Skip to content

Registered aircraft · 12

Aircraft of this model in the FAA registry, by N-number.

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 ('1850120')
  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 ('1850120')
ORDER BY n_number

Run 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.

N3571GMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 1080 N3572GHauser Linda · Ulysses, KSBuilt 1964 · S/N 1081 N3573GDuran Robert J · Fort Lupton, COBuilt 1964 · S/N 1082 N7220VRidgway Rick J DBA · Carlisle, INBuilt 1965 · S/N 1257 N8246HLake Elsinore Soaring Club · Wildomar, CABuilt 1965 · S/N 1119 N8264HAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 1137 N8272HMorten Jesse L · Larimore, NDBuilt 1965 · S/N 1145 N8278HCedar Hill Aviation Service Llpc · Cedar Hill, TNS/N 1147 N8279HChilhowee Soaring Association Inc · Benton, TNBuilt 1965 · S/N 1148 N8294HSidney Aviation LLC · Sidney, NEBuilt 1965 · S/N 1163 N83786Riggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 1217 N9670ZRodriguez Joseph R · Lake Elsinore, CABuilt 1964 · S/N 1060

Back to Callair A-9