Hi there, I am trying to build some sort of database based on captured tracks (so a plane only shows up once in the database). To do some fancy powerBI stuff I am looking for a recent icao aircraft type designators list (like 738 is Boeing 737-800 etc). Plenty databses available online, haven’t seen a downloadable file yet.
Anyone? Or - even better - a script that exports tracks to csv or something?
Cheers-Guus
Check these:
The Basestation DB files might contain the required information as well
Try Aircraft Type Designators which is the canonical source
and look at the devtools (f12) network tab …
Hi Guus, I hope this finds you doing well. I am looking for the same thing (I capture what ADS-B gives me in a Postgres database) but haven’t been able to find quite what I want. Just wondering if you’ve found anything out there?
The Basestation DB referenced up thread does indeed have an aircraft table that gets very close, but the long form type description is excessively long. Meanwhile on the ICAO page also mentioned up thread, the type designator is not a primary key, so any given designator may (and often does) point to multiple types.
Any insight appreciated, thanks!
Pat
What exactly are you trying to achieve?
The Basestation format is used very often, what problem do you have with the long form type?
Well, I mean, that’s just the way it is - a single ICAO type designator can refer to multiple specific aircraft types, by design (it’s not intended to uniquely identify the type, it’s meant to group together related aircraft with similar characteristics). If you’re trying to use an ICAO type designator to uniquely identify the aircraft type, you’re doing it wrong…
Well, yes - I really do get all of that. Still, the Basestation file gives me this for all the C172’s that it has:
172/172 Cutlass/172 Skyhawk/Cutlass/Hawk XP/Mescalero/P172 Skyhawk Powermatic/R172/R172 Hawk XP/Skyhawk/Skyhawk Powermatic/T-41 Mescalero/P-172/F172/F172 Skyhawk/FP172/FR172 Hawk XP/FR172 Reims Rocket/Hawk XP/Reims Rocket/Skyhawk
Not very helpful. Similarly, for all the B763’s it is 767-300. That’s also not helpful, but for the exact opposite reason. I find it hard to believe there aren’t sources out there that map ICAO hex codes to a meaningful but not overly verbose long description, like 767 36NERBDSF.
Finding a mapping for ICAO 24-bit addresses is quite a different question to finding a mapping for ICAO aircraft type descriptors. I’m still not quite sure what it is you’re trying to do here.
For US-registered aircraft the FAA registry has specific manufacturer/type information for each registered aircraft which you can then pair up with a 24-bit address. Beware that it is very inconsistent. The FAA registry is actually the source of many of the ICAO type designators in the database that ships with dump1090-fa, and there is a lot of work needed behind the scenes to turn the FAA registry data into a useful aircraft type.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.