Cortez, CO
Registered aircraft · 26
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 = 'CORTEZ' 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 = 'CORTEZ' 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.
N114FBeech 95-A55 · S/N TC-347N114MTRockwell International 114 · S/N 14068N142WMooney M20C · S/N 2219N2018MPiper PA-28R-201T · S/N 28R-7803100N2045ZCessna 150C · S/N 15059845N242FMSteve Franchini/Kenneth Mahaff VANS RV-10 · S/N 42086N2468KLuscombe 8E · S/N 5195N2473CCessna 180 · S/N 30773N2804YCessna 182E · S/N 18253804N3163VCessna 182F · S/N 18254563N316RWCessna T210N · S/N 21063447N33082Piper J5A · S/N 5-431N35957Cessna TU206F · S/N U20602829N365JBell 206B · S/N 4632N5059JAir Tractor AT-402B · S/N 402B-1039N51330Cessna 172P · S/N 17274298N52RUS C Aerostar S A YAK-52 · S/N 845012N5395VCessna T210L · S/N 21060930N6092DPiper PA-18A 150 · S/N 18-5459N6651UMooney M20D · S/N 146N6879KGrumman Acft ENG Cor-Schweizer G-164B · S/N 508 BN6880KGrumman Acft ENG Cor-Schweizer G-164B · S/N 509BN6ZTPiper PA-18-150 · S/N 18-5824N74ELCarlos Garza LANCAIR · S/N 010N7573QCessna A185F · S/N 18503615N9470WPiper PA-28-235 · S/N 28-11196Registration pending
Back to Cortez, CO