OpenAirDocs.org
Berthoud, CO

Registered aircraft · 28

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

N10580Cessna LC41-550FG · S/N 411150Dwyer Lawrence WilliamN145RBPowrachute PC2000 · S/N 886077Mcbartlett Kelly JN20358Cessna 177B · S/N 17702661Built 1977 · Ricky B'S Bodyshop IncN245TCessna 421C · S/N 421C1104High Country Aero LtdN300DFCessna 182J · S/N 18257109Built 1966 · Downer Justin WN3069CPiper PA-28-181 · S/N 28-7990153Built 1978 · Busboom Richard JayN32DBCessna 180H · S/N 18051714Built 1966 · Carpenter Forrest AN34WYDouglass James D BEARHAWK PATROL · S/N P28-63P/64P-282Built 2022 · Douglass James DN3792TPiper PA-28R-180 · S/N 28R-30105Built 1967 · Browning Marvin RobertN40159Stinson 108 · S/N 108-89Built 1946 · Leyner Robert EN436QWPowrachute AIRWOLF 912ULS · S/N A149ULSMcbartlett Kelly JN4778FCessna P206B · S/N P206-0378Built 1967 · Pond Engineering Laboratories IncN487WBWayne Baker KITFOX S7 SUPER SPOR · S/N KA16066326Built 2016 · Rice Leslie GN5701XCessna 320 · S/N 320-0001Built 1961 · Coan Mark AN580JGRewerts Glen D RV-7 · S/N 72816Built 2011 · Rewerts Glen DN6128PMaule M-7-235 · S/N 4057CTango Alpha Sierra LLCN6304QMooney M20F · S/N 670397Built 1967 · N6304q LLCN682APCessna TR182 · S/N R182-01072Built 1979 · Flipside Aviation LLCN7018HPiper J3C-65 · S/N 20262Leyner Robert EN7093BPiper PA-18A 150 · S/N 18-5176Built 1957 · Backcountry Aviation LLCN74581Mooney M20B · S/N 1892Lane Tyler RN766RSStratmeyer Richard H GLASTAR · S/N 5766Built 2004 · Stratmeyer Richard HN79AQTiger AG-5B · S/N 10206Schmidt Steven TodN8191VLacourse Richard COZY MK IV · S/N 237Built 1999 · Nelson Ronald RN905DHSwan Lake AIRCAM · S/N AC213Built 2016 · Tango Alpha Sierra LLCN9293Ries JODEL F-12 · S/N 8019Built 1974 · Brunner Gavin AN972RTGross Robert F1 · S/N 17Built 2003 · Mellott Stephen GN97389Stinson 108 · S/N 108-389Built 1946 · Pennuto Kurt T
Back to Berthoud, CO