Registered aircraft · 16

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 = 'OH' AND g.registrant_city = 'MASSILLON' 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 = 'OH' AND g.registrant_city = 'MASSILLON'
  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 = 'OH' AND g.registrant_city = 'MASSILLON'
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.

N1409NPiper J3C-65 · S/N 22932Built 1947 · Fuhrer Joshua N1974YGrumman American Avn. AA-1B · S/N AA1B-0444Built 1974 · Hemperly Jeffery L N201JZMooney M20J · S/N 24-0220Built 1977 · Gill Kevin W N212KMPiper PA 46-350P · S/N 4636052Built 1996 · Mollet Kern N23KGGill Kevin W COZY MK-4 · S/N 0048Built 2009 · Gill Kevin W N246SXAshwin K Welch SONEX A · S/N 150Welch Ashwin K N2509WLancair LC41-550FG · S/N 41061Built 2005 · Double D'S LLC N269JHEla Aviacion S L ELA-07 R-100 · S/N 0312 355 0712Harrison Jeffrey C N3169ZPiper PA-22-150 · S/N 22-7120Built 1959 · Bixler Tyke L N35798Cessna 172I · S/N 17256967Built 1968 · Big Sky Aviation LLC N4370UCessna 150D · S/N 15060370Built 1964 · Neal Gordon T N49023Taylorcraft DCO-65 · S/N 5246Romar Mitchel D N593MCCirrus Design SR22 · S/N 4864Built 2019 · Chaffin Mark Bernard N8104BCessna 172 · S/N 29904Built 1957 · Romar Mark A N850AJSocata TBM 700 · S/N 602Built 2011 · Aj Air Ltd N8746XCessna 182D · S/N 18253146Built 1961 · Black Kevin R

Back to Massillon, OH