# Cancelled registrations: Yazoo City, MS

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

Cancelled aircraft registrations in Yazoo City, MS.

- [N7151W](https://openairdocs.org/deregistered/N7151W-2017-08-24.md): Cessna T210L · S/N 21059871 · Cancelled Aug 24, 2017 · Exported to Mexico · Nine Dragons LLC
- [N2740Q](https://openairdocs.org/deregistered/N2740Q-2014-04-29.md): Cessna 182K · S/N 18257940 · Cancelled Apr 29, 2014 · Second renewal notice · Built 1967 · Arias Claudia S
- [N10648](https://openairdocs.org/deregistered/N10648-2013-08-05.md): Cessna 150L · S/N 15074946 · Cancelled Aug 5, 2013 · Registration expired, pending cancellation · Built 1973 · Vancleave Wayne
- [N110JS](https://openairdocs.org/deregistered/N110JS-2013-06-07.md): Rockwell International S-2R · S/N 2323R · Cancelled Jun 7, 2013 · Sale reported, canceled
- [N74669](https://openairdocs.org/deregistered/N74669-2013-05-08.md): Piper J5C · S/N 5-1452 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1943 · Granberry John F
- [N4561Y](https://openairdocs.org/deregistered/N4561Y-2012-12-07.md): Piper PA-25-235 · S/N 25-4219 · Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1967 · Payne J C DBA
- [N4637H](https://openairdocs.org/deregistered/N4637H-2012-11-27.md): Piper PA-15 · S/N 15-362 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1948
- [N1520X](https://openairdocs.org/deregistered/N1520X-2011-04-13.md): Air Tractor AT-502 · S/N 502-0157 · Cancelled Apr 13, 2011 · First renewal notice · Built 1991 · Carson Air Service Inc
- [N38138](https://openairdocs.org/deregistered/N38138-2011-01-21.md): Piper J5A · S/N 5-878 · Cancelled Jan 21, 2011 · Revoked, pending cancellation · Built 1941 · Payne James E
- [N1510Z](https://openairdocs.org/deregistered/N1510Z-2004-09-23.md): Air Tractor AT-402 · S/N 402-0829 · Cancelled Sep 23, 2004 · Triennial form not returned · Built 1991 · Producers Flying Inc
- [N4017B](https://openairdocs.org/deregistered/N4017B-1997-10-09.md): Ayres S2R-T34 · S/N T34002 · Cancelled Oct 9, 1997 · Second triennial mailing, no response · George Clanton Dusting And Spraying
- [N4431S](https://openairdocs.org/deregistered/N4431S-1992-03-11.md): Air Tractor AT-301 · S/N 3010091 · Cancelled Mar 11, 1992 · Exported to Mexico · Air Care Flying Svc Inc
- [N6838L](https://openairdocs.org/deregistered/N6838L-1986-02-04.md): Piper PA-25-235 · S/N 25-7405575 · Cancelled Feb 4, 1986 · Exported to Canada · Payne James C
- [N86632](https://openairdocs.org/deregistered/N86632-1981-10-15.md): Bellanca 7GCAA · S/N 289-74 · Cancelled Oct 15, 1981 · G & W Farms
- [N7670V](https://openairdocs.org/deregistered/N7670V-1971-07-15.md): Aero Commander CALLAIR A-9B · S/N 1398 · Cancelled Jul 15, 1971 · Delhi Plantation
- [N61217](https://openairdocs.org/deregistered/N61217-1971-02-05.md): Boeing A75L3 · S/N 75-7686 · Cancelled Feb 5, 1971 · Hawks Jack
- [N65904](https://openairdocs.org/deregistered/N65904-1971-02-03.md): Boeing A75L3 · S/N 75-5773 · Cancelled Feb 3, 1971 · George Clanton
- [N54905](https://openairdocs.org/deregistered/N54905-1971-01-26.md): Fairchild M-62A · S/N T43-5643 · Cancelled Jan 26, 1971 · Womble Tony A
- [N52532](https://openairdocs.org/deregistered/N52532-1964-09-23.md): Boeing D75N1 · S/N 75-2240 · Cancelled Sep 23, 1964 · J C Payne
- [N9457A](https://openairdocs.org/deregistered/N9457A-1960-05-06.md): Cessna 140A · S/N 15278 · Cancelled May 6, 1960 · Exported to Canada · Dunwoody W B
- [N3209M](https://openairdocs.org/deregistered/N3209M-1956-03-22.md): Piper PA-12 · S/N 12-1879 · Cancelled Mar 22, 1956 · Herbert Rogers
- [N42554](https://openairdocs.org/deregistered/N42554-1956-03-05.md): Piper J3C-65 · S/N 14833 · Cancelled Mar 5, 1956 · Yazoo Air Service
- [N62437](https://openairdocs.org/deregistered/N62437-1956-02-15.md): Consolidated Vultee BT-13A · S/N 7727 · Cancelled Feb 15, 1956 · Clanton George
- [N52504](https://openairdocs.org/deregistered/N52504-1954-02-18.md): Boeing B75 · S/N 75-1374 · Cancelled Feb 18, 1954 · Yazoo Dusting Service Inc

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

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