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 aircraft_model_code IN ('2210302', '2210400')
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 aircraft_model_code IN ('2210302', '2210400')
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.
N64AMSkahen Sean M · Saint Joseph, MNN691BEWester Joshua · Emmett, IDN6GCLett Robert W · Dallas, TXN6XAFlying Farmers LLC · Dalhart, TXN6XCNorthstar Aerospray Inc · Clara City, MNN70HUHexom Nathan · Bozeman, MTN713MMGannett Helicopters · Lander, WYN747HUAlpha Air LLC · Logan, UTN76DVTuchscherer William G · Oshkosh, WIN7XJAverage Joe Flying Services LLC · Mukwonago, WIN801JHBerg Jacob · Findlay, OHN80HULast Waterhole LLC · West Richland, WAN817JVRusyniak Anthony J · Syracuse, NYN84WMErickson Lee A Trustee · Fargo, NDN8765HN8765h LLC · Carthage, NCN888HUPeoples Michael L Jr · Rockwall, TXN8QAWilcox Consulting LLC · Amarillo, TXN8QTJd Services Inc · Glendive, MTN8XARogne Fred A · Fallon, NVN8XCGreenblatt Stan M · Brick, NJN8XJLefore Nikolas · Milton Freewater, ORN8XULevine Laurence · Hernando, MSN90ESTodd Donnie D Jr · Pell City, ALN90HULenaerts-Bergmans Bart · Jefferson, MAN91KWLavell Michael J · Blue Mounds, WIN92ANStevens Matthew S · Penn Yan, NYN92ARBixby Colleen M · Ellsworth, NEN92HURobinson Larry D · Dewitt, ARN93HUFugleberg Lance R · Portland, NDN94HUTronstad John L · Baker, MTN954LTWc Flight LLC · Higgins, TXN95KSHarper Harry · Meridian, IDN960DGN960dg LLC · Idaho Falls, IDN9614EWeber William J · Durham, NCN9615RAlbright Frank · Elba, ALN96186Registered aircraftN9618FCoady Siegfried · Dallas, TXN96206Registration Pending · Sioux Falls, SDRegistration pendingN9620ZBaker Joe · Turner, MTN9623YTownsend Richard · Sagle, IDN9623ZYellowstone Aviation Inc · Jackson, WYN96HUBristol Bay Fisheries Inc · Angwin, CAN96RKKomro Robert J · Durand, WIN9QAVerwolf Phil A · Broadus, MT
Back to Aviat A-1