AD 79-10-14 R1

Registered aircraft · 56,582

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  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.

N9931ARowland Brett D · Wichita, KSBuilt 1950 · S/N 19291N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084N9931EN9931e LLC · Phoenix, AZBuilt 1979 · S/N 17272291N9931HEnergy Transfer Aviation LLC · Spring, TXBuilt 1981 · S/N 18268122N9931QDexter Aero Club Inc · Stetson, MEBuilt 1975 · S/N 17265875N9931THanft Douglas N · Raymond, CABuilt 1960 · S/N 18253031N99329Tactical Integrated Training Soluctions LLC · San Antonio, TXBuilt 1985 · S/N 17276432N9932EMiller Mike R · Redmond, WABuilt 1975 · S/N 18263992N9932GT & M Aircraft LLC · Monticello, ILBuilt 1971 · S/N 18800732N9932HFlathead Flight Operations LLC · Kalispell, MTBuilt 1981 · S/N 18268123N9932NGetz Keith · Murfreesboro, TNBuilt 1975 · S/N 18052587N9932ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606753N99338Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276433N9933ATravelair Inc · Ocala, FLBuilt 1950 · S/N 19411N9933BHenkemeyer Joseph S · Cave Creek, AZBuilt 1957 · S/N 34333N9933MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700750N9933TOrr Kory A · Hay Springs, NEBuilt 1960 · S/N 18253033N9933ZFreelance Air · Kennesaw, GABuilt 1983 · S/N U20606754N99341Jlinn Aviation Inc · Quinlan, TXBuilt 1985 · S/N 17276434N99344Global Tours & Travel Services LLC · Davie, FLS/N 17276435N99347Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276436N9934BMasterson Kevin M · Eagle River, AKBuilt 1957 · S/N 34334N9934EStenger D James Trustee · Sonora, CABuilt 1975 · S/N 18263994N9934GDiorio Christopher J · Melba, IDBuilt 1973 · S/N A1500471N9934NAtkins Ricky K · Placerville, CABuilt 1975 · S/N 18052589N9934QDoupe Services LLC · Fort Myers, FLBuilt 1975 · S/N 17265878N9934VRuby Aviation LLC · Oak Creek, COBuilt 1966 · S/N 18051786N9934XLogue James · Fort Worth, TXBuilt 1975 · S/N 21060916N9934ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606755N9935AMichael Monte E · Axtell, TXBuilt 1950 · S/N 19413N9935BCarpenter Willard D · Borrego Springs, CABuilt 1957 · S/N 34335N9935ERegistration Pending · Belington, WVRegistration pendingBuilt 1985 · S/N 18268474N9935FKrahe Richard P · Willoughby, OHBuilt 1999 · S/N 17280645N9935HKahn Lawrence · Upper Lake, CABuilt 1981 · S/N 18268125N9935MFreshwater Adventures Inc · Dillingham, AKBuilt 1982 · S/N 20700751N9935NMeggers Roger D · Baker, MTBuilt 1975 · S/N 18052590N9935RUsda Aphis Ppq · Edinburg, TXBuilt 1986 · S/N U20606988N9935VD & S Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17264562N9936QHunt Richard M · Columbus, OHBuilt 1975 · S/N 17265880N9936VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264563N99377Barta Terry · Faribault, MNBuilt 1985 · S/N 17276439N9937AInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 19297N9937E7 And 7 LLC · Leon, IABuilt 1979 · S/N 17272293N9937QFosmo Richard E · Eatonville, WABuilt 1975 · S/N 17265881N9938NJohnson Scott A · Missoula, MTBuilt 1975 · S/N 18052593N9938TShope Brandon M · North Pole, AKFirst renewal noticeBuilt 1960 · S/N 18253038N9938ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606757N99396Flightline Air Service LLC · Pineville, LABuilt 1985 · S/N 17276441N9939NSylvester Sean W · North Pole, AKS/N 18052594N9939VJackson Walter E · Wasilla, AKBuilt 1966 · S/N 18051791
Back to AD 79-10-14 R1