Parker, CO
Registered aircraft · 135
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 = 'PARKER' 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 = 'PARKER' 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.
N102CVRobinson Helicopter R44 · S/N 0570N109DJLewis Jeffrey/Chancellor David RV-10 · S/N 41650N10THHarrison Ted W RV-4 · S/N 2653N1114ACessna 208B · S/N 208B0309N111ETCirrus Design SR22 · S/N 3270N116CWCarlos Walter Jazun RV-7 · S/N 0073385N120WBSchleicher ASW-20 · S/N 20361N121PHMooney International M20V · S/N 33-0018N124CHMaule M-4-220C · S/N 2001CN1306KSilvaire LUSCOMBE 8A · S/N 4033N14JMCessna 180J · S/N 18052475N182BMCessna 182P · S/N 18262868N1902BLuscombe 8F · S/N 6329N19508Cessna 150L · S/N 15074459N206CBPiper PA-28-140 · S/N 28-7425230N206DZCessna 206 · S/N 206-0185N208DECessna 208B · S/N 208B0502N21442Piper PA-28-181 · S/N 28-7990048N22117Piper PA-32RT-300T · S/N 32R-7887244N22232Cessna T210L · S/N 21059730N243JSSaurer John M ZENITH STOL CH750 · S/N 7836N2505FChampion 7ECA · S/N 127N250BGDornier Luftfahrt 328-100 · S/N 3025N2569ZCessna 185B · S/N 185-0569N264HUMaule M-4-220C · S/N 2012CN28307Grumman American Avn. AA-5B · S/N AA5B0551N289STPiper PA-28-181 · S/N 2881039N29261Piper J3C-65 · S/N 16959N2973MPiper PA-12 · S/N 12-1460N29JMJames Mckinstry RV14 · S/N 141081N2HUCessna R182 · S/N R18200447N3027BCessna 195B · S/N 7910N30319Boone Douglas M ROTORWAY 162-F · S/N 3279N3067FCraw Keith VANS ACFT RV-8 · S/N 81664N315DWCirrus Design SR20 · S/N 11358N317JKAviat PITTS S-2C · S/N 6081N31RSKeith M Craw XENOS MOTOR GLIDER · S/N XNB0021N32005Waco UPF-7 · S/N 5636N320CJCessna 525B · S/N 525B0120N320WKExtra Flugzeugproduktions UND EXTRA NG · S/N NG012N32295Stinson 10A · S/N 7943N322NHBeech J35 · S/N D-5646N32BHBeech V35B · S/N D-10046N33ZLJonker Sailplanes JS3 · S/N 03-148N342FGPiper PA-28-181 · S/N 28020042N3478QCessna 320E · S/N 320E-0078N3497DCessna 170B · S/N 27040N355BZN355bz HELICYCLE · S/N 02-28-08N357BDCirrus Design SR22T · S/N 0618N3620XAero Commander 100-180 · S/N 5097
Back to Parker, CO