# Cancelled registrations: Coffeyville, KS

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

Cancelled aircraft registrations in Coffeyville, KS.

- [N73386](https://openairdocs.org/deregistered/N73386-2020-02-21.md): Fairchild M-62A · S/N T434451 · Cancelled Feb 21, 2020 · Revoked, canceled · Built 1943 · Abshier Edwin W
- [N77704](https://openairdocs.org/deregistered/N77704-2018-03-06.md): Mcclish FUNK B85C · S/N 334 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Roesky Emil W
- [N23423](https://openairdocs.org/deregistered/N23423-2017-10-28.md): Piper J4A · S/N 4613 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Beeson Joe
- [N9027D](https://openairdocs.org/deregistered/N9027D-2013-05-17.md): Cessna 421B · S/N 421B-0128 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1970 · Central States Aircraft Sales Inc
- [N270AC](https://openairdocs.org/deregistered/N270AC-2012-09-20.md): Aero Commander 685 · S/N 12011 · Cancelled Sep 20, 2012 · Registration expired, pending cancellation · Built 1972 · Central States Acft Sales Inc
- [N34768](https://openairdocs.org/deregistered/N34768-2012-06-04.md): Mcclish FUNK B75L · S/N 215 · Cancelled Jun 4, 2012 · Registration pending, canceled
- [N133G](https://openairdocs.org/deregistered/N133G-2004-12-02.md): Langworthy H J/Langworthy G R SMYTH SIDEWINDER · S/N 212357 · Cancelled Dec 2, 2004 · Triennial form not returned · Langworthy Harold J
- [N48642](https://openairdocs.org/deregistered/N48642-1995-07-07.md): Cessna 152 · S/N 15283355 · Cancelled Jul 7, 1995 · Exported to Spain · Coffeyville Aircraft Inc
- [N24720](https://openairdocs.org/deregistered/N24720-1995-06-28.md): Cessna 152 · S/N 15280337 · Cancelled Jun 28, 1995 · Exported to Spain · Coffeyville Aircraft Inc
- [N625CA](https://openairdocs.org/deregistered/N625CA-1995-06-28.md): Cessna 152 · S/N 15283461 · Cancelled Jun 28, 1995 · Exported to Spain · Coffeyville Aircraft Inc
- [N2027](https://openairdocs.org/deregistered/N2027-1995-03-30.md): Leathers-Breezy RLU1 · S/N LL1 · Cancelled Mar 30, 1995 · City Of Coffeyville
- [N5046U](https://openairdocs.org/deregistered/N5046U-1982-05-05.md): Cessna 206 · S/N 2060046 · Cancelled May 5, 1982 · Exported to Panama · Coffeyville Aircraft Inc
- [N367B](https://openairdocs.org/deregistered/N367B-1976-07-14.md): Beech 95 · S/N TD-3 · Cancelled Jul 14, 1976 · Jensen Brothers Manufacturing Co Inc
- [N87360](https://openairdocs.org/deregistered/N87360-1974-08-28.md): Erco 415-C · S/N 533 · Cancelled Aug 28, 1974 · Scissel Bob
- [N21357](https://openairdocs.org/deregistered/N21357-1974-05-15.md): Cessna 182P · S/N 18261584 · Cancelled May 15, 1974 · Built 1972 · Lightstone Aviation Inc
- [N61558](https://openairdocs.org/deregistered/N61558-1965-05-21.md): Boeing PT-17 · S/N 75-1734 · Cancelled May 21, 1965 · Built 1941 · Coffeyville Airway Co
- [N29421](https://openairdocs.org/deregistered/N29421-1965-05-19.md): Aeronca 65-TL · S/N L4020T · Cancelled May 19, 1965 · Jack F Twitchell
- [N47364](https://openairdocs.org/deregistered/N47364-1955-08-02.md): Aeronca 0-58B · S/N 058B-10523 · Cancelled Aug 2, 1955 · Twitchell Jack F
- [N21891](https://openairdocs.org/deregistered/N21891-1950-02-09.md): Piper J3F-50 · S/N 2669 · Cancelled Feb 9, 1950 · Built 1939 · Bath Frank J
- [N18041](https://openairdocs.org/deregistered/N18041-1948-08-09.md): Beech E17B · S/N 152 · Cancelled Aug 9, 1948 · Built 1937 · Coffeyville Airways Company
- [N117V](https://openairdocs.org/deregistered/N117V-1948-06-10.md): Monocoupe 90 · S/N 626 · Cancelled Jun 10, 1948 · Jones Norman Et Al
- [N47690](https://openairdocs.org/deregistered/N47690-1948-05-12.md): Taylorcraft L-2A · S/N 0-4456 · Cancelled May 12, 1948 · Built 1940 · Eagle Carl L
- [N34767](https://openairdocs.org/deregistered/N34767-1943-10-21.md): Funk G · S/N 221 · Cancelled Oct 21, 1943 · Funk Aircraft Co
- [N15159](https://openairdocs.org/deregistered/N15159-1941-08-23.md): Stinson A · S/N 9119 · Cancelled Aug 23, 1941 · Exported to India · Inman Leona
- [N230M](https://openairdocs.org/deregistered/N230M-1940-05-15.md): Boeing 80-A1 · S/N 1088 · Cancelled May 15, 1940 · Inman Leona
- [N1616](https://openairdocs.org/deregistered/N1616-1937-01-28.md): American Eagle A-1 · S/N 50 · Cancelled Jan 28, 1937 · Hart Melvin
- [N309M](https://openairdocs.org/deregistered/N309M-1934-06-07.md): Cessna CG-2 · S/N 5 · Cancelled Jun 7, 1934 · Built 1930 · Coffeyville Glider Club

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

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