# Registered aircraft: TCDS A3WE

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

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

- [Boeing 727-223](https://openairdocs.org/model/boeing-727-223.md): 9 registered aircraft · Registry code 1384074
- [Boeing 727-227](https://openairdocs.org/model/boeing-727-227.md): 4 registered aircraft · Registry code 1384078
- [Boeing 727-225](https://openairdocs.org/model/boeing-727-225.md): 2 registered aircraft · Registry code 1384077
- [Boeing 727-200](https://openairdocs.org/model/boeing-727-200.md): 1 registered aircraft · Registry code 138407E
- [Boeing 727-200F](https://openairdocs.org/model/boeing-727-200f.md): 1 registered aircraft · Registry code 1384060
- [Boeing 727-212](https://openairdocs.org/model/boeing-727-212.md): 1 registered aircraft · Registry code 138407G
- [Boeing 727-230](https://openairdocs.org/model/boeing-727-230.md): 1 registered aircraft · Registry code 1384080
- [Boeing 727-232](https://openairdocs.org/model/boeing-727-232.md): 1 registered aircraft · Registry code 1384082
- [Boeing 727-243](https://openairdocs.org/model/boeing-727-243.md): 1 registered aircraft · Registry code 138408D
- [Boeing 727-247](https://openairdocs.org/model/boeing-727-247.md): 1 registered aircraft · Registry code 138408F
- [Boeing 727-264](https://openairdocs.org/model/boeing-727-264.md): 1 registered aircraft · Registry code 138408M
- [Boeing 727-277](https://openairdocs.org/model/boeing-727-277.md): 1 registered aircraft · Registry code 138408S
- [Boeing 727-281](https://openairdocs.org/model/boeing-727-281.md): 1 registered aircraft · Registry code 138408N
- [Boeing 727](https://openairdocs.org/model/boeing-727.md): 0 registered aircraft · Registry code 1384001
- [Boeing 727-100](https://openairdocs.org/model/boeing-727-100.md): 0 registered aircraft · Registry code 1384036
- [Boeing 727-100C](https://openairdocs.org/model/boeing-727-100c.md): 0 registered aircraft · Registry code 1384037
- [Boeing 727-108C](https://openairdocs.org/model/boeing-727-108c.md): 0 registered aircraft · Registry code 1384039
- [Boeing 727-109](https://openairdocs.org/model/boeing-727-109.md): 0 registered aircraft · Registry code 1384033
- [Boeing 727-109C](https://openairdocs.org/model/boeing-727-109c.md): 0 registered aircraft · Registry code 1384034
- [Boeing 727-113C](https://openairdocs.org/model/boeing-727-113c.md): 0 registered aircraft · Registry code 1384038
- [Boeing 727-114](https://openairdocs.org/model/boeing-727-114.md): 0 registered aircraft · Registry code 1384040
- [Boeing 727-116](https://openairdocs.org/model/boeing-727-116.md): 0 registered aircraft · Registry code 1384043
- [Boeing 727-116C](https://openairdocs.org/model/boeing-727-116c.md): 0 registered aircraft · Registry code 1384046
- [Boeing 727-121C](https://openairdocs.org/model/boeing-727-121c.md): 0 registered aircraft · Registry code 138404I
- [Boeing 727-123](https://openairdocs.org/model/boeing-727-123.md): 0 registered aircraft · Registry code 138404G
- [Boeing 727-134](https://openairdocs.org/model/boeing-727-134.md): 0 registered aircraft · Registry code 1384041
- [Boeing 727-134C](https://openairdocs.org/model/boeing-727-134c.md): 0 registered aircraft · Registry code 138404H
- [Boeing 727-151C](https://openairdocs.org/model/boeing-727-151c.md): 0 registered aircraft · Registry code 138404V
- [Boeing 727-155C](https://openairdocs.org/model/boeing-727-155c.md): 0 registered aircraft · Registry code 138404Z
- [Boeing 727-162](https://openairdocs.org/model/boeing-727-162.md): 0 registered aircraft · Registry code 1384056
- [Boeing 727-172C](https://openairdocs.org/model/boeing-727-172c.md): 0 registered aircraft · Registry code 1384058
- [Boeing 727-173C](https://openairdocs.org/model/boeing-727-173c.md): 0 registered aircraft · Registry code 1384059
- [Boeing 727-180C](https://openairdocs.org/model/boeing-727-180c.md): 0 registered aircraft · Registry code 138406G
- [Boeing 727-185C](https://openairdocs.org/model/boeing-727-185c.md): 0 registered aircraft · Registry code 138406N
- [Boeing 727-191](https://openairdocs.org/model/boeing-727-191.md): 0 registered aircraft · Registry code 1384063
- [Boeing 727-193](https://openairdocs.org/model/boeing-727-193.md): 0 registered aircraft · Registry code 138406Z
- [Boeing 727-208](https://openairdocs.org/model/boeing-727-208.md): 0 registered aircraft · Registry code 1384070
- [Boeing 727-214](https://openairdocs.org/model/boeing-727-214.md): 0 registered aircraft · Registry code 138407R
- [Boeing 727-217](https://openairdocs.org/model/boeing-727-217.md): 0 registered aircraft · Registry code 1384061
- [Boeing 727-221](https://openairdocs.org/model/boeing-727-221.md): 0 registered aircraft · Registry code 1384071
- [Boeing 727-222](https://openairdocs.org/model/boeing-727-222.md): 0 registered aircraft · Registry code 1384073
- [Boeing 727-224](https://openairdocs.org/model/boeing-727-224.md): 0 registered aircraft · Registry code 1384076
- [Boeing 727-228](https://openairdocs.org/model/boeing-727-228.md): 0 registered aircraft · Registry code 1384083
- [Boeing 727-231](https://openairdocs.org/model/boeing-727-231.md): 0 registered aircraft · Registry code 1384079
- [Boeing 727-233](https://openairdocs.org/model/boeing-727-233.md): 0 registered aircraft · Registry code 138408A
- [Boeing 727-235](https://openairdocs.org/model/boeing-727-235.md): 0 registered aircraft · Registry code 138408B
- [Boeing 727-251](https://openairdocs.org/model/boeing-727-251.md): 0 registered aircraft · Registry code 138408H
- [Boeing 727-254](https://openairdocs.org/model/boeing-727-254.md): 0 registered aircraft · Registry code 138408L
- [Boeing 727-256](https://openairdocs.org/model/boeing-727-256.md): 0 registered aircraft · Registry code 1384062
- [Boeing 727-259](https://openairdocs.org/model/boeing-727-259.md): 0 registered aircraft · Registry code 138408J
- [Boeing 727-260](https://openairdocs.org/model/boeing-727-260.md): 0 registered aircraft · Registry code 138408K
- [Boeing 727-269](https://openairdocs.org/model/boeing-727-269.md): 0 registered aircraft · Registry code 1384064
- [Boeing 727-270](https://openairdocs.org/model/boeing-727-270.md): 0 registered aircraft · Registry code 138408P
- [Boeing 727-276](https://openairdocs.org/model/boeing-727-276.md): 0 registered aircraft · Registry code 138408R
- [Boeing 727-282](https://openairdocs.org/model/boeing-727-282.md): 0 registered aircraft · Registry code 138408T
- [Boeing 727-284](https://openairdocs.org/model/boeing-727-284.md): 0 registered aircraft · Registry code 1384065
- [Boeing 727-286](https://openairdocs.org/model/boeing-727-286.md): 0 registered aircraft · Registry code 1384066
- [Boeing 727-287](https://openairdocs.org/model/boeing-727-287.md): 0 registered aircraft · Registry code 1384020
- [Boeing 727-290](https://openairdocs.org/model/boeing-727-290.md): 0 registered aircraft · Registry code 138408W
- [Boeing 727-291](https://openairdocs.org/model/boeing-727-291.md): 0 registered aircraft · Registry code 138408X
- [Boeing 727-294](https://openairdocs.org/model/boeing-727-294.md): 0 registered aircraft · Registry code 1384088
- [Boeing 727-295](https://openairdocs.org/model/boeing-727-295.md): 0 registered aircraft · Registry code 1384075
- [Boeing 727-C](https://openairdocs.org/model/boeing-727-c.md): 0 registered aircraft · Registry code 1384022

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

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