# Cancelled registrations: Springfield, TN

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

Cancelled aircraft registrations in Springfield, TN.

- [N69HJ](https://openairdocs.org/deregistered/N69HJ-2021-03-27.md): Hughes 269A · S/N 580869 · Cancelled Mar 27, 2021 · Sale reported, canceled
- [N488MC](https://openairdocs.org/deregistered/N488MC-2021-03-20.md): Schweizer TH55A/269A · S/N 680885 · Cancelled Mar 20, 2021 · Sale reported, canceled
- [N2025C](https://openairdocs.org/deregistered/N2025C-2020-07-24.md): Beech 95 · S/N TD-192 · Cancelled Jul 24, 2020 · Wingnuts Aviation LLC
- [N92022](https://openairdocs.org/deregistered/N92022-2020-01-06.md): Piper J3C-65 · S/N 16455 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1946 · Farmer Joe M
- [N8678G](https://openairdocs.org/deregistered/N8678G-2013-08-21.md): Cessna 150F · S/N 15062778 · Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1966
- [N9888](https://openairdocs.org/deregistered/N9888-2013-05-08.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1304 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1974 · Smith Terry
- [N6618](https://openairdocs.org/deregistered/N6618-2013-04-30.md): Grumman G-164A · S/N 751 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1970 · Smith Terry
- [N2438C](https://openairdocs.org/deregistered/N2438C-2012-10-19.md): Piper PA-38-112 · S/N 38-79A0185 · Cancelled Oct 19, 2012 · Registration expired, pending cancellation · Built 1978 · Williams Aviation Corp
- [N1YJ](https://openairdocs.org/deregistered/N1YJ-2012-05-04.md): Barbee CASSUTT III M · S/N 919-L · Cancelled May 4, 2012 · Registration expired, pending cancellation · Built 1974 · Barbee James A
- [N102GM](https://openairdocs.org/deregistered/N102GM-2011-06-01.md): Miller F-11 · S/N 102GM · Cancelled Jun 1, 2011 · Sale reported, canceled
- [N89552](https://openairdocs.org/deregistered/N89552-2007-09-25.md): Cessna 152 · S/N 15282783 · Cancelled Sep 25, 2007 · Exported to Poland · Built 1978 · Mc Cauley Aviation Inc
- [N5153E](https://openairdocs.org/deregistered/N5153E-2006-02-21.md): Cessna 172N · S/N 17271739 · Cancelled Feb 21, 2006 · Triennial form not returned · Built 1978 · Mccauley Aviation Inc
- [N5418](https://openairdocs.org/deregistered/N5418-1997-08-05.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1033 · Cancelled Aug 5, 1997 · Exported to Turkey · Williams Aviation Inc
- [N465RF](https://openairdocs.org/deregistered/N465RF-1997-03-20.md): Grumman G-164 · S/N 233 · Cancelled Mar 20, 1997 · Garrison Spraying Services Inc DBA
- [N32911](https://openairdocs.org/deregistered/N32911-1991-04-12.md): Piper PA-28-180 · S/N 287505102 · Cancelled Apr 12, 1991 · Triennial form not returned · Williams Aviation Inc
- [N2030C](https://openairdocs.org/deregistered/N2030C-1989-06-19.md): Beech 95 · S/N TD196 · Cancelled Jun 19, 1989 · Triennial form not returned · Williams Aviation Inc
- [N32992](https://openairdocs.org/deregistered/N32992-1981-12-23.md): Piper PA-28-180 · S/N 287505107 · Cancelled Dec 23, 1981 · Built 1974 · Williams Aviation Inc
- [N6032Z](https://openairdocs.org/deregistered/N6032Z-1975-05-08.md): Piper PA-25 · S/N 25-39 · Cancelled May 8, 1975 · Wroten John R Jr
- [N4376A](https://openairdocs.org/deregistered/N4376A-1972-12-08.md): Piper PA-18A 150 · S/N 18-4778 · Cancelled Dec 8, 1972 · Exported to Canada · Built 1946 · Wroten J

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

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