# Cancelled registrations: Usaf Academy, CO

A list on [Usaf Academy, CO](https://openairdocs.org/faa-place/CO/Usaf%20Academy.md).

Cancelled aircraft registrations in Usaf Academy, CO.

- [N421BA](https://openairdocs.org/deregistered/N421BA-2017-09-18.md): Let L13 AC BLANIK · S/N 028902 · Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc
- [N424BA](https://openairdocs.org/deregistered/N424BA-2017-08-31.md): Let L13 AC BLANIK · S/N 028905 · Cancelled Aug 31, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy
- [N435BA](https://openairdocs.org/deregistered/N435BA-2017-07-18.md): Let L13 AC BLANIK · S/N 029101 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc
- [N408BA](https://openairdocs.org/deregistered/N408BA-2017-05-31.md): Let L 33 SOLO · S/N 020603 · Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 2002 · United States Air Force Academy 94 Fts Cc
- [N31AF](https://openairdocs.org/deregistered/N31AF-2017-05-23.md): Schweizer SGM2-37 · S/N 1 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1982 · United States Air Force
- [N27AF](https://openairdocs.org/deregistered/N27AF-2013-11-04.md): Schweizer SGM2-37 · S/N 7 · Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 1983 · United States Air Force
- [N148XS](https://openairdocs.org/deregistered/N148XS-2013-06-11.md): Aeromot AMT-200S · S/N 200.148 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 2003 · 94th Flight Training Squadron
- [N2447W](https://openairdocs.org/deregistered/N2447W-2013-04-15.md): Schweizer SGS 2-33 · S/N 12 · Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1967 · United States Air Force
- [N97LP](https://openairdocs.org/deregistered/N97LP-2013-02-05.md): Cessna 172P · S/N 17274398 · Cancelled Feb 5, 2013 · Built 1980 · United States Air Force Aero Club
- [N1192S](https://openairdocs.org/deregistered/N1192S-2003-08-13.md): Schweizer SGS 2-33A · S/N 202 · Cancelled Aug 13, 2003 · Triennial form not returned · Built 1970 · United States Air Force
- [N225AF](https://openairdocs.org/deregistered/N225AF-2000-05-05.md): Schweizer SGS 2-25 · S/N 1 · Cancelled May 5, 2000 · Triennial form not returned · US Air Force
- [N7904N](https://openairdocs.org/deregistered/N7904N-1997-07-24.md): Cessna R172E · S/N R1720295 · Cancelled Jul 24, 1997 · Triennial form not returned · U S Air Force
- [N3043F](https://openairdocs.org/deregistered/N3043F-1997-02-18.md): Cessna T-41B · S/N R1720135 · Cancelled Feb 18, 1997 · Triennial form not returned · US Air Force Owner
- [N7634S](https://openairdocs.org/deregistered/N7634S-1996-05-21.md): Bellanca 8GCBC · S/N 21076 · Cancelled May 21, 1996 · Triennial form not returned · Fischer Agency Inc
- [N33894](https://openairdocs.org/deregistered/N33894-1996-02-05.md): Schweizer SGS 1-26E · S/N 624 · Cancelled Feb 5, 1996 · United States Air Force
- [N17920](https://openairdocs.org/deregistered/N17920-1994-06-24.md): Schweizer SGS 1-26E · S/N 530 · Cancelled Jun 24, 1994 · Triennial form not returned · US Air Force Academy
- [N1191S](https://openairdocs.org/deregistered/N1191S-1991-05-16.md): Schweizer SGS 2-33A · S/N 201 · Cancelled May 16, 1991 · Triennial form not returned · US Air Force
- [N1193S](https://openairdocs.org/deregistered/N1193S-1991-05-16.md): Schweizer SGS 2-33A · S/N 203 · Cancelled May 16, 1991 · Triennial form not returned · US Air Force
- [N5218F](https://openairdocs.org/deregistered/N5218F-1981-05-07.md): Cessna 172F · S/N 17253243 · Cancelled May 7, 1981 · Usaf Academy Aero Club
- [N24628](https://openairdocs.org/deregistered/N24628-1981-03-13.md): Beech C23 · S/N M1407 · Cancelled Mar 13, 1981 · Built 1972 · Usaf Academy Aero Club
- [N7735S](https://openairdocs.org/deregistered/N7735S-1977-11-01.md): Schweizer SGS 1-26D · S/N 435 · Cancelled Nov 1, 1977 · U S Air Force Academy
- [N7746L](https://openairdocs.org/deregistered/N7746L-1976-04-19.md): Cessna 172K · S/N 17259009 · Cancelled Apr 19, 1976 · Usaf Academy Aero Club

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'CO' AND d.registrant_city = 'USAF ACADEMY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/CO/Usaf%20Academy/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.