Skip to content

Registered aircraft · 23

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

N21164Christenson Dean A · Intl Falls, MNS/N 7049 N21165Stewart Donald J · Charlotte, NCBuilt 1939 · S/N 7024 N21169Warren John P · White Lake, MIBuilt 1939 · S/N 7028 N21186Lea Richard M · Pasadena, MDBuilt 1939 · S/N 7062 N21195Williams John David · Omaha, NEBuilt 1939 · S/N 7134 N22502Pennell Timothy M · Hickory, NCBuilt 1939 · S/N 7076 N22513Sutton Bradley V · Dallas, TXBuilt 1939 · S/N 7083 N22517Alseth Elif A · Rockton, ILS/N 7061 N22531Coleman Burgess · S Lyon, MIBuilt 1939 · S/N 7099 N22543Rawson John · Orange, CAS/N 7106 N22546Elliott Brandon J · Senoia, GAS/N 7128 N22548V2 Aviation LLC · Mishawaka, INBuilt 1939 · S/N 7131 N22579Sutton Bradley V · Dallas, TXS/N 7157 N23701Jackson Ramman S · Los Angeles, CABuilt 1939 · S/N 7170 N23703Ackerman Jerry L · Spring, TXS/N 7150 N23706Petersen Lewis C · Salisbury Center, NYBuilt 1939 · S/N 7189 N23710Klein John T · Austin, ARBuilt 1939 · S/N 7173 N23741Morris John B Jr · Kenai, AKBuilt 1939 · S/N 7211 N23784St Clair Joseph M · Wills Point, TXBuilt 1939 · S/N 7244 N23785Ackerman William L · Montgomery, TXBuilt 1940 · S/N 7260 N23792Swartz William L · Cumb Foreside, MES/N 7247 N26204Ton David B · Bremen, INS/N 7258 N99992Grace James J J Jr · Parrish, FLBuilt 1939 · S/N 7195

Back to Stinson HW75