# Registered aircraft: TCDS E-228

A list on [TCDS E-228](https://openairdocs.org/tcds/E-228.md).

Registry models that point at this data sheet: 144 registered aircraft in all. Each model’s page lists its aircraft.

- [Lycoming 0-435](https://openairdocs.org/engine/lycoming-0-435.md): 87 registered aircraft · Registry code 41516
- [Lycoming GO-435](https://openairdocs.org/engine/lycoming-go-435.md): 33 registered aircraft · Registry codes 41520, 42072
- [Lycoming GO-435-C2A2](https://openairdocs.org/engine/lycoming-go-435-c2a2.md): 5 registered aircraft · Registry code 42076
- [Lycoming GO-435-C2B2](https://openairdocs.org/engine/lycoming-go-435-c2b2.md): 5 registered aircraft · Registry code 42079
- [Lycoming O-435-C](https://openairdocs.org/engine/lycoming-o-435-c.md): 5 registered aircraft · Registry code 42070
- [Lycoming 0-435B](https://openairdocs.org/engine/lycoming-0-435b.md): 3 registered aircraft · Registry code 41519
- [Lycoming GO-435-C2](https://openairdocs.org/engine/lycoming-go-435-c2.md): 2 registered aircraft · Registry code 42074
- [Lycoming GO-435-C2A](https://openairdocs.org/engine/lycoming-go-435-c2a.md): 2 registered aircraft · Registry code 42075
- [Lycoming GO-435-C2B](https://openairdocs.org/engine/lycoming-go-435-c2b.md): 1 registered aircraft · Registry code 42077
- [Lycoming O-435](https://openairdocs.org/engine/lycoming-o-435.md): 1 registered aircraft · Registry code 42063
- [Lycoming GO-435-C2B1](https://openairdocs.org/engine/lycoming-go-435-c2b1.md): 0 registered aircraft · Registry code 42078
- [Lycoming GO-435-C2C](https://openairdocs.org/engine/lycoming-go-435-c2c.md): 0 registered aircraft · Registry code 42080
- [Lycoming GO-435-C2D](https://openairdocs.org/engine/lycoming-go-435-c2d.md): 0 registered aircraft · Registry code 42081
- [Lycoming GO-435-C2E](https://openairdocs.org/engine/lycoming-go-435-c2e.md): 0 registered aircraft · Registry code 42082
- [Lycoming GO-435-D1](https://openairdocs.org/engine/lycoming-go-435-d1.md): 0 registered aircraft · Registry code 42073
- [Lycoming O-435-A](https://openairdocs.org/engine/lycoming-o-435-a.md): 0 registered aircraft · Registry code 42068
- [Lycoming O-435-A2](https://openairdocs.org/engine/lycoming-o-435-a2.md): 0 registered aircraft · Registry code 42065
- [Lycoming O-435-B](https://openairdocs.org/engine/lycoming-o-435-b.md): 0 registered aircraft · Registry code 42064
- [Lycoming O-435-C1](https://openairdocs.org/engine/lycoming-o-435-c1.md): 0 registered aircraft · Registry code 42069
- [Lycoming O-435-C2](https://openairdocs.org/engine/lycoming-o-435-c2.md): 0 registered aircraft · Registry code 42071
- [Lycoming O-435-K](https://openairdocs.org/engine/lycoming-o-435-k.md): 0 registered aircraft · Registry code 42066
- [Lycoming O-435-K1](https://openairdocs.org/engine/lycoming-o-435-k1.md): 0 registered aircraft · Registry code 42067

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
-- One row per registry model code; the page joins codes that share a name
SELECT 'engine' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.engine_model_code = m.code
WHERE m.code IN (SELECT code FROM 'https://openairdocs.org/data/latest/faa_engine_model.parquet' WHERE tcds_number = 'E-228')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

This list as a web page: https://openairdocs.org/tcds/E-228/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.