Highlands Ranch, CO
Registered aircraft · 46
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 = 'HIGHLANDS RANCH' 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 = 'HIGHLANDS RANCH' 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.
N1025VCessna R172K · S/N R1722086N139KFWight Albert A KITFOX SPEEDSTER · S/N KCS139N179ESlingsby DART T.51 · S/N 1471N180MJCessna 180 · S/N 31607N184GLMeyer George C W ZENITH CH-250M · S/N 150A3579GMN193CGRosel George F LANCAIR IV-PT · S/N LIV-487N223DFCirrus Design SR22T · S/N 8927N239SECessna 421B · S/N 421B0315N25529Balloon Works FIREFLY 8B-15 · S/N F8B-423N255SWCirrus Design SR22 · S/N 2473N28JDNorth American T-28A · S/N 50-300N303DWCirrus Design SR22T · S/N 10231N340MGCessna 340A · S/N 340A0769N34777Cessna 177B · S/N 17702000N388ANicolaas W Hanekom VELOCITY SUV · S/N 001N388HWin-Lynn Series LANCAIR ES-P · S/N ESP-201N38KGCentrair 101A · S/N 101A0129N408JMMoore James P RV8 · S/N 80380N426RBeech C35 · S/N D-3188N509RSCessna 414A · S/N 414A0060N521SGMooney M20R · S/N 29-0362N529NGPilatus PC-12/47E · S/N 1529N537JHBellanca 7KCAB · S/N 533-75N5393TCessna 182K · S/N 18257628N605VVBombardier CL-600-2B16 · S/N 5773N612TKThomas J Krueger VANS RV7 · S/N 73926N614XGPiper PA-28R-201T · S/N 28R-7703262N6293UMooney M20C · S/N 2132N647JAWright T J/Anderson J P VELOCITY RG · S/N DMO 374N64VLLunceford Jerry W LANCAIR 360 · S/N 1001-320-841Registration pendingN6622VBellanca 17-30A · S/N 30270N6665VBellanca 17-30 · S/N 30035N733DMCessna 172N · S/N 17268215N816ETDJI MAVIC PRO · S/N 08QDDCN0120164First renewal noticeN821WWCessna 182T · S/N 18281828N837REHawker Beechcraft 4000 · S/N RC-54N8458XCessna 172C · S/N 17248958N8533XCessna P172D · S/N P17257133N858TNCirrus Design SR22T · S/N 1858N9204TCessna 180C · S/N 50704N9403QBeech 58 · S/N TH-54N9599TCessna 210 · S/N 57399N9744MMooney M20C · S/N 670038N97803Cessna 182Q · S/N 18267197N987MPEpic E1000 · S/N K067N992LBCessna 182P · S/N 18263982
Back to Highlands Ranch, CO