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 ('0191102')
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 ('0191102')
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.
N9707EHumfleet Edward · Curtis, WAN9710EField James David · Connersville, INN9711EBenien Dennis A · Napoleon, OHN9716EErvin William B · Clear Lake, MNN9717EJeffryes Richard B · Creswell, ORN9724ERosti Construction Of Mn Inc · Elko, MNN9725EEmch Donald R Jr · New Waterford, OHFirst renewal noticeN9726EClark David A · Plainfield, INN9727ECarlisle Maxxxwell M · Tarzana, CAN9734EDykstra Danny L · Jasper, MNN9736EWilliams Chad · Jamestown, INN9738ESchaublin Gary R · Delta, CON9742EForbes James A · Monkton, MDN9743EKemble Kevin R · South Bend, INN9746EWething Aviation LLC · Detroit Lakes, MNN9747EJones Gregory P · Dowling, MIN9752ESmith Happy E · Rogersville, TNN9756ERice Gary W · San Antonio, TXN9757EInspired Oasis LLC · Alpine, CAN9758ETumminaro Michael · Neodesha, KSN9761EStonier Scott F J · Bloomington, INN9763ENelsen Kc Jr · Phoenix, AZN9766EHamm Jeffrey E · Lexington, OKN9767EThomas Trae · Rockwell City, IAN9769EGardner Carsten · Eagle River, AKN9770EEstu Michael P · Huntington Beach, CAN9771EAgaliotis Paul E · San Martin, CAN9773EFruguglietti Joseph M · Burney, CAN9779EStuckle Eugene A · Davenport, WAN9780ELambert James D · Sterling, CON9784ERuniyon Greg A · Bainbridge, INN9785EGreener Richard M · Mohnton, PAN9789EGolonka Joseph P · Beekwourth, CARegistration revokedN9790ELerch Mark R · San Angelo, TXN9791EHutson Norman · Olympia, WAN9795EOklahoma Flight Academy LLC · Owasso, OKN9796ESipe William J · Manchester, TNN9797EMac Coy Clifford J · Line Lexington, PAN9800EWord Of Truth Inc · Madisonville, TXN9804ELorentzen John R · Port Alsworth, AKN9808EEngler Alan W · Bad Axe, MIN9809EVetterkind Jack O · New Auburn, WIN9811EBarnes Glen R · Lone Oak, TXN9814EMuir David W Jr · Lake Stevens, WAN9818EWhite Andrew R · Dubois, WYN9820ERoth Sebastian A · Pacoima, CAN9825ECox Norman E · Arlington, ORN9830EGollobit Matt W · Pierce, NEN9831EMatthews Raymond H Jr · Rhoadesville, VAN9832ERegistration Pending · Bozeman, MTRegistration pending, pending cancellation
Back to Aeronca 11AC