OpenAirDocs.org
Mentor, OH

Registered aircraft · 38

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

N104HJHonda HA-420 · S/N 42000104Built 2018 · Mile High Club Aviation LLCN1191JAero Commander 112 · S/N 234Built 1974 · Mag-Nif IncN1310KPiper PA-28-181 · S/N 28-7790216Built 1976 · Vector Aviation LLCN177HBHixenbaugh S/Barlett J HB69 · S/N 002Built 2004 · Barlett SandraN179DADiamond Aircraft Ind DA20-A1 · S/N 10179Dunne Robert WN181TBPiper PA-28-181 · S/N 28-7990212Built 1978 · Vector Aviation LLCN1880QCessna 177RG · S/N 177RG0280Built 1972 · Newby PatrickN18929Beech 76 · S/N ME-6Built 1978 · Vector Aviation LLCN18KXLedoux Kirk CCK-1865 · S/N CCK-1865-1081Built 2021 · N68hm LLCN2010NCessna 140 · S/N 12246Built 1947 · Mccoy Michael DavidN20631Fairchild 24 K · S/N 3358Built 1938 · Levine James DavidN232JMCessna T182T · S/N T18209073Built 2013 · Willfish LLCN246DYRaytheon A36 · S/N E-3065Built 1996 · Wilson Ralph W TrusteeN25010Workman Joseph ROTORWAY 162F · S/N 6264Built 1999 · Workman JosephN302JKTextron 525B · S/N 525B0493Built 2016 · Crt Air LLCN348MAAmerican Champion 7GCBC · S/N 1337-2002Built 2002 · Wilson Ralph W TrusteeN3535RMooney M20R · S/N 29-0502Built 2008 · Mannion Paul RN365HBSandra Barlett/Jeffrey Barlett HB65 · S/N 003Built 2019 · Barlett Sandra EN40JVAvions Mudry ET Cie CAP 10B · S/N 80Built 1977 · Whiting Andrew WN496DCRaytheon G36 · S/N E3741Built 2006 · B & Pb LLCN5336VPiper PA-32R-301T · S/N 3257240Built 2001 · Kenco Leasing LLCN5344GDehavilland DHC-2 MK.I · S/N 1219N68hm LLCN542EBCessna T210N · S/N 21064351Built 1981 · Svoboda Erik SN555ADBombardier CL-600-2B16(CL-604) · S/N 6126Built 2018 · Ad One LLCN5610ZPiper PA-22-108 · S/N 22-9422Built 1962 · Mcvey James WN588TWBell 206B · S/N 4590Built 2005 · Willfish LLCN6009PCessna 172S · S/N 172S10137Built 2006 · Oh Air LLCN639STNew Piper PA-28-181 · S/N 2843639Built 2006 · Vector Aviation LLCN6403PPiper PA-24-250 · S/N 24-1513Built 1959 · Diemand Larry LN6874BPiper PA-22-150 · S/N 22-4118Sale reportedN7232CPiper PA-28-181 · S/N 28-7690061Built 1976 · Vector Aviation LLCN7834NPiper PA-28-180 · S/N 28-5288Built 1969 · Vector Aviation LLCN78PSAerotek PITTS S-2A · S/N 2068Built 1974 · Jarc DanielN8245CPiper PA-28-181 · S/N 28-8090372Built 1980 · Vector Aviation LLCN8701ZCola Ronald G ZENITH 701 · S/N 7258Built 2009 · Cola Ronald GN88TWCessna 208 · S/N 20800292Built 1998 · Wheel-Air LLCN89NXCirrus Design SR22 · S/N 1004Built 2004 · Cardinal Account Services Inc DBAN997ABarlett Jeffrey H RV-7A · S/N 71598Built 2008 · Barlett Jeffrey H
Back to Mentor, OH