# Registered aircraft: Porterfield CP-50

A list on [Porterfield CP-50](https://openairdocs.org/model/porterfield-cp-50.md).

Aircraft of this model in the FAA registry, by N-number.

- [N21973](https://openairdocs.org/aircraft/N21973.md): Western Antique Aeroplane & Automobile Museum · Hood River, OR · Built 1939 · S/N 559
- [N21987](https://openairdocs.org/aircraft/N21987.md): Hayden Robert E Jr · Anahiem Hills, CA · Built 1939 · S/N 570
- [N21994](https://openairdocs.org/aircraft/N21994.md): Taylor Brent · Ottumwa, IA · Built 1939 · S/N 574
- [N25422](https://openairdocs.org/aircraft/N25422.md): Stewart Dan R · Cashmere, WA · S/N 596
- [N25436](https://openairdocs.org/aircraft/N25436.md): Briley Victor O · Johannesburg, MI · Built 1940 · S/N 606
- [N25437](https://openairdocs.org/aircraft/N25437.md): Collins William A · Tillar, AR · S/N 607
- [N25439](https://openairdocs.org/aircraft/N25439.md): Bennett Robert M · Felton, DE · Built 1948 · S/N 609
- [N25495](https://openairdocs.org/aircraft/N25495.md): Shannon Aviation LLC · Drexel, MO · Built 1940 · S/N 624

## The whole list in SQL

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

```sql
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('6480114')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/porterfield-cp-50/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.