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.

N777LLHelfrich Vincent · Lawrence, MABuilt 1971 · S/N TC-1410N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415N777UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 26916N777USCurley James L · Oneida, TNBuilt 1966 · S/N TE-182N778ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29587N778FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25223N778JHCurran Michael · Gallatin, TNBuilt 1980 · S/N WA-156N778LGLogistic Air Inc · Reno, NVS/N 32895N778UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26940N7796NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N TC-1192N7799TSn 1474 LLC · Wilmington, DEBuilt 2002 · S/N 1474N779ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29955N779FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25252N779JBJetblue Airways Corp · Long Island City, NYBuilt 2009 · S/N 3811N779LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 1238N779MMMartin James D · Graford, TXBuilt 1963 · S/N TC-470N779NMCallahan Mfg Inc · Royal City, WABuilt 1967 · S/N TC-1053N779UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26941N77AWRose Timothy A · Hickory, MSBuilt 1961 · S/N TC-187N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053N77CLDopfel Bruce E · Belle Plaine, KSBuilt 1967 · S/N TE-275N77FKOcean Aviation 26 LLC · Great Neck, NYBuilt 1998 · S/N 1357N77GUFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 46512N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120N77RRWilson Jonathan G · Granbury, TXBuilt 1964 · S/N TC-823N78001United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27577N78002United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27578N78003United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27579N78004United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27580N78005United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27581N78008United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29478N78009United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29479N78013United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29861N78017United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31679N7801YRed Baron Aviation LLC · Denver, COBuilt 1978 · S/N TC-2139N780ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29956N780BABoeing Aircraft Holding Co · Renton, WABuilt 1990 · S/N 24310N780FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25253N780UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26944N7817LNyerges James · Midland, TXFirst renewal noticeBuilt 1967 · S/N LD-340N781AAN781aa LLC · Junction City, KSBuilt 1961 · S/N TC-38N781ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29586N781FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26673N781UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26945N7821RRegistered aircraftBuilt 1968 · S/N TC-1196N7823RJeffco LLC · Wasco, CAS/N TC-1197N782ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30003N782FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 26677N782KAaron Daryl G · Rosenberg, TXBuilt 1965 · S/N TC-924N782UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26948
Back to AD 95-26-15 R1