AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: DaveReid on February 03, 2010, 09:36:50 AM

Title: Database update info
Post by: DaveReid on February 03, 2010, 09:36:50 AM
Logged over southern UK earlier today:

Mode S: AD794E
Reg: N96757
Type: Gulfstream Aerospace G-1159A (Gulfstream III)
MSN: 379

Currently populates as Type: Taylorcraft Bc-12D; MSN: 9057

MTIA
Dave
Title: Re: Database update info
Post by: AirNav Development on February 03, 2010, 01:00:38 PM
What can be done to avoid these problems? Any suggestions? What is the most accurate aircraft information external database we can rely on?
Title: Re: Database update info
Post by: Allocator on February 03, 2010, 01:11:19 PM
GAS has the old date, airframes.org has the updated data in addition to the old details.

The date of the new registration is 2009-10-19 so I guess that GAS is lagging behind.  Even so, the old details won't be overwritten in the RB database even when GAS is updated.

Best bet Dave is to submit the change of details to the GAS website as a start?
Title: Re: Database update info
Post by: tarbat on February 03, 2010, 01:17:41 PM
Yes, GAS is one of the best sources, but it does rely on people (like Dave) submitting updates to keep it up-to-date ;)

I keep GAS's lookup program ( http://www.gatwickaviationsociety.org.uk/sbs_populatebeta.asp ) open on my desktop all day, just so that I can do quick checks.

(http://farm5.static.flickr.com/4053/4327878072_e5280b78e4_t.jpg) (http://www.flickr.com/photos/tarbat/4327878072/sizes/o/)
Title: Re: Database update info
Post by: AirNav Development on February 03, 2010, 01:22:04 PM
The problem is that we already get this data from GAS, automatically.
What is the GAS sources are wrong? Alternatives?
Title: Re: Database update info
Post by: tarbat on February 03, 2010, 01:45:15 PM
I would say http://www.airframes.org/ is one of the best, if only you could get agreement from them to use their database.

The example DaveReid gives is up-to-date on http://www.airframes.org/

(http://farm5.static.flickr.com/4035/4327918510_808cf50302.jpg) (http://www.flickr.com/photos/tarbat/4327918510/sizes/o/)
Title: Re: Database update info
Post by: Allocator on February 03, 2010, 01:55:38 PM
airframes.org bans the use of 'bots' for lookups, so an agreement would definitely be needed.

--------------------------

No bots, please ...

No bots, spiders, scrapers, scripted or otherwise automated queries, please.

As an exception, bots are tolerated only as long as they respect the robots.txt standard and if their purpose is to index this site to be included in a public search engine. And that is just a handfull like Google, MSN, Yahoo, etc.

Spidering this site violating this rule by sending private harvesting bots or otherwise sending automated queries is considered abuse. Violating bots will be blocked and/or publicly listed.

Title: Re: Database update info
Post by: AirNav Support on February 03, 2010, 01:58:20 PM
We believe we did contact airframes.org on a few occasions before but didn't actually get a reply. Development can confim.
Title: Re: Database update info
Post by: AirNav Development on February 03, 2010, 02:33:06 PM
That is totally correct. We've sent several email to airframes.org but we didn't a single reply from them. We would be interested in feeding our server with their aircraft data. Does anyone have their private email contact? Please send us a PM if that is the case.
Title: Re: Database update info
Post by: DaveReid on February 03, 2010, 04:37:58 PM
What can be done to avoid these problems? Any suggestions? What is the most accurate aircraft information external database we can rely on?

www.aircraftId.com is used by organisations like Eurocontrol and EASA to validate and clean their in-house aircraft databases, why not go and talk to them ?
Title: Re: Database update info
Post by: tarbat on February 03, 2010, 05:01:19 PM
www.aircraftId.com is used by organisations like Eurocontrol and EASA to validate and clean their in-house aircraft databases, why not go and talk to them ?

You mean, talk to you Dave!!  I think we all know your agenda, just give it a rest for a while.

Domain name: AIRCRAFTID.COM
Administrative Contact:
Reid  Dave  [email protected]
PO Box 149
Reading  Berks RG6 5FQ
UK

Domain name: FLIGHTROUTELOOKUP.COM
Administrative Contact:
Reid  Dave  [email protected]
PO Box 149
Reading  Berks RG6 5FQ
UK
Title: Re: Database update info
Post by: Fenris on February 03, 2010, 05:23:11 PM
Agenda or no agenda, we'd all be happier with accurate database contents...
Title: Re: Database update info
Post by: DaveReid on February 03, 2010, 05:24:37 PM
Nope - it was a simple statement of fact, in response to a direct question by AirNav which solely asked about accuracy.

What AirNav presumably meant to ask was:

What is the most accurate aircraft information external database we can rely on other than those run by people and organisations we don't like ?

I have no idea what the answer to that question is !
Title: Re: Database update info
Post by: Fenris on February 03, 2010, 05:27:34 PM
Answers to questions like that tend to zero.

I remember at a previous company I worked for when the MD had just heard that another similar company in the industry had gone bust saying " Who is there left to hate now?"

Title: Re: Database update info
Post by: tarbat on February 03, 2010, 05:39:32 PM
Really Dave.  Airnav asked "what is the most accurate aircraft information external database", and you replied www.aircraftId.com.  But conveniently failed to mention that you are the CEO of AvGen, who operate the www.aircraftId.com service.

I guess you would say its the most accurate!!
Title: Re: Database update info
Post by: radarspotter10 on February 03, 2010, 05:53:01 PM
hi.
I vote for airframes.org great site.
http://www.airframes.org/ i

from pat
Title: Re: Database update info
Post by: DaveReid on February 03, 2010, 05:55:13 PM
I guess you would say its the most accurate!!

No, I wouldn't dream of saying that, and didn't. 

Far better for AirNav to go and ask organisations who have been faced with the same requirements and who have made a free choice in the open market.

I'm surprised AirNav didn't think of that for themselves :-)
Title: Re: Database update info
Post by: Horsham Spotter on February 03, 2010, 06:07:59 PM
hi.
I vote for airframes.org great site.
http://www.airframes.org/ i

from pat
I Second that Pat. Not only is it a great database which people who use it know, you can sometimes view a picture and flight route data of searched aircraft.
airframes.org for me.
Steve.
Title: Re: Database update info
Post by: anorak on February 03, 2010, 08:04:00 PM
Are there any toys left in the pram?
Title: Re: Database update info
Post by: AirNav Development on February 03, 2010, 08:14:05 PM
We have sent 2 more emails to airframes.org
We hope they reply this time. We are really interesting in solving this problem ASAP.
Title: Re: Database update info
Post by: ACW367 on February 03, 2010, 09:08:47 PM
What can be done to avoid these problems? Any suggestions? What is the most accurate aircraft information external database we can rely on?

The short answer is there is no central external database.  Probably the most accurate one currently out there is the Libhomeradar one maintained by Kai-Jens Meyer.  This is the database which is used to Parser the Yahoo Group.  That Yahoo mode S group with its search facility is the best to update new tie-ups as many of the people who report them to the group have access to official information like FlightPlans or ACARS.

The biggest problem is database deletions.  There is no way even with Airframes.org or Libhomeradar for them to keep up to date with aircraft de-registration, return to lessors, PWFU or scrappage.  There is also no real way anywhere on the web to trace GA aircraft of those countries that do not publish national registers.

As a user to keep my data as up to date as I can (especially in regard to deletions), I cross refer 15-20 different websites. The four or five mentioned above, airliner and Bizjet news websites and production lists, online national aircraft registers, spotters logs (especially of the boneyards) etc. I put a whole stack of links on the useful website list thread.

Most of the data gathering on world aircraft (GAS, Airframes, Libhomeradar) is either carried out by hobbyists in their spare time and using user contributions, or web design/consultant types who earn their money from the consultancy and run the databases as an aside. The logos/flags DAT/silhouettes are also being provided by a few dedicated forum volunteers, whose services are not guaranteed (as seen this week with the departure of Ian K).

You guys are absolutely fantastic at the technical inovation and you have a spectacular product with great innovation and future growth potential.  

What I would love to see you bring 'in house', is the database administration side, to become a world leader in the mode S tie-up game.  You have the web resources to build a great server and user fed database for look-ups similar to what GAS and Airframes provide.  

I know you are a relatively small company. But in future I would like to see you bring in a few full time librarian/staty types to analyse the information from your servers. They could cross refer them to the many available open source web information.  They could build up a network of your professional contacts to provide accurate inside information from those with access to official sources. This would then provide the definitive world leading source data, owned in house by Airnav.

We as users could then be presented with regular little .exe file upates for our NavData, that not only update our Navdata with new tie-ups, but also strips out the old de-registered ones.  

Not trying to put people like Rod Bearden out of a 'job' but your new stat team could also create and monitor the logos (I recently stripped out over 300 of them belonging to defunct airlines), flags, silhouettes, airport outlines etc.  

You could even create versions of the .exe that would work with the basestation format for a modest fee.  Wouldn't it be great if in future, SBS users came to the Airnav website to get the up to date information and add-on files and look-up information they need.

Go on Airnav get into the data upkeep business.

:-)
Title: Re: Database update info
Post by: DaveReid on February 03, 2010, 10:13:45 PM
Logged over southern UK this afternoon:

Mode S: 43C23F
Reg: ZR323
Type: Agusta 109E Power
MSN: 11665

Currently populates as Type: Westland WAH-64D Longbow Apache AH1; MSN: DU005/WAH005

MTIA
Dave
Title: Re: Database update info
Post by: Jeremy on February 04, 2010, 12:07:20 AM
And who is going to pay for all these new employees??
J.
Title: Re: Database update info
Post by: AirNav Development on February 04, 2010, 12:20:45 AM
Dave: you don't need to keep posting one or another database errors. We all know you want to sell your company's services already. :-)
Title: Re: Database update info
Post by: DaveReid on February 04, 2010, 07:50:22 AM
Dave: you don't need to keep posting one or another database errors. We all know you want to sell your company's services already. :-)

Sorry, run that one by me again, please !

Read the title of this thread - are you now saying that now you don't even want free-of-charge, gratis, no-strings-attached data that you can use to update your database and thereby ensure that your thousands of sharers see a correct aircraft on their screens instead of a wrong one ?

I'd have thought that was what our American friends call a no-brainer.

And equally we both know that there will be many AirNav users reading this who are happy to use such posted information to update their local databases even if you don't want to apply the corrections to the server purely because of where they have come from - which is, frankly, pathetic.

Feel free to use the information or ignore it, that's your choice.  There isn't going to be a bill in the post :-)
Title: Re: Database update info
Post by: DaveReid on February 04, 2010, 09:43:41 AM
Logged over southern UK a couple of hours ago:

Mode S: A31FF6
Reg: N300GP
Type: Bombardier BD-100 Challenger 300
ICAO: CL30
MSN: 20253

Currently populates as Type: (none); MSN: (none)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: tarbat on February 04, 2010, 10:05:24 AM
Dave, I guess it would help to know your source of information.  Is this based on visual sightings, or something else.  Just trying to assess the accuracy and reliability of the data, that's all.
http://www.airframes.org/reg/n300gp
Title: Re: Database update info
Post by: radarspotter10 on February 04, 2010, 11:00:42 AM
Dave: you don't need to keep posting one or another database errors. We all know you want to sell your company's services already. :-)

Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat
Title: Re: Database update info
Post by: Runway 31 on February 04, 2010, 11:01:34 AM
http://www.pictaero.com/en/pictures/picture,71830

Picture of N300GP taken 30/1/2010
Title: Re: Database update info
Post by: jannuh on February 04, 2010, 11:20:13 AM
Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat
Speak for yourself Radarspotter10, I'd like to have my own opinion, don't need yours!
Thank You!
Title: Re: Database update info
Post by: radarspotter10 on February 04, 2010, 11:27:57 AM
Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat
Speak for yourself Radarspotter10, I'd like to have my own opinion, don't need yours!
Thank You!

hi jannuh
And your entitled to your opinion my man. just the same as me.
from pat
Title: Re: Database update info
Post by: DaveReid on February 04, 2010, 12:19:03 PM
Dave, I guess it would help to know your source of information.  Is this based on visual sightings, or something else.  Just trying to assess the accuracy and reliability of the data, that's all.
http://www.airframes.org/reg/n300gp

Gladly.

http://registry.faa.gov/aircraftinquiry/NNum_Results.aspx?NNumbertxt=N300GP

Edit:  now also showing on airframes.org (it wasn't earlier today): www.airframes.org/reg/n300gp although still nothing listed on GAS
Title: Re: Database update info
Post by: tarbat on February 04, 2010, 01:05:01 PM
Thanks for the explanation Dave.
Title: Re: Database update info
Post by: viking9 on February 04, 2010, 03:03:06 PM

Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat


Pat,

I've kept quiet so far but I have to tell you, from one Irishman to another, that your inane remarks are not doing much to help the myth in this country that Irishmen are thick.

Though he is too modest to admit it himself, I can tell you that Dave Reid is a well respected professional in the aviation world, with a vast amount of knowledge and experience. We need people like him to contribute to these forums so that people like you, and even I, can learn something.

Your unconditional support of AirNav and readiness to slag off anyone who criticises them is quite baffling to me. I can tell you that the founder of radarspotters.eu established that forum because members of this forum were being banned for criticising AirNav's attitude to customers. Incidentally, I was the first member of the radarspotters forum, having had a warning that I would be banned from this one should I criticise AirNav.

So, Pat, I think you should do all Irishmen living in the UK a favour and curb your intemperate remarks and try to learn something from those qualified and experienced contributors to this forum instead of berating them.

Oh! and would you please correct the typo in your signature line or remove it altogether.

Tom



Title: Re: Database update info
Post by: Tramline on February 04, 2010, 03:49:28 PM

Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat


Pat,

I've kept quiet so far but I have to tell you, from one Irishman to another, that your inane remarks are not doing much to help the myth in this country that Irishmen are thick.

Though he is too modest to admit it himself, I can tell you that Dave Reid is a well respected professional in the aviation world, with a vast amount of knowledge and experience. We need people like him to contribute to these forums so that people like you, and even I, can learn something.

Your unconditional support of AirNav and readiness to slag off anyone who criticises them is quite baffling to me. I can tell you that the founder of radarspotters.eu established that forum because members of this forum were being banned for criticising AirNav's attitude to customers. Incidentally, I was the first member of the radarspotters forum, having had a warning that I would be banned from this one should I criticise AirNav.

So, Pat, I think you should do all Irishmen living in the UK a favour and curb your intemperate remarks and try to learn something from those qualified and experienced contributors to this forum instead of berating them.

Oh! and would you please correct the typo in your signature line or remove it altogether.

Tom

Well said.
Title: Re: Database update info
Post by: Horsham Spotter on February 04, 2010, 03:54:27 PM
Any more news on the Database update info ?
Steve.
Title: Re: Database update info
Post by: AirNav Development on February 04, 2010, 04:31:56 PM
We are waiting for a few answers we sent to some companies to arrive.
Title: Re: Database update info
Post by: Horsham Spotter on February 04, 2010, 04:44:32 PM
Thank you AirNav.
Hope you get a good responce.
Steve.
Title: Re: Database update info
Post by: eggplant on February 04, 2010, 09:48:53 PM

Hi all.
We all know Dave the Rave by now, I think people on this site are getting very tired of his selling pitch,  its becoming boring and monotonous, any business man knows not to discuss business in a public forum, send airnav a email and give us all a break Dave.
from pat


Pat,

I've kept quiet so far but I have to tell you, from one Irishman to another, that your inane remarks are not doing much to help the myth in this country that Irishmen are thick.

Though he is too modest to admit it himself, I can tell you that Dave Reid is a well respected professional in the aviation world, with a vast amount of knowledge and experience. We need people like him to contribute to these forums so that people like you, and even I, can learn something.

Your unconditional support of AirNav and readiness to slag off anyone who criticises them is quite baffling to me. I can tell you that the founder of radarspotters.eu established that forum because members of this forum were being banned for criticising AirNav's attitude to customers. Incidentally, I was the first member of the radarspotters forum, having had a warning that I would be banned from this one should I criticise AirNav.

So, Pat, I think you should do all Irishmen living in the UK a favour and curb your intemperate remarks and try to learn something from those qualified and experienced contributors to this forum instead of berating them.

Oh! and would you please correct the typo in your signature line or remove it altogether.

Tom

Well said.

Thought I'd throw my two penneth worth in !

I do not know (nor do I wish to know) what politics may exist between Airnav and Dave Reid, but I have found his posts helpful and useful.
Title: Re: Database update info
Post by: AirNav Support on February 04, 2010, 11:44:35 PM
Keep the infighting away please.

We do respect DaveReid however his system if used by us would mean we have to pass the cost back to the customers. It something we cannot absorb, hence why it hasn't been taken on. We won't disclose the exact details but passing the cost back to the customers is not something we want to do.
Title: Re: Database update info
Post by: viking9 on February 05, 2010, 07:27:09 AM
AirNav,

No infighting here. Merely doing the job of a moderator, which you should be doing, and trying to keep some order so people can get some value out of the debate.

radarspotter10's reply was as expected - still nothing to add to the thread but crass comments.


Title: Re: Database update info
Post by: DaveReid on February 05, 2010, 07:47:04 AM
We do respect DaveReid however his system if used by us would mean we have to pass the cost back to the customers. It something we cannot absorb, hence why it hasn't been taken on. We won't disclose the exact details but passing the cost back to the customers is not something we want to do.

That's strange - I've had an email from Andre, your CEO, specifically requesting that we keep any proposal discussions confidential and not make any comment on them in this forum, yet here you are doing the exact opposite.  I'd suggest you go and talk to your boss before saying any more.

So I won't respond here other than to observe that there are many thousands of RadarBox users, all of whom (unless they have disabled the download of aircraft details/photos) stand to gain from a reliable database and a more intelligent photo link to airliners.net, so you will no doubt be evaluating any proposals in terms of the cost and VFM spread across those thousands of users.

Let's continue this discussion offline, as Andre has requested.
Title: Re: Database update info
Post by: Jeremy on February 05, 2010, 10:15:30 AM
Oh what a shame. I was enjoying this one!
J.
Title: Re: Database update info
Post by: DaveReid on February 05, 2010, 02:53:35 PM
(to revert to the original scope of this thread)

Currently (1452UTC) outbound from LHR as CSA651:

Mode S: 49D063
Reg: OK-MEH
Type: Airbus A320-214
ICAO: A320
MSN: 3031

Currently populates as Type: Tupolev Tu-154M; MSN: 88A789; Reg: OK-TCC

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: tarbat on February 05, 2010, 03:10:41 PM
Currently (1452UTC) outbound from LHR as CSA651:

Also confirmed on airframes.org - http://www.airframes.org/reg/okmeh
Title: Re: Database update info
Post by: DaveReid on February 05, 2010, 06:23:22 PM
Currently on the network:

Mode S: 3C4858
Reg: D-ABBX
Type: Boeing 737-808
ICAO: B738
MSN: 34969

Currently populates as ICAO: B768

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Horsham Spotter on February 07, 2010, 07:51:25 PM
Good evening all.
Has any one used ADU software and does it work with RB.
Steve
Title: Re: Database update info
Post by: Marpleman on February 07, 2010, 09:08:14 PM
Good evening all.
Has any one used ADU software and does it work with RB.
Steve

Hi Steve

I'm 99% certain it does not work with RadarBox, given the conversations I've had with fellow spotters at Manchester

I'm a long time user of Aerodata which I suppose is a main competitor of ADU, which has a link available direct into the RadarBox data files to give almost seemless spotting!

I'm sure there must be someone out there who can confirm this?

Regards

Rich
Title: Re: Database update info
Post by: Horsham Spotter on February 08, 2010, 05:12:56 AM


[/quote]

Hi Steve

I'm 99% certain it does not work with RadarBox, given the conversations I've had with fellow spotters at Manchester

I'm a long time user of Aerodata which I suppose is a main competitor of ADU, which has a link available direct into the RadarBox data files to give almost seemless spotting!

I'm sure there must be someone out there who can confirm this?

Regards

Rich
[/quote]

Thank You Rich.
Just looked at the Aerodata site and it seem's to operate with RB with it's RB analyiser.Think I will give them a call after work Today to confirm a few thing's.
Steve.
Title: Re: Database update info
Post by: DaveReid on February 08, 2010, 07:24:52 AM
I'm 99% certain it does not work with RadarBox, given the conversations I've had with fellow spotters at Manchester

From the ADU website:

ADU Software SBS Utility

Who is it for? – ADU users who have a Kinetic BaseStation and would like to populate SBS information.

What does it do? -  Populates information into the SBS SQB file which then generates information to display on the radar screen.

What information? – Registrations, Aircraft Types, ICAO type codes, Construction numbers, Manufacturer,  Operators, Operator Flag Codes, Aircraft personal sightings & Interested Reference to aircraft required. Frame and Reg required notification.

That falls into the category, discussed elsewhere, of SBS add-ons that don't work with RadarBox;  I can't see RB mentioned at all on the ADU website, unless it's buried away somewhere that I've missed.

HTH
Dave
Title: Re: Database update info
Post by: AirNav Development on February 08, 2010, 12:37:35 PM
Does anyone here have any experience in using ADU software? Is it reliable with accurate information?
Title: Re: Database update info
Post by: Horsham Spotter on February 08, 2010, 04:44:50 PM
I have been using ADU for a few years now and think its great! I update mine several times per month via the web whenever I'm notified byADU an update is available.
I find it particularly handy when I use my RadarBox abroad (AMS, MAD etc) with my Laptop and internet access is difficult/ expensive. I copy and paste the ModeS code into the search box and Hey-Presto, the answer is usually there unless it is a very recent change/allocation.
rgds
Terry

Hello Terry.
I have emailed ADU Today asking if it work's with RB. Waiting for their responce. I take it that it does as per your last post. And you sound like your happy with it.
Steve.
Title: Re: Database update info
Post by: Horsham Spotter on February 08, 2010, 04:53:14 PM
Terry
Forgot to ask but which option did you download that works with RB.
Steve.
Title: Re: Database update info
Post by: DaveReid on February 08, 2010, 06:12:19 PM
Terry
Forgot to ask but which option did you download that works with RB.
Steve.

I don't think Terry was suggesting that ADU was actually integrated with RadarBox:

I copy and paste the ModeS code into the search box

You can copy-and-paste from practically any Windows application to another, I think we were hoping for a bit more in the way of interoperability here ...
Title: Re: Database update info
Post by: Horsham Spotter on February 08, 2010, 06:24:49 PM
AirNav & All
I have had an email from ADU and it seems that it work's as a (stand alone program that work's along side AirNav and they are currently testing a Airnav utility in order to populate personal sightings and mode s information where you will not have to rely on the internet to make a good connection - this will be a good utility for mobile and home use).
Price is not bad either. I'am going to purchase the V12 product this week and will let you know how I get on.
Happy radar boxing all.
Steve.

Title: Re: Database update info
Post by: Marpleman on February 08, 2010, 08:36:45 PM

[/quote]

Thank You Rich.
Just looked at the Aerodata site and it seem's to operate with RB with it's RB analyiser.Think I will give them a call after work Today to confirm a few thing's.
Steve.
[/quote]

Hi Steve

sorry - I didn't make my response too clear!

Aerodata has a "RadarBox analyser" file which reads direct from "My flights" file within the AirNav folder

Basically it identifies aircraft that you haven't see before and allows you to directly log them within the Aerodata DB

There are of course a variety of set up options depending on the users requirements.

Aerodata have in the past developed a free download of ADS-B and Hex codes complete with reg/type/cn etc etc for use with SBS, but given the Analyser links the database with the Radar Box,I hardly ever get any unknowns showing up on the analyser screen (which incidentally sits nicely on top of the radar box creen)

Their database appears to be similarly updated as the ADU one is, several times a week, and currently has over 1.5 million frames detailed on it - admittedly not all of use to RadarBox, but it's pretty damn comprehensive, maintained by several dedicated editors.

hope this helps

Regards

Rich
Title: Re: Database update info
Post by: mjleprix on February 09, 2010, 08:33:52 AM
Hi Airnav
I have used adu now for two years, have always found their data as up to date as any, certainly as good if not better than airframes and if it has to have any credance at all, every aircraft put up by Dave this week has been up to date in the ADU database. I do know that ADU are working on a linkup to Radarbox in some form. So they have my vote.
Thanks
Mike P
Title: Re: Database update info
Post by: DaveReid on February 09, 2010, 09:12:58 AM
every aircraft put up by Dave this week has been up to date in the ADU database

Thanks for the confirmation.  They are now on airframes.org too (although they weren't all at the time I posted them), but not all yet on GAS.
Title: Re: Database update info
Post by: perezoso on February 09, 2010, 02:40:03 PM
And now for something completely different (isn't this what the thread was supposed to be for?):

COA52 populates as SAEZ-KIAH; but is in fact KIAH-KLAX.  
COA53 populates as KEWR-LLBG; but is in fact KLAX-KIAH-SAEZ

These have apparently been 739ERs with full ADS-B for the past few days (at least the domestic segment of COA53).  Looks to me like Continental's new 739ER's and the (presumably new) 738's have ADS-B, although I'm sure somebody here knows more. Gives me more to track, especially once I have a real antenna. :-)
Title: Re: Database update info
Post by: DaveReid on February 09, 2010, 10:38:03 PM
Currently on the network:

Mode S: 4013AF
Reg: G-OZBT
Type: Airbus A321-231
ICAO: A321
MSN: 3546

Currently populates as Registration: G-TTIH

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: rnsavage on February 10, 2010, 08:13:27 PM
Thought I would add some comments to this post.

Firstly, one of the limitations of the current design of AirNav RB once the database is populated with an aircraft details, and they were wrong or then updated (i.e. American's reuse the same reg, which will have the same ModeS code), your RB will bring up the wrong details - which I think is the crux of this post. I know if you post your log to the Mode S group, they will check your details are correct.

What would be a nice addition to the RB product, would be if you could do something similar from the Reporter application (i.e. create a CSV report, that could be then checked via an online source, your data was correct). That way, you would benefit from any data updates that were provided online. This would always depend on a bulk checking option from an online source (note this is not the same as using the populate option in the reporter application, which checks your local database, or if not in, checks online).

Re: ADU. I know the guys very well who do ADU, and the database design (as I originally wrote the product that came before this product (Registration Details), and ADU starting point was my design. The data in this product is excellent with a very good data team in place, and I am sure if Steve is writing something to interface with RB, it will complement it.

I also like a comment in another post, in AirNav having an online source of data. It would be interesting option to put a poll on, to see if people were willing to pay X amount a month for this; or, speaking to the likes of ADU to offer a similar service. When I was doing my database application, one of my thoughts would of been an online application rather than a standalone (as then you don't have to worry about downloading updates!).

Rick





Title: Re: Database update info
Post by: DaveReid on February 10, 2010, 09:57:02 PM
Firstly, one of the limitations of the current design of AirNav RB once the database is populated with an aircraft details, and they were wrong or then updated (i.e. American's reuse the same reg, which will have the same ModeS code), your RB will bring up the wrong details - which I think is the crux of this post.

I think you have hit the nail on the head.

Designing a database schema to cope with the different ways that various countries handle the relationship between airframes, registrations and ICAO24 codes is a far from trivial exercise.  While a flat-file format is just about OK for exporting an instantaneous snapshot of the data, you can't possibly expect to be able to model the way the world works and maintain data effectively without a proper relational, multi-table schema.  That's the mistake that, perhaps understandably, both Kinetic and AirNav made when they fixed the format of the databases that they ship with their respective products.

Using the ICAO24 as a unique PK is a no-no, that can't cope either with what happens in the US where, as you rightly say, codes stay with registrations and can move from one aircraft to another, or with what countries like the UK do, where a code stays with the airframe even if it's re-registered.  And that's before you start to consider issues like on-off miscodes.

I've yet to see a schema that can handle all these scenarios that doesn't contain at least 6 (ideally 7) tables to model the various interrelationships between airframes, registrations and ICAO24 codes.

(http://www.civilaircraftregisters.org/Mode_S_Resources/AIDA.gif)
Title: Re: Database update info
Post by: DaveReid on March 05, 2010, 09:48:10 AM
No sign yet of the promised developments on this front (presumably 3D distractions).

In the meantime, for anyone who is maintaining their own NavData.db3, here's one that popped up in this morning's network log:

Mode S: 738045
Reg: 4X-ELE
Type: Boeing 747-412
ICAO: B744
MSN: 26551

Currently populates as Registration: 4X-ELS (which went to Cathay Pacific as B-HKT in 2007)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 06, 2010, 12:28:00 PM
On the network this morning:

Mode S: C04081
Reg: C-FYLC
Type: Boeing 737-8BK2
ICAO: B738
MSN: 33029

Currently populates as ICAO: A343 (with A340-300 silhouette)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 07, 2010, 11:01:38 AM
Currently on the network:

Mode S: 393A6E
Reg: F-GOTO
Type: Airbus A330-323X
ICAO: A333
MSN: 1021

Currently populates as ICAO: F172 (no silhouette)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: MIKE.UTD on March 07, 2010, 07:53:46 PM
Hi,
I use Aerodata as my database which is very accurate and updated weekly. A few mates who went to the Florida area in Feb used the other machine with this database and was very accurate. Give Paul Turnbull a bell to see if a deal can be done.
If I remember it is free to download and updated monthly.
Title: Re: Database update info
Post by: Marpleman on March 07, 2010, 08:20:42 PM
Hi,
I use Aerodata as my database which is very accurate and updated weekly. A few mates who went to the Florida area in Feb used the other machine with this database and was very accurate. Give Paul Turnbull a bell to see if a deal can be done.
If I remember it is free to download and updated monthly.


Hi Mike

Likewise - i've used Aerodata for the past 7-8 years,and can't speak more highly of it.

Do you use the RB analyser with yours also?

Rich
Title: Re: Database update info
Post by: DaveReid on March 08, 2010, 08:27:58 AM
On the network yesterday:

Mode S: 342553
Reg: EC-KCP
Type: Airbus A330-343X
ICAO: A333
MSN: 833

Currently populates as Reg: F-WWKO;  Type: Airbus A330-302;  MSN: 994

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: mjleprix on March 08, 2010, 09:46:53 AM
As far as data bases goes ,I have used both Aerodate and ADU over a number of years and,whilst the data supplied is equally first class, I have a personal preference for ADU. I find the layout and presentation of the data better and the reports available getting better every year. Another consideration is that it is cheaper ,representing, to me ,better value. But each I repeat have their merits.
What we all most definately need is a better database for Airnav, and I'm happy that they are working to that end.
Mike P
Title: Re: Database update info
Post by: DaveReid on March 08, 2010, 06:16:15 PM
Currently on the network:

Mode S: 8961F5
Reg: A6-ABN
Type: Airbus A320-214
ICAO: A320
MSN: 3152

Currently populates as Registration A6-ABM;  Type: British Aerospace BAe-748 Srs2B/426;  MSN: 1799

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Pinza on March 08, 2010, 10:47:10 PM
Mode S: 4CA810

Appears to be a new Ryanair delivery B738 (35028/3199)

On Dublin to Stansted tonight and not LX-ARC as reported.

LX-ARC also reported by Mode-S 4D02C3 - interesting - but must a-bed!
Title: Re: Database update info
Post by: DaveReid on March 08, 2010, 11:05:22 PM
Mode S: 4CA810

Appears to be a new Ryanair delivery B738 (35028/3199)

On Dublin to Stansted tonight and not LX-ARC as reported.

LX-ARC also reported by Mode-S 4D02C3 - interesting - but must a-bed!

EI-EKP
Title: Re: Database update info
Post by: ACW367 on March 09, 2010, 01:08:45 AM
I agree that Aerodata does have a good database for Mode S to Registration tie-ups.  It is also relatively quick in removing aircraft that have been WFU or reregistered.

Unfortunately Aerodata does not always use ICAO codes which we have all campaigned for.  Search the data for F10A, H25X, B73B and many more. So in my opinion it would need manual work before being uploaded to the Navdata to correct these many ICAO code anomolies. 

Airnav have always stated they want a fully automated process and therefore I don't think they will go for this.
Title: Re: Database update info
Post by: DaveReid on March 09, 2010, 07:57:53 AM
I agree that Aerodata does have a good database for Mode S to Registration tie-ups.  It is also relatively quick in removing aircraft that have been WFU or reregistered.

Unfortunately Aerodata does not always use ICAO codes which we have all campaigned for.  Search the data for F10A, H25X, B73B and many more. So in my opinion it would need manual work before being uploaded to the Navdata to correct these many ICAO code anomolies. 

Airnav have always stated they want a fully automated process and therefore I don't think they will go for this.

Absolutely correct, use of standard ICAO type designators should be a no-brainer for any database that wants to be taken seriously.

Equally desirable IMHO are standardised type descriptors - there is no excuse for this kind of mess (from the NavData.db3 that comes with RadarBox 3D):

Canadair CL-600-2B16 Challenger 604
Canadair CL600-2B16 (604)
Canadair CL604
Canadair CL604 Challenger

For some good background reading about how the industry is tackling this issue (but equally applicable to enthusiast databases), visit www.intlaviationstandards.org/Documents/CICTTStandardBriefing.pdf
Title: Re: Database update info
Post by: ACW367 on March 09, 2010, 04:03:04 PM

Absolutely correct, use of standard ICAO type designators should be a no-brainer for any database that wants to be taken seriously.

Equally desirable IMHO are standardised type descriptors - there is no excuse for this kind of mess (from the NavData.db3 that comes with RadarBox 3D):

Canadair CL-600-2B16 Challenger 604
Canadair CL600-2B16 (604)
Canadair CL604
Canadair CL604 Challenger


Dave

To be fair that info is mostly populated from Airliners.net.  Maybe you should press on their forums that they standardise the attributions that users have available to add when they upload photos to that site.

Regards
ACW367
Title: Re: Database update info
Post by: DaveReid on March 09, 2010, 05:59:14 PM
To be fair that info is mostly populated from Airliners.net.  Maybe you should press on their forums that they standardise the attributions that users have available to add when they upload photos to that site.

That's true, but then Airliners.net is free, so they get to make their own rules (and then ignore them) if they so desire.

I know AirNav are (or at least were) looking at sources that come with at least some guarantees of consistency.

It all seems to have gone a bit quiet, though, amid all the excitement over 3D.
Title: Re: Database update info
Post by: DaveReid on March 09, 2010, 09:07:00 PM
Currently on the network:

Mode S: AE01D5
Reg: 64-14849
Type: Boeing RC-135U Combat Sent
ICAO: R135
MSN: 18789

Currently populates as ICAO: K35R

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 11, 2010, 08:29:07 AM
Currently on the network:

Mode S: 393CCB
Reg: F-GPGL
Type: Dassault Falcon 100
ICAO: FA10
MSN: 203

Currently populates as ICAO: F10A

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: eggplant on March 13, 2010, 10:08:07 PM
A couple of questions I'm sure our learned experts/AirNav will be able to answer :-

1. When I view the MyLog data from the menubar and update/correct info on this screen will this new data automatically be transferred to the Navdata.db3 file - or do I need to use database explorer to make it permanent ?

2. If I check the "auto populate aircraft data" on the preferences dialogue will my manually updated info (entered as Q1) be overwritten by potentially old data from the AN server ?

Thanks
Title: Re: Database update info
Post by: RodBearden on March 13, 2010, 10:21:39 PM
Hi eggplant

Q1 - MyLog gets its data from NavData, not the other way round, so any changes that you make to MyLog only apply there. You need to update NavData separately, then updates you make there will be applied in the future to new records in Mylog - hope that makes sense!

Q2 - potentially, yes, as it might well be when RadarBox auto-populates from the AirNav server. This is a part of the problems that we hope AirNav will be looking at when they update the whole issue of the Database.

Rod
Title: Re: Database update info
Post by: eggplant on March 13, 2010, 10:23:24 PM
Hi eggplant

Q1 - MyLog gets its data from NavData, not the other way round, so any changes that you make to MyLog only apply there. You need to update NavData separately, then updates you make there will be applied in the future to new records in Mylog - hope that makes sense!

Q2 - potentially, yes, as it might well be when RadarBox auto-populates from the AirNav server. This is a part of the problems that we hope AirNav will be looking at when they update the whole issue of the Database.

Rod

Understood completely. Thanks for your answers.

John
Title: Re: Database update info
Post by: DaveReid on March 14, 2010, 12:37:46 AM
Currently on the network:

Mode S: A00C4A
Reg: N102BQ
Type: Gulfstream IVSP
ICAO: GLF4
MSN: 1273

Currently populates as ICAO: FA5X

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 15, 2010, 09:27:31 AM
Currently on the network:

Mode S: 3C48C2
Reg: D-ABFB
Type: Airbus A320-214
ICAO: A320
MSN: 4128

Currently populates as Type: Boeing 737-230/Adv;  ICAO: B732 (de-regd 1997)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 15, 2010, 09:26:22 PM
On the network this afternoon:

Mode S: 7803B6
Reg: B-5401
Type: Boeing 737-87L
ICAO: B738
MSN: 35530

Currently populates as Type: Gulfstream Aerospace G-IV;  Registration B-3999;  ICAO: GLF4 (re-regd 2007)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: btclarke on March 16, 2010, 07:21:37 PM
Picked up an anomaly today...

Mode S: 49D0A3
Reg: OK-XGC
Type: Boeing 737-55S
ICAO: B735
C/N: 26541
L/N: 2319

System says it's a F172K rego OK-TEC, no mode S.
Title: Re: Database update info
Post by: DaveReid on March 17, 2010, 04:52:19 PM
Currently on the network:

Mode S: A7C80B
Reg: N600JD
Type: Gulfstream V
ICAO: GLF5
MSN: 640

Currently populates as ICAO: C650

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 19, 2010, 02:39:06 PM
On the network this morning:

Mode S: 3C6442
Reg: D-AIBB
Type: Airbus A319-112
ICAO: A319
MSN: 4182

Currently populates as ICAO: A300;  Type: Airbus-A300B4-2C;  MSN: 057 (de-regd 1988, scrapped 2000)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 26, 2010, 11:13:00 AM
Currently on the network:

Mode S: 02A2A7
Reg: TS-INN
Type: Airbus A320-212
ICAO: A320
MSN: 793

Currently populates as Reg: TS-ING;  Type: Airbus A320-211;  MSN: 140

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 26, 2010, 04:56:47 PM
On the network now:

Mode S: 3C11A1
Reg: D-AVRO
Type: British Aerospace 146-RJ85
ICAO: RJ85
MSN: E2246

Currently populates as ICAO: B462

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 28, 2010, 04:15:05 PM
Currently on the network:

Mode S: 30013F
Reg: I-FLYW
Type: Dassault Falcon 900EX
ICAO: F900
MSN: 27

Currently populates as ICAO: F9EX (non-ICAO)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 29, 2010, 08:27:00 AM
Currently on the network:

Mode S: 4006EE
Reg: G-TOYM
Type: Boeing 737-36Q
ICAO: B733
MSN: 29141

Currently populates as Reg: G-OHAJ (de-regd 2005)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 30, 2010, 08:32:11 AM
Currently on the network:

Mode S: 7500DC
Reg: 9M-AHD
Type: Airbus A320-216
ICAO: A320
MSN: 3291

Currently populates as Reg: 9M-TGK;  Type: Boeing 727-247/Adv(F);  ICAO: B722;  MSN: 21392/1305 (de-regd 2007)  

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 30, 2010, 09:11:34 PM
Currently on the network:

Mode S: C01D82
Reg: C-FLEN
Type: Boeing 737-4K5
ICAO: B734
MSN: 24769

Currently populates as Type: Beech 95 Travel Air;  ICAO: CL30;  MSN: TD-131 (confused? I know I am!)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on March 31, 2010, 04:31:28 PM
On the network today:

Mode S: A07A7F
Reg: N13SY
Type: British Aerospace 125-800A
ICAO: H25B
MSN: 258103

Currently populates as ICAO: BE4A

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 01, 2010, 08:03:03 AM
On the network last night:

Mode S: 7C1B38
Reg: VH-FNU
Type: Fokker F-28-0100
ICAO: F100
MSN: 11373

Currently populates as ICAO: DHC6

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 01, 2010, 11:58:49 AM
Currently on the network:

Mode S: 49D0A3
Reg: OK-XGC
Type: Boeing 737-55S
ICAO: B735
MSN: 26541

Currently populates as Reg: OK-TEC;  Type: Reims F172K;  ICAO: ...;  MSN: RF1720627

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: dl1812 on April 01, 2010, 02:35:21 PM
Off at a slight tangent to this topic:

If I click on a cell under 'Network', I can fill in or update the details if available.
Also, if I sit there with my finger on the up/down cursor it will eventually update all of the cells that can be updated.

So what exactly does "populate" do, and should I use it insteasd of my one finger method ?

Words of one syllable please, I'm not computer literate like some on here  :o(
Title: Re: Database update info
Post by: DaveReid on April 01, 2010, 02:56:42 PM
Off at a slight tangent to this topic:

If I click on a cell under 'Network', I can fill in or update the details if available.
Also, if I sit there with my finger on the up/down cursor it will eventually update all of the cells that can be updated.

So what exactly does "populate" do, and should I use it insteasd of my one finger method ?

Words of one syllable please, I'm not computer literate like some on here  :o(

The "currently populates" details quoted are indeed what you will see if you click on, or cursor up/down to, the Mode S code in question.  That's to say the AirNav server fills in your local RadarBox database with the details that it has for that code.

Unfortunately all too often those details are incorrect or out-of-date, and you may even find that after you have corrected your own database yourself, the server subsequently overwrites your amendments with incorrect data - you will find a couple of long threads from users reporting this problem if you do a forum search.

I hope that makes sense and answers your question.
Title: Re: Database update info
Post by: dl1812 on April 01, 2010, 03:47:52 PM
The "currently populates" details quoted are indeed what you will see if you click on, or cursor up/down to, the Mode S code in question.  That's to say the AirNav server fills in your local RadarBox database with the details that it has for that code.

Unfortunately all too often those details are incorrect or out-of-date, and you may even find that after you have corrected your own database yourself, the server subsequently overwrites your amendments with incorrect data - you will find a couple of long threads from users reporting this problem if you do a forum search.

I hope that makes sense and answers your question.

Many thanks Dave - articulate and helpful as always !

Dave L.
Title: Re: Database update info
Post by: DaveReid on April 02, 2010, 06:51:40 AM
Currently on the network:

Mode S: A0C069
Reg: N148AA
Type: Beech 350C Super King Air
ICAO: B350
MSN: FM-12

Currently populates as Type: McDonnell Douglas DC-10-10;  ICAO: DC10;  MSN: 46703/19 (de-regd 2002)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: NF2G on April 02, 2010, 12:10:52 PM
One of American Airlines' original DC-10s, probably, still hanging around in the data cloud.

Title: Re: Database update info
Post by: NF2G on April 02, 2010, 12:11:48 PM
Earlier in the thread, someone mentioned the GAS lookup program.  I have the link open now and it looks to be designed specifically for the Kinetic box.  Can it be made to work with RadarBox?
Title: Re: Database update info
Post by: Geot on April 02, 2010, 01:53:08 PM
Last week was long dead Air Canada fleet aircraft appearing on ANRB - this week it has been Canadian Pacific Airlines DC-10s. A long, long gone airline and a/c. The hits were actually new production Bombardier a/c, a Global Express and a Dash 8-400 on test flights from Downsview. I dont expect ANRB to have such new a/c in the DB but I also don't expect it to fill my DB with long expired information, (cancelled over ten years ago).

GeoT
Title: Re: Database update info
Post by: anorak on April 03, 2010, 10:05:37 AM
On my box now;
381E3B   34      FA50  Russia - Air Force   2010/04/03 10:44:06
Do I need to go to my bunker or my data base
Title: Re: Database update info
Post by: Runway 31 on April 03, 2010, 11:59:37 AM
Should be F-RAFL/34 of the French Air Force
Title: Re: Database update info
Post by: Marpleman on April 03, 2010, 02:52:51 PM
On my box now;
381E3B   34      FA50  Russia - Air Force   2010/04/03 10:44:06
Do I need to go to my bunker or my data base

Quality comment anorak - love it!!

Rich
Title: Re: Database update info
Post by: DaveReid on April 03, 2010, 04:22:55 PM
On my box now;
381E3B   34      FA50  Russia - Air Force   2010/04/03 10:44:06
Do I need to go to my bunker or my data base

A simple database update will suffice - use your favourite SQLite utility to make the following changes in your NavData.db3:

(http://www.civilaircraftregisters.org/Mode_S_Resources/381E3Bb.gif)

Then save the following thumbnails:

http://cdn-www.airliners.net/aviation-photos/small/6/1/2/1475216.jpg
http://cdn-www.airliners.net/aviation-photos/small/3/0/9/1469903.jpg

as 34.jpg and 34,2.jpg in your AirNav RadarBox\Data\Photo folder.
Title: Re: Database update info
Post by: anorak on April 03, 2010, 06:01:16 PM
Thanks Dave.  No time off this Easter?
Title: Re: Database update info
Post by: DaveReid on April 04, 2010, 08:15:14 AM
Thanks Dave.  No time off this Easter?

I work for myself, so life is one long holiday :-)
Title: Re: Database update info
Post by: Tramline on April 04, 2010, 01:51:57 PM
D-AFKD Contactair F100 just dep LHR, Database brought up photo of a F50 which was re-registered in 1993!!
Title: Re: Database update info
Post by: DaveReid on April 07, 2010, 10:00:12 AM
Currently on the network:

Mode S: 49D0A8
Reg: OK-DGM
Type: Boeing 737-45S
ICAO: B734
MSN: 28473

Currently populates as Reg: (null);  Type: (null);  ICAO: (null);  MSN: (null)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 07, 2010, 08:26:07 PM
Currently on the network:

Mode S: A5221A
Reg: N43PR
Type: Boeing 737-75V
ICAO: B737
MSN: 28581

Currently populates as ICAO: CL61

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 12, 2010, 04:38:36 PM
On the network this afternoon:

Mode S: A82D60
Reg: N626JS
Type: Gulfstream V
ICAO: GLF5
MSN: 642

Currently populates as Type: Gulfstream Aerospace G-IV Gulfstream IV-SP;  ICAO: GLF4;  MSN: 1334

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: msteen on April 13, 2010, 10:54:10 AM
What about a feature built in ANRB where users easily could correct the info for an aircraft if they find an error/missing entry, the info is automatically sent to airnav systems for quality control, and updated in the software for all the users over the internet ?
Title: Re: Database update info
Post by: DaveReid on April 15, 2010, 09:09:16 AM
Currently on the network:

Mode S: 79A071
Reg: B-6059
Type: Airbus A330-243
ICAO: A332
MSN: 664

Currently populates as ICAO: A342

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 19, 2010, 02:54:46 PM
Currently on the network:

Mode S: 508118
Reg: UR-GAR
Type: Boeing 737-4Y0
ICAO: B734
MSN: 26081

Currently populates as Type: Boeing 737-528

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: shaun on April 19, 2010, 04:53:55 PM
More photos for me of two different aircraft.

[attachment deleted by admin]
Title: Re: Database update info
Post by: DaveReid on April 19, 2010, 05:16:19 PM
More photos for me of two different aircraft.

Don't complain - granted they are completely the wrong aircraft, but give me an Iskra or a Ching Kuo any day in preference to a boring old C-130 !
Title: Re: Database update info
Post by: DaveReid on April 19, 2010, 07:38:29 PM
Currently on the network:

Mode S: A23A97
Reg: N2426
Type: Cessna 560 Citation Encore+
ICAO: C560
MSN: 560-0815

Currently populates as Type: Cessna 560 Citation V;  ICAO: C680

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: ACW367 on April 19, 2010, 10:52:53 PM
Currently on the network:

Mode S: A23A97
Reg: N2426
Type: Cessna 560 Citation Encore+
ICAO: C560
MSN: 560-0815

Currently populates as Type: Cessna 560 Citation V;  ICAO: C680

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave

Rod presume you meant to say "Currently populates as Type: Cessna 680 Citation Sovereign;  ICAO: C680"
Title: Re: Database update info
Post by: DaveReid on April 20, 2010, 07:00:57 AM
Currently on the network:

Mode S: A2071F
Reg: N23KY
Type: Cessna P210 Centurion
ICAO: P210
MSN: P210-00447

Currently populates as ICAO: C10T

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave

Edit:  Apologies, this was in MyFlights, not on the network, above info still applies.
Title: Re: Database update info
Post by: DaveReid on April 22, 2010, 11:36:09 AM
Noted on MyFlights this morning (south-eastern UK):                              
                                                                                  
Mode S: AAD2F1
Reg: N797KK
Type: Bombardier BD-700 Global Express
ICAO: GLEX
MSN: 9290
                                                                                  
Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)
                                                                                  
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
                                                                                  
MTIA                                                                              
Dave                                                                              
Title: Re: Database update info
Post by: DaveReid on April 23, 2010, 03:36:38 PM
On MyFlights today:

Mode S: AD5A55
Reg: N96FL
Type: Cirrus SR-22
ICAO: SR22
MSN: 2899

Currently populates as ICAO: ASTR (de-regd 2008)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 24, 2010, 08:12:21 AM
Noted on MyFlights yesterday evening:

Mode S: AC442A
Reg: N89NC
Type: Gulfstream V
ICAO: GLF5
MSN: 5049

Currently populates as Type: Dassault Falcon 50;  ICAO: FA5X;  MSN: 337

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 26, 2010, 08:28:34 AM
Noted on MyFlights yesterday:

Mode S: A175FC
Reg: N1932P
Type: Gulfstream G550
ICAO: GLF5
MSN: 5256

Currently populates as ICAO: GLF4

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 27, 2010, 04:48:26 PM
Just airborne from LHR:

Mode S: 400409
Reg: G-BNLJ
Type: Boeing 747-436
ICAO: B744
MSN: 24052

Currently populates as ICAO: B752

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 28, 2010, 08:14:10 AM
On MyFlights earlier this morning:

Mode S: A7D633
Reg: N604AZ
Type: Canadair CL-600 Challenger 604
ICAO: CL60
MSN: 5328

Currently populates as ICAO: ...;  Photo links: AS55 TwinStar MSN 5644

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 28, 2010, 03:33:45 PM
Currently on the network:

Mode S: 440414
Reg: OE-LET
Type: Airbus A321-211
ICAO: A321
MSN: 3830

Currently populates as Type: Airbus A320-214;  ICAO: A320

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on April 29, 2010, 06:43:41 AM
On the network yesterday evening:

Mode S: E4827E
Reg: PR-MYC
Type: Airbus A319-132
ICAO: A319
MSN: 3733

Currently populates as Type: Airbus A320-214;  ICAO: A320

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Erich on May 02, 2010, 07:43:04 AM
Manual entry in the ROUTE list.
my problem is I want to change my list manually.
unfortunately can not be all about e.g. DLH7jh, AUA 73jp without probleme.leider zbRYR88xy, WZZ833c, JAE 7093 NICT zu.obwohl can find in the list below is not registered ist.was I'm doing wrong.
help Erik.
Title: Re: Database update info
Post by: DaveReid on May 03, 2010, 08:25:01 AM
Currently on the network:

Mode S: A6A6B4
Reg: N528AP
Type: Gulfstream G550
ICAO: GLF5
MSN: 5168

Currently populates as ICAO: GLF3

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: RodBearden on May 03, 2010, 10:44:29 PM
Erik

Are you putting a date in the CH field when you update a route?

Put in the date and time when you do the update, in the format:
YYYYMMDDHHMMSS  so today would be
20100503233500

That might help.

Rod
Title: Re: Database update info
Post by: DaveReid on May 04, 2010, 07:43:47 AM
Currently on the network:

Mode S: 885183
Reg: HS-TLC
Type: Airbus A340-541
ICAO: A345
MSN: 698

Currently populates as ICAO: A346

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on May 07, 2010, 01:27:32 PM
Currently on the network:

Mode S: AA6CD2
Reg: N771AV
Type: Gulfstream IV
ICAO: GLF4
MSN:

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Erich on May 14, 2010, 06:59:42 PM
We believe we did contact airframes.org on a few occasions before but didn't actually get a reply. Development can confim.
Title: Re: Database update info
Post by: DaveReid on May 15, 2010, 09:42:02 AM
Currently on the MyFlights:

Mode S: A768B6
Reg: N577DA
Type: Canadair CL-600 Challenger 604
ICAO: CL60
MSN: 5398

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on June 03, 2010, 11:50:01 AM
Noted on MyFlights:

Mode S: A0082B
Reg: N1008G
Type: Cessna 208B
ICAO: C208
MSN: 208B2191

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on June 04, 2010, 07:53:56 AM
Noted in MyFlights:

Mode S: A7F150
Reg: N6101Y
Type: Piper PA-28
ICAO: P28A
MSN: 2842343

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: orkney on June 04, 2010, 09:05:33 AM
Noted in MyFlights:

Mode S: A7F150
Reg: N6101Y
Type: Piper PA-28
ICAO: P28A
MSN: 2842343

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave



Hello

All the details apart from the icao were already in the central database so it must be a problem for you (and possibly others) downloading this data. The downloading of data is outside our control. We can only upload to the server. I have now added the ICAO anyway.

Andrew
Title: Re: Database update info
Post by: Marpleman on June 04, 2010, 09:31:17 AM
Noted in MyFlights:

Mode S: A7F150
Reg: N6101Y
Type: Piper PA-28
ICAO: P28A
MSN: 2842343

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave



Hello

All the details apart from the icao were already in the central database so it must be a problem for you (and possibly others) downloading this data. The downloading of data is outside our control. We can only upload to the server. I have now added the ICAO anyway.

Andrew


Morning Andrew

I think herein lies our problem

I'm still experiencing this - getting blanks, going to the database to update, and finding its already there.

I put it down to my own technical ineptness in understanding the "fetching" mechanics, but if Dave's not getting the info, maybe the problems more deep rooted?

Rich
Title: Re: Database update info
Post by: DaveReid on June 04, 2010, 09:35:49 AM
All the details apart from the icao were already in the central database so it must be a problem for you (and possibly others) downloading this data. The downloading of data is outside our control. We can only upload to the server. I have now added the ICAO anyway.

Well the server certainly wasn't returning any details for that hex code when it was logged.

But I agree that the details for the PA-28 in question are now being returned correctly.

Along with two rather smashing photos of Air Maui AS350 N6101Y (re-registered as N405AM in 1997) ...
Title: Re: Database update info
Post by: orkney on June 04, 2010, 09:57:51 AM
Hello  Rich

Looking at my log I can see many cases of this indeed. I now think we should should do any further discussions on this in our own forum to leave this thread free for what it is for.


Dave

I don't think we have control over photos either apart from where they link to and I did delete the erroneous links so the shouldn't click to the large picture.


Andrew
Title: Re: Database update info
Post by: shaun on June 04, 2010, 11:12:21 AM
I cant find what  Mode-S 403DE1 is. Populating blank.
Title: Re: Database update info
Post by: Marpleman on June 04, 2010, 11:18:16 AM
Hi Shaun

Please see the link below



http://www.airnavsystems.com/forum/index.php?topic=4980.msg49886#msg49886

We set this up to provide a specific thread where the update team can retrieve forum members requests and investigate accordingly, otherwise we run the risk of missing some!

At work at the moment (supposedly!), so cannot do much to help, but we'll take a look at it and update accordingly

Hope this helps!

Thanks

Rgds

Rich

Title: Re: Database update info
Post by: Runway 31 on June 04, 2010, 11:48:34 AM
403DE1 is an AA5 G-BXHH according to Airframes
Title: Re: Database update info
Post by: shaun on June 04, 2010, 12:26:30 PM
Thanks Rich and Runway 31.
Shaun
Title: Re: Database update info
Post by: DaveReid on June 04, 2010, 12:30:30 PM
You can also search on any allocated code in the UK civil range (currently 400400 to 4063A3) at www.caa.co.uk/application.aspx?catid=60&pagetype=65&appid=1&mode=search
Title: Re: Database update info
Post by: DaveReid on June 04, 2010, 02:54:11 PM
I don't think we have control over photos either apart from where they link to and I did delete the erroneous links so the shouldn't click to the large picture.

I'm not sure what you mean when you say that you "deleted the erroneous links".

I've made sure that N6101Y isn't in my Database Explorer/NavData database, and that I don't have any thumbnails for it in my Photo folder, but RadarBox still insists on showing the helicopter photos, so those details can only be coming from the server.

I suspect I'm simply not understanding how the process works, it would be nice if someone could explain it to me.
Title: Re: Database update info
Post by: orkney on June 04, 2010, 04:04:48 PM
hello

I meant that I deleted the LK and LK2 fields for that aircraft (and PT and PT2 fields as well) thinking this would stop people from getting the helicopter photos but obviously it doesn't. At least I now know to completely ignore the photo links since they update themselves anyway regardless of what we do to them.

Andrew
Title: Re: Database update info
Post by: DaveReid on June 04, 2010, 04:45:48 PM
I meant that I deleted the LK and LK2 fields for that aircraft (and PT and PT2 fields as well) thinking this would stop people from getting the helicopter photos but obviously it doesn't. At least I now know to completely ignore the photo links since they update themselves anyway regardless of what we do to them.

OK, thanks, I guess that makes us both officially mystified as to how the process works :-)

AirNav, this might be an opportune moment to chip in and enlighten us !
Title: Re: Database update info
Post by: ACW367 on June 04, 2010, 04:48:16 PM
Airnav are aware that there is an issue, in that data that we are entering for the AT PT and LK fields is not filtering to users. This means that in a very small number of cases you will still get a incorrect photo or non standard ICAO code. Airnav have this as a priority fix and it should be resolved shortly.
Title: Re: Database update info
Post by: DaveReid on June 08, 2010, 07:33:24 AM
On MyFlights this morning:

Mode S: A539BF
Reg: N436DM
Type: Canadair CL-600 Challenger
ICAO: CL60
MSN: 5116

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on June 08, 2010, 04:11:41 PM
Noted on MyFlights:

Mode S: A380FC
Reg: N325B
Type: Dassault Falcon 2000
ICAO: F2TH
MSN: 197

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveG on June 08, 2010, 06:28:25 PM
Reply 153 & 154 have been updated in DB
Title: Re: Database update info
Post by: DaveReid on June 09, 2010, 07:47:40 AM
Reply 153 & 154 have been updated in DB

Two down, only 374,313 to go :-)

I've sent you a PM.
Title: Re: Database update info
Post by: malc41 on June 09, 2010, 04:53:23 PM
Dave we'll get there soon!
Title: Re: Database update info
Post by: DaveG on June 09, 2010, 06:10:49 PM
Cheers Dave got it.  Why do I feel I'm walking in a mine field, lol.  Wish all registers we're published/accessed the same, would be so much easier.
Title: Re: Database update info
Post by: DaveG on June 09, 2010, 06:11:45 PM
Here is an open question, and yes I've no idea the answer...

How many ModeS codes are in use?
Title: Re: Database update info
Post by: DaveReid on June 09, 2010, 06:58:00 PM
Here is an open question, and yes I've no idea the answer...

How many ModeS codes are in use?

Depends on what you mean by "in use" - many aircraft have codes assigned without having an ATC transponder to transmit them, so you'll never pick them up.
Title: Re: Database update info
Post by: ACW367 on June 09, 2010, 08:54:45 PM
OK the better question is how many flyable aircraft are fitted with Mode S transponders.  My current semi-educated estimate is over 110,000 with around 3,000 changes worldwide in any one given month.

The 370K odd US allocated codes and the 20K UK allocated codes include many many thousands of Gliders, Balloons, Microlights which are never likely to even be equipped with Mode C, let alone a broadcasting Mode S.  Adding these to the system, and consequently tracking these aircraft sales and re-registrations would really divert the task from the important tracking of changes to Airliners, Biz Aviation and ADS-B aircraft that will be picked up often by the masses.  Tracking and updating the re-registration of a non-radio equipped Piper J-6 Cub operating from a farm strip in the town of Truth or Consequences, New Mexico (just because the FAA publish a code for its future use) is not going to help anyone.
Title: Re: Database update info
Post by: DaveReid on June 09, 2010, 09:18:02 PM
OK the better question is how many flyable aircraft are fitted with Mode S transponders.  My current semi-educated estimate is over 110,000 with around 3,000 changes worldwide in any one given month.

What we need is a truly worldwide Mode S network, then we could simply count the codes picked up :-)

I'd estimate nearer 150,000 potentially flyable Mode S transponder-equipped aircraft (including military).  As you rightly say, and indeed I did too, many aircraft have codes assigned without having an ATC transponder to transmit them, I guess we'll never know exactly how many.

I think we can rule out that "Piper J-6 Cub", though :-)
Title: Re: Database update info
Post by: DaveReid on June 10, 2010, 08:49:12 AM
On MyFlights last night:

Mode S: A3DEC7
Reg: N349AK
Type: Hawker 4000
ICAO: HA4T
MSN: RC-42

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveG on June 10, 2010, 04:42:16 PM
Just checked - message 163 has been updated
Title: Re: Database update info
Post by: DaveReid on June 11, 2010, 06:42:18 AM
Reply 153 & 154 have been updated in DB

Something not quite right here - the newly-created record for that Falcon 2000 has the correct type and msn, but a photo link and thumbnail of a Lancair that was de-registered in 2003 ...
Title: Re: Database update info
Post by: Marpleman on June 11, 2010, 10:18:45 AM
Reply 153 & 154 have been updated in DB

Something not quite right here - the newly-created record for that Falcon 2000 has the correct type and msn, but a photo link and thumbnail of a Lancair that was de-registered in 2003 ...

We're just testing you Dave!

Thnx - will look into it this evening

Rgds

Rich
Title: Re: Database update info
Post by: DaveReid on June 11, 2010, 10:46:23 AM
Did I pass ?   :-)
Title: Re: Database update info
Post by: Marpleman on June 11, 2010, 10:55:12 AM
Did I pass ?   :-)

With distinction
Title: Re: Database update info
Post by: ACW367 on June 11, 2010, 11:37:53 AM
Reply 153 & 154 have been updated in DB

Something not quite right here - the newly-created record for that Falcon 2000 has the correct type and msn, but a photo link and thumbnail of a Lancair that was de-registered in 2003 ...

Airnav are aware that there is an issue, in that data that we are entering for the AT PT and LK fields is not filtering to users. This means that in a very small number of cases you will still get a incorrect photo or non standard ICAO code. Airnav have this as a priority fix and it should be resolved shortly.

Dave See my Quote above.  Airnav are aware of the bug and we hope to have this resolved shortly. 
Title: Re: Database update info
Post by: DaveReid on June 11, 2010, 12:01:47 PM
Airnav are aware that there is an issue, in that data that we are entering for the AT PT and LK fields is not filtering to users. This means that in a very small number of cases you will still get a incorrect photo or non standard ICAO code. Airnav have this as a priority fix and it should be resolved shortly.

Dave See my Quote above.  Airnav are aware of the bug and we hope to have this resolved shortly. 

OK, thanks for that - I hadn't realised that the spurious photo links bug applied to newly-created records as well as to existing ones.
Title: Re: Database update info
Post by: DaveReid on June 11, 2010, 04:55:17 PM
On MyFlights ths morning:

Mode S: AC86A4
Reg: N906NB
Type: Falcon 7X
ICAO: FA7X
MSN: 74

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveG on June 11, 2010, 05:00:00 PM
#171 updated.
Title: Re: Database update info
Post by: John Racars on June 11, 2010, 06:10:25 PM
Any change of this flight?

BAW20U = ?-?

Thank you in advance!
Title: Re: Database update info
Post by: DaveG on June 11, 2010, 06:17:52 PM
the aircraft used could have been:

G-EUUZ, A320-232, 405A48

It is in the database correctly.
Title: Re: Database update info
Post by: ACW367 on June 11, 2010, 06:39:19 PM
Dave R it would really help us if you include both owner (from the Register) and Operator (from the RVSM Monitoring Orgs or other sources) with the data block you include in your post. 

Regards
ACW
Title: Re: Database update info
Post by: DaveReid on June 13, 2010, 08:42:06 AM
Dave R it would really help us if you include both owner (from the Register) and Operator (from the RVSM Monitoring Orgs or other sources) with the data block you include in your post.

OK, I'll see what I can do, although it's an automated routine that I'm running to cross-check local and network flights against my master database, and I don't have time at the moment to tinker with the code.
Title: Re: Database update info
Post by: DaveReid on June 13, 2010, 08:44:31 AM
On MyFlights yesterday evening:

Mode S: A4D9A3
Reg: N411UK
Type: Cirrus SR-22
ICAO: SR22
MSN: 3696

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 13, 2010, 09:27:15 AM
N411UK added to databade, thanks Dave
Title: Re: Database update info
Post by: DaveReid on June 16, 2010, 12:52:40 PM
On MyFlights yesterday:

Mode S: A68A81
Reg: N520SC
Type: Canadair CL-600 Challenger 605
ICAO: CL60
MSN: 5779

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 16, 2010, 02:03:50 PM
Wouldnt have got that one from the usual sources. LJ60 on Airframes and nothing on GAS.  Details on FAA though

Added to database
Title: Re: Database update info
Post by: DaveReid on June 16, 2010, 02:55:40 PM
Wouldnt have got that one from the usual sources. LJ60 on Airframes and nothing on GAS.  Details on FAA though

Well I guess I should be glad I'm not classed as a "usual source"  :-)
Title: Re: Database update info
Post by: DaveReid on June 16, 2010, 03:10:23 PM
Noted on MyFlights:

Mode S: A70365
Reg: N551CS
Type: Gulfstream G550
ICAO: GLF5
MSN: 5264

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 16, 2010, 04:57:47 PM
N551CS added
Title: Re: Database update info
Post by: DaveReid on June 16, 2010, 05:14:12 PM
N551CS added

Any prospect yet of AirNav giving you a utility to automatically import types commonly fitted with Mode S from the FAA register ?

It's going to be a long haul otherwise, inputting them one at a time ...
Title: Re: Database update info
Post by: orkney on June 16, 2010, 05:47:10 PM
N551CS added

Any prospect yet of AirNav giving you a utility to automatically import types commonly fitted with Mode S from the FAA register ?

It's going to be a long haul otherwise, inputting them one at a time ...

hello

We have discussed this faa import many times so there is no need to raise it again. Also would you prefer  just to leave the infamous XXX bank trustee or other pointless info  that  is so prevalent in the official faa register instead of us looking for the airline that is operating it. If you like your faa records so much import the faa file yourself and turn off your auto populate. then we might finally get peace although I thought your sarcastic "advice" had come to an end this last week or so but sadly it is back.

Andrew

Title: Re: Database update info
Post by: DaveReid on June 16, 2010, 05:57:51 PM
We have discussed this faa import many times so there is no need to raise it again. Also would you prefer  just to leave the infamous XXX bank trustee or other pointless info  that  is so prevalent in the official faa register instead of us looking for the airline that is operating it. If you like your faa records so much import the faa file yourself and turn off your auto populate. then we might finally get peace although I thought your sarcastic "advice" had come to an end this last week or so but sadly it is back.

OK, have it your own way, personally I'd have thought that some kind of automatic import to jump-start the process was a no-brainer.

But if you're saying that we can anticipate a sharp reduction in the number of FAA unknowns, then so be it - I look forward to that as much as anyone else.
Title: Re: Database update info
Post by: DaveReid on June 18, 2010, 02:29:59 PM
Currently on MyFlights:

Mode S: A8559A
Reg: N636SD
Type: Embraer EMB-500 Phenom 100
ICAO: E50P
MSN: 50000117

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 18, 2010, 02:34:33 PM
N636SD done
Title: Re: Database update info
Post by: DaveReid on June 18, 2010, 07:29:29 PM
On MyFlights this evening:

Mode S: A6FD9D
Reg: N55FP
Type: Cessna 525B CitationJet 3
ICAO: C25B
MSN: 525B-0153

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 18, 2010, 08:24:57 PM
Ta Dave done.
Title: Re: Database update info
Post by: Marpleman on June 18, 2010, 08:53:29 PM
We have discussed this faa import many times so there is no need to raise it again. Also would you prefer  just to leave the infamous XXX bank trustee or other pointless info  that  is so prevalent in the official faa register instead of us looking for the airline that is operating it. If you like your faa records so much import the faa file yourself and turn off your auto populate. then we might finally get peace although I thought your sarcastic "advice" had come to an end this last week or so but sadly it is back.

OK, have it your own way, personally I'd have thought that some kind of automatic import to jump-start the process was a no-brainer.

But if you're saying that we can anticipate a sharp reduction in the number of FAA unknowns, then so be it - I look forward to that as much as anyone else.

Hi Dave

We've been looking at alternative methods of getting "non-singular" records into the database for the past couple of weeks now, as I agree that the "one by one" approach is an impossibility.

With a little help from Dev, we can very easily achieve this,although it may not be ideal, especially with owners or operators.

My personal view on this (and I must stress - personal), is that it is more useful to get aircraft details with a solid basis of registration, type, cn, ICAO and if possible operator onto the databse - at least then we won't get so many unpopulated records appearing.

We can then plug the gaps accordingly, although with biz jets and light aircraft, again I personally do not see the operator as being crucial?
It would be nice to get as accurate a picture as is possible regarding the operator, but just keeping this up to date alone would be a task and a half

Commercial airliners would be easier to deal with obviously.

At the moment, we don't have any facility to do this,although it has been suggested as an available option.

I'll keep you posted

Regards

Rich

 

Title: Re: Database update info
Post by: DaveReid on June 18, 2010, 09:25:44 PM
All makes sense to me.

But then I'm not the one who has to convince a sceptical Orcadian :-)
Title: Re: Database update info
Post by: DaveReid on June 22, 2010, 02:24:39 PM
Noted on MyFlights this afternoon:

Mode S: AA9103
Reg: N780F
Type: Gulfstream G550
ICAO: GLF5
MSN: 5261

Currently populates as MSN: 530

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 22, 2010, 03:13:30 PM
Changed Dave
Title: Re: Database update info
Post by: DaveReid on June 22, 2010, 04:09:20 PM
Currently populates as MSN: 530

Oops, should have also pointed out that MSN 530 is now N780W, which doesn't populate either.
Title: Re: Database update info
Post by: Runway 31 on June 22, 2010, 04:52:28 PM
Nae bothers Dave, I check anyway and it is msn 5261
Title: Re: Database update info
Post by: DaveReid on June 22, 2010, 07:10:04 PM
Nae bothers Dave, I check anyway and it is msn 5261

I think we're at cross-purposes here ...
Title: Re: Database update info
Post by: Runway 31 on June 22, 2010, 07:19:54 PM
Right enough got you now.
Title: Re: Database update info
Post by: DaveReid on June 24, 2010, 01:36:17 PM
On MyFlights this morning, and again this afternoon:

Mode S: AAAF5F
Reg: N788MP
Type: Cessna 525 Citation Jet 1+
ICAO: C525
MSN: 525-0645

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on June 24, 2010, 01:39:19 PM
Oops, should have also pointed out that MSN 530 is now N780W, which doesn't populate either.

Still can't get this one to populate.
Title: Re: Database update info
Post by: Runway 31 on June 24, 2010, 02:07:10 PM
Both done now Dave.  We were at cross purposes with N780W.
Title: Re: Database update info
Post by: DaveReid on June 27, 2010, 07:36:25 AM
On MyFlights yesterday afternoon:

Mode S: A1E105
Reg: N220AD
Type: Cirrus SR22
ICAO: SR22
MSN: 3697

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 27, 2010, 09:07:11 AM
N220AD updated
Title: Re: Database update info
Post by: DaveReid on June 27, 2010, 05:30:04 PM
On MyFlights this morning:

Mode S: A99723
Reg: N717MB
Type: Cessna 680 Citation Sovereign
ICAO: C680
MSN: 680-0084

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 27, 2010, 06:44:03 PM
N717MB updated
Title: Re: Database update info
Post by: DaveReid on June 28, 2010, 09:02:26 PM
On MyFlights this morning:

Mode S: A9EAB7
Reg: N738W
Type: Cessna 414A Chancellor
ICAO: C414
MSN: 414A-0027

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 29, 2010, 07:34:50 AM
Updated, ta Dave
Title: Re: Database update info
Post by: 54901 - Jim on June 29, 2010, 11:11:38 AM
Minimal information on this record -->

C00669    C-FCLC    C180


Thanks!

Jim
Title: Re: Database update info
Post by: DaveReid on June 29, 2010, 11:23:09 AM
Minimal information on this record -->

C00669    C-FCLC    C180

MSN 31600, formerly N4702B.

Although it's highly likely that what you actually picked up was Air Canada A319 C-GARG, which is currently miscoded as such.
Title: Re: Database update info
Post by: 54901 - Jim on June 29, 2010, 11:28:13 AM
Thank you, Dave!


Jim
Title: Re: Database update info
Post by: DaveReid on June 30, 2010, 02:50:37 PM
On MyFlights this afternoon:

Mode S: A1BB6E
Reg: N210VS
Type: Cessna 560 Citation Excel
ICAO: C56X
MSN: 560-5093

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on June 30, 2010, 03:33:34 PM
Updated Dave, thanks

Alan
Title: Re: Database update info
Post by: DaveReid on July 01, 2010, 03:57:41 PM
Noted in MyFlights:

Mode S: 40535A
Reg: G-PHAB
Type: Cirrus SR22
ICAO: SR22
MSN: 2710

Currently populates as Reg: G-MACL

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: DaveReid on July 02, 2010, 03:03:49 PM
Is there a problem with UK updates ?  My last one didn't get actioned.

Anyway, here's another - noted in MyFlights:

Mode S: 4063AE
Reg: G-LALE
Type: Embraer ERJ-135BJ Legacy 600
ICAO: E135
MSN: 14501017

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on July 02, 2010, 04:17:59 PM
Both now done, sorry for the delay but was watching Holland - Brazil.

Alan
Title: Re: Database update info
Post by: DaveReid on July 04, 2010, 10:08:02 AM
Noted in MyFlights:

Mode S: 4063AF
Reg: G-DKEM
Type: Bell 407
ICAO: B407
MSN: 53750

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on July 04, 2010, 11:33:02 AM
Updated Dave, Thanks
Title: Re: Database update info
Post by: DaveReid on July 14, 2010, 07:34:54 AM
Noted in MyFlights:

Mode S: 406280
Reg: G-CGLR
Type: Czech Aircraft Works Sportcruiser
ICAO: CRUZ
MSN: 09SC324

Currently populates as Reg: (blank);  Type: (blank);  ICAO: (blank);  MSN: (blank)

This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.

MTIA
Dave
Title: Re: Database update info
Post by: Runway 31 on July 14, 2010, 09:28:17 AM
Updated Dave, many thanks

Alan