# Registered aircraft: TCDS E-304

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

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

- [Lycoming VO-540 series](https://openairdocs.org/engine/lycoming-vo-540-series.md): 110 registered aircraft · Registry codes 41534, 41582
- [Lycoming VO-540-C2A](https://openairdocs.org/engine/lycoming-vo-540-c2a.md): 6 registered aircraft · Registry code 42244
- [Lycoming VO-540-B1B3](https://openairdocs.org/engine/lycoming-vo-540-b1b3.md): 3 registered aircraft · Registry code 42232
- [Lycoming VO-540-A1A](https://openairdocs.org/engine/lycoming-vo-540-a1a.md): 0 registered aircraft · Registry code 42228
- [Lycoming VO-540-A2A](https://openairdocs.org/engine/lycoming-vo-540-a2a.md): 0 registered aircraft · Registry code 42229
- [Lycoming VO-540-B1A](https://openairdocs.org/engine/lycoming-vo-540-b1a.md): 0 registered aircraft · Registry code 42230
- [Lycoming VO-540-B1B](https://openairdocs.org/engine/lycoming-vo-540-b1b.md): 0 registered aircraft · Registry code 42231
- [Lycoming VO-540-B1C](https://openairdocs.org/engine/lycoming-vo-540-b1c.md): 0 registered aircraft · Registry code 42233
- [Lycoming VO-540-B1D](https://openairdocs.org/engine/lycoming-vo-540-b1d.md): 0 registered aircraft · Registry code 42238
- [Lycoming VO-540-B1E](https://openairdocs.org/engine/lycoming-vo-540-b1e.md): 0 registered aircraft · Registry code 42239
- [Lycoming VO-540-B1F](https://openairdocs.org/engine/lycoming-vo-540-b1f.md): 0 registered aircraft · Registry code 42234
- [Lycoming VO-540-B1H3](https://openairdocs.org/engine/lycoming-vo-540-b1h3.md): 0 registered aircraft · Registry code 42235
- [Lycoming VO-540-B2A](https://openairdocs.org/engine/lycoming-vo-540-b2a.md): 0 registered aircraft · Registry code 42236
- [Lycoming VO-540-B2C](https://openairdocs.org/engine/lycoming-vo-540-b2c.md): 0 registered aircraft · Registry code 42237
- [Lycoming VO-540-B2D](https://openairdocs.org/engine/lycoming-vo-540-b2d.md): 0 registered aircraft · Registry code 42240
- [Lycoming VO-540-B2E](https://openairdocs.org/engine/lycoming-vo-540-b2e.md): 0 registered aircraft · Registry code 42241
- [Lycoming VO-540-C1A](https://openairdocs.org/engine/lycoming-vo-540-c1a.md): 0 registered aircraft · Registry code 42242
- [Lycoming VO-540-C1B](https://openairdocs.org/engine/lycoming-vo-540-c1b.md): 0 registered aircraft · Registry code 42243
- [Lycoming VO-540-C1C3](https://openairdocs.org/engine/lycoming-vo-540-c1c3.md): 0 registered aircraft · Registry code 42247
- [Lycoming VO-540-C2B](https://openairdocs.org/engine/lycoming-vo-540-c2b.md): 0 registered aircraft · Registry code 42245
- [Lycoming VO540-C2C](https://openairdocs.org/engine/lycoming-vo540-c2c.md): 0 registered aircraft · Registry code 42246

## 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-304')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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