# Cancelled registrations: Crescent City, CA

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

Cancelled aircraft registrations in Crescent City, CA.

- [N791PF](https://openairdocs.org/deregistered/N791PF-2020-07-10.md): Penticoff James F VANS ACFT RV8A · S/N 81328 · Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 2007 · Penticoff James F
- [N2483N](https://openairdocs.org/deregistered/N2483N-2019-02-02.md): Cessna 140 · S/N 12736 · Cancelled Feb 2, 2019 · Registration expired, pending cancellation · Armenta Evelyn
- [N2705N](https://openairdocs.org/deregistered/N2705N-2018-03-23.md): Cessna 120 · S/N 12963 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1947 · Wilson Clifford L
- [N72083](https://openairdocs.org/deregistered/N72083-2018-03-16.md): Luscombe 8A · S/N 3510 · Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Finlay E A
- [N49398](https://openairdocs.org/deregistered/N49398-2017-11-18.md): Fairchild M-62A · S/N T435907 · Cancelled Nov 18, 2017 · Revoked, canceled · Built 1943 · Woertendyke Ed Jr
- [N115KV](https://openairdocs.org/deregistered/N115KV-2017-06-30.md): Vilven Jon A AVID FLYER MARK IV · S/N 1487D · Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Vilven Jon A
- [N4385X](https://openairdocs.org/deregistered/N4385X-2013-06-07.md): Alders Edward AVID MARK IV · S/N 1129D · Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Alders Arlen Edward
- [N6113S](https://openairdocs.org/deregistered/N6113S-2013-04-26.md): Air & Space America 18A · S/N 18-19 · Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1965 · Hale Mark E
- [N3286Q](https://openairdocs.org/deregistered/N3286Q-2005-05-23.md): Cessna 401 · S/N 401-0086 · Cancelled May 23, 2005 · Triennial form not returned · Built 1967 · Del Norte Ambulance Inc
- [N1446](https://openairdocs.org/deregistered/N1446-2000-09-21.md): Cessna 210 · S/N 57231 · Cancelled Sep 21, 2000 · Triennial form not returned · Powell Lloyd A
- [N3231P](https://openairdocs.org/deregistered/N3231P-1997-01-24.md): Piper PA-23 · S/N 231174 · Cancelled Jan 24, 1997 · Triennial form not returned · Gawer Richard W
- [N124BR](https://openairdocs.org/deregistered/N124BR-1995-11-28.md): Rolland Bernard E NIEUPORT II · S/N 909 · Cancelled Nov 28, 1995 · Rolland Bernard E
- [N7976E](https://openairdocs.org/deregistered/N7976E-1982-01-05.md): Cessna 150 · S/N 17776 · Cancelled Jan 5, 1982 · Knapp David A
- [N23P](https://openairdocs.org/deregistered/N23P-1980-01-29.md): Sharp-Taylor Monoplane STM · S/N PS1 · Cancelled Jan 29, 1980 · Hendrick David A Etal
- [N60337](https://openairdocs.org/deregistered/N60337-1978-01-16.md): Cessna 150J · S/N 15070233 · Cancelled Jan 16, 1978 · Long James R
- [N4293F](https://openairdocs.org/deregistered/N4293F-1976-04-20.md): Cessna 172 · S/N 46193 · Cancelled Apr 20, 1976 · Exported to Canada · Built 1958 · Potter Donald
- [N7027B](https://openairdocs.org/deregistered/N7027B-1972-03-07.md): Piper PA-22-150 · S/N 22-4278 · Cancelled Mar 7, 1972 · Exported to Canada · George A Palmer
- [N36333](https://openairdocs.org/deregistered/N36333-1970-12-29.md): Taylorcraft BC12-D · S/N 6410 · Cancelled Dec 29, 1970 · Built 1945 · Stover James R

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

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