# Cancelled registrations: Susanville, CA

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

Cancelled aircraft registrations in Susanville, CA.

- [N1417X](https://openairdocs.org/deregistered/N1417X-2018-05-03.md): Piper PA-28-180 · S/N 28-7505226 · Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1975 · Stewart William H
- [N312MG](https://openairdocs.org/deregistered/N312MG-2018-04-19.md): Gratriex William C ZODIAC 601 XL · S/N 6802 · Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2012 · Gratriex William C
- [N515YG](https://openairdocs.org/deregistered/N515YG-2018-03-27.md): William C Gratriex BG-1 · S/N 001 · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 2014 · Gratriex William C
- [N1149K](https://openairdocs.org/deregistered/N1149K-2018-03-23.md): Luscombe 8A · S/N 3876 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1946 · Purdy Leroy W
- [N2865C](https://openairdocs.org/deregistered/N2865C-2018-01-03.md): Cessna 170B · S/N 26408 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1954 · Rhymes Bruce A
- [N5793P](https://openairdocs.org/deregistered/N5793P-2013-07-08.md): Aerospatiale AS350BA · S/N 1476 · Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1982 · Mountain Lifeflight
- [N5367](https://openairdocs.org/deregistered/N5367-2013-04-18.md): Schleicher Alexander K 7 · S/N 7099 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1964 · Davis Wesley D Jr
- [N591RB](https://openairdocs.org/deregistered/N591RB-2013-04-15.md): S N I A S AS-350B ECUREUIL · S/N 1389 · Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1981 · Mountain Lifeflight Lp
- [N421P](https://openairdocs.org/deregistered/N421P-2009-09-14.md): Cessna 421B · S/N 421B0389 · Cancelled Sep 14, 2009 · Second triennial mailing, no response · Built 1973 · Mountain Lifeflight Lp
- [N2067N](https://openairdocs.org/deregistered/N2067N-2008-06-06.md): Enstrom F-28 · S/N 368 · Cancelled Jun 6, 2008 · Triennial form not returned · Northstar Helitek Inc
- [N51981](https://openairdocs.org/deregistered/N51981-2007-01-05.md): Gratriex W C/Gratriex L E SCORPION BGH1 · S/N RW 2509 · Cancelled Jan 5, 2007 · Gratriex William C
- [N51981](https://openairdocs.org/deregistered/N51981-2004-09-08.md): Steadman SCORPION TOO RW133 · S/N RW2509 · Cancelled Sep 8, 2004 · Gratriex William C
- [N9053T](https://openairdocs.org/deregistered/N9053T-2004-01-06.md): Aerospatiale AS350BA · S/N 2395 · Cancelled Jan 6, 2004 · Exported to Canada · Built 1990 · Northstar Helitek Inc
- [N70910](https://openairdocs.org/deregistered/N70910-1972-02-23.md): Piper J3C-65 · S/N 17929 · Cancelled Feb 23, 1972 · Barr Dave
- [N5740T](https://openairdocs.org/deregistered/N5740T-1971-02-12.md): Cessna 172E · S/N 17251640 · Cancelled Feb 12, 1971 · Clark Construction Corporation
- [N29239](https://openairdocs.org/deregistered/N29239-1943-11-18.md): Aeronca 60-TF · S/N F2890T · Cancelled Nov 18, 1943 · Built 1940 · Bay Cities Flyers
- [N10632](https://openairdocs.org/deregistered/N10632-1935-03-15.md): Osterblom Harry HEATH SUPER PARASOL · S/N HO-1 · Cancelled Mar 15, 1935 · Osterblom Harry

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

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