# Cancelled registrations: Huntsville, TX

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

Cancelled aircraft registrations in Huntsville, TX.

- [N10PH](https://openairdocs.org/deregistered/N10PH-2018-03-09.md): Cessna 170B · S/N 26718 · Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1955 · Douglas Oscar A
- [N1567W](https://openairdocs.org/deregistered/N1567W-2018-01-02.md): Beech E-55 · S/N TE-862 · Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1972 · Webb Dustin L
- [N21RN](https://openairdocs.org/deregistered/N21RN-2017-10-28.md): Nutt GYROCOPTER 1-A · S/N 10457691 · Cancelled Oct 28, 2017 · Revoked, canceled · Built 1975 · Nutt Raymond E Jr
- [N68465](https://openairdocs.org/deregistered/N68465-2013-08-20.md): Cessna 152 · S/N 15282305 · Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1978
- [N49652](https://openairdocs.org/deregistered/N49652-2013-05-10.md): Cessna 152 · S/N 15283489 · Cancelled May 10, 2013 · Sale reported, canceled · Built 1979
- [N68733](https://openairdocs.org/deregistered/N68733-2013-05-02.md): Cessna 152 · S/N 15282343 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1978 · Lasalle John DBA
- [N35DW](https://openairdocs.org/deregistered/N35DW-2013-03-11.md): Williams Donald P PITTS SPECIAL S-1S · S/N 22130DW · Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Williams Donald P
- [N21061](https://openairdocs.org/deregistered/N21061-2012-08-23.md): Ozga John CHALLENGER II · S/N CH211941255 · Cancelled Aug 23, 2012 · Registration expired, pending cancellation · Built 1995 · Padgett Troy A
- [N1511J](https://openairdocs.org/deregistered/N1511J-2012-08-06.md): Piper PA-28-140 · S/N 28-23904 · Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1967 · Yawn Billy R
- [N97169](https://openairdocs.org/deregistered/N97169-2011-05-03.md): Stinson 108 · S/N 108-169 · Cancelled May 3, 2011 · Second triennial mailing, no response · Built 1946 · Waterman David K
- [N1047U](https://openairdocs.org/deregistered/N1047U-1992-03-04.md): Piper PA-34-200 · S/N 347250031 · Cancelled Mar 4, 1992 · Triennial form not returned · Gillaspie Wade Jr
- [N21373](https://openairdocs.org/deregistered/N21373-1975-09-17.md): Cessna 182P · S/N 18261593 · Cancelled Sep 17, 1975 · Built 1972 · Shipman William L/DBA Huntsville Aviation
- [N1384A](https://openairdocs.org/deregistered/N1384A-1971-12-01.md): Beech 70 · S/N LB-18 · Cancelled Dec 1, 1971 · Texas Department Of Corrections
- [N32166](https://openairdocs.org/deregistered/N32166-1971-08-18.md): Waco UPF-7 · S/N 5798 · Cancelled Aug 18, 1971 · Built 1942 · Maddux Thomas J
- [N6078G](https://openairdocs.org/deregistered/N6078G-1971-06-23.md): Cessna 150K · S/N 15071578 · Cancelled Jun 23, 1971 · Exported to Mexico · Huntsville Aviation Inc
- [N5545A](https://openairdocs.org/deregistered/N5545A-1968-06-12.md): Cessna 170 · S/N 19657 · Cancelled Jun 12, 1968 · Hampton Isaac P Jr
- [N47858](https://openairdocs.org/deregistered/N47858-1955-11-18.md): Taylorcraft DCO-65 · S/N L-6282 · Cancelled Nov 18, 1955 · Kirk Joe E
- [N3433K](https://openairdocs.org/deregistered/N3433K-1951-07-23.md): Piper J3C-65 · S/N 22124 · Cancelled Jul 23, 1951 · Kirk Joe E

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

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