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.

N400SFGlobal Aero Aviation Inc · Houston, TXBuilt 1987 · S/N 1026N400ZUEastern Stearman Inc Trustee · Leesburg, VABuilt 1986 · S/N 1009N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001N401BMorrison Richard L Trustee · Anchorage, AKBuilt 1978 · S/N TC-2164N401JSMm Fleet Holdings LLC · Farmers Branch, TXBuilt 2000 · S/N 1423N401JXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 1606N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439N403JSPistola Alta LLC · Miami, FLBuilt 2000 · S/N 1433N403SBSmb G-IV X LLC · Longwood, FLS/N 1417N403TB403tb LLC · Dover, DEBuilt 1992 · S/N 1191N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842N4043GGalaxy Aviation Services LLC · Orlando, FLBuilt 1977 · S/N 340A0266N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450N4051CSky High Ventures LLC · Bartlett, TNBuilt 1980 · S/N 340A0995N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132N405SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 1403N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267N4065GCruz-Alvarez Raul Trustee · Miami Springs, FLS/N 340A0268N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752N406CPCalcasieu Parish Police Jury · Lake Charles, LABuilt 1967 · S/N LM-9N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133N406SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 1405N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454N407SVWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 1411N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231N408JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1402N408SNUS Department Of State · Melbourne, FLS/N UE-408N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275N4094S4094s LLC · Holly, MIBuilt 1975 · S/N TC-1840N4096SSmith Timothy M · Mount Pleasant, WIBuilt 1975 · S/N TC-1842N409VRegistered aircraftBuilt 1965 · S/N TE-7N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264N40MGFly Arkansas LLC · Harrison, ARBuilt 1959 · S/N TD-293N40MMChupp Family Trust LLC · Kalispell, MTBuilt 1964 · S/N TC-740N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650N40VCFuerza Regida Corp · San Bernardino, CABuilt 1997 · S/N 1316N4105SAxis Aviation Group Inc · Sacramento, CABuilt 1975 · S/N TC-1845N410GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 01199N410PAPhoenix Em120 LLC · Wilmington, DEBuilt 1990 · S/N 120.195N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288N411AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4411N411AVAircol 9 · Wilmington, DES/N 4011N411LTKent Aviation LLC · Midland, TXBuilt 1998 · S/N 1344
Back to AD 95-26-15 R1