Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('34703')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('34703')
ORDER BY n_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N39ZAVeruca Salt LLC · Washington, TXN40UA40ua LLC · Kissimmee, FLN4328YBorsight Leasing LLC · Ogden, UTN439RSSugden Richard · Wilson, WYN50XXJs Albatros LLC · Nashville, TNN55107Tropical Aviation Of Delaware Inc · White Plains, MDN600DMWarbird Preservation Foundation · Bettendorf, IAN626SFPratt Group Leasing LLC · Niles, MIN63MXFox3 International LLC · Scottsdale, AZN63XXDt Aviation Consulting LLC · Atlanta, GAN656DTLegacy 222 LLC · El Cajon, CAN678LSHuff Air LLC · Uvalde, TXN699BAGraham Michael C · Newnan, GAN77MHHoward Jesse · Houston, TXN831DLMerlin Labs Inc · Boston, MAN831EFZeus Flight LLC · Ketchum, IDN8XHUat LLC · Kissimmee, FLN900MLVast Inc · Long Beach, CAN9053EClassic Aviation LLC · Jackson, WYN90576D & M Enterprise LLC · Wilmington, DEN90MSValiair Lc Trustee · Casper, WYN91354Taylor Aero LLC · Lewes, DEN929ASSchiro Anthony · Lewes, DEN939CMJet Aerobatics LLC · Groveland, FLN939TSShortt Aircraft Leasing LLC · Wilmington, DEN94NLBrotz Michael R · Kohler, WIN992RTFox3 International LLC · Scottsdale, AZN9CYFox3 International LLC · Scottsdale, AZ
Back to Ivchenko AI-25TL