# Registered aircraft: Pietsch Warren A

A list on [Pietsch Warren A](https://openairdocs.org/faa-owner/PIETSCH%20WARREN%20A.md).

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

- [N101H](https://openairdocs.org/aircraft/N101H.md): Monocoupe 110 SPECIAL · S/N 6W60 · Built 1938 · Minot, ND
- [N11490](https://openairdocs.org/aircraft/N11490.md): Waco QCF · S/N 3572 · Built 1931 · Minot, ND
- [N114V](https://openairdocs.org/aircraft/N114V.md): Monocoupe 110 · S/N 6W23 · Built 1932 · Minot, ND
- [N1249](https://openairdocs.org/aircraft/N1249.md): Luscombe PHANTOM 1 · S/N 120 · Built 1937 · Minot, ND
- [N1286](https://openairdocs.org/aircraft/N1286.md): Luscombe PHANTOM 1 · S/N 106 · Built 1936 · Minot, ND
- [N14419](https://openairdocs.org/aircraft/N14419.md): Taylor J-2 · S/N 1607 · Built 1937 · Minot, ND
- [N151LP](https://openairdocs.org/aircraft/N151LP.md): Waco UPF-7 · S/N 5824 · Minot, ND
- [N180WP](https://openairdocs.org/aircraft/N180WP.md): Pietsch Warren TAYLORCRAFT GJ · S/N XT-1 · Built 1980 · Minot, ND
- [N214GP](https://openairdocs.org/aircraft/N214GP.md): Pietsch Warren IT · S/N Z1A-0016 · Built 1994 · Minot, ND
- [N30110](https://openairdocs.org/aircraft/N30110.md): Pietsch SD-TWO · S/N P-10 · Built 1967 · Minot, ND
- [N343E](https://openairdocs.org/aircraft/N343E.md): Meyers MAC-145 · S/N 210 · Built 1951 · Minot, ND
- [N3484N](https://openairdocs.org/aircraft/N3484N.md): Mooney M20F · S/N 680067 · Built 1967 · Minot, ND
- [N4967M](https://openairdocs.org/aircraft/N4967M.md): Piper PA-11 · S/N 11-453 · Built 1948 · Minot, ND
- [N5528N](https://openairdocs.org/aircraft/N5528N.md): North American P-51C · S/N 2925 · Built 1948 · Minot, ND
- [N7739M](https://openairdocs.org/aircraft/N7739M.md): Mooney M22 · S/N 700006 · Built 1970 · Minot, ND
- [N811B](https://openairdocs.org/aircraft/N811B.md): Luscombe 8F · S/N 6741 · Built 1950 · Minot, ND
- [N985SW](https://openairdocs.org/aircraft/N985SW.md): Beech D17S · S/N 4870 · Built 1943 · Minot, ND
- [N9NV](https://openairdocs.org/aircraft/N9NV.md): Let BLANIK L-13 · S/N 175220 · Built 1972 · Minot, ND

## 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_name = 'PIETSCH WARREN A' OR list_contains(g.other_registrant_names, 'PIETSCH WARREN A')
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-owner/PIETSCH%20WARREN%20A/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.
