OpenAirDocs.org
Usaf Academy, CO

Registered aircraft · 36

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 = 'USAF ACADEMY'
  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.

N1370UCessna 172M · S/N 17267041Built 1976 · United States Air Force Aero ClubN1401ECessna 172N · S/N 17270986Built 1978 · United States Air Force Aero ClubN146ACCessna R172E · S/N R1720147Built 1967 · United States Air Force OwnerN161AFSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 384Built 2003 · Usaf AcademyN162AFSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 385Built 2003 · Usaf AcademyN163AFSchempp-Hirth DISCUS-2B · S/N 188Built 2003 · Usaf AcademyN164AFSchempp-Hirth DISCUS-2B · S/N 189Built 2003 · Usaf AcademyN165AFSchempp-Hirth DISCUS-2B · S/N 187Built 2003 · Usaf AcademyN386SPCessna 172S · S/N 172S8283Built 1999 · Usaf Academy Aero ClubN470AKCub Crafters CC18-180 · S/N CC18-0089Built 2018 · Akima Logistics Services LLCN471AKCub Crafters CC18-180 · S/N CC18-0090Built 2018 · Akima Logistics Services LLCN473AKCub Crafters CC18-180 · S/N CC18-0092Built 2018 · Akima Logistics Services LLCN48FLZaklady Lotnicze Marganski MDM-1P FOX-P · S/N 240Built 2010 · United States Air ForceN557AWCessna 150M · S/N 15077067Built 1975 · United States Air ForceN557SHCessna 150L · S/N 15072617Built 1971 · United States Air ForceN557THCessna 150M · S/N 15077111Built 1975 · United States Air ForceN614DGDG Flugzeugbau DG 1000S · S/N 10-183S113Built 2012 · U S Air ForceN615DGDG Flugzeugbau DG 1000S · S/N 10-184S114Built 2012 · US Air ForceN616DGDG Flugzeugbau DG 1000S · S/N 10-185S115Built 2012 · U S Air ForceN6601KCessna 172P · S/N 17274218Built 1980 · Air Force Academy Aero ClubN66MJCessna 182Q · S/N 18266399United States Air Force (Owner)N70464Dehavilland DHC-6 TWIN OTTER · S/N 555Built 1977 · United States Air ForceN70465Dehavilland DHC-6 TWIN OTTER · S/N 554Built 1977 · United States Air ForceN717DGDG Flugzeugbau DG 1000S · S/N 10-186S116Built 2012 · U S Air ForceN718DGDG Flugzeugbau DG 1000S · S/N 10-187S117Built 2012 · U S Air ForceN719DGDG Flugzeugbau DG 1000S · S/N 10-188S118Built 2012 · U S Air ForceN736HMCessna R172K · S/N R1722540Built 1977 · Air Force Academy Aero ClubN7753LCessna R172G · S/N R1720429Built 1970 · United States Air ForceN7757LCessna R172E · S/N R172-0259Built 1967 · United States Air ForceN78512Cessna 172K · S/N 17257646Built 1969 · United States Air Force Academy Aero ClubN7884NCessna R172E · S/N R172-0275Built 1967 · United States Air Force OwnerN7903NCessna R172E · S/N R172-0294Built 1968 · United States Air ForceN82305Piper PA-25-235 · S/N 25-7656070Built 1976 · Akima Logistics Services LLCN94986Cessna 182Q · S/N 18266552Built 1978 · United States Air Force (Owner)N9788HCessna 182R · S/N 18268025Built 1981 · United States Air ForceN98306Cessna 172P · S/N 17276276Built 1985 · United States Air Force Owner
Back to Usaf Academy, CO