# Cancelled registrations: La Porte, TX

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

Cancelled aircraft registrations in La Porte, TX.

- [N2839W](https://openairdocs.org/deregistered/N2839W-2023-10-11.md): Beech 95-B55 (T42A) · S/N TC-1571 · Cancelled Oct 11, 2023 · Built 1973 · Lisa Beach Inc
- [N7716C](https://openairdocs.org/deregistered/N7716C-2020-10-03.md): Piper PA-28R-200 · S/N 28R-7635114 · Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Ascent Aviation LLC
- [N33665](https://openairdocs.org/deregistered/N33665-2020-08-02.md): Piper PA-28-151 · S/N 28-7515352 · Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1975 · Mobley Kirk W
- [N184AG](https://openairdocs.org/deregistered/N184AG-2019-09-06.md): Aetos Group D130 X8 · S/N AG001 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Aetos Group Inc
- [N1021Y](https://openairdocs.org/deregistered/N1021Y-2019-07-18.md): Hiller-Mitchell UH-12B · S/N MH 353 · Cancelled Jul 18, 2019 · Registration expired, pending cancellation · Built 1981 · King Mike D
- [N186AG](https://openairdocs.org/deregistered/N186AG-2019-05-04.md): Sensefly EXOM · S/N EX-01-29308 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Aetos Group Inc
- [N28937](https://openairdocs.org/deregistered/N28937-2018-08-09.md): Engineering & Research ERCOUPE 415-C · S/N 32 · Cancelled Aug 9, 2018 · Revoked, canceled · Built 1941 · Clemmons B J
- [N130AG](https://openairdocs.org/deregistered/N130AG-2018-06-08.md): Aeryon Labs SCOUT · S/N SN000018 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Aetos Group Inc
- [N9508X](https://openairdocs.org/deregistered/N9508X-2018-03-01.md): Cessna 210A · S/N 21057808 · Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1961 · Pellican Flying Club
- [N3398M](https://openairdocs.org/deregistered/N3398M-2018-01-04.md): Piper PA-28R-201 · S/N 28R-7837113 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1977 · De Aviation Inc
- [N35807](https://openairdocs.org/deregistered/N35807-2017-11-18.md): Piper J3L-65 · S/N 6599 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1941 · Trigg Neal C
- [N132AG](https://openairdocs.org/deregistered/N132AG-2017-05-09.md): Aeryon Labs SKY RANGER · S/N SR 9024867 · Cancelled May 9, 2017 · Aetos Group Inc
- [N183AG](https://openairdocs.org/deregistered/N183AG-2017-05-09.md): Aeryon Labs SKY RANGER · S/N SR 6022853 · Cancelled May 9, 2017 · Aetos Group Inc
- [N131AG](https://openairdocs.org/deregistered/N131AG-2017-05-08.md): Aeryon Labs SKY RANGER · S/N SR7010640 · Cancelled May 8, 2017 · Aetos Group Inc
- [N92278](https://openairdocs.org/deregistered/N92278-2017-01-24.md): Piper J3C-65 · S/N 16739 · Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1946 · Turbeville John R
- [N37499](https://openairdocs.org/deregistered/N37499-2014-12-02.md): Balloon Works FIREFLY 6B · S/N F6B-007 · Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Essmeir Scott C
- [N681C](https://openairdocs.org/deregistered/N681C-2013-10-23.md): Beech C18S · S/N 44-47538 · Cancelled Oct 23, 2013 · Revoked, canceled · Turbeville John R
- [N101GC](https://openairdocs.org/deregistered/N101GC-2011-06-16.md): Cessna 321 · S/N 37004 · Cancelled Jun 16, 2011 · Revoked, canceled · Built 1955 · Wb Flying Club
- [N3236H](https://openairdocs.org/deregistered/N3236H-2010-02-09.md): Ercoupe 415-C · S/N 3861 · Cancelled Feb 9, 2010 · Triennial form not returned · Built 1946 · Sport Wings Enterprises LLC
- [N2222K](https://openairdocs.org/deregistered/N2222K-2009-07-14.md): Piper PA-23-150 · S/N 23-150 · Cancelled Jul 14, 2009 · Registration revoked · Built 1955 · Apache Aviation Inc
- [N19705](https://openairdocs.org/deregistered/N19705-2009-07-09.md): Aeronca K · S/N K222 · Cancelled Jul 9, 2009 · Registration revoked · Built 1937 · Burmaster Keith
- [N3643H](https://openairdocs.org/deregistered/N3643H-2007-03-15.md): Engineering & Research 415-D · S/N 4268 · Cancelled Mar 15, 2007 · Built 1946 · Sport Wings Enterprises LLC
- [N992RS](https://openairdocs.org/deregistered/N992RS-2006-06-12.md): American Champion 8KCAB · S/N 685-92 · Cancelled Jun 12, 2006 · Triennial form not returned · Built 1992 · De Aviation Inc
- [N8058C](https://openairdocs.org/deregistered/N8058C-2001-03-05.md): Packer John D CHALLENGER II · S/N PACK1-CH2 · Cancelled Mar 5, 2001 · Triennial form not returned · Packer John D
- [N2977A](https://openairdocs.org/deregistered/N2977A-1995-01-30.md): Bellanca 8KCAB · S/N 63180 · Cancelled Jan 30, 1995 · Triennial form not returned · Harvey Eoin S
- [N4600P](https://openairdocs.org/deregistered/N4600P-1994-01-10.md): Cessna 152 · S/N 15284777 · Cancelled Jan 10, 1994 · Exported to India · Cliff Hyde Flying Service Inc
- [N6235M](https://openairdocs.org/deregistered/N6235M-1994-01-10.md): Cessna 152 · S/N 15284641 · Cancelled Jan 10, 1994 · Exported to India · Cliff Hyde Flying Service Inc
- [N777BN](https://openairdocs.org/deregistered/N777BN-1985-02-04.md): Nash Bill H NASH RAMBLER · S/N 102 · Cancelled Feb 4, 1985 · Nash Bill H
- [N2945T](https://openairdocs.org/deregistered/N2945T-1972-08-17.md): Aero Commander 100 · S/N 061 · Cancelled Aug 17, 1972 · Stephens Robert
- [N7162M](https://openairdocs.org/deregistered/N7162M-1967-11-16.md): Cessna 175 · S/N 55462 · Cancelled Nov 16, 1967 · Bayshore Flying Association
- [N43667](https://openairdocs.org/deregistered/N43667-1956-03-07.md): Taylorcraft BC12-D · S/N 7326 · Cancelled Mar 7, 1956 · W L Brown
- [N5394H](https://openairdocs.org/deregistered/N5394H-1951-07-30.md): Piper PA-16 · S/N 16-200 · Cancelled Jul 30, 1951 · Hou Port Aviation 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 = 'LA PORTE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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