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 ('1384969')
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 ('1384969')
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.
N451UPUnited Parcel Service Co · Louisville, KYN452UPUnited Parcel Service Co · Louisville, KYN453UPUnited Parcel Service Co · Louisville, KYN454UPUnited Parcel Service Co · Louisville, KYN455UPUnited Parcel Service Co · Louisville, KYN456UPUnited Parcel Service Co · Louisville, KYN457UPUnited Parcel Service Co · Louisville, KYN458UPUnited Parcel Service Co · Louisville, KYN459UPCc & Ei LLC · Louisville, KYN460UPC C & E I LLC · Louisville, KYN461UPUnited Parcel Service Co · Louisville, KYN462UPUnited Parcel Service Co · Louisville, KYN463UPUnited Parcel Service Co · Louisville, KYN464UPUnited Parcel Service Co · Louisville, KYN465UPUnited Parcel Service Co · Louisville, KYN466UPUnited Parcel Service Co · Louisville, KYN467UPUnited Parcel Service Co · Louisville, KYN468UPUnited Parcel Service Co · Louisville, KYN469UPUnited Parcel Service Co · Louisville, KYN470UPUnited Parcel Service Co · Louisville, KYN471UPUnited Parcel Service Co · Louisville, KYN472UPUnited Parcel Service Co · Louisville, KYN473UPUnited Parcel Service Co · Louisville, KYN474UPUnited Parcel Service Co · Louisville, KYN475UPUnited Parcel Service Co · Louisville, KY
Back to Boeing 757-24APF