Littleton, CO
Registered aircraft · 119
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 = 'LITTLETON' 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 = 'LITTLETON' 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.
N118KCessna 501 · S/N 501-0686N129SECessna 182S · S/N 18280384N131GSAmerican Champion 8KCAB · S/N 839-99N1490BLuscombe 8F · S/N 6117N153CSCessna T182T · S/N T18209043N156MECessna 172S · S/N 172S8435N169EAPipistrel D O O VELIS ELECTRO · S/N VSWX1280097N170PMCentrair 101 · S/N 101A0098N177APCessna 177RG · S/N 177RG0304N17HLCessna 421B · S/N 421B-0310N18HUAviat A-1C-200 · S/N 3004N193SFPiper PA 46-350P · S/N 4636567N1DLStemme S10-VT · S/N 11-031N20SJMolino PIK-20B · S/N 20064N210TYCessna P210N · S/N P210-00252N2175SCessna T210L · S/N 21061136N222JDAerotek PITTS S-2B · S/N 5016N2317DPiper PA-38-112 · S/N 38-79A0269N231SRMooney M20K · S/N 25-0405N235DEStinson 108-3 · S/N 108-4566N235NDDiamond Aircraft Ind DA20-C1 · S/N C0035N2369MPiper PA-12 · S/N 12-1501N25556Balloon Works FIREFLY 8B-15 · S/N F8B-420N260JBSiai-Marchetti SF260 · S/N 2-54N262BBMooney M20K · S/N 25-0474N2665DJI INSPIRE 1 · S/N W13DCE26041786N2670YCessna 180E · S/N 18051170N272DSDiamond Aircraft Ind DA 40 · S/N 40.1188N282RCCardwell Ronald L RV-8 · S/N 83463N28BJPiper PA-34-220T · S/N 34-47017N29675Cameron Balloons N-105 · S/N 5064N303AMElan/Glaser Dirks DG-300 ELAN · S/N 3E486A27N303SBAmerican Champion 8KCAB · S/N 887-2001N3107TCessna 177 · S/N 17700407N322BWWaters Billy J TEAM ROCKET F-1 · S/N 026N333ANCirrus Design SR22T · S/N 0055N339AMills Scott I RV-9A · S/N 90493N34WBPierce PITTS S-1D · S/N 7-0319N360NCStephen A Page GLASAIR SUPER II S · S/N 2376N3746EBalloon Works FIREFLY 7 · S/N F7-120N4042DBalloon Works FIREFLY 7 · S/N 7855N405MKCirrus Design SR22T · S/N 1579N42526Cessna 180J · S/N 18052359N441CRCessna 425 · S/N 425-0149N441WFCessna 441 · S/N 4410115N4635WRockwell International 112TCA · S/N 13165N4848LCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC043N4866KRyan NAVION · S/N NAV-4-1866N4907PPiper PA-23-250 · S/N 27-498N49249Cessna 152 · S/N 15283442
Back to Littleton, CO