# Cancelled registrations: Leland, MS

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

Cancelled aircraft registrations in Leland, MS.

- [N27195](https://openairdocs.org/deregistered/N27195-2021-06-05.md): Piper J3C-65 · S/N 4427 · Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1940 · Prather Steve H
- [N6674V](https://openairdocs.org/deregistered/N6674V-2020-07-30.md): Bellanca 17-30 · S/N 30048 · Cancelled Jul 30, 2020 · First renewal notice · Built 1967 · Butler Thomas A
- [N19229](https://openairdocs.org/deregistered/N19229-2020-07-10.md): Cessna 150L · S/N 15074256 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1972 · Saulter Marvin G Jr
- [N67011](https://openairdocs.org/deregistered/N67011-2018-04-18.md): Beech C23 · S/N M-2228 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Up And Away LLC
- [N3727C](https://openairdocs.org/deregistered/N3727C-2017-01-24.md): Piper L-4B · S/N 9868 · Cancelled Jan 24, 2017 · Revoked, pending cancellation · Civil Air Patrol Miss Wg
- [N7878F](https://openairdocs.org/deregistered/N7878F-2007-05-19.md): Cessna 150F · S/N 15063978 · Cancelled May 19, 2007 · Triennial form not returned · Built 1966 · Aero Optics Inc
- [N2882J](https://openairdocs.org/deregistered/N2882J-2004-12-03.md): Cessna A188B · S/N 18803557T · Cancelled Dec 3, 2004 · Exported to Brazil · Built 1979 · Reed Rodney D DBA
- [N8380H](https://openairdocs.org/deregistered/N8380H-2004-03-16.md): Robinson Helicopter R22 · S/N 0325 · Cancelled Mar 16, 2004 · Triennial form not returned · Built 1983 · Tri-M Agronomics LLC
- [N5195L](https://openairdocs.org/deregistered/N5195L-2003-05-02.md): Air Tractor AT-502B · S/N 502B-0537 · Cancelled May 2, 2003 · Exported to Philippines · Built 1999 · Lewis Air Service Inc
- [N6347](https://openairdocs.org/deregistered/N6347-1994-08-05.md): Dean KRI · S/N JWDI · Cancelled Aug 5, 1994 · Triennial form not returned · Grammer Charles A
- [N57587](https://openairdocs.org/deregistered/N57587-1981-02-19.md): Piper PA-36-285 · S/N 36-7560120 · Cancelled Feb 19, 1981 · Steen Pauline L DBA Delta Crop Service
- [N28002](https://openairdocs.org/deregistered/N28002-1974-03-01.md): Piper J3C-65 · S/N 4505 · Cancelled Mar 1, 1974 · Exported to Netherlands · Reed John A
- [N32977](https://openairdocs.org/deregistered/N32977-1971-01-14.md): Piper J4F · S/N 4-1327 · Cancelled Jan 14, 1971 · Built 1940 · Fred Frazier
- [N50094](https://openairdocs.org/deregistered/N50094-1970-12-31.md): Boeing A75N1 · S/N 75-1115 · Cancelled Dec 31, 1970 · Built 1941 · Frazier Fred
- [N59835](https://openairdocs.org/deregistered/N59835-1970-09-03.md): Boeing A75N1 · S/N 75-4549 · Cancelled Sep 3, 1970 · Frazier Fred
- [N7798D](https://openairdocs.org/deregistered/N7798D-1970-04-27.md): Piper PA-18A 150 · S/N 18-6007 · Cancelled Apr 27, 1970 · Exported to Netherlands · Reed Jimmie C
- [N88494](https://openairdocs.org/deregistered/N88494-1954-09-24.md): Piper J3C-65 · S/N 16118 · Cancelled Sep 24, 1954 · Huntley Blythe E
- [N5550H](https://openairdocs.org/deregistered/N5550H-1951-04-25.md): Piper PA-11 · S/N 11-1061 · Cancelled Apr 25, 1951 · Tate C A
- [N18156](https://openairdocs.org/deregistered/N18156-1948-05-12.md): Finklea Brothers FINKLEA TRAINER · S/N 1 · Cancelled May 12, 1948 · Built 1939 · Finklea Brothers
- [N350K](https://openairdocs.org/deregistered/N350K-1948-02-03.md): Parks P-1 · S/N 1977 · Cancelled Feb 3, 1948 · Finklea Brothers James Curtiss Finklea &
- [N6436](https://openairdocs.org/deregistered/N6436-1942-01-03.md): Stearman C-3-MB · S/N 176 · Cancelled Jan 3, 1942 · Dawn Cotton Dusting Corp
- [N167M](https://openairdocs.org/deregistered/N167M-1941-01-05.md): Standard D-29A · S/N 1014 · Cancelled Jan 5, 1941 · Built 1930 · Mcmullin L B & Caraway W J
- [N6456](https://openairdocs.org/deregistered/N6456-1940-04-15.md): Travel Air 4000 · S/N 777 · Cancelled Apr 15, 1940 · Dawn Cotton Dusting Corp
- [N6689](https://openairdocs.org/deregistered/N6689-1939-12-01.md): Command-Aire 3C-3 · S/N 514 · Cancelled Dec 1, 1939 · Built 1928 · Dawn Cotton Dusting Corp
- [N486W](https://openairdocs.org/deregistered/N486W-1939-04-03.md): Stearman 4CM-1 · S/N 4034 · Cancelled Apr 3, 1939 · Dawn Crop Dusting Corp
- [N10034](https://openairdocs.org/deregistered/N10034-1938-03-22.md): Eaglerock A-1 · S/N 969 · Cancelled Mar 22, 1938 · Built 1930 · Finklea Brothers
- [N13910](https://openairdocs.org/deregistered/N13910-1938-03-22.md): Stearman C3-B · S/N 153 · Cancelled Mar 22, 1938 · Finklea J A
- [N13912](https://openairdocs.org/deregistered/N13912-1938-03-22.md): Pitcairn PA-7 · S/N 2 · Cancelled Mar 22, 1938 · Finklea Brothers
- [N4129](https://openairdocs.org/deregistered/N4129-1936-08-10.md): Waco ASO · S/N 829 · Cancelled Aug 10, 1936 · Finklea Brothers J A Finklea & J C Finklea
- [N36K](https://openairdocs.org/deregistered/N36K-1934-08-05.md): New Standard D-29A · S/N 1002 · Cancelled Aug 5, 1934 · Finkles Ray
- [N13913](https://openairdocs.org/deregistered/N13913-1934-07-09.md): Pitcairn PA-6 · S/N 3 · Cancelled Jul 9, 1934 · Built 1928 · Finkle Ray
- [N607](https://openairdocs.org/deregistered/N607-1930-07-15.md): Command-Aire 5C-3A · S/N W-54 · Cancelled Jul 15, 1930 · Finklea Ray

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

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