# Cancelled registrations: Rancho Santa Fe, CA

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

Cancelled aircraft registrations in Rancho Santa Fe, CA.

- [N47UP](https://openairdocs.org/deregistered/N47UP-2023-08-04.md): Cessna 182P · S/N 18264954 · Cancelled Aug 4, 2023 · Superfast Skylane LLC
- [N747RH](https://openairdocs.org/deregistered/N747RH-2022-03-15.md): Hensley Robert A LANCAIR 320 · S/N 242 · Cancelled Mar 15, 2022 · Sale reported, canceled · Built 1988
- [N625EA](https://openairdocs.org/deregistered/N625EA-2020-01-24.md): Fourthwing VIREO · S/N F126 · Cancelled Jan 24, 2020 · Registration pending, canceled
- [N3059M](https://openairdocs.org/deregistered/N3059M-2019-12-09.md): Piper PA-12 · S/N 12-1748 · Cancelled Dec 9, 2019 · Revoked, canceled · Built 1947 · Wiberg Donald F
- [N478LM](https://openairdocs.org/deregistered/N478LM-2019-11-15.md): Lockheed Martin INDAGO · S/N IDGV1AG061820151057 · Cancelled Nov 15, 2019 · Registration pending, canceled
- [N580SS](https://openairdocs.org/deregistered/N580SS-2019-11-15.md): Lockheed Martin INDAGO · S/N IDGV1LE061820151052 · Cancelled Nov 15, 2019 · Registration pending, canceled
- [N582LM](https://openairdocs.org/deregistered/N582LM-2019-11-15.md): Lockheed Martin INDAGO · S/N IDGV1AG061820151054 · Cancelled Nov 15, 2019 · Registration pending, canceled
- [N1645E](https://openairdocs.org/deregistered/N1645E-2018-12-15.md): Aeronca 7AC · S/N 7AC5210 · Cancelled Dec 15, 2018 · Revoked, canceled · Built 1946 · Wiberg Donald F
- [N210VC](https://openairdocs.org/deregistered/N210VC-2017-06-01.md): Cessna T210L · S/N 21060200 · Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1974 · Flynn Michael J
- [N8107M](https://openairdocs.org/deregistered/N8107M-2013-07-23.md): Cessna 310I · S/N 310I0107 · Cancelled Jul 23, 2013 · Registration expired, pending cancellation · Built 1964 · Dawson Steve
- [N9249F](https://openairdocs.org/deregistered/N9249F-2013-05-22.md): Hughes 369HS · S/N 350726S · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1975 · Kenram Corporation
- [N4199K](https://openairdocs.org/deregistered/N4199K-2013-04-25.md): Raven Industries S77A · S/N S77A-104 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1983 · Balloon Flights LLC
- [N3756Q](https://openairdocs.org/deregistered/N3756Q-2013-03-25.md): Northrop C-125A · S/N 48-634 · Cancelled Mar 25, 2013 · Sale reported, canceled
- [N395MY](https://openairdocs.org/deregistered/N395MY-2013-02-27.md): Gates Learjet 35A · S/N 395 · Cancelled Feb 27, 2013 · Exported to Canada · Built 1981 · N395my LLC
- [N1275W](https://openairdocs.org/deregistered/N1275W-2008-06-05.md): Cessna T206H · S/N T20608679 · Cancelled Jun 5, 2008 · Exported to Mexico · Njc Air LLC
- [N40HH](https://openairdocs.org/deregistered/N40HH-2006-01-04.md): Bell 206B · S/N 3218 · Cancelled Jan 4, 2006 · Built 1980 · South Seas Helicopter Co. Inc.
- [N4753C](https://openairdocs.org/deregistered/N4753C-2005-03-17.md): Fairchild C-82A · S/N 48-574 · Cancelled Mar 17, 2005 · Sale reported · Built 1948
- [N1517S](https://openairdocs.org/deregistered/N1517S-2002-02-06.md): Balloon Works FIREFLY 7-B · S/N 11077 · Cancelled Feb 6, 2002 · Triennial form not returned · Built 1981 · Rodriguez Abelardo L
- [N216JM](https://openairdocs.org/deregistered/N216JM-1996-05-09.md): Avions Pierre Robin PIERRE ROBIN R2160 · S/N 202 · Cancelled May 9, 1996 · Triennial form not returned · Doban Robert C
- [N66JC](https://openairdocs.org/deregistered/N66JC-1990-12-19.md): Burkhart Grob Flugzeugbau G109 · S/N 6065 · Cancelled Dec 19, 1990 · Exported to Australia · Chalmers Investment Company Inc
- [N30383](https://openairdocs.org/deregistered/N30383-1983-05-17.md): Piper PA-44-180 · S/N 44-7995073 · Cancelled May 17, 1983 · Crosby Kenneth B
- [N40RW](https://openairdocs.org/deregistered/N40RW-1983-01-07.md): West Reed COMMUTER IIA · S/N WK181 · Cancelled Jan 7, 1983 · Built 1981 · West Reed & Keys Patrick
- [N37D](https://openairdocs.org/deregistered/N37D-1976-05-13.md): Beech B-60 · S/N P-335 · Cancelled May 13, 1976 · Built 1975 · Fleet Preston M
- [N5AM](https://openairdocs.org/deregistered/N5AM-1976-01-28.md): Cessna 340 · S/N 340-0010 · Cancelled Jan 28, 1976 · Aircraft Mobilehomes Inc
- [N1558C](https://openairdocs.org/deregistered/N1558C-1955-05-31.md): Cessna 180 · S/N 30258 · Cancelled May 31, 1955 · Exported to Canada · Ewing Gifford C

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

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