# Registered aircraft: Jefferson, OR

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

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

- [N140KY](https://openairdocs.org/aircraft/N140KY.md): Cessna 120 · S/N 11780 · Built 1946 · Carpenter Michael A
- [N150HH](https://openairdocs.org/aircraft/N150HH.md): Bell 206B · S/N 701 · Built 1971 · Cascade Airways LLC
- [N1836C](https://openairdocs.org/aircraft/N1836C.md): Grumman Acft ENG Cor-Schweizer G-164C · S/N 36C · Built 1978 · Cascade Airways LLC
- [N25719](https://openairdocs.org/aircraft/N25719.md): Beech V35B · S/N D-9540 · Built 1973 · Brunner Robert L
- [N29224](https://openairdocs.org/aircraft/N29224.md): Cessna U206C · S/N U206-1176 · Built 1968 · Phelan Ricky Ray
- [N2HA](https://openairdocs.org/aircraft/N2HA.md): Cessna 172M · S/N 17265382 · Built 1975 · Brunner Robert L
- [N35374](https://openairdocs.org/aircraft/N35374.md): Piper J5A · S/N 5-625 · Built 1941 · Phelan Ricky R
- [N398KL](https://openairdocs.org/aircraft/N398KL.md): Swearingen SA226TC · S/N TC-398 · Built 1981 · Cascade Airways LLC
- [N4139M](https://openairdocs.org/aircraft/N4139M.md): Piper PA-12 · S/N 12-3038 · Whiteley Jeffrey L
- [N4184U](https://openairdocs.org/aircraft/N4184U.md): Cessna 150D · S/N 15060184 · Built 1963 · Doughton Jonathan S
- [N528PG](https://openairdocs.org/aircraft/N528PG.md): Airborne REDBACK · S/N 503-719 · Built 2002 · Harmsworth Colin C
- [N5636A](https://openairdocs.org/aircraft/N5636A.md): Cessna 172 · S/N 28236 · Built 1956 · Fine Aviation LLC
- [N6188E](https://openairdocs.org/aircraft/N6188E.md): Cessna 172 · S/N 46288 · Cs Aircraft Services LLC
- [N625DK](https://openairdocs.org/aircraft/N625DK.md): Knight Doug VANS RV-9A · S/N 90625 · Built 2006 · Knight Doug B
- [N6506H](https://openairdocs.org/aircraft/N6506H.md): Piper J3C-65 · S/N 19691 · Built 1946 · Carpentiero Michael A
- [N65322](https://openairdocs.org/aircraft/N65322.md): Northwing Design APACHE SPORT · S/N 7282 · Harmsworth Colin C
- [N7100M](https://openairdocs.org/aircraft/N7100M.md): Cessna 175 · S/N 55400 · Built 1958 · Whiteley Jeffrey L
- [N897SB](https://openairdocs.org/aircraft/N897SB.md): Beech E18S · S/N BA-385 · Built 1958 · Cascade Airways LLC

## 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 = 'JEFFERSON'
ORDER BY g.n_number
```

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