# Registered aircraft: TCDS 1A2 A list on [TCDS 1A2](https://openairdocs.org/tcds/1A2.md). Registry models that point at this data sheet: 3,117 registered aircraft in all. Each model’s page lists its aircraft. - [Piper PA-18-150](https://openairdocs.org/model/piper-pa-18-150.md): 2,065 registered aircraft · Registry codes 7101828, 7104221 - [Piper PA-18](https://openairdocs.org/model/piper-pa-18.md): 477 registered aircraft · Registry code 7101802 - [Piper PA-18-135](https://openairdocs.org/model/piper-pa-18-135.md): 220 registered aircraft · Registry code 7101820 - [Piper PA-18-105 SPECIAL](https://openairdocs.org/model/piper-pa-18-105-special.md): 97 registered aircraft · Registry code 7101808 - [Piper PA-18-125](https://openairdocs.org/model/piper-pa-18-125.md): 90 registered aircraft · Registry code 7101812 - [Piper PA-18 105](https://openairdocs.org/model/piper-pa-18-105.md): 57 registered aircraft · Registry code 7101809 - [Piper/Cub Crafters PA-18-150](https://openairdocs.org/model/piper-cub-crafters-pa-18-150.md): 46 registered aircraft · Registry code 7101843 - [Cub Crafters PA18-150](https://openairdocs.org/model/cub-crafters-pa18-150.md): 16 registered aircraft · Registry code 2470000 - [Piper PA-19](https://openairdocs.org/model/piper-pa-19.md): 15 registered aircraft · Registry code 7101902 - [Piper PA-18S-150](https://openairdocs.org/model/piper-pa-18s-150.md): 6 registered aircraft · Registry code 7101832 - [Piper PA-18AS-125](https://openairdocs.org/model/piper-pa-18as-125.md): 5 registered aircraft · Registry code 7101816 - [Piper PA-18S](https://openairdocs.org/model/piper-pa-18s.md): 4 registered aircraft · Registry code 7101806 - [Piper PA-18S-135](https://openairdocs.org/model/piper-pa-18s-135.md): 3 registered aircraft · Registry code 7101826 - [Piper PA-18S-125](https://openairdocs.org/model/piper-pa-18s-125.md): 2 registered aircraft · Registry code 7101818 - [Cubs Unlimited/Piper PA 18-150](https://openairdocs.org/model/cubs-unlimited-piper-pa-18-150.md): 1 registered aircraft · Registry code 05617YI - [David B Piper PA18 REPLICA](https://openairdocs.org/model/david-b-piper-pa18-replica.md): 1 registered aircraft · Registry code 05639JS - [Kurt Lepping PA-18-150](https://openairdocs.org/model/kurt-lepping-pa-18-150.md): 1 registered aircraft · Registry code 7101847 - [Piper PA-18-125 A1](https://openairdocs.org/model/piper-pa-18-125-a1.md): 1 registered aircraft · Registry code 710181Z - [Piper PA-18-135 (L-21B)](https://openairdocs.org/model/piper-pa-18-135-l-21b.md): 1 registered aircraft · Registry code 7101821 - [Piper PA-18AS-135](https://openairdocs.org/model/piper-pa-18as-135.md): 1 registered aircraft · Registry code 7101824 - [Piper-Coley PA-18-125](https://openairdocs.org/model/piper-coley-pa-18-125.md): 1 registered aircraft · Registry code 7101817 - [Piper-Root PA-18 SUPER CUB](https://openairdocs.org/model/piper-root-pa-18-super-cub.md): 1 registered aircraft · Registry code 7101803 - [Piper/Gerbi Charles R PA 18-150](https://openairdocs.org/model/piper-gerbi-charles-r-pa-18-150.md): 1 registered aircraft · Registry code 7101851 - [Piper/Johnson C D PA-18 150](https://openairdocs.org/model/piper-johnson-c-d-pa-18-150.md): 1 registered aircraft · Registry code 7101840 - [Piper/Meyer Alfred R PA 18-150](https://openairdocs.org/model/piper-meyer-alfred-r-pa-18-150.md): 1 registered aircraft · Registry code 7101844 - [Piper/Snyder Matthew A PA-18-150](https://openairdocs.org/model/piper-snyder-matthew-a-pa-18-150.md): 1 registered aircraft · Registry code 7101848 - [Piper/Sorensen PA-18-150](https://openairdocs.org/model/piper-sorensen-pa-18-150.md): 1 registered aircraft · Registry code 7101829 - [Piper/White Theordore F PA-18-150](https://openairdocs.org/model/piper-white-theordore-f-pa-18-150.md): 1 registered aircraft · Registry code 7101833 - [Piper / Grant PA-18](https://openairdocs.org/model/piper-grant-pa-18.md): 0 registered aircraft · Registry code 7101819 - [Piper / Harris PA-18](https://openairdocs.org/model/piper-harris-pa-18.md): 0 registered aircraft · Registry code 7101823 - [Piper PA-18A](https://openairdocs.org/model/piper-pa-18a.md): 0 registered aircraft · Registry code 7102831 - [Piper PA-18AS-150](https://openairdocs.org/model/piper-pa-18as-150.md): 0 registered aircraft · Registry code 7101830 - [Piper PA-18S 105](https://openairdocs.org/model/piper-pa-18s-105.md): 0 registered aircraft · Registry code 7101811 - [Piper PA-18S-105 SPECIAL](https://openairdocs.org/model/piper-pa-18s-105-special.md): 0 registered aircraft · Registry code 7101810 - [Piper PA-19S](https://openairdocs.org/model/piper-pa-19s.md): 0 registered aircraft · Registry code 7101906 - [Piper/Cardinal Airmotive PA-18](https://openairdocs.org/model/piper-cardinal-airmotive-pa-18.md): 0 registered aircraft · Registry code 7101801 - [Piper/Durr Jerry PA 18-150](https://openairdocs.org/model/piper-durr-jerry-pa-18-150.md): 0 registered aircraft · Registry code 7101841 - [Piper/Ellis Wendell Kirk PA-18-150](https://openairdocs.org/model/piper-ellis-wendell-kirk-pa-18-150.md): 0 registered aircraft · Registry code 7101846 - [Piper/Howell PA-18](https://openairdocs.org/model/piper-howell-pa-18.md): 0 registered aircraft · Registry code 7101807 - [Piper/L A Air PA-18-150](https://openairdocs.org/model/piper-l-a-air-pa-18-150.md): 0 registered aircraft · Registry code 7101831 - [Piper/Mervyn Farm PA-18 180](https://openairdocs.org/model/piper-mervyn-farm-pa-18-180.md): 0 registered aircraft · Registry code 7101825 - [Piper/Stevens PA 18 150](https://openairdocs.org/model/piper-stevens-pa-18-150.md): 0 registered aircraft · Registry code 7101827 - [Piper/Waage Donald PA 18](https://openairdocs.org/model/piper-waage-donald-pa-18.md): 0 registered aircraft · Registry code 7101860 ## 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 = '1A2') GROUP BY ALL ORDER BY aircraft DESC, code ``` This list as a web page: https://openairdocs.org/tcds/1A2/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.