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.

N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N591ADSome Amigos LLC · Spring, TXBuilt 1964 · S/N TC-647N591JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2246N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152N592JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2259N592RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 1396N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071N5932SRomain Dallas B · Fort Benton, MTS/N TE-125N5938MKarlen John R · Boring, ORS/N 340-0074N593JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2280N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440N594JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2284N595CCarol Corp · Lincoln, NES/N TC-863N595JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2286N597JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2307N597SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 415N597TDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1967 · S/N TE-353N598JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2314N599AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4599N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89N599JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2336N599VKDeland LLC · Kalispell, MTBuilt 1970 · S/N TC-1346N59AGUnited States Government · Fort Belvoir, VABuilt 1981 · S/N 59N59DLChannel Islands Aviation Inc · Camarillo, CABuilt 1979 · S/N ME-143N59HVBoling Kyle C · Oak Hill, FLBuilt 1966 · S/N TC-1007N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751N5DRHaslett Bradley A · Collierville, TNBuilt 1974 · S/N TC-1653N5GFSdl Gulfstream LLC · Wilmington, DEBuilt 1995 · S/N 1277N5HEFinancial Solution Services · Leesburg, FLS/N 340A0485N5KGCrossley Michael · Corona Del Mar, CABuilt 1968 · S/N TC-1068N5MCGeorgetown Interstate Aviation Inc · Santa Barbara, CABuilt 1993 · S/N 1218N5WENeilson Grant R · Richmond Hill, GABuilt 1976 · S/N TC-1981N5YBFrasier Samuel R · Gainesville, FLS/N TC-952N6001KAllred Warren D · Marshfield, MOBuilt 1979 · S/N WA-25N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123N6003RRemikin I LLC · Naperville, ILS/N ME-126N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133N6007FMobley Barbara Alice · Kathleen, GABuilt 1979 · S/N WA-4N6007TMinton Richard D · Longville, LABuilt 1979 · S/N WA-5N600BFCentral Virginia Aviation Inc · Petersburg, VABuilt 1966 · S/N LJ-193N600CKNb Airlines LLC · Miami, FLBuilt 1991 · S/N 1169N600MBKleid Kenneth E · Spring Branch, TXBuilt 1968 · S/N TC-1184N600PMBlackford Ryan · Manchester, TNBuilt 1977 · S/N TC-2082N600PRWest Wind Air LLC · Lake Village, ARBuilt 1981 · S/N TC-2384N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100
Back to AD 95-26-15 R1