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.

N5437UBatdorf Richard E · Naples, FLBuilt 1967 · S/N TE-406N543AXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-219N543DGrantham Ray · Sevierville, TNBuilt 1984 · S/N 340A1805N543USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26490N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843N5446GCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1979 · S/N 340A0685N544USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26491N544UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4847N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191N5453JC L Flight Associates LLC · Bakersfield, CAS/N 340A0111N5454XKair Aviation · Parkland, FLS/N 340A1512N545MMage Aircraft Leasing LLC · San Antonio, TXS/N 340A1041N545USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26492N545UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4850N546GAFinch Dennis G Jr DBA · Long Prairie, MNBuilt 1975 · S/N TC-1915N546UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4885N5476UMagruder Thomas D Jr · Ocean Springs, MSBuilt 1967 · S/N TC-1037N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849N547USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26494N5485MN446rh LLC · Helena, MTBuilt 1978 · S/N ME-32N548USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26495N549TSayers James B · Edison, OHBuilt 1961 · S/N TC-91N549USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26496N549UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4932N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172N54GSN28hb LLC · New York, NYS/N 340A0456N54VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N ME-313N550BZRoswell James M · Stuart, FLBuilt 1981 · S/N TC-2352N550DFArrow Aircraft Leasing LLC · Tucson, AZBuilt 1978 · S/N TC-2197N550JAAlves Gerald T · Alamo, CABuilt 1962 · S/N TC-302N550LEFlycarolina LLC · Concord, NCBuilt 1963 · S/N TC-400N550NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26497N550RNovember Sierra Aviation LLC · Oneill, NES/N TC-391N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086N551CBModern Industrial Services Inc · Beaumont, TXBuilt 2001 · S/N 1449N551JSEm Concepts LLC · Cape Coral, FLBuilt 1978 · S/N TC-2199N551NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26498N551UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2011 · S/N 4940N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861N552NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26499N552SSky'S The Limit Aviation LLC · Wilmington, DES/N 340-0170N552UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4957N553NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26500N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960N553WP6sm Aviation LLC · Savannah, GABuilt 1974 · S/N TC-1757N554CLLacy Clay · Groveland, CABuilt 1966 · S/N TE-99N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898N554JFRhoton Joel S · Borger, TXS/N TC-1286N554JSKilo Kilo Mike LLC · Jacksonville, FLBuilt 1980 · S/N TC-2323N554KCaux Brisebois Vincent · Newcastle, WAS/N TC-1179
Back to AD 95-26-15 R1