# Registered aircraft: TCDS E-307

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

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

- [Rolls-Royce AVON](https://openairdocs.org/engine/rolls-royce-avon-series.md): 2 registered aircraft · Registry code 54520
- [Rolls-Royce AVON-532R](https://openairdocs.org/engine/rolls-royce-avon-532r-series.md): 2 registered aircraft · Registry code 54517
- [Bristol Si AVON-522](https://openairdocs.org/engine/bristol-si-avon-522.md): 0 registered aircraft · Registry code 10185
- [Bristol Si AVON-524B](https://openairdocs.org/engine/bristol-si-avon-524b.md): 0 registered aircraft · Registry code 10186
- [Bristol Si AVON-525B](https://openairdocs.org/engine/bristol-si-avon-525b.md): 0 registered aircraft · Registry code 10187
- [Bristol Si AVON-526](https://openairdocs.org/engine/bristol-si-avon-526.md): 0 registered aircraft · Registry code 10188
- [Bristol Si AVON-527](https://openairdocs.org/engine/bristol-si-avon-527.md): 0 registered aircraft · Registry code 10189
- [Bristol Si AVON-531](https://openairdocs.org/engine/bristol-si-avon-531.md): 0 registered aircraft · Registry code 10190
- [Bristol Si AVON-532R-B](https://openairdocs.org/engine/bristol-si-avon-532r-b.md): 0 registered aircraft · Registry code 10191
- [Bristol Si AVON-533R](https://openairdocs.org/engine/bristol-si-avon-533r.md): 0 registered aircraft · Registry code 10192
- [Bristol Si AVON-533R-11A](https://openairdocs.org/engine/bristol-si-avon-533r-11a.md): 0 registered aircraft · Registry code 10193
- [Rolls-Royce AVON-522](https://openairdocs.org/engine/rolls-royce-avon-522.md): 0 registered aircraft · Registry code 54108
- [Rolls-Royce AVON-524B](https://openairdocs.org/engine/rolls-royce-avon-524b.md): 0 registered aircraft · Registry code 54109
- [Rolls-Royce AVON-525B](https://openairdocs.org/engine/rolls-royce-avon-525b.md): 0 registered aircraft · Registry code 54110
- [Rolls-Royce AVON-526](https://openairdocs.org/engine/rolls-royce-avon-526.md): 0 registered aircraft · Registry code 54111
- [Rolls-Royce AVON-527](https://openairdocs.org/engine/rolls-royce-avon-527.md): 0 registered aircraft · Registry code 54112
- [Rolls-Royce AVON-531](https://openairdocs.org/engine/rolls-royce-avon-531.md): 0 registered aircraft · Registry code 54113
- [Rolls-Royce AVON-532R-B](https://openairdocs.org/engine/rolls-royce-avon-532r-b.md): 0 registered aircraft · Registry code 54114
- [Rolls-Royce AVON-533R](https://openairdocs.org/engine/rolls-royce-avon-533r.md): 0 registered aircraft · Registry code 54115
- [Rolls-Royce AVON-533R-11A](https://openairdocs.org/engine/rolls-royce-avon-533r-11a.md): 0 registered aircraft · Registry code 54116

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

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