# Cancelled registrations: Bellaire, TX

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

Cancelled aircraft registrations in Bellaire, TX.

- [N5GZ](https://openairdocs.org/deregistered/N5GZ-2022-02-05.md): Cessna P337H · S/N P3370319 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · World Transport Coordination Svcs Inc
- [N1473T](https://openairdocs.org/deregistered/N1473T-2021-10-30.md): Piper PA-28R-200 · S/N 28R-7235300 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1972 · Aether Aviation LLC
- [N101JY](https://openairdocs.org/deregistered/N101JY-2018-02-27.md): White Carl A CHAMPION SPORTSTER · S/N 101 · Cancelled Feb 27, 2018 · Registration expired, pending cancellation · White Carl A
- [N99444](https://openairdocs.org/deregistered/N99444-2014-12-01.md): Engineering & Research ERCOUPE 415-C · S/N 2067 · Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1946 · Villavecchia Arthur R
- [N756DE](https://openairdocs.org/deregistered/N756DE-2014-11-18.md): Cessna U206G · S/N U20604001 · Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Roy W Bell Dds Inc
- [N2368L](https://openairdocs.org/deregistered/N2368L-2013-08-05.md): Beech 23 · S/N M-209 · Cancelled Aug 5, 2013 · Sale reported, canceled · Built 1963
- [N4587R](https://openairdocs.org/deregistered/N4587R-2012-12-07.md): Piper PA-28-140 · S/N 28-21332 · Cancelled Dec 7, 2012 · Registration expired, pending cancellation · Built 1965 · Eason Michael A
- [N3065L](https://openairdocs.org/deregistered/N3065L-2012-11-06.md): Cessna 310J · S/N 310J0065 · Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1965 · Fore Way Avn Inc
- [N1620D](https://openairdocs.org/deregistered/N1620D-1976-05-13.md): Cessna 170A · S/N 20262 · Cancelled May 13, 1976 · Tinsley Stanley D &/Or James D Burnette
- [N3127Q](https://openairdocs.org/deregistered/N3127Q-1973-06-21.md): Cessna 182K · S/N 18258127 · Cancelled Jun 21, 1973 · Built 1967 · Lucas Donald C / Craven Charles M
- [N61902](https://openairdocs.org/deregistered/N61902-1970-12-08.md): Consolidated Vultee BT-13 · S/N 7206 · Cancelled Dec 8, 1970 · Anderson Greenwood & Co
- [N55601](https://openairdocs.org/deregistered/N55601-1965-01-11.md): Consolidated Vultee BT-13A · S/N 6864 · Cancelled Jan 11, 1965 · Dashiell David A
- [N60E](https://openairdocs.org/deregistered/N60E-1957-11-05.md): Howard DGA-15P · S/N 502 · Cancelled Nov 5, 1957 · Harper Joe S
- [N78022](https://openairdocs.org/deregistered/N78022-1955-11-23.md): Globe GC-1B · S/N 2022 · Cancelled Nov 23, 1955 · Built 1946 · Garner Ray
- [N2836V](https://openairdocs.org/deregistered/N2836V-1953-02-25.md): Beech 35 · S/N D-241 · Cancelled Feb 25, 1953 · Exported to Canada · Hurley Harvey L
- [N335](https://openairdocs.org/deregistered/N335-1931-04-24.md): Standard J-1 · S/N 0305 · Cancelled Apr 24, 1931 · Built 1918 · Monson Gertin A

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

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