# Registered aircraft: Piaggio P-149D

A list on [Piaggio P-149D](https://openairdocs.org/model/piaggio-p-149d.md).

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

- [N149BR](https://openairdocs.org/aircraft/N149BR.md): Stolzer Dale V · Shady Shores, TX · Built 1962 · S/N 111
- [N149FW](https://openairdocs.org/aircraft/N149FW.md): White David A · Kailua Kona, HI · Built 1987 · S/N 288
- [N149LT](https://openairdocs.org/aircraft/N149LT.md): Neil Squared LLC · Spring Grove, IL · S/N 321
- [N149PG](https://openairdocs.org/aircraft/N149PG.md): Crouch Paul Alan · Oak Harbor, WA · Built 1960 · S/N 177
- [N290ML](https://openairdocs.org/aircraft/N290ML.md): Limbacher Richard A · Stone Creek, OH · S/N 161
- [N52571](https://openairdocs.org/aircraft/N52571.md): Loomis Philip W · Stukenbrock · Non-citizen corporation, flight hours not reported · S/N 296

## 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 ('6960149')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/piaggio-p-149d/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.