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 ('2072436')
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 ('2072436')
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.
N99040Bradley Aircraft Company LLC · Columbus, INN99045Allen Michael R · Graham, NCN9906LRiseaero LLC · Florence, SCN99100Sterling Flight Training LLC · Jacksonville, FLN99104Dury Aviation Services Inc · De Soto, ILN9912LCivil Air Patrol Inc · Maxwell Afb, ALN99141Airgo Inc · Centralia, ILN9914LFlex Air Holdings Inc · Manhattan, KSN99157Hess Garrett J · Fullerton, CAN99171Airlake Aero Inc · Lakeville, MNN99243Wings Over Texas Holdings LLC · Denton, TXN99253Mitiguy Aviation LLC · Stow, MAN99263Wings Over Texas Holdings LLC · Denton, TXN99265St Pete Aviation Services LLC · Saint Petersburg, FLN99273United States Air Force · Dover Afb, DEN99295Sky Warrior Flight Training Inc · Pensacola, FLN99329Tactical Integrated Training Soluctions LLC · San Antonio, TXN99338Civil Air Patrol Inc · Maxwell Afb, ALN99341Jlinn Aviation Inc · Quinlan, TXN99344Global Tours & Travel Services LLC · Davie, FLN99347Skywarrior Flight Training Inc · Pensacola, FLN99377Barta Terry · Faribault, MNN99396Flightline Air Service LLC · Pineville, LAN99442Sale Reported · Kissimmee, FLSale reported, pending cancellationN99465Farzam Hamid · Newington, CTN99467Civil Air Patrol Inc · Maxwell Afb, ALN99508Lee Randall Ross · Houston, TXN99517Civil Air Patrol Inc · Maxwell Afb, ALN99527Delta State University · Cleveland, MSN99532Civil Air Patrol Inc · Maxwell Afb, ALN99553Jka LLC · Notasulga, ALN99583Motz Gary A · Bemidji, MNN99589Kingsky Flight Academy LLC · Lakeland, FLN99598Registration Pending · Argyle, TXRegistration pendingN99606Civil Air Patrol Inc · Maxwell Afb, ALN9964LHess Garrett J · Fullerton, CAN9968LMw Flying LLC · Sanford, NCN99697Sky High Leasing Services LLC · Lakeland, FLN99700Lee Rich · Carlsbad, CAN99709Long Island Aviators LLC · Seaford, NYN99712Nesher Aviation II LLC · Jacksonville, FLN99715N99715 LLC · Wheeling, ILN99725Holladay Aviation LLC · Jacksonville, FLN99744Christiansen Aviation LLC · Wilmington, DEN99750Kool Wings Leasing LLC · Indianapolis, INN99759Civil Air Patrol · Maxwell Afb, ALN99765Tactical Intergriated Training Solutions LLC · Colorado Springs, CON99770Civil Air Patrol · Maxwell Afb, ALN99783Alexander Todd · Westhampton, MAN99826Cp Aviation · Santa Paula, CA
Back to Cessna 172P