# Cancelled registrations: Columbia, TN

A list on [Columbia, TN](https://openairdocs.org/faa-place/TN/Columbia.md).

Cancelled aircraft registrations in Columbia, TN.

- [N338CM](https://openairdocs.org/deregistered/N338CM-2021-08-21.md): Mitsubishi MU-2B-36A · S/N 703SA · Cancelled Aug 21, 2021 · Sale reported, canceled · Built 1977
- [N3117R](https://openairdocs.org/deregistered/N3117R-2019-03-02.md): Cessna 182L · S/N 18258517 · Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1967 · Progress Engineering Inc
- [N44DJ](https://openairdocs.org/deregistered/N44DJ-2015-05-13.md): Cessna 210H · S/N 21059016 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1968 · Schmitter Karl
- [N609KA](https://openairdocs.org/deregistered/N609KA-2014-08-21.md): West J B JR CHALLENGER II · S/N CH2-0307-2789 · Cancelled Aug 21, 2014 · Exported to Canada · Built 2007 · West J B Jr
- [N5803A](https://openairdocs.org/deregistered/N5803A-2013-07-19.md): Cessna 172 · S/N 28403 · Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1956 · Goodman Sam
- [N8496R](https://openairdocs.org/deregistered/N8496R-2009-07-14.md): Piper PA-28-140 · S/N 28-22408 · Cancelled Jul 14, 2009 · Triennial form not returned · Built 1966 · Kirtley John W
- [N26975](https://openairdocs.org/deregistered/N26975-2008-07-14.md): Gulfstream American AA-5A · S/N AA5A0854 · Cancelled Jul 14, 2008 · Triennial form not returned · Built 1979 · Herklotz Robert A
- [N53LG](https://openairdocs.org/deregistered/N53LG-2003-10-02.md): Rockwell International 690B · S/N 11523 · Cancelled Oct 2, 2003 · Haulers Insurance Company Inc
- [N8065E](https://openairdocs.org/deregistered/N8065E-1997-03-17.md): Kempfer Louis T WEEDHOPPER -2SEAT · S/N 409 · Cancelled Mar 17, 1997 · Kemper Louis T
- [N7546G](https://openairdocs.org/deregistered/N7546G-1996-05-31.md): Cessna 172L · S/N 17259246 · Cancelled May 31, 1996 · Triennial form not returned · Schmitter Karl J
- [N6051G](https://openairdocs.org/deregistered/N6051G-1995-10-03.md): Cessna 150K · S/N 15071551 · Cancelled Oct 3, 1995 · Triennial form not returned · Beasley Walter J
- [N2045Q](https://openairdocs.org/deregistered/N2045Q-1994-10-04.md): Shull Larry KOLB TWINSTAR · S/N 1374 · Cancelled Oct 4, 1994 · Kempfer Louis T
- [N8509E](https://openairdocs.org/deregistered/N8509E-1981-01-06.md): Kustoff-King TEENIE TWO · S/N 01 · Cancelled Jan 6, 1981 · Kustoff Edward S
- [N81549](https://openairdocs.org/deregistered/N81549-1971-06-21.md): Aeronca 7AC · S/N 7AC-168 · Cancelled Jun 21, 1971 · Built 1945 · Cheek Earl Porter
- [N4386P](https://openairdocs.org/deregistered/N4386P-1965-05-20.md): Piper PA-23-160 · S/N 23-1897 · Cancelled May 20, 1965 · M C West Inc
- [N52400](https://openairdocs.org/deregistered/N52400-1952-02-19.md): Consolidated Vultee BT-13A · S/N 10520 · Cancelled Feb 19, 1952 · Built 1945 · Burks Edward E
- [N6778](https://openairdocs.org/deregistered/N6778-1938-02-15.md): National Airways System 27 SPECIAL · S/N 135 · Cancelled Feb 15, 1938 · Frank Foster Frakes
- [N266](https://openairdocs.org/deregistered/N266-1935-11-07.md): Waco 9 · S/N 87 · Cancelled Nov 7, 1935 · Built 1925 · Frakes F F
- [N3946](https://openairdocs.org/deregistered/N3946-1930-05-09.md): Travel Air 3000 · S/N 320 · Cancelled May 9, 1930 · Covert Milton P

## 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 = 'TN' AND d.registrant_city = 'COLUMBIA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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