# Cancelled registrations: Grandview, MO

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

Cancelled aircraft registrations in Grandview, MO.

- [N1006](https://openairdocs.org/deregistered/N1006-2019-05-04.md): Bradshaw-Smith MINIPLANE B-1 · S/N B-1 · Cancelled May 4, 2019 · Revoked, canceled · Built 1962 · Floyd Michael B
- [N2781Y](https://openairdocs.org/deregistered/N2781Y-2018-03-23.md): Beech 95 · S/N TD-151 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1958 · Kernolde Op
- [N3662D](https://openairdocs.org/deregistered/N3662D-2017-07-18.md): Balloon Works FIREFLY 7 · S/N F7-050 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 1983 · Nunn Clide B Jr
- [N139JR](https://openairdocs.org/deregistered/N139JR-2014-09-03.md): Douglas DC3C · S/N 20550 · Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1943
- [N4087S](https://openairdocs.org/deregistered/N4087S-2013-08-22.md): Atteberry Gary CHNGR II CLIPPEDWNG · S/N CH21192CW0900 · Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1994
- [N2525W](https://openairdocs.org/deregistered/N2525W-2013-07-18.md): Beech B24R · S/N MC-199 · Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1973 · Bell Aero Technologies
- [N60677](https://openairdocs.org/deregistered/N60677-2013-07-16.md): Cessna 150J · S/N 15070494 · Cancelled Jul 16, 2013 · Revoked, canceled · Built 1969 · Johnson Joseph N
- [N6889V](https://openairdocs.org/deregistered/N6889V-2013-05-02.md): Mooney M20F · S/N 22-1276 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1975 · Todd Charles C
- [N3840E](https://openairdocs.org/deregistered/N3840E-2012-11-13.md): Aeronca 7AC · S/N 7AC-7090 · Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1947 · Nugent John E
- [N15369](https://openairdocs.org/deregistered/N15369-2012-08-07.md): Balloon Works FIREFLY 7-B · S/N 10238 · Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1981 · Furr Don R
- [N4070U](https://openairdocs.org/deregistered/N4070U-2012-06-04.md): Cessna 150E · S/N 15061470 · Cancelled Jun 4, 2012 · Revoked, canceled · Built 1965 · Russian Conrad T
- [N68VT](https://openairdocs.org/deregistered/N68VT-2006-08-14.md): Beech V35A · S/N D-8656 · Cancelled Aug 14, 2006 · Triennial form not returned · Built 1967 · Messer Crown And Bridge Lab Inc
- [N90495](https://openairdocs.org/deregistered/N90495-2006-04-03.md): Keister Daniel SONERAI II · S/N 12771 · Cancelled Apr 3, 2006 · Triennial form not returned · Keister Daniel J
- [N7151H](https://openairdocs.org/deregistered/N7151H-1995-10-25.md): Bleything Claude D MARK II TWINSTAR · S/N M2254 · Cancelled Oct 25, 1995 · Triennial form not returned · Topping Don
- [N6226U](https://openairdocs.org/deregistered/N6226U-1981-05-07.md): Mooney M20C · S/N 2065 · Cancelled May 7, 1981 · Moeller-Pickett & Associates Inc
- [N1439N](https://openairdocs.org/deregistered/N1439N-1970-11-30.md): Piper J3C-65 · S/N 22967 · Cancelled Nov 30, 1970 · Carter Paul O Etal
- [N61286](https://openairdocs.org/deregistered/N61286-1965-07-12.md): Piper PA-18-125 · S/N 18-859 · Cancelled Jul 12, 1965 · Grandview Air Force Base Aero Club
- [N4938E](https://openairdocs.org/deregistered/N4938E-1963-08-16-GL-L.md): Bensen Gyrocopter B7MC · S/N GL-L · Cancelled Aug 16, 1963 · Gary Lee Meredith
- [N4938E](https://openairdocs.org/deregistered/N4938E-1963-08-16-GM-L.md): Bensen Gyrocopter B7MC · S/N GM-L · Cancelled Aug 16, 1963 · Gary Lee Meredith

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

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