# Cancelled registrations: Ada, OK

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

Cancelled aircraft registrations in Ada, OK.

- [N237CN](https://openairdocs.org/deregistered/N237CN-2022-11-05.md): DJI MAVIC 2 PRO · S/N 163CJ7PR0A8A7N · Cancelled Nov 5, 2022 · Chickasaw Nation Tribal Government
- [N647ND](https://openairdocs.org/deregistered/N647ND-2021-11-05.md): DJI PHANTOM 2 VISION + · S/N PH645470838 · Cancelled Nov 5, 2021 · First renewal notice · Doyle Ricky W
- [N685ZC](https://openairdocs.org/deregistered/N685ZC-2019-10-05.md): DJI PHANTOM 2 · S/N DJ6-PT645306586 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Clonch Brad W
- [N6868C](https://openairdocs.org/deregistered/N6868C-2019-09-06.md): DJI PHANTOM 2 · S/N B85E4B90190FDB137B213CDDA49722 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Chickasaw Nation Communications And Community
- [N6869N](https://openairdocs.org/deregistered/N6869N-2019-09-06.md): DJI SPREADINGWINGS S1000 · S/N 8AF5C37F0BB3348EDE54ELLE8CEAE4 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Chickasaw Nation
- [N387TG](https://openairdocs.org/deregistered/N387TG-2018-02-07.md): Griboski Morgan R QUICKIE 1 · S/N 001 · Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Griboski Morgan R
- [N4191U](https://openairdocs.org/deregistered/N4191U-2017-02-17.md): Cessna 150D · S/N 15060191 · Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 1963 · Vandeveer Chris R
- [N87156](https://openairdocs.org/deregistered/N87156-2013-05-15.md): Ercoupe 415-C · S/N 329 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1946 · Mcgehee Wendyl B
- [N8521C](https://openairdocs.org/deregistered/N8521C-2013-05-14.md): Piper PA-22-135 · S/N 22-1233 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1953 · Lawrence Phillip W
- [N57MM](https://openairdocs.org/deregistered/N57MM-2013-04-23.md): Beech 65-A90 · S/N LJ-126 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1966 · Son Properties Inc
- [N83965](https://openairdocs.org/deregistered/N83965-2012-11-13.md): Aeronca 7AC · S/N 7AC-2651 · Cancelled Nov 13, 2012 · Sale reported, pending cancellation · Built 1946
- [N39250](https://openairdocs.org/deregistered/N39250-2011-08-10.md): Taylorcraft BF · S/N 6504 · Cancelled Aug 10, 2011 · Revoked, canceled · Built 1945 · Vandiver Robert Eugene
- [N9576Y](https://openairdocs.org/deregistered/N9576Y-2005-09-28.md): Beech 95-A55 · S/N TC-358 · Cancelled Sep 28, 2005 · Second triennial form not returned · Built 1962 · Pajo Publishing Inc
- [N7030V](https://openairdocs.org/deregistered/N7030V-2002-05-30.md): Mooney M20F · S/N 22-1377 · Cancelled May 30, 2002 · Triennial form not returned · Built 1976 · Deaton Austin R Jr
- [N7165V](https://openairdocs.org/deregistered/N7165V-1995-10-02.md): Mooney M20F · S/N 220074 · Cancelled Oct 2, 1995 · Triennial form not returned · Floyd Paul Raymond
- [N4359F](https://openairdocs.org/deregistered/N4359F-1991-01-31.md): Piper PA-28-151 · S/N 287715025 · Cancelled Jan 31, 1991 · Kellogg Donald H
- [N1VE](https://openairdocs.org/deregistered/N1VE-1984-06-11.md): Piper PA-30 · S/N 301260 · Cancelled Jun 11, 1984 · Lee Jim R
- [N19959](https://openairdocs.org/deregistered/N19959-1974-04-22.md): Cessna 172M · S/N 17260888 · Cancelled Apr 22, 1974 · Love Iven Edward
- [N5160T](https://openairdocs.org/deregistered/N5160T-1973-06-25.md): Champion 7ECA · S/N 190 · Cancelled Jun 25, 1973 · Davis Charles M
- [N8988D](https://openairdocs.org/deregistered/N8988D-1970-06-24.md): Piper PA-18A · S/N 18-6392 · Cancelled Jun 24, 1970 · Harris George D
- [N69565](https://openairdocs.org/deregistered/N69565-1965-12-14.md): Stinson VULTEE V-77 · S/N 77-11 · Cancelled Dec 14, 1965 · Watson M Lewis
- [N4670N](https://openairdocs.org/deregistered/N4670N-1955-10-18.md): Consolidated Vultee BT-13 · S/N 11594 · Cancelled Oct 18, 1955 · Walsh Justin Enright
- [N54109](https://openairdocs.org/deregistered/N54109-1955-10-11.md): Fairchild M-62A · S/N 5813AE · Cancelled Oct 11, 1955 · Elwood Kingery
- [N2029E](https://openairdocs.org/deregistered/N2029E-1951-11-02.md): Aeronca 7AC · S/N 7AC-5599 · Cancelled Nov 2, 1951 · Myers Flying Service Inc
- [N8262K](https://openairdocs.org/deregistered/N8262K-1949-06-04.md): Stinson 108-1 · S/N 108-1-1262 · Cancelled Jun 4, 1949 · Built 1946 · Myers Escal
- [N4619N](https://openairdocs.org/deregistered/N4619N-1948-03-22.md): Boeing PT-17 · S/N 75-3515 · Cancelled Mar 22, 1948 · Wolfe O E
- [N24842](https://openairdocs.org/deregistered/N24842-1941-11-26.md): Piper J3F-50 · S/N 3483 · Cancelled Nov 26, 1941 · Kelley Robert M

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

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