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.
N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEN711UATuthill Andrew M · Etna, NHN711WEMelbourne Flight Training LLC · Melbourne, FLN712DAlpha Aviation LLC · Dalhart, TXN713SJKoerner James L Trustee · Gilbert, AZN7140JCohesive Aviation LLC · Gilford, NHN7141JHutt Aviation Inc · Minden, NVN7151JLenticularis LLC · Madison, WIN717GMustang Sally Aviation LLC · Camden, SCN717MEMotormod LLC · Florence, SCN717RFWings Flight Enterprises Inc · Danville, KYN7225VConnecticut Aircraft Sales LLC · Manchester, CTN723GPuerta Jose Fernando Del Valle · Miami, FLN725BBScenic Concepts LLC · La Crosse, WIN725ZNLaramie Flying Club Inc · Laramie, WYN7266DMelbourne Flight Training LLC · Melbourne, FLN726JHClearview Flying Club Inc · Westminster, MDN726MMRiverside Flight Academy LLC · Riverside, CAN727METruesdell Shannon · Stephenville, TXN727TLLangebrake Lawrence C · Saint Petersburg, FLN728KGCapsed LLC · Mojave, CAN729JHDickman Robert J · Richmond, INN72ERMaierhoffer Henry F Jr · Sylvania, GAN72NXNexair Avionics LLC · Plymouth, MAN72SAInternational Air Services Inc Trustee · Carson City, NVN72STSierra Tango Air LLC · Senoia, GAN7306EG & M Aircraft Inc · Wheat Ridge, CON7319DN7319d LLC · Port Saint Lucie, FLN7320FRick Aviation Inc · Newport News, VAN7320JNextgen Flight Academy Inc · Riverside, CAN7326EMountain South Aviation LLC · Telford, TNN7333FHickle William H · Inyokern, CAN7334FWings Flight Enterprises Inc · Danville, KYN7338FKyle Aviation Services LLC · North Charleston, SCN7339FLambright Kevin L · Shipshewana, INN733ABKalman Engineering Inc · Pekin, ILN733ADMarshe Aviation LLC · Upland, CAN733AEMackey Aviation LLC · Talking Rock, GAN733AGRick Aviation Inc · Newport News, VAN733AHAltus Aircraft LLC · Taylor, TXN733AJ578 Airplane Leasing Inc · Kissimmee, FLN733AKParker Helicopters Inc · Watsonville, CAN733AMGlendale Community College · Glendale, CAN733ANAtlas Epigrin Aviation LLC · Austin, TXN733AQCrankshaft Aviation LLC · Pine River, MNN733ATAlpha Tango LLC · Lake Village, ARN733AVPdm Aviation LLC · Greencastle, INN733AWKaiser Eric J · Milford, INN733AYFord Eagles Inc · Plymouth, MIN733AZTactical Integrated Training Solutions LLC · San Antonio, TX
Back to Cessna 172N