Grand Junction, CO

Registered aircraft · 162

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 = 'GRAND JUNCTION'
  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.

N102ESSpirit Engineering SE-1 · S/N 046Spirit Engineering IncN103DAerocar ONE · S/N 2Built 1956 · Felling CarlN111ESSpirit Engineering SE-1 · S/N 047Spirit Engineering IncN112SESpirit Engineering SE-1 · S/N 002Built 2025 · Spirit Engineering IncN113SESpirit Engineering SE-1 · S/N 001Built 2024 · Spirit Engineering IncN114ABBernard L Hartnell RV 14A · S/N 140102Built 2018 · Hartnell Bernard L TrusteeN114ESSpirit Engineering SE-1 · S/N 048Spirit Engineering IncN1204CCessna T182T · S/N T18208026Built 2001 · Carvilles Auto MartN120ESSpirit Engineering SE-1 · S/N 049Spirit Engineering IncN124ESSpirit Engineering SE-1 · S/N 050Spirit Engineering IncN125BKBeech 200 · S/N BB-977Built 1982 · Coloramo Federal Credit UnionN128ESSpirit Engineering SE-1 · S/N 051Spirit Engineering IncN132ESSpirit Engineering SE-1 · S/N 052Spirit Engineering IncN133DBMooney M20J · S/N 24-1275Built 1982 · 3h Mech LLCN138CLDiamond Aircraft Ind DA20-C1 · S/N C0038Built 1998 · Kempton Larry G JrN141ESSpirit Engineering SE-1 · S/N 053Spirit Engineering IncN143ESSpirit Engineering SE-1 · S/N 054Spirit Engineering IncN145ESSpirit Engineering SE-1 · S/N 055Spirit Engineering IncN14734Bellanca 17-31A · S/N 75-32-154Built 1974 · Thorman Bryan RN151ESSpirit Engineering SE-1 · S/N 056Spirit Engineering IncN1537CCessna 180 · S/N 30237Built 1953 · Wbs Coatings IncN155ALH&S LIGHTNING · S/N 9Irvin Roger HN155ESSpirit Engineering SE-1 · S/N 057Spirit Engineering IncN177ESSpirit Engineering SE-1 · S/N 058Spirit Engineering IncN1812QCessna TU206F · S/N U20602936Built 1975 · Liv2fly LLCN1814FCessna 210E · S/N 21058714Built 1965 · Alpine Cable And Construction IncN185AFCessna A185F · S/N 18502236Built 1973 · Tanada Lake Lodge LLCN1869EAeronca 7AC · S/N 7AC-5436Built 1946 · Miller Randall DN1879PPiper PA-18-150 · S/N 18-4158Wbs Coatings IncN187ESSpirit Engineering SE-1 · S/N 059Spirit Engineering IncN188ESSpirit Engineering SE-1 · S/N 060Spirit Engineering IncN202RDouglas B-26C · S/N 28880Lone Star Express LlpN2112YCessna 172D · S/N 17249612Built 1962 · Colorado Flight Center IncN2304GCessna 182B · S/N 51604Built 1958 · High Mountain Aviation LLCN2309GCessna 182B · S/N 51609Built 1958 · Equipment & Machinery Appraisal LLCN237HExtra Flugzeugbau EA 300/L · S/N 022Built 1996 · Hatfield R AndrewN24487Taylorcraft BL-65 · S/N 1827Built 1940 · Popp Walter EN2470CCessna 180 · S/N 30770Mcclymond Tyler LN2778ARyan NAVION A · S/N NAV-4-862Feather Gerald BN283SSPiper PA 46-350P · S/N 4636080Built 1997 · Smith Scott RN284ADAerial Delivery Services AG-36X4-GEN · S/N 1910F916ARG13BK9CJB3Archon Drone Services LLCN2904CPiper PA-28RT-201T · S/N 28R-7931250Kempton Larry G JrN291WCPiper PA-28-181 · S/N 28020052Built 2022 · Colorado Mesa UniversityN292WCPiper PA-28-181 · S/N 28020053Built 2022 · Colorado Mesa UniversityN293WCPiper PA-28-181 · S/N 28020054Built 2022 · Colorado Mesa UniversityN2973ACessna 180 · S/N 30173Built 1953 · Red Aero LLCN3007KPiper PA-28-181 · S/N 28-7990248First renewal noticeBuilt 1978 · C & B PartnershipN302ESSpirit Engineering SE-1 · S/N 061Spirit Engineering IncN3041FCessna 182J · S/N 18257141Built 1966 · Roffey Edward P TrusteeN304ESSpirit Engineering SE-1 · S/N 062Spirit Engineering Inc
Back to Grand Junction, CO