# Cancelled registrations: Crystal City, TX

A list on [Crystal City, TX](https://openairdocs.org/faa-place/TX/Crystal%20City.md).

Cancelled aircraft registrations in Crystal City, TX.

- [N65365](https://openairdocs.org/deregistered/N65365-2017-11-22.md): Consolidated Vultee BT-13A · S/N 3161 · Cancelled Nov 22, 2017 · Revoked, pending cancellation · Built 1942 · Gardner Bros
- [N9794Z](https://openairdocs.org/deregistered/N9794Z-2017-02-13.md): North American SNJ-5 · S/N AJ954 · Cancelled Feb 13, 2017 · Revoked, canceled · Gardner Bros
- [N9029A](https://openairdocs.org/deregistered/N9029A-2017-02-04.md): Cessna 170B · S/N 18784 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1949 · Carr Dave C
- [N76878](https://openairdocs.org/deregistered/N76878-2015-05-04.md): Hughes 269A · S/N 980985 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1964 · Zavala County Sheriffs Department
- [N6512E](https://openairdocs.org/deregistered/N6512E-2013-04-30.md): Cessna 175 · S/N 56012 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1959 · Carr Charles S
- [N1698S](https://openairdocs.org/deregistered/N1698S-2013-02-26.md): Snow 600-S2C · S/N 600-1294C · Cancelled Feb 26, 2013 · Sale reported, pending cancellation · Built 1965
- [N4042P](https://openairdocs.org/deregistered/N4042P-2012-11-15.md): Piper PA-23-160 · S/N 23-1519 · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1958 · Lico Inc
- [N1673S](https://openairdocs.org/deregistered/N1673S-2012-08-10.md): Snow 600-S2C · S/N 600-1248C · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1965 · Franks Crop Dusting Service Inc
- [N6634H](https://openairdocs.org/deregistered/N6634H-2011-08-08.md): Piper J3C-65 · S/N 19838 · Cancelled Aug 8, 2011 · Registration pending, canceled · Built 1946
- [N6838R](https://openairdocs.org/deregistered/N6838R-2010-05-17.md): Cessna T210G · S/N T210-0238 · Cancelled May 17, 2010 · Exported to Mexico · Built 1966 · Poston Daniel A
- [N9773V](https://openairdocs.org/deregistered/N9773V-1971-10-26.md): Cessna 188 · S/N 188-0223 · Cancelled Oct 26, 1971 · Braxdale Aviation Inc
- [N7584C](https://openairdocs.org/deregistered/N7584C-1970-10-12.md): Callair A-4 · S/N 189 · Cancelled Oct 12, 1970 · Franks W M
- [N9964C](https://openairdocs.org/deregistered/N9964C-1970-06-25.md): Callair A-5 · S/N 219 · Cancelled Jun 25, 1970 · Ag Aero Service
- [N9481R](https://openairdocs.org/deregistered/N9481R-1970-06-11.md): Snow S2C · S/N 1120C · Cancelled Jun 11, 1970 · Franks Crop Dusting Service Inc
- [N7214W](https://openairdocs.org/deregistered/N7214W-1968-10-15.md): Piper PA-28-180 · S/N 28-1028 · Cancelled Oct 15, 1968 · Exported to Canada · Wagner Mary
- [N3662G](https://openairdocs.org/deregistered/N3662G-1964-10-08.md): North American T-28A · S/N 49-1577A · Cancelled Oct 8, 1964 · Stacy M J
- [N50544](https://openairdocs.org/deregistered/N50544-1956-04-30.md): Fairchild M-62A · S/N T42-3969 · Cancelled Apr 30, 1956 · Carmona Ralph
- [N36926](https://openairdocs.org/deregistered/N36926-1955-10-10.md): Aeronca 65-CA · S/N CA18051 · Cancelled Oct 10, 1955 · Built 1941 · Wagner Warren Erler
- [N63863](https://openairdocs.org/deregistered/N63863-1955-09-23.md): Boeing B75N1 · S/N 75-6580 · Cancelled Sep 23, 1955 · Carmona Ralph
- [N4518M](https://openairdocs.org/deregistered/N4518M-1951-01-29.md): Piper PA-11 · S/N 11-21 · Cancelled Jan 29, 1951 · Exported to Mexico · Built 1947 · Haskett Harold J
- [N7356P](https://openairdocs.org/deregistered/N7356P-undated.md): Piper PA-24-250 · S/N 24-2534 · Cancellation date not recorded · Winter Garden Aviation 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 = 'CRYSTAL CITY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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