# Cancelled registrations: San Ysidro, CA

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

Cancelled aircraft registrations in San Ysidro, CA.

- [N1119](https://openairdocs.org/deregistered/N1119-2023-03-04.md): Hogge Dennis Warren LANCAIR 320 · S/N 424 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Van Den Eeden Pedro E
- [N107LV](https://openairdocs.org/deregistered/N107LV-2018-06-08.md): Martin Jorge W GT400 · S/N J101 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 2005 · Martin Jorge W
- [N7661C](https://openairdocs.org/deregistered/N7661C-2018-01-29.md): Martin Jorge W RACER · S/N J102 · Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 2007 · Martin Jorge W
- [N8278M](https://openairdocs.org/deregistered/N8278M-2013-07-24.md): Cessna 210K · S/N 21059278 · Cancelled Jul 24, 2013 · Exported to Mexico · Built 1970
- [N64WS](https://openairdocs.org/deregistered/N64WS-2013-06-05.md): Johnson Dale A WOODSTOCK · S/N 64 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Johnson Dale
- [N431QA](https://openairdocs.org/deregistered/N431QA-2010-12-10.md): Contreras Vicente ROTORWAY A600 TALON · S/N 8037 · Cancelled Dec 10, 2010 · Exported to Mexico · Contreras Vicente
- [N9374Z](https://openairdocs.org/deregistered/N9374Z-2009-02-04.md): Cessna TU206G · S/N U20606440 · Cancelled Feb 4, 2009 · Exported to Mexico · Built 1982
- [N6285Y](https://openairdocs.org/deregistered/N6285Y-2008-12-16.md): Piper PA-23-250 · S/N 27-3532 · Cancelled Dec 16, 2008 · Exported to Mexico · Zermeno Francisco T
- [N8777Q](https://openairdocs.org/deregistered/N8777Q-2008-10-28.md): Cessna U206G · S/N U20603529 · Cancelled Oct 28, 2008 · Exported to Mexico · Built 1976 · Contreras Vicente
- [N4580X](https://openairdocs.org/deregistered/N4580X-2008-04-25.md): Cessna TU206F · S/N U20602878 · Cancelled Apr 25, 2008 · Exported to Mexico
- [N246PL](https://openairdocs.org/deregistered/N246PL-2008-04-14.md): Cessna T210L · S/N 21059625 · Cancelled Apr 14, 2008 · Exported to Mexico
- [N18VC](https://openairdocs.org/deregistered/N18VC-2008-02-05.md): Cessna U206G · S/N U20605275 · Cancelled Feb 5, 2008 · Exported to Mexico · Contreras Vicente DBA
- [N732RH](https://openairdocs.org/deregistered/N732RH-2007-04-27.md): Cessna TU206G · S/N U20604711 · Cancelled Apr 27, 2007 · Exported to Mexico · Built 1978 · Contreras Vicente
- [N5851F](https://openairdocs.org/deregistered/N5851F-2006-09-15.md): Cessna 210G · S/N 21058851 · Cancelled Sep 15, 2006 · Exported to Mexico · Contreras Vicente DBA
- [N525VC](https://openairdocs.org/deregistered/N525VC-2006-07-24.md): Cessna T210N · S/N 21064136 · Cancelled Jul 24, 2006 · Exported to Mexico · Contreras Vicente
- [N761HP](https://openairdocs.org/deregistered/N761HP-2005-06-30.md): Cessna T210M · S/N 21062272 · Cancelled Jun 30, 2005 · Exported to Mexico · Contrerus Vicente
- [N8301S](https://openairdocs.org/deregistered/N8301S-2005-06-30.md): Cessna 182H · S/N 18256401 · Cancelled Jun 30, 2005 · Exported to Mexico · Contreras Vicente
- [N3835G](https://openairdocs.org/deregistered/N3835G-2005-01-24.md): Cessna TU206B · S/N U2060835 · Cancelled Jan 24, 2005 · Exported to Mexico · Contreras Vincente DBA
- [N59238](https://openairdocs.org/deregistered/N59238-2004-03-15.md): Cessna T210L · S/N 21060173 · Cancelled Mar 15, 2004 · Exported to Mexico · Built 1974 · Contreras Vicente
- [N761VH](https://openairdocs.org/deregistered/N761VH-2002-11-14.md): Cessna T210M · S/N 21062549 · Cancelled Nov 14, 2002 · Exported to Mexico · Built 1978 · Contreras Vicente
- [N868C](https://openairdocs.org/deregistered/N868C-1993-12-23.md): Partenavia P68 · S/N 214 · Cancelled Dec 23, 1993 · Exported to Mexico · San Diego Shipping & Research Co Inc
- [N4117R](https://openairdocs.org/deregistered/N4117R-1973-10-19.md): Piper PA-32-300 · S/N 32-40436 · Cancelled Oct 19, 1973 · Exported to Mexico · Aviation E/C Inc
- [N5204U](https://openairdocs.org/deregistered/N5204U-1973-08-13.md): Cessna 206 · S/N 206-0204 · Cancelled Aug 13, 1973 · Exported to Mexico · Elias Alejandro
- [N4024K](https://openairdocs.org/deregistered/N4024K-1973-06-25.md): Ryan NAVION B · S/N 1024B · Cancelled Jun 25, 1973 · Wehber Selim
- [N997PK](https://openairdocs.org/deregistered/N997PK-1973-02-13.md): Piper PA-32-300 · S/N 32-40416 · Cancelled Feb 13, 1973 · Exported to Mexico · Built 1967 · Baja Properties Leasing Inc
- [N67666](https://openairdocs.org/deregistered/N67666-1970-08-31.md): Piper J3C-65 · S/N 13970 · Cancelled Aug 31, 1970 · Built 1945 · Lower Robert 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 = 'CA' AND d.registrant_city = 'SAN YSIDRO'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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