Skip to content

Registered aircraft · 13

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

N12002Coonan Gary M · Bell Buckle, TNS/N 3619 N12443Steeves Brian · Wahpeton, NDBuilt 1932 · S/N 3606 N1244GFlyboy LLC · Tampa, FLBuilt 1932 · S/N 3607 N13027Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1932 · S/N 3660 N13071Period Aviation LLC · Babylon, NYBuilt 1933 · S/N 3689 N13074Borgerson Mark J · Montevideo, MNBuilt 1933 · S/N 3691 N13075Braatz Ronald W · Bend, ORBuilt 1933 · S/N 3692 N13419Ray Jimmy · Southlake, TXBuilt 1933 · S/N 3762 N13442Owls Head Transportation Museum · Owls Head, MEBuilt 1932 · S/N 3766 N13444Dream Waco LLC · Oklahoma City, OKBuilt 1933 · S/N 3763 N13446Prince William H · Beverly, MABuilt 1933 · S/N 3765 N155YTexas Barnstorming Museum · Hallettsville, TXBuilt 1932 · S/N 3618 N2091KCournoyer John J · Ellsinore, MOBuilt 1932 · S/N 3608

Back to Waco UBF