Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; general aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR FDEA202508111397Seat Track · wornCABIN-SEAT TRACK AT STATION 999 X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRSDR FDEA202508111396Seat Track · wornCABIN-SEAT TRACK AT STATION 999 X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRSDR FDEA202508111395Seat Track · wornCABIN-SEAT TRACK AT STATION 1089, X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1089, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK REPLASDR FDEA202508111394Seat Track · wornCABIN-SEAT TRACK AT STATION 6-30,X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 6-30, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEASDR UIEA2025081101120Pin · dislodgedCOCKPIT FIRE EXTINGUISHER PIN FELL OUT. REINSTALLED PULL TIGHT SEAL PER AMM 26-26-02. NO FURTHER DEFECTS NOTED.SDR SWIA2025081075198Former · crackedPAX DOOR FORMER BS 320.163 SUSPECTED CRACKED. INSTALLED NEW PAX DOOR FORMER IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH 51-900-1002-SKY. PRESSURIZATION LEAK CHECK OF THE REPAIR AREA PASSED IAW AMM 21-31-00-SDR SWIA2026020475190Intercostal · crackedPAX DOOR INTERCOSTAL DD1A AFT CRACKED. INSTALLED A NEW PAX DOOR AFT DD1A INTERCOSTAL IAW SRM 51-42-06-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2025081075189Door Frame · crackedPAX DOOR FRAME BS 320 CRACKED. INSTALLED A NEW DOOR FRAME IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2026020475188Intercostal · dentedPAX DOOR AFT DD1 INTERCOSTAL DENTED AT THE BEND RADIUS. INSTALLED A NEW PAX DOOR AFT DD1 INTERCOSTAL IAW SRM 51-42-06-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA202512090810Stringer · corrodedSTRINGER 24R FOUND CORRODED BETWEEN BS 349 TO 364. REPAIRED THE STRINGER IAW SRM 51-23-00-001-001-A01, 51-24-36-001-001-A01, 51-25-06-001-001-A01, 51-25-16-001-001-A01, 51-40-11-001-001-A01, 51-42-06-001-001-A01, 51-42-20-001-001-A01, 51-42-21-001-001-A01, 5SDR SWIA20251110810Rib · crackedRH WING LEADING EDGE RIB AT SS58.41 IS CRACKED ON TOP SIDE OF RIB (C-CHECK RO 11/07/2025)PERFORMED REPAIR DAMAGE ON RH WING LEADING EDGE RIB AT SS58.41 IAW CRJ900 AMM 57-41-32, MHI RJ REO 690-57-41-538 REV--(P1) DATE: 2025-08-12, MHI RJ REO 690-57-41-538 REV-SDR SWAA2025092300276Glowstrip · crackedCRACK ON PHOTOLUMINESCENT STRIP, RT PASSENGER CABIN. REPLACED THE PHOTOLUMINESCENT STRIP IAW AMM-33-51-15-400-802.SDR SWAA2025092300275Glowstrip · crackedCRACKS ON PHOTOLUMINESCENT STRIP, LT PASSENGER CABIN. REPLACED PHOTOLUMINESCENT STRIP IAW AMM-33-51-15-400-802.SDR SWAA2025092300043Lens · brokenBROKEN BASE OF EXIT LIGHT. REPLACED EXIT LIGHT ASSY LENS IAW AMM-33-51-01-960-802, STEP 3 C.SDR SWAA2025092300049Lens · brokenBROKEN BASE EXIT LIGHT ASSY. AFT GALLEY AREA. REPLACED EXIT LIGHT ASSY LENS IAW AMM-33-51-01-960-802 STEP 3.C.SDR SWAA2025092300048Lens · brokenBROKEN BASE EXIT LIGHT ASSY AT LAVATORY A. REPLACED EXIT LIGHT ASSY LENS IAW AMM-33-51-01-960-802 STEP 3.C.SDR SWAA2025092300047Lens · brokenBROKEN BASE EXIT LIGHT ASSY AT GALLEY 1. REPLACED EXIT LIGHT ASSY LENS IAW AMM-33-51-01-960-802 STEP 3.C. (SDR SWAA2025092300046Light · brokenBROKEN BASE EXIT LIGHT ASSY ON SIDEWALL 232YHW IN PASSENGER CABIN. REPLACED BASE EXIT LIGHT ASSY ON SIDEWALL 232YHW IAW AMM-33-51-01-960-802 STEP 3.C.SDR SWAA2025092300045Light · brokenBROKEN BASE EXIT LIGHT ASSY ON SIDEWALL 231YHW IN PASSENGER CABIN. REPLACED BASE EXIT LIGHT ASSY ON SIDEWALL 231YHW IAW AMM-33-51-01-960-802 STEP 3.C.SDR SWAA2025092300044Guard · brokenBROKEN EMERGENCY EXIT LIGHT SWITCH GUARD ON LAVATORY B. REPLACED EMERGENCY EXIT LIGHT SWITCH GUARD IAW CMM-33-11-05, PAGE 10028, ITEM 15 AND PAGE 10029.SDR SWAA2025091600180Support Angle · crackedLEFT WING T/E PANEL 561AB AFT PANEL SUPPORT ANGLE IS CRACKED. REMOVED AND REPLACED LEFT-HAND WING T/E PANEL 561AB BEAM ASSY IAW SRM 51-40-02 AND DWG# 115A3712 ID: 0005 REV: -.SDR SWAA2025091500183Rib · crackedR/H HORIZONTAL STAB REMOVABLE L/E 341B RIB NR 3 IS CRACKED. REMOVED AND REPLACED RIB NR 3 IAW SRM 51-40-02 & DWG 186A1001.SDR SWAA2025091500187Rib · crackedRIGHT HORIZONTAL STAB REMOVABLE L/E 341B RIB NR 4 IS CRACKED. REMOVED AND REPLACED RIB NR 4 IAW SRM 51-40-02 & DWG 186A1001.SDR HNAA2025091400631Floor Support · corrodedLH #7 FLOOR SILL IS CORRODED. R&R LH #7 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR AALA202509147411Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202509146141Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500C TO BS 500I AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR HNAA202509110065Intake · corrodedLEFT ENGINE AIR INTAKE LIP IS CORRODED. R&R LT ENGINE AIR INTLET ASSEMBLY IAW EMB 145 AMM 71-60-01.SDR HNAA202509110064Floor Support · corrodedLH #6 FLOOR SILL IS CORRODED. R&R LH #6 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR SWAA2025091200092Panel · debondedPANEL 193CL HAS LARGE DISBONDS ON BOTH SKINS. DUE TO THE EXTENT OF DAMAGE; REPLACED PANEL 193CL WITH NEW PANEL IAW SRM 51-10-02-0G-0 PARA 9 AND AIPC 53-14-00-03A ITEM 290.;SDR SWAA2025091200093Panel · debondedPANEL 193CR INNER SKIN IS DISBONDED. REPAIRED IAW SRM 51-70-05-2R-2-A00733, REPAIR 2. REPAIR OF DAMAGE THAT IS MORE THAN 0.50 INCH (12.70 MM) IN DIAMETER TO ONE SKIN AND THE HONEYCOMB CORE.SDR SWAA2025091000030Pin · corrodedPITTING CORROSION ON LOWER ATTACHMENT PIN REAR SPAR AT RT HORIZONTAL STABILIZER. REPLACED LOWER ATTACHMENT PIN AT RT HORIZONTAL STABILIZER IAW AMM 27-41-11-401-NG SEE REMOVED AND INSTALLED ON TTG8R0089ZTY.SDR SWAA2025090800284Support Angle · corrodedAFT CARGO BULKHEAD SUPPORT ANGLE AT BS 947.5, LBL 4, WAS CORRODED. REMOVED AND REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 149A8117, REV -.SDR SWAA2025090800176Support · corrodedAFT CARGO ZEE ANGLE SUPPORT AT RBL 21 FROM STA 727 TO STA 767 HAS CORROSION IN VARIOUS LOCATIONS. REMOVED AND REPLACED THE FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02, AND DWG 146A7500 0085, REV A.SDR SWAA2025090800175Support · corrodedAFT CARGO ZEE ANGLE SUPPORT AT LBL 21 FROM BS 727 - 847 HAD CORROSION IN VARIOUS LOCATIONS. REMOVED AND REPLACED THE FLOOR TO SIDEWAL SUPPORT IAW SRM 51-40-02, AND DWG 146A7500 0061, REV-.SDR AALA202509081347Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509054747Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509055408Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509056610Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR 2025F00216A/C Pack · odorABOUT 1/2 WAY THRU THE FLIGHT, CREW NOTICED A BURNING SMELL IN THE CABIN. NO VISUAL JUST A SMELL. AFTER ABOUT 10 MINUTES THE SMELL WENT AWAY. CREW COMPLETED FLIGHT TO ORIGINAL DESTINATION. ONCE TRANSFERRED TO POTOMAC APPROACH, APPROACH DECLARED EMERGENCY. CREWSDR SIMA20250810001Floor Support · corrodedRH FWD SILL HAS CORROSION BETWEEN FR 13 AND FR 14 @ Y=+48" (MAJOR REPAIR) (LEVEL 2 CORROSION) BLENDED CORROSION ON FWD RH SILL AT FR13-FR14 AND Y=+48" PER EMB 175 SRM 51-10-03. BLENDED AREA MEASURES (L: 3" W: 1" D: .015".) AREA MEASURED USING DEPTH GAUGE AND ISDR IPXA2025083098755Angle · corrodedAPU INLET DOOR LOWER CORNER ANGLE STA 1785.45 STR 6R HAS CORROSION. INSTALLED LOWER CORNER ANGLE IAW SRM 51-40-02-0G-0.SDR IPXA2025083098735Angle · corrodedAPU INLET DOOR UPPER CORNER ANGLE STA 1785.45 STR 3R HAS CORROSION. INSTALLED UPPER CORNER ANGLE IAW SRM 51-40-02-0G-0.SDR IPXA2025083000877Strap · corrodedMAJOR REPAIR, APU INLET DOOR AFT STRAP AT STA 1825 HAS EVIDENCE CORROSION. INSTALLED ALL REPAIR PARTS (3EA STRAPS AND 2EA FILLERS), 2 FITTINGS AND 4 ANGLES IAW B757-200PF SRM 51-40-02-0G-0 FOR ACCOMPLISH TO SRM 53-80-15-2R-1 REPAIR 1 DETAIL II.SDR IPXA2025082798800Angle · corrodedAPU INLET DOOR UPPER ANGLE FROM STA 1785.45 TO STA 1826 AT STR 3R HAS CORROSION. INSTALLED UPPER ANGLE IAW B757-200PF SRM 51-40-02-0G-0.SDR IPXA2025090298768Angle · corrodedAPU INLET DOOR LOWER ANGLE BS 1785.45 TO 1826, S6R HAD CORROSION. INSTALLED LOWER ANGLE IAW SRM 51-40-02-0G-0.SDR AALA202509023823Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202509021789Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508293678Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO HAS CRACKED BAFFLE CLIP AT LEFT HAND SIDE, FORWARD SIDE OF BS 500H TO BL25L. INSTALLED NEW CLIP. PER AARD 53-00-01-6.SDR IPXA2025082600303Strap · corrodedAPU INLET SUPPORT STRUCTURE FWD STRAP I/B END SHOWS SIGNS OF POSSIBLE CORROSION, INSTALLED FWD STRAP, AT APU INLET SUPPORT STRUCTURE IAW B757-200 SRM 51-40-02-OG-0SDR AALA202508273099Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO HAS A CRACKED AT BAFFLE CLIP LOCATED ON RIGHT HAND SIDE, FORWARD SIDE OF STATION 500H, BL25R. INSTALLED 500H-500G RIGHT HAND BAFFLE. PER AARD 51-00-05-1 AND AARD 53-00-01-06.