# Cancelled registrations: Rhome, TX

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

Cancelled aircraft registrations in Rhome, TX.

- [N50PB](https://openairdocs.org/deregistered/N50PB-2022-01-08.md): Piper PA-23-250 · S/N 27-2328 · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1963 · Palmenteri Louis J
- [N513RC](https://openairdocs.org/deregistered/N513RC-2021-09-04.md): Clement Robert D CH600 ZODIAC · S/N 6-1120-513 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Boatman Jackie Allen
- [N14842](https://openairdocs.org/deregistered/N14842-2020-12-05.md): Rose PARRAKEET A-1 · S/N 102 · Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1936 · Pellegreno Dominick D
- [N2893Q](https://openairdocs.org/deregistered/N2893Q-2019-10-05.md): Cessna 172L · S/N 17259893 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1971 · Moore Curtis S
- [N5872B](https://openairdocs.org/deregistered/N5872B-2019-06-06.md): Cessna 182A · S/N 33872 · Cancelled Jun 6, 2019 · Registration expired, pending cancellation · Built 1956 · Moore C S
- [N5299Y](https://openairdocs.org/deregistered/N5299Y-2017-10-31.md): Piper PA-23-250 · S/N 272371 · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Palmenteri Louis J
- [N99791](https://openairdocs.org/deregistered/N99791-2017-07-20.md): Ercoupe 415-C · S/N 2414 · Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1946 · Lindsey Robert C
- [N893TX](https://openairdocs.org/deregistered/N893TX-2017-07-14.md): Aero Vodochody L-29C DELFIN · S/N 893142 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Rogers John D Trustee
- [N2562G](https://openairdocs.org/deregistered/N2562G-2017-03-10.md): Champion 7ECA · S/N 442 · Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1967 · Eppard Jack L
- [N3214V](https://openairdocs.org/deregistered/N3214V-2014-11-21.md): Balloon Works FIREFLY 7-15 · S/N F7-912 · Cancelled Nov 21, 2014 · Registration expired, pending cancellation · Built 1997 · Roybal James
- [N79152](https://openairdocs.org/deregistered/N79152-2014-08-18.md): Cessna 152 · S/N 15282425 · Cancelled Aug 18, 2014 · Exported to Sri Lanka · Built 1978 · Miller Brian A
- [N4436Y](https://openairdocs.org/deregistered/N4436Y-2013-08-08.md): Langa G A/Menmuir J QD CTY AC CHLNGR II · S/N CHII-02981722 · Cancelled Aug 8, 2013 · Sale reported, canceled · Built 1989
- [N5456F](https://openairdocs.org/deregistered/N5456F-2013-04-19.md): Alon A-2A · S/N B-256 · Cancelled Apr 19, 2013 · Registration expired, pending cancellation · Built 1967 · Moore Frantz F Jr
- [N92987](https://openairdocs.org/deregistered/N92987-2008-10-07.md): Commonwealth 185 · S/N 1721 · Cancelled Oct 7, 2008 · Exported to Canada · Built 1946 · Bauer Joachim
- [N91594](https://openairdocs.org/deregistered/N91594-2004-09-30.md): Piper PA-38-112 · S/N 38-82A0083 · Cancelled Sep 30, 2004 · Built 1981 · Herring Lewis
- [N298SH](https://openairdocs.org/deregistered/N298SH-2001-01-11.md): Schweizer 269C · S/N S1761 · Cancelled Jan 11, 2001 · Skylane Helicopters LLC
- [N5496F](https://openairdocs.org/deregistered/N5496F-1999-10-28.md): Mooney A-2A · S/N B-296 · Cancelled Oct 28, 1999 · Triennial form not returned · Moore Frantz E Jr

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

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