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.

N52751Weinstein Mark H · Carrollton, GABuilt 1974 · S/N 18262819N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164N52754Torgerson'S LLC · Ethridge, MTBuilt 1974 · S/N 18262822N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165N52758Luse David C · Newalla, OKBuilt 1974 · S/N 18262825N5275DWorrell Sharyl L · Anchorage, AKBuilt 1958 · S/N 50173N5275EPasiewicz Shannon M · Anchorage, AKBuilt 1959 · S/N 50575N5275QSkyfarmer LLC · Culleoka, TNBuilt 1972 · S/N 15073175N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203N5275VViatrans LLC · Pryor, OKBuilt 1975 · S/N 21060890N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938N52761Reb Baron Aviation LLC · Riverdale, CAS/N 18262828N52764Skylane LLC · Williamsburg, VABuilt 1974 · S/N 18262831N52765Benson Daniel P · Lake Placid, FLBuilt 1977 · S/N 177RG1267N52767Loudy William E · Rigby, IDBuilt 1974 · S/N 18262834N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341N5276ESchmutz George L · Atascadero, CABuilt 1983 · S/N 18268306N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010N5276QCarter Nolon D · Kirksville, MOBuilt 1972 · S/N 15073176N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891N52775Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18262837N5277EJefredo Corp · Zephyrhills, FLS/N 17271809N5277JYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700772N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892N52781Mckendry Martin · Carmel Valley, CABuilt 1974 · S/N 18262840N52783Valdes Alfonso · El Paso, TXBuilt 1974 · S/N 18262842N52786Moore Roger · Jonesboro, ARBuilt 1977 · S/N 177RG1270N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488N5278ESeasholtz John O · Fresno, CABuilt 1979 · S/N 18503949N5278QRegistration Pending · Madison, MSRegistration pending, canceledBuilt 1972 · S/N 15073178N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492N5278VZubrod John W · Ebony, VABuilt 1977 · S/N R1722285N52791Gibson James W · San Antonio, TXS/N 177RG1271N52792Ball Richard W · Ridgefield, CTBuilt 1974 · S/N 18262848N52794Hawk Flyer 794 LLC · San Bruno, CABuilt 2002 · S/N 172S9211N52795Key Lime Consultants LLC · Belleview, FLS/N 18262851N52797Supinie Andy · Wichita, KSBuilt 1974 · S/N 18262852N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558N527AAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1976 · S/N 15078287N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779N527BMMarc Inc · Bolton, MSS/N P2060035N527CAIsaacson Scott D · San Diego, CABuilt 1977 · S/N R172-2510N527DSSkyhawk Leasing LLC · Greenfield, INBuilt 2004 · S/N 172S9588N527NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10818N527ZMTextron Aviation Inc · Wichita, KSS/N 172S13662N52800Jackson Royalties Inc · Brandon, MSBuilt 1977 · S/N 177RG1273N52802Gune Abhijit P · Dublin, CABuilt 1977 · S/N 177RG1274
Back to AD 79-10-14 R1