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 ('2072730')
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 ('2072730')
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.
N9135GRay James O III · Mc Rae, GAN9136GFredenburg Kenneth D Trustee · Gilroy, CAN9137GGulf Coast Helicopters Inc · Pearland, TXN9142GRegistered aircraftN9144GZimmerman Paul B · Haswell, CON9145GYost James J · Placentia, CAN9146GShea Bernie J · Polson, MTN9147GSnyder Barry L · Morrison, CON9161GBowling Gary L · Elk City, IDN9163GHayssen Arthur H · Sebastopol, CAN9164GZirjacks Winston L Jr · Gold River, CAN9167GKgrd Aviators LLC · Greenwood, SCN9168GClark Byron · Olympia, WAN9169GDodson International Parts Inc · Rantoul, KSN9174GSmith Daniel · Whittier, NCN9182GPetersen Danny S · Caddo, OKN9191GFischer Gary H · Savannah, GAN9192GWg Aero LLC · Shreveport, LAN9196GJohnson Judith A · Sedro Woolley, WAN9197GWheeler Dealer LLC · Wilmington, DEN9198GDuckflyway LLC · Herscher, ILN9200GNoya Charles J · Albuquerque, NMN9207GSundin James B · Kahului, HIN9208GAdams Shane M · Jonesborough, TNN92147Bielstein David P · Plainville, GAN9214GOwens Joseph F · Tallahassee, FLN92150Pessolano Vincent F · Naples, FLN92151Adiabatic Adventures LLC · Morrison, CON92152Pank Thomas E · Walkersville, MDN92158Ackerman Jefferson P · Beaufort, SCN9216GComdess Company Inc · Seville, OHN92172Fly Like An Eagle LLC · Springfield, MON92175Richards Joseph · Gardiner, NYN9217GRegister Otis E · Rolla, MON92180Mahanti Robert L · Flagstaff, AZN92183Desselle Trent · New Orleans, LAN92184Aviatrix Adventures LLC · Tallahassee, FLN92187Med Eagle LLC · Folsom, CAN9218GTpec LLC · Madison, MSN92190Rimkus Fisher · Rio Frio, TXN92193Hendricks Alan M · Greenville, TXN92198Hanson Steven Dale · Livermore, CAN92207Eason William E · Gloucester, MAN92208Full Throttle Aviation LLC · Nashville, ARN92209Stanton Gregory R Jr · Newport, ORN92214Sfh Aviation LLC · Birmingham, MIN92215Indian Lakes Aviation LLC · Cedar Springs, MIN9223GWilson John L · Winchester, KYN9224GB9224g LLC · Carthage, NCN92262William Syme Alexander Howie Trustee · Bozeman, MT
Back to Cessna 182N