# Cancelled registrations: Solana Beach, CA

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

Cancelled aircraft registrations in Solana Beach, CA.

- [N787WM](https://openairdocs.org/deregistered/N787WM-2021-07-03.md): Causey James E ACRODUSTER II · S/N SA750-083176JC · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1993 · Maltzman Avi
- [N37GR](https://openairdocs.org/deregistered/N37GR-2020-05-19.md): Bell 412EP · S/N 36209 · Cancelled May 19, 2020 · Tcfi Al4 LLC
- [N3162Z](https://openairdocs.org/deregistered/N3162Z-2019-11-04.md): Balloon Works FIREFLY 8B-15 · S/N F8B-559 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1998 · Amazing Adventures Inc
- [N860JN](https://openairdocs.org/deregistered/N860JN-2018-01-26.md): Ninomiya John CELEBRATION B · S/N 1001 · Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Ninomiya John K
- [N7EG](https://openairdocs.org/deregistered/N7EG-2017-06-14.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S-604 · Cancelled Jun 14, 2017 · Built 1982 · Perell John R
- [N116TG](https://openairdocs.org/deregistered/N116TG-2015-05-05.md): Gildred Theodore E SONEX · S/N 086 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Gildred Theodore E
- [N180L](https://openairdocs.org/deregistered/N180L-2013-08-06.md): Beech B35 · S/N D-2623 · Cancelled Aug 6, 2013 · Registration expired, pending cancellation · Built 1950 · Clark Brian Edward
- [N8026Z](https://openairdocs.org/deregistered/N8026Z-2013-05-13.md): Caldwell James M AX-7 · S/N 1-3 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1979 · Caldwell James M
- [N9110S](https://openairdocs.org/deregistered/N9110S-2013-04-25.md): Beech 95-B55 (T42A) · S/N TC-1937 · Cancelled Apr 25, 2013 · Exported to Brazil · Hunter Gregory R
- [N1240R](https://openairdocs.org/deregistered/N1240R-2013-01-30.md): Raven S55A · S/N S55A-368 · Cancelled Jan 30, 2013 · Registration expired, pending cancellation · Built 1978 · Simpson Phillip C
- [N970AS](https://openairdocs.org/deregistered/N970AS-2010-08-19.md): Dehavilland DHC-6-300 · S/N 838 · Cancelled Aug 19, 2010 · Exported to Canada · Built 1988 · Weeks Chandler G Trustee
- [N3329C](https://openairdocs.org/deregistered/N3329C-2010-02-09.md): Beech F35 · S/N D-4322 · Cancelled Feb 9, 2010 · Triennial form not returned · Built 1955 · Madsen Dakota R
- [N904DD](https://openairdocs.org/deregistered/N904DD-2006-11-01.md): Bell OH-58A · S/N 71-20493 · Cancelled Nov 1, 2006 · Exported to Canada · Built 1989 · Del Mar Citation LLC
- [N7962D](https://openairdocs.org/deregistered/N7962D-1995-12-15.md): Beech H35 · S/N D5221 · Cancelled Dec 15, 1995 · Triennial form not returned · Strange Robert D
- [N3850C](https://openairdocs.org/deregistered/N3850C-1995-09-28.md): Aero Commander 500 · S/N 703 · Cancelled Sep 28, 1995 · Exported to Brazil · Rolf Bote Incorporated
- [N3849N](https://openairdocs.org/deregistered/N3849N-1992-02-24.md): Mooney M20F · S/N 680130 · Cancelled Feb 24, 1992 · Exported to Germany · Vita Andreas A
- [N5DA](https://openairdocs.org/deregistered/N5DA-1991-05-02.md): Cessna 140A · S/N 15571 · Cancelled May 2, 1991 · Triennial form not returned · Built 1950 · Pusateri Vincent P

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

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