# Registered aircraft: Cotulla, TX

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

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

- [N1953R](https://openairdocs.org/aircraft/N1953R.md): Robinson Helicopter R44 · S/N 30018 · Smith Helicopters Inc
- [N210WC](https://openairdocs.org/aircraft/N210WC.md): Cessna T210N · S/N 21064759 · Built 1982 · Weeks Curtis E
- [N28HH](https://openairdocs.org/aircraft/N28HH.md): Robinson Helicopter R44 II · S/N 12414 · Built 2008 · Smith Helicopters Inc
- [N3021X](https://openairdocs.org/aircraft/N3021X.md): Cessna 150F · S/N 15064421 · May'S Welding Service Inc
- [N3100B](https://openairdocs.org/aircraft/N3100B.md): Beech F33A · S/N CE-1789 · Built 1994 · Leone James Frank
- [N315G](https://openairdocs.org/aircraft/N315G.md): Beech 95-B55 (T42A) · S/N TC-907 · Built 1965 · Vancleve Cole
- [N344JG](https://openairdocs.org/aircraft/N344JG.md): Robinson Helicopter R44 II · S/N 12128 · Built 2008 · Smith Helicopters Inc
- [N34592](https://openairdocs.org/aircraft/N34592.md): Cessna 177B · S/N 17701889 · Built 1973 · Van Cleve Cole
- [N58208](https://openairdocs.org/aircraft/N58208.md): Hughes 269C · S/N 390780 · Built 1979 · Smith Helicopter Inc
- [N584AB](https://openairdocs.org/aircraft/N584AB.md): Robinson Helicopter R44 II · S/N 13017 · Built 2010 · Smith Helicopters Inc
- [N63130](https://openairdocs.org/aircraft/N63130.md): Cessna 180K · S/N 18052831 · Box Talon
- [N7031A](https://openairdocs.org/aircraft/N7031A.md): Robinson Helicopter R22 BETA · S/N 2892 · Built 1998 · Smith Helicopters Inc
- [N7419F](https://openairdocs.org/aircraft/N7419F.md): Hughes 269C · S/N 670606 · Built 1977 · Smith Helicopters Inc
- [N811S](https://openairdocs.org/aircraft/N811S.md): Robinson Helicopter R44 · S/N 30072 · Built 2020 · Smith Helicopters Inc
- [N834SH](https://openairdocs.org/aircraft/N834SH.md): Robinson Helicopter R22 BETA · S/N 3800 · Built 2005 · Smith Helicopters Inc
- [N8547F](https://openairdocs.org/aircraft/N8547F.md): Piper PA-34-200T · S/N 34-7770090 · Built 1976 · Page Elton T III
- [N9282F](https://openairdocs.org/aircraft/N9282F.md): Hughes 269C · S/N 340289 · Built 1974 · Box Helicopters Inc
- [N981SH](https://openairdocs.org/aircraft/N981SH.md): Robinson Helicopter R22 BETA · S/N 2791 · Built 1998 · Smith Helicopters Inc

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

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