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 ('138470A', '138469A')
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 ('138470A', '138469A')
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.
N37562United Airlines Inc · Chicago, ILN37563United Airlines Inc · Chicago, ILN37567United Airlines Inc · Chicago, ILN37577United Airlines Inc · Chicago, ILN37605Boeing Co · Renton, WAN469AMUmb Bank Na Trustee · Salt Lake City, UTN47412Wilmington Trust Co Trustee · Wilmington, DEN47434Umb Bank Na Trustee · Salt Lake City, UTN47446United Airlines Inc · Chicago, ILN47453Umb Bank Na Trustee · Salt Lake City, UTN47457Umb Bank Na Trustee · Salt Lake City, UTN47462United Airlines Inc · Chicago, ILN47470Wilmington Trust Co Owner Trustee · Wilmington, DEN47505United Airlines Inc · Chicago, ILN47512United Airlines Inc · Chicago, ILN47517Wilmington Trust Co Trustee · Wilmington, DEN47524Wilmington Trust Co Trustee · Wilmington, DEN47533United Airlines Inc · Chicago, ILN47569United Airlines Inc · Chicago, ILN47570United Airlines Inc · Chicago, ILN499AMUmb Bank Na Trustee · Salt Lake City, UTN569AMUmb Bank Na Trustee · Salt Lake City, UTN57409Wilmington Trust Co Trustee · Wilmington, DEN57416United Airlines Inc · Chicago, ILN57451Umb Bank Na Trustee · Salt Lake City, UTN57466United Airlines Inc · Chicago, ILN57478United Airlines Inc · Chicago, ILN57480Wilmington Trust Co Trustee · Wilmington, DEN57604Boeing Co · Renton, WAN67481Umb Bank N A Trustee · Salt Lake City, UTN67501United Airlines Inc · Chicago, ILN67603Boeing Co · Renton, WAN703ALAlaska Airlines Inc · Seattle, WAN704ALBca Customers Finance Inc · Renton, WAN705ALAlaska Airlines Inc · Seattle, WAN706ALAlaska Airlines Inc · Seatac, WAN707ALAlaska Airlines Inc · Seatac, WAN708ALAlaska Airlines Inc · Seattle, WAN709ALBank Of Utah Trustee · Salt Lake City, UTN710ALAlaska Airlines Inc · Seattle, WAN712ALAlaska Airlines Inc · Seattle, WAN713ALAlaska Airlines Inc · Seattle, WAN716ALAlaska Airlines Inc · Seattle, WAN719ALAlaska Airlines Inc · Seattle, WAN720ALAlaska Airlines Inc · Seattle, WAN722ALAlaska Airlines Inc · Seatac, WAN723ALAlaska Airlines Inc · Seatac, WAN724ALAlaska Airlines Inc · Seattle, WAN725ALAlaska Airlines Inc · Seattle, WAN729ALAlaska Airlines Inc · Seattle, WA
Back to Boeing 737-9