OpenAirDocs.org
Sterling, CO

Registered aircraft · 25

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 = 'STERLING'
  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.

N141GBeech E35 · S/N D-3975Built 1954 · Waller Steven MN1801JPiper PA-28-140 · S/N 28-24228Built 1968 · Moore Nicholas CoryN202EPCessna 182Q · S/N 18267673Built 1980 · Sonnenberg JerryN2138RMooney M20E · S/N 646Built 1965 · Wisdom VictorN2139APiper PA-18-135 · S/N 18-1861Built 1952 · Aero Seat IncN2322APiper PA-18A-135 · S/N 18-1898Built 1952 · Mertens Darrel WN2749KCessna 180K · S/N 18053059Built 1979 · Aero Applicators IncN31203Cummins-Walker-Hendrix RAND KR-2 · S/N 383Built 1976 · Markal Flying Club IncN33816Piper PA-28R-200 · S/N 28R-7535200Built 1975 · Hettinger John EN349ASAir Tractor AT-802A · S/N 802A-0603Built 2015 · Aero Applicators IncN4215WAir Tractor AT-402B · S/N 402B-1211Built 2009 · Aero Applicators IncN45BLBeech A36TC · S/N EA-101Built 1980 · King Air LLCN602DMAir Tractor AT-602 · S/N 602-1273Built 2016 · Aero ApplicatorsN60VWWilkerson Vernon W V W 1 · S/N 100Built 1996 · Nix William CN6331CPiper PA-28-161 · S/N 28-7816408Built 1978 · Lambert James DonaldN6669UMooney M20E · S/N 176Built 1963 · Nix William CN802HMAir Tractor AT-802 · S/N 802-0146Built 2003 · Aero S E A T IncN802WMAir Tractor AT-802A · S/N 802A-0824Built 2020 · Aero Seat IncN808AMAir Tractor AT-802A · S/N 802A-1275Aero Seat IncN874MMAir Tractor AT-802A · S/N 802A-0874Built 2021 · Aero S E A T IncN8974BCessna 172 · S/N 36674Built 1958 · Waller Steven MN9191JPiper PA-28-180 · S/N 28-3259Built 1966 · Armstrong Donald BradfordN920KHKenneth S Hendrickson S-19 VENTERRA · S/N 011100098Built 2022 · Capps Andrew JN96410Cessna 182Q · S/N 18266709Built 1978 · Penny John C JrN9780EAeronca 11AC · S/N 11AC-1424Built 1946 · Lambert James D
Back to Sterling, CO