OpenAirDocs.org
Medina, OH

Registered aircraft · 80

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

N106BLLeftwich Brian L LEFTWICH SPRINT · S/N 0649Registration pendingBuilt 2020N106GKLearjet 45 · S/N 2134Built 2013 · Vrs Holdings LLCN1091HAeronca 15AC · S/N 15AC-112First renewal noticeBuilt 1948 · Huber Gregory AN1112HCessna 175 · S/N 56188Strojny Andrew P IIIN11227Cessna 150L · S/N 15075262Built 1973 · Tribec IncN120WDWilliam A Dotter SIXCHUTER SR7 · S/N SR72014Built 2014 · Apanovitch JosephN133VSLearjet 45 · S/N 2060Built 2006 · Vrs Holdings LLCN13410Waco PLA · S/N 3760Huber Gregory AN143CXLindstrand Balloons 56X · S/N 5331Built 2006 · Hot Air Ohio LLCN149JMDavid H Manning S-21 OUTBOUND · S/N 04230323Built 2026 · Manning DavidN150BKCessna 150J · S/N 15070857Built 1969 · Tribec IncN177TJCessna 177B · S/N 17702593Built 1976 · Cobb Joseph JrN18202Cessna 150L · S/N 15073859Built 1972 · Flying Tomato Aviation LLCN2199SFirefly Balloons FIREFLY 8B-15 · S/N F8B-2072Saul Daniel KN2208MPiper J3C-65 · S/N 20999Built 1946 · Seivers Matthew RN2482EAeronca 7AC · S/N 7AC-6061Built 1946 · Wischt Paul J JrN2708NCessna 120 · S/N 12966Built 1947 · Goldstein Michael FN277RDEnstrom Helicopter 280C · S/N 1156Built 1978 · Westline CorpN307VAVans RV-12 · S/N 12069Built 2016 · Balski Keith DN30834Piper PA32-301XTC · S/N 3255019Built 2004 · Tribec Group International IncN3262CBeech E35 · S/N D-3928Built 1954 · Sievers Gilbert HN327CFAutel Robotics EVO II PRO · S/N H6R922218142C Three Photography LLCN327DXDJI PHANTOM 4 · S/N 07DDD3E0B10742C Three Photography LLCN327ESDJI MAVIC 2 PRO · S/N 163DG65001T71RC Three Photography LLCN330MJCirrus Design SF50 · S/N 0390Built 2022 · Sr Aviation LLCN3332TCessna 177 · S/N 17700632Williams Darryl LN34679Cessna 177B · S/N 17701936Built 1973 · Flanders John HN3485EAeronca 7AC · S/N 7AC-6867Built 1947 · Huber Greg AN34RBBrooks Randall E RANS S21 OUTBOUND · S/N 02210166Built 2024 · Brooks Randall EN3523WPiper PA-32-260 · S/N 32-408Built 1966 · Ramunni Andrew RN3613VCessna 140 · S/N 14881Built 1948 · Mcwilliams Eric TN3732LCessna 172G · S/N 17253901Built 1965 · Summa Dawn KN3773RCessna 172H · S/N 17255573Blair Richard JN3802JBeech A36 · S/N E-1781Dental Surgical Center Of Medina IncN3835TPiper PA-28R-180 · S/N 28R-30153Built 1967 · Huber Charles HN4072CStinson 108-3 · S/N 108-5072Built 1949 · Orians Brian EN4610BCessna 180 · S/N 31508Built 1955 · Huber Gregory AN4618VVarga 2150A · S/N VAC-83-77Built 1977 · Seymour James HN485GGCameron Balloons US ZL-70 · S/N 6810Built 2016 · Lutkus Janet MN48KYEclipse EA500 · S/N 000178Built 2008 · N48ky LLCN495PADaniel K Saul ADE RZ-7 · S/N 1001Built 2014 · Saul Daniel KN501WACessna 150M · S/N 15076640Built 1975 · Ferrari Jason MN5258MAerostar International S-55A · S/N S55A-3083Built 2000 · Lutkus JanetN53054Cessna 172P · S/N 17274674Built 1981 · Ott RobertN5450NHoward DGA-15P · S/N 1815Built 1944 · Goldstein Michael FrankN5533HPiper PA-11 · S/N 11-1036Built 1949 · G2g Aeroservices LLCN575JWall Donald A BD-5J · S/N 15Built 2003 · Bede Family FoundationN582BBeech A35 · S/N D-1601Built 1948 · Sievers Gilbert HN58HCBeech 58 · S/N TH-637Built 1975 · Medina Sky LLCN59DHBeech V35A · S/N D-8891Built 1968 · May Bernard A
Back to Medina, OH