# Cancelled registrations: Emmett, ID

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

Cancelled aircraft registrations in Emmett, ID.

- [N4832](https://openairdocs.org/deregistered/N4832-2021-04-03.md): Cosmos PHASE 2 · S/N 21319 · Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1999 · Scobey Robert P
- [N3274H](https://openairdocs.org/deregistered/N3274H-2020-10-31.md): Engineering & Research 415-CD · S/N 3899 · Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1947 · Meyer Marc W
- [N58805](https://openairdocs.org/deregistered/N58805-2020-01-21.md): Fairchild M-62A · S/N FW906 · Cancelled Jan 21, 2020 · Revoked, canceled · Built 1943 · Thompson Arthur R
- [N7253E](https://openairdocs.org/deregistered/N7253E-2018-05-31.md): Cessna 182B · S/N 52253 · Cancelled May 31, 2018 · Sale reported, canceled · Built 1959
- [N8698U](https://openairdocs.org/deregistered/N8698U-2017-06-22.md): Cessna 172F · S/N 17252602 · Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1965 · Mednicoff Steve
- [N3623W](https://openairdocs.org/deregistered/N3623W-2017-06-21.md): Piper PA-32-260 · S/N 32-524 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1966 · Henderson Timothy A
- [N5196H](https://openairdocs.org/deregistered/N5196H-2015-05-15.md): Piper PA-14 · S/N 14-493 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1948 · Taylor Donald L
- [N6399B](https://openairdocs.org/deregistered/N6399B-2012-06-25.md): Cessna 182A · S/N 34299 · Cancelled Jun 25, 2012 · Second renewal notice · Built 1957 · Jennings Richard L
- [N3321Y](https://openairdocs.org/deregistered/N3321Y-2010-12-16.md): Cessna 182E · S/N 18254321 · Cancelled Dec 16, 2010 · Revoked, pending cancellation · Built 1962 · Lanham Rex E
- [N71989](https://openairdocs.org/deregistered/N71989-2006-09-01.md): Luscombe 8A · S/N 3416 · Cancelled Sep 1, 2006 · Triennial form not returned · Built 1946 · Taylor Robert K
- [N7869](https://openairdocs.org/deregistered/N7869-2006-08-10.md): Grumman Acft ENG Cor-Schweizer G-164A · S/N 1003 · Cancelled Aug 10, 2006 · Triennial form not returned · Built 1972 · Taylor Donald L
- [N4085D](https://openairdocs.org/deregistered/N4085D-2005-02-18.md): Cessna 182A · S/N 34785 · Cancelled Feb 18, 2005 · Triennial form not returned · Built 1958 · Vaughn Ronald Keith
- [N5293](https://openairdocs.org/deregistered/N5293-2003-09-18.md): Grumman G-164 · S/N 581 · Cancelled Sep 18, 2003 · Triennial form not returned · Built 1969 · Morris Jay L
- [N44811](https://openairdocs.org/deregistered/N44811-2002-11-25.md): Cessna 421B · S/N 421B0802 · Cancelled Nov 25, 2002 · Exported to Canada · Built 1974 · Moe Russell S
- [N2107X](https://openairdocs.org/deregistered/N2107X-2002-06-06.md): Cessna 337 · S/N 337-0007 · Cancelled Jun 6, 2002 · Triennial form not returned · Built 1964 · Morris Jay L
- [N3751C](https://openairdocs.org/deregistered/N3751C-1995-04-05.md): Corey Alfred Y SCORPION 133 · S/N 11745 · Cancelled Apr 5, 1995 · Triennial form not returned · Britton John E
- [N9056L](https://openairdocs.org/deregistered/N9056L-1983-11-23.md): Champion 7ECA · S/N 768-70 · Cancelled Nov 23, 1983 · Administratively canceled · Varner Charles A
- [N4817F](https://openairdocs.org/deregistered/N4817F-1983-08-16.md): Cessna TU206A · S/N TU206-0517 · Cancelled Aug 16, 1983 · Revoked, pending cancellation · Built 1966 · Rex E Lanham Co
- [N57429](https://openairdocs.org/deregistered/N57429-1977-12-01.md): Bellanca 7GCBC · S/N 500-73 · Cancelled Dec 1, 1977 · Robinson David H
- [N8269A](https://openairdocs.org/deregistered/N8269A-1973-11-07.md): Cessna 170B · S/N 25121 · Cancelled Nov 7, 1973 · Exported to Canada · Robinson David H
- [N7909H](https://openairdocs.org/deregistered/N7909H-1973-04-23.md): Piper PA-12 · S/N 12-813 · Cancelled Apr 23, 1973 · Exported to Canada · Robinson David H
- [N94862](https://openairdocs.org/deregistered/N94862-1972-11-06.md): Ercoupe 415-E · S/N 5004 · Cancelled Nov 6, 1972 · Exported to Canada · Stevenson Robert D
- [N50678](https://openairdocs.org/deregistered/N50678-1971-10-19.md): Piper J5A · S/N 51203 · Cancelled Oct 19, 1971 · Buck A H
- [N9055D](https://openairdocs.org/deregistered/N9055D-1970-06-29.md): Piper PA-22-160 · S/N 22-6195 · Cancelled Jun 29, 1970 · Gem Aero Assn Inc
- [N1390K](https://openairdocs.org/deregistered/N1390K-1954-05-24.md): Luscombe 8A · S/N 4117 · Cancelled May 24, 1954 · Built 1946 · Poole Ronald
- [N18260](https://openairdocs.org/deregistered/N18260-1951-01-29.md): Welch OW5M · S/N 142 · Cancelled Jan 29, 1951 · Gem Flying Club

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

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