# Cancelled registrations: Canon City, CO

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

Cancelled aircraft registrations in Canon City, CO.

- [N27490](https://openairdocs.org/deregistered/N27490-2018-12-04.md): Taylorcraft BL-65 · S/N 2132 · Cancelled Dec 4, 2018 · Revoked, canceled · Built 1940 · Freek Jack E
- [N121SW](https://openairdocs.org/deregistered/N121SW-2018-02-28.md): Cessna 182P · S/N 18262667 · Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1973 · Crosby Jackie N Trustee
- [N8718T](https://openairdocs.org/deregistered/N8718T-2018-01-09.md): Cessna 182C · S/N 52618 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1960 · Fly High Aviation LLC
- [N182VR](https://openairdocs.org/deregistered/N182VR-2014-09-10.md): Cessna 182P · S/N 18263229 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1974 · Sternberg Arthur M
- [N20822](https://openairdocs.org/deregistered/N20822-2013-11-07.md): Valentin TAIFUN 17 E II · S/N 1116 · Cancelled Nov 7, 2013 · Registration expired, pending cancellation · Built 1988 · Melendy Allan R
- [N667MR](https://openairdocs.org/deregistered/N667MR-2013-05-13.md): Riem M P/Riem M E S-7 COURIER · S/N 1096210 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Riem Mark P
- [N789CC](https://openairdocs.org/deregistered/N789CC-2013-05-09.md): Piper PA-32-300 · S/N 32-40241 · Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1967 · Flanigan Kevin C
- [N757ES](https://openairdocs.org/deregistered/N757ES-2013-05-08.md): Cessna 152 · S/N 15279686 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1977 · Tarachand Nosh J DBA
- [N2479Z](https://openairdocs.org/deregistered/N2479Z-2012-08-21.md): Piccard AX-6 · S/N 479 · Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1980
- [N4219V](https://openairdocs.org/deregistered/N4219V-2012-06-12.md): Cessna 170 · S/N 18575 · Cancelled Jun 12, 2012 · Revoked, canceled · Built 1948 · Meyers Arthur D
- [N8877B](https://openairdocs.org/deregistered/N8877B-2008-07-08.md): Cessna 172 · S/N 36577 · Cancelled Jul 8, 2008 · Triennial form not returned · Built 1958 · Doubleday Guy
- [N43GA](https://openairdocs.org/deregistered/N43GA-2004-06-02.md): Bell 206L-3 · S/N 51305 · Cancelled Jun 2, 2004 · Triennial form not returned · Rapid Air LLC
- [N85Z](https://openairdocs.org/deregistered/N85Z-1995-05-22.md): Siewert Irving OSPREY GP-4 · S/N 125 · Cancelled May 22, 1995 · Triennial form not returned · Siewert Irving H
- [N2580U](https://openairdocs.org/deregistered/N2580U-1973-06-26.md): Cessna 172D · S/N 17250180 · Cancelled Jun 26, 1973 · Built 1963 · Leithold William F
- [N7375K](https://openairdocs.org/deregistered/N7375K-1970-06-24.md): Piper PA-20 · S/N 20-284 · Cancelled Jun 24, 1970 · Sunset Drive In Theatre
- [N88658](https://openairdocs.org/deregistered/N88658-1956-02-24.md): Piper J3C-65 · S/N 16287 · Cancelled Feb 24, 1956 · Fremont Air Service

## 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 = 'CANON CITY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/CO/Canon%20City/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
