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 ('0690009', '060009Y', '05622D3')
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 ('0690009', '060009Y', '05622D3')
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.
N458EPLancaster Travis I · Minot Afb, NDN45PJSteele John A III · Duxbury, MAN46036Diaz Silveira Jorge · Homestead, FLN4612RBurbridge Benjamin L · Jacksonville, FLN462ZGramelspacher Robert E · Troy, INN4647RDotson Jesse D · Dayton, TNN46RJChastain Ashley B · Greeley, CON470MBGad Aircraft Services LLC · Solon, MEN470PJFlippin Dale F · Auburn, CAN470PPAlley Peter H · Big Rapids, MIN471PDKuykendall Robert F · Vallecito, CAN4754Sale Reported · Crystal, MNSale reported, pending cancellationN475JBShackelford Lon D · Charlottesville, VAN476VTM&M Rv-12 LLC · Savannah, MON481RVLadd Avion LLC · Milford, INN482ABZapata Raymond E · Cabo Rojo, PRN4830POpen Sky LLC · Appleton, WIN484TABurr Allen H · Oak Island, NCN486HScarborough Robert J · Reidsville, NCN488QABleau Michael · Melbourne, FLN48ZGMartinez Ivo · Spring Valley, CAN491PRRoach Donald G · St Louis Park, MNN495YBBowers Gale W · Monroe, ORN49DDRose Kagen N · Santa Fe, TXN49VWVander Weerdt Dennis A Trustee · Grinnell, IAN4BHHerrick Brett · Columbus, INN502WBFischer James E · Lakeville, MNN503JDRegistration Pending · Tualatin, ORRegistration pendingN504JEBadding Jeffrey P · Wauwatosa, WIN505VRTallent Nita G · Wheatland, WYN506ALCulver Edward A · Greenleaf, IDN51199Sigg Keith A · Olympia, WAN511MMCane Creek Aviation LLC · Fletcher, NCN511PNNiewenhuis Dennis R · Corsica, SDN512RVWinters Andre · Pennsburg, PAN512SGHambly Heather M · Richfield, WIN512SKLee Ernest D · Independence, ORN512SVVan Den Broeke Steven E · Camino, CAN513LJMoffitt David R · Port Angeles, WAN514STMorse Rick L · Columbia, SCN521HCMusketeer LLC · New Iberia, LAN523GTMartinson Dean O · Estes Park, CON525ATBlount Parker · Reidsville, GAN529RPDamschroder Alexander R · Port Clinton, OHN532UBStandage-Beier Wylie S · Phoenix, AZN533EBlake James D · Galesburg, ILN5386CLudwig Consulting LLC · Billings, MTN544JSShannon John P · Walla Walla, WAN545BFFive Brothers Flying Adventures LLC · Huntsburg, OHN551CGWhp Holdings LLC · Rochester, MI
Back to Vans RV-12