# Cancelled registrations: Smyrna, TN

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

Cancelled aircraft registrations in Smyrna, TN.

- [N804AE](https://openairdocs.org/deregistered/N804AE-2024-11-05.md): Embraer EMB-135KL · S/N 145487 · Cancelled Nov 5, 2024 · Built 2001 · Corporate Flight Management Inc DBA
- [N411FR](https://openairdocs.org/deregistered/N411FR-2023-12-29.md): Cessna 172R · S/N 17280262 · Cancelled Dec 29, 2023 · Built 1997 · Wings Of Eagles Aviation LLC
- [N207RW](https://openairdocs.org/deregistered/N207RW-2023-08-02.md): Bombardier CL-600-2B19 · S/N 7862 · Cancelled Aug 2, 2023 · Exported to San Marino · Built 2003 · Corporate Flight Management Inc
- [N35585](https://openairdocs.org/deregistered/N35585-2022-07-25.md): Cessna 172S · S/N 172S8873 · Cancelled Jul 25, 2022 · Sale reported
- [N766JS](https://openairdocs.org/deregistered/N766JS-2021-10-09.md): Boeing 727-27 · S/N 19535 · Cancelled Oct 9, 2021 · Sale reported, canceled · Built 1967
- [N431S](https://openairdocs.org/deregistered/N431S-2020-07-10.md): Swearingen SA227-TT · S/N TT-431 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Resource Air Charter LLC
- [N5140H](https://openairdocs.org/deregistered/N5140H-2019-11-29.md): Cessna 152 · S/N 15284066 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1979 · L&W Leasing LLC
- [N51218](https://openairdocs.org/deregistered/N51218-2019-11-04.md): Cessna 150J · S/N 15069844 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1968 · Oneal Robert L
- [N539PA](https://openairdocs.org/deregistered/N539PA-2019-06-12.md): British Aerospace BAE JETSTREAM 3101 · S/N 741 · Cancelled Jun 12, 2019 · Second renewal notice · Built 1987 · Corporate Flight Management Inc
- [N23QB](https://openairdocs.org/deregistered/N23QB-2019-01-28.md): Royal PIETENPOL AIRCAMPER · S/N ZR1 · Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Built 1975 · Boatman John J Jr
- [N58283](https://openairdocs.org/deregistered/N58283-2015-05-11.md): Aerospatiale SA341G GAZELLE · S/N 1015 · Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1972 · Pearce David B
- [N8293W](https://openairdocs.org/deregistered/N8293W-2015-05-05.md): Piper PA-28-180 · S/N 28-2456 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1965 · Lane William E
- [N123RT](https://openairdocs.org/deregistered/N123RT-2014-09-25.md): Cessna 421B · S/N 421B0108 · Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1971 · White Francis E DBA
- [N2676J](https://openairdocs.org/deregistered/N2676J-2014-09-25.md): Cessna 150G · S/N 15065676 · Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1966 · Stones River Air Service Inc
- [N10UP](https://openairdocs.org/deregistered/N10UP-2013-12-26.md): British Aerospace BAE JETSTREAM 3101 · S/N 635 · Cancelled Dec 26, 2013 · Exported to Panama · Built 1984 · Corporate Flight Management Inc
- [N497UE](https://openairdocs.org/deregistered/N497UE-2013-09-26.md): British Aerospace BAE JETSTREAM 3201 · S/N 904 · Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1990 · Corporate Flight Management Inc
- [N998CF](https://openairdocs.org/deregistered/N998CF-2013-08-27.md): Mcdonnell Douglas DC-8-62F · S/N 46139 · Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1970
- [N375A](https://openairdocs.org/deregistered/N375A-2013-06-12.md): Aero Commander 680V · S/N 1692-71 · Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1967
- [N1344X](https://openairdocs.org/deregistered/N1344X-2013-06-06.md): Haynes Dean A B-8M · S/N 1 · Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Skinner Herbert R
- [N992CF](https://openairdocs.org/deregistered/N992CF-2013-05-10.md): Douglas DC-8F-54 · S/N 45884 · Cancelled May 10, 2013 · Sale reported, canceled · Built 1968
- [N991CF](https://openairdocs.org/deregistered/N991CF-2013-02-27.md): Douglas DC-8F-54 · S/N 45801 · Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1965
- [N4638Z](https://openairdocs.org/deregistered/N4638Z-2012-11-27.md): Piper PA-22-108 · S/N 22-8156 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1961
- [N421CM](https://openairdocs.org/deregistered/N421CM-2012-11-20.md): Cessna 421 · S/N 421-0134 · Cancelled Nov 20, 2012 · Registration expired, pending cancellation · Built 1968 · Air Flora Aviation Corporation
- [N7950Z](https://openairdocs.org/deregistered/N7950Z-2012-09-06.md): Cessna 150C · S/N 15060050 · Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1963
- [N924AE](https://openairdocs.org/deregistered/N924AE-2011-11-23.md): British Aerospace BAE JETSTREAM 3201 · S/N 924 · Cancelled Nov 23, 2011 · Exported to Colombia · Built 1991
- [N865CY](https://openairdocs.org/deregistered/N865CY-2011-08-05.md): British Aerospace BAE JETSTREAM 3201 · S/N 865 · Cancelled Aug 5, 2011 · Exported to Colombia · Built 1989 · Corporate Flight Management Inc
- [N341TE](https://openairdocs.org/deregistered/N341TE-2011-06-29.md): British Aerospace BAE JETSTREAM 3201 · S/N 950 · Cancelled Jun 29, 2011 · Exported to Colombia · Built 1991 · Corporate Flight Management Inc
- [N958AE](https://openairdocs.org/deregistered/N958AE-2010-12-03.md): British Aerospace BAE JETSTREAM 3201 · S/N 958 · Cancelled Dec 3, 2010 · Exported to Canada · Built 1992 · Corporate Flight Management Inc
- [N415LJ](https://openairdocs.org/deregistered/N415LJ-2010-08-24.md): Learjet 23 · S/N 092 · Cancelled Aug 24, 2010 · Triennial form not returned · Built 1966 · Skycare Inc
- [N963AE](https://openairdocs.org/deregistered/N963AE-2010-06-08.md): British Aerospace BAE JETSTREAM 3201 · S/N 963 · Cancelled Jun 8, 2010 · Exported to Canada · Built 1992
- [N434AM](https://openairdocs.org/deregistered/N434AM-2009-09-17.md): British Aerospace BAE JETSTREAM 3201 · S/N 887 · Cancelled Sep 17, 2009 · Built 1990 · Corporate Flight Management Inc
- [N964CT](https://openairdocs.org/deregistered/N964CT-2009-05-13.md): Diamond Aircraft Ind DA20-C1 · S/N C0114 · Cancelled May 13, 2009 · Built 2000 · Wings Of Eagles LLC
- [N914AE](https://openairdocs.org/deregistered/N914AE-2006-12-05.md): British Aerospace BAE JETSTREAM 3201 · S/N 914 · Cancelled Dec 5, 2006 · Exported to Haiti · Built 1990 · Corporate Flight Management Inc
- [N883CH](https://openairdocs.org/deregistered/N883CH-2005-12-29.md): British Aerospace BAE JETSTREAM 3201 · S/N 883 · Cancelled Dec 29, 2005 · Exported to Haiti · Built 1990 · Corporate Flight Management Inc
- [N242RH](https://openairdocs.org/deregistered/N242RH-1999-11-24.md): British Aerospace BAE JETSTREAM 3201 · S/N 903 · Cancelled Nov 24, 1999 · Exported to Cayman Islands · Corporate Flight Management Inc
- [N22EQ](https://openairdocs.org/deregistered/N22EQ-1995-09-07.md): Mitsubishi MU-2B-20 · S/N 192 · Cancelled Sep 7, 1995 · Triennial form not returned · Luttrell And Peek Leasing DBA
- [N16178](https://openairdocs.org/deregistered/N16178-1982-01-21.md): Cessna 150L · S/N 15073526 · Cancelled Jan 21, 1982 · Administratively canceled · Wieland Richard L
- [N32044](https://openairdocs.org/deregistered/N32044-1977-12-05.md): Piper PA-28-151 · S/N 28-7515054 · Cancelled Dec 5, 1977 · Built 1974 · Brandon John W Jr Etal
- [N1442V](https://openairdocs.org/deregistered/N1442V-1977-09-01.md): Curtiss Wright C-46F · S/N 22503 · Cancelled Sep 1, 1977 · Built 1945 · Capitol International Airways Inc
- [N9940T](https://openairdocs.org/deregistered/N9940T-1976-06-15.md): Cessna 182A · S/N 18253040 · Cancelled Jun 15, 1976 · Stones River Air Service Inc
- [N4906C](https://openairdocs.org/deregistered/N4906C-1974-10-09.md): Mcdonnell Douglas DC-8F-55 · S/N 45862 · Cancelled Oct 9, 1974 · Exported to France · Capitol International Airways Inc
- [N7706B](https://openairdocs.org/deregistered/N7706B-1961-12-14.md): Beech A45 (T-34A) · S/N G-92 · Cancelled Dec 14, 1961 · U S Air Force

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

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