OpenAirDocs.org
Johnstown, PA

Registered aircraft · 54

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

N15KDCirrus Design SR20 · S/N 2159Built 2012 · John W Sumrada LLCN195KSCessna 195A · S/N 7582Built 1950 · Kalina David AN290SABombardier CL-600-2B19 · S/N 7274Built 1998 · Slate 290 LLCN30012Piper PA-28-161 · S/N 28-7916073Built 1978 · Wfc Aviation IncN3037FPiper PA-28-161 · S/N 28-7916214Built 1978 · Nulton Enterprises LLCN31569Piper PA-32-300 · S/N 32-7840133Built 1978 · Snyder Bradley RN33672Piper PA-28-151 · S/N 28-7515298Built 1975 · Nulton Enterprises LLCN341MCPiper PA 46-350P · S/N 4636018Built 1995 · 1 Mc LLCN396SABombardier CL-600-2B19 · S/N 7839Built 2003 · Mard Aviation LLCN3989FPiper PA-28-151 · S/N 28-7615435Built 1976 · Wfc Aviation IncN420UTHonda HA-420 · S/N 420000211Built 2021 · Nulton Enterprises LLCN4370XPiper PA-28-140 · S/N 28-7625014Built 1975 · Mcguirk Michael SN44580Piper PA-28-151 · S/N 28-7415673Built 1974 · Mtt Aviation Services IncN530SABombardier CL-600-2B19 · S/N 7985Slate Aircraft Company LLCN556SABombardier CL-600-2B19 · S/N 7983Slate Aircraft Company LLCN55915Piper PA-28-180 · S/N 28-7305500Built 1973 · Loncella James GN621SABombardier CL-600-2B19 · S/N 7987Slate Aircraft Company LLCN633SABombardier CL-600-2B19 · S/N 7988Slate Aircraft Company LLCN64715Piper PA-60-602P · S/N 60-8365003Yardley Management LtdN697LBPiper PA-28RT-201 · S/N 28R-7918112Built 1979 · Mtt Aviation Services IncN6980JPiper PA-28-181 · S/N 28-7690447Built 1976 · Nulton Enterprises LLCN700ZRaytheon B200 · S/N BB-1920Ati Aviation LLCN767SABombardier CL-600-2B19 · S/N 7870Built 2003 · Slate Aircraft Company LLCN791SABombardier CL-600-2B19 · S/N 7968Built 2004 · Slate 791 Holdings LLCN793PHawker Beechcraft C90GT · S/N LJ-1836Built 2007 · Pbmj LLCN800AYBombardier CL-600-2B19 · S/N 8000Built 2004 · Slate Crj Acquisitions 1 LLCN801AYBombardier CL-600-2B19 · S/N 8001Built 2004 · Slate Crj Acquisitions 1 LLCN801KCDiamond Aircraft Ind DA 42 · S/N 42.AC101Built 2007 · Nulton Enterprises LLCN819AYBombardier CL-600-2B19 · S/N 8019Built 2005 · Slate Crj Acquisitions 1 LLCN820AYBombardier CL-600-2B19 · S/N 8020Built 2005 · Slate Crj Acquisitions 1 LLCN8216SPiper PA-28-161 · S/N 28-8016328Built 1980 · Nulton Enterprises LLCN826AYBombardier CL-600-2B19 · S/N 8026Built 2005 · Slate Crj Acquisitions 1 LLCN840AYBombardier CL-600-2B19 · S/N 8040Built 2005 · Slate Crj Acquisitions 1 LLCN841ACDavid A Kalina AIRCAM · S/N AC217Built 2022 · Kalina David AN845SABombardier CL-600-2B19 · S/N 7965Built 2004 · Slate Crj Acquisitions 1 LLCN8683BBombardier CL-600-2B19 · S/N 7683Built 2002 · Slate Crj Acquisitions 1 LLCN8694ABombardier CL-600-2B19 · S/N 7694Built 2002 · Slate Crj Acquisitions 1 LLCN8783EBombardier CL-600-2B19 · S/N 7783Built 2003 · Slate Crj Acquisitions I LLCN880SABombardier CL-600-2B19 · S/N 7978Slate Aircraft Company LLCN8847ABombardier CL-600-2B19 · S/N 7847Built 2003 · Slate Crj Acquisitions 1 LLCN8869BBombardier CL-600-2B19 · S/N 7869Built 2003 · Viajet LLCN8877ABombardier CL-600-2B19 · S/N 7877Built 2003 · Slate Crj Acquisitions 1 LLCN8908DBombardier CL-600-2B19 · S/N 7908Built 2004 · Slate Crj Acquisitions 1 LLCN8942ABombardier CL-600-2B19 · S/N 7942Built 2004 · Viajet LLCN8974CBombardier CL-600-2B19 · S/N 7974Built 2004 · Slate Crj Acquisitions 1 LLCN8976EBombardier CL-600-2B19 · S/N 7976Built 2004 · Slate Crj Acquisitions 1 LLCN8980ABombardier CL-600-2B19 · S/N 7980Built 2004 · Viajet LLCN8986BBombardier CL-600-2B19 · S/N 7986Built 2004 · Slate Crj Acquisitions 1 LLCN9246JPiper PA-28-180 · S/N 28-3321Built 1966 · Mckool John JrN940SABombardier CL-600-2B19 · S/N 7979Slate Aircraft Company LLC
Back to Johnstown, PA