# Cancelled registrations: Commerce City, CO

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

Cancelled aircraft registrations in Commerce City, CO.

- [N40218](https://openairdocs.org/deregistered/N40218-2021-10-30.md): Raven S-60A · S/N S60A-183 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1981 · Riehl Frank
- [N1988U](https://openairdocs.org/deregistered/N1988U-2021-07-31.md): Cameron Balloons A-140 · S/N 5255 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 1986 · Riehl Frank J
- [N53574](https://openairdocs.org/deregistered/N53574-2021-07-31.md): Galaxy Balloons GALAXY 7 · S/N GLX-1077 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Riehl Frank J
- [N53584](https://openairdocs.org/deregistered/N53584-2021-07-31.md): Galaxy Balloons GALAXY 7 · S/N GLX-1067 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Riehl Frank J
- [N5302M](https://openairdocs.org/deregistered/N5302M-2019-11-04.md): Cameron Balloons US C-100 · S/N 6137 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1997 · A Balloon Adventures Aloft
- [N2192F](https://openairdocs.org/deregistered/N2192F-2018-12-15.md): Firefly Balloons FIREFLY 9B-15 · S/N F9B-2011 · Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 2005 · Riehl Frank J DBA
- [N8056F](https://openairdocs.org/deregistered/N8056F-2018-12-13.md): Cessna 150F · S/N 15064156 · Cancelled Dec 13, 2018 · Revoked, canceled · Built 1966 · Ammon Gary E
- [N32855](https://openairdocs.org/deregistered/N32855-2018-06-08.md): Balloon Works FIREFLY 8B-15 · S/N F8B-522 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1996 · Riehl Frank J DBA
- [N369XT](https://openairdocs.org/deregistered/N369XT-2018-05-30.md): Extra Flugzeugproduktions EA 300/L · S/N 1315 · Cancelled May 30, 2018 · Sale reported, canceled · Built 2010
- [N2989L](https://openairdocs.org/deregistered/N2989L-2018-04-18.md): Cameron Balloons US N-160 · S/N 5209 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1986 · Riehl Frank
- [N872MZ](https://openairdocs.org/deregistered/N872MZ-2017-09-08.md): Hermance Scott L BUSHMASTER · S/N 1001 · Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 2009 · Hermance Scott L
- [N5595A](https://openairdocs.org/deregistered/N5595A-2015-05-19.md): Hi-Plain Ultralights RALLY 3 · S/N 25455 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Hi Plains Ultralights Inc
- [N79444](https://openairdocs.org/deregistered/N79444-1995-04-24.md): Cessna 172K · S/N 17258093 · Cancelled Apr 24, 1995 · Triennial form not returned · Woods Gordon
- [N8280Z](https://openairdocs.org/deregistered/N8280Z-1979-07-24.md): Cessna 210-5(205) · S/N 205-0280 · Cancelled Jul 24, 1979 · J S L Equipment Sales And Leasing Inc
- [N2463B](https://openairdocs.org/deregistered/N2463B-1979-03-27.md): Bensen B-8 · S/N 3283 · Cancelled Mar 27, 1979 · Riehl Frank J
- [N8579A](https://openairdocs.org/deregistered/N8579A-1974-05-17.md): Beech A35 · S/N D-2001 · Cancelled May 17, 1974 · Built 1949 · Self William F
- [N77PC](https://openairdocs.org/deregistered/N77PC-1971-03-22.md): Cochran WE-1 VOLKSPLANE · S/N 2888638 · Cancelled Mar 22, 1971 · Built 1970 · Cochran Paul R
- [N1088C](https://openairdocs.org/deregistered/N1088C-1965-12-28.md): Mooney M20A · S/N 1359 · Cancelled Dec 28, 1965 · Century Casualty Company

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

This list as a web page: https://openairdocs.org/faa-place/CO/Commerce%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.