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 ('1153408')
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 ('1153408')
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.
N8595MMohle Darren · Carlsbad, CAN8613MPray Aviation Inc · Augusta, KSN8801MStein Bruce A · Punta Gorda, FLN8813MMja Flight LLC · Justin, TXN8831MMcmeekin Robert R Jr · Bethesda, MDN8847MTravel Air LLC · Chico, CAN88ACSegerstrom William C · Sunriver, ORN8928MKeyt Jeffrey D · New Providence, NJN8950MPacific Flight Academy LLC · Honolulu, HIN8950UManley Steven T · Dallas, TXN8979MBean George W Jr · Fort Worth, TXN8RBMckeen John C · Santa Clarita, CAN9416SAllen Roger B · Gardnerville, NVN948TPray Aviation Inc · Augusta, KSN959GSSanders Aviation Inc · Jasper, ALN95BEAmundson David Owen · Sioux Falls, SDN95DJSanders Aviation Inc · Jasper, ALN95HJSkyview Aviation LLC · Benton, KYN95KKGrimes Chris · Hudson, NYN95WTDs Flight Services LLC · Battle Ground, WAN95YWhite Tavis · Huntsville, ALN969MGRas Aviation LLC · Elyria, OHN998DMD & S Aviation LLC · Spring, TX
Back to Beech D95A