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 = 'NORTON' 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 = 'NORTON'
  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 = 'NORTON'
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.

N11225Jabiru USA Sport J250-SP · S/N 248Hancock Bobby Earl Jr N162HCSteven Miller 162F · S/N 8784Miller Steven M N1631ACameron Balloons US ZL-70 · S/N 6890First renewal noticeBuilt 2019 · Cowgar Jeremy N N19360Waco ZGC-8 · S/N 5056Built 1938 · Satina David J N2047GCessna 182A · S/N 51347Built 1958 · Satina David J N20994Dart GK · S/N G-12Built 1938 · Satina David J N2193PFinicle Noel C RV-4 · S/N 1795Built 1990 · Deem Adam C N2307UCessna 172D · S/N 17249907Built 1962 · Cowgar Jeremy N N2415JCameron Balloons U S A-90 · S/N 6857Built 2018 · Cowgar Jeremy N N26120Grumman American Avn. AA-5A · S/N AA5A0441Built 1977 · Houk David A Jr N34081Cessna 177RG · S/N 177RG0964Danko James A N3855MPiper PA-28-161 · S/N 28-7816381Built 1978 · Pramik Edward J N4444HPiper PA-15 · S/N 15-233Built 1948 · Satina David J N5651WPiper PA-28-160 · S/N 28-834Houk David A Jr N622JCCowgar Jeremy N CH 750 CRUZER · S/N C75-11262Built 2021 · Cowgar Jeremy N N9007DPiper PA-22-160 · S/N 22-6142Built 1958 · Satina David J

Back to Norton, OH