OpenAirDocs.org
Basalt, CO

Registered aircraft · 26

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

N1033BGeide Richard F SPORT-A · S/N 1Built 1979 · Rudd Wayne GN11ZGRobinson Helicopter R66 · S/N 0769Built 2017 · White Star Marine Services LLCN22CGCessna 441 · S/N 441-0119Built 1979 · 316 Extreme LLCN27550Beech V35 · S/N D-8465Built 1967 · Anderson Herman AN27782Stinson SR-10E · S/N 5949Built 1940 · Rudd WayneN3182ANational Ballooning 858 · S/N 168Wood Bruce LN4111ACameron Balloons A-315 · S/N 6082Built 1997 · Above It All Balloon Co IncN4141DCameron Balloons US N-145 · S/N 5682Built 1991 · Above It All Balloon Co IncN434TCThunder & Colt Airborne Amer 240A · S/N 2258USABuilt 1992 · Above It All Balloon Co IncN442SHRobinson Helicopter R44 II · S/N 10626Built 2005 · Rudd Wayne GN5271EAerostar International S-77A · S/N S77A-3033Built 2000 · Camelot BalloonsN5289AAerostar International S-66A · S/N S66A-3066Above It All Balloon Co IncN5546HCessna T182 · S/N 18267873Built 1981 · Moore Thomas PN600PCAmerican Champion 8KCAB · S/N 714-93Built 1993 · Rudd WayneN618WZCameron Balloons US Z-105 · S/N 6798Built 2016 · Above It All Balloon Co IncN641CMConsolidated Vultee BT-13 · S/N 1479Built 1941 · Rudd Wayne GN65391Cameron Balloons US A-140 · S/N 6714Built 2013 · Above It All Balloon Co IncN69533Cameron Balloons US A-180 · S/N 6796Built 2016 · Above It All Balloon Co IncN703WMCessna T182T · S/N T18208461Built 2005 · Moore TomN788TKRobinson Helicopter R44 II · S/N 10703Built 2005 · Rudd Wayne GN82949Piper PA-18-150 · S/N 18-7909033Built 1978 · Mcbride Peter MN8414PPiper PA-24-400 · S/N 26-8Built 1965 · Rudd WayneN8569CPiper PA-18-135 · S/N 18-2720Built 1954 · Rudd Wayne GN90783Robinson Helicopter R22 · S/N 0290Built 1982 · Rudd Wayne GN91355Aerostar International S-71A · S/N S71A-3020Built 1998 · Camelot Balloons IncN95650Cessna 182Q · S/N 18266591Jnl Leasing LLC
Back to Basalt, CO