Skip to content

Ryan Aeronautical ST-A

Registered aircraft · 23

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 ('7830402')
  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 ('7830402')
ORDER BY n_number

Run 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.

N14911Fisher Kurt · San Luis Obispo, CABuilt 1935 · S/N 104 N14954Peters Gary · Clarkston, WABuilt 1935 · S/N 110 N14955Freeman Stephen K · Memphis, TNBuilt 1936 · S/N 133 N14956Lee Larry W · Atlanta, GAS/N 112 N14957Barber Fred L · Smithville, MOBuilt 1935 · S/N 113 N14982Burger Bernard F · Orange, CABuilt 1936 · S/N 114 N14983Autry Marbella A · Montrose, COBuilt 1936 · S/N 115 N14984Monaco Donald F Trustee · Modesto, CABuilt 1936 · S/N 116 N14985Sweet Tea Holdings LLC · Kalispell, MTS/N 117 N14987Richards John F · Ventura, CAS/N 124 N16039Bowe Walter C Trustee · Sonoma, CABuilt 1936 · S/N 128 N17351Somers Charles Michael · Hillsboro, ORBuilt 1937 · S/N 154 N17352Ryan Air Exposition LLC · Vacaville, CABuilt 1937 · S/N 156 N17353Creative Interiors Inc · Wichita, KSBuilt 1937 · S/N 157 N17357Xstac LLC · Flower Mound, TXBuilt 1937 · S/N 162 N17369Tidmore Argie D · Pottsville, PABuilt 1937 · S/N 174 N18902Airpower Museum Inc · Ottumwa, IABuilt 1938 · S/N 198 N18922Sundale Aviation Inc · Erwinna, PABuilt 1939 · S/N 312 N18923Plane Fun Inc Tr Trustee · Snellville, GABuilt 1939 · S/N 322 N26JCSilver Eagle LLC · Garden City, NYBuilt 1937 · S/N 148 N7779Leon Arnaldo M · Las Vegas, NVS/N 476 N86555Barber Fred L · Smithville, MOS/N 111 N9ENewcomer David · Portsmouth, VABuilt 1939 · S/N 355

Back to Ryan Aeronautical ST-A