# Registered aircraft: TCDS A-787

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

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

- [Alon A2](https://openairdocs.org/model/alon-a2.md): 144 registered aircraft · Registry code 0540102
- [Ercoupe 415-D](https://openairdocs.org/model/ercoupe-415-d.md): 101 registered aircraft · Registry code 0420326
- [Forney F-1](https://openairdocs.org/model/forney-f-1.md): 50 registered aircraft · Registry code 0420202
- [Mooney M10](https://openairdocs.org/model/mooney-m10.md): 39 registered aircraft · Registry code 5872018
- [Engineering & Research 415-D](https://openairdocs.org/model/engineering-research-415-d.md): 24 registered aircraft · Registry code 0420306
- [Alon A-2A](https://openairdocs.org/model/alon-a-2a.md): 21 registered aircraft · Registry code 0540104
- [Ercoupe 415-E](https://openairdocs.org/model/ercoupe-415-e.md): 18 registered aircraft · Registry code 0420328
- [Aircoupe F-1A](https://openairdocs.org/model/aircoupe-f-1a.md): 10 registered aircraft · Registry code 0420104
- [Forney F-1A](https://openairdocs.org/model/forney-f-1a.md): 8 registered aircraft · Registry code 0420204
- [Engineering & Research 415-E](https://openairdocs.org/model/engineering-research-415-e.md): 7 registered aircraft · Registry code 0420308
- [Erco 415-D](https://openairdocs.org/model/erco-415-d.md): 4 registered aircraft · Registry code 0420406
- [Mooney A-2A](https://openairdocs.org/model/mooney-a-2a.md): 4 registered aircraft · Registry code 5872014
- [Engineering & Research 415-G](https://openairdocs.org/model/engineering-research-415-g.md): 3 registered aircraft · Registry code 0420310
- [Ercoupe 415-G](https://openairdocs.org/model/ercoupe-415-g.md): 3 registered aircraft · Registry code 0420330
- [Forney 415-D](https://openairdocs.org/model/forney-415-d.md): 2 registered aircraft · Registry code 0420336
- [Forney 415-E](https://openairdocs.org/model/forney-415-e.md): 1 registered aircraft · Registry code 0420338
- [Univair 415-D](https://openairdocs.org/model/univair-415-d.md): 1 registered aircraft · Registry code 9230411
- [Erco 415-E](https://openairdocs.org/model/erco-415-e.md): 0 registered aircraft · Registry code 0420408
- [Erco 415-G](https://openairdocs.org/model/erco-415-g.md): 0 registered aircraft · Registry code 0420410

## 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 'aircraft' AS kind, m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
WHERE m.code IN (SELECT code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' WHERE tcds_number = 'A-787')
GROUP BY ALL
ORDER BY aircraft DESC, code
```

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