# Cancelled registrations: Danbury, TX

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

Cancelled aircraft registrations in Danbury, TX.

- [N9266D](https://openairdocs.org/deregistered/N9266D-2023-12-11.md): Piper PA-18A 150 · S/N 18-6564 · Cancelled Dec 11, 2023 · Revoked, canceled · Built 1958 · Truell Jerry C
- [N57SJ](https://openairdocs.org/deregistered/N57SJ-2021-03-24.md): Enstrom F-28A · S/N 278 · Cancelled Mar 24, 2021 · Built 1975 · Salaika Timothy A
- [N1567T](https://openairdocs.org/deregistered/N1567T-2018-06-26.md): Borths Jamie C INFINITY · S/N IPP2-124 · Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2003
- [N8237K](https://openairdocs.org/deregistered/N8237K-2018-01-29.md): Gulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 626-B · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1979 · Garrett Flying Service Inc
- [N50043](https://openairdocs.org/deregistered/N50043-2015-09-15.md): Cessna 150H · S/N 15069034 · Cancelled Sep 15, 2015 · Exported to Mexico · Built 1968 · Davenport Richard B
- [N6778K](https://openairdocs.org/deregistered/N6778K-2013-09-26.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 467B · Cancelled Sep 26, 2013 · Registration expired, pending cancellation · Built 1978 · Garrett Flying Service Inc
- [N4963](https://openairdocs.org/deregistered/N4963-2013-04-25.md): Grumman G-164A · S/N 1098 · Cancelled Apr 25, 2013 · Sale reported, pending cancellation · Built 1973
- [N65529](https://openairdocs.org/deregistered/N65529-2012-10-09.md): Boeing A75L3 · S/N 757962 · Cancelled Oct 9, 2012 · Sale reported, pending cancellation · Built 1943
- [N65868](https://openairdocs.org/deregistered/N65868-1984-07-02.md): Boeing A75N1(PT17) · S/N 75-4331 · Cancelled Jul 2, 1984 · Sale reported · Built 1942
- [N9875](https://openairdocs.org/deregistered/N9875-1983-04-23.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1310 · Cancelled Apr 23, 1983 · Sale reported, pending cancellation · Built 1974
- [N6252Z](https://openairdocs.org/deregistered/N6252Z-1981-12-24.md): Piper PA-25 · S/N 25-311 · Cancelled Dec 24, 1981 · Keillor Flying Service Inc
- [N7985](https://openairdocs.org/deregistered/N7985-1981-12-17.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 849 · Cancelled Dec 17, 1981 · Keilor Flying Service Inc
- [N5328](https://openairdocs.org/deregistered/N5328-1979-10-04.md): Grumman G-164A · S/N 654 · Cancelled Oct 4, 1979 · Keillor Flying Service Inc
- [N4717Q](https://openairdocs.org/deregistered/N4717Q-1977-04-27.md): Cessna A185E · S/N 185-1171 · Cancelled Apr 27, 1977 · Exported to Canada · Garrett J T Jr
- [N7401J](https://openairdocs.org/deregistered/N7401J-1975-09-15.md): Piper PA-28-140 · S/N 28-24764 · Cancelled Sep 15, 1975 · Truell Jerry Chapman
- [N95952](https://openairdocs.org/deregistered/N95952-1954-02-24.md): Taylorcraft BC12-D · S/N 8252 · Cancelled Feb 24, 1954 · Built 1946 · Pelech Eugene L And Walker Charles B

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

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