Skip to content

Yakovlev YAK-50

Registered aircraft · 37

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

N110YAMatuska F Dale · Port Orange, FLBuilt 1986 · S/N 863110 N11YKAlpha Juliet LLC · Sheridan, WYBuilt 1985 · S/N 853001 N121GCYak 50 LLC · Newark, DEBuilt 1984 · S/N 842901 N150FAFast Aircraft Inc · Scottsdale, AZBuilt 1985 · S/N 853002 N150YKBpm Yak-50 LLC · Wilmington, DEBuilt 1982 · S/N 822308 N227WLam Lawrence Y C · Rosemead, CABuilt 1983 · S/N 832601 N3201RBergeson John S · Rhome, TXBuilt 1975 · S/N 750403 N359FGSlyfield Frederick J II · Park City, UTBuilt 1984 · S/N 842305 N369AGMorts Aeroservice Inc · Vincentown, NJBuilt 1979 · S/N 792006 N402YKWilkins David J · Claremore, OKS/N 822402 N4295XSpence Vincent Anthony · Memphis, TNBuilt 1975 · S/N 750503 N446DHGlaser Scott T · Rosamond, CABuilt 1985 · S/N 853106 N46AWSsbm LLC · Phoenix, AZBuilt 1985 · S/N 853008 N500YKRegistered aircraftBuilt 1981 · S/N 812102 N504BVMarkus Stanley L · Oconomowoc, WIBuilt 1983 · S/N 832510 N504WRRietdyk Guido · Rancho Dominguez, CABuilt 1981 · S/N 812104 N50BKTen G LLC · Waddell, AZBuilt 1982 · S/N 822307 N50MYYak 50 LLC · Scottsdale, AZBuilt 1983 · S/N 832606 N50RKEkberg Craig T · Rolling Hills, CABuilt 1981 · S/N 812001 N50RUFranklin Vernon Y · Midlothian, TXBuilt 1984 · S/N 842907 N50YKBitterlich Mark G · New Bern, NCBuilt 1984 · S/N 842806 N5203VAnchor Capital Holdings LLC · Goshen, KYBuilt 1979 · S/N 79-1503 N53526Matuska Floyd Dale · Port Orange, FLS/N 832607 N550BKFerguson Ross L · Stateline, NVBuilt 1985 · S/N 822303 N550YNixon Edward J · Collierville, TNBuilt 1984 · S/N 842708 N550YKSkorost LLC · Scottsdale, AZBuilt 1981 · S/N 812107 N55YFWorldwide Warbirds Inc · Midway, UTBuilt 1985 · S/N 853104 N613BMFrost Keith A · Scotts Valley, CABuilt 1984 · S/N 842803 N666YYRocket One LLC · Sheridan, WYS/N 822202 N67YKAir Care Systems Inc · Lamar, COS/N 812010 N72YKMckibben Mark A · Owings, MDBuilt 1972 · S/N 01 N78YKM & R Holdings LLC · Montgomery, ALBuilt 1978 · S/N 781204 N79RUWorld Aviation Museum Corp · Woodville, WIBuilt 1979 · S/N 791508 N79YKOrtiz Longo Carlos R · Tomball, TXBuilt 1979 · S/N 791601 N8519QDaus Jeffrey C · Louisville, KYS/N 842707 N92GGTen G LLC · Waddell, AZBuilt 1980 · S/N 801610 N950MSSale Reported · Verdi, NVSale reportedS/N 791507

Back to Yakovlev YAK-50