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.
N73172American Patrols Inc · Midland, TXN73174Welch Cleatus E · Orlando, FLN73178G P Holding Inc · Mora, MNN73179Weengknutts 179 · Delta, UTN73181Nurse Alex S · San Diego, CAN73183Sandwich Aviation Inc · Somonauk, ILN73189Ellie Air LLC · Mabank, TXN73190Flying J Enterprises LLC · San Antonio, TXN73192Nationwide Aviation LLC · Hudson Oaks, TXN73195Saratoga Flyers Inc · South Glens Falls, NYN73197Seward Kent · Parma, IDN73198Davis Jimmy R Jr · Wharton, TXN73199Performance Polymer Technologies LLC · Roscommon, MIN73200Burns Kurtis L · Clyde Park, MTN73209Goldberg Peter S · Eagle River, AKN73213Haig Gene · Palatine, ILN73250Skaya Aircraft LLC · Buford, GAN73254Swensen Jason D · Norfolk, NEN73262Air Spacers Inc · Santa Monica, CAN73267Schutze Eric D · Ojai, CAN73289Correggio James · Shapleigh, MEN73293Shawano Flying Service Inc · Shawano, WIN73294G And G Maintenance Corp · Miami, FLN73295Whitten Chris D · Townville, SCN73296Han Farms Inc · Inverness, MTN73298Castelan Luis E · Irving, TXN73306Boomer Aviation Inc · Fort Walton Beach, FLN73307Ftk Aviation LLC · Evans, GAN73311184 Flying Club Inc · Concord, CAN73312Murray Air LLC · Patoka, ILN73317Bell Susan J · Georgetown, CAN73318Lair De Rien Aviation Inc Trustee · Wilmington, DEN73319My Way Aviation LLC · Weston, FLN73321Learn To Fly Nola LLC · New Orleans, LAN73324Gulf Atlantic Airways DBA · Gainesville, FLN73330Thornton Ralph · Oxford, ALN73331Dameron Cleveland F · Wicomico Church, VAN73334Heavy Metal Air LLC · Farmingdale, NYN73338Einarson Flying Service · Intl Falls, MNN73345N73345 Aviation LLC · Sheridan, WYN73354Sky Partners LLC · Sylacauga, ALN73357Aerospace Trust Management LLC Trustee · Wilmington, DEN73361Snyder Steven S · Norfolk, VAN73362Spanaflight LLC · Puyallup, WAN73365Toliver David R · Lenexa, KSN73367Martinez Jose Antonio · Orlando, FLN73370Bay Flying Services LLC · Pinconning, MIN73371Elliott Aaron · Scott City, KSN73381Wings Over Texas Holdings LLC · Denton, TXN73383Ludington Rental LLC · Ludington, MI
Back to Cessna 172M