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 ('2072734')
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 ('2072734')
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.
N9173CBettendorf Nicholas L · Mchenry, ILN9178CKelly Randall Shawn · Rocklin, CAN9187CKd3262 LLC · Downers Grove, ILN9187RMih LLC · Birmingham, ALN9200CShepard Philip A · Trophy Club, TXN920SBDream Cloud Aviation LLC · Saint Marys, PAN9212CMyers Kenneth O · Niskayuna, NYN9218CArensmeyer Michael W · Longmont, CON921KPCenturion N709jm LLC · Minneapolis, MNN9222RWellman A Ryan · San Jose, CAN925PBRegistered aircraftN9260RVroom David H · Oro Valley, AZN9271RUpwind Aviation LLC · Mitchell, SDN92RZSale Reported · Gold Canyon, AZSale reportedN9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeN9360RWaggener Chris E · Clyde, NCN9442RPauly Jeff D · Watkins, MNN945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN9487RBoyer Air Lc · West Des Moines, IAN958SBVictor Foxtrot LLC · Scott City, KSN959BWRegistered aircraftN96WPVanneman William M · Ludlow, VTN977LAGillian Michael Thaddeus · Chicago, ILN980HPTopher Enterprises LLC · Bucyrus, KSN980JKKoskan John M · Wood, SDN9827CKae Aviation LLC · Conover, WIN9834CN8184h LLC · Thiensville, WIN9836CDominguez Robert R · Temecula, CAN9838CWellman A Ryan · San Jose, CAN983VBKaufman Jeffrey Robert · Chapel Hill, NCN9840CMid Atlantic Ag LLC · Nassau, DEN9842CSale Reported · Belgrade, MTSale reportedN9848CBudd Richard E · Brooksville, FLN9849C377 Morale Welfare Recreational Services Aero Club · Albuquerque, NMN9851CDodson International Parts Inc · Rantoul, KSN9852CRyco LLC · Lusk, WYN9861CBell Richard H · Blairsville, GAN9864CAerowest LLC · Wilmington, DEN9869CSouthern Star Holdings LLC · Safety Harbor, FLN9886CAlm Ronald · Kuna, IDN9887CLeonard Paul A Jr · Grand Beach, MIN9888CLoehde Thomas · Lolo, MTN988MTurecek Peter J · Fairfield, CTN98GPHammack Philip Scott · Canton, MSN9907CBlue Marlin LLC · Kalispell, MTN9947CLoftin Aviation Group LLC · Suwanee, GAN9955CBrenna Matt R · Austin, TXN9967CJoemac Business Services LLC · Casper, WYN9968CPaulin Gregory H · Flagstaff, AZN9969CAttitude Indicators LLC · Allegan, MI
Back to Cessna R182