# Cancelled registrations: Kellogg, ID

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

Cancelled aircraft registrations in Kellogg, ID.

- [N58907](https://openairdocs.org/deregistered/N58907-2012-08-30.md): Cessna T-50 · S/N 13633 · Cancelled Aug 30, 2012 · Revoked, canceled · Built 1942 · Gage B F
- [N2369F](https://openairdocs.org/deregistered/N2369F-1978-02-09.md): Cessna 210E · S/N 21058569 · Cancelled Feb 9, 1978 · Built 1965 · Linhart William H
- [N102CH](https://openairdocs.org/deregistered/N102CH-1976-01-12.md): Cessna 337C · S/N 0850 · Cancelled Jan 12, 1976 · Hoye Ronald R Sr
- [N50806](https://openairdocs.org/deregistered/N50806-1970-10-22.md): Fairchild PT-19 · S/N 7323AE · Cancelled Oct 22, 1970 · Built 1943 · Crow Adelbert J/Crow Duwain D
- [N63269](https://openairdocs.org/deregistered/N63269-1965-05-22.md): Timm N2T-1 · S/N 227 · Cancelled May 22, 1965 · Clarke Roscoe J
- [N2587G](https://openairdocs.org/deregistered/N2587G-1964-12-03.md): Cessna 182B · S/N 51887 · Cancelled Dec 3, 1964 · Exported to Canada · Sass Verne
- [N41773](https://openairdocs.org/deregistered/N41773-1962-01-04.md): Funk B75L · S/N 218 · Cancelled Jan 4, 1962 · Rock Oliver F
- [N4873H](https://openairdocs.org/deregistered/N4873H-1958-06-23.md): Piper PA-17 · S/N 17-172 · Cancelled Jun 23, 1958 · Culp Orville
- [N8732C](https://openairdocs.org/deregistered/N8732C-1957-12-12.md): Piper PA-22-135 · S/N 22-1407 · Cancelled Dec 12, 1957 · Mattmiller John N
- [N32101](https://openairdocs.org/deregistered/N32101-1955-10-20.md): Waco UPF-7 · S/N 5733 · Cancelled Oct 20, 1955 · Built 1941 · Kling Donald L
- [N72357](https://openairdocs.org/deregistered/N72357-1955-10-03.md): Cessna 140 · S/N 9543 · Cancelled Oct 3, 1955 · Phillips Lee
- [N49347](https://openairdocs.org/deregistered/N49347-1953-08-13.md): Fairchild M-62A-3 · S/N FT-816 · Cancelled Aug 13, 1953 · Hayes Robert E
- [N9083K](https://openairdocs.org/deregistered/N9083K-1949-09-09.md): Stinson 108-1 · S/N 108-2083 · Cancelled Sep 9, 1949 · Shoshone Pilots Association
- [N49358](https://openairdocs.org/deregistered/N49358-1949-07-14.md): Cessna T-50 · S/N 2644 · Cancelled Jul 14, 1949 · Built 1943 · Wing H E
- [N9392K](https://openairdocs.org/deregistered/N9392K-1949-05-25.md): Stinson 108-2 · S/N 108-2392 · Cancelled May 25, 1949 · Keister Beulah
- [N8538X](https://openairdocs.org/deregistered/N8538X-undated.md): Cessna P172D · S/N P17257138 · Cancellation date not recorded · Williams Duane DBA Shoshone Air Service

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

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