# Cancelled registrations: Walnut, CA

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

Cancelled aircraft registrations in Walnut, CA.

- [N591AK](https://openairdocs.org/deregistered/N591AK-2022-12-31.md): Sikorsky S-76B · S/N 760348 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1989 · Unical Aviation Inc
- [N12400](https://openairdocs.org/deregistered/N12400-2018-09-17.md): North American F-86L · S/N 53-4064A · Cancelled Sep 17, 2018 · Revoked, canceled · Built 1953 · Mount San Antonio College
- [N2128Q](https://openairdocs.org/deregistered/N2128Q-2018-09-13.md): Piper PA-28-161 · S/N 28-7916281 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1979 · It Wurx Inc
- [N9120A](https://openairdocs.org/deregistered/N9120A-2018-01-10.md): Piper PA-38-112 · S/N 38-82A0098 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1982 · Mt San Antonio Community College District
- [N84AM](https://openairdocs.org/deregistered/N84AM-2017-10-20.md): Rolladen Schneider OHG LS-3-17 · S/N 3466 · Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Built 1980 · Schirra John A
- [N71RC](https://openairdocs.org/deregistered/N71RC-2017-04-13.md): Cessna 421C · S/N 421C0423 · Cancelled Apr 13, 2017 · Built 1977 · Bedichek Robert C
- [N301F](https://openairdocs.org/deregistered/N301F-2014-09-29.md): Glasflugel H 301 LIBELLE · S/N 22 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1966 · Saunders Paul A Jr
- [N457M](https://openairdocs.org/deregistered/N457M-2013-07-15.md): Adams Cliff QUICKSILVER MXII · S/N 001 · Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Built 2002 · Adams Cliff
- [N918CD](https://openairdocs.org/deregistered/N918CD-2013-05-22.md): Beech B24R · S/N MC-398 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1976 · Mount San Antonio Community College
- [N141CM](https://openairdocs.org/deregistered/N141CM-2013-04-10.md): Piper PA-31 · S/N 31234 · Cancelled Apr 10, 2013 · Registration expired, pending cancellation · Built 1969 · Tokyo International Trading America Inc
- [N90017](https://openairdocs.org/deregistered/N90017-2013-03-26.md): Sneddon Norman R CHEROKEE-II · S/N 2001 · Cancelled Mar 26, 2013 · Sale reported, canceled · Built 1988
- [N4272B](https://openairdocs.org/deregistered/N4272B-2013-03-07.md): Raven Industries S-66A · S/N S66A-136 · Cancelled Mar 7, 2013 · Sale reported, pending cancellation · Built 1982
- [N596](https://openairdocs.org/deregistered/N596-2013-02-08.md): Hickey 1917 SE5-A REPLICA · S/N 072041 · Cancelled Feb 8, 2013 · Sale reported, canceled · Built 1974
- [N3082](https://openairdocs.org/deregistered/N3082-2012-09-05.md): Pitts SPECIAL · S/N 249-H · Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1971
- [N634LB](https://openairdocs.org/deregistered/N634LB-2012-08-31.md): Bell Helicopter Textron Canada 206B · S/N 4634 · Cancelled Aug 31, 2012 · Exported to China · Kao Wilson Chien Yu
- [N47PR](https://openairdocs.org/deregistered/N47PR-2012-08-10.md): Seright Paul O JR RV-6A · S/N 001 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1994 · Mount San Antonio Community College
- [N218SE](https://openairdocs.org/deregistered/N218SE-2012-04-12.md): Grumman American Avn. G-1159 · S/N 116 · Cancelled Apr 12, 2012 · Registration pending, pending cancellation · Built 1972
- [N8135F](https://openairdocs.org/deregistered/N8135F-2008-03-13.md): Cessna 150F · S/N 15064235 · Cancelled Mar 13, 2008 · Exported to Philippines · Built 1966 · Aguilar Krishna G
- [N210EL](https://openairdocs.org/deregistered/N210EL-2005-12-22.md): Cessna T210N · S/N 21063843 · Cancelled Dec 22, 2005 · Exported to Mexico · Arrieta Jaime
- [N8888V](https://openairdocs.org/deregistered/N8888V-2004-11-22.md): Cameron Balloons U S MONITOR-80 · S/N 4766 · Cancelled Nov 22, 2004 · Triennial form not returned · Built 2000 · Viewsonic Corp
- [N22GB](https://openairdocs.org/deregistered/N22GB-1992-12-31.md): Cessna 340A · S/N 340A0983 · Cancelled Dec 31, 1992 · Exported to Canada · Briggs Donald G
- [N4849T](https://openairdocs.org/deregistered/N4849T-1977-07-07.md): Piper PA-28R-200 · S/N 28R-7235123 · Cancelled Jul 7, 1977 · Briggs Donald G
- [N64281](https://openairdocs.org/deregistered/N64281-1975-05-01.md): Hiller OH-23C · S/N 56-2303 · Cancelled May 1, 1975 · Mt San Antonio College

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

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