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 KY72026F00000Wire · defectiveE1 ENG FIRE LIGHT ON. REPAIRED DEFECTIVE WIRING TO ENG FIRE DETECTOR DT 1003 IAW SA227DC WM 26-20-00 OPS CHECK GOOD ON GRDSDR SWAA2025123039107Floorbeam · corrodedCORROSION AT FLOORBEAM, BS 986, LBL 42, WL 208. REMOVED DAMAGED AREA, FABRICATED, LOCATED, DRILLED, APPLIED PROTECTIVE TREATMENT TO REPAIR PARTS AND REPAIR AREA IAW SRM 53-70-51-2R-6 REP 6, ALT 4.SDR SWAA2025122939106Support Bracket · crackedCRACK INBD TRAILING EDGE SUPPORT BRACKET IRSS 212, RT WING. REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02-0G-0, AND SRM 51-10-02-0G-0, ITEM 9, AND DWG 115A2001, SHEET 50, REV -.SDR SWAA2025122939104Web · crackedCRACK WEB TRAILING EDGE FIXED PANEL ORSS 271 ON RT WING. REMOVED AND REPLACED THE WEB T/E FIXED PANEL IAW SRM 51-40-02; SRM 51-10-02, ITEM 9, AND DWG 115A2512, SHEET 16, REV -.SDR SWAA2025122939105Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE ORSS 297 AT RT WING. REPLACED CORRUGATED PLATE TRAILING EDGE ORSS 297 AT RT WING IAW SRM 51-40-02-0G-0, AND DWG 115A3700, SHEET 82, REV A, AND APPLIED PROTECTIVE TREATMENT ON AREA IAW SRM 51-20-01-0G-0.SDR SWI2025F01852Shear Tie · corrodedAFT FUSELAGE INTERNAL AREA HAS CORROSION ON SHEAR TIE AT FRAME #87 ALONG STRINGER 27R. (C-CHECK RO 12/19/2025)REMOVED AND REPLACED SHEAR CLIP AT FR 87 STGR 27R-28R REF EM,B 175 SRM 51-40-08.THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTIONSDR SWI2025F01851Skin · corrodedWASTE SERVICE PANEL INNER UPPER SURFACE HAS AREAS WITH POSSIBLE CORROSION AT SEAMS AROUND FIBERGLASS PROTECTIVE COVER. (C-CHECK RO 12/19/2025)REMOVED AND REPLACED INNER DOUBLER AT WASTE SERVICE BOX FR 88-89 STRG 26R-28R REF EMB 175 SRM 51-40-08.THIS REPAIR DOSDR SWIA202512220003Shear Tie · corrodedWASTE PAN INTERNAL AREA HAS CORROSION ON SHEAR TIE AT FRAME #88 ALONG STRINGER 27R. 100% MATERIAL LOSS. (C-CHECK RO 12/19/2025)REMOVED AND REPLACED SHEAR CLIP AT FR 88 STGR 27R-28R REF EMB 175 SRM 51-40-08. THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NSDR SWAA2025121639202Lens · missingMISSING EMERGENCY LIGHT LENS ON THE BULL NOSE OVERHEAD STOWAGE BIN 11 LT SIDE. INSTALLED THE LENS IAW AMM 33-51-03-960-802.SDR AALA202512152228Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: RIGHT-HAND AFT EMERGENCY EXIT DOOR 844 INFLATION RESERVOIR HAS BROKEN ELECTRICAL CONNECTOR. MAINTENANCE REPLACED INFLATION RESERVOIR PER AMM 25-62-49.SDR SWAA2025121039101Access Panel · crackedCRACKED ACCESS PANEL 344GB AT RT HORIZONTAL STABILIZER. REPAIRED ACCESS PANEL 344GB AT RT HORIZONTAL STABILIZER IAW SRM 55-20-01-2R-4, REPAIR 4.SDR SWAA2025121039100Access Panel · crackedCRACKED ACCESS PANEL 334GB AT LT HORIZONTAL STABILIZER. REPAIRED ACCESS PANEL 334GB AT LT HORIZONTAL STABILIZER IAW SRM 55-20-01-2R-4, REPAIR 4.SDR SWAA2025120939102Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 334GB AT LT HORIZONTAL STABILIZER. REPAIRED ACCESS PANEL 334GB AT LT HORIZONTAL STABILIZER IAW SRM 51-70-04-2R-9, REPAIR 9.SDR SIMA20251123002Stringer · corrodedRIGHT AFT CARGO. CORROSION ON STRINGER 21R BETWEEN FRAMES 83-84. MAJOR REPAIR. PERFORMED PERMANENT REPAIR TO RT AFT CARGO, STRINGER 21R BETWEEN FRAMES 83-84 IAW ERS-EJ-53MR-5303.SDR AALA202512036760Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR FORWARD GIRT BAR FITTING PLATE. REPLACED PLATE AS REQUIRED.SDR AALA202512031306Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR FORWARD GIRT BAR FITTING PLATE. REPLACED PLATE AS REQUIRED.SDR CALA2025120311719Skin · dentedACCOMPLISH AFT CARGO DOOR SKIN REPLACEMENT. REMOVED AND REPLACED AFT CARGO DOOR EXTERNAL SKIN AS PER SRM 51-40-02-0G-0 AND DWG 146A6110 SHEET 26.SDR AALA202512028896Bottle · no testAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT PASSENGER / CREW DOOR 842 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DAMPING FUNCTION TEST. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR QXEA2025120100357Indicator · inoperativeFLIGHT 2103. R1 DOOR SLIDE INDICATOR, CENTER, BLANK IN BOTH OPEN AND CLOSED POSITIONS. REMOVED FROM SERVICE. PLACED ON MEL 52-70-01C. MEL CLEARED BY PERFORMING MCN E520141-01 ISSUE 1, WHILE REINSTALLING UPPER LINER FOUND SUPPORT BRACKET ON LINER SLIGHLTY BESDR CALA2025120111609Beam · wornLEFT T/E WING DEFLECTION RIB DAMAGED. REPAIRED DAMAGE WEAR AT THE LT WING T/E DEFLECTION CONTROL RIB AND UPPER SUPPORT BEAM TAB IAW SRM 57-51-02--2R-4, ECRA 5751-01223, THIS REPAIR IS A PERMANENT REPAIR ,SDR AALA202511285461Structure · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL STRUCTURE FR68 UPPER CORNER LT SIDE MEASURE OF CRACK L:0.210 INCH. MAINTENANCE REPLACED LINTEL LOC BTW FR66 TO FR68 SRTG8 LT SIDE AT AFT GALLEY AREA IAW SRM 51-72-11-911-001 FOR REPLACED PROCEDURES REFER TO NCN 513SDR CALA2025112711502Skin · dentedACCOMPLISH FWD CARGO DOOR SKIN REPLACEMENT. REMOVED AND REPLACED FWD CARGO DOOR EXTERNAL SKIN IAW SRM 51-40-02-0G-0, AND DWG 143A6110, SHEET 18.SDR DALA2025112708678Pin · looseWHITE CABIN AISLE EMERGENCY LIGHT OUT. FOUND PIN LOOSE AT HARNESS END. SECURED PIN AND PERFORMED OPS CHECK OF CABIN EMERGENCY LIGHTING IAW AMM 33-51. (LP 5953609)SDR SWAA2025112639310Slide · looseFWD ENTRY DOOR SLIDE LOOSE. REATTACHED FWD ENTRY DOOR SLIDE I.A.W. 25-66-01.SDR SWAA2025112639309Girt Bar · detachedBRACKET FOR GIRT BAR DETACHED FROM EMERGENCY SLIDE COVER. PERFORMED MX TASK 725-61-06 REM/INST AND PERFORMED EA M-23-125-01839 AND INSTALLED THREADED FASTNER/NUT.SDR SWAA2025112639318Slide · dislodgedL2 DOOR SLIDE OUT OF CONTAINER. REPACKED L2 DOOR SLIDE IAW MT 725-61-06. ACFT OK FOR SERVICE.SDR SWAA2025112639129Light · detachedFORWARD GALLEY EMERGENCY EXIT LIGHT COVER FELL OFF. R & R FWD GALLEY EMERGENCY LIGHT ASSY IAW AMM 33-51-01-960-802-NG, OPS CHECKED NORMAL.SDR SWAA2025112639209Handle · brokenL1 DOOR ASSIST HANDLE BROKEN. SWAPPED ASSIST HANDLE FROM FWD LAV TO L1 DOOR PER AMM 52-11-31. L1 DOOR ASSIST HANDLE OPS CHECKS NORMAL. OK TO CONTINUE IAW MEL 25-10-01. C/W SP NR 1B. AUTH 294378. INSTALLED NEW ASSIST HANDLE IN FWD LAVATORY. CHECKED GOOD. SDR SWAA2025112638943Rib · crackedRT HORZONTAL STAB LEADING EDGE RIB AT HSS 244.72 HAS A CRACK. ACCOMPLISHED HFEC INSPECTION OF THE DAMAGED AREA, CRACK VERIFIED IAW NDT MANUAL PART 6; 51-00-00, PROCEDURE 23. RT REMOVABLE HORIZONTAL LEADING EDGE REMOVED AND REPLACED IAW AMM 27-41-21.SDR SWAA2025112638944Rib · crackedCRACK FOUND ON RIB AT STA 244.72 ON RT REMOVABLE HORIZONTAL LEADING EDGE. REMOVED AND REPLACED AMM 27-41-21 REMOVABLE HORIZONTAL LEADING EDGE.SDR SWAA2025112639059Skin · delaminatedRIGHT HAND MAIN FLAP TRAILING EDGE DELAMINATED. C/W TEMPORARY REPAIR PER SRM 57-53-01-1A-1. REFER TO TSR 2025009642. AFTER REVIEW; ENGINEERING CONCURS WITH SRM DEFERRAL FOR FAULT TTG8Q0190VFG.SDR SWAA2025112639115Battery Pack · intermittentEMERGENCY LIGHTS IN MAIN CABIN COME ON AND OFF INTERMITTENTLY. REMOVED, REPLACED, & PERFORMED A GOOD EMERGENCY EXIT B22;SDR DXTA2025112605814Light · malfunctionedEMERGENCY LIGHTS EICAS MESSAGE CYCLES ON AND OFF WHWN SWITCH IS PLACED TO THE ON POSTION FOR EMERGENCY LIGHTS TEST. EXTERIOR EMERGENCY LTS CYCLE ON AND OFF AS WELL. PERFORMED EMERGENCY LIGHT OPERATIONAL CHECK WITH NO DEFCETS NOTED. WORK PERFORMED IAW AMP BD7SDR DXTA2025112605816Packing · faultedWHILE LEVEL AT FL410, HEARD A LOUD THUMP IN THE NOSE FOLLOWED BY GEAR DISAGREE N AMBER CAS MESSAGE. NOSE GEAR INDICATOR WAS ALSO SHOWING YELLOW HASH INDICATION. QRH PROCEDURES WERE ACCOMPLISHED. INDICATIONS REMAINED UNTIL DESCENDING THROUGH FL230, HEARD ANOTHSDR DXTA2025112605809Battery · inoperativeEMERGENCY LIGHTS FLICKERING CONSISTENTLY IN FLIGHT WITH EMER LIGHT SWITCH IN ARMED POSITION CORRECTIVE ACTION: REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY PN: 7450LS-00 SN: 005353 WITH REPAIRED UNIT PN: 7450LS-00 SN: 006796. REMOVED AND REPLACED #2 EMERGENSDR CALA2025112611495Tru · faultedSMELL OF SMOKE IN FWD CABIN AND DOOR 3R FLAGGING SDR. DETECTED SMOKE ODOR IN THE AFT E/E EXHAUST. INSPECTED AFT E&E AND NOTED SMOKE COMING OUT FROM THE BACK SECTION OF THE R1 ATRU M2435003 IN P800 E6. REMOVED R1-ATRU AS PER AMM DMC-B787-A-24-35-00-00A-520A-A. SDR CALA2025112611494Pitot System · leakingREJECTED T/O FOR IAS DISAGREE REPEAT WRITE UP APPROX 80 KTS REF FIM 31-62 TASK 876. PERFORMED TROUBLESHOOTING FROM STEP A TO STEP E (6) OBERSERVED MX MSG 31-65060. PERFORMED PITOT STATIC SYSTEM FLUSHING IN ACCORDANCE WITH AMM 34-11-00 CAPTS PITOT FOUND TO BE SDR CALA2025112611493Transmitter · faultedTRAILING EDGE FLAPS DISAGREE. EXTENDED TO FLAPS 1 AND FLAPS STOPPED EXTENDING HALFWAY BETWEEN UP AND FLAPS 1. LE FLAPS TRANSIT LIGHT ILLUMINATED. ALTERNATE FLAPS EXTENSION USED TO EXTEND FLAPS TO 15. AS FLAP INDICATOR MOVED FROM FLAPS 10 TO 15 LE FLAPS EXT GRESDR CALA2025112611492Warning Light · false activationDOOR WARNING ANNUNCIATOR IS ON AFT ENTRY AFT ENTRY DOOR LIGHT ON AFTER TAKEOFF. FA MOVED HANDLE TO CLOSED POSITION AND CLEARED THE LIGHT OPEN AND CLOSED AFT ENTRY DOOR AND CONFIRMED DOOR WARNING ANNUNCIATOR LIGHT IS NOT PRESENT.SDR CALA2025112611491Cylinder · faultedDURING R&R OF RT OVERWING SLIDE FOUND HYD LEAK THAT IS DETERIORATING THE INFLATION BOTTLE AS WELL AS COMPLETELY SATURATING THE INFLATION HOSE FOR OVERWING SLIDE. PRECAUTIONARY R & R RT OVERWING SLIDE INFLATION CYLINDER IAW 25-65-02-404-010, ALSO R & R INFLATISDR DALA2025112508603Wire · damaged30 JH FLOOR WHITE EMER LIGHT INOPERATIVE. REPAIRED WIRING PER A330 AMM 33-51. OK FOR SERVICE. (7205694)SDR DALA2025112508601Frame · damagedFRAME 61, AFT SIDE, STRINGER 4R HAS TOOLING DAMAGE AROUND FASTENER HOLE. REPAIRED PER A330 SRM 53-11. (1318372)SDR DALA2025112508600Stringer · gougedSTRINGER 3R AT FR 61 GOUGED IN RADIUS ABOVE TRAPPED FASTENER. REPAIRED PER A330 SRM 53-11. (1318231)SDR DALA2025112508599Frame · damagedJUST FWD OF FRAME 63 ON STRINGER 2R. STRINGER 2R GOUGED AND TOOLING DMG. REPAIRED PER A330 SRM 53-11. (1318215)SDR DALA2025112508598Frame · gougedFWD SIDE FRAME 64 AT STR 1R LIP HAS GOUGE. REPAIRED PER A330 SRM 51-42-11. (1318434)SDR DALA2025112508597Light · faultedEMERGENCY EXIT SIGNS INOPERATIVE, INTERMITTENTLY FLASH ON AND OFF ON BOTH DOORS IN THE AFT OF THE AIRCRAFT. PERFORMED OPS TEST OF EMERGENCY LIGHTS PER A320 AMM 33-51. NO 30 DAY HISTORY. OK FOR SERVICE. (LP: 1317100)SDR DALA2025112508596Pin · faultedAFTER AIRCRAFT SHUTDOWN MID CABIN LEFT EMERGENCY EXIT SHOWING, NOT ARMED WHILE RIGHT REMAINS ARMED. LATCH PIN RE-ENGAUGED IAW A320 AMM 52-71. ALL INDICATIONS NORMAL AT THIS TIME. (LP: 7337438)SDR DALA2025112508595Light · detachedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / LOCATIONS:32D / MYCABIN TEXT: FRC33520132D EMERGENGY LIGHT IS HANGING BY WIRE / INTERIOR. C/A: R&R 32D FLOOR EMERGENCY LIGHT BRACKET PER A320 CMM 25-31-51. OPS CK OK. REMOVED PLACARDS. NO 'M' PROC REQ. (LP: 131SDR AALA202511254932Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND MAIN LANDING GEAR DOOR FORWARD FITTING. REPLACED FITTING PER CMM 52-81-18.SDR AALA202511257097Pin · brokenAIRCRAFT IN BASE MAINTENANCE: ROW 21ABC SEAT WALL EMERGENCY LIGHT NOT ILLUMINATING. MAINTENANCE FOUND WIRE BROKEN ON CONNECTOR OF HARNESS THAT CONNECTS TO 7260VC10. REPLACED PIN IAW ESPM 20-48-21 AND WDM 33-51-08.