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.

N606PSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 1477N6079STelevision Technical Consultants Inc · South Bend, INBuilt 1975 · S/N TC-1877N607AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30573N607JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2386N607NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 4595N607SBPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1997 · S/N 1308N6082SWro LLC · Conway, ARS/N TC-1914N6084SGraves Dorel Jr · Danville, INBuilt 1975 · S/N TC-1913N608ARAviation Inventory Resources Inc · Alvarado, TXS/N 608N608DADelta Air Lines Inc · Atlanta, GABuilt 1985 · S/N 22815N608JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2415N608LHAsturias Air Services Inc · Miami, FLS/N 1162N608NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4902N609NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4951N60CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-11N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663N60GGSuperior Transportation Associates Inc · Costa Mesa, CABuilt 1998 · S/N 1351N60LDRegistered aircraftBuilt 1994 · S/N 1242N60MJAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-60N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073N60UCAlpine Aviation Inc · Provo, UTS/N UC-60N60VLBank Of Utah Trustee · Salt Lake City, UTS/N 39254N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083N610WMWilber Christian B · Waukesha, WIS/N WA-64N611NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 4996N612AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48290N612DTMission Air Capital Services LLC · San Antonio, TXS/N 52N612JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2447N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927N612NKRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2012 · S/N 5029N613AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30574N613GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1401N613JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2449N613NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5042N6140NMurray Edward K · Fallbrook, CABuilt 1981 · S/N TC-2428N6145JGoodman Aircraft Inc · Wilmington, DEBuilt 1982 · S/N TC-2429N614BSPicton Jerry Francis · Rockport, TXBuilt 1975 · S/N TC-1917N614NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5132N615AASkydive San Joaquin Valley Inc · Bakersfield, CABuilt 1967 · S/N LJ-298N615ABBolea Air Inc · Morgan Hill, CABuilt 1964 · S/N TC-815N615JBJetblue Airways · Long Island City, NYBuilt 2005 · S/N 2461N615NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 5159N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427N615SCSvp LLC · Missoula, MTS/N 26100N616CCWest Texas Holdings LLC · San Antonio, TXBuilt 2001 · S/N 1455N616NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5370
Back to AD 95-26-15 R1