# Registered aircraft: Clayton Harry L

A list on [Clayton Harry L](https://openairdocs.org/faa-owner/CLAYTON%20HARRY%20L.md).

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

- [N108A](https://openairdocs.org/aircraft/N108A.md): Schempp-Hirth STANDARD CIRRUS · S/N 140 · Built 1971 · Wichita, KS
- [N117LP](https://openairdocs.org/aircraft/N117LP.md): Hassell LP-49 · S/N 54K · Wichita, KS
- [N1196](https://openairdocs.org/aircraft/N1196.md): Schleicher K 8 B · S/N 8573 · Built 1966 · Wichita, KS
- [N1346D](https://openairdocs.org/aircraft/N1346D.md): Scheibe L SPATZ-55 · S/N 777 · Wichita, KS
- [N371T](https://openairdocs.org/aircraft/N371T.md): Schleicher K 6 CR-PE · S/N 6142 · Built 1963 · Wichita, KS
- [N40278](https://openairdocs.org/aircraft/N40278.md): Schweizer SGU-1-19A · S/N 52A · Built 1947 · Wichita, KS
- [N4663S](https://openairdocs.org/aircraft/N4663S.md): Schleicher K 8 B · S/N 8213 · Wichita, KS
- [N5047K](https://openairdocs.org/aircraft/N5047K.md): Breigleb BG-12B · S/N 12059 · Built 1965 · Wichita, KS
- [N608A](https://openairdocs.org/aircraft/N608A.md): Schleicher Alexander K 7 · S/N 536 · Wichita, KS
- [N631G](https://openairdocs.org/aircraft/N631G.md): Briegleb BG 12B · S/N 21 · Wichita, KS
- [N7476](https://openairdocs.org/aircraft/N7476.md): Slingsby SWALLOW TYPE T.45 · S/N 1660 · Built 1968 · Wichita, KS
- [N779A](https://openairdocs.org/aircraft/N779A.md): Schleicher KA 7 · S/N 7151 · Wichita, KS
- [N7887C](https://openairdocs.org/aircraft/N7887C.md): Schempp-Hirth STANDARD AUSTRIA S · S/N 33 · Wichita, KS
- [N8747](https://openairdocs.org/aircraft/N8747.md): Schempp-Hirth KA8B · S/N SH8639 · Built 1970 · Wichita, KS
- [N91274](https://openairdocs.org/aircraft/N91274.md): Schleicher K 8 B · S/N 8433-SH · Wichita, KS
- [N91850](https://openairdocs.org/aircraft/N91850.md): Schweizer SGU-1-19 · S/N 27A · Built 1946 · Wichita, KS

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

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