Skip to content

Aerostar S A YAK-52

Registered aircraft · 17

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 ('1140003')
  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 ('1140003')
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.

N2832Warsaw Pact Aviation Lc · Davenport, IABuilt 1986 · S/N 866411 N31656Rubana Inc · Santa Monica, CANon-citizen corporation, flight hours not reportedS/N 878206 N352BWLam Tack C · Los Angeles, CABuilt 1983 · S/N 833412 N352SHAdams James G · Morgantown, INBuilt 1985 · S/N 855704 N426YKSommers Cole · Katonah, NYBuilt 1985 · S/N 856102 N4450YYak Flyers LLC · Grants Pass, ORBuilt 1985 · S/N 855809 N52WNFishrup Andrew H · Victorville, CAS/N 833014 N552SHM & R Holdings LLC · Montgomery, ALS/N 855402 N552WHHallstrom Warren C · North Little Rock, ARBuilt 1986 · S/N 866308 N552YKSchrick Mark A · Verdi, NVS/N 822606 N567CDHeffley Brothers Flying Circus LLC · Benbrook, TXBuilt 1983 · S/N 833813 N624DHYak-Ity-Yak LLC · Columbiana, ALBuilt 1982 · S/N 822815 N63YKScheinblum Carissa · Collierville, TNBuilt 1984 · S/N 844209 N696YKGreeley Stephen · Albuquerque, NMBuilt 1987 · S/N 878004 N8712Amsrud Eric M · Marble Hill, GABuilt 1986 · S/N 866306 N952YKChan Norman A · Lumberton, NJBuilt 1982 · S/N 821705 N98YKWwii Airborne Demonstration Team Foundation · Lawton, OKFirst renewal noticeS/N 9812108

Back to Aerostar S A YAK-52