OpenAirDocs.org
Dublin, OH

Registered aircraft · 50

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

N112SGGfeller Steve F RV6 · S/N 22390Built 1996 · Suleman MuhammadN1869FCessna 210F · S/N 21058769Registration pendingBuilt 1966N2100XPiper PA-28-201T · S/N 28-7921008Built 1979 · Schwind Michael KN2269LGrumman American Avn. AA-5 · S/N AA5-0156Built 1972 · Larrison Bryan JN240ESSchmidlin Eric LANCAIR LEGACY · S/N L2K237Built 2007 · Schmidlin EricN248LJCameron Balloons US Z-120 · S/N 7002Built 2024 · Colubmus Aeronauts LLCN250JHCirrus Design SR22 · S/N 3993Built 2013 · Jh Diaries LLCN2713WMooney M20C · S/N 3334Built 1966 · Dutro Tammy SN28BUBeaver Stephen J BUCKER JUNGMANN · S/N 001Built 2010 · Beaver Stephen JN312AZCirrus Design SR20 · S/N 2344Built 2017 · A & J Aviation Rental LLCN37VMPiper PA-46-310P · S/N 46-8508002Built 1984 · Victory Maximus LLCN388DDCanadair CL-600 CHALLENGER · S/N 1082Built 1983 · Challenger Four LLCN393JETextron 680A · S/N 680A0303Built 2022 · Jeb Investments LLCN414RMGrumman American Avn. AA-5B · S/N AA5B1313Built 1979 · Mutzman Richard C TrusteeN414YHCessna 414A · S/N 414A0514Built 1980 · Victory Maximus II LLCN421DBCessna 421C · S/N 421C0509Built 1978 · Acme 17 LLCN44LJoseph Anthony Trepicone LIVPT · S/N LIV-484Flying Architect Aviation LLCN46AVAvian Balloon FALCON II · S/N 46Built 1980 · On-Target Management Group LLC DBAN479ACAmerican Champion 7GCAA · S/N 427-99Built 1999 · Vick Vernon AN5064VVarga 2150A · S/N VAC52Built 1975 · Senita KentN515GKBeech E-90 · S/N LW-108Built 1974 · Avintel Management LLCN5253MTaylorcraft BC12-D · S/N 10553Built 1947 · Weigle Dana LN525WTButts Bruce E WITTMAN TAILWIND · S/N 001Built 2012 · Butts Bruce EN5408PPiper PA-24-250 · S/N 24-462Built 1958 · Zero Eight Papa LLCN54461Piper PA-28-151 · S/N 28-7415067Built 1973 · Cline Christopher TN555YDBeech A36 · S/N E-1048Built 1977 · Yoder Philip G TrusteeN6097HArbc Inc DBA Lindstrand 90A · S/N 5588Built 2015 · Columbus Aeronauts LLCN6597BHeldeburg Designs BLUE HERON MARATHON · S/N HD04127MBuilt 2004 · Mckinley Ed LN661JSStrausbaugh Joseph A VANS RV-7 · S/N 70276Built 2009 · Strausbaugh Joseph AN66489Beech A36 · S/N E-2073Built 1983 · Fog City Flying LLCN6802VAerostar Acft Corp Of Texas M20F · S/N 22-0002Tennave LLCN6898NMooney M-20G · S/N 680133Built 1968 · Mcdonald John AN68UDGulfstream Aerospace GVII-G600 · S/N 73178Built 2025 · Spartan Air LLCN729AJCirrus Design SR22 · S/N 4208Built 2015 · Edwards 729aj LLCN72MRCessna 182S · S/N 18280123Built 1998 · Snide Thomas CN737LGCessna 172N · S/N 17269496Built 1977 · Airborne Mgmt LLCN763JJabiru Aircraft PTY J230-D · S/N 872Built 2015 · Keith Michael DN7724Sportavia-Putzer FOURNIER R.F.4.D · S/N 4114Built 1968 · Beaver Stephen JN779DSSaucier JR Dana A RV-10 · S/N 40361Built 2013 · Saucier Dana A JrN79132Stinson VULTEE V-77 · S/N 77-486Built 1944 · Dye Kenneth AN813SFSchleicher ASW-27 · S/N 27009Built 1996 · Old Fredrick LeighN8143YPiper PA-30 · S/N 30-1254Built 1966 · Tennave LLCN819RJCameron Balloons US A-105 · S/N 6807Built 2016 · Columbus Aeronauts LLCN841DMCessna T182T · S/N T18208632Built 2006 · Gibb David JN876KTacheny GREAT LAKES 2T1A · S/N 6726-J-344Saucier Dana A JrN9000QBeech V35A · S/N D-9000Built 1969 · Fog City Flying LLCN9068VMooney M20F · S/N 690012Built 1968 · Dreher MatthewN9151LChampion 7GCBC · S/N 306-71Built 1971 · Cerrato Michael JN91DPLearjet 31A · S/N 079Built 1993 · N91dp LLCN9550RBeech K35 · S/N D-6108Built 1959 · England Steven B
Back to Dublin, OH