OpenAirDocs.org
Pueblo, CO

Registered aircraft · 148

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

N100ZYBen Walden DGA-1A · S/N ONEBuilt 2016 · Walden Taylor GN117CBeech C90A · S/N LJ-1433Built 1996 · Western Enterprise LLCN11CDAerotek PITTS SPECIAL S-1S · S/N 1-0056Built 1978 · Travelaire Service IncN12589Beech B17L · S/N 7Built 1934 · Eastman Gregory LN143TXDiamond Aircraft Ind DA20-C1 · S/N C0412Built 2006 · Cae Doss Aviation IncN144TXDiamond Aircraft Ind DA20-C1 · S/N C0414Built 2007 · Cae Doss Aviation IncN150WTCessna 150G · S/N 15065949Jenson Greg RN1673JPiper PA-28-140 · S/N 28-24074Built 1967 · Southern Colorado Flight Professionals LLCN1930XCessna 182H · S/N 18256030Built 1965 · Duff James JN1997CCessna 170B · S/N 26142Built 1954 · Travelaire Service IncN2051PHoyle Clifford L FIGHTER ESCORT WINGS · S/N T-035Hoyle Clifford LN2236ZPiper PA-28-201T · S/N 28-7921022Built 1979 · Roukema James EN2244VPiper PA-28-161 · S/N 28-7916329Built 1979 · Southern Colorado Flight Professionals LLCN2316MPiper PA-12 · S/N 12-1480Built 1946 · Red Tail Aviation LLCN231MKMooney M20K · S/N 25-0309Built 1980 · Eastman Gregory LN2323GCessna 182D · S/N 51623Built 1958 · Leone Daniel MN2345DCessna 170B · S/N 20497Built 1952 · Travelaire Service IncN240JPDiamond Aircraft Ind DA20-C1 · S/N C0192Built 2002 · Cae Doss Aviation IncN2453KLuscombe 8E · S/N 5180Walden Taylor GN25465Cessna C-165 · S/N 570Built 1940 · Hoyle Clifford LN255RPPosey Ronny E ISON 1600 · S/N 1069Built 2005 · Bucciarelli Dominick FN25NFAviat A-1C-180 · S/N 3178Built 2013 · Western Enterprise LLCN26905Cessna 180 · S/N 18051354Indgjer Lawrence DN2850CCessna 170B · S/N 26393Built 1954 · Toxvard Ludvig E IIIN2879TChristen Industries A-1 · S/N 1009Built 1987 · Wark John CharlesN3012BPiper PA-28-236 · S/N 28-7911016Built 1978 · Throwbacks LLCN34259Cessna 177B · S/N 17701738Built 1972 · Sharp Kenneth MN35536Piper J3C-90 · S/N 6441Built 1941 · Pueblo Historical Aircraft SocietyN3579HErcoupe 415-C · S/N 4204Built 1946 · Bucciarelli DominickN3619XAero Commander 100-180 · S/N 5096Needs Shaely MN36RSAmerican Champion 7GCBC · S/N 1280-99Built 1999 · Salerno MichaelN380GFDiamond Aircraft Ind DA20-C1 · S/N C0380Built 2006 · Cae Doss Aviation IncN3814EAeronca 11AC · S/N 11AC-S32Built 1947 · Allen Anwaar SaeedN39810Burkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3813Built 1983 · Hoyle Clifford LN3991MPiper PA-28R-201T · S/N 28R-7803211Built 1978 · Staruh Donald EN4019VCessna 170 · S/N 18338Built 1948 · Eastman Gregory LN4033BBellanca 17-31A · S/N 75-32-153Hawkins Nathan CN4045ZPiper PA-18-150 · S/N 18-8007Built 1963 · Eastman Gregory LN4102NCessna 140 · S/N 13560Built 1947 · Walden Taylor GN414TWEclipse EA500 · S/N 000147Built 2008 · Colorado Bluebird LLCN4189VCessna 170 · S/N 18522Eastman Gregory LN423BALet L13 AC BLANIK · S/N 028904Sale reportedBuilt 2002N4243MHayworth Kenneth R QUICKSILVER GT 500 · S/N 0080Hayworth Kenneth RN43625Piper PA-28-151 · S/N 28-7415542Built 1974 · Southern Colorado Flight Professionals LLCN437LMRobinson Helicopter R44 · S/N 1349Built 2003 · Gigliotti DarinN44249Taylorcraft BC12-D1 · S/N 10049Built 1946 · Trimble Adam SN444RECessna 175 · S/N 55174Jenson Greg RayN4479TPiper PA-28R-200 · S/N 28R-7235033Built 1972 · Southern Colorado Flight Professionals LLCN46MPiper PA-24-250 · S/N 24-411Built 1958 · Jones Gregory DN4905PDJI AGRAS T50 · S/N 1581F6BUB24B20015L7GPel-Air Inc
Back to Pueblo, CO