# Registered aircraft: Aerostar International S57H

A list on [Aerostar International S57H](https://openairdocs.org/model/aerostar-international-s57h.md).

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

- [N1912M](https://openairdocs.org/aircraft/N1912M.md): Mconnell Thomas S II · Albuquerque, NM · Built 2003 · S/N S57H-3006
- [N5051U](https://openairdocs.org/aircraft/N5051U.md): Frackman David · Brooklyn, NY · Built 2003 · S/N S57H-3002
- [N5095S](https://openairdocs.org/aircraft/N5095S.md): Buckner Jason A · Albuquerque, NM · Built 2003 · S/N S57H-3005
- [N5098W](https://openairdocs.org/aircraft/N5098W.md): Dezeeuw Douglas Wayne · Orange City, IA · Built 2003 · S/N S57H3007
- [N51058](https://openairdocs.org/aircraft/N51058.md): Chelgren David W · Colorado Springs, CO · First renewal notice · Built 2003 · S/N S57H-3004
- [N5117V](https://openairdocs.org/aircraft/N5117V.md): Trainor Jarod · Albuquerque, NM · Built 2004 · S/N S57H-3008
- [N5141G](https://openairdocs.org/aircraft/N5141G.md): Kiehle Erik A · Meridian, MS · Built 2005 · S/N S57H-3012
- [N5213B](https://openairdocs.org/aircraft/N5213B.md): Mccullough Kyle S · Saint Marys, IA · Built 2004 · S/N S57H-3009
- [N5228D](https://openairdocs.org/aircraft/N5228D.md): Daikin America Inc · Decatur, AL · Built 2005 · S/N S57H-3013
- [N5233F](https://openairdocs.org/aircraft/N5233F.md): Fenske David W · Albuquerque, NM · Built 2004 · S/N S57H-3011
- [N5242J](https://openairdocs.org/aircraft/N5242J.md): Phoenix Balloon LLC · Visalia, CA · Built 2004 · S/N S5-7H-3010
- [N5244M](https://openairdocs.org/aircraft/N5244M.md): Rolland Brent K · Carlsbad, CA · S/N S57H-3014
- [N621US](https://openairdocs.org/aircraft/N621US.md): Green John J · Albuquerque, NM · Built 2003 · S/N S57H-3003

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

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