# Cancelled registrations: Webster, TX

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

Cancelled aircraft registrations in Webster, TX.

- [N421PU](https://openairdocs.org/deregistered/N421PU-2022-09-03.md): DJI PHANTOM 3 ADVANCED · S/N CF221828156572 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Sugita Yoshino S
- [N510JU](https://openairdocs.org/deregistered/N510JU-2021-07-31.md): DJI PHANTOM 2 VISION + · S/N PH645494421 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Sugita Yoshino S
- [N9235A](https://openairdocs.org/deregistered/N9235A-2021-01-11.md): Piper PA-38-112 · S/N 38-82A0112 · Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1982 · King Karen
- [N446S](https://openairdocs.org/deregistered/N446S-2021-01-09.md): Cessna 172N · S/N 17272332 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1979 · King Mike
- [N9532B](https://openairdocs.org/deregistered/N9532B-2019-11-04.md): Cameron Balloons US C-100 · S/N 6176 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1998 · Critelli Brian
- [N408DS](https://openairdocs.org/deregistered/N408DS-2019-03-09.md): Piper PA-38-112 · S/N 38-79A0574 · Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1979 · King Mike
- [N55093](https://openairdocs.org/deregistered/N55093-2018-03-06.md): Piper PA-28-140 · S/N 28-7325321 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1973 · Bedford Jason
- [N2493D](https://openairdocs.org/deregistered/N2493D-2018-03-01.md): Piper PA-38-112 · S/N 38-79A0332 · Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1978 · King Mike
- [N74717](https://openairdocs.org/deregistered/N74717-2017-09-26.md): Mooney M20B · S/N 1717 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1961 · Menon Anil S
- [N4006W](https://openairdocs.org/deregistered/N4006W-2017-02-22.md): Piper PA-32-300 · S/N 32-40006 · Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1966 · Beasley Inza H
- [N6389S](https://openairdocs.org/deregistered/N6389S-2014-06-30.md): Cessna 150G · S/N 15067189 · Cancelled Jun 30, 2014 · Registration expired · Built 1967 · Shackelford Linda C
- [N4428A](https://openairdocs.org/deregistered/N4428A-2013-08-14.md): Piper PA-22-150 · S/N 22-3757 · Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1956 · Ward Robert E
- [N4030P](https://openairdocs.org/deregistered/N4030P-2012-06-07.md): Piper PA-23-160 · S/N 23-1505 · Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1958
- [N68440](https://openairdocs.org/deregistered/N68440-2012-04-04.md): Cessna 152 · S/N 15282297 · Cancelled Apr 4, 2012 · Registration pending, pending cancellation · Built 1978
- [N11734](https://openairdocs.org/deregistered/N11734-2003-07-03.md): Cessna 150L · S/N 15075599 · Cancelled Jul 3, 2003 · Second triennial mailing, no response · Built 1974 · Aero Club Inc
- [N4061L](https://openairdocs.org/deregistered/N4061L-1999-06-08.md): Balloon Works FIREFLY 7 · S/N 7986 · Cancelled Jun 8, 1999 · Critelli Brian
- [N1506S](https://openairdocs.org/deregistered/N1506S-1997-09-11.md): Balloon Works FIREFLY 7 · S/N 11169 · Cancelled Sep 11, 1997 · Critelli Brian
- [N711SC](https://openairdocs.org/deregistered/N711SC-1995-02-09.md): Gates Learjet 25D · S/N 345 · Cancelled Feb 9, 1995 · Exported to Argentina · Statewide Capital Inc

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

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