# Cancelled registrations: Union City, TN

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

Cancelled aircraft registrations in Union City, TN.

- [N1064W](https://openairdocs.org/deregistered/N1064W-2022-10-01.md): Beech A60 · S/N P-226 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Morris Truck And Tractor LLC
- [N1536Z](https://openairdocs.org/deregistered/N1536Z-2022-01-08.md): Air Tractor AT-401 · S/N 401-0857 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1992 · Russell Larry B
- [N23937](https://openairdocs.org/deregistered/N23937-2021-04-10.md): Air Tractor AT-301 · S/N 301-0445 · Cancelled Apr 10, 2021 · Sale reported, canceled · Built 1982
- [N1005T](https://openairdocs.org/deregistered/N1005T-2020-01-31.md): Air Tractor AT-401 · S/N 401-0693 · Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1988 · Russell Larry B DBA
- [N70151](https://openairdocs.org/deregistered/N70151-2020-01-24.md): Piper J3C-65 · S/N 17136 · Cancelled Jan 24, 2020 · Revoked, canceled · Built 1946 · Harbin Melbalene
- [N33571](https://openairdocs.org/deregistered/N33571-2019-03-02.md): Piper J3C-65 · S/N 14048 · Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1945 · Vaught Harold E
- [N38401](https://openairdocs.org/deregistered/N38401-2019-03-02.md): DJI PHANTOM 1 · S/N PT645328493 · Cancelled Mar 2, 2019 · Registration expired, pending cancellation · Orton Stoney D
- [N88533](https://openairdocs.org/deregistered/N88533-2017-11-21.md): Piper J3C-65 · S/N 16158 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Morris James
- [N4593N](https://openairdocs.org/deregistered/N4593N-2014-11-25.md): Boeing E75 · S/N 75-5877 · Cancelled Nov 25, 2014 · Registration expired, pending cancellation · Built 1942 · Robert E & Jenny D Kirkland Foundation
- [N52GT](https://openairdocs.org/deregistered/N52GT-2005-12-30.md): Beech 200 · S/N BB-377 · Cancelled Dec 30, 2005 · Exported to Panama · Built 1978 · Messenger Inc
- [N5095S](https://openairdocs.org/deregistered/N5095S-1999-12-09.md): Air Tractor AT-301 · S/N 301-0118 · Cancelled Dec 9, 1999 · Triennial form not returned · Russell Larry DBA
- [N24834](https://openairdocs.org/deregistered/N24834-1997-11-14.md): Cessna 152 · S/N 15280405 · Cancelled Nov 14, 1997 · Triennial form not returned · West Tennessee Aviation Inc
- [N4747P](https://openairdocs.org/deregistered/N4747P-1976-06-16.md): Piper PA-23-250 · S/N 27283 · Cancelled Jun 16, 1976 · Zeller O A Jr
- [N1362C](https://openairdocs.org/deregistered/N1362C-1974-05-20.md): Piper PA-18 · S/N 18-2534 · Cancelled May 20, 1974 · Vaught Arnold
- [N4702A](https://openairdocs.org/deregistered/N4702A-1971-01-19.md): Piper PA-18A 150 · S/N 18-4916 · Cancelled Jan 19, 1971 · Vaught Harold E
- [N7434D](https://openairdocs.org/deregistered/N7434D-1970-10-12.md): Piper PA-22-150 · S/N 22-5198 · Cancelled Oct 12, 1970 · Mcadoo Builders Supply Company Inc
- [N4196Z](https://openairdocs.org/deregistered/N4196Z-1967-05-26.md): Piper PA-18-150 · S/N 18-8386 · Cancelled May 26, 1967 · Exported to Canada · Taylor J D
- [N41487](https://openairdocs.org/deregistered/N41487-1964-09-09.md): Piper J3C-65 · S/N 8130 · Cancelled Sep 9, 1964 · Melbalene Harbin
- [N20459](https://openairdocs.org/deregistered/N20459-1948-06-08.md): Welch OW5M · S/N 154 · Cancelled Jun 8, 1948 · Holly James I
- [N32469](https://openairdocs.org/deregistered/N32469-1944-04-12.md): Culver LCA · S/N 201 · Cancelled Apr 12, 1944 · Schwarm Donald
- [N22140](https://openairdocs.org/deregistered/N22140-1944-04-06.md): Aeronca K · S/N K-324 · Cancelled Apr 6, 1944 · Built 1938 · Cummingham Herbert Ewell

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

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