# Cancelled registrations: Kingfisher, OK

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

Cancelled aircraft registrations in Kingfisher, OK.

- [N55439](https://openairdocs.org/deregistered/N55439-2018-02-15.md): Quad City CHALLENGER I · S/N 0296 0607 · Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Built 1996 · Pyle Lester D
- [N4357Z](https://openairdocs.org/deregistered/N4357Z-2012-11-21.md): Piper PA-18-150 · S/N 18-8675 · Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1968 · Kingfisher Airport
- [N71620](https://openairdocs.org/deregistered/N71620-2000-09-12.md): Luscombe 8A · S/N 3047 · Cancelled Sep 12, 2000 · Ludwig Enterprises
- [N4786Y](https://openairdocs.org/deregistered/N4786Y-1991-06-05.md): Piper PA-25-235 · S/N 254557 · Cancelled Jun 5, 1991 · Exported to Sweden · Newberry Brice
- [N5712V](https://openairdocs.org/deregistered/N5712V-1985-10-22.md): Beech 95-C55 · S/N TE-96 · Cancelled Oct 22, 1985 · Caw Construction Co
- [N68554](https://openairdocs.org/deregistered/N68554-1979-09-25.md): Bellanca 7GCBC · S/N 390-72 · Cancelled Sep 25, 1979 · Exported to Canada · Jech Arnold L
- [N4473E](https://openairdocs.org/deregistered/N4473E-1971-01-20.md): Aeronca 7DC · S/N 7DC98 · Cancelled Jan 20, 1971 · Kingfisher Airport
- [N317C](https://openairdocs.org/deregistered/N317C-1970-06-29.md): Stinson 108-2 · S/N 108-3317 · Cancelled Jun 29, 1970 · Kingfisher Airport
- [N3818Z](https://openairdocs.org/deregistered/N3818Z-1968-06-26.md): Piper PA-18-150 · S/N 18-7556 · Cancelled Jun 26, 1968 · Kingfisher Airport
- [N3090Z](https://openairdocs.org/deregistered/N3090Z-1960-11-07.md): Piper PA-18A 150 · S/N 18-7144 · Cancelled Nov 7, 1960 · Exported to Jamaica · Built 1959 · Kingfisher Airport
- [N2872Z](https://openairdocs.org/deregistered/N2872Z-1960-09-10.md): Piper PA-18A 150 · S/N 18-7034 · Cancelled Sep 10, 1960 · Exported to Jamaica · Kingfisher Airport
- [N3596K](https://openairdocs.org/deregistered/N3596K-1958-05-02.md): Piper J3C-65 · S/N 22287 · Cancelled May 2, 1958 · White W V
- [N5062H](https://openairdocs.org/deregistered/N5062H-1951-07-09.md): Piper PA-11 · S/N 11-961 · Cancelled Jul 9, 1951 · Kingfisher Airport
- [N3055E](https://openairdocs.org/deregistered/N3055E-1950-01-04.md): Aeronca 7AC · S/N 7AC-6644 · Cancelled Jan 4, 1950 · Skala Frank E
- [N88081](https://openairdocs.org/deregistered/N88081-1949-09-09.md): Piper J3C-65 · S/N 15697 · Cancelled Sep 9, 1949 · Kingfisher Airport
- [N18704](https://openairdocs.org/deregistered/N18704-1948-05-05.md): Arrow F · S/N 67 · Cancelled May 5, 1948 · Built 1937 · Strickland Irwing James/Callison G E

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

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