Skip to content

Registered aircraft · 8

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 ('1890102')
  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 ('1890102')
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.

N188VMaximus Aviation LLC · Cheyenne, WYBuilt 1955 · S/N 101 N206Gaines Robert M · Nashville, TNBuilt 1948 · S/N 1-053 N214NMid Atlantic Air Museum · Reading, PABuilt 1955 · S/N 1-058 N224MJGlover William Scott · Mount Pleasant, TXS/N 1-064 N234Mid Atlantic Air Museum · Reading, PABuilt 1956 · S/N 1-070 N243Mid Atlantic Air Museum · Reading, PABuilt 1946 · S/N 1-077 N480XXHerrington Russell · Portal, GAS/N 1-065 N8693EGaines Robert M · Nashville, TNS/N 1-079

Back to Camair 480