# Registered aircraft: Piper AEROSTAR 601

A list on [Piper AEROSTAR 601](https://openairdocs.org/model/piper-aerostar-601.md).

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

- [N15MH](https://openairdocs.org/aircraft/N15MH.md): Registered aircraft · Built 1979 · S/N 6107338062145
- [N3646P](https://openairdocs.org/aircraft/N3646P.md): Mr Group · Rapid City, SD · S/N 6108598162155
- [N42WH](https://openairdocs.org/aircraft/N42WH.md): F & F Automotive Inc · Valliant, OK · Built 1978 · S/N 61-0533-131
- [N505VC](https://openairdocs.org/aircraft/N505VC.md): Roe Robert M · Pearland, TX · Built 1981 · S/N 6108808162157
- [N601B](https://openairdocs.org/aircraft/N601B.md): Kornegay Clyde Cullen · Harlingen, TX · Built 1979 · S/N 6106057962136
- [N6890L](https://openairdocs.org/aircraft/N6890L.md): Top Tier Truck And Trailer LLC · Dimmitt, TX · Built 1981 · S/N 6108708162156
- [N7MU](https://openairdocs.org/aircraft/N7MU.md): Aerospace Trust Management LLC Trustee · Wilmington, DE · S/N 61-0698-7962143
- [N8032J](https://openairdocs.org/aircraft/N8032J.md): Mchuard LLC · Wilmington, DE · Built 1978 · S/N 61-0510-129

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

This list as a web page: https://openairdocs.org/model/piper-aerostar-601/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.