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 ('2072434')
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 ('2072434')
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.
N9790GIsaac Gerald B · Spencerport, NYN9808JPtosis LLC · Fair Oaks, CAN9812JMelbourne Flight Training LLC · Melbourne, FLN981MARed Rose Flight Tours LLC · Lancaster, PAN9824JBarksdale James Alan · Florence, ALN9829JInflight Corp · Chaffee, MON9831GStarr David · Mount Prospect, ILN9839GLong William F · Belton, TXN9848JLanham David R · Visalia, CAN9853JEastern Kentucky University Center For Aviation · Richmond, KYN9862JNew River Flying Club Inc · Beaver, WVN9866JKembel Robert D · Saint Ignatius, MTN9867JNorby Aviation LLC · Hopkinton, MAN9872JWagner Timothy A · Port Trevorton, PAN9874EBlust Henry A · Arlington, VAN9888JHoran Lawrence J · Terrell, TXN98DXInternational Air Services Inc Trustee · Carson City, NVN99048Bradley Aircraft Co · Columbus, INN990BFlight Academy LLC · Van Nuys, CAN9914ESimica Charles A · Marietta, GAN9918EByrne Evan A · Mountain Lake Park, MDN9931EN9931e LLC · Phoenix, AZN9937E7 And 7 LLC · Leon, IAN9943ELerud Peder E · Stockton, CAN9945EWilcox John C · Aurora, NEN9957EReisman Richard H · Montrose, CON9960EArklamiss Aviation LLC · Ruston, LAN9961ERuryk Jonathan D · Pineville, LAN9963EDenski David T · Plymouth, MIN9971EGuerrero-Reyes Fernando G · Princeton, NJN997SEAero Equities LLC · Ventura, CAN9991EWings Flight Enterprises Inc · Danville, KYN9991GSale Reported · Staten Island, NYSale reported, canceledN9993ECruise Flight Academy Inc · Dalton, GAN999ARD R Tripp Enterprises LLC · Omaha, NEN999WBEastern Kentucky University · Richmond, KYN99PGWilliams James R · Batesville, INN9MYBermudez Tacito Octavio · Conyers, GA
Back to Cessna 172N