OpenAirDocs.org
Springfield, OH

Registered aircraft · 49

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N115ALLansing Alan C CH 650 · S/N 7486Built 2019 · Lansing Alan CN128SGSelecttech Geospatial EP-2000 · S/N SN-0100Selecttech Geospatial LLCN129SGSelecttech Geospatial EH-4 · S/N 0050Selecttech Geospatial LLCN146TDDJI AGRAS T40 · S/N 1581F574B234C00100P6Volare Strategies LLCN177WBCessna 177RG · S/N 177RG0975Built 1976 · Cardinal 3 Flyers LLCN1964YMooney M20D · S/N 229Perry Shawn MN199KASelecttech Geospatial EH-4 · S/N SN-0051Select Tech Geospatial LLCN244JBRobinson Helicopter R44 · S/N 0560Built 1999 · Spier Ronald BN2466PPiper PA-22-150 · S/N 22-2841Built 1955 · Griffin Scott MN262XJDJI AGRAS T40 · S/N 1581F574B239600100KHJersey Manor Farms LLCN2650ZBellanca 7ECA · S/N 1223-77Built 1977 · Frederick James HN32383Rearwin 175 · S/N 1532Miller Scott DN323RJRonald B Spier SONEX XENOS · S/N X0062Built 2015 · Spier Ronald BN393GLNanchang CJ-6A · S/N 3832022Built 1982 · Sollinger John EN410PJPeterson Douglas William VANS RV-10 · S/N 40009Built 2005 · Volk TimothyN426HHickerson Timothy William VANS RV-8 · S/N 81246Built 2003 · Hickerson Timothy WilliamN42PCBeech E-90 · S/N LW-85Built 1973 · Krohn Aviation LLCN447XJDJI AGRAS T40 · S/N 1581F574B238300100AGJersey Manor Farms LLCN450RVVans RV-12 · S/N 120450Hickerson Timothy WilliamN450XAXag P150 · S/N 186324P18223443K328TOn Point Ag Services LLCN4674ZPiper PA-22-108 · S/N 22-8207Built 1961 · Hoadley Todd FN509HCMiller Dennis J TITAN TORNADO I · S/N T99582SOHK0338Built 1999 · Spier Ronald BN510ADPiper PA-23-250 · S/N 27-8054044Built 1980 · Dj Aztec LLCN514JHBaxter James M CHALLENGER II · S/N CH2-1003-2393Williamson Dan EN540XGDJI AGRAS T40 · S/N 64TBL7K00200D3Global Impact Stem AcademyN55409Cessna 172P · S/N 17275176Burrowes William AN5850ZPiper PA-22-108 · S/N 22-9705Built 1963 · Miller Helen JN597BLLindamood Richard B S-6ES · S/N 08071826Built 2007 · Lindamood Richard BN621FWCirrus Design SR22 · S/N 2594Built 2007 · Francis Wayne LtdN642RGCirrus Design SR20 · S/N 2760Built 2021 · Lone Mountain Aircraft Training LLCN6597ECessna 175 · S/N 56097Built 1959 · Printz Thomas LN718SRCirrus Design SR22 · S/N 2252Built 2006 · Lone Mountain Aircraft LLCN7532UMyers Charles DRAGONFLY · S/N 001Park Kevin M BN774GPass Joseph TJ SPORT · S/N 001Harmon LarryN7919ECessna 150 · S/N 17719Built 1959 · Nicodemus Trey MN8018CPiper PA-32-260 · S/N 32-7600008Built 1975 · Patterson Charles AN806CADJI PHANTOM 3 ADVANCED · S/N P76UDH06B200EQLadar Techniques LLCN821PKKelly Patrick M KITFOX CLASSIC IV · S/N C9905-0247Built 1999 · Foster Kelly AN8322YPiper PA-30 · S/N 30-1463Built 1967 · Dayhoff Miller Alice JN8343XCessna 172C · S/N 17248843Built 1961 · Howard John DN836LLCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 09SC222RBuilt 2009 · Tremont Air LLCN85748Aeronca 7AC · S/N 7AC-4497Built 1955 · Yellow Bird Flyers AssociationN8789UCessna 150M · S/N 15077993Built 1976 · Langley Bryan TN87DDRobert H Young BABY ACE D · S/N 1Built 1963 · Griffin Scott MN9141WPiper PA-28-235 · S/N 28-10762Built 1966 · Slater Daniel RN9227HFairchild M-62A-3 · S/N FV258Built 1943 · Jeffers Andrew TN948SASocata TB-20 TRINIDAD · S/N 948Built 1989 · Pavlatos Plato NicholasN96688Taylorcraft BC12-D · S/N 8988Built 1946 · Griffin Scott MN982DCDJI AGRAS T40 · S/N 1581F574B2387001004MNorthwestern Local Schools
Back to Springfield, OH