Wheat Ridge, CO
Registered aircraft · 66
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 = 'WHEAT RIDGE' 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 = 'WHEAT RIDGE' 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.
N1094FCessna 172N · S/N 17272957N12PPBeech B-60 · S/N P-334N1403GBeech 95-A55 · S/N TC-227N144RUPiper PA-44-180 · S/N 44-7995323N1735MCessna 182P · S/N 18264421N184AFCessna 172R · S/N 17281184N201THCessna 172R · S/N 17280201N233GGAdams Balloon Loft EGG · S/N 404N239DAAller Daniel L KITFOX CLASC IV-1200 · S/N C9610-0177N273SBBergner Lee Stewart RV4 · S/N 1615N2803ASocata TB-20 TRINIDAD · S/N 1036N2882CPiper PA-44-180 · S/N 44-7995302N2913ECessna 172N · S/N 17271371N292FWWallace Fred STOL CH 801 · S/N 8-4220N30147Piper PA-28-181 · S/N 28-7990085N3027SPiper PA-28-181 · S/N 28-7990310N31399Piper PA-28-161 · S/N 28-7816556N3162LCessna 310J · S/N 310J0162N3517SCessna 172R · S/N 17281083N3961Potter PITTS SPECIAL S-1C · S/N 563EPN4052FPiper PA-28-181 · S/N 28-7790002N413EBCessna 172RG · S/N 172RG0113N41498Piper PA-28-151 · S/N 28-7415237N4184MPiper PA-28R-201 · S/N 2844062N41DRPiper PA-38-112 · S/N 38-81A0060N429HSmith Ronald L HATZ CB1 · S/N 470N4345GPiper PA-28-161 · S/N 28-8416061N442MKPiper PA-44-180 · S/N 44-7995301N442SAPiper PA-44-180 · S/N 44-7995071N4547ECessna 172N · S/N 17271626N45941Cessna 152 · S/N 15282952N4632FPiper PA-28-181 · S/N 28-7790051N4709RCessna 172RG · S/N 172RG0013N485LMTed E Mayfield FISHER 101 · S/N 77N5088KCessna 172N · S/N 17273959N5178SCessna 172R · S/N 17281097N5199JCessna 172S · S/N 172S9097N52160Cessna 172P · S/N 17274424N5353GPiper PA-28R-201 · S/N 2844078N5412VCessna 172RG · S/N 172RG0524N59KPPeters Kerry VANS RV-4 · S/N 4175N61GSCessna 152 · S/N 15281609N625HACessna T182T · S/N T18208626N6271JPiper PA-28-181 · S/N 28-7690388N6402VCessna 172RG · S/N 172RG0664N65440Cessna 152 · S/N 15281554N65584Cessna 152 · S/N 15281634N6587ECessna 172N · S/N 17272040N6667UMooney M20C · S/N 2394N68806Cessna 152 · S/N 15282383
Back to Wheat Ridge, CO