OpenAirDocs.org
Johnstown, OH

Registered aircraft · 34

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

N101JWTextron 525 · S/N 525-0950Built 2017 · Korndawg LLCN16XFLet L 33 SOLO · S/N 940310Built 1995 · Ovdiyenko Chris MN21235Taylorcraft BC-65 · S/N 1025Built 1938 · Humphrey Andrew DN253BKDJI T40 · S/N 1581F574B2387001000YAdkins Daniel AN2640CAeroprakt Mfg SP Z O O A32 · S/N 327Built 2024 · Heavenbound Enterprises LLCN2MKPiaggio P180 · S/N 1063Built 2003 · Italian Job Holdings LLCN302YBDJI AGRAS T50 · S/N 1581F6BUB2448001CU58Buckeye Agri Sales LLCN3099WBeech V35B · S/N D-9561Built 1973 · Savage Curtis MacN314PMAeroprakt Mfg SP Z O O A32 · S/N 398Heavenbound Enterprises LLCN316HBAeroprakt Mfg SP Z O O A32 · S/N 359Built 2025 · Heavenbound Enterprises LLCN330MAPiper PA-46-600TP · S/N 4698145Built 2020 · Venture Acquisition Holdings LLCN43539Taylorcraft BCS12-D · S/N 7198Built 1946 · Humphrey Andrew DN452THHolland Travis STOL CH 801 · S/N 8-4949Humphrey Andrew DN4609KNavion NAVION A · S/N NAV-4-1609Dean Ronald EN47481Taylorcraft DCO-65 · S/N 5082Built 1943 · Huff Roger AN5004MTaylorcraft BC12-D · S/N 10304Huff RogerN58HBAeroprakt Mfg SP. Z O O A32 · S/N 394Heavenbound Enterprises LLCN5941CVans RV-12 · S/N 120101Built 2011 · Huff Roger AN6260VBeech V35 · S/N D-8591Built 1967 · Pcb AircraftN630HBAeroprakt Manufacturing SP Zoo A22LS · S/N 473Built 2023 · Heavenbound Enterprises LLCN652HBAeroprakt Mfg SP Z O O A32 · S/N 380Heavenbound Enterprises LLCN653HBAeroprakt Manufacturing SP Zoo A22LS · S/N 739Heavenbound Enterprises LLCN6574HPiper J3C-65 · S/N 19765Built 1946 · Huff RogerN695CWAeroprakt Manufacturing SP Zoo A22LS · S/N 738Heavenbound Enterprises LLCN730FPFpna A-22 VALOR · S/N 288Built 2010 · Heavenbound Enterprises LLCN740QQuicksilver Aeronautics L-S2S · S/N 10006Built 2015 · Heavenbound Enterprises LLCN742RFFrank Ronald A RAF AVID · S/N 742Built 1998 · Frank Ronald AN837LSAeroprakt Mfg SP Z O O A32 · S/N 399Heavenbound Enterprises LLCN864WWarner Kirk FLYBABY 1A · S/N 012156Built 2008 · Huff Roger AN8816JPiper PA-28-180 · S/N 28-2770Built 1965 · Huff Roger AN912LWMortimer John Vince III DRIFTER 912 · S/N 2019-01Built 2019 · Humphrey Andrew DN92192Piper J3C-65 · S/N 16632Built 1946 · Humphrey Andrew DN92629Piper J3C-65 · S/N 17000Built 1956 · Boltress Thomas ScottN98NDJackson David O BABY ACE MODEL D · S/N 300Built 1985 · Clark Todd E
Back to Johnstown, OH