Registered aircraft · 26

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'MT' AND g.registrant_city = 'ENNIS' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'MT' AND g.registrant_city = 'ENNIS'
  ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'MT' AND g.registrant_city = 'ENNIS'
ORDER BY g.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.

N1080ZAvid CHAMPION · S/N 08UThompson Ward N1262Stinson 10A · S/N 7973Sale reportedBuilt 1941 N14887Howard DGA-11 · S/N 79Built 1937 · Witt William A N15332Balloon Works FIREFLY 7 · S/N 10207Built 1980 · Forney Gary R N1741CCessna 180 · S/N 30441Built 1953 · Witt William A N22CACessna LC42-550FG · S/N 421003Built 2008 · N22ca LLC N2450XCessna 182H · S/N 18256350Built 1965 · Backcountry LLC N375WWWarning Walter O MONI · S/N 71Built 1983 · Padilla John A N4019YCessna 185 · S/N 185-0219Built 1961 · Witt William A N43894Taylorcraft BC12-D · S/N 7553Built 1946 · Witt William A N4522DBeech G35 · S/N D-4668Guy Timothy S N46KNHook Jerry L NORTHWAY 2 · S/N 001Built 1998 · Padilla John A N493CAPiper PA-32-260 · S/N 32-346Built 1967 · Mccann James M N5040RCessna 172M · S/N 17263281Built 1974 · Shirley Craig T N614LBeech V35B · S/N D-10055Built 1977 · Gleason Gregory C N687HZKerr John HATZ CLASSIC · S/N 687Built 2009 · Brown Verne L N719JGTextron T206H · S/N T20609834Built 2026 · Skyhawk Dev Inc N727LHCessna P206 · S/N P206-0085Built 1965 · Hale John A N7513UWatson S-1S · S/N 101Built 1965 · Witt William A N7523KPiper PA-18-105 SPECIAL · S/N 18-239Built 1950 · Richardson Joe W N7574HPiper PA-12 · S/N 12-445Built 1946 · Miller Thomas L N8925TPiper PA-34-220T · S/N 348433007Built 1984 · Suslavich Frank N917PNBalony Kubicek Spol Sro BB30Z · S/N 1386Built 2017 · Overwalle Peter Van N917WTStamsta David WITTMAN TAILWIND W10 · S/N 00-1170Built 2003 · Stamsta David T N966TFAviat A-1B · S/N 2383Brown Verne L N9702PPiper PA-18-150 · S/N 18-7509134Built 1975 · Hall Charles R

Back to Ennis, MT