# Cancelled registrations: Wasco, CA

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

Cancelled aircraft registrations in Wasco, CA.

- [N121SM](https://openairdocs.org/deregistered/N121SM-2022-06-04.md): Cessna 182C · S/N 52813 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Built 1960 · Williams Delbert D
- [N6526D](https://openairdocs.org/deregistered/N6526D-2021-07-03.md): North American-Medore SNJ-5 · S/N 88-19133-1 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Williams Delbert D
- [N2153H](https://openairdocs.org/deregistered/N2153H-2018-01-11.md): Hiller OH-23D · S/N 57-3028 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Burroughs James R
- [N51329](https://openairdocs.org/deregistered/N51329-2017-11-18.md): Fairchild M-62A · S/N T42-3265 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1942 · Payne Aviation
- [N7840](https://openairdocs.org/deregistered/N7840-2016-11-16.md): Grumman G-164A · S/N 788 · Cancelled Nov 16, 2016 · Third renewal notice · Built 1971 · Hallmark Merle D
- [N27277](https://openairdocs.org/deregistered/N27277-2013-06-06.md): Thornton Thomas V KR-2 · S/N 3225 · Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Thornton Thomas V
- [N4363B](https://openairdocs.org/deregistered/N4363B-2013-04-17.md): Cessna 170B · S/N 26707 · Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1955 · Magorian Bruce
- [N31U](https://openairdocs.org/deregistered/N31U-2012-09-25.md): Ryan NAVION B · S/N NAV-4-2100B · Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1950 · Osborn Aviation Inc
- [N57439](https://openairdocs.org/deregistered/N57439-2006-03-21.md): Boeing A75N1(PT17) · S/N 75-1985 · Cancelled Mar 21, 2006 · Exported to Canada · Built 1941
- [N2237M](https://openairdocs.org/deregistered/N2237M-2005-06-23.md): Ayres S2R-G10 · S/N G10-124 · Cancelled Jun 23, 2005 · Exported to Philippines · Built 1996 · Osborn Aviation Inc
- [N931X](https://openairdocs.org/deregistered/N931X-1999-08-31.md): Grumman G-164A · S/N 443 · Cancelled Aug 31, 1999 · Exported to Mexico · Hallmark Merle D
- [N44138](https://openairdocs.org/deregistered/N44138-1981-09-03.md): Piper PA-28-151 · S/N 28-7415589 · Cancelled Sep 3, 1981 · Built 1974 · Wingate Donnel E
- [N68415](https://openairdocs.org/deregistered/N68415-1981-05-08.md): Boeing B75N1 · S/N 75-7762 · Cancelled May 8, 1981 · Woolley Herbert A
- [N56587](https://openairdocs.org/deregistered/N56587-1972-01-24.md): Boeing E75N1 · S/N 75-171 · Cancelled Jan 24, 1972 · Built 1952 · W C Young
- [N74381](https://openairdocs.org/deregistered/N74381-1971-02-10.md): Bellanca 14-13-2 · S/N 1494 · Cancelled Feb 10, 1971 · Kirkwood Fred Jr
- [N56850](https://openairdocs.org/deregistered/N56850-1970-08-10.md): Convair BT-13B · S/N 79-1520 · Cancelled Aug 10, 1970 · Young W C
- [N1507M](https://openairdocs.org/deregistered/N1507M-1965-05-18.md): Boeing E75 · S/N 75-8170 · Cancelled May 18, 1965 · W C Young
- [N53266](https://openairdocs.org/deregistered/N53266-1955-11-29.md): Fairchild M-62A · S/N T41-1181 · Cancelled Nov 29, 1955 · Barling Nathaniel & Barling Samuel
- [N48604](https://openairdocs.org/deregistered/N48604-1955-11-21.md): Taylorcraft L-2M · S/N L-6304 · Cancelled Nov 21, 1955 · Welch Joseph E
- [N57229](https://openairdocs.org/deregistered/N57229-1955-08-02.md): Consolidated Vultee BT-13A · S/N 3433 · Cancelled Aug 2, 1955 · Young W C
- [N53731](https://openairdocs.org/deregistered/N53731-1951-02-23.md): Fairchild M-62A · S/N T43-5123 · Cancelled Feb 23, 1951 · Built 1943 · Peters E J
- [N12261](https://openairdocs.org/deregistered/N12261-1937-07-06.md): Champion B-1 · S/N 101 · Cancelled Jul 6, 1937 · Atkisson J B

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

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