Windsor, CO
Registered aircraft · 45
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 = 'WINDSOR' 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 = 'WINDSOR' 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.
N10CTJabiru Aircraft PTY J230-D · S/N 993N1159MRaymond Middleton FALCO F8L · S/N 1159N12063Naval Aircraft Factory N3N-3 · S/N 2996N130KBDJI AGRAS T40 · S/N 1581F574B235W00100CBN149RVVance Ronald F BEDE IV · S/N 1032N182RFCessna 182J · S/N 18257620N1835PPiper PA-22 · S/N 22-2686N18JHBeech 95-A55 · S/N TC-495N1966YMooney M20D · S/N 231N21KDCessna 414A · S/N 414A0439N2208FFirefly Balloons FIREFLY 7-15 · S/N F7-2029N231TBMooney M20K · S/N 25-0235N23PWHaehn John D RV-4 · S/N 1162N320DKOlsen Daniel M LANCAIR 320 · S/N 363-320-SFBN320RSSpace Roy D LANCAIR 320 · S/N 439-320-189-FBN32299Piper PA-28-151 · S/N 28-7515116N366AADJI T20P · S/N 1581F574B224A00100DVN36818Aeronca 65-TAC · S/N F1581TAN378BGRaytheon B300 · S/N FL-453N412LBDJI T40 · S/N 64TBL8H002006SN41DHDehavilland TIGER MOTH DH 82A · S/N 84734N453DMMcewen Dick L RV-7A · S/N 71963N4745MPiper PA-11 · S/N 11-263N474BSGeoffrey Sluyter S-21 OUTBOUND · S/N 09220289N50FUSchleicher Alexander ASH 26 E · S/N 26248N550JEBeech M35 · S/N D-6356Registration expired, pending cancellationN57371Piper PA-28-180 · S/N 28-7405046N58801Cirrus Design SR22T · S/N 1099N596DCDJI AGRAS T40 · S/N 1581F574B226S0010210N6316CAerostar International RX 8 · S/N RX8-3105N6926ECessna 175A · S/N 56426N7045VMooney M20C · S/N 20-1203N70568Balloon Works FIREFLY 8B-15 · S/N F8B-614N72043Luscombe 8A · S/N 3470N731RRCessna P210N · S/N P21000538N7448MCessna 175 · S/N 55748N7638ZPiper PA-18-150 · S/N 18-8403N768HSXag P100 PRO · S/N 1863FPEG8219425K1G05Sale reportedN774KBBauer Kris B VANS RV-7A · S/N 72060N7903PPiper PA-24-250 · S/N 24-3133N799WMRans Employee Flying Club S-7COURIER · S/N 1098231N861CDDavid A Hansell VANS RV-10 · S/N 42258N8940AAdams Balloons A60-S · S/N 286N9086QBalloon Works FIREFLY 7-15 · S/N F7-753N9687TCessna 210 · S/N 57487
Back to Windsor, CO