OpenAirDocs.org
United States Air Force

Registered aircraft · 45

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'UNITED STATES AIR FORCE' OR list_contains(g.other_registrant_names, 'UNITED STATES AIR FORCE')
  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.

N138UADiamond Aircraft Ind DA 40 NG · S/N 40.NC251Built 2023 · Apo ApN144UADiamond Aircraft Ind DA 40 NG · S/N 40.NC254Built 2023 · Apo, APN185TWCessna A185F · S/N 18503945Built 1979 · Jber, AKN2263TCessna R182 · S/N R18200014Built 1977 · Dover Afb, DEN2696CCessna R182 · S/N R18200218Built 1978 · Peterson Afb, CON308DGDG Flugzeugbau DG 1000S · S/N 10-177S107U S A F Academy, CON374AWDiamond Aircraft Ind DA 42 NG · S/N 42.N559Built 2024 · Apo, APN374YJDiamond Aircraft Ind DA 40 NG · S/N 40.NC320Built 2024 · Apo, APN411USPiper PA-31-350 · S/N 31-8152073Built 1981 · Hanscom Afb, MAN48FLZaklady Lotnicze Marganski MDM-1P FOX-P · S/N 240Built 2010 · Usaf Academy, CON4972RCessna 172H · S/N 17256326Built 1967 · Apo, APN4979RCessna 172H · S/N 17256333Built 1967 · Offutt Afb, NEN5120FCessna 172F · S/N 17252811Built 1965 · Jacksonville, FLN5204FCessna 172F · S/N 17253195Built 1965 · Offutt Afb, NEN5215FCessna 172F · S/N 17253233Built 1965 · Rio Vista, CAN5220FCessna 172F · S/N 17253250Built 1965 · Eglin Afb, FLN5235FCessna 172F · S/N 17253301Built 1965 · March Afb, CAN555ZZBeech A45 · S/N G-290Built 1953 · Rio Vista, CAN557AWCessna 150M · S/N 15077067Built 1975 · Usaf Academy, CON557SHCessna 150L · S/N 15072617Built 1971 · Usaf Academy, CON557THCessna 150M · S/N 15077111Built 1975 · Usaf Academy, CON619AGPiper PA-28-181 · S/N 2843252Built 1999 · Colorado Springs, CON70464Dehavilland DHC-6 TWIN OTTER · S/N 555Built 1977 · Usaf Academy, CON70465Dehavilland DHC-6 TWIN OTTER · S/N 554Built 1977 · Usaf Academy, CON770AGBombardier BD-700-1A10 · S/N 9355Built 2009 · Hanscom Afb, MAN7753LCessna R172G · S/N R1720429Built 1970 · Usaf Academy, CON7754LCessna R172G · S/N R1720430Built 1970 · U S A F Academy, CON7755LCessna R172G · S/N R1720431Built 1970 · U S A F Academy, CON7756LCessna R172G · S/N R1720432Built 1970 · U S A F Academy, CON7757LCessna R172E · S/N R172-0259Built 1967 · Usaf Academy, CON7866NCessna R172E · S/N R172-0257Built 1967 · Colorado Springs, CON7873NCessna R172E · S/N R172-0264Built 1967 · Colorado Springs, CON7882NCessna R172E · S/N R172-0273Built 1967 · Kirtland Afb, NMN7887NCessna R172E · S/N R172-0278Built 1967 · Kirtland Afb, NMN7903NCessna R172E · S/N R172-0294Built 1968 · Usaf Academy, CON8137QPiper PA-28-161 · S/N 28-8016179Built 1979 · Hanscom Afb, MAN894BABoeing 747-85M · S/N 42416Built 2016 · Wpafb, OHN895BABoeing 747-85M · S/N 42417Built 2016 · Wpafb, OHN901GXBombardier BD-700-1A10 · S/N 9001Bedford, MAN9045Bombardier BD-700-1A10 · S/N 60045Bedford, MAN9048GBombardier BD-700-1A10 · S/N 60115Built 2023 · Bedford, MAN9358LCessna 172P · S/N 17276546Built 1986 · Eglin Afb, FLN9390BCessna 172RG · S/N 172RG0810Built 1981 · Elmendorf Afb, AKN9788HCessna 182R · S/N 18268025Built 1981 · Usaf Academy, CON99273Cessna 172P · S/N 17276427Built 1985 · Dover Afb, DE
Back to United States Air Force