# Cancelled registrations: The Colony, TX

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

Cancelled aircraft registrations in The Colony, TX.

- [N238SH](https://openairdocs.org/deregistered/N238SH-2023-03-04.md): Prince David L GLASAIR SH-2 · S/N 238 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2007 · Henricks Michael R
- [N141MM](https://openairdocs.org/deregistered/N141MM-2022-06-14.md): Magnino Mark S SONERAI II · S/N 01414L · Cancelled Jun 14, 2022 · Registration expired, pending cancellation · Built 1989 · Magnino Mark S
- [N51YF](https://openairdocs.org/deregistered/N51YF-2021-01-09.md): Faas C Jack LOEHLE 5151 · S/N 679113 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Faas C Jack
- [N751XD](https://openairdocs.org/deregistered/N751XD-2019-10-05.md): Gryphon Dynamics GD-6 · S/N GD6001 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Chopper Shots Imaging LLC
- [N652BM](https://openairdocs.org/deregistered/N652BM-2019-06-29.md): Minicopter JOKER 3 · S/N MJ3001 · Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Chopper Shots Imaging LLC
- [N653HC](https://openairdocs.org/deregistered/N653HC-2019-06-29.md): 3D Robotics SOLO · S/N S111A5601509 · Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Ua Tacsolutions LLC
- [N1917F](https://openairdocs.org/deregistered/N1917F-2018-02-09.md): Fokker D-7 · S/N 1 · Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1967 · Kelly Donald M
- [N2417D](https://openairdocs.org/deregistered/N2417D-2017-02-22.md): Piper PA-38-112 · S/N 38-79A0304 · Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1978 · Lutts Robin R
- [N2311H](https://openairdocs.org/deregistered/N2311H-2014-09-16.md): Balloon Works FIREFLY 7 · S/N 7748 · Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1978 · Foster Fred
- [N7552](https://openairdocs.org/deregistered/N7552-2013-07-23.md): Schweizer SGS 2-33A · S/N 182 · Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1970 · Planes Of History Inc
- [N7611E](https://openairdocs.org/deregistered/N7611E-2013-05-08.md): Bellanca 14-19-3 · S/N 4113 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1959 · Lanning John
- [N6874E](https://openairdocs.org/deregistered/N6874E-2013-05-02.md): Cessna 175A · S/N 56374 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1959 · Murphy William J
- [N6038X](https://openairdocs.org/deregistered/N6038X-2013-04-25.md): Mooney M20A · S/N 1629 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1960 · Phillips David
- [N68TT](https://openairdocs.org/deregistered/N68TT-2012-06-07.md): Thompson Thomas N DRAGONFLY · S/N 896 · Cancelled Jun 7, 2012 · Registration expired, pending cancellation · Thompson Thomas N
- [N234EZ](https://openairdocs.org/deregistered/N234EZ-2008-11-04.md): Langley VARI-EZE · S/N 1521 · Cancelled Nov 4, 2008 · Triennial form not returned · Built 1979 · Norris Robert E
- [N218E](https://openairdocs.org/deregistered/N218E-2008-09-11.md): Eiben Theodore Q-2 · S/N 2735 · Cancelled Sep 11, 2008 · Triennial form not returned · Built 1987 · Magnino Mark S
- [N68TT](https://openairdocs.org/deregistered/N68TT-1992-03-18.md): Brooks Dale C KOSAN #39 · S/N 1 · Cancelled Mar 18, 1992 · Thompson Thomas N
- [N57127](https://openairdocs.org/deregistered/N57127-1991-12-11.md): Raven S55A · S/N S55A670 · Cancelled Dec 11, 1991 · Triennial form not returned · Blue Sky Adventures

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

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