# Registered aircraft: Parma, ID

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1132B](https://openairdocs.org/aircraft/N1132B.md): Silvaire LUSCOMBE 8A · S/N 5759 · Built 1947 · Hager Bill E
- [N158Q](https://openairdocs.org/aircraft/N158Q.md): Coates Ray Dean QUICKIE · S/N 158B · Hager Bill
- [N20TZ](https://openairdocs.org/aircraft/N20TZ.md): Dusseau Richard F KITFOX SER 5 SAFARI · S/N S96080188 · Jantzi Katrina
- [N342TH](https://openairdocs.org/aircraft/N342TH.md): Beech T-34C-1 · S/N GM-87 · Built 1981 · Hill Thomas D
- [N3619C](https://openairdocs.org/aircraft/N3619C.md): Cessna 180 · S/N 31117 · Built 1954 · Hamby Michael R
- [N3734V](https://openairdocs.org/aircraft/N3734V.md): Cessna 150M · S/N 15076606 · Burrell Dennis E
- [N3932D](https://openairdocs.org/aircraft/N3932D.md): Dressen Donald L ESCAPE LS · S/N 01 · Built 2012 · Nelson Christopher H
- [N4017Y](https://openairdocs.org/aircraft/N4017Y.md): Cessna 185 · S/N 185-0217 · Built 1961 · 17y LLC
- [N429ST](https://openairdocs.org/aircraft/N429ST.md): Jim L Tracy RV-8 · S/N 83064 · Built 2015 · Tracy Jim L
- [N47TL](https://openairdocs.org/aircraft/N47TL.md): Cessna A185F · S/N 18503185 · Built 1976 · Obendorf Phillip G
- [N52367](https://openairdocs.org/aircraft/N52367.md): Ray E Roberts KITFOX V VIXEN · S/N V9404-0008 · Jantzi Reuben B
- [N53709](https://openairdocs.org/aircraft/N53709.md): Taylorcraft DCO-65 · S/N L-5941 · Built 1944 · Hill Thomas D
- [N6433E](https://openairdocs.org/aircraft/N6433E.md): Cessna 172 · S/N 46533 · Built 1959 · Morgan Peter F
- [N675MA](https://openairdocs.org/aircraft/N675MA.md): Piper PA46-500TP · S/N 4697367 · Built 2008 · Owyhee Produce LLC
- [N73197](https://openairdocs.org/aircraft/N73197.md): Cessna 172M · S/N 17267324 · Built 1976 · Seward Kent
- [N74JF](https://openairdocs.org/aircraft/N74JF.md): Freeburg John D SMITH MINIPLANE · S/N 007 · Built 2020 · Hager Bill E
- [N79589](https://openairdocs.org/aircraft/N79589.md): Cessna 182P · S/N 18261838 · Built 1973 · Aqua Irrigation Technologies LLC
- [N817ST](https://openairdocs.org/aircraft/N817ST.md): Columbia Aircraft Mfg LC41-550FG · S/N 41724 · Built 2007 · Taberna John P
- [N8279A](https://openairdocs.org/aircraft/N8279A.md): Cessna 170B · S/N 25131 · Built 1952 · Hadley Harold C
- [N837TH](https://openairdocs.org/aircraft/N837TH.md): Top Hatz HATZ CB-1 · S/N 873 · Built 2007 · Hager Bill
- [N854NP](https://openairdocs.org/aircraft/N854NP.md): Tyhurst Christian E SONEX · S/N 001 · Built 2007 · Tyhurst Christian E
- [N8605D](https://openairdocs.org/aircraft/N8605D.md): Piper PA-22-160 · S/N 22-5803 · Built 1957 · Troxel Robert G
- [N882TH](https://openairdocs.org/aircraft/N882TH.md): Thomas D Hill RV-8 · S/N 83123 · Hill Thomas D
- [N9405C](https://openairdocs.org/aircraft/N9405C.md): Cessna 180 · S/N 31803 · Built 1955 · Ramsower Charles M
- [N99577](https://openairdocs.org/aircraft/N99577.md): Engineering & Research ERCOUPE 415-C · S/N 2200 · Built 1946 · Alfred E Mcmillin
- [N999RP](https://openairdocs.org/aircraft/N999RP.md): Peck Robert A SONERAI II · S/N 151 · Jantzi Isaac J

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'ID' AND g.registrant_city = 'PARMA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/ID/Parma/aircraft

---
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.
