OpenAirDocs.org
Boulder, CO

Registered aircraft · 221

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

N100MLBeech 58 · S/N TH-249Built 1972 · Ml Aviation LLCN1026BBeech E50 · S/N LH-163Built 1956 · Bazler Jack A TrusteeN1037ZCanadian Car & Foundry NORSEMAN MARK V · S/N N-29-5Built 1945 · Elliott David PN1068CCessna T182T · S/N T18208822Built 2008 · Gunlock Michael GN1090JCessna 172S · S/N 172S10271Built 2006 · Rocky Mountain Flight Consultants LLCN10LZShell George R RUTAN LONG EZE · S/N 1324Built 1998 · Breakell Walter JN110DKCirrus Design SR22T · S/N 10414Built 2025 · Zeus Boulder Aviation LLCN110EZHuss Ian ION EZE · S/N 001Built 1998 · Huss IanN111JKKendrick Harold J VARI-EZE · S/N 476Built 1983 · King Gailyn MN113JCPiper PA-28-236 · S/N 28-8211027Built 1982 · Mcdonnell Bryant EN114ECScottish SERIES 100 MDL 101 · S/N BH100/132Built 1971 · Bulldog132llcN1209MCessna 182P · S/N 18264243Built 1975 · Shook Steve TrusteeN120SPiper PA-24-250 · S/N 24-125Built 1958 · Glenn RobertN1252MCessna 182P · S/N 18264259Built 1975 · Nyquist DavidN128CRCurt Randoll RANS S-7S COURIER · S/N 1014702Built 2019 · Randoll Curtis WN12JAPipistrel D O O ALPHA TRAINER · S/N 1119 AT 912 LSABuilt 2022 · Journeys Aviation IncN134BCSchweizer SGS 1-34 · S/N 85Built 1973 · Journeys Aviation IncN15113Firefly Balloons FIREFLY 8 · S/N F8-2001Built 2001 · Life Cycle Balloon Adventures LtdN151JWStemme S10-V · S/N 14-008Built 1994 · Hanzel Karl EN162GLDiamond Aircraft Ind DA 40 · S/N 40.1162Built 2012 · Boulder Aviation Partners LLCN162HHayes Doug ROTORWAY EXEC 162F · S/N 6710Built 2004 · Hayes DougN1721CCessna 180 · S/N 30421Lemons Air LLCN17939Schweizer SGS 2-33A · S/N 294Built 1973 · Journeys Aviation IncN17NLExtra Flugzeugbau EA 300/L · S/N 014Built 1995 · Aerospatial Systems LLCN180JVCessna 180 · S/N 30136Built 1953 · Bf Aviation LLCN1814TSchlachter Michael C VANS RV-10 · S/N 42092Built 2023 · Schlachter Michael CN192JNYoungblut John E EARLYBIRD 2/3 JN4D · S/N 002Youngblut John EN192SShort Brothers S312 TUCANO T MK1 · S/N T16Built 1989 · Falcon Air IncN1MNSwearingen SA227-TT · S/N TT-486ABuilt 1981 · Dukes Garage LLCN201VNMooney M20J · S/N 24-0248Built 1977 · Przebinda ViktorN2021MMooney International M20TN · S/N 31-0138Built 2015 · Kunkel David LN202MMPipistrel Italia S R L VIRUS SW · S/N 1110 SWN 100 IS LSABuilt 2023 · Journeys Aviation IncN2054ECessna 172N · S/N 17271133Built 1978 · Jamieson Mark SN205XXKazan Helicopters MI-17-V5 · S/N 703M01Built 2007 · Red Air Transport LLCN206XCessna TP206C · S/N P206-0479Built 1968 · Kennedy BenjaminN206XXKazan Helicopters MI-17-V5 · S/N 004M160Red Air Transport LLCN208CNTextron 208B · S/N 208B5415Built 2017 · Churchill Navigation Inc DBAN210KKCessna P210N · S/N P210-00586Built 1980 · Kunkel David LN2121EAeronca 7AC · S/N 7AC-5692Built 1946 · Bage Air LLCN214LHAmerican Champion 7GCAA · S/N 494-2005Built 2005 · Rocky Mountain Flight Consultants LLCN216BDCirrus Design SR22T · S/N 1550Built 2017 · Boldmethod Air LLCN2186Sportavia-Putzer FOURNIER R.F.4.D · S/N 4066Built 1968 · Schipper Doedo WN2192UFirefly Balloons FIREFLY 8B-15 · S/N F8B-2049Weaver David BN2193GMooney M20M · S/N 27-0294Built 2000 · Westward AviationN2250Flug & Fahrzeugwerke FFA HBV-DIAMANT 16.5 · S/N 019Built 1967 · Rubber Yo YoN231TFMooney M20K · S/N 25-0013Built 1978 · Aerospatial Systems LLCN23SGSchempp-Hirth DISCUS CS · S/N 052-CSBuilt 1991 · Soaring Society Of Boulder IncN240XXMil MI-171E · S/N 171E00643157509UBuilt 2016 · Red Air Transport LLCN241XXMil MI-171E · S/N 171E00643157510UBuilt 2016 · Red Air Transport LLCN242XXMil MI-171E · S/N 171E00643157511UBuilt 2016 · Red Air Transport LLC
Back to Boulder, CO