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.
N800MDPark Whitney Foutz · Boulder, CON8014EHutton Steve · Saint Helens, ORFirst renewal noticeN8025EMission Aviation Fellowship · Nampa, IDN802DDN802dd Corp Trustee · Wilmington, DEN803BTLouisville Aircraft Leasing LLC · Louisville, KYN804BLFlores Omar Javier · New Braunfels, TXN8050EPerun Av LLC · Cliffside Park, NJN80628Goyne Gregory Ashley · Wrangell, AKN8062EAviation Specialized Services LLC · Lewisville, TXN806DAPeak Leasing LLC · Anchorage, AKN8073EOcean Aviation Inc · Berlin, MDN8074EN8074e LLC · Jackson, NJN8077ESws Aviation Services Inc · Titusville, FLN8082EAviation Access LLC · Van Nuys, CAN8085EMcdonald Douglas A · Falls Church, VAN8089ESkywarrior Flight Training Inc · Pensacola, FLN8098ERegistered aircraftN-number assigned, not yet registeredN809STDiaz Natanael Luna · Toa Baja, PRN80FPCarastro Enterprises LLC · Montgomery, ALN810FSModi Yogini · Homestead, FLN810SUApm Leasing LLC · Casper, WYN811BJSix Pack Aviation LLC · Pocono Pines, PAN8126EAnderson Wilbur W Trustee · Lead Hill, ARN812CPHigh Wing Air Services LLC · Merritt Island, FLN812DAHanson Aviation LLC · Winter Park, FLN816LGGray James · Jupiter, FLN816RARochester Air Center LLC · Canandaigua, NYN8173ESky Equity LLC · Woodbury, MNN8182ERed Arrow Aviation LLC · Santa Teresa, NMN8184GAspire Aviation LLC · Farmingdale, NYN8208EChamplain Island Hoppers · Burlington, VTN82149Sanders Flight Training Center Inc · Jasper, ALN8236GVinton Timothy R · Whitman, NEN8243EMacon Air LLC · Franklin, NCN8259GCappello Dave Allen · Cottonwood, CAN825ERFlying Aces Aero-Fleet Inc · Guyton, GAN8266EPropel Air LLC · Pottstown, PAN8268ERegistration Pending · Richlands, NCRegistration pending, pending cancellationN8269EBucher Max · Fort Mohave, AZN8274EChristiansen Aviation LLC · Wilmington, DEN8276ESkyview Aviation LLC · Tracy, CAN8278EEquinoxx Flight Systems LLC · Lawrenceville, GAN8279EHull Farms Inc · Blythe, CAN8281EAir Plains Services Corp · Wellington, KSN8285EJames G Loy General Contractor Inc · Punta Gorda, FLN8286EPreston Richard R Trustee · Albuquerque, NMN8288EGomez Cierra D · Jasper, ALN828YLong Island Aviators LLC · Seaford, NYN8291ERangers Flying Club Inc · Eden Prairie, MNN8292EP&N Corp · Marion, IA
Back to Cessna 172N