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.
N739DFMorcom Aviation Services Inc DBA · Everett, WAN739DJKemp Kerm R · Southwest Ranches, FLN739DPMoler Darryll M · Mount Orab, OHN739DRCenterline Holdings LLC · Belgrade, MTN739DTWheelair Inc · Fairfield, CAN739DWKayo Air Service Inc · Harlingen, TXN739DXRegistration Pending · Glendale, CARegistration pendingN739DZFerrari Thomas J · Torrance, CAN739EAVpc Air Inc · Cartersville, GAN739EFDyberg Mike · Mount Vernon, WAN739EHDairy Air Inc · Wyoming, PAN739EKParker Dean · Rawlins, WYN739EPLucci Giacinto A · Nashville, MIN739ERSmitty 172 LLC · Rockford, MIN739ET2035 Holdings LLC · Las Vegas, NVN739EUStar Fleet Aviation LLC · New Albany, OHN739EYLease Aviation Inc · Waterford, MIFirst renewal noticeN739EZLow Flying Angels Inc · Folsom, CAN739FCAri Ben Aviator Inc · Fort Pierce, FLN739FDHutchinson Johnny M · Blytheville, ARN739FGWings Flight Enterprises Inc · Danville, KYN739FHR&R Aero Services LLC · Eden Prairie, MNN739FMRegistration Pending · Concord, NCRegistration pendingN739FNRussell David P · Owensboro, KYN739FPTmw Aviation LLC · Portland, ORN739FSLindsay Aviation Inc · West Seneca, NYN739FTWings Of Her Dreams Aviation LLC · Belton, TXN739FU9fu LLC · Anchorage, AKN739FYSanford Aircraft LLC · Winter Springs, FLN739FZSorbi Aviation Inc · El Cajon, CAN739GCSavage Dewey M · Newport Beach, CAN739GDMidwest Trucking Transport Inc · Willowbrook, ILN739GEAllnew Enterprises Inc · Scotch Plains, NJFirst renewal noticeN739GFDahl Peter · Webster, MNN739GGRaptor Aviation LLC · South Saint Paul, MNFirst renewal noticeN739GHGreer Stephen R · Rowlett, TXN739GQMelbourne Flight Training LLC · Melbourne, FLN739GSCke Aviation LLC · Marietta, GAN739GUKimrey Norman Harold · Springdale, ARN739GVQuarter To Two Flying Club Inc · Williamsport, PAN739GXMusic City Air LLC · Rogersville, ALN739GYRadecki Francis R · Carmichael, CAN739HCGc Aviation Services-1 LLC · Miamisburg, OHN739HDRoseland Dan E · Sonoma, CAN739HETakai Hiroyasu · San Jose, CAN739HHAbove And Beyond Aviation LLC · Austin, TXN739HKSouthwest Aeronautics Mathematics & Science Acad · Albuquerque, NMN739HPHawaii Pacific Aviation Inc · Kailua Kona, HIN739HSOrange County Flight Center Inc · Santa Ana, CAN739HX739hx LLC · Jackson, MI
Back to Cessna 172N