# Cancelled registrations: Piedmont, CA

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

Cancelled aircraft registrations in Piedmont, CA.

- [N664EJ](https://openairdocs.org/deregistered/N664EJ-2023-03-04.md): DJI PHANTOM 3 PROFESSION · S/N CF281854268888 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Produce 2 Broadcast LLC
- [N269WP](https://openairdocs.org/deregistered/N269WP-2001-01-22.md): Cessna 320E · S/N 320E-0096 · Cancelled Jan 22, 2001 · Triennial form not returned · Linford John A
- [N4301G](https://openairdocs.org/deregistered/N4301G-1983-08-10.md): Mcculloch J-2 · S/N 011 · Cancelled Aug 10, 1983 · Breuner Stol Co
- [N555CT](https://openairdocs.org/deregistered/N555CT-1977-11-21.md): Cessna T210L · S/N 21059785 · Cancelled Nov 21, 1977 · Gudebski John J
- [N6872](https://openairdocs.org/deregistered/N6872-1975-11-25.md): Sud SA316B ALOUETTE III · S/N 1680 · Cancelled Nov 25, 1975 · Exported to South Africa · Frank C
- [N3047](https://openairdocs.org/deregistered/N3047-1975-11-21.md): Aerospatiale SE3160 ALOUETTE III · S/N 1782 · Cancelled Nov 21, 1975 · Exported to South Africa · Frank C DBA Frank C Associates
- [N6873](https://openairdocs.org/deregistered/N6873-1975-07-28.md): Aerospatiale SE3160 ALOUETTE III · S/N 1681 · Cancelled Jul 28, 1975 · Exported to South Africa · Frank C Dbac Frank Associates
- [N8396](https://openairdocs.org/deregistered/N8396-1975-04-25.md): Snias SE 3160 · S/N 1868 · Cancelled Apr 25, 1975 · Exported to South Africa · Built 1971 · C Frank Associates
- [N6875](https://openairdocs.org/deregistered/N6875-1975-03-12.md): Aerospatiale SA316B ALOUETTE III · S/N 1703 · Cancelled Mar 12, 1975 · Exported to South Africa · C Frank Associates
- [N8261](https://openairdocs.org/deregistered/N8261-1975-03-12.md): Aerospatiale SA316B ALOUETTE III · S/N 1737 · Cancelled Mar 12, 1975 · Exported to South Africa · Built 1970 · C Frank Associates
- [N8654](https://openairdocs.org/deregistered/N8654-1975-03-12.md): Socata TB20 · S/N 1727 · Cancelled Mar 12, 1975 · Exported to South Africa · C Frank Associates
- [N9836](https://openairdocs.org/deregistered/N9836-1975-03-12.md): Aerospatiale SE3160 ALOUETTE III · S/N 1636 · Cancelled Mar 12, 1975 · Exported to South Africa · Built 1969 · Frank C DBA C Frank Associates
- [N4373](https://openairdocs.org/deregistered/N4373-1975-03-10.md): Sud SE3160 ALOUETTE III · S/N 1625 · Cancelled Mar 10, 1975 · Exported to South Africa · Built 1969 · Frank C
- [N8393](https://openairdocs.org/deregistered/N8393-1975-03-10.md): Snias SE 3160 · S/N 1866 · Cancelled Mar 10, 1975 · Exported to South Africa · Built 1971 · C Frank Associates
- [N9363](https://openairdocs.org/deregistered/N9363-1975-03-10.md): Snias SE 3160 · S/N 1746 · Cancelled Mar 10, 1975 · Exported to South Africa · Built 1970 · Frank C
- [N9703](https://openairdocs.org/deregistered/N9703-1975-01-23.md): Aerospatiale SA316B ALOUETTE III · S/N 1807 · Cancelled Jan 23, 1975 · Exported to South Africa · C Frank Associates
- [N9835](https://openairdocs.org/deregistered/N9835-1975-01-23.md): Sud SE3160 ALOUETTE III · S/N 1629 · Cancelled Jan 23, 1975 · Exported to South Africa · Built 1969 · C Frank Associates
- [N8806](https://openairdocs.org/deregistered/N8806-1941-02-01.md): Stearman C3-B · S/N 218 · Cancelled Feb 1, 1941 · Benjamin Michael Fillmore

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

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