OpenAirDocs.org
Elyria, OH

Registered aircraft · 28

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

Query with SQL
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 = 'ELYRIA'
  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.

N1198XPiper PA-28-180 · S/N 28-7505223Built 1975 · Discover Aviation Center LLCN1544RAir Tractor AT-402 · S/N 401-0864Built 1992 · Ras Aviation LLCN1904SLearjet 45 · S/N 053Built 1999 · 1904 LLCN208GTCirrus Design SR20 · S/N 1621Built 2006 · Gti Properties LLCN20958Piper PA-28-161 · S/N 28-7916020Built 1978 · Ras Aviation LLCN217BEEves Bryan E HAWK ARROW II · S/N BE001Built 2000 · Schuck Robert AN21ZAFlight Design CTLS · S/N F-10-09-04Built 2011 · Ras Aviation LLCN2274XCessna 337 · S/N 337-0174Built 1965 · Dutko Adam MN26476Meyers OTW-160 · S/N 29Built 1941 · Wheeler Jeffrey AN2875BPiper PA-28-161 · S/N 28-7916499Built 1979 · Ras Aviation LLCN2945LMooney M20C · S/N 670079Built 1967 · Dutko Adam MichaelN299JWCirrus Design SR22 · S/N 1034Built 2004 · Ras Aviation LLCN302AVPiper PA-28-161 · S/N 28-7716283Ras Aviation LLCN6359CPiper PA-28-161 · S/N 28-7816413Built 1978 · Ras Aviation LLCN648GHBuckeye Industries DREAM MACHINE · S/N 6059Built 2001 · Daniels Larry FN649TWRobinson Helicopter R44 II · S/N 11514Built 2006 · Marathon Leasing IncN732ZHCessna P210N · S/N P21000599Built 1981 · De La Porte HerbN761ZBCessna T210M · S/N 21062639Built 1978 · Its Academic IncN8134XCessna 172B · S/N 17248634Built 1961 · Lugas Grant AN8152LCessna 172H · S/N 17256352Built 1967 · Bowman Douglas MN81DSDiamond Aircraft Ind DA 40 · S/N 40.406Built 2004 · Marathon Leasing IncN821BEPiper PA-28-161 · S/N 28-7816398Built 1978 · Ras Aviation LLCN8223BPiper PA-28RT-201 · S/N 28R-8018080Built 1980 · Ras Aviation LLCN8333TPiper PA-28-161 · S/N 28-8116146Built 1981 · Ras Aviation LLCN8574XCessna P172D · S/N P17257174Built 1963 · Discover Aviation Center LLCN872JWBellanca 17-31A · S/N 32-90First renewal noticeBuilt 1972 · Wheeler Jeffrey AN969MGBeech D95A · S/N TD-553Ras Aviation LLCN997SGPiper PA-28-161 · S/N 28-7816562Built 1978 · Ras Aviation LLC
Back to Elyria, OH