# Cancelled registrations: Melba, ID

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

Cancelled aircraft registrations in Melba, ID.

- [N46081](https://openairdocs.org/deregistered/N46081-2022-07-02.md): Taylorcraft DCO-65 · S/N 5056 · Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Kinney Norman E
- [N2332F](https://openairdocs.org/deregistered/N2332F-2022-02-05.md): Cessna 210E · S/N 21058532 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Ingersoll Robert H
- [N3143Y](https://openairdocs.org/deregistered/N3143Y-2021-10-02.md): Cessna 182E · S/N 18254143 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1962 · Kinney Norman E
- [N8674H](https://openairdocs.org/deregistered/N8674H-2021-10-02.md): North American NAVION · S/N NAV-4-674 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1947 · Tucker Robert B
- [N7031Q](https://openairdocs.org/deregistered/N7031Q-2020-12-08.md): Garner Jack E MINI-MAX · S/N JG101 · Cancelled Dec 8, 2020 · Registration expired, pending cancellation · Built 1998 · Garner Jack E
- [N87JL](https://openairdocs.org/deregistered/N87JL-2018-04-04.md): Larsen John M MARK V · S/N.001 · Cancelled Apr 4, 2018 · Registration expired, pending cancellation · Built 1995 · Larsen John M
- [N9815Y](https://openairdocs.org/deregistered/N9815Y-2018-03-07.md): Champion 7FC · S/N 7FC-433 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1961 · Price James A
- [N4673A](https://openairdocs.org/deregistered/N4673A-2016-01-20.md): Cessna 180 · S/N 32270 · Cancelled Jan 20, 2016 · Built 1956 · Blackwell Jack A
- [N8160W](https://openairdocs.org/deregistered/N8160W-2013-05-13.md): Piper PA-28-180 · S/N 28-2277 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1965 · Price James A
- [N91113](https://openairdocs.org/deregistered/N91113-2013-04-26.md): Williams Jerry AIR COMMAND · S/N 557-96-6407 · Cancelled Apr 26, 2013 · Sale reported, pending cancellation
- [N21LJ](https://openairdocs.org/deregistered/N21LJ-2011-04-26.md): Larsen John M AVID HEAVY HAULER · S/N 910 · Cancelled Apr 26, 2011 · Sale reported
- [N8709D](https://openairdocs.org/deregistered/N8709D-2010-12-20.md): Piper PA-22-160 · S/N 22-5890 · Cancelled Dec 20, 2010 · Triennial form not returned · Built 1958 · Dickman Edward A
- [N375CB](https://openairdocs.org/deregistered/N375CB-2010-10-06.md): Brinker M/Garner J BI-PLANE · S/N U R 1 · Cancelled Oct 6, 2010 · Built 2009 · Brinker Michael W
- [N31578](https://openairdocs.org/deregistered/N31578-2006-06-22.md): Piper PA-34-200T · S/N 34-7870242 · Cancelled Jun 22, 2006 · Exported to Canada · Built 1978 · Blackwell Jack A
- [N58LD](https://openairdocs.org/deregistered/N58LD-2005-08-25.md): Jones David W LONG EZ · S/N 1696 · Cancelled Aug 25, 2005 · Built 1988 · Jones David W
- [N66257](https://openairdocs.org/deregistered/N66257-1998-10-26.md): Kitfox Ten MODEL 2 · S/N 593 · Cancelled Oct 26, 1998 · Triennial form not returned · Popken Roland H
- [N6984M](https://openairdocs.org/deregistered/N6984M-1997-07-11.md): Stinson 108-3 · S/N 1084984 · Cancelled Jul 11, 1997 · Exported to Canada · Muller Dan E

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

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