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 ('2072418')
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 ('2072418')
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.
N92035Ford Daniel T · Warsaw, INN920AJAmerican Patrols Inc · Midland, TXN92103Pgd Flyers Inc · Cape Coral, FLN9210HFlex Air Holdings Inc · Wilmington, DEN92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYN92141High Flight Academy LLC · Allison Park, PAN92159Buster Aviation LLC · Harveys Lake, PAN92161Skywarrior Flight Training Inc · Pensacola, FLN92169Welch William Ben · Danville, ILN9216HBurgess Alan P · Corona, CAN9219HKful Flyers Foundation Inc · Fullerton, CAN921AARegistration Pending · Deland, FLRegistration pendingN9223HHallock Robert C III · Sag Harbor, NYN92255Kloker Daniel E · Owasso, OKN9226HDebt LLC · Yuma, AZN922EAButler Ronald A · Cumming, GAN92306High Wingers Inc · Racine, WIN92307Lowcountry Flight LLC · Johns Island, SCN92318Flitepro Inc · Murrieta, CAN92324Pea-Wayman Flight LLC · Daytona Beach, FLN92356Hub City Aviation Academy LLC · Lubbock, TXN9236HOptic Air LLC · Sioux Center, IAN9240HPropability One LLC · Daytona Beach, FLN92424Christiansen Cortland · Bakersfield, CAN9242HRoland Aviation LLC · Gualala, CAN9243HSeward Air Taxi LLC · Seward, AKN92445Pureflight Aviation Training LLC · Newberg, ORN92447American Patrols Inc · Midland, TXN92448Eckholt John · Forest Grove, ORN9244HCoachron Investments LLC · Grosse Ile, MIN92471Shoemaker Floyd · Oneida, TNN9249HGencur Paul A · Hudson, OHN9252HStratus Aviation LLC DBA · Vacaville, CAN92548Pulliam Richard W · Henryetta, OKN9254HShipley Donald E · Alpine, TXN92570Becker Steven H · Prescott, AZN92595Bearfight Aviation LLC · Dover, DEN9259HBooke Phillip Austin · Anniston, ALN925CBDhani Errol · Locust Grove, GAN92617Stahl Raifen · Anchorage, AKN9261HSchrom Frederick A · Carlisle, PAN9262HAero Maintenance Inc · Vancouver, WAN9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNN9265HCleveland Douglas P · Live Oak, FLN9269HLargen Gregory K · Benton, KSN92704Gull Wing Flight LLC · Pt Pleas Bch, NJN92720Registration Pending · Champaign, ILRegistration pendingN92722Bryant David A · Walhalla, SCN9272HBlackbird 71 LLC · Rockford, ILN92747Wiles Donald · Shrewsbury, MA
Back to Cessna 172M