# Cancelled registrations: Bonham, TX

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

Cancelled aircraft registrations in Bonham, TX.

- [N7062D](https://openairdocs.org/deregistered/N7062D-2020-02-21.md): Piper PA-18 · S/N 18-5599 · Cancelled Feb 21, 2020 · Revoked, canceled · Built 1957 · Stroud Loyd E
- [N2530A](https://openairdocs.org/deregistered/N2530A-2019-11-15.md): Piper PA-18-135 · S/N 18-2145 · Cancelled Nov 15, 2019 · Revoked, canceled · Built 1952 · Stroud Loyd D
- [N4880E](https://openairdocs.org/deregistered/N4880E-2019-09-14.md): Aeronca 7EC · S/N 7GC57 · Cancelled Sep 14, 2019 · Revoked, canceled · Built 1959 · Farmers Dusting Svc Inc
- [N6752P](https://openairdocs.org/deregistered/N6752P-2019-09-06.md): Piper PA-24-250 · S/N 24-1881 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1960 · Hale Sidney B
- [N7119K](https://openairdocs.org/deregistered/N7119K-2019-08-05.md): Piper PA-18-105 SPECIAL · S/N 18-337 · Cancelled Aug 5, 2019 · Revoked, canceled · Built 1950 · Stroud Loyd
- [N3552A](https://openairdocs.org/deregistered/N3552A-2015-05-15.md): Piper PA-22 · S/N 22-1826 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1953 · Walker Billy J
- [N6585W](https://openairdocs.org/deregistered/N6585W-2015-05-11.md): Piper PA-28-140 · S/N 28-20666 · Cancelled May 11, 2015 · Sale reported, canceled · Built 1965
- [N6148C](https://openairdocs.org/deregistered/N6148C-2014-12-22.md): Callair A-4 · S/N 161 · Cancelled Dec 22, 2014 · Revoked, canceled · Built 1956 · Smith Ray
- [N6BG](https://openairdocs.org/deregistered/N6BG-2014-10-29.md): Gush CASSUTT 3M · S/N 463 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1974 · Vestal Reed Jr
- [N86702](https://openairdocs.org/deregistered/N86702-2013-08-16.md): Bellanca 7KCAB · S/N 429-74 · Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1974
- [N9355U](https://openairdocs.org/deregistered/N9355U-2013-03-26.md): Cessna 150M · S/N 15078304 · Cancelled Mar 26, 2013 · Sale reported, pending cancellation · Built 1976
- [N3424B](https://openairdocs.org/deregistered/N3424B-2006-05-05.md): Beech D35 · S/N D-3662 · Cancelled May 5, 2006 · Triennial form not returned · Built 1953 · Jones Larry E
- [N78803](https://openairdocs.org/deregistered/N78803-1957-11-25.md): Piper PA-11 · S/N 11-1576 · Cancelled Nov 25, 1957 · Built 1947 · Farmer'S Dusting Service/Rennels Robert T
- [N75403](https://openairdocs.org/deregistered/N75403-1951-11-06.md): North American SNJ-4 · S/N 78-7332 · Cancelled Nov 6, 1951 · Roger Quinley
- [N84413](https://openairdocs.org/deregistered/N84413-1949-03-23.md): Aeronca 7AC · S/N 3107 · Cancelled Mar 23, 1949 · Straub A L
- [N47389](https://openairdocs.org/deregistered/N47389-1948-07-13.md): Fairchild M-62A · S/N T41-1283 · Cancelled Jul 13, 1948 · Straub A L
- [N34933](https://openairdocs.org/deregistered/N34933-1944-06-14.md): Interstate S-1A · S/N 28 · Cancelled Jun 14, 1944 · Pope H L

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

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