# Cancelled registrations: Pharr, TX

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

Cancelled aircraft registrations in Pharr, TX.

- [N915JH](https://openairdocs.org/deregistered/N915JH-2024-02-10.md): Cessna T210N · S/N 21064145 · Cancelled Feb 10, 2024 · Sale reported, canceled · Built 1980
- [N577RR](https://openairdocs.org/deregistered/N577RR-2021-10-02.md): Beech B-60 · S/N P-464 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1978 · Tr Valley Aviation LLC
- [N611AY](https://openairdocs.org/deregistered/N611AY-2019-11-19.md): Beech C90 · S/N LJ-601 · Cancelled Nov 19, 2019 · Expired dealer · Built 1973 · Tr Valley Aviation LLC
- [N48GR](https://openairdocs.org/deregistered/N48GR-2017-07-14.md): Learjet 25 · S/N 048 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1970 · G & R Machinery Sales LLC
- [N345FW](https://openairdocs.org/deregistered/N345FW-2017-06-19.md): Williams Roy P SPORT BIRD · S/N 110 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Williams Roy P
- [N94EH](https://openairdocs.org/deregistered/N94EH-2017-05-23.md): Cessna T210L · S/N T21059782 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1972 · Gonzalez Manuel
- [N8723M](https://openairdocs.org/deregistered/N8723M-2017-02-22.md): Beech 23 · S/N M-512 · Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1963 · Noggle John W G
- [N380JT](https://openairdocs.org/deregistered/N380JT-2015-05-19.md): British Aerospace BAE JETSTREAM 3101 · S/N 743 · Cancelled May 19, 2015 · Sale reported, canceled
- [N145](https://openairdocs.org/deregistered/N145-2014-09-05.md): Meyers MAC-145 · S/N 208 · Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1954 · Shawn Service Inc
- [N3832S](https://openairdocs.org/deregistered/N3832S-2013-06-11.md): Vickers Armstrong VISCOUNT 757 · S/N 144 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Grupo Madero S A Inc
- [N1931Y](https://openairdocs.org/deregistered/N1931Y-2013-04-16.md): Lapham Charles Gregory GA1 · S/N GA001 · Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Lapham Charles G
- [N538PA](https://openairdocs.org/deregistered/N538PA-2012-11-02.md): British Aerospace BAE JETSTREAM 3101 · S/N 751 · Cancelled Nov 2, 2012 · Exported to Mexico · Built 1987 · Vale Air USA
- [N1903E](https://openairdocs.org/deregistered/N1903E-2010-12-09.md): Cessna TP206A · S/N P206-0292 · Cancelled Dec 9, 2010 · Registration pending, pending cancellation · Built 1966
- [N159E](https://openairdocs.org/deregistered/N159E-2009-07-20.md): Fairchild 24 C8 · S/N 2698 · Cancelled Jul 20, 2009 · Registration revoked · Built 1935 · Thompson Paul E
- [N9559P](https://openairdocs.org/deregistered/N9559P-2009-07-15.md): Piper PA-25-235 · S/N 25-7405711 · Cancelled Jul 15, 2009 · Registration revoked · Built 1974 · Valley Ag Air Inc
- [N9268F](https://openairdocs.org/deregistered/N9268F-2001-11-01.md): Carpenter Allan R LOCKWOOD AIR CAM · S/N AC004 · Cancelled Nov 1, 2001 · Exported to Mexico · Built 1998 · Pina Ismael A
- [N6025S](https://openairdocs.org/deregistered/N6025S-1996-01-27.md): Beech B-60 · S/N P325 · Cancelled Jan 27, 1996 · Triennial form not returned · Cebolla Inc
- [N4741Y](https://openairdocs.org/deregistered/N4741Y-1982-09-24.md): Piper PA-25-260 · S/N 254491 · Cancelled Sep 24, 1982 · Exported to Mexico · Valley Ag Air Inc
- [N64963](https://openairdocs.org/deregistered/N64963-1981-06-16.md): Cessna 152 · S/N 15281501 · Cancelled Jun 16, 1981 · Exported to Mexico · Norris Edward F
- [N4819V](https://openairdocs.org/deregistered/N4819V-1977-03-07.md): Bellanca 17-30 · S/N 30091 · Cancelled Mar 7, 1977 · Neumann Don W
- [N47809](https://openairdocs.org/deregistered/N47809-1970-09-23.md): Aeronca 0-58B · S/N 058B8633 · Cancelled Sep 23, 1970 · Amando R Ramos
- [N75865](https://openairdocs.org/deregistered/N75865-1965-06-02.md): Boeing E75 · S/N 75-5988 · Cancelled Jun 2, 1965 · Mid-Valley Dusters Inc
- [N1770B](https://openairdocs.org/deregistered/N1770B-1962-07-27.md): Boeing A75 · S/N 75-5532 · Cancelled Jul 27, 1962 · Built 1955 · Leclair Jack J
- [N47653](https://openairdocs.org/deregistered/N47653-1951-12-27.md): Taylorcraft DCO-65 · S/N L-5990 · Cancelled Dec 27, 1951 · Built 1943 · Walton Ray
- [N54360](https://openairdocs.org/deregistered/N54360-1950-11-22.md): Fairchild M-62A · S/N T42-1797 · Cancelled Nov 22, 1950 · Baden Bernice

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

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