Aerostar International S57H
Registered aircraft · 13
Aircraft of this model in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1912MMconnell Thomas S II · Albuquerque, NMN5051UFrackman David · Brooklyn, NYN5095SBuckner Jason A · Albuquerque, NMN5098WDezeeuw Douglas Wayne · Orange City, IAN51058Chelgren David W · Colorado Springs, COFirst renewal noticeN5117VTrainor Jarod · Albuquerque, NMN5141GKiehle Erik A · Meridian, MSN5213BMccullough Kyle S · Saint Marys, IAN5228DDaikin America Inc · Decatur, ALN5233FFenske David W · Albuquerque, NMN5242JPhoenix Balloon LLC · Visalia, CAN5244MRolland Brent K · Carlsbad, CAN621USGreen John J · Albuquerque, NM
Back to Aerostar International S57H