# Cancelled registrations: Hermosa Beach, CA

A list on [Hermosa Beach, CA](https://openairdocs.org/faa-place/CA/Hermosa%20Beach.md).

Cancelled aircraft registrations in Hermosa Beach, CA.

- [N3303T](https://openairdocs.org/deregistered/N3303T-2019-09-06.md): Glasflugel H 301 LIBELLE · S/N 25 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1966 · Mccarthy Francis D
- [N248SB](https://openairdocs.org/deregistered/N248SB-2019-02-02.md): Beech A36 · S/N E-2931 · Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Built 1995 · Altitude Aviation Inc
- [N87160](https://openairdocs.org/deregistered/N87160-2019-01-28.md): Ercoupe 415-C · S/N 333 · Cancelled Jan 28, 2019 · Revoked, canceled · Built 1946 · Enright Gerard R Jr
- [N80677](https://openairdocs.org/deregistered/N80677-2017-02-04.md): Globe GC-1B · S/N 1082 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Reynolds Vernon W Jr
- [N82775](https://openairdocs.org/deregistered/N82775-2017-02-04.md): Couch GLIDER · S/N 1 · Cancelled Feb 4, 2017 · Revoked, canceled · Crouch Robert S
- [N880E](https://openairdocs.org/deregistered/N880E-2015-04-30.md): Beech 65-88 · S/N LP-4 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1965 · Independent Charter
- [N58787](https://openairdocs.org/deregistered/N58787-2014-12-22.md): Fairchild M-62A · S/N T41825 · Cancelled Dec 22, 2014 · Revoked, canceled · Built 1941 · Croshaw William Monroe
- [N9342C](https://openairdocs.org/deregistered/N9342C-2014-11-24.md): Piper PA-28R-201 · S/N 28R-7837192 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1978 · Hutt T Richard
- [N444SR](https://openairdocs.org/deregistered/N444SR-2013-03-11.md): Beech B90 · S/N LJ-416 · Cancelled Mar 11, 2013 · Registration expired, pending cancellation · Built 1968 · Molhook Kirk E
- [N91696](https://openairdocs.org/deregistered/N91696-2012-09-12.md): North American NAVION · S/N NAV-4-438 · Cancelled Sep 12, 2012 · Revoked, canceled · Built 1946 · Purkey Carl D
- [N75828](https://openairdocs.org/deregistered/N75828-2012-09-06.md): Cessna T-50 · S/N 4474 · Cancelled Sep 6, 2012 · Revoked, canceled · Built 1943 · Morris Alfred
- [N67801](https://openairdocs.org/deregistered/N67801-2012-09-05.md): Howard DGA-15P · S/N 899 · Cancelled Sep 5, 2012 · Revoked, canceled · Ward Robert J
- [N39473](https://openairdocs.org/deregistered/N39473-2012-06-12.md): Stinson 10A · S/N 8173 · Cancelled Jun 12, 2012 · Revoked, canceled · Built 1942 · Stroud Charles H Jr
- [N4099K](https://openairdocs.org/deregistered/N4099K-2012-06-04.md): Fly Baby 1-A · S/N 635 · Cancelled Jun 4, 2012 · Revoked, canceled · Built 1964 · Robertson C W Jr
- [N50ML](https://openairdocs.org/deregistered/N50ML-2010-07-08.md): Diamond Aircraft Ind DA20-A1 · S/N 10007 · Cancelled Jul 8, 2010 · Triennial form not returned · Built 1994 · Behar Alberto E
- [N280DA](https://openairdocs.org/deregistered/N280DA-2009-01-13.md): Diamond Aircraft Ind DA20-A1 · S/N 10158 · Cancelled Jan 13, 2009 · Exported to Germany · Built 1996 · Behar Alberto E
- [N7303V](https://openairdocs.org/deregistered/N7303V-1992-03-26.md): Bellanca 17-30 · S/N 30170 · Cancelled Mar 26, 1992 · Triennial form not returned · Barron Donald J
- [N9408F](https://openairdocs.org/deregistered/N9408F-1984-10-02.md): Hughes 269B · S/N 84-0132 · Cancelled Oct 2, 1984 · Exported to New Zealand · Built 1965 · Beckwith John C
- [N5233X](https://openairdocs.org/deregistered/N5233X-1978-03-03.md): Champion 7ECA · S/N 688 · Cancelled Mar 3, 1978 · Anderson Donald Brant
- [N9947L](https://openairdocs.org/deregistered/N9947L-1976-11-23.md): Grumman American Avn. AA-1B · S/N AA1-B0247 · Cancelled Nov 23, 1976 · Penwell Harold
- [N1439C](https://openairdocs.org/deregistered/N1439C-1971-08-11.md): Piper PA-22-135 · S/N 22-1197 · Cancelled Aug 11, 1971 · Mcnally William J
- [N4109K](https://openairdocs.org/deregistered/N4109K-1950-06-27.md): North American NAVION · S/N NAV-4-1109 · Cancelled Jun 27, 1950 · Haas L Ernest

## 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 = 'CA' AND d.registrant_city = 'HERMOSA BEACH'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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