Fort Collins, CO
Registered aircraft · 165
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 = 'FORT COLLINS' 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 = 'FORT COLLINS' 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.
N100DMMoore Douglas R RV-14A · S/N 140037N106VBeech K35 · S/N D-6009N10XHScion Helicopters EAGLE R&D HELICYCLE · S/N 06-03N1162RRaven S55A · S/N S55A-324N117CMMurphy Chris VANS RV-4 · S/N 3000N1188MCessna 172K · S/N 17258688N11AAJonker Sailplanes JS3 · S/N 03-031N121DHMiller Charles W SKYBOLT · S/N M0001N124DBeech V35B · S/N 10002N124WSKing Wayne G PEGAZAIR 100 · S/N 001N125CKCraig Thomas Weinland CCK-1865 · S/N CCK-1865-1103N12TGCameron Balloons US O-90 · S/N 6651N1343TPiper PA-32-300 · S/N 32-7240114N1350VCessna R172K · S/N R1722178N1352UCessna 172M · S/N 17267023N148BCAmerican Champion 8GCBC · S/N 507-2008N1490RPrecision Hawk LANCASTER MK IV · S/N PCM-0V6-201623-009-VEXFirst renewal noticeN14UKThunder & Colt COLT 120A · S/N 2314First renewal noticeN1541WBeech A36 · S/N E-327N15695Piper PA-28-180 · S/N 28-7305120N1593XPiper PA-28R-200 · S/N 28R-7535345N15FSPiper PA-34-220T · S/N 34-8133046N16XHScion Helicopters SH-410 · S/N 001N17953Schweizer SGS 1-26E · S/N 553N179XPCessna R172K · S/N R1723155N17XHScion Helicopters SH-425 · S/N 001N182HCessna 182H · S/N 18255990N1870EBombardier BD-100-1A10 · S/N 20555N192MHHolland Mike RV9A · S/N 90556N1960TPiper PA-28R-200 · S/N 28R-7135173N1976KLuscombe 8E · S/N 4703N1989ZCessna 150C · S/N 15059789N2012UMaule M-4-220C · S/N 2011CN2046ZBeech A36 · S/N E-1396N2147PPiper PA-32-300 · S/N 32-7940042N218PMCirrus Design SR22 · S/N 0201N222ABBeech 95-B55 (T42A) · S/N TC-1527N222LHDJI PHANTOM 3 PROFESSION · S/N P76DC11N22WLBeech 35-C33A · S/N CE-41N2386MPiper PA-12S · S/N 12-1628N24BSMooney M20F · S/N 670495N2518FChampion 7ECA · S/N 136N2600CCameron Balloons US Z-105 · S/N 6428N261MCCirrus Design SR22T · S/N 1753N2646JArbc Inc DBA Lindstrand 105A · S/N 5565N2820VBeech 35 · S/N D-222N283TBCessna TU206G · S/N U20603956N286ACAir Creation USA ARV TANARG · S/N T12032N2896VBeech 35 · S/N D-304N291AKWalker Ryan D RANS S-6S COYOTE II · S/N 03101932
Back to Fort Collins, CO