OpenAirDocs.org
Watkins, CO

Registered aircraft · 50

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

N1008ACessna 402 · S/N 402-0097Built 1967 · Aerial Surveys International LLCN103BUPiper PA-31-350 · S/N 31-7405202Colorado Aircraft CorpN103ECCessna 401 · S/N 401-0135Built 1967 · Aerial Surveys International LLCN106REPiper PA-31-350 · S/N 31-7752056Colorado Aircraft CorpN109XSFolland GNAT T 1 · S/N XS109Denver Aerospace MuseumN123KJFairchild C-123K · S/N 54-0659Built 1954 · Astre Air InternationalN16493Bell UH-1H · S/N 66-16493Astre Air InternationalN20DTThermal Flites MONERAI · S/N 314Built 1982 · Denver Aerospace Science MuseumN210EZPiper PA-28-181 · S/N 28-7990077Built 1978 · Faulkison Brian SN2506WBeech B24R · S/N MC-165Heiss William RN25EDDavis Eric L LONG-EZ · S/N 418Haynes Douglas EdwardN2JJCessna 401 · S/N 401-0235Built 1968 · Aerial Surveys International LLCN301GMDouglas E Haynes DEHAS DHGM 12 · S/N 0001Haynes Douglas EdwardN30260Piper PA-28-181 · S/N 28-7890452Built 1978 · Schubert Mark JN334XWBac JET PROVOST MK5A · S/N XW334Built 1998 · Astre Air IntlN34MMCessna 401 · S/N 401-0125Built 1967 · Schubee Air IncN35689Piper PA-28-181 · S/N 28-8090193Built 1979 · Faulkison Brian SN36JTRockwell International 695 · S/N 95-024Built 1980 · Aerial Surveys International LLCN372CZTextron 525C · S/N 525C0372Built 2022 · Ccp Aviation LLCN373XWBac JET PROVOST MK5A · S/N XW373Astre Air InternationalN38CJCessna 402C · S/N 402C0023Built 1978 · Airplane Seven LLCN40029Piaggio P.136-L1 · S/N 220Astre Air InternationalN400CMPiper PA-31T · S/N 31T-7620040Built 1976 · Aerial Surveys International LLCN4273CHunting P66 PEMBROKE · S/N PAC/W/781Mulvey John RN427XWBritish JET PROVOST T MK5 · S/N EEP/JP/1049Astre Air InternationalN4367LFolland GNAT T 1 · S/N XR-955Built 1963 · Denver Aerospace Science MuseumN453LPCessna 182S · S/N 18280453Built 1999 · Frsp LLCN49461Cessna 152 · S/N 15281287Built 1978 · Blue Sky Aviation LLCN50826Cessna 172P · S/N 17274222Bristol Bay Capital LLCN55250Cessna 172P · S/N 17275144Built 1981 · Colorado Aircraft CorpN622DLCessna 172M · S/N 17264853Built 1975 · Colorado Aircraft CorpN66091Cessna 172Q · S/N 17275964Built 1982 · Ftg Leasing LLCN70ZLCameron Balloons US ZL-70 · S/N 6631Built 2011 · Cwc Balloons LLCN711DHHaynes Douglas Edward HSGS 711 · S/N 71100AHaynes Douglas EdwardN711HHDouglas E Haynes DEHAS DHDL 08 · S/N 0001Haynes Douglas EdwardN739BECessna 172N · S/N 17270866Built 1978 · Ftg Leasing LLCN739ZCCessna 172N · S/N 17270928Built 1978 · P&B Aviation LLCN739ZPCessna 172N · S/N 17270939Built 1978 · Blue Sky Aviation LLCN771SJDouglas E Haynes DEHAS DHJS 07 · S/N 0001Haynes Douglas EdwardN7928SBell 47G-3B-1 · S/N 6598Built 1966 · Gardenville Project LLCN7931LBeech A23-24 · S/N MA-118Zundel Dana JohnN7999KBeech S35 · S/N D-7578Bristol Bay Capital LLCN800VBRockwell International 690C · S/N 11646Built 1980 · Aerial Surveys International LLCN8242VPiper PA-28RT-201T · S/N 28R-8031149Built 1980 · Faulkison Brian ScottN85MJCessna 310C · S/N 35772Zundel Dana JohnN8928FHughes 269A · S/N 0004Built 1964 · Denver Aerospace Science MuseumN936FCFolland GNAT T.MK.1 · S/N XR980Built 1964 · Astre Air InternationalN981LBArbc Inc DBA Lindstrand 105A · S/N 5620Built 2016 · Cwc Balloons LLCN989DECessna T206H · S/N T20608001Built 2000 · Aerial Surveys International LLCN998XRFolland GNAT T 1 · S/N FL592Astre Air International
Back to Watkins, CO