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.

N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117N9313GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801450N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081N9313XSjb Farms LLC · Albany, ORS/N 18268484N9314CThielker Mark Robert · Bellaire, TXBuilt 1955 · S/N 31712N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220N9314GPeerbolte John K · Highland, INBuilt 1971 · S/N 18260854N9314XFortney Rick · Mc Alpin, FLBuilt 1985 · S/N 18268485N93157Haley Mitchell P · Big Lake, MNBuilt 1974 · S/N 21060285N9315BVan Horne Robert E · Centralia, ILBuilt 1958 · S/N 55115N9315C15charlie LLC · Soldotna, AKBuilt 1955 · S/N 31713N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118N9315ESmith Mark S · Cornville, AZS/N 17272221N9315UGilbreath Brent · Arlington, TXBuilt 1976 · S/N 15078265N9315XBowen Floyd Eugene Jr Trustee · Bend, ORBuilt 1985 · S/N 18268486N9316BKnutson Wayne R · Thompson, NDS/N 55116N9316URoadrunner Bus LLC · Weston, NEBuilt 1976 · S/N 15078266N9316XZilberberg Tamir · North Hollywood, CABuilt 1985 · S/N 18268487N9317Avignati West LLC · Santa Barbara, CABuilt 1977 · S/N 18265663N9317CSixus LLC · Fairfax, VABuilt 1955 · S/N 31715N9317EBrothers Brian · Columbus, OHBuilt 1984 · S/N 18268394N9317MWestwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700680N9317WBruton Paul R · El Campo, TXBuilt 1986 · S/N U20607018N9317XMoonshine Energy LLC · Midland, TXBuilt 1961 · S/N 18253717N93183Frost John David Trustee · Anchorage, AKBuilt 1976 · S/N 18503190N93186Bates Byron B · Ethel, WABuilt 1974 · S/N 21060299N93189Hoppner Theodore · Fairbanks, AKS/N 18503194N9318BAnderson Daniel R · Venus, TXS/N 172RG0790N9318UWhite David A · Omaha, ARS/N 15078268N9318XTopnotch Aero Inc · Austin, TXBuilt 1962 · S/N 18253718N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084N9319UJohnson Douglas G · Mason City, IABuilt 1976 · S/N 15078269N9319XShepherd Joseph R · Fayetteville, GAS/N 18253719N931EMClackamas County Sheriffs Office · Oregon City, ORBuilt 1975 · S/N 18263643N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349N931SJTss Flying Club Inc · Bethesda, MDBuilt 2001 · S/N 18280931N931URRegistration Pending · Ivins, UTRegistration pendingS/N 56048N93202Nature State LLC · Portland, ORBuilt 1977 · S/N 18503198N9320CRiley Coda L · Beaumont, TXBuilt 1955 · S/N 31718N9320DDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 172RG1119N9320GChiles Farms LLC · Hooper, COBuilt 1971 · S/N 18260860N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085N9320XBlue Skies Air LLC · Portland, ORBuilt 1985 · S/N 18268488N93216East Moriches Aerial Advertising Ltd · Ridge, NYBuilt 1966 · S/N R172-0110N9321BGippner Gerald W · Olathe, KSBuilt 1958 · S/N 55121N9321EMertinez Matos Daniel Enrique · Fajardo, PRS/N 17272225N9321GFontana Michael A · Kirkwood, MOS/N 18260861N9321XSakonnet Aircharter · Bradenton, FLBuilt 1985 · S/N 18268489N93229Back Country Club LLC · Crawford, TXBuilt 1976 · S/N 18503200N9322CWaters David J · Phelps, NYBuilt 1959 · S/N 46402
Back to AD 79-10-14 R1