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 ('7103201')
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 ('7103201')
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.
N1059FRandag William F Jr · El Paso, TXN1063LWjm Aviation LLC · North Wales, PAN168FReading Aero Club Inc · Reading, PAN187TPR G R Holdings LLC · Spring Branch, TXN3121VCochise Community College · Douglas, AZN3126WHawaii Pacific Aviation Inc · Kailua Kona, HIN341TAUnited States Of America · Travis Afb, CAN396AGSkywest Leasing Inc · St George, UTN430RMRocky Mountain College · Billings, MTN467AArcher Aircraft LLC · Wilmington, DEN486MAOrange Wing Aviation Inc · Wilmington, DEN635KCCavorite Aviation LLC · West Jordan, UTN639STVector Aviation LLC · Mentor, OHN676MMButler Nathaniel J · West Fargo, NDN69TZUnder The Radar LLC · Henderson, NVN709CAChristiansen Aviation LLC · Wilmington, DE
Back to New Piper PA-28-181