# Cancelled registrations: Lamesa, TX

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

Cancelled aircraft registrations in Lamesa, TX.

- [N59239](https://openairdocs.org/deregistered/N59239-2020-01-10.md): Fairchild M-62A · S/N T435543 · Cancelled Jan 10, 2020 · Revoked, canceled · Built 1943 · Burnett B J
- [N75763](https://openairdocs.org/deregistered/N75763-2020-01-06.md): Destiny XLT · S/N 4L0584 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Built 2003 · Parker Rob
- [N7736W](https://openairdocs.org/deregistered/N7736W-2019-03-02.md): Piper PA-28-180 · S/N 28-1744 · Cancelled Mar 2, 2019 · Built 1964 · Don Lybrand Flying Service Inc
- [N461RL](https://openairdocs.org/deregistered/N461RL-2018-08-20.md): Piper PA-34-200T · S/N 34-8170001 · Cancelled Aug 20, 2018 · First renewal notice · Claiborne Aviation LLC
- [N387AC](https://openairdocs.org/deregistered/N387AC-2018-02-13.md): Robinson Helicopter R22 BETA · S/N 1631 · Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1990 · Chiles Don L
- [N1013W](https://openairdocs.org/deregistered/N1013W-2013-08-28.md): Shackelford Marvin G T-BIRD II · S/N 818 · Cancelled Aug 28, 2013 · Sale reported, canceled
- [N9751V](https://openairdocs.org/deregistered/N9751V-2013-05-30.md): Cessna A188 · S/N 188-0201 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1966 · C And S Flying Svc Inc
- [N91905](https://openairdocs.org/deregistered/N91905-2012-10-11.md): Air Tractor AT-502 · S/N 502-0226 · Cancelled Oct 11, 2012 · Registration pending, pending cancellation · Built 1993
- [N87837](https://openairdocs.org/deregistered/N87837-2012-09-10.md): Piper J3C-65 · S/N 15268 · Cancelled Sep 10, 2012 · Revoked, canceled · Built 1945 · Hogg F O
- [N36599](https://openairdocs.org/deregistered/N36599-2009-04-27.md): Air Tractor AT-301 · S/N 301-0332 · Cancelled Apr 27, 2009 · Exported to Mexico · Built 1981 · Hogg Flying Service Inc
- [N7521Z](https://openairdocs.org/deregistered/N7521Z-1998-02-20.md): Piper PA-25-235 · S/N 253561 · Cancelled Feb 20, 1998 · Triennial form not returned · Hogg Glenn W
- [N94137](https://openairdocs.org/deregistered/N94137-1995-05-21.md): Engineering & Research 415-C · S/N 1460 · Cancelled May 21, 1995 · Williams Burnie L II
- [N61564](https://openairdocs.org/deregistered/N61564-1994-05-24.md): Cessna 172M · S/N 17264642 · Cancelled May 24, 1994 · Second triennial mailing, no response · Dopson Ben M
- [N7083Z](https://openairdocs.org/deregistered/N7083Z-1974-12-04.md): Piper PA-25-235 · S/N 25-2867 · Cancelled Dec 4, 1974 · Exported to Mexico · Hawkins Bob
- [N6728Z](https://openairdocs.org/deregistered/N6728Z-1967-10-02.md): Piper PA-25-235 · S/N 25-2344 · Cancelled Oct 2, 1967 · Exported to Chile · Spires Inc
- [N6729Z](https://openairdocs.org/deregistered/N6729Z-1967-10-02.md): Piper PA-25-235 · S/N 25-2345 · Cancelled Oct 2, 1967 · Exported to Chile · Spires Inc
- [N9275D](https://openairdocs.org/deregistered/N9275D-1965-05-26.md): Piper PA-18A 150 · S/N 18-6578 · Cancelled May 26, 1965 · Bob E Hawkins
- [N71839](https://openairdocs.org/deregistered/N71839-1965-05-21.md): Luscombe 8A · S/N 3266 · Cancelled May 21, 1965 · Wilson Hayford Leon & Edward Dunn
- [N9949D](https://openairdocs.org/deregistered/N9949D-1960-06-15.md): Piper PA-18A 150 · S/N 18-7005 · Cancelled Jun 15, 1960 · Chapman And Spires Inc
- [N2649H](https://openairdocs.org/deregistered/N2649H-1955-11-15.md): Ercoupe 415-C · S/N 3274 · Cancelled Nov 15, 1955 · Built 1946 · Nance O H
- [N1030D](https://openairdocs.org/deregistered/N1030D-1955-10-05.md): Cessna 190 · S/N 7715 · Cancelled Oct 5, 1955 · Tinsley Ed R Jr
- [N3644H](https://openairdocs.org/deregistered/N3644H-1953-08-17.md): Ercoupe 415-C · S/N 4269 · Cancelled Aug 17, 1953 · Exported to Mexico · Barrow Carl
- [N1602E](https://openairdocs.org/deregistered/N1602E-1951-03-12.md): Aeronca 7AC · S/N 7AC-5167 · Cancelled Mar 12, 1951 · Built 1946 · Hogg F O Jr
- [N53896](https://openairdocs.org/deregistered/N53896-1949-02-28.md): Fairchild M-62A · S/N T42-3744 · Cancelled Feb 28, 1949 · Hogg Farrell F

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

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