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.
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/
decodedbursts