# Registered aircraft: Rochester, WA

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

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

- [N1008Z](https://openairdocs.org/aircraft/N1008Z.md): Psota MINIPLANE · S/N 1 · Built 1961 · Kimbrel Mark D
- [N11WD](https://openairdocs.org/aircraft/N11WD.md): Miniplane 1 · S/N 12-19-19 · Registration pending · Built 1973
- [N125SH](https://openairdocs.org/aircraft/N125SH.md): Harroun David RANS S7S COURIER · S/N 0503346-S · Built 2005 · Harroun David R
- [N160MB](https://openairdocs.org/aircraft/N160MB.md): Ashley Clayton HELICYCLE · S/N 1-18 · Built 2003 · Ashley Clayton L
- [N200RQ](https://openairdocs.org/aircraft/N200RQ.md): Remos G-3/600 · S/N 200 · Built 2007 · Kerzie Ken
- [N2403J](https://openairdocs.org/aircraft/N2403J.md): Cessna 150G · S/N 15065503 · Built 1966 · Cordell John M
- [N43803](https://openairdocs.org/aircraft/N43803.md): Taylorcraft BC12-D · S/N 7462 · Built 1946 · Kimbrel Melvin A
- [N46003](https://openairdocs.org/aircraft/N46003.md): Cessna 172I · S/N 17256981 · Built 1968 · Carroll Michael L
- [N47DK](https://openairdocs.org/aircraft/N47DK.md): Konopatzke Dan AVID FLYER MK IV · S/N 1379D · Registration pending, pending cancellation · Built 2001
- [N5775F](https://openairdocs.org/aircraft/N5775F.md): Danforth Lew VANS RV-4 · S/N 1307 · Danforth Lew W
- [N653MC](https://openairdocs.org/aircraft/N653MC.md): Mcdonald Melvin Joseph RUTAN LONG EZ · S/N 146 · Daily Joshua
- [N7058L](https://openairdocs.org/aircraft/N7058L.md): Aircreation BUGGY 582 SLGB · S/N T00085 · Built 2001 · Mackey Lanny J
- [N706AD](https://openairdocs.org/aircraft/N706AD.md): Schweizer SGS 1-26A · S/N 178 · Built 1966 · Kimbrel Mark D
- [N7705G](https://openairdocs.org/aircraft/N7705G.md): Whittman Tailwind W-8 · S/N J.B.O.-1 · Built 1967 · Kimbrel Mark D
- [N8350K](https://openairdocs.org/aircraft/N8350K.md): Stinson 108-1 · S/N 108-1350 · Built 1946 · Kimbrel Mark D
- [N8391J](https://openairdocs.org/aircraft/N8391J.md): Cessna 150G · S/N 15066291 · Daily Joshua J
- [N8518](https://openairdocs.org/aircraft/N8518.md): Wilson-Stits Flut-R-Bug SA6B · S/N WW-100 · Built 1968 · Kimbrel Mark D
- [N8723K](https://openairdocs.org/aircraft/N8723K.md): Stinson 108-1 · S/N 108-1723 · Built 1947 · Kimbrel Mark
- [N8979Z](https://openairdocs.org/aircraft/N8979Z.md): Cessna 310G · S/N 310G0079 · Built 1962 · Kimbrel Mark D
- [N91491](https://openairdocs.org/aircraft/N91491.md): North American NAVION · S/N NAV-4-286 · Daily Joshua J
- [N945CS](https://openairdocs.org/aircraft/N945CS.md): S.A.Centrair PEGASE 101 · S/N 101 003 · Gilbreath Michael L

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

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