# Cancelled registrations: Ennis, TX

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

Cancelled aircraft registrations in Ennis, TX.

- [N4978Z](https://openairdocs.org/deregistered/N4978Z-2021-10-30.md): Piper PA-22-108 · S/N 22-8584 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1961 · Davis James Randall
- [N408P](https://openairdocs.org/deregistered/N408P-2020-10-07.md): Raytheon A36 · S/N E-3580 · Cancelled Oct 7, 2020 · Exported to Mexico · Built 2004 · Beard Bramlet
- [N397T](https://openairdocs.org/deregistered/N397T-2020-01-06.md): Beech D95A · S/N TD-544 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 1963 · Berlin Airlift Foundation
- [N5046N](https://openairdocs.org/deregistered/N5046N-2018-03-14.md): Bellanca 7GCBC · S/N 1132-79 · Cancelled Mar 14, 2018 · Registration expired, pending cancellation · Built 1979 · Walker Carol L
- [N5027G](https://openairdocs.org/deregistered/N5027G-2018-01-23.md): Bellanca 7GCBC · S/N 1174-79 · Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1979 · Setian Peter
- [N82952](https://openairdocs.org/deregistered/N82952-2017-11-21.md): Aeronca 7AC · S/N 7AC1603 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Byers John D
- [N814R](https://openairdocs.org/deregistered/N814R-2017-06-07.md): Beech K35 · S/N D-5946 · Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1959 · Laudan Timothy J
- [N5441W](https://openairdocs.org/deregistered/N5441W-2014-09-19.md): Piper PA-28-160 · S/N 28-517 · Cancelled Sep 19, 2014 · Sale reported, pending cancellation · Built 1962
- [N8257F](https://openairdocs.org/deregistered/N8257F-2013-11-08.md): Cessna 150F · S/N 15064357 · Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1966 · Ennis Flying Club Inc
- [N9869V](https://openairdocs.org/deregistered/N9869V-2013-09-19.md): Cessna 188 · S/N 188-0119 · Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1966 · Davis Charles Mike
- [N76VR](https://openairdocs.org/deregistered/N76VR-2010-01-06.md): Mellema BEDE 4 · S/N 582 · Cancelled Jan 6, 2010 · Built 1978 · Barney Thomas H
- [N82797](https://openairdocs.org/deregistered/N82797-2008-05-20.md): Kester BD-4 · S/N 553 · Cancelled May 20, 2008 · Exported to Canada · Built 1984 · Barney Thomas H II
- [N4315P](https://openairdocs.org/deregistered/N4315P-1999-05-25.md): Piper PA-23-160 · S/N 23-1816 · Cancelled May 25, 1999 · Exported to Germany · Eisenhuth Albert
- [N45540](https://openairdocs.org/deregistered/N45540-1996-12-11.md): Cessna 150M · S/N 15076965 · Cancelled Dec 11, 1996 · Exported to Czech Republic · Red Baron Aviation
- [N7132G](https://openairdocs.org/deregistered/N7132G-1986-07-01.md): Cessna 172K · S/N 17258832 · Cancelled Jul 1, 1986 · Mccormack Robert S
- [N8145F](https://openairdocs.org/deregistered/N8145F-1981-01-19.md): Cessna 150F · S/N 15064245 · Cancelled Jan 19, 1981 · Mason Robert K DBA J & J Specialties
- [N85787](https://openairdocs.org/deregistered/N85787-1976-06-16.md): Aeronca 7AC · S/N 7AC-4537 · Cancelled Jun 16, 1976 · W D Bozek
- [N3349W](https://openairdocs.org/deregistered/N3349W-1974-10-29.md): Piper PA-32-260 · S/N 32-190 · Cancelled Oct 29, 1974 · Ennis Aviation Inc
- [N89272](https://openairdocs.org/deregistered/N89272-1949-09-09.md): Cessna 140 · S/N 8298 · Cancelled Sep 9, 1949 · Schanewerk Joe
- [N37372](https://openairdocs.org/deregistered/N37372-1948-09-15.md): Interstate S-1A · S/N 215 · Cancelled Sep 15, 1948 · Built 1941 · Williams Seth S
- [N37404](https://openairdocs.org/deregistered/N37404-1948-09-15.md): Interstate S-1A · S/N 247 · Cancelled Sep 15, 1948 · Built 1942 · Williams Seth S
- [N34936](https://openairdocs.org/deregistered/N34936-1948-09-10.md): Interstate S-1A · S/N 31 · Cancelled Sep 10, 1948 · Williams Seth S

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

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