# Cancelled registrations: Mariposa, CA

A list on [Mariposa, CA](https://openairdocs.org/faa-place/CA/Mariposa.md).

Cancelled aircraft registrations in Mariposa, CA.

- [N1284R](https://openairdocs.org/deregistered/N1284R-2023-11-27.md): Bellanca 17-30A · S/N 30394 · Cancelled Nov 27, 2023 · Sale reported, canceled
- [N7358V](https://openairdocs.org/deregistered/N7358V-2022-12-31.md): Bellanca 17-31TC · S/N 31001 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1969 · Foster Troy D
- [N1887](https://openairdocs.org/deregistered/N1887-2019-03-14.md): Cessna 320C · S/N 320C0023 · Cancelled Mar 14, 2019 · Sale reported · Built 1964
- [N71KN](https://openairdocs.org/deregistered/N71KN-2017-07-12.md): Nye Kenneth G KR-2 · S/N 4371 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1992 · Shaw William D
- [N1438A](https://openairdocs.org/deregistered/N1438A-2013-06-11.md): Piper PA-22-135 · S/N 22-552 · Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1952
- [N70DP](https://openairdocs.org/deregistered/N70DP-2013-06-05.md): Piccard AX-6 · S/N 717 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1974 · Lucero Richard T
- [N3145B](https://openairdocs.org/deregistered/N3145B-2013-04-01.md): Breeden Dwayne V2-D · S/N 102 · Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1984
- [N3382V](https://openairdocs.org/deregistered/N3382V-2012-09-12.md): Cessna 150M · S/N 15076483 · Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1974
- [N747A](https://openairdocs.org/deregistered/N747A-2004-01-16.md): Sikorsky S-55 · S/N 55910 · Cancelled Jan 16, 2004 · Built 1956 · Central Sierra Helicopters Inc
- [N1482L](https://openairdocs.org/deregistered/N1482L-2001-02-27.md): Beech A23 · S/N M-882 · Cancelled Feb 27, 2001 · Triennial form not returned · Ferrier Harvey D
- [N50878](https://openairdocs.org/deregistered/N50878-2000-07-31.md): Cessna 150J · S/N 15069617 · Cancelled Jul 31, 2000 · Newman John E
- [N25EH](https://openairdocs.org/deregistered/N25EH-1994-04-05.md): Heldt E R/Heldt A C LANCAIR 0235 · S/N 014 · Cancelled Apr 5, 1994 · Triennial form not returned · Heldt Earl R
- [N7250F](https://openairdocs.org/deregistered/N7250F-1993-01-29.md): Piper PA-28-140 · S/N 2825167 · Cancelled Jan 29, 1993 · Clark Robert M Jr
- [N521KH](https://openairdocs.org/deregistered/N521KH-1991-05-15.md): Heddergott BD-4 · S/N 521 · Cancelled May 15, 1991 · Triennial form not returned · Heddergott Klaus D
- [N5318Y](https://openairdocs.org/deregistered/N5318Y-1981-05-07.md): Piper PA-23-250 · S/N 272395 · Cancelled May 7, 1981 · Yosemite Aviation Center Inc
- [N6709G](https://openairdocs.org/deregistered/N6709G-1978-01-31.md): Cessna 150L · S/N 15072209 · Cancelled Jan 31, 1978 · Yosemite Aviation Center Inc
- [N2948K](https://openairdocs.org/deregistered/N2948K-1974-04-19.md): Luscombe 8A · S/N 5675 · Cancelled Apr 19, 1974 · Bryant Robert W
- [N24802](https://openairdocs.org/deregistered/N24802-1965-05-18.md): Piper J3C-65 · S/N 3454 · Cancelled May 18, 1965 · Built 1939 · Kirby Kenneth P
- [N95062](https://openairdocs.org/deregistered/N95062-1950-03-08.md): Taylorcraft BC12-D · S/N 9462 · Cancelled Mar 8, 1950 · Hodgson Robert E

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

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