# Registered aircraft: Midvale, UT

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

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

- [N1490X](https://openairdocs.org/aircraft/N1490X.md): Piper PA-28-235 · S/N 28-7510095 · Built 1975 · Twin Peaks Holdings
- [N177U](https://openairdocs.org/aircraft/N177U.md): Cessna 195 · S/N 7433 · Registration pending · Built 1949
- [N2378E](https://openairdocs.org/aircraft/N2378E.md): Aviotec AVIASTOL · S/N 001 · Built 2000 · Fair Hillary M
- [N2937U](https://openairdocs.org/aircraft/N2937U.md): Cessna 172D · S/N 17250537 · Built 1963 · Hangar 47 Aviation LLC
- [N324SM](https://openairdocs.org/aircraft/N324SM.md): Textron T206H · S/N T20609666 · Built 2021 · Maverick II LLC
- [N41AK](https://openairdocs.org/aircraft/N41AK.md): Beech F90 · S/N LA-188 · Built 1982 · Substation Air LLC
- [N4227Q](https://openairdocs.org/aircraft/N4227Q.md): Cessna 172L · S/N 17260127 · Built 1971 · Schoenfeld Paul E
- [N4377W](https://openairdocs.org/aircraft/N4377W.md): Piper PA-28-161 · S/N 28-8516006 · Built 1984 · Cameron Jarred
- [N45XD](https://openairdocs.org/aircraft/N45XD.md): Cessna T210N · S/N 21064495 · Built 1981 · Substation Air LLC
- [N4626H](https://openairdocs.org/aircraft/N4626H.md): Mooney M20J · S/N 24-0799 · Built 1979 · Flying K Enterprises LLC
- [N54CT](https://openairdocs.org/aircraft/N54CT.md): Brubaker Calvin VANS RV-10 · S/N 40212 · Built 2020 · Brubaker Calvin
- [N551SC](https://openairdocs.org/aircraft/N551SC.md): Piper PA-18-125 · S/N 18-945 · Aoa Adventures LLC
- [N631D](https://openairdocs.org/aircraft/N631D.md): Beech C35 · S/N D-2893 · Built 1951 · Kyczak Aviation LLC
- [N6852H](https://openairdocs.org/aircraft/N6852H.md): Cessna 172M · S/N 17265608 · Built 1975 · Setter Jory
- [N71RJ](https://openairdocs.org/aircraft/N71RJ.md): Wightman Steven D SEAWIND · S/N 153 · Built 2011 · Twin Peaks Holdings
- [N89186](https://openairdocs.org/aircraft/N89186.md): Cessna 152 · S/N 15282665 · Built 1978 · Hangar 47 Aviation LLC
- [N8WN](https://openairdocs.org/aircraft/N8WN.md): Thompson Johnny LIGHTNING · S/N 26 · Built 2008 · Lyman Roy M
- [N919PK](https://openairdocs.org/aircraft/N919PK.md): Pilatus PC-12/47E · S/N 1095 · Built 2008 · Western Flyer Holdings LLC
- [N9456X](https://openairdocs.org/aircraft/N9456X.md): Cessna 182R · S/N 18268533 · Built 1985 · Moxie Holdings 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 = 'UT' AND g.registrant_city = 'MIDVALE'
ORDER BY g.n_number
```

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