# Cancelled registrations: Brenham, TX

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

Cancelled aircraft registrations in Brenham, TX.

- [N608YQ](https://openairdocs.org/deregistered/N608YQ-2022-02-05.md): DJI Innovations INSPIRE 1 · S/N 0410057022 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · New Story Media LLC
- [N608ZK](https://openairdocs.org/deregistered/N608ZK-2022-02-05.md): DJI Innovations INSPIRE 1 · S/N 0410011271 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · New Story Media LLC
- [N639LX](https://openairdocs.org/deregistered/N639LX-2019-05-03.md): DJI PHANTOM 2 · S/N PH645148178 · Cancelled May 3, 2019 · Registration expired, pending cancellation · New Story Media LLC
- [N98946](https://openairdocs.org/deregistered/N98946-2018-08-23.md): Piper PA-12 · S/N 12-301 · Cancelled Aug 23, 2018 · Revoked, canceled · Built 1946 · Coats Jon B
- [N750RD](https://openairdocs.org/deregistered/N750RD-2018-03-07.md): Wilson R Dupuis CH750 · S/N 75-8703 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Dupuis Wilson R
- [N40711](https://openairdocs.org/deregistered/N40711-2014-12-18.md): Piper PA-28R-200 · S/N 28R-7435115 · Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1973
- [N1393R](https://openairdocs.org/deregistered/N1393R-2014-09-05.md): Grumman American Avn. AA-5 · S/N AA5-0793 · Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1975 · Mcbride Darrell C
- [N255M](https://openairdocs.org/deregistered/N255M-2013-12-17.md): Yakovlev YAK-55M · S/N 920408 · Cancelled Dec 17, 2013 · Exported to Canada · Built 1992 · Reed Randall W
- [N3574S](https://openairdocs.org/deregistered/N3574S-2012-11-08.md): Cessna 172E · S/N 17250774 · Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1963 · Cunningham William D DBA
- [N978SH](https://openairdocs.org/deregistered/N978SH-2010-04-05.md): Robinson Helicopter R22 BETA · S/N 4070 · Cancelled Apr 5, 2010 · Exported to South Africa · Ross Michael Peter
- [N3299N](https://openairdocs.org/deregistered/N3299N-2009-10-09.md): Piper J3C-65 · S/N 22495 · Cancelled Oct 9, 2009 · Registration revoked · Built 1946 · Coats Jon B
- [N592JD](https://openairdocs.org/deregistered/N592JD-2009-09-08.md): Pdps Pzl-Bielsko SZD-59 · S/N B-2158 · Cancelled Sep 8, 2009 · Built 1994 · Zaremba Anthony B
- [N1238L](https://openairdocs.org/deregistered/N1238L-2004-11-24.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 737 · Cancelled Nov 24, 2004 · Triennial form not returned · Built 1976 · Take Flight Inc
- [N13335](https://openairdocs.org/deregistered/N13335-1996-10-25.md): Cessna 177B · S/N 17702413 · Cancelled Oct 25, 1996 · Exported to Canada · Built 1976 · Bluebonnet Aero
- [N1406D](https://openairdocs.org/deregistered/N1406D-1993-04-01.md): Cessna 170A · S/N 20130 · Cancelled Apr 1, 1993 · Exported to South Africa · Cummings Joel M DBA
- [N9402R](https://openairdocs.org/deregistered/N9402R-1981-10-15.md): Snow S2A · S/N 1031 · Cancelled Oct 15, 1981 · Nickles Charles E
- [N345](https://openairdocs.org/deregistered/N345-1957-02-15-8051.md): Standard J-1 · S/N 8051 · Cancelled Feb 15, 1957 · Built 1928 · Wilfley Walter
- [N4485N](https://openairdocs.org/deregistered/N4485N-1949-05-10.md): Boeing E75N1 · S/N 75-8305 · Cancelled May 10, 1949 · Exported to Mexico · Mills Aerial Service

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

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