# Cancelled registrations: La Quinta, CA

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

Cancelled aircraft registrations in La Quinta, CA.

- [N407WS](https://openairdocs.org/deregistered/N407WS-2021-10-30.md): Wild Sky GOAT · S/N 1707 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 2017 · Fly The Desert LLC
- [N8498J](https://openairdocs.org/deregistered/N8498J-2020-04-03.md): Westman Barry N FW-190A · S/N 1 · Cancelled Apr 3, 2020 · Sale reported, canceled · Built 1984
- [N10VH](https://openairdocs.org/deregistered/N10VH-2020-02-28.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S-619 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1983 · Gray Bruce D
- [N243TL](https://openairdocs.org/deregistered/N243TL-2019-09-06.md): DJI PHANTOM 2 VISION + · S/N PH645243463 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Henkel Kristopher D
- [N931XZ](https://openairdocs.org/deregistered/N931XZ-2015-05-28.md): Westland Helicopters GAZELLE HT. MK3 · S/N 1728 · Cancelled May 28, 2015 · Exported to South Africa · Foote Howard A
- [N1133S](https://openairdocs.org/deregistered/N1133S-2015-05-18.md): Cessna 411 · S/N 411-0202 · Cancelled May 18, 2015 · Registration expired, pending cancellation · Built 1966 · Maino Roger L Trustee
- [N2036H](https://openairdocs.org/deregistered/N2036H-2015-04-24.md): Balloon Works FIREFLY 7 · S/N 798 · Cancelled Apr 24, 2015 · Registration expired, pending cancellation · Built 1977 · Moonshadows Media Inc
- [N374WZ](https://openairdocs.org/deregistered/N374WZ-2014-12-22.md): North Wing Uum SPORT X2 · S/N LS7012 · Cancelled Dec 22, 2014 · Registration pending, canceled · Built 2009
- [N98TR](https://openairdocs.org/deregistered/N98TR-2013-08-21.md): Hubbard Chauncey C STDD HMLTN GL II S · S/N 2237 · Cancelled Aug 21, 2013 · Sale reported, canceled
- [N5095U](https://openairdocs.org/deregistered/N5095U-2013-03-25.md): Quicksilver MXL SPORT II · S/N 000742 · Cancelled Mar 25, 2013 · Sale reported, canceled · Built 2000
- [N2348H](https://openairdocs.org/deregistered/N2348H-2012-08-14.md): Balloon Works FIREFLY 7 · S/N 7732 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1978
- [N2447H](https://openairdocs.org/deregistered/N2447H-2012-08-14.md): Balloon Works FIREFLY 7 · S/N 7713 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1978
- [N2048F](https://openairdocs.org/deregistered/N2048F-2012-08-08.md): Hawkins AX-4 · S/N 40 · Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1975
- [N9GE](https://openairdocs.org/deregistered/N9GE-2012-06-21.md): Eberhart Gregory STARDUSTER TOO SA300 · S/N 472 · Cancelled Jun 21, 2012 · First renewal notice · Eberhart Gregory
- [N6PL](https://openairdocs.org/deregistered/N6PL-2010-01-26.md): Piper PA-32R-301T · S/N 3257147 · Cancelled Jan 26, 2010 · Exported to Australia · Built 2000 · Mailloux Ralph E Trustee
- [N119DC](https://openairdocs.org/deregistered/N119DC-2004-08-04.md): Charron Daniel P KITFOX LITE · S/N L0001-068 · Cancelled Aug 4, 2004 · Triennial form not returned · Charron Daniel P
- [N105HH](https://openairdocs.org/deregistered/N105HH-2000-05-11.md): Messerschmitt-Boelkow-Blohm BO-105S · S/N S-339 · Cancelled May 11, 2000 · Triennial form not returned · Gray Bruce D
- [N739KJ](https://openairdocs.org/deregistered/N739KJ-1997-03-25.md): Cessna 172N · S/N 17270601 · Cancelled Mar 25, 1997 · Bongirno Carl G Co-Trustee

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

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