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 ('2073456')
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 ('2073456')
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.
N9894YRaymond Andy · Council Bluffs, IAN9909NMorgan Vernon E · Dillon, CON9922YInfinite Wings LLC · Henderson, NVN9923YPostupack Peter Jr · New Cumberland, PAN9926NBelchak Timothy A · Albuquerque, NMN9928YEckelkamp L B Jr · Washington, MON992PSProctor Gary · Wichita, KSN994CDNavair LLC · Mount Vernon, OHN9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeN9963YN9963y LLC · Provo, UTN9964YGreenspun Mark H · Washington, DCN9968NBuhannic Patrick A · Shepherdstown, WVN9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLN9991YArwlb Aviation LLC · Spokane, WAN99YZEdwal Aviation LLC · Reno, NV
Back to Cessna T210N