Skip to content

Registered aircraft · 17

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

N2115UDengler Steven G · Lopez Island, WAS/N 163 N2129UMarzich Frank M · Rockford, ILBuilt 1962 · S/N 177 N5912XKnutson Wayne R · Thompson, NDS/N 48 N5913XHay Johnny L · Bethel, OHS/N 49 N5914XTamvakis Dimitri · Orlando, FLS/N 50 N5918XRiley Luther R · Chickasha, OKS/N 54 N5931XRotors & Wings LLC · Salem, ILS/N 69 N5945XFarwell Theodore R · Orangeville, PAS/N 83 N5950XWelch Thomas R · Modesto, CAS/N 89 N5976XFandler Frederick · Shady Shores, TXBuilt 1961 · S/N 119 N5985XWestern North Carolina Air Museum · Hendersonville, NCBuilt 1961 · S/N 129 N5986XPanella Benjamin · Wampum, PABuilt 1961 · S/N 130 N5996XBowles Alan B · Georgetown, TXBuilt 1961 · S/N 141 N6796DMat-Su Air Service Inc · Willow, AKBuilt 1960 · S/N 5 N6798DBeard Roger D · Mooresville, INBuilt 1959 · S/N 19 N8101TWimberly Fred N · Callao, VABuilt 1962 · S/N 190 N8197Walsh Dennis Executor Et Al · Little Falls, NYS/N 74

Back to Brantly B-2