Colorado Springs, CO
Registered aircraft · 557
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 = 'COLORADO SPRINGS' 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.
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 = 'COLORADO SPRINGS' ORDER BY g.n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N100NEPiper PA-31-310 · S/N 31-7712022N1014Z101 Flying Assoc THORP T-18 · S/N 108N104LBLindstrand Balloons 105A · S/N 5079N1063GCram Joe VANS RV8 · S/N 80722N108MQRobinson Helicopter R44 II · S/N 11067N10ZRDouglas D Ritter DESERT FOX 1 · S/N 01N111KRLearjet 35A · S/N 464N112RSSheffield Raymond L VANS RV-6A · S/N 22785N1164Schleicher K 8 B · S/N 8542-SHN1168VCessna R172K · S/N R1722132N1177BAmerican Champion 8KCAB · S/N 651-91N117JPPiper PA-31-325 · S/N 31-7612086N1184EBellanca 7ECA · S/N 1217-77N118WMMackey William RV-8 · S/N 81274N11968Cessna 177B · S/N 17702383N11YSCessna 150H · S/N 15068608N121BRCirrus Design SR22 · S/N 1697N123FRSlingsby T67M-260 · S/N 2250N1256UCessna 172M · S/N 17266951N129AXMckinney Donald L VANS RV-6A · S/N 60326N12TNAmerican Champion 8KCAB · S/N 1127-2013N12YBBetty James C JR RV-4 · S/N 1146N1312NBoeing E75 · S/N 75-5742N13182Cessna 172M · S/N 17262552N1322Rockwell International 114 · S/N 14165First renewal noticeN13804Cessna 177B · S/N 17702470N144LPCubcrafters CC11-160 · S/N CC11-00144Registration pending, canceledN1499FZaklady Lotnicze Marganski MDM-1P FOX-P · S/N 247N15095Firefly Balloons FIREFLY 8B-15 · S/N F8B-2027N150SPPatriot CX1900A · S/N CX1900A-0001Sale reported, pending cancellationN1511JBalony Kubicek Spol Sro BB51Z · S/N 1770N153ALPowrachute AIRWOLF 912ULS · S/N A466ULSN154RVDavid Carl Goodwin IV RV-10 · S/N 004N1554SBeech 35-B33 · S/N CD-525N157MTNeil M Salmi SALMI NEIL RANS S-7S · S/N 0811562N1591DCessna 195A · S/N 7874N1598APiper PA-20 · S/N 20-836N15BWWelter William G JR LONG EZ · S/N 1675N15DQBellanca 17-30A · S/N 75-30773N15KQCharles D Morgan VANS RV-7 · S/N 71245N1647AFirefly Balloons GALAXY 11B · S/N GLX-1611BN167CSGarton C F/Kelling S G RV-6A · S/N 23197N169PSDiamond Aircraft Ind DA20-C1 · S/N C0169N16GLGreat Lakes 2T-1A-2 · S/N 0772N16JVNorth American T-6G · S/N 49-3155N16LSBellanca 14-19-3 · S/N 4150N170WSCessna 170A · S/N 19490N172TMCessna 172N · S/N 17270278N1776BAerostar International S-57A · S/N S57A-3225First renewal noticeN181DMMcclung Daniel W CHRISTEN EAGLE I · S/N M002First renewal notice
Back to Colorado Springs, CO