# Cancelled registrations: Sun Valley, ID

A list on [Sun Valley, ID](https://openairdocs.org/faa-place/ID/Sun%20Valley.md).

Cancelled aircraft registrations in Sun Valley, ID.

- [N1159H](https://openairdocs.org/deregistered/N1159H-2023-04-06.md): Aeronca 15AC · S/N 15AC-172 · Cancelled Apr 6, 2023 · Registration expired, pending cancellation · Built 1948 · Craig John A
- [N6033C](https://openairdocs.org/deregistered/N6033C-2019-05-01.md): Beech B-60 · S/N P-491 · Cancelled May 1, 2019 · Registration expired, pending cancellation · Built 1979 · Dcm Aircraft LLC
- [N17993](https://openairdocs.org/deregistered/N17993-2014-09-10.md): Beech E-55 · S/N TE-1100 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1977 · Bertha Brian A
- [N24MH](https://openairdocs.org/deregistered/N24MH-2013-08-07.md): Cessna 340 · S/N 340-0169 · Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1972 · J C Enterprises
- [N6095C](https://openairdocs.org/deregistered/N6095C-2012-09-17.md): Cessna T210N · S/N 21063801 · Cancelled Sep 17, 2012 · Exported to Australia · Built 1979 · Nystrom International
- [N160AT](https://openairdocs.org/deregistered/N160AT-2008-12-09.md): Consolidated Vultee PBY-6A · S/N 46665 · Cancelled Dec 9, 2008 · Exported to Australia · Nystrom International
- [N1097Y](https://openairdocs.org/deregistered/N1097Y-2004-04-07.md): Raytheon A36 · S/N E-3060 · Cancelled Apr 7, 2004 · Exported to Australia · Built 1996 · Nystrom International Inc
- [N105PK](https://openairdocs.org/deregistered/N105PK-2004-02-25.md): Mooney M20R · S/N 29-0203 · Cancelled Feb 25, 2004 · Exported to Australia · Built 1999 · Nystrom International
- [N711WE](https://openairdocs.org/deregistered/N711WE-2003-06-18.md): Piper PA-31-350 · S/N 31-7752190 · Cancelled Jun 18, 2003 · Exported to Australia · Built 1977 · Nystrom International
- [N5772C](https://openairdocs.org/deregistered/N5772C-2001-09-19.md): Mooney M20K · S/N 25-0841 · Cancelled Sep 19, 2001 · Triennial form not returned · Horsley Co
- [N4932C](https://openairdocs.org/deregistered/N4932C-1997-07-25.md): Cessna A185F · S/N 18502663 · Cancelled Jul 25, 1997 · Exported to Australia · Nystrom International
- [N6476L](https://openairdocs.org/deregistered/N6476L-1996-07-09.md): Piper PA-31-310 · S/N 31437 · Cancelled Jul 9, 1996 · Exported to New Zealand · Nystrom International
- [N4005H](https://openairdocs.org/deregistered/N4005H-1991-05-03.md): Mooney M20K · S/N 250453 · Cancelled May 3, 1991 · Exported to Canada · Peter Flood And Company Inc
- [N9391](https://openairdocs.org/deregistered/N9391-1978-10-03.md): Beech S35 · S/N D-7639 · Cancelled Oct 3, 1978 · Roth Wayne E/Palmer Robert
- [N292M](https://openairdocs.org/deregistered/N292M-1974-04-11.md): Piper PA-23-250 · S/N 27-305 · Cancelled Apr 11, 1974 · Sims Robert A
- [N92554](https://openairdocs.org/deregistered/N92554-1955-10-12.md): Piper PA-12 · S/N 12-83 · Cancelled Oct 12, 1955 · Brohan William K

## 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 = 'ID' AND d.registrant_city = 'SUN VALLEY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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