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 ('2071828')
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 ('2071828')
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.
N6096JCurrivan Robert B · Fort Mohave, AZN6098JHall David K · State College, PAN6099JVincent David R · Hartley, TXN6120FHickman Robert J · Canby, ORN6135FJr Imaging Logistics Inc · Pasco, WAN6140FFluno John I · San Rafael, CAN6145FAlpha Bravo Aviation LLC · Trophy Club, TXN6146FHeppner Sebastian · Fishers, INN6155FHalladay Roy · Erie, CON6157FLa Placa Peter · Lake Havasu City, AZN6167FJohnson Susan J · Chelan, WAN6188FSky High Adventures LLC · Wilmington, DEN632EHHuddleston Edward L · Oaktown, INN634EHEd-Air Inc · Oaktown, INN6436FOrnelas Miguel A · Tucson, AZN6438FRegistration Pending · Everett, WARegistration pendingN6503FStockton Ketron J · Bulls Gap, TNN7837FObrien Daniel N Jr · Bellevue, WAN7949FMaciol Michael W M D · Pelham, NYN8123LShippee Norman J · Foster, RIN8189FArchuleta Michelle L · Las Cruces, NMN90PPN90pp LLC · Titusville, FLN9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeN9906GNielson Donald L · Independence, ORN9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLN9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeN9914GKunas Matthew · Akron, OHN9922GAguilar William A · Puyallup, WAN9934GDiorio Christopher J · Melba, IDN9976GAbernethy Joe H · Hickory, NC
Back to Cessna A150L