anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Type codes in the database  (Read 34226 times)

0 Members and 1 Guest are viewing this topic.

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4124
Re: Type codes in the database
« Reply #15 on: May 18, 2009, 09:05:03 PM »
Thank you Gary for posting. We are very grateful for your teams work and anyone telling you otherwise should be ashamed of themselves.

We echo your comments about the accuracy and the level of changes required and can only hope that anyone using the databases understands the level of complexity around this to make it as close to accurate as possible.

jgrloit,

We originally used static database and from that we use airliners.net and GAS for the updates.
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

Brian

  • Jr. Member
  • **
  • Posts: 74
Re: Type codes in the database
« Reply #16 on: May 18, 2009, 09:15:54 PM »
AirNav Support,

So the "Military information" came from the "static database" ?

Sorry you aren't making it very clear where those Military ICAO type codes came.

CoastGuardJon

  • Hero Member
  • *****
  • Posts: 1178
  • Mullion Cove, Kernow --- sw Cornwall UK.
Re: Type codes in the database
« Reply #17 on: May 18, 2009, 09:21:19 PM »
Hi Gary, like 99.9% of us in here, many thanks for all the info., effort and hard work that is put into the DB.    You can please most of the people all of the time, a few most of the time, and then there's those who will never be satisfied - I'm just grateful for the RB, you, AN and this Forum for the superb contribution to my hobby.    THANKS all.
ANRB :  AOR AR8000 : Icom R-7000 : Icom IC-R9000 : JRC NRD-545 : OptoElectronics Digital Scout and OptoLinx Interface; Realistic Pro-2005 : UBC 800XLT - listed in alphabetical order, not cost, preference, performance or entertainment value!

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4124
Re: Type codes in the database
« Reply #18 on: May 18, 2009, 09:35:12 PM »
We have added a FAQ:

http://www.airnavsystems.com/forum/index.php?topic=2688.new#new

We will add to that if we get further queries regarding how it works.

Brian,

If you mean the actype table in the database. Then yes it was made from different sources originally and is static (it doesn't change by GAS updates). This is the first time the actype table has been mentioned in terms of updating.

If we get the list jmhayes has mentioned, we can add them.
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Type codes in the database
« Reply #19 on: May 18, 2009, 09:39:40 PM »
We have added a FAQ:

http://www.airnavsystems.com/forum/index.php?topic=2688.new#new

We will add to that if we get further queries regarding how it works.

Brian,

If you mean the actype table in the database. Then yes it was made from different sources originally and is static (it doesn't change by GAS updates). This is the first time the actype table has been mentioned in terms of updating.

If we get the list jmhayes has mentioned, we can add them.

If you simply want a list of valid ICAO type codes, you can download it yourself from www.icao.int/anb/ais/8643/index.cfm
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4124
Re: Type codes in the database
« Reply #20 on: May 18, 2009, 10:02:15 PM »
Thanks Dave, we will try and squeeze that into 2.10
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

cessna24v

  • New Member
  • *
  • Posts: 4
Re: Type codes in the database
« Reply #21 on: May 18, 2009, 10:20:28 PM »
Quote
Q. AIrnav support - if GAS only supplies the Civ Airframe data - where does the RB Server system get the Military information from?
It looks as though the short-types on that system are incorrect!!!

Just to prevent further confusion, GAS supplies both Civil and Military codes.

I was referring to the strange ones like BC-A etc. which are not and never have been in the GAS DB.
Gary

jgrloit

  • Sr. Member
  • ****
  • Posts: 271
Re: Type codes in the database
« Reply #22 on: May 18, 2009, 10:31:15 PM »
Thanks for the clarification Gary.

I was starting to suspect MY reading of the messages was giving me a misleading conclusion!!!!

I am, at present only interested in the Mode-S to Registration links - the types and Operators can follow later!!!
Based in Hexham - Tyne Valley 
Best view for RB is North of a line between EGNT and EGNC  - includes OTA and Spade, to EGPH above 7500ft.   Can be TRUE mobile with Mobile Broadband feed to Network.

Brian

  • Jr. Member
  • **
  • Posts: 74
Re: Type codes in the database
« Reply #23 on: May 18, 2009, 10:47:55 PM »
AirNav Support,
Thanks for making the new topic on "how the database works" Nice to read it on one page.  Just trying to learn everything about it. and these ICAO codes stuff!.

That pages needs more info on how the FAA N-numbers works with Mode-S ID's.
You only talked about UK stuff.  I'm sure you are still working on that page to make it better.


Edit:
You can also link to some other stuff on that new page. I'm sure you can find some links to add that talks about Mode-S and N-numbers on the wiki sites.  Just make it look pretty :)

Another question.  Where did these codes(BC-A, etc. see first post) that is showing up in the radarbox database come from.  Do you have a link to learn more about it.
« Last Edit: May 18, 2009, 11:04:40 PM by Brian »

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Type codes in the database
« Reply #24 on: May 19, 2009, 07:00:32 AM »
Thanks for making the new topic on "how the database works" Nice to read it on one page.  Just trying to learn everything about it. and these ICAO codes stuff!.

That pages needs more info on how the FAA N-numbers works with Mode-S ID's.
You only talked about UK stuff.  I'm sure you are still working on that page to make it better.

Yes, I'd agree, that's a useful addition.

However one of the examples quoted is a bit misleading:

Mode-S IDs can also change there link to registrations. Example G-EUUT could go out of service and then 401240 is assigned to G-ELLB. This will mean the aircraft details in your local database will be wrong.

The UK never reassigns the Mode S code from an aircraft which has gone out of service.  Other countries such as the US reassign codes from one aircraft to another, but that's only because they reassign registrations, and the FAA matches registrations permanently to Mode S codes.

In fact there are very few examples worldwide of Mode S codes being reused on a different aircraft with a different registration - the only ones I can think of, off the top of my head, would be the Czech Republic which changed its Mode S allocation system from a permanent reg/code match (like the USA) to an ad-hoc one.  This resulted in, for example, code 49D0A3 being reassigned from C172 OK-TEC to B735 OK-XGC.

HTH
Dave
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4124
Re: Type codes in the database
« Reply #25 on: May 19, 2009, 07:49:41 AM »
Thanks Dave, we will clarify that paragraph so it talks about change in operators.

Brian,

The ICAO codes are in the actype table in the database. As Dave mentioned the site below can give you a quick view of what they mean.
http://www.icao.int/anb/ais/8643/index.cfm
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

malc41

  • RadarBox Beta Testers
  • Hero Member
  • *
  • Posts: 586
Re: Type codes in the database
« Reply #26 on: May 19, 2009, 08:02:34 AM »
Dave

When you say never reassign s-codes in the UK, could this be taken that we have a large block and not enough aircraft in this country to use them all up for some time?
15 Miles East of EGNJ

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Type codes in the database
« Reply #27 on: May 19, 2009, 08:43:49 AM »
When you say never reassign s-codes in the UK, could this be taken that we have a large block and not enough aircraft in this country to use them all up for some time?

You could say that   :-)

The UK is allocated just over a quarter of a million codes.  Of those, around 23,000 have been allocated to G- civil aircraft, an unknown number to the military and a handful to the Isle of Man, Bermuda and Caymans.

I think that still leaves quite a few !!
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

malc41

  • RadarBox Beta Testers
  • Hero Member
  • *
  • Posts: 586
Re: Type codes in the database
« Reply #28 on: May 19, 2009, 09:01:57 AM »
Dave

When you put it that way, they won't run out in my lifetime, no at least while we are in a credit crunch!

So I take it the M- registrations are included with us?
15 Miles East of EGNJ

jgrloit

  • Sr. Member
  • ****
  • Posts: 271
Re: Type codes in the database
« Reply #29 on: May 19, 2009, 10:55:07 AM »
I think using UK in the previous message is technically incorrect as the range of radio prefixes and country codes that use the 'UK' allocation are those from the UK and British Commonwealth.
The G-, M-, VP- and other callsign prefixes also stem from the UK and British Commonwealth allocations from the ITU  decades ago!!!
Based in Hexham - Tyne Valley 
Best view for RB is North of a line between EGNT and EGNC  - includes OTA and Spade, to EGPH above 7500ft.   Can be TRUE mobile with Mobile Broadband feed to Network.