OpenAirDocs.org
AD 95-26-15 R1

Registered aircraft · 5,439

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.

N13138United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30351N1315ZRiesbeck Randall C · Waynesville, OHBuilt 1961 · S/N TC-123N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538N131FLIfl Group Inc · Waterford, MIBuilt 1955 · S/N 155N131JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1408N131NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6472N131SFSuburban Air Freight Inc · Omaha, NEBuilt 1990 · S/N UC-131N131UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0815N1321AAndromeda Leasing I LLC · Purchase, NYBuilt 1995 · S/N 27957N132ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6473N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331N132JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1403N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132N132TWRc Flyers LLC · Wilmington, DEBuilt 1974 · S/N TC-1654N1332ZUp And Up Aviation LLC · Spring, TXBuilt 1961 · S/N TC-141N1333Beech Nut Flyers LLC · San Diego, CABuilt 1968 · S/N TC-1100N1339ZSmith Derek D · Brooks, GABuilt 1961 · S/N TC-139N133ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6482N133BAAlpine Aviation Inc · Provo, UTBuilt 1986 · S/N UB54N133MRPrecision Aero LLC · Wilmington, DEBuilt 1978 · S/N TC-2173N133PCGilco Distributors · Santa Rosa, CABuilt 1976 · S/N 340A0093N133UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0816N134ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 6495N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816N134GGGibson Gordon S Trustee · Pacific Palisades, CABuilt 1981 · S/N 340A1202N134UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0817N1351ZErickson David R · West Point, UTS/N TC-148N1353RRegistered aircraftBuilt 1979 · S/N WA-6N1357ZBromschwig Eric I · Montgomery, TXS/N TC-157N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68N135NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6520N135UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0818N1362CPaw Management Inc · Calimesa, CAS/N 340A0012N1365ZSkans David K · Henderson, NVBuilt 1961 · S/N TC-160N1366ZPfetsch Mitchell R · Daggett, CABuilt 1961 · S/N TC-166N136ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6532N136CAAviation Business Corp · Saint Louis, MOS/N 400N136FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64058N136UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0819N1377ZCoen Brady · Wiley, COBuilt 1961 · S/N TC-165N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078N137AAAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6647N137ASFlight Leasing Corp · Wilmington, DES/N ME-72N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137N137FSparks James T · Abbeville, MSBuilt 1956 · S/N TE-32N137UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 0820N137WSCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1997 · S/N 1307N1380GWalborn & Associates Inc · Mountain Home, IDBuilt 1976 · S/N 340A0079
Back to AD 95-26-15 R1