# Registered aircraft: Joseph, OR

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

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

- [N1190C](https://openairdocs.org/aircraft/N1190C.md): Piper PA-18A-135 · S/N 18-2473 · Built 1954 · Stein Adam Kent
- [N138RS](https://openairdocs.org/aircraft/N138RS.md): Smelser Robert W 18 SUPER SPORT · S/N WA1714 · Built 1998 · Perry Louis D
- [N185JB](https://openairdocs.org/aircraft/N185JB.md): Cessna A185F · S/N 18503800 · Basile Joseph
- [N2022R](https://openairdocs.org/aircraft/N2022R.md): Perry Robert B FISHER CLASSIC · S/N 500 · Built 2004 · North East Oregon Aviation Foundation
- [N2834B](https://openairdocs.org/aircraft/N2834B.md): Piper PA-28-181 · S/N 28-7990477 · Built 1979 · Sager Arthur
- [N31876](https://openairdocs.org/aircraft/N31876.md): Maule MX-7-180A · S/N 20045C · Winn Derek H
- [N3730R](https://openairdocs.org/aircraft/N3730R.md): Cessna 172H · S/N 17255530 · Built 1966 · Chief Joseph Flyers Inc
- [N3802V](https://openairdocs.org/aircraft/N3802V.md): Cessna 170 · S/N 18723 · Brink Gregory P
- [N4190Z](https://openairdocs.org/aircraft/N4190Z.md): Piper PA-18-150 · S/N 18-8374 · Built 1966 · Winn Derek H
- [N43863](https://openairdocs.org/aircraft/N43863.md): Taylorcraft BC12-D · S/N 7522 · Good Kenneth A
- [N438LL](https://openairdocs.org/aircraft/N438LL.md): Learn Martin J CHALLENGER II · S/N CH2-0106-2710 · Learn Martin J
- [N4718F](https://openairdocs.org/aircraft/N4718F.md): Cessna P206B · S/N P206-0318 · Built 1966 · Pbar Inc
- [N526RM](https://openairdocs.org/aircraft/N526RM.md): Michael S Fleming RV-7 · S/N 74572 · Built 2023 · Fleming Michael S
- [N6524B](https://openairdocs.org/aircraft/N6524B.md): Mooney M20 · S/N 1191 · Built 1957 · Rotzler Russell J
- [N708MT](https://openairdocs.org/aircraft/N708MT.md): Cessna 180 · S/N 32014 · Thibodeau Michael L
- [N7745D](https://openairdocs.org/aircraft/N7745D.md): Piper PA-22-150 · S/N 22-5425 · Sale reported · Built 1957
- [N804PM](https://openairdocs.org/aircraft/N804PM.md): Cessna 182E · S/N 18254108 · Built 1962 · Smp Outdoors Inc
- [N838JW](https://openairdocs.org/aircraft/N838JW.md): Piper PA-18-150 · S/N 18-7709147 · Built 1977 · Fleming Cheri Rene
- [N9623V](https://openairdocs.org/aircraft/N9623V.md): Cessna 172M · S/N 17264403 · Schreder Peter T
- [N9777D](https://openairdocs.org/aircraft/N9777D.md): Piper PA-18A 150 · S/N 18-6191 · Built 1957 · Rouse Kenneth L Jr

## 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 = 'OR' AND g.registrant_city = 'JOSEPH'
ORDER BY g.n_number
```

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