# Registered aircraft

Look up a U.S.-registered aircraft by N-number and see the FAA airworthiness directives that may apply to it.

## Most registered models

- [Piper PA-28-140](https://openairdocs.org/model/piper-pa-28-140.md): 4,258 registered aircraft · Registry code 7102802
- [Zipline International P2 ZIP](https://openairdocs.org/model/zipline-international-p2-zip.md): 4,134 registered aircraft · Registry code 06102II
- [Cirrus Design SR22](https://openairdocs.org/model/cirrus-design-sr22.md): 4,026 registered aircraft · Registry code 2130001
- [Cessna 172M](https://openairdocs.org/model/cessna-172m.md): 3,572 registered aircraft · Registry code 2072418
- [Piper PA-28-180](https://openairdocs.org/model/piper-pa-28-180.md): 3,504 registered aircraft · Registry code 7102808
- [Piper J3C-65](https://openairdocs.org/model/piper-j3c-65.md): 3,189 registered aircraft · Registry code 7100510
- [Cessna 172N](https://openairdocs.org/model/cessna-172n.md): 3,138 registered aircraft · Registry code 2072434
- [Cirrus Design SR22T](https://openairdocs.org/model/cirrus-design-sr22t.md): 3,100 registered aircraft · Registry code 2130004
- [Piper PA-28-181](https://openairdocs.org/model/piper-pa-28-181.md): 2,938 registered aircraft · Registry code 7102807
- [Cessna 182P](https://openairdocs.org/model/cessna-182p.md): 2,099 registered aircraft · Registry code 2075816
- [Piper PA-18-150](https://openairdocs.org/model/piper-pa-18-150.md): 2,054 registered aircraft · Registry code 7101828
- [Cessna 172S](https://openairdocs.org/model/cessna-172s.md): 1,913 registered aircraft · Registry code 2072439
- [Beech A36](https://openairdocs.org/model/beech-a36.md): 1,907 registered aircraft · Registry code 1151604
- [Aeronca 7AC](https://openairdocs.org/model/aeronca-7ac.md): 1,878 registered aircraft · Registry code 2110102
- [DJI AGRAS T40](https://openairdocs.org/model/dji-agras-t40.md): 1,841 registered aircraft · Registry code 06102D3
- [Cessna 172](https://openairdocs.org/model/cessna-172.md): 1,805 registered aircraft · Registry code 2072402
- [Cessna 152](https://openairdocs.org/model/cessna-152.md): 1,636 registered aircraft · Registry code 2071835
- [Cirrus Design SR20](https://openairdocs.org/model/cirrus-design-sr20.md): 1,633 registered aircraft · Registry code 2130000
- [Cessna 140](https://openairdocs.org/model/cessna-140.md): 1,603 registered aircraft · Registry code 2071602
- [DJI AGRAS T50](https://openairdocs.org/model/dji-agras-t50.md): 1,569 registered aircraft · Registry code 06102HG
- [Cessna 182Q](https://openairdocs.org/model/cessna-182q.md): 1,565 registered aircraft · Registry code 2072732
- [Piper PA-28-161](https://openairdocs.org/model/piper-pa-28-161.md): 1,490 registered aircraft · Registry code 7102803
- [Cessna 150L](https://openairdocs.org/model/cessna-150l.md): 1,446 registered aircraft · Registry code 2071826
- [Cessna 150M](https://openairdocs.org/model/cessna-150m.md): 1,439 registered aircraft · Registry code 2071830
- [Mooney M20J](https://openairdocs.org/model/mooney-m20j.md): 1,406 registered aircraft · Registry code 5870219
- [Robinson Helicopter R44 II](https://openairdocs.org/model/robinson-helicopter-r44-ii.md): 1,330 registered aircraft · Registry code 7640122
- [Cessna 170B](https://openairdocs.org/model/cessna-170b.md): 1,299 registered aircraft · Registry code 2072306
- [Mooney M20C](https://openairdocs.org/model/mooney-m20c.md): 1,258 registered aircraft · Registry code 5870208
- [Textron 172S](https://openairdocs.org/model/textron-172s.md): 1,255 registered aircraft · Registry code 2072449
- [Piper PA-12](https://openairdocs.org/model/piper-pa-12.md): 1,242 registered aircraft · Registry code 7101202

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
-- The 30 most registered models; without the LIMIT, every model
SELECT m.code, m.manufacturer, m.model, count(*) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 30
```

This list as a web page: https://openairdocs.org/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
