OpenAirDocs.org
AD 95-26-15 R1

Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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.

N169DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29689N169FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63101N169GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-169N169SPVahedi Vafa S · San Diego, CAS/N TC-353N169UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0864N169UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1455N16BBEuroair Consultants LLC · Vero Beach, FLFirst renewal noticeBuilt 1974 · S/N TC-1749N16GJGlobal Empire Trust LLC · Dover, DES/N 1088N16JNSonance Rocket LLC · San Clemente, CABuilt 1996 · S/N 1292N16RBHotel Sierra Aviation LLC · Texarkana, TXBuilt 1965 · S/N TC-840N16YBBolea Air Inc · Morgan Hill, CABuilt 1974 · S/N TC-1688N1702TDans Shop Inc · Montevideo, MNBuilt 1963 · S/N TC-527N1704WNiskanen Michael · Framingham, MABuilt 1972 · S/N TC-1486N1706GBarcenas Shawn · Weirsdale, FLBuilt 1962 · S/N TC-274N17085Bc Aircraft Leasing LLC · Albuquerque, NMBuilt 1975 · S/N 47957N1709AAndromeda Leasing I LLC · Purchase, NYS/N 24086N170FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63102N170GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-170N170PAPhoenix Air Group Inc · Cartersville, GABuilt 1965 · S/N 054N170UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0865N170USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1462N17104United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27294N17105United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27295N1711VAggravation Aviation Inc · Wilmington, DEBuilt 1964 · S/N TC-591N17122United Airlines Inc · Chicago, ILBuilt 1997 · S/N 27564N17126United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27566N17128United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27567N17133United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29282N17139United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30352N171CJBering Air Inc · Nome, AKBuilt 1993 · S/N UE-71N171DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24759N171DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29690N171FBrassell Andrew Keith · Argyle, TXBuilt 1964 · S/N TC-609N171FBBiggs Aircraft Inc · Wellston, OKBuilt 1977 · S/N TC-2039N171FLIfl Group Inc · Waterford, MIBuilt 1956 · S/N 318N171JCAlliance Aviation Group LLC · Wilmington, DEBuilt 1993 · S/N 1222N171JDStoffel Duane L · Hamilton, MTBuilt 1961 · S/N TC-90N171JSSerrato Joel · Brownsville, TXS/N 340-0072N171PAPhoenix Air Group Inc · Cartersville, GABuilt 1968 · S/N 192N171UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24322N171UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0866N171USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1465N172AJWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 32400N172DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24775N172DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29691N172FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63103N172GAAlpine Aviation Inc · Provo, UTS/N UB-11N172UPUnited Parcel Service Co · Louisville, KYBuilt 2006 · S/N 0867N172USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1472N1734GJ-Bird Air Service LLC · Cheyenne, WYBuilt 1962 · S/N TC-275
Back to AD 95-26-15 R1