Registered aircraft · 20

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 = 'LEWIS CENTER' 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 = 'LEWIS CENTER'
  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 = 'LEWIS CENTER'
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.

N1864LBrian Gafford DRIFTER MU582 · S/N 1001Built 2015 · Gafford Brian A N23123Cessna 150H · S/N 15068739Built 1968 · Gafford Brian A N252HWMooney M20K · S/N 25-1142Built 1987 · Beverly Robert E N26RCChase Robert S CH 701 · S/N 4534Layne Chad N2958ZPiper PA-22-150 · S/N 22-6931Built 1959 · Bryce Brad W N31LYCanton Paul A VELOCITY XL RG · S/N 3RX011Built 2008 · Tofte Arthur Shawn N3241LCessna 172H · S/N 17256141Built 1967 · Dostroph Manfred J N401RHHickman Robert J VANS RV-4 · S/N 1986Built 1999 · Tofte Shawn A N4092WPiper PA-32-300 · S/N 32-40151Built 1967 · M & M Aircraft LLC N40ATCessna R182 · S/N R18200527Built 1978 · N40at LLC N41229Piper PA-28-180 · S/N 28-7405084Built 1974 · Whitewings Inc N47WRCessna 140 · S/N 8454Built 1946 · Robillard Robert P N558MMooney M20J · S/N 24-1686-14Synergyair Ltd N6222SPiper PA-28R-200 · S/N 28R-7335197Built 1973 · Clear Sky Aviation LLC N62RWLabelle SKYBOLT · S/N 1ACTofte Arthur Shawn N701JFSocata TBM 700 · S/N 331Built 2005 · J Fergus Inc N73BWPiper PA-28-161 · S/N 28-7816102Built 1977 · Bravo Whiskey Holdings LLC N883CDCirrus Design SR22 · S/N 0532Built 2003 · Charlie Delta Llp N915MPCessna 525A · S/N 525A0024Built 2001 · Finnegan Air Inc N95661Cessna 182Q · S/N 18266594Built 1978 · Godfrey Turhan L

Back to Lewis Center, OH