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

N1001EAeronca 7AC · S/N 7AC-4551Built 1946 · Bellas Bryan Turner N151TDWilliams John TITAN T-51 MUSTANG · S/N 0001Built 2002 · Willliams John D N200CWMaule MX-7-160 · S/N 19017CBuilt 1994 · Skylake Adventures LLC N2252UBrantly B-2B · S/N 411Skylake Adventures LLC N2529JCessna 150E · S/N 15061029Sale reportedBuilt 1964 N34356Meyers OTW-160 · S/N 101Built 1943 · Ingle Samuel C N34966Cessna 177B · S/N 17702119Built 1974 · Williams John D N3786YCessna 210D · S/N 21058286Built 1963 · Williams John D N43014Piper PA-28R-200 · S/N 28R-7435241Built 1974 · Woodworth Neal A N467TBWalters Gary E TITAN TORNADO S · S/N S03XXXCOHK0467Ingle Samuel C N53072Ryan Aeronautical ST3KR · S/N 1828Built 1942 · Williams John D N5783HPiper PA-16 · S/N 16-398Built 1949 · Bellas Bryan T N580ZYAeronca 50-F · S/N F-8160Kettunen Aeronautical Inc N6832QBeech 35-B33 · S/N CD-771Built 1964 · Williams John D N71HEngineering & Research 415-C · S/N 1092Built 1946 · Mcdowell Donald L N724GAGrumman American Avn. GA-7 · S/N GA7-0023Williams John D N724TAWilliams John D JR TITAN TORNADO II · S/N SS08912COHK0529Williams John D N751TAJohn D Williams T-51B · S/N M09BV12COHK0151BBuilt 2015 · Williams John D N751TXWilliams John TITAN T-51 MUSTANG · S/N 0007Williams John N772EZCobabe H Leroy GLASAIR · S/N 665RBuilt 1987 · Skylake Adventures LLC N8268BPiper PA-28-181 · S/N 28-8190040Built 1980 · Marinko Christopher M N8542JCessna 150G · S/N 15066442Built 1967 · Mcdowell Donald L N8563ECichocki Donald TITAN TORNADO · S/N T915030HK0005Built 1992 · Williams John D N912RDeaton Ronald E TITAN TORNADO 912 · S/N D00912SOHK0382Williams John D N9133WPiper PA-28-235 · S/N 28-10752Built 1966 · Ingle Samuel C N951JDGerald Deroy T-51 · S/N M06HV6SOHK0093Built 2019 · Williams John D

Back to Geneva, OH