# Registered aircraft: Schmitt Rudy

A list on [Schmitt Rudy](https://openairdocs.org/faa-owner/SCHMITT%20RUDY.md).

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

- [N11149](https://openairdocs.org/aircraft/N11149.md): Cessna 150L · S/N 15075225 · Brookshire, TX
- [N1854V](https://openairdocs.org/aircraft/N1854V.md): Cessna 172M · S/N 17263771 · Built 1974 · Brookshire, TX
- [N22110](https://openairdocs.org/aircraft/N22110.md): Cessna 150H · S/N 15068066 · Brookshire, TX
- [N2490J](https://openairdocs.org/aircraft/N2490J.md): Cessna 150G · S/N 15065590 · Built 1966 · Brookshire, TX
- [N2821V](https://openairdocs.org/aircraft/N2821V.md): Beech 35 · S/N D-225 · Built 1947 · Brookshire, TX
- [N3916S](https://openairdocs.org/aircraft/N3916S.md): Cessna 172E · S/N 17251116 · Built 1964 · Brookshire, TX
- [N3989Y](https://openairdocs.org/aircraft/N3989Y.md): Cessna 210D · S/N 21058489 · Built 1964 · Brookshire, TX
- [N4966Y](https://openairdocs.org/aircraft/N4966Y.md): Piper PA-25-235 · S/N 25-4767 · Built 1968 · Brookshire, TX
- [N50079](https://openairdocs.org/aircraft/N50079.md): Cessna 150H · S/N 15069051 · Built 1968 · Brookshire, TX
- [N5722G](https://openairdocs.org/aircraft/N5722G.md): Cessna 150K · S/N 15071222 · Built 1969 · Bulverde, TX
- [N604V](https://openairdocs.org/aircraft/N604V.md): Beech 35-33 · S/N CD-124 · Built 1960 · Brookshire, TX
- [N66718](https://openairdocs.org/aircraft/N66718.md): Cessna 150M · S/N 15076232 · Built 1974 · Brookshire, TX
- [N670W](https://openairdocs.org/aircraft/N670W.md): Beech M35 · S/N D-6445 · Built 1960 · Brookshire, TX
- [N7128X](https://openairdocs.org/aircraft/N7128X.md): Cessna 150A · S/N 15059228 · Built 1961 · Brookshire, TX
- [N757HM](https://openairdocs.org/aircraft/N757HM.md): Cessna 152 · S/N 15279753 · Brookshire, TX
- [N8086V](https://openairdocs.org/aircraft/N8086V.md): Cessna 188 · S/N 188-0336 · Brookshire, TX
- [N8147V](https://openairdocs.org/aircraft/N8147V.md): Cessna A188 · S/N 188-0397 · Built 1968 · Brookshire, TX
- [N8421Z](https://openairdocs.org/aircraft/N8421Z.md): Cessna 210-5(205) · S/N 2050421 · Built 1963 · Brookshire, TX
- [N9629G](https://openairdocs.org/aircraft/N9629G.md): Cessna A188B · S/N 18801570 · Built 1974 · Brookshire, TX
- [N9703J](https://openairdocs.org/aircraft/N9703J.md): Cessna A188B · S/N 18803841T · Built 1981 · Brookshire, TX
- [N9881E](https://openairdocs.org/aircraft/N9881E.md): Cessna 182P · S/N 18263942 · Bulverde, TX

## 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 = 'SCHMITT RUDY' OR list_contains(g.other_registrant_names, 'SCHMITT RUDY')
ORDER BY g.n_number
```

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