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 ('5460133')
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 ('5460133')
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.
N18PRDenicola Frank · Visalia, CAN274SJList Chad C · Soldotna, AKN2VBParker Grant F · Elgin, ORN311ECLinton Andrew M · Black Mountain, NCN498XASpringer Larry E · Bothel, WAN50GACantrell James E Trustee · Madison, GAN51587Werner Platte River Crossings Lp · Douglas, WYN51602Krebs Martin C · Miami, FLN51619Isabella Ralph N · Delanson, NYN51620Bork Joseph L · Mosier, ORN51621Johnson Lucas G · Pleasant Lake, MIN51626Silvey Brandon · Cascade, IDN51629Phillips Aaron W · Fort Scott, KSN51638Janczak Gillian · Golden Valley, AZN51647Feuerborn Ethan T · Boise, IDN55LETimmreck Joseph P · Anchorage, AKN62002Bieniek Joseph D · Fergus Falls, MNN62007Meche Russell P · Rayne, LAN62013Andersen Steve · Albert Lea, MNN62017Bond Kelly J · Wasilla, AKN62020Chardon Stephen A · Franconia, NHN62021Biotech Travel LLC · Pima, AZN62026Opsal Eric J · Williston, NDN62027Burkart John L · Angwin, CAN888RFTao Engineering · Groveland, CAN913VBCafarelli Peter · Livingston, TXN91PTClark Daniel E · Rio Linda, CA
Back to Maule M-5-220C