Westminster, CO
Registered aircraft · 55
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 = 'WESTMINSTER' 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 = 'WESTMINSTER' 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.
N112SWBrown Garold L KB-3 · S/N 001N148DGGray Donald E CGS HAWK · S/N HAII-148-TD-503N16MJBeech K35 · S/N D-6023N182ARCessna 182G · S/N 18255472N207MSYermilov Aleksandr B MUSTANG II · S/N 001N24293Cessna T206H · S/N T20608608N2546GChampion 7ECA · S/N 421N260TTTextron B300 · S/N FL-1243N280DCCopp David G GLASAIR SIIS FT · S/N 2358N280SGEnstrom 280FX · S/N 2072N2889CCessna 170B · S/N 26432N425TACessna 182P · S/N 18264951N44941Piper PA-28R-201T · S/N 28R-7703344N477Merickel Theodore J RANS S-6-S · S/N JUMBON5114RBeech B19 · S/N MB-648N522VXCirrus Design SF50 · S/N 0656N5508NPatlovany Robert KR-2 · S/N 81455N5771VBeech A23-24 · S/N MA-22N6007CCessna R182 · S/N R18200348N60449Cessna 150J · S/N 15070316N61411Blanchard STOLP STARDUSTER SA- · S/N 1151N618TVans RV-12IS · S/N 12121N62XCMichael A Wise CUB R/C · S/N 01N633CACentrair 101 · S/N 101 083N651TBeech 95-A55 · S/N TC-471N6529QAlon A2 · S/N A-129N715AGPiper PA-28-235 · S/N 28-7310034N7309TCessna 172A · S/N 46909N7317YPiper PA-30 · S/N 30-360N75564Airborne EDGE · S/N 503-650N761EUCessna T210M · S/N 21062205N7650SBellanca 7GCBC · S/N 928-76N7840WPiper PA-28-180 · S/N 28-1857N795ESBrian M Schmid TORNADO 1 · S/N T95503SOHK0143N7963WPiper PA-28-180 · S/N 28-2012N809HSCirrus Design SR22T · S/N 8691N8125PPiper PA-24-250 · S/N 24-3378N818RDDomenico Ricky A RV9A · S/N 91030N8399SCessna 182H · S/N 18256499N8490GCessna 150F · S/N 15062590N8577Mooney M20C · S/N 2737N8615VBellanca 7KCAB · S/N 504-75N86KPPankratz Christopher K KITFOX 5 VIXEN · S/N ECV006N924GVEugene Vincent Spellman RUTAN LONG EZ · S/N 924N927GLCirrus Design SF50 · S/N 0644N929MSPowrachute PC 2000 · S/N A190POWN940EBNick Barr ANT · S/N 04-19-136N940WCessna 182H · S/N 18256606N9435WPiper PA-28-235 · S/N 28-11145N9523QBeech 35-C33A · S/N CE-23
Back to Westminster, CO