# Cancelled registrations: Dyersburg, TN

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

Cancelled aircraft registrations in Dyersburg, TN.

- [N90342](https://openairdocs.org/deregistered/N90342-2017-07-14.md): Air Tractor AT-502B · S/N 502B-0579 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1999 · Addison Ag Operating & Leasing Inc
- [N321GP](https://openairdocs.org/deregistered/N321GP-2014-11-26.md): Palmer Gregory D MITCHELL WING U-2 · S/N GP1011885 · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Palmer Gregory D
- [N9102G](https://openairdocs.org/deregistered/N9102G-2014-11-24.md): Cessna 182N · S/N 18260642 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1971 · Singleton Robert H
- [N5587P](https://openairdocs.org/deregistered/N5587P-2013-08-13.md): Stone S/Pioneer FLIGHTSTAR · S/N 001 · Cancelled Aug 13, 2013 · Sale reported, canceled
- [N2894A](https://openairdocs.org/deregistered/N2894A-2013-02-11.md): Weedhopper WEEDHOPPER II · S/N 2096 · Cancelled Feb 11, 2013 · Sale reported, canceled · Built 2007
- [N7498Z](https://openairdocs.org/deregistered/N7498Z-2011-06-07.md): Piper PA-25-235 · S/N 25-3443 · Cancelled Jun 7, 2011 · Registration pending, pending cancellation · Built 1965
- [N25319](https://openairdocs.org/deregistered/N25319-2008-03-28.md): Cessna 152 · S/N 15280592 · Cancelled Mar 28, 2008 · Exported to Canada · Built 1977 · Sigman John T Jr
- [N12CD](https://openairdocs.org/deregistered/N12CD-2005-09-13.md): Piper PA-31-350 · S/N 31-7952031 · Cancelled Sep 13, 2005 · Exported to United Kingdom · Built 1978 · Reelfoot Aviation LLC
- [N938DS](https://openairdocs.org/deregistered/N938DS-2003-10-22.md): Piper PA-31-350 · S/N 31-8352013 · Cancelled Oct 22, 2003 · Exported to Philippines · Built 1983 · Darden Management Inc
- [N20269](https://openairdocs.org/deregistered/N20269-2002-09-30.md): Harris Lee S CHALLENGER 1 · S/N 0201-0752 · Cancelled Sep 30, 2002 · Built 2001 · Harris Lee S
- [N224TT](https://openairdocs.org/deregistered/N224TT-1993-08-25.md): Bradshaw Sam A JR MONI · S/N 00224 · Cancelled Aug 25, 1993 · Triennial form not returned · Bradshaw Sam A Jr
- [N33MZ](https://openairdocs.org/deregistered/N33MZ-1991-02-28.md): Warne Monte S 1-STOL · S/N 17523 · Cancelled Feb 28, 1991 · Triennial form not returned · Warne Monte S
- [N6602A](https://openairdocs.org/deregistered/N6602A-1986-01-23.md): Piper PA-23-250 (6PCLM) · S/N 27-7954023 · Cancelled Jan 23, 1986 · Kelly And Dearing Aviation
- [N5945F](https://openairdocs.org/deregistered/N5945F-1976-03-22.md): Cessna 210H · S/N 21058945 · Cancelled Mar 22, 1976 · Pelham Peter
- [N1834H](https://openairdocs.org/deregistered/N1834H-1973-12-28.md): Cessna 310C · S/N 35934 · Cancelled Dec 28, 1973 · W W Wickersham DBA
- [N75264](https://openairdocs.org/deregistered/N75264-1972-02-21.md): Piper J3C-65 · S/N 12711 · Cancelled Feb 21, 1972 · William E Braese
- [N6869M](https://openairdocs.org/deregistered/N6869M-1972-02-17.md): Stinson 108-3 · S/N 108-4869 · Cancelled Feb 17, 1972 · Dyer Aero Service
- [N42404](https://openairdocs.org/deregistered/N42404-1972-02-14.md): Piper J3C-65 · S/N 14664 · Cancelled Feb 14, 1972 · Dyer Aero Service
- [N35011](https://openairdocs.org/deregistered/N35011-1972-02-08.md): Piper J5A · S/N 5-520 · Cancelled Feb 8, 1972 · Dyer Aero Service
- [N38381](https://openairdocs.org/deregistered/N38381-1970-06-24.md): Piper J3C-65 · S/N 6992 · Cancelled Jun 24, 1970 · Built 1941 · Stutts T C
- [N5571H](https://openairdocs.org/deregistered/N5571H-1965-10-25.md): Piper PA-11 · S/N 11-1093 · Cancelled Oct 25, 1965 · Claude B Davis
- [N89114](https://openairdocs.org/deregistered/N89114-1955-10-13.md): Cessna 140 · S/N 8122 · Cancelled Oct 13, 1955 · Crenshaw J A
- [N1370M](https://openairdocs.org/deregistered/N1370M-1955-10-04.md): Consolidated Vultee BT-13A · S/N 6413 · Cancelled Oct 4, 1955 · Dyersburg Flying Service Inc
- [N33243](https://openairdocs.org/deregistered/N33243-1952-04-15.md): Piper J3F-65 · S/N 5919 · Cancelled Apr 15, 1952 · Dyersburg Flying Service
- [N53670](https://openairdocs.org/deregistered/N53670-1952-04-15.md): Taylorcraft L-2B · S/N L-4612 · Cancelled Apr 15, 1952 · Dyersburg Flying Service
- [N92238](https://openairdocs.org/deregistered/N92238-1952-04-15.md): Piper J3C-65 · S/N 16683 · Cancelled Apr 15, 1952 · Dyersburg Aerial Crop Service
- [N86230](https://openairdocs.org/deregistered/N86230-1951-07-25.md): Aeronca 11AC · S/N 11AC-34 · Cancelled Jul 25, 1951 · Dyersburg Flying Service
- [N86936](https://openairdocs.org/deregistered/N86936-1949-06-21.md): Bellanca 14-13 · S/N 1298 · Cancelled Jun 21, 1949 · Mr Harold D Keller Motor & Equipment Co

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

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