# Registered aircraft: Shoreview, MN

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

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

- [N1701](https://openairdocs.org/aircraft/N1701.md): Cessna 172F · S/N 17252418 · Built 1964 · Rolston Charles W
- [N2172S](https://openairdocs.org/aircraft/N2172S.md): DJI AIR 2S · S/N 1581F3YT7L82003P4240 · City Of Shoreview
- [N242SE](https://openairdocs.org/aircraft/N242SE.md): Cirrus Design SR22 · S/N 9019 · Built 2022 · Sanco Enterprises
- [N25185](https://openairdocs.org/aircraft/N25185.md): Fairchild 24W-40 · S/N 108 · Built 1940 · Bruggeman Steven S
- [N344PT](https://openairdocs.org/aircraft/N344PT.md): Nelson Garrett T SONEX · S/N 1634 · Built 2016 · Nelson Garrett T
- [N4381A](https://openairdocs.org/aircraft/N4381A.md): Piper PA-18A · S/N 18-4787 · N4381a Inc
- [N4456X](https://openairdocs.org/aircraft/N4456X.md): Piper PA-28R-200 · S/N 28R-7635050 · Built 1975 · Fly By Knight Corp
- [N4647C](https://openairdocs.org/aircraft/N4647C.md): Cessna 170B · S/N 25591 · Built 1953 · Concolor LLC
- [N52813](https://openairdocs.org/aircraft/N52813.md): Boeing A75N1(PT17) · S/N 75-394 · Built 1940 · Tischer William D
- [N5694H](https://openairdocs.org/aircraft/N5694H.md): Beech 95 · S/N TD-243 · Built 1965 · Tischer William D
- [N5842B](https://openairdocs.org/aircraft/N5842B.md): Cessna 182 · S/N 33842 · Built 1956 · Pietrs Michael
- [N5942R](https://openairdocs.org/aircraft/N5942R.md): Cessna 172G · S/N 17253611 · Built 1965 · L&L Ltd
- [N6021E](https://openairdocs.org/aircraft/N6021E.md): Beech K35 · S/N D-5919 · Built 1959 · Merhar Timothy J
- [N7175T](https://openairdocs.org/aircraft/N7175T.md): Cessna 172A · S/N 46775 · Built 1959 · Tischer William D
- [N734HZ](https://openairdocs.org/aircraft/N734HZ.md): Cessna 172N · S/N 17268878 · Built 1977 · Aster Labs Inc
- [N7492B](https://openairdocs.org/aircraft/N7492B.md): Champion 7EC · S/N 7EC-558 · Built 1957 · Benson Airport Association Inc
- [N771M](https://openairdocs.org/aircraft/N771M.md): Beech A36 · S/N E-293 · Built 1971 · Ags Leasing Services LLC
- [N789B](https://openairdocs.org/aircraft/N789B.md): Piper PA-18-150 · S/N 18-7709171 · Built 1977 · Nelson Brett R
- [N80869](https://openairdocs.org/aircraft/N80869.md): Globe GC-1B · S/N 272 · Built 1946 · Bailey Robert L
- [N8187V](https://openairdocs.org/aircraft/N8187V.md): Cessna A150M · S/N A1500559 · Built 1974 · Nelson Brett R
- [N8353R](https://openairdocs.org/aircraft/N8353R.md): Piper PA-28-140 · S/N 28-22228 · Built 1966 · Schrandt Mark L
- [N8432L](https://openairdocs.org/aircraft/N8432L.md): Cessna 172I · S/N 17256632 · Built 1968 · Aster Labs Inc
- [N86AZ](https://openairdocs.org/aircraft/N86AZ.md): Jimi Holdings KITFOX S7 SUPER SPRT · S/N KA14787283 · Built 2019 · Eggen Mark Allen
- [N88PY](https://openairdocs.org/aircraft/N88PY.md): Piper PA-18-150 · S/N 18-7425 · Built 1960 · Segler Max D
- [N8958K](https://openairdocs.org/aircraft/N8958K.md): Stinson 108-1 · S/N 108-1958 · Built 1947 · Christopherson Mark A
- [N95JJ](https://openairdocs.org/aircraft/N95JJ.md): Connell Joseph T CONNELL RV-9A · S/N 90216 · Built 2010 · Horrigan Patrick B
- [N970TM](https://openairdocs.org/aircraft/N970TM.md): DJI AIR 2S · S/N 1581F3YT7L82003P424 · City Of Shoreview

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

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