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.

N616RRRed River Aircraft Leasing LLC · Anchorage, AKBuilt 1999 · S/N 1368N616UACole Thomas Ed · White Settlement, TXS/N TC-1039N617AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 30575N617NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5387N617USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21121N618JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2489N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653N618NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5458N618USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21122N6199XH&S Aviation LLC · Chesapeake, VABuilt 1982 · S/N ME-437N619AAvire LLC · West Hollywood, CABuilt 1989 · S/N 1123N619AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30594N619MLSmb G-IV Xii LLC · Longwood, FLBuilt 1988 · S/N 1062N619NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5517N61DDKissner Mark E · Frederick, MDS/N 340A1037N61ESTtl Aero LLC · Oklahoma City, OKBuilt 1964 · S/N TC-682N61QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-92N61UCAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC61N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203N620DLAerotrust Services Corp Trustee · Wilmington, DEBuilt 1986 · S/N 22910N620GDrygala Marcin · Williamsburg, VABuilt 1966 · S/N TC-978N620NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5624N6212VHoffman Eric M · Kerman, CABuilt 1962 · S/N TC-327N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424N621AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48319N621GWoolslayer Homer · Tulsa, OKBuilt 1966 · S/N TE-214N621JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2491N621NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5672N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431N622NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5804N623BBAirshares Incorp · Petersburg, VABuilt 1967 · S/N LJ-277N623JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2504N623JLJomar Aviation LLC · Boca Raton, FLBuilt 1997 · S/N 1337N623NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5861N6240XCoal Black Cattle Co LLC · Roundup, MTBuilt 1977 · S/N 340A0437N624GJBlue Water Aviation LLC · Wilmington, DEBuilt 1995 · S/N 1267N624JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2520N624NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5880N624PDAries Equipment Leasing LLC · Los Angeles, CABuilt 1995 · S/N 1272N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287N625JBJetblue Airways Corporation · Long Island City, NYBuilt 2005 · S/N 2535N625NKUmb Bank Na Trustee · Salt Lake City, UTS/N 5954N6269NJuliet Tango Capital LLC · Saginaw, MIBuilt 1978 · S/N 340A0454N626HRegistered aircraftBuilt 1966 · S/N TC-980N626HMRb Aviation LLC · Tyler, TXBuilt 1981 · S/N 340A1280N626NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5999N6276XWj Bolton Farms LLC · Mark Tree, ARBuilt 1978 · S/N 340A0460
Back to AD 95-26-15 R1