OpenAirDocs.org
Gypsum, CO

Registered aircraft · 24

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

N104BUCessna 182E · S/N 182543521984k LLCN104GPBouley Joseph L JR GLASTAR · S/N 5302Built 2010 · Kline Michael SN162PMPiper PA-30 · S/N 30-72Built 1963 · French LorenN2123APiper PA-28-181 · S/N 28-7990105Built 1978 · Itechnology Design IncN25MPWilmot Philip S VANS RV-4 · S/N 2371Built 2000 · Selander Hazel BN3440XMooney M20E · S/N 1130Built 1966 · Churches Tyler AN43616Taylorcraft BC12-D · S/N 7275Built 1946 · Selander Hazel BN4857UCessna 210-5A(205A) · S/N 205-0557Built 1964 · Colorado Aviators LLCN5081VVarga 2150A · S/N VAC-70-77Built 1977 · Walker Gregory SN52726Cessna 182P · S/N 18262800Built 1974 · Cottonwood Flyers LLCN6014JCessna T182T · S/N T18208531Built 2006 · Due West Aviation LLCN6850BCessna T210M · S/N 21062845Jennings Donald JN685TLCirrus Design SR22T · S/N 0970Built 2015 · Seefeeltrust LLCN714JMCessna LC41-550FG · S/N 411121Built 2008 · J&S Landings LLCN7319QCessna 182P · S/N 18260959Built 1972 · Bassett Robert CN7542CForney F-1 · S/N 5657Built 1958 · Sinclair Leonard AN7683MCessna 175 · S/N 55983Harmon Katlyn EN81625Huempfner Reinhold KOLB FIRESTAR II · S/N K-R/1073-394012Built 1995 · Mcelderry Stanley RN862JMCirrus Design SF50 · S/N 0495Built 2023 · Hip Flights LLCN8724WPiper PA-28-235 · S/N 28-10259French Loren CN909VJDassault-Breguet FALCON 50 · S/N 69Built 1981 · Wc Aviation LLCN90TLCessna P210N · S/N P21000206Built 1979 · Colorado Aviators LLCN9127WPiper PA-28-235 · S/N 28-10744Built 1966 · Deshayes Eric ThorsonN9671CPiper PA-28-181 · S/N 28-7890435French Loren
Back to Gypsum, CO