# Registered aircraft: TCDS A15SO

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

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

- [Adams Balloon A55S](https://openairdocs.org/model/adams-balloon-a55s.md): 35 registered aircraft · Registry code 0050105
- [Adams Balloon A55](https://openairdocs.org/model/adams-balloon-a55.md): 24 registered aircraft · Registry code 0050103
- [Adams Balloons A-B](https://openairdocs.org/model/adams-balloons-a-b.md): 14 registered aircraft · Registry code 0050325
- [Adams Balloon A50S](https://openairdocs.org/model/adams-balloon-a50s.md): 10 registered aircraft · Registry code 0050101
- [Adams Balloons A55S](https://openairdocs.org/model/adams-balloons-a55s.md): 10 registered aircraft · Registry code 0050355
- [Adams Balloons A60-S](https://openairdocs.org/model/adams-balloons-a60-s.md): 10 registered aircraft · Registry code 0050360
- [Andrew Philip Richardson DBA A-B](https://openairdocs.org/model/andrew-philip-richardson-dba-a-b.md): 10 registered aircraft · Registry code 0050050
- [Andrew Philip Richardson DBA A55S](https://openairdocs.org/model/andrew-philip-richardson-dba-a55s.md): 8 registered aircraft · Registry code 0050055
- [Andrew Philip Richardson DBA A-60S](https://openairdocs.org/model/andrew-philip-richardson-dba-a-60s.md): 7 registered aircraft · Registry code 0050060
- [Adams Balloon A B](https://openairdocs.org/model/adams-balloon-a-b.md): 6 registered aircraft · Registry code 0050100
- [Adams Balloon L D-S](https://openairdocs.org/model/adams-balloon-l-d-s.md): 3 registered aircraft · Registry code 0050204
- [Adams Balloon Loft A-60S](https://openairdocs.org/model/adams-balloon-loft-a-60s.md): 3 registered aircraft · Registry code 0066360
- [Adams Balloons A55](https://openairdocs.org/model/adams-balloons-a55.md): 2 registered aircraft · Registry code 0050350
- [Elizabeth Adams Walz A60S](https://openairdocs.org/model/elizabeth-adams-walz-a60s.md): 2 registered aircraft · Registry code 0050460
- [Adams Balloon Loft A55S](https://openairdocs.org/model/adams-balloon-loft-a55s.md): 1 registered aircraft · Registry code 0066350
- [Adams Balloons LD S](https://openairdocs.org/model/adams-balloons-ld-s.md): 1 registered aircraft · Registry code 0050365
- [Andrew Philip Richardson DBA LD S](https://openairdocs.org/model/andrew-philip-richardson-dba-ld-s.md): 1 registered aircraft · Registry code 0050070
- [Adams Balloon Loft A50S](https://openairdocs.org/model/adams-balloon-loft-a50s.md): 0 registered aircraft · Registry code 0066355
- [Andrew Philip Richardson DBA A55](https://openairdocs.org/model/andrew-philip-richardson-dba-a55.md): 0 registered aircraft · Registry code 005005A
- [Elizabeth Adams Walz A55S](https://openairdocs.org/model/elizabeth-adams-walz-a55s.md): 0 registered aircraft · Registry code 0050450

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

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