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

N11203Harter Michael R · Greenfield, INBuilt 1930 · S/N 3399 N11260Swindle Don · Collinsville, TXBuilt 1931 · S/N 3409 N11267Willford George A · Waterville, OHBuilt 1931 · S/N 3446 N11466Command Aire LLC · Sitka, AKBuilt 1931 · S/N 3519 N618YKing David T · Red Hook, NYBuilt 1930 · S/N 3352 N619YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1930 · S/N 3364 N648YJ & J Aero · Chuckey, TNBuilt 1930 · S/N 3384 N864VKuehl Alison L · Mount Pleasant, TXBuilt 1930 · S/N 3265

Back to Waco INF