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.

N806FXFederal Express Corp · Memphis, TNS/N 375N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302N806JGGallagher James · Thornhurst, PABuilt 1989 · S/N UC63N806NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0578N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081N807EXFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 292N807FXFederal Express Corp · Memphis, TNS/N 383N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312N807KWAlta 777 LLC · Salt Lake City, UTS/N 27638N807NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0588N807WHDulin Thad L · Midland, TXBuilt 1969 · S/N TC-1250N8085RMcgilvray Jeremme Allen · Carson City, NVBuilt 1969 · S/N TC-1246N8088RFree Philip O · Collierville, TNBuilt 1969 · S/N TC-1252N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176N808DJAeroquest LLC DBA · Olive Branch, MSBuilt 1982 · S/N ME-391N808MFCd 321 LLC · Cypress, TXBuilt 2001 · S/N 1448N808NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0591N808TWVa Office Of Emergency Service LLC · Hampton, VABuilt 1977 · S/N 340A0304N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349N809NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0663N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796N80AUAurora Flight Sciences Corp · Manassas, VABuilt 1998 · S/N 340B437N80AWThurnau Travels LLC · Hartsburg, MOBuilt 1975 · S/N TC-1839N80KYBreeding Mark A · Bowie, TXBuilt 1961 · S/N TC-86N80QJRegistered aircraftBuilt 1998 · S/N 1333N80RDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-21N80RRBemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-296N80YDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-79N8100LDynamic Avlease Inc · Bridgewater, VABuilt 1989 · S/N 146N8100VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1985 · S/N 024N8104RDfr Aviation Inc · Greenwood, INBuilt 1969 · S/N TC-1259N810ADGulf States Air Inc · Bossier City, LAS/N LD-328N810FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 220N810KWAlta 777 LLC · Salt Lake City, UTS/N 27639N810NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0674N810TNorthware Ventures Inc · Hidalgo, TXBuilt 1974 · S/N TC-1667N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116N810TMNomad Air LLC · Dover, DEBuilt 2002 · S/N 1483N811FXFederal Express Corp · Memphis, TNS/N 283N811KWAlta 777 LLC · Salt Lake City, UTS/N 27656N811NWDelta Air Lines Inc · Atlanta, GABuilt 2005 · S/N 0690N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538N811WDDoherty Christopher L · West Chester, OHBuilt 1968 · S/N TC-1083N8122RAviation Buddy Corp · Incline Village, NVBuilt 1974 · S/N TC-1732N8127RKanok Enterprises LLC · Derby, KSBuilt 1974 · S/N TC-1735N812ACInternational Air Services Inc Trustee · Carson City, NVS/N LJ-123N812FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 404N812NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0784N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157N813KWAlta 777 LLC · Salt Lake City, UTS/N 27641
Back to AD 95-26-15 R1