# Cancelled registrations: Coeur D Alene, ID

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

Cancelled aircraft registrations in Coeur D Alene, ID.

- [N423ST](https://openairdocs.org/deregistered/N423ST-2022-11-05.md): Burns Fletcher A SONERAI II L · S/N FB01041 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1984 · Avon Robert W
- [N575DA](https://openairdocs.org/deregistered/N575DA-2022-11-05.md): DJI PHANTOM 3 PROFESSION · S/N P78DCF12032326 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Salvation Army Kroc Center
- [N6602B](https://openairdocs.org/deregistered/N6602B-2022-03-08.md): Cessna 310B · S/N 35702 · Cancelled Mar 8, 2022 · Second renewal notice · Built 1958 · Inceptus Inc
- [N2106K](https://openairdocs.org/deregistered/N2106K-2021-09-04.md): Dehavilland DHC-2 MK. I(L20A) · S/N 1131 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1956 · Brooks Seaplane Service Inc
- [N848MG](https://openairdocs.org/deregistered/N848MG-2021-07-31.md): Sidney G Goodwin BUETO 1 · S/N 4102018 · Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Goodwin Sidney G
- [N628S](https://openairdocs.org/deregistered/N628S-2021-01-11.md): Ridenhour Jan W SEEKER ONE 85A · S/N S0001A · Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 2004 · Ridenhour Jan W
- [N235SP](https://openairdocs.org/deregistered/N235SP-2019-12-17.md): Schaefer D F / Pelland P G LANCAIR 235 · S/N 52 · Cancelled Dec 17, 2019 · Exported to Argentina · Built 1993 · Schaefer Daniel E
- [N3210A](https://openairdocs.org/deregistered/N3210A-2019-09-06.md): Cessna 170B · S/N 25854 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1953 · Inceptus Inc
- [N723PW](https://openairdocs.org/deregistered/N723PW-2019-06-25.md): DJI PHANTOM 2 VISION + · S/N PH645375081 V2.0 · Cancelled Jun 25, 2019 · Second renewal notice · Welch Comer Engineers
- [N166TA](https://openairdocs.org/deregistered/N166TA-2017-09-26.md): Brown L O Pat STAR-LITE · S/N 166 · Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1987 · Goodwin Sidney G
- [N521JH](https://openairdocs.org/deregistered/N521JH-2017-02-17.md): Harrison Stanley HARRISON S-7 COURIER · S/N 1096210 · Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Built 2004 · Harrison Stanley
- [N6745F](https://openairdocs.org/deregistered/N6745F-2013-09-26.md): Cessna 150F · S/N 15063345 · Cancelled Sep 26, 2013 · Revoked, canceled · Built 1966 · Smith James C
- [N311DH](https://openairdocs.org/deregistered/N311DH-2013-07-09.md): Bell 430 · S/N 49067 · Cancelled Jul 9, 2013 · Exported to Turkey · Built 2000 · Hagadone Helicopters LLC
- [N9GB](https://openairdocs.org/deregistered/N9GB-2013-05-17.md): Semco Balloon CHALLENGER · S/N SEM104 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1973 · Stuart Thomas J
- [N8698Z](https://openairdocs.org/deregistered/N8698Z-2013-05-15.md): Cessna P206C · S/N P206-0498 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1968 · Hunt Bros Construction Inc
- [N75LP](https://openairdocs.org/deregistered/N75LP-2012-06-25.md): Pickrell A Larry LM-1 · S/N 1 · Cancelled Jun 25, 2012 · Triennial form not returned · Built 1991 · Tennison Rory
- [N156SS](https://openairdocs.org/deregistered/N156SS-2010-11-22.md): Solan Thomas A STORCH · S/N 0001 · Cancelled Nov 22, 2010 · Solan Thomas A
- [N25016](https://openairdocs.org/deregistered/N25016-2009-07-16.md): Semco Balloon T · S/N SEM70 · Cancelled Jul 16, 2009 · Registration revoked · Built 1972 · Semco Balloon
- [N5885C](https://openairdocs.org/deregistered/N5885C-2008-07-24.md): Beech E-55 · S/N TE868 · Cancelled Jul 24, 2008 · Built 1972 · Wasti Hamid A
- [N222DG](https://openairdocs.org/deregistered/N222DG-2005-09-26.md): Fairchild F-27F · S/N 31 · Cancelled Sep 26, 2005 · Triennial form not returned · Built 1958 · Empire Airlines Inc
- [N789LM](https://openairdocs.org/deregistered/N789LM-2005-09-20.md): Cessna 182S · S/N 18280043 · Cancelled Sep 20, 2005 · Exported to Canada · Lunceford Earl G Trustee
- [N4073Z](https://openairdocs.org/deregistered/N4073Z-2002-08-21.md): Piper PA-18-150 · S/N 18-8086 · Cancelled Aug 21, 2002 · Exported to Canada · Built 1964 · Hall William H
- [N3071R](https://openairdocs.org/deregistered/N3071R-1998-06-15.md): Piper PA-28R-200 · S/N 28R35632 · Cancelled Jun 15, 1998 · Munkittrick Mark G
- [N6217F](https://openairdocs.org/deregistered/N6217F-1998-05-12.md): Ballard Larry CHALLENGER II · S/N CH20995L392 · Cancelled May 12, 1998 · Exported to Canada · Ballard Larry A
- [N5919Y](https://openairdocs.org/deregistered/N5919Y-1996-03-15.md): Piper PA-23-250 · S/N 273076 · Cancelled Mar 15, 1996 · Pope Kent M
- [N903T](https://openairdocs.org/deregistered/N903T-1992-08-28.md): Beech 95-55 · S/N TC42 · Cancelled Aug 28, 1992 · Triennial form not returned · Christianson Perry A
- [N8109B](https://openairdocs.org/deregistered/N8109B-1991-03-13.md): Cessna 172 · S/N 29909 · Cancelled Mar 13, 1991 · Triennial form not returned · Hempen Robert L
- [N8744Q](https://openairdocs.org/deregistered/N8744Q-1984-07-03.md): Cessna U206F · S/N U20603497 · Cancelled Jul 3, 1984 · Administratively canceled · Pulis Builders Inc
- [N2204F](https://openairdocs.org/deregistered/N2204F-1980-07-26.md): Piper PA-28-181 · S/N 28-7990192 · Cancelled Jul 26, 1980 · Built 1979 · Crawley David B
- [N8556](https://openairdocs.org/deregistered/N8556-1974-09-23.md): Semco Balloon T · S/N SEM 79 · Cancelled Sep 23, 1974 · Semco Balloon Mark Semich
- [N7458Y](https://openairdocs.org/deregistered/N7458Y-1971-02-09.md): Piper PA-30 · S/N 30-521 · Cancelled Feb 9, 1971 · Jaeger Joseph Jr
- [N1624A](https://openairdocs.org/deregistered/N1624A-1960-06-14.md): Piper PA-18A · S/N 18-1269 · Cancelled Jun 14, 1960 · Kadoun Kenneth R
- [N2000M](https://openairdocs.org/deregistered/N2000M-1955-10-04.md): Piper PA-11 · S/N 11-2 · Cancelled Oct 4, 1955 · Brooks William R
- [N3350B](https://openairdocs.org/deregistered/N3350B-1955-08-04.md): Piper PA-18 · S/N 18-3303 · Cancelled Aug 4, 1955 · Exported to United Kingdom · Brooks William R
- [N3801M](https://openairdocs.org/deregistered/N3801M-1951-08-10.md): Piper PA-12 · S/N 12-2560 · Cancelled Aug 10, 1951 · Aviation Industries Inc
- [N33904](https://openairdocs.org/deregistered/N33904-1950-03-07.md): Taylorcraft BC12-65 · S/N 2755 · Cancelled Mar 7, 1950 · O A Wartenberg
- [N49144](https://openairdocs.org/deregistered/N49144-1949-12-22.md): Aeronca 0-58B · S/N 058B-4062 · Cancelled Dec 22, 1949 · Lents Percy M
- [N73496](https://openairdocs.org/deregistered/N73496-1949-11-12.md): Fairchild PT-23-AE · S/N 3113AE · Cancelled Nov 12, 1949 · Schneberger Ed C
- [N297Y](https://openairdocs.org/deregistered/N297Y-1949-09-30.md): Fairchild 24W-40 · S/N W40-127 · Cancelled Sep 30, 1949 · Aviation Industries Inc
- [N30115](https://openairdocs.org/deregistered/N30115-1949-07-18.md): Waco UPF-7 · S/N 5512 · Cancelled Jul 18, 1949 · Aviation Industries Inc
- [N73497](https://openairdocs.org/deregistered/N73497-1949-05-10.md): Fairchild PT-23 · S/N 1183AE · Cancelled May 10, 1949 · Robinson James B
- [N2805H](https://openairdocs.org/deregistered/N2805H-1949-04-22.md): Engineering & Research ERCOUPE 415-C · S/N 3430 · Cancelled Apr 22, 1949 · Aviation Industries Inc
- [N29319](https://openairdocs.org/deregistered/N29319-1948-06-09.md): Waco UPF-7 · S/N 5346 · Cancelled Jun 9, 1948 · Aviation Industries Inc

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

This list as a web page: https://openairdocs.org/faa-place/ID/Coeur%20D%20Alene/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, except the copies of manufacturers’ service documents, which belong to their rights holders.