# Cancelled registrations: Guymon, OK

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

Cancelled aircraft registrations in Guymon, OK.

- [N651DC](https://openairdocs.org/deregistered/N651DC-2023-02-04.md): Beryl G Rich RV-3B · S/N 11511 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 2018 · Chain Dan
- [N5615X](https://openairdocs.org/deregistered/N5615X-2018-01-23.md): Aero Commander S2R · S/N 1815R · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1973 · Valley Flying Service Inc
- [N777WG](https://openairdocs.org/deregistered/N777WG-2015-12-12.md): Glasgow Michael L C-52 · S/N M1 · Cancelled Dec 12, 2015 · Built 1994 · Miller Royce D
- [N85015](https://openairdocs.org/deregistered/N85015-2013-06-05.md): Piper PA-25 · S/N 25-134 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Valley Flying Service Inc
- [N8653L](https://openairdocs.org/deregistered/N8653L-2013-05-15.md): Piper PA-25-235 · S/N 25-5096 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Valley Flying Service Inc
- [N4748M](https://openairdocs.org/deregistered/N4748M-2012-08-06.md): Piper PA-11 · S/N 11356 · Cancelled Aug 6, 2012 · Revoked, canceled · Built 1947 · Hiller Gladys
- [N1006T](https://openairdocs.org/deregistered/N1006T-2002-07-25.md): Air Tractor AT-501 · S/N 501-0030 · Cancelled Jul 25, 2002 · Second triennial mailing, no response · Built 1988 · Kokendoffer Earl J
- [N4922R](https://openairdocs.org/deregistered/N4922R-2002-07-25.md): Cessna A188B · S/N 18802439T · Cancelled Jul 25, 2002 · Second triennial mailing, no response · Built 1975 · Kokendoffer Earl
- [N9485T](https://openairdocs.org/deregistered/N9485T-2001-08-22.md): Cessna 210 · S/N 57285 · Cancelled Aug 22, 2001 · Triennial form not returned · Downing Lori L
- [N315PF](https://openairdocs.org/deregistered/N315PF-1997-02-18.md): Air Tractor AT-400 · S/N 4000315 · Cancelled Feb 18, 1997 · Triennial form not returned · Kokendoffer Earl
- [N3549W](https://openairdocs.org/deregistered/N3549W-1991-06-05.md): Piper PA-32-260 · S/N 32436 · Cancelled Jun 5, 1991 · Ramirez M Joseph
- [N9301F](https://openairdocs.org/deregistered/N9301F-1984-02-13.md): Hughes 269B · S/N 0003 · Cancelled Feb 13, 1984 · Administratively canceled · Harrington Vet Service Inc
- [N9760E](https://openairdocs.org/deregistered/N9760E-1981-12-15.md): Aeronca 11AC · S/N 11AC-1379 · Cancelled Dec 15, 1981 · Triennial form not returned · Miller Clyde
- [N9649Z](https://openairdocs.org/deregistered/N9649Z-1975-09-05.md): Intermountain CALLAIR A-9 · S/N 1039 · Cancelled Sep 5, 1975 · James Leo
- [N6759J](https://openairdocs.org/deregistered/N6759J-1973-06-26.md): Piper PA-28-140 · S/N 28-24482 · Cancelled Jun 26, 1973 · Rigby Airmotive Inc
- [N70874](https://openairdocs.org/deregistered/N70874-1971-02-04.md): Piper J3C-65 · S/N 17897 · Cancelled Feb 4, 1971 · Harley Boyd
- [N2181A](https://openairdocs.org/deregistered/N2181A-1970-06-29.md): Piper PA-22 · S/N 22-599 · Cancelled Jun 29, 1970 · Wilmot Marshall
- [N1664V](https://openairdocs.org/deregistered/N1664V-1956-03-29.md): Cessna 120 · S/N 13836 · Cancelled Mar 29, 1956 · Pritchard Herschell C
- [N24242](https://openairdocs.org/deregistered/N24242-1955-03-04.md): Aeronca 65-C · S/N C7099 · Cancelled Mar 4, 1955 · Built 1939 · Wyatt Edward
- [N52645](https://openairdocs.org/deregistered/N52645-1952-02-01.md): Fairchild PT-19 · S/N T42-3130 · Cancelled Feb 1, 1952 · Thoreson Arthur
- [N3639H](https://openairdocs.org/deregistered/N3639H-1951-10-04.md): Engineering & Research 415-C · S/N 4264 · Cancelled Oct 4, 1951 · Built 1946 · Thrall Albert D
- [N3600H](https://openairdocs.org/deregistered/N3600H-1951-05-03.md): Engineering & Research 415-C · S/N 4225 · Cancelled May 3, 1951 · Built 1946 · Odom A M
- [N1811](https://openairdocs.org/deregistered/N1811-1948-07-12.md): Travel Air Mfg 2000 · S/N 237 · Cancelled Jul 12, 1948 · Built 1927 · Noonan John
- [N114](https://openairdocs.org/deregistered/N114-1930-05-02.md): Curtiss Wright JN4C · S/N M-5198 · Cancelled May 2, 1930 · Wilmeth Cam S

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

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