OpenAirDocs.org
Johnstown, CO

Registered aircraft · 26

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

N103VSnyder Raymond J RV-8 · S/N 80323Built 2005 · Rogers Aviation LLCN116ZXCessna 182S · S/N 18280042Built 1997 · Vranjes PeterN185GGCessna A185F · S/N 18502787Built 1975 · Anchor Aviation LLCN1931MCirrus Design SR22T · S/N 10392Built 2024 · Anchor Aviation LLCN200TCCocks Thomas F RV-6 · S/N 20882Registration pendingBuilt 1992N2242LBeech C23 · S/N M-1891Built 1976 · Deyoung Jeffrey ScottN229HYHylio HYL-150 · S/N 17906110502Precision-Applicators LLCN230XCAnchor Roofing CCX-2300 · S/N CCX-2300-0078Built 2023 · Anchor Aviation LLCN3404NPiper J3C-65 · S/N 22913Built 1947 · Anchor Aviation LLCN342GBGame Composites GB1 GAMEBIRD · S/N 0057Built 2022 · Anchor Aviation LLCN395JJPiper PA-34-200T · S/N 34-7870393Built 1978 · Cate Kyle TN4074WHelio H-700 · S/N H-13York Leslie NealN420LPPrichard Lynn RV4 · S/N 4028Built 2000 · Cross Todd JN53MABell 206B · S/N 2285Built 1977 · Ag Air IncN553MBBickling Melvin T RV-9A · S/N 91457Built 2011 · Bickling Melvin TN555AABell Textron Canada 505 · S/N 65506Built 2025 · Anchor Aviation LLCN632KAmerican Champion 8GCBC · S/N 433-2001Built 2001 · Mouzakis Shaun Kevin IIN6918DPiper PA-23-160 · S/N 23-2038Built 1962 · Tucker Christopher WN7929PPiper PA-24-250 · S/N 24-3163Built 1962 · Smh Aviation LLCN852SSBell 206L-3 · S/N 51270Ag Air IncN8840UCessna 172F · S/N 17252751Built 1965 · Hathor Aviation LLCN9077TCessna 182C · S/N 52977Built 1960 · Megilligan Scott MN9476BCessna 175 · S/N 55276Built 1958 · Higher Calling LLCN9614HCessna 172M · S/N 17266265Built 1975 · C&H Elite Air LLCN9621VCessna 172M · S/N 17264401Built 1974 · Hathor Aviation LLCN9958DPiper PA-22-150 · S/N 22-6748Built 1959 · Moore William H
Back to Johnstown, CO