mhostetter/gr-adsb

Integrate FAA registry info

Opened this issue · 0 comments

The FAA publishes a list of all registered tail numbers, their registrants, and their corresponding ICAO addresses, among other things. The CSV list is updated daily and is about 60 MB. I want to one-time convert a downloaded copy to a SQLite database for fast lookups.

https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/releasable_aircraft_download/

  • Write a script to convert a user's downloaded FAA registry CSV file into an ICAO-indexed SQLite database
  • Add option to ADS-B Decoder to use FAA database
  • Propagate registry number info in decoded bursts