# Cancelled registrations: Mitchell, SD

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

Cancelled aircraft registrations in Mitchell, SD.

- [N32535](https://openairdocs.org/deregistered/N32535-2021-12-17.md): Pratt Randall L SONERAI I · S/N 352 · Cancelled Dec 17, 2021 · Registration expired, pending cancellation · Built 1986 · Pratt Randall L
- [N6225W](https://openairdocs.org/deregistered/N6225W-2018-08-10.md): Piper PA-28-140 · S/N 28-20266 · Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1964 · Patton Gregory John
- [N126CB](https://openairdocs.org/deregistered/N126CB-2013-08-23.md): Cameron Balloons V-56 · S/N 324 · Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1977
- [N1990Z](https://openairdocs.org/deregistered/N1990Z-2013-08-21.md): Cameron Balloons US V-77 · S/N 5269 · Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1986
- [N2018F](https://openairdocs.org/deregistered/N2018F-2013-08-21.md): Cameron Balloons US O-77 · S/N 5365 · Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1987
- [N225CB](https://openairdocs.org/deregistered/N225CB-2013-06-14.md): Cameron Balloons V-56 · S/N 456 · Cancelled Jun 14, 2013 · Sale reported, canceled · Built 1980
- [N6695P](https://openairdocs.org/deregistered/N6695P-2013-04-30.md): Piper PA-24-250 · S/N 24-1820 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1960 · Myers Stanley H
- [N2989G](https://openairdocs.org/deregistered/N2989G-2013-04-02.md): Cameron Balloons US N-77 · S/N 5181 · Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1986
- [N2165S](https://openairdocs.org/deregistered/N2165S-2012-08-21.md): Cessna 210L · S/N 21061126 · Cancelled Aug 21, 2012 · Exported to Australia · Built 1975 · Top Flight L L C
- [N6538Z](https://openairdocs.org/deregistered/N6538Z-2004-04-27.md): Cessna TU206G · S/N U20606313 · Cancelled Apr 27, 2004 · Exported to Mexico · Built 1981 · Nedved Lonnie J DBA
- [N3097R](https://openairdocs.org/deregistered/N3097R-1993-04-14.md): Raven S-60A · S/N S60A132 · Cancelled Apr 14, 1993 · Soukup & Thomas Balloon Museum Inc
- [N4436J](https://openairdocs.org/deregistered/N4436J-1993-01-26.md): Piper J3C-65 · S/N 19867 · Cancelled Jan 26, 1993 · Wagner Harold J
- [N6933V](https://openairdocs.org/deregistered/N6933V-1991-03-25.md): Mooney M20F · S/N 221306 · Cancelled Mar 25, 1991 · Triennial form not returned · Sheesley Plumbing & Heating Inc
- [N1371B](https://openairdocs.org/deregistered/N1371B-1967-07-27.md): Luscombe 8F · S/N 5998 · Cancelled Jul 27, 1967 · Reverend Joseph Burns
- [N7956E](https://openairdocs.org/deregistered/N7956E-1965-12-27.md): Cessna 150 · S/N 17756 · Cancelled Dec 27, 1965 · Gregg Aviation
- [N2261N](https://openairdocs.org/deregistered/N2261N-1964-01-09.md): Cessna 140 · S/N 12497 · Cancelled Jan 9, 1964 · Brech Doyle J Sr
- [N5343P](https://openairdocs.org/deregistered/N5343P-1963-09-11.md): Piper PA-24-180 · S/N 24-388 · Cancelled Sep 11, 1963 · Exported to Canada · Built 1958 · Rushing Ray
- [N50183](https://openairdocs.org/deregistered/N50183-1955-10-10.md): Fairchild M-62A · S/N T41-1058 · Cancelled Oct 10, 1955 · Kenneth F Post
- [N2848H](https://openairdocs.org/deregistered/N2848H-1951-01-18.md): Engineering & Research ERCOUPE 415-C · S/N 3473 · Cancelled Jan 18, 1951 · Built 1946 · Wilson Motor Service
- [N805K](https://openairdocs.org/deregistered/N805K-1938-08-21.md): Great Lakes 2T-1A · S/N 66 · Cancelled Aug 21, 1938 · Built 1929 · Toomire Arley F
- [N4110](https://openairdocs.org/deregistered/N4110-1935-09-01.md): Travel Air 2000 · S/N 100 SUB · Cancelled Sep 1, 1935 · Ronald M B
- [N6598](https://openairdocs.org/deregistered/N6598-1934-12-15.md): American Eagle 101 · S/N 252 · Cancelled Dec 15, 1934 · Built 1928 · Kutil Rudolph G

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

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