OpenAirDocs.org
Cardington, OH

Registered aircraft · 27

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

N108TSCessna 170B · S/N 20328Built 1952 · Hesser Dale WN17129Hiller OH-23B · S/N 51-16189Built 1951 · Dreyer Elwain CN18WSLuscombe 8E · S/N 4737Built 1947 · Mason Loretta LN1985BSilvaire LUSCOMBE 8A · S/N 6412Fisher Air LLCN2033RAir Tractor AT-504 · S/N 504-4010Built 2011 · Lj Leasing LLCN2231DCessna 170B · S/N 20383Built 1952 · Fisher Air LLCN2470PCessna 182S · S/N 18280891Built 2000 · Fisher Air LLCN2746Heldeberg Designs BLUE HERON MARATHON · S/N HD03089MEdwards Joseph AN3619JCessna T188C · S/N T18803565TBuilt 1979 · Fisher Ag Service LLCN3631VCessna 140 · S/N 14902Built 1948 · Fisher Air LLCN374HHiller UH-12D · S/N 1374Dreyer Elwain CN4370JPiper PA-28-140 · S/N 28-22754Dreyer Elwain CN4854RCessna A188B · S/N 18802373TBuilt 1975 · Fisher Ag Service LLCN5005KAir Tractor AT-602 · S/N 602-0403Built 1997 · Fisher Spray Service LLCN602FHAir Tractor AT-602 · S/N 602-1162Built 2008 · Fisher Spray Service LLCN602STAir Tractor AT-602 · S/N 602-0581Built 2000 · L J Leasing LLCN629JPAir Tractor AT-802A · S/N 802A-0129Built 2002 · Lj Leasing LLCN6491KCessna 150M · S/N 15077726Fisher Air LLCN7251JPiper PA-28-140 · S/N 28-24593Built 1968 · Chapman Michael SN756EUCessna R182 · S/N R18201055Built 1979 · Fisher Air LLCN78150Globe GC-1B · S/N 2150Built 1946 · Dreyer Elwain CN806EHRobinson Helicopter R22 BETA · S/N 1452Built 1990 · Fisher Air LLCN88800Helderberg Design BLUE HERON · S/N HD0412GMCoffman Robert PN92375North American/Levrett AT6-C · S/N AC41-33062JLFisher Air LLCN92924Commonwealth 185 · S/N 1656Dreyer Elwain CN96794Taylorcraft BC12-D · S/N 9094Built 1946 · Fisher Air LLCN976CWAir Tractor AT-402B · S/N 402B-1227Built 2010 · Fisher Spray Service LLC
Back to Cardington, OH