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 ('2072401')
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 ('2072401')
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.
N829BWBridgewater State University · Bridgewater, MAN829FSPerformance Aircraft Sales Inc · Lincoln, NEN8348MWings Over Texas Holdings LLC · Denton, TXN83AFN83af LLC · Stuart, FLN852CPPmbarrett Aviation LLC · Tucson, AZN855CPVector Air LLC · Erie, CON858CPDae Aviation Enterprises Corp · Gilford, NHN859CPN859cp LLC · Boynton Beach, FLN860CPChristiansen Aviation LLC · Wilmington, DEN862CPN862cp LLC · Stuart, FLN865CPAmr Holdings LLC · Kalispell, MTN869CPExecutive Flight Institute LLC · Murrieta, CAN86BJWings Over Texas Holdings LLC · Denton, TXN870CPAvolant Aviation LLC · Mooresville, NCN871CPRedstone Arsenal Flying Activity · Redstone, ALN872FALewis University · Romeoville, ILN872FSTfs Air LLC · Loveland, CON879MTCfgn Aviation LLC · Molalla, ORN87GVChristiansen Aviation LLC · Wilmington, DEN886ABWings Over Texas Holdings LLC · Denton, TXN886CTCoast Flight Training And Management Inc · San Diego, CAN89005Singh Fiyaad · Ocoee, FLN890KCMustang Sally Aviation LLC · Camden, SCN900CAAtp Aircraft 1 LLC · Wilmington, DEN909DBN909db Aviation Services LLC · Colorado Springs, CON90FLTegridy Equipment Leasing LLC · Aurora, ORN911LAMindy Limited LLC · Muscatine, IAN913MAKennedy Michael J · Gilbert, AZN916TAAtp Aircraft 4 LLC · Wilmington, DEN91934N91934 LLC · Evergreen, CON91936Oklahoma State University · Stillwater, OKN91966Wings Over Texas Holdings LLC · Denton, TXN9196WOklahoma State University · Stillwater, OKN9198WOklahoma State University · Stillwater, OKN91996Oklahoma State University · Stillwater, OKN9199ZOklahoma State University · Stillwater, OKN919TAAtp Aircraft 4 LLC · Wilmington, DEN91FSEastern Kentucky University · Richmond, KYN92004Oklahoma State University · Stillwater, OKN9200BChristiansen Aviation LLC · Wilmington, DEN9202UOklahoma State University · Stillwater, OKN920CFWingsleasing LLC · Wichita, KSN920TAAtp Aircraft 4 LLC · Wilmington, DEN921TAAtp Aircraft 4 LLC · Wilmington, DEN9229FCooke John W III · Carthage, TXN922TAAtp Aircraft 4 LLC · Wilmington, DEN925MHAir America Imagery LLC · Daytona Beach, FLN928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeN92FSEastern Kentucky University · Richmond, KYN92LCEastern Kentucky University · Richmond, KY
Back to Cessna 172R