OpenAirDocs.org
Castle Rock, CO

Registered aircraft · 70

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 = 'CASTLE ROCK'
  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.

N100SDCessna 182C · S/N 52853Built 1960 · Divan Jeremy EN102HSSchempp-Hirth VENTUS-2B · S/N 16Registration pendingBuilt 1995N140PCCessna 172N · S/N 17268241Built 1976 · Navigation Leasing LLCN152SACessna 172S · S/N 172S11275Built 2013 · Xd Aviation LLCN16097Cessna 150L · S/N 15073474Built 1972 · Crosswind Capital LLCN16RNNixon Robert R RV-6 · S/N 24755Built 2000 · Swanson Kristopher JN17BMTextron 172S · S/N 172S12978Built 2023 · Navigation Leasing LLCN17WKAviat A-1B · S/N 2158Ohnigian Steven PN2035VCessna 140 · S/N 14248Built 1947 · Reall George DN2039WBeech 35-C33 · S/N CD-969Built 1965 · Witt Ted CN20JWBeech 95-A55 · S/N TC-258Built 1962 · Rocky Mountain Triangle LLCN2134NPiper PA-28RT-201T · S/N 28R-7931048Built 1979 · Painter Christopher RN21MSMooney M20R · S/N 29-0197Built 1999 · Van Hanna Flying Circus LLCN224DWSchempp-Hirth DISCUS A · S/N 62Reid MichaelN224QAKolb MARK III XTRA · S/N M3X 19-3-000115Built 2020 · Williams JonathanN2318VCessna 140 · S/N 14554Built 1947 · Jones Stanley EN23AXBrugemann J A Z M Sief LANCAIR IV-P · S/N LIV389ABuilt 2009 · Clayton Restorations LtdN2520ZBuckeye DREAM MACHINE · S/N 3220Built 1994 · Lillehaugen Grant AN2568SBalloon Works FIREFLY 8B-15 · S/N F8B-437Built 1993 · Rutherford Marcia AN2599EAeronca 7AC · S/N 7AC-6181Pechon Sean CN313CAMckinstry PITTS SPECIAL S-1LD · S/N 7-0060JM-3LDBuilt 1977 · Buckley Robert Lee JrN313CZBuckley Robert L JR RV-7 · S/N 71122Built 2009 · Buckley Robert L JrN313LNPiper PA-28-180 · S/N 28-2571Bazal Jared WN31MKCirrus Design SR22T · S/N 9626Built 2023 · Turbonium LLCN330XXExtra Flugzeugproduktions-Und EA 300/LC · S/N LC050Built 2015 · One Hard Zero LLCN3331QPiper PA-28-161 · S/N 28-7716148Built 1977 · Evangelista RonaldN3344SMooney M20E · S/N 710Built 1965 · Lewis James P JrN3638QBeech A23-19 · S/N MB-251Built 1967 · Winder Keven SN402XTRaytheon 400A · S/N RK-274Built 2000 · Guntrack Aviation LLCN4064RPiper PA-32-300 · S/N 32-40372Built 1967 · Hissem John TN41698Bellanca 7ECA · S/N 980-73Built 1973 · Collier James RN44HRCessna T210M · S/N 21062685Built 1978 · Cardinal Aviation Services LLCN480EDHylio AG-216 · S/N 17906090238Douglas County ColoradoN4950LPiper PA-28-180 · S/N 28-4320Built 1967 · Desimone Joseph LN5112VMorrisey 2150A · S/N SP-12Built 1961 · Mertz Harry ZN51LVVarner David L VANS RV-8 · S/N 81871Built 2008 · Neal Darren IN522PMPiper PA 46-350P · S/N 4636568Registration pendingN526LKTextron 172S · S/N 172S12923Built 2022 · Kenzy 2022 LLCN5461SCessna TR182 · S/N R18201577Built 1980 · Carter Kenneth M JrN546BPiper PA-28-181 · S/N 2881105Built 2019 · Navigation Leasing LLCN555XDAmerican Champion 8KCAB · S/N 1135-2013Built 2013 · Xd Aviation LLCN55MSStick And Rudder CCX-2300 · S/N CCX-2300-0082Built 2023 · N55ms LLCN562ABCessna 172S · S/N 172S9545Navigation Leasing LLCN580ETTextron 172S · S/N 172S12990Built 2023 · Trede 2023 LLCN6711NMooney M20C · S/N 680045Built 1968 · Hanna William RN6819ZRick G Holland AIRCAMPER · S/N 1968Built 2013 · Holland Rick GN683SPCessna 172S · S/N 172S8094Built 1999 · November 243 Bravo Mike LLCN703BKTextron 172S · S/N 172S12991Built 2023 · Kenzy 2023 LLCN7138WPiper PA-28-180 · S/N 28-962Built 1962 · Bazal JaredN724DCHead Balloons AX8-105 · S/N 457Built 2017 · Liberti Christopher M
Back to Castle Rock, CO