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.
N4429QDyberg Mike DBA · Mount Vernon, WAN4429RMacoupin Flyers Inc · Hettick, ILN442HBAirborne LLC · Wilmington, DEN4430RDunder Neil DBA · Cicero, INN4431QGraham Huber L · Gulf Breeze, FLN4431RRaritan Valley Flying School · Princeton, NJN4432RBend Aircraft Mechanics LLC · Bend, ORN4433QTwo Dog Enterprises Inc · Madison, WIN4434QFaires Kelly C · Cedartown, GAN4434RAll American Aviation LLC · Fort Worth, TXN4436QVan Hoomissen Thomas J · Anchorage, AKN4436RDoran Kenneth J · Twisp, WAN4441RAtwood Flying Club · Atwood, KSN4446RSiler Jerry L · Eau Claire, WIN4447QWolter Dennis R · Cincinnati, OHN444EEVaughn Stewart C · West Jordan, UTN4452RZitting Fredrick J · Colorado City, AZN4453RJackson Robin D · Harlan, IAN4454RDekle Drew · Athens, GAN4456RTruskey David R · Dauphin, PAN445RDensmore John L · Conway, WAN4462RLockwood Ronald D · Filer, IDN4464RT-Craft Aero Club Inc · Nampa, IDN4465RCk Leasing Services LLC · Wilmington, DEN4466RFletcher William J · Washougal, WAN4467RBrackett David E · Line Lexington, PAN4468RSchmitt Dillon Allen · Caledonia, MIN4472RFlyrite Aviation LLC · Fort Myers, FLN4473RMiller Keith A · Reedy, WVN4479RUp And Up Aviation LLC · Magnolia, TXN4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNN4482RBarxbar Aviation LLC · Mesa, AZN4486RAurora Aviation Lc · Pierce City, MON4488RSmith Byron L · Bourbon, INN4493RBarnstormers Inc · Bemidji, MNN4495RKohl James D Trustee · Deerfield, ILN4497RMazurek Drew A · New Haven, CTN44DMGorge Winds Aviation Inc · Fairview, ORN454BMCorman David L · Lovington, ILN4574VSmtm Holdings Inc · Wilmington, DEN457BCMorris Thomas Z Trustee · Spokane Valley, WAN457SKWorld Marketing Syndicate I · Wilmington, DEN46085Davenport Jimmy J · Hayesville, NCN46091Pilot Instructional Center LLC · Kansas City, MON4609QN4609q LLC · Opa-Locka, FLN4610QBlaire William C · Rch Palos Vrd, CAN4613QSouth Seattle College · Seattle, WAN46189Mcdonald Gerald T · Imogene, IAN46262Lautner Elden B · Kaleva, MIN46299Van Anda Aviation LLC · Apopka, FL
Back to Cessna 172M