# Cancelled registrations: Edcouch, TX

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

Cancelled aircraft registrations in Edcouch, TX.

- [N75934](https://openairdocs.org/deregistered/N75934-2017-02-04.md): Boeing N2S-4 · S/N 753486 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1942 · Mckinnis E F
- [N4412S](https://openairdocs.org/deregistered/N4412S-1982-08-23.md): Air Tractor AT-301 · S/N 301-0072 · Cancelled Aug 23, 1982 · Built 1977 · Neal W J
- [N6643K](https://openairdocs.org/deregistered/N6643K-1982-04-27.md): Grumman G-164B · S/N 404B · Cancelled Apr 27, 1982 · Exported to Mexico · Cannon Agricultural Aviation Service Inc
- [N614U](https://openairdocs.org/deregistered/N614U-1981-05-07.md): Grumman G-164 · S/N 342 · Cancelled May 7, 1981 · Neal W J
- [N65105](https://openairdocs.org/deregistered/N65105-1973-09-14.md): Consolidated Vultee SNV-1 · S/N 6326 · Cancelled Sep 14, 1973 · Odom Stanley C
- [N59493](https://openairdocs.org/deregistered/N59493-1973-09-04.md): Consolidated Vultee BT-13A · S/N 6086 · Cancelled Sep 4, 1973 · Stanley C Odom
- [N47828](https://openairdocs.org/deregistered/N47828-1971-10-20.md): Cessna T-50 · S/N 5091 · Cancelled Oct 20, 1971 · Wylie I R & Odom Stanley C
- [N993X](https://openairdocs.org/deregistered/N993X-1971-01-04.md): Grumman G-164A · S/N 518 · Cancelled Jan 4, 1971 · Gonzales Raul Jr
- [N45204](https://openairdocs.org/deregistered/N45204-1965-06-06.md): Naval Aircraft Factory N3N-3 · S/N 2862 · Cancelled Jun 6, 1965 · Stanley C Odom
- [N57857](https://openairdocs.org/deregistered/N57857-1965-06-05.md): Boeing A75N1 · S/N 75115 · Cancelled Jun 5, 1965 · Odom Stanley
- [N54093](https://openairdocs.org/deregistered/N54093-1965-06-03.md): Boeing D75N1 · S/N 75-4008 · Cancelled Jun 3, 1965 · Odom C Stanley
- [N59546](https://openairdocs.org/deregistered/N59546-1965-06-03.md): Boeing A75N1 · S/N 75-4337 · Cancelled Jun 3, 1965 · Odom Stanley C
- [N51777](https://openairdocs.org/deregistered/N51777-1956-08-21.md): Boeing A75N1(PT17) · S/N 75-4505 · Cancelled Aug 21, 1956 · Mckinnis E F
- [N59673](https://openairdocs.org/deregistered/N59673-1956-03-08.md): Consolidated Vultee BT-13A · S/N 5999 · Cancelled Mar 8, 1956 · John T Crawford
- [N3955M](https://openairdocs.org/deregistered/N3955M-1951-10-02.md): Piper PA-12 · S/N 12-2855 · Cancelled Oct 2, 1951 · Miller N B
- [N98146](https://openairdocs.org/deregistered/N98146-1951-04-05.md): Piper J3C-65 · S/N 18305 · Cancelled Apr 5, 1951 · Miller Niles Boyd

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

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