OpenAirDocs.org
Batavia, OH

Registered aircraft · 71

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

N100GCCraft Steven Z CRAFT-BENSEN · S/N 001Built 2012 · Workman Randall LN1017FMooney M20J · S/N 24-3108Imwalle John NN12064Cessna 172S · S/N 172S9839Built 2005 · Eastern Cincinnati Aviation IncN121UCCessna 172R · S/N 17280420Built 1998 · Eastern Cincinnati Aviation IncN132ABEnstrom 280 · S/N 1004Built 1974 · Scenix Air LLCN136PRaytheon A36 · S/N E-3029Flying DazeN172LBVans RV-12 · S/N 120787Built 2018 · Boyer Philip BN176MECessna 172S · S/N 172S8470Built 2000 · Eastern Cincinnati Aviation IncN190AFFocke Wulf FW 190 F8/R1 · S/N 583 661Built 1944 · Tri State Warbird MuseumN201XVMooney M20J · S/N 24-0508Built 1978 · Cahill Michael FN206VBCessna T206H · S/N T20609084Built 2013 · N206vb LLCN20PMPiper / Mcguinness L4H · S/N 10623Tri-State Warbird MuseumN2135SCessna 172S · S/N 172S9558Built 2003 · Eastern Cincinnati Aviation IncN224DFBoeing B75N1 · S/N 75-7899Built 1943 · Tri-State Warbird MuseumN2386VCessna 172R · S/N 17280702Built 1999 · Eastern Cincinnati Aviation IncN2414KLuscombe 8E · S/N 5141Built 1947 · Cahill Michael FN2416CCessna 180 · S/N 30716Built 1954 · Ta Ritchey LLCN246KWCessna 182Q · S/N 18267659Built 1980 · Genellie Gerald F Jr TrusteeN253WPCessna 182S · S/N 18280743Built 2000 · Eastern Cincinnati Aviation IncN27671Taylorcraft BC-65 · S/N 2313Clearwater Air & Auto MuseumN295THCessna 150L · S/N 15072736Howser Anthony JN3067BCessna 195A · S/N 7951Built 1952 · Imwalle John NN32GVCessna 172M · S/N 17267026Eastern Cincinnati Aviation IncN3466GGoodyear FG1D · S/N 92132Built 1945 · Tri-State Warbird MuseumN361EXHangar 36 DYNALI H3 · S/N H3-42-1630Built 2017 · Hangar 36N362SPCessna 172S · S/N 172S8779Built 2001 · Eastern Cincinnati Aviation IncN377ESCessna 172R · S/N 17280086Built 1997 · Eastern Cincinnati Aviation IncN37924Piper J3C-65 · S/N 22743Built 1947 · Tri-State Warbird MuseumN3867RCessna 172H · S/N 17255367Built 1966 · Howser Timmy LN405SPCessna 172S · S/N 172S8298Built 1999 · Eastern Cincinnati Aviation IncN420GPGrumman TBM-3 · S/N 53420Built 1944 · Tri-State Warbird MuseumN42525Cessna 182L · S/N 18259056Built 1968 · Titus Daniel AN4495KRyan NAVION · S/N NAV-4-1495Built 1948 · Crawford William AN44WZBell Richard W JR RV 4 · S/N 729Wild Blue Yonder LLCN4847GCessna 172N · S/N 17273394Built 1979 · Flying DazeN48HSCirrus Design SF50 · S/N 0053Built 2018 · Osterfeld Jefferey JN5033RCessna 172M · S/N 17263274Built 1974 · Eastern Cincinnati Aviation IncN5315ECessna 172S · S/N 172S9291Eastern Cincinnati Aviation IncN53417Cessna 172R · S/N 17281162Built 2003 · Eastern Cincinnati Aviation IncN536SPCessna 172S · S/N 172S8388Built 2000 · Eastern Cincinnati AviationN5498EGeide HEADWIND D · S/N RFGBuilt 1965 · Crawford William AN5524QMooney M20E · S/N 615Imwalle John NN5813Curtiss Wright P40M · S/N 27501Built 1943 · Tri-State Warbird MuseumN60138Cessna 150J · S/N 15070099Built 1968 · Clearwater Air & Auto MuseumN605VJDunham Rodney SKY RANGER · S/N 605Built 2008 · Hueber Richard FN6167LCessna 182T · S/N 18281380Built 2004 · Eastern Cincinnati Aviation IncN69113Green Horace C HELICYCLE · S/N 03-008Built 2006 · Imwalle John NN697JSPegasus QUANTUM 15 · S/N 7584Built 1999 · Schubert JeffN6985ACessna 172 · S/N 29085Built 1956 · Imwalle John NN7026CGrumman HU-16 · S/N 149836Built 1951 · Tri-State Warbird Museum
Back to Batavia, OH