# Cancelled registrations: Rosharon, TX

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

Cancelled aircraft registrations in Rosharon, TX.

- [N1241B](https://openairdocs.org/deregistered/N1241B-2022-04-02.md): Luscombe 8A · S/N 5869 · Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 1947 · Arnold Craig
- [N3966B](https://openairdocs.org/deregistered/N3966B-2019-09-05.md): Boeing E75 · S/N 756002 · Cancelled Sep 5, 2019 · Revoked, canceled · Mccauley W M
- [N2716Y](https://openairdocs.org/deregistered/N2716Y-2018-07-12.md): Beech 95 · S/N TD-43 · Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1958 · Dutch Wings LLC
- [N8329D](https://openairdocs.org/deregistered/N8329D-2018-02-20.md): Beech J35 · S/N D-5407 · Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1957 · Dickey Winton B
- [N17515](https://openairdocs.org/deregistered/N17515-2018-02-07.md): Schmidt COOT-A · S/N WS-01 · Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 1976 · Thompson Clark J
- [N665JR](https://openairdocs.org/deregistered/N665JR-2018-01-08.md): Bellanca 17-30A · S/N 73-30555 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Built 1973 · Entrust Retirement Services Inc
- [N224BJ](https://openairdocs.org/deregistered/N224BJ-2017-06-14.md): Nickoloff James A GLASAIR TAIL DRAGGER · S/N 552 · Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1993 · Arnold Craig
- [N52770](https://openairdocs.org/deregistered/N52770-2017-02-04.md): Boeing A75N1 · S/N 75879 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1941 · Mccauley W M
- [N713CP](https://openairdocs.org/deregistered/N713CP-2015-05-05.md): Quicksilver GT500 · S/N 0144 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Segal Howard S
- [N899DB](https://openairdocs.org/deregistered/N899DB-2013-11-04.md): Bliss Warren D PIETENPOL AIRCAMPER · S/N 0066 · Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Bliss Warren D
- [N66483](https://openairdocs.org/deregistered/N66483-2013-09-25.md): Boeing E75 · S/N 758443 · Cancelled Sep 25, 2013 · Revoked, canceled · Built 1943 · Mccauley W M
- [N352A](https://openairdocs.org/deregistered/N352A-2013-08-23.md): Mooney M-18L · S/N 13 · Cancelled Aug 23, 2013 · Sale reported, canceled · Built 1949
- [N2016T](https://openairdocs.org/deregistered/N2016T-2013-04-29.md): Broerman Charles D BENSEN · S/N 503CB · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Broerman Charles D
- [N4012P](https://openairdocs.org/deregistered/N4012P-2012-11-15.md): Ayres S2R-600 · S/N 2540R · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Built 1979 · Alford Flying Service Inc
- [N36343](https://openairdocs.org/deregistered/N36343-2010-03-10.md): Piper PA-34-200T · S/N 34-7870320 · Cancelled Mar 10, 2010 · Exported to Venezuela · Built 1978
- [N211DD](https://openairdocs.org/deregistered/N211DD-2006-06-22.md): Mcmillin Derrall THORP T211 SPORT E · S/N 011R · Cancelled Jun 22, 2006 · Mcmillin Derrall E
- [N811GA](https://openairdocs.org/deregistered/N811GA-2006-06-20.md): Beech C90 · S/N LJ-810 · Cancelled Jun 20, 2006 · Exported to Venezuela · Built 1979 · Sandoval Ivette M
- [N2KY](https://openairdocs.org/deregistered/N2KY-1991-06-14.md): Partenavia P.68C · S/N 262 · Cancelled Jun 14, 1991 · Exported to Antigua and Barbuda · Classic Aviation International 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 = 'ROSHARON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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