# Registered aircraft: TCDS A13NM

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

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

- [Bombardier DHC-8-402](https://openairdocs.org/model/bombardier-dhc-8-402.md): 26 registered aircraft · Registry code 1390042
- [Dehavilland DHC-8-202](https://openairdocs.org/model/dehavilland-dhc-8-202.md): 17 registered aircraft · Registry code 2809007
- [Bombardier DHC-8-315](https://openairdocs.org/model/bombardier-dhc-8-315.md): 15 registered aircraft · Registry code 1390043
- [Bombardier DHC-8-202](https://openairdocs.org/model/bombardier-dhc-8-202.md): 14 registered aircraft · Registry code 1390007
- [Dehavilland DHC-8-106](https://openairdocs.org/model/dehavilland-dhc-8-106.md): 4 registered aircraft · Registry code 2809020
- [Boeing DHC-8-102](https://openairdocs.org/model/boeing-dhc-8-102.md): 3 registered aircraft · Registry code 1386002
- [Boeing Of Canada/Dehav Div DHC-8-311](https://openairdocs.org/model/boeing-of-canada-dehav-div-dhc-8-311.md): 3 registered aircraft · Registry code 1386006
- [Boeing Of Canada/Dehav Div DHC-8-106](https://openairdocs.org/model/boeing-of-canada-dehav-div-dhc-8-106.md): 2 registered aircraft · Registry code 1386020
- [Bombardier DHC-8-201](https://openairdocs.org/model/bombardier-dhc-8-201.md): 2 registered aircraft · Registry code 1390004
- [Dehavilland DHC-8-103](https://openairdocs.org/model/dehavilland-dhc-8-103.md): 2 registered aircraft · Registry code 2809006
- [Dehavilland DHC-8-201](https://openairdocs.org/model/dehavilland-dhc-8-201.md): 2 registered aircraft · Registry code 2809001
- [Dehavilland DHC-8-315](https://openairdocs.org/model/dehavilland-dhc-8-315.md): 2 registered aircraft · Registry code 2809010
- [Boeing Of Canada/Dehav Div DHC-8-102](https://openairdocs.org/model/boeing-of-canada-dehav-div-dhc-8-102.md): 1 registered aircraft · Registry code 1385303
- [Bombardier DHC-8-300](https://openairdocs.org/model/bombardier-dhc-8-300.md): 1 registered aircraft · Registry code 1390011
- [Dehavilland DHC-8-102](https://openairdocs.org/model/dehavilland-dhc-8-102.md): 1 registered aircraft · Registry code 2809003
- [Boeing / Dehavilland DHC-8-103](https://openairdocs.org/model/boeing-dehavilland-dhc-8-103.md): 0 registered aircraft · Registry code 1386005
- [Boeing DHC-8-301](https://openairdocs.org/model/boeing-dhc-8-301.md): 0 registered aircraft · Registry code 1386003
- [Boeing Of Canada DHC-8-102](https://openairdocs.org/model/boeing-of-canada-dhc-8-102.md): 0 registered aircraft · Registry code 1385305
- [Boeing Of Canada/Dehav Div DHC-8-315](https://openairdocs.org/model/boeing-of-canada-dehav-div-dhc-8-315.md): 0 registered aircraft · Registry code 1386107
- [Boeing/Canada DHC-8-301](https://openairdocs.org/model/boeing-canada-dhc-8-301.md): 0 registered aircraft · Registry code 1386007
- [Bombardier DHC-8-100 SER](https://openairdocs.org/model/bombardier-dhc-8-100-ser.md): 0 registered aircraft · Registry code 1390000
- [Bombardier DHC-8-101](https://openairdocs.org/model/bombardier-dhc-8-101.md): 0 registered aircraft · Registry code 1390001
- [Bombardier DHC-8-102](https://openairdocs.org/model/bombardier-dhc-8-102.md): 0 registered aircraft · Registry code 1390002
- [Bombardier DHC-8-103](https://openairdocs.org/model/bombardier-dhc-8-103.md): 0 registered aircraft · Registry code 1390003
- [Bombardier DHC-8-106](https://openairdocs.org/model/bombardier-dhc-8-106.md): 0 registered aircraft · Registry code 1390012
- [Bombardier DHC-8-311](https://openairdocs.org/model/bombardier-dhc-8-311.md): 0 registered aircraft · Registry code 1390010
- [Bombardier DHC-8-401](https://openairdocs.org/model/bombardier-dhc-8-401.md): 0 registered aircraft · Registry code 1390041
- [Dehavilland Acft Of Canada DHC-8-402](https://openairdocs.org/model/dehavilland-acft-of-canada-dhc-8-402.md): 0 registered aircraft · Registry code 2805090
- [Dehavilland DHC 8 200](https://openairdocs.org/model/dehavilland-dhc-8-200.md): 0 registered aircraft · Registry code 2809004
- [Dehavilland DHC-8-100 SERIES](https://openairdocs.org/model/dehavilland-dhc-8-100-series.md): 0 registered aircraft · Registry code 2802602
- [Dehavilland DHC-8-101](https://openairdocs.org/model/dehavilland-dhc-8-101.md): 0 registered aircraft · Registry code 2809002
- [Dehavilland DHC-8-300 SERIES](https://openairdocs.org/model/dehavilland-dhc-8-300-series.md): 0 registered aircraft · Registry code 2809008
- [Dehavilland DHC-8-301](https://openairdocs.org/model/dehavilland-dhc-8-301.md): 0 registered aircraft · Registry code 2809011
- [Dehavilland DHC-8-311](https://openairdocs.org/model/dehavilland-dhc-8-311.md): 0 registered aircraft · Registry code 2809005
- [Dehavilland DHC-8-400](https://openairdocs.org/model/dehavilland-dhc-8-400.md): 0 registered aircraft · Registry code 2802413
- [Dehavilland DHC-8-401](https://openairdocs.org/model/dehavilland-dhc-8-401.md): 0 registered aircraft · Registry code 2809041
- [Dehavilland DHC-8-402](https://openairdocs.org/model/dehavilland-dhc-8-402.md): 0 registered aircraft · Registry code 2800942

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

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