# Cancelled registrations: Great Bend, KS

A list on [Great Bend, KS](https://openairdocs.org/faa-place/KS/Great%20Bend.md).

Cancelled aircraft registrations in Great Bend, KS.

- [N7742P](https://openairdocs.org/deregistered/N7742P-2020-01-17.md): Piper PA-24 · S/N 24-2956 · Cancelled Jan 17, 2020 · Built 1961 · Schenk Richard J
- [N81037](https://openairdocs.org/deregistered/N81037-2019-02-05.md): Cessna 140 · S/N 10327 · Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 1946 · Cook David L Trustee
- [N567CM](https://openairdocs.org/deregistered/N567CM-2018-03-26.md): Schrieber Robert L P-70 · S/N 045 · Cancelled Mar 26, 2018 · Registration expired, pending cancellation · Built 1997 · Brining Air LLC
- [N6698P](https://openairdocs.org/deregistered/N6698P-2015-05-13.md): Piper PA-24-180 · S/N 24-1824 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1960 · Richter Roger B
- [N9PF](https://openairdocs.org/deregistered/N9PF-2015-05-04.md): Funk Philip & Betty FUNK MUSTANG M II · S/N MII-1268 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1998 · Dyer Steve
- [N4402A](https://openairdocs.org/deregistered/N4402A-2013-05-13.md): Raven S-60A · S/N S60A-345 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1984 · Steve Boyd DBA
- [N18550](https://openairdocs.org/deregistered/N18550-2013-03-26.md): Cessna C-37 · S/N 369 · Cancelled Mar 26, 2013 · Sale reported, canceled
- [N2668B](https://openairdocs.org/deregistered/N2668B-1993-07-22.md): Cessna 421C · S/N 421C0276 · Cancelled Jul 22, 1993 · Triennial form not returned · Midwest Piper Sales Great Bend Inc
- [N2870X](https://openairdocs.org/deregistered/N2870X-1983-01-26.md): Piper PA-28-236 · S/N 28-7911214 · Cancelled Jan 26, 1983 · Midwest Industrial Machinery Inc
- [N756KD](https://openairdocs.org/deregistered/N756KD-1982-11-08.md): Cessna TR182 · S/N R18201090 · Cancelled Nov 8, 1982 · Allen Drilling Co
- [N8637E](https://openairdocs.org/deregistered/N8637E-1982-01-05.md): Homesick Angel BENSEN B-8 · S/N 1 · Cancelled Jan 5, 1982 · Ravenstein Donald D
- [N1620N](https://openairdocs.org/deregistered/N1620N-1961-03-01.md): Funk B85C · S/N 396 · Cancelled Mar 1, 1961 · Built 1947 · Button Charles
- [N880B](https://openairdocs.org/deregistered/N880B-1959-07-28.md): Mooney M20 · S/N 1043 · Cancelled Jul 28, 1959 · Built 1956 · Carothers Barton/ Moses Edward R
- [N41714](https://openairdocs.org/deregistered/N41714-1957-03-12.md): Culver LFA · S/N 431 · Cancelled Mar 12, 1957 · Rathbun William
- [N8707A](https://openairdocs.org/deregistered/N8707A-1956-06-05.md): Beech A35 · S/N D-2117 · Cancelled Jun 5, 1956 · Built 1949 · Bee Formation Testing Company
- [N2109N](https://openairdocs.org/deregistered/N2109N-1955-10-05.md): Cessna 140 · S/N 12345 · Cancelled Oct 5, 1955 · Isern Leonard J
- [N94970](https://openairdocs.org/deregistered/N94970-1954-02-17.md): Taylorcraft BC12-D · S/N 9370 · Cancelled Feb 17, 1954 · Zutavern Jerry B
- [N4466C](https://openairdocs.org/deregistered/N4466C-1954-02-03.md): Cessna 195A · S/N 16051 · Cancelled Feb 3, 1954 · Schartz Implement Co
- [N95354](https://openairdocs.org/deregistered/N95354-1954-02-03.md): Taylorcraft BC12-D · S/N 9754 · Cancelled Feb 3, 1954 · Crest Flying Club Inc
- [N2793N](https://openairdocs.org/deregistered/N2793N-1954-01-29.md): Cessna 140 · S/N 13054 · Cancelled Jan 29, 1954 · Carpenter M B
- [N1278C](https://openairdocs.org/deregistered/N1278C-1954-01-26.md): Piper PA-22-135 · S/N 22-1072 · Cancelled Jan 26, 1954 · Blackburn S R
- [N2010D](https://openairdocs.org/deregistered/N2010D-1954-01-26.md): Beech C35 · S/N D-3360 · Cancelled Jan 26, 1954 · Spruill Motors Inc
- [N2669A](https://openairdocs.org/deregistered/N2669A-1954-01-26.md): Piper PA-18 · S/N 18-2185 · Cancelled Jan 26, 1954 · Rosencrantz-Bemis Equipt Co Inc
- [N3002A](https://openairdocs.org/deregistered/N3002A-1954-01-26.md): Cessna 170B · S/N 25646 · Cancelled Jan 26, 1954 · Moses Ed R
- [N4602K](https://openairdocs.org/deregistered/N4602K-1954-01-26.md): Ryan NAVION A · S/N NAV-4-1602 · Cancelled Jan 26, 1954 · Berwick S A
- [N5920C](https://openairdocs.org/deregistered/N5920C-1954-01-26.md): Beech C35 · S/N D-3280 · Cancelled Jan 26, 1954 · J D Ferrell Drilling Co Inc
- [N74304](https://openairdocs.org/deregistered/N74304-1954-01-26.md): Bellanca 14-13-2 · S/N 1417 · Cancelled Jan 26, 1954 · Built 1947 · White Chas L
- [N1952B](https://openairdocs.org/deregistered/N1952B-1954-01-22.md): Luscombe 8F · S/N 6379 · Cancelled Jan 22, 1954 · Peters Drilling Co
- [N89282](https://openairdocs.org/deregistered/N89282-1951-05-24.md): Cessna 140 · S/N 8308 · Cancelled May 24, 1951 · Ferrell A J
- [N34557](https://openairdocs.org/deregistered/N34557-1951-04-25.md): Aeronca 65-CA · S/N 15691 · Cancelled Apr 25, 1951 · George Elbert Parrish
- [N50889](https://openairdocs.org/deregistered/N50889-1948-11-18.md): Cessna T-50 · S/N 5955 · Cancelled Nov 18, 1948 · Black Marshall Oil Co
- [N14410](https://openairdocs.org/deregistered/N14410-1936-09-27.md): Swallow TP-K · S/N 213 · Cancelled Sep 27, 1936 · Roland O Wells

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

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