OpenAirDocs.org
Piqua, OH

Registered aircraft · 36

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

N11489Waco QDC · S/N 3547Built 1931 · Perry Aaron ON1340XWaco UIC · S/N 3748Perry Aaron ON13412Waco UIC · S/N 3768Built 1933 · Perry Aaron ON15722Waco YQC-6 · S/N 4396Built 1936 · Perry Aaron ON20546Taylorcraft A · S/N 554Perry Aaron ON205YYCessna 525A · S/N 525A0205Built 2004 · Little H Holdings LLCN20991Dart G · S/N G9Built 1938 · Perry Aaron ON21WBBorie William E PIETENPOL · S/N WEB-1Perry Aaron ON261ACPanorama Aerial Imaging AIRCAM · S/N AC-271-2Bertke MichaelN2634ADJI AGRAS T40 · S/N 64TBL5H00200L6Aerospray LLCN26WSSeltzer FLYBABY 1A · S/N 582211Built 1976 · Borgerding RichardN315GSDJI AGRAS T100 · S/N 1581F8ZLC25AE002JU0YNexus Drone Ag LLCN328CDSmith Darrell CH-601XL · S/N 6-5399Built 2008 · Donohue Joseph ThomasN3320Pitcairn PA-5 · S/N 3Built 1927 · Perry Aaron ON371BSSaunders Jesse W EAA BI-PLANE · S/N 10001Built 2010 · Perry Aaron ON40971Piper J3C-65 · S/N 7638Perry Aaron ON420CRCessna 525A · S/N 525A0215Built 2004 · Orange Lightning LLCN4912ADJI AGRAS T40 · S/N 1581F574B226D00101RZAerospray LLCN4JMMartin Jack E LONG-EZ · S/N 1179Built 1988 · Parker Trevor LN500WMBeech N35 · S/N D-6691Built 1961 · Bim-Merle Robert W IIIN561TBeech N35 · S/N D-6731Built 1961 · Sierra Alpha Air LLCN581FADJI AGRAS T100 · S/N 1581F8ZLC25B500239K8Nexus Drone Ag LLCN5955KGulfstream AM Corp Comm Div 690C · S/N 11703Built 1981 · Volare Via LLCN5992GCessna 150K · S/N 15071492Perry Aaron ON62977Bellanca 7ECA · S/N 855-72Built 1972 · Borgerding RichardN6310PPiper PA-24 · S/N 24-1420Built 1959 · Popel John G Sr TrusteeN6417RPiper PA-28-140 · S/N 28-21596Bogey Aviation LLCN676TBeech P35 · S/N D-7248Built 1963 · Fry Aviation LLCN7216WPiper PA-28-180 · S/N 28-1030Built 1963 · Bim Merle Robert W IIIN7294LGrumman American Avn. AA-5 · S/N AA5-0294Built 1973 · Hampshire Kimberly SN742MGChafin Gary S RANS S-7S · S/N 1003354Built 2006 · Parker Trevor LN76VABeech C23 · S/N M-1786Built 1976 · Hartzell Propeller Emp Flg ClubN8087CPiper PA-28-236 · S/N 28-7911317Built 1979 · Hartzell Propeller Employees Flying ClubN8403BPiper PA-32R-301 · S/N 32R-8113082Built 1981 · Volare Via LLCN8563KStinson 108-2 · S/N 108-1563Perry Aaron ON97806Stinson 108-1 · S/N 108-806Perry Aaron O
Back to Piqua, OH