# Registered aircraft: Valley City, ND

A list on [Valley City, ND](https://openairdocs.org/faa-place/ND/Valley%20City.md).

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

- [N12939](https://openairdocs.org/aircraft/N12939.md): Sampson PIETENPOL AIRCAMPER · S/N EMS-2 · Built 1972 · Anderson Rick L
- [N151DJ](https://openairdocs.org/aircraft/N151DJ.md): Piper PA-28-151 · S/N 28-7515308 · Built 1975 · Valley City Flying Club Llp
- [N15NV](https://openairdocs.org/aircraft/N15NV.md): Ayres S-2R · S/N 2475R · Built 1978 · North Valley Aircraft Inc
- [N15PU](https://openairdocs.org/aircraft/N15PU.md): Christen Industries PITTS S-2S · S/N 3015 · Built 1989 · North Valley Aircraft Inc
- [N2260V](https://openairdocs.org/aircraft/N2260V.md): Cessna 140 · S/N 14491 · North Valley Aircraft Inc
- [N2859F](https://openairdocs.org/aircraft/N2859F.md): Cessna 182J · S/N 18256959 · Built 1966 · Valley City Flying Club Llp
- [N3271P](https://openairdocs.org/aircraft/N3271P.md): Peterson Stewart A QUICKSILVER MX II · S/N 1013 · Built 1982 · Nielson Steven J
- [N3994D](https://openairdocs.org/aircraft/N3994D.md): Peel BABY GREAT LAKES · S/N OGL-1 · Anderson Rick L
- [N4026U](https://openairdocs.org/aircraft/N4026U.md): Piper PA-18-150 · S/N 18-7409147 · Lindemann Aviation LLC
- [N51GF](https://openairdocs.org/aircraft/N51GF.md): Christen Industries PITTS S-2B · S/N 5089 · North Valley Aircraft Inc
- [N58865](https://openairdocs.org/aircraft/N58865.md): Cessna 182P · S/N 18262354 · Built 1973 · Fairhill Properties LLC
- [N66384](https://openairdocs.org/aircraft/N66384.md): Cessna 150M · S/N 15076008 · Built 1974 · Anderson Rick L
- [N687H](https://openairdocs.org/aircraft/N687H.md): Hostetler Rolland GN1 AIRCAMPER · S/N 1016 · Built 1987 · Anderson Rick L
- [N7638C](https://openairdocs.org/aircraft/N7638C.md): North American/Victoria MNT LT AT-6A · S/N 774300 · Lindemann Flying Service LLC
- [N805RB](https://openairdocs.org/aircraft/N805RB.md): Boeing PT-17 · S/N 75-2729 · Built 1941 · North Valley Aircraft Inc
- [N85BW](https://openairdocs.org/aircraft/N85BW.md): Beech B95A · S/N TD-480 · Built 1961 · Sayler Nathan T
- [N91TC](https://openairdocs.org/aircraft/N91TC.md): Cooney R-3 · S/N 2 · Built 1979 · North Valley Aircraft Inc
- [N9562E](https://openairdocs.org/aircraft/N9562E.md): Aeronca 11AC · S/N 11AC-1199 · Anderson Rick L
- [N9986M](https://openairdocs.org/aircraft/N9986M.md): Cessna TU206G · S/N U20604635 · Logan Timothy R

## 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 = 'ND' AND g.registrant_city = 'VALLEY CITY'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/ND/Valley%20City/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, except the copies of manufacturers’ service documents, which belong to their rights holders.