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.

N9907AHuff Steven D · Lake Havasu City, AZBuilt 1950 · S/N 19267N9907BMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34307N9907HMather Aviation LLC · Mather, CABuilt 1981 · S/N 18268103N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851N9908AKelly Larry E · Currie, NCBuilt 1950 · S/N 19268N9908EAndrews Allen P · Longview, TXBuilt 1975 · S/N 18263968N9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLBuilt 1973 · S/N A1500459N9908VDls Computer Services Inc · Lake In The Hills, ILBuilt 1977 · S/N R1722353N9909NMorgan Vernon E · Dillon, COS/N 21063250N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853N9909XMameli Tyler L · Williamson, GABuilt 1961 · S/N 185-0109N9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKBuilt 1983 · S/N U20606740N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059N990CAJundi Adam · North Royalton, OHBuilt 1976 · S/N 15079158N990CKSaucier Christopher A · Marion, MTBuilt 1976 · S/N 18265006N990CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280256N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690N990VPValenzuela Pedro · Douglas, AZBuilt 1979 · S/N U206-04673N990WPThomas Field Flying Club LLC · Holly Springs, MSBuilt 1973 · S/N 18262238N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403N9910ABach Jeremy · Camp Verde, AZS/N 19270N9910ESmoke Eagles Inc · Newport Beach, CABuilt 1975 · S/N 18263970N9910MSatran Paul C · Detroit Lakes, MNBuilt 1977 · S/N 21062089N9910NRunner Douglas A · Ashby, NEBuilt 1982 · S/N 18504370N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854N9910XHower Loyal L · Moscow, IDBuilt 1961 · S/N 185-0110N9911ADaniels Bayce D · Anthony, NMS/N 19271N9911BGustafson Kim · Lake Stevens, WABuilt 1957 · S/N 34311N9911HDouglas Forest Protective Association · Roseburg, ORBuilt 1981 · S/N 18268107N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855N9911VInternational Air Services Inc Trustee · Carson City, NVS/N 18051763N9911XDesolation Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 185-0111N9912AEvans Alfred M Jr · Kingston, OKBuilt 1950 · S/N 19272N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648N9912NRegistered aircraftBuilt 1975 · S/N 18052567N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856N9913EHobot LLC · Springdale, ARBuilt 1975 · S/N 18263973N9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1973 · S/N A1500464N9913MVillapudua Ruben Ruiz · Phoenix, AZBuilt 1977 · S/N 21062090N9913VIsern Douglas J · Golden, COBuilt 1966 · S/N 18051765N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288N9914GKunas Matthew · Akron, OHBuilt 1973 · S/N A1500465N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649N9914MLabra Victor David · Mesa, AZS/N 18264810N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858N9914VJennair LLC · Wilmington, DEBuilt 1966 · S/N 18051766N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412N9915AAbel Elliot A · Terre Haute, INBuilt 1950 · S/N 19275
Back to AD 79-10-14 R1