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 SWIA20260112007Pulley · brokenUPON T/S MCD WHEEL/DOOR MOTOR CABLE PULLEY BROKEN MEL, FOUND A 2 INCH CUT IN THE SIDE OF THE AFT DOOR SKIN AT THE UPPER AREA FOR THE CABLE FEED THRU TO PULLEY OPENING.. COMPLIED WITH REO 670-52-11-1544 DATED: 2026-01-08 REV: A TEMPORARY REPAIR TO PASSENGER DOSDR SWAA2026011259231Lens · detachedSIDEWALL LIGHT LENS ROW 8 DEF FELL OFF. SECURED WINDOW LIGHT LENS IN PLACE IAW SIP.SDR SWAA2026011259229Scuff Plate · crackedR1 DOOR THRESHOLD SCUFF PLATE CRACKED ON FWD AND AFT SIDES. REMOVED AND REPLACED THE R1 DOOR SCUFF PLATE IAW AMM 53-11-01.SDR SROM20260112001Hydraulic Line · chafedAFTER ENGINE START IT WAS NOTICED THAT THE INBOARD ROLL SPOILER HYDRAULIC CAUTION LIGHT REMAINED ILLUMINATED AND THEN THAT THE #1 HYDRAULIC QUANTITY WAS VISIBLE DROPPING. THE ENGINES WERE SHUTDOWN WHEN THE #1 HYDRAULIC QUANTITY REACHED APPROXIMATELY 10% AND THSDR DALA2026011200263Shear Tie · corrodedAFT CARGO COMPARTMENT FOUND ONE SHEAR TIE CORRODED AT BS 1417, BTWN S39L AND S39R, THE WORN SHEAR TIE WAS R & R IAW SRM 51-40-02 (1389847)SDR DALA2026011200262Shear Tie · corrodedAFT CARGO BAY FOUND ONE SHEAR TIE CORROSION AT BS 1219, BTWN S38L AND S39L, REF CPCP TASK 53-558-00. THE WORN SHEAR TIE R & R IAW SRM 51-40-02 (1389839)SDR AALA202601123976Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGNS, ALL THREE, AT R1 DOOR ARE INOPERABLE. MAINTENANCE REPLACED BATTERY PACK AT R1 DOOR POSITION M33094.SDR IPXA2026010996688Tee Fitting · corrodedTEE FITTING, BS 1037 - 1060, LBL 60, EXFOLIATING CORROSION. REMOVED THE TEE FITTING IAW SRM 51-40-02. INSTALLED A NEW TEE FITTING IAW SRM 51-40-02.SDR AALA202601128700Slide Raft · no testAIRCRAFT WAS GROUNDED: FAULT MESSAGE FOR LEFT 2/ EMERGENCY POWER SUPPLY UNIT DISPLAYED DURING SYSTEM TEST. MAINTENANCE FOUND THE L1 (AALA202601127620) AND R1 (AALA202601128700) DOOR SLIDES CAUSING THE MESSAGE AND REPLACED BOTH OF THEM PER TASK CARD 26L00025011SDR AALA202601127620Slide Raft · no testAIRCRAFT WAS GROUNDED: FAULT MESSAGE FOR LEFT 2/ EMERGENCY POWER SUPPLY UNIT DISPLAYED DURING SYSTEM TEST. MAINTENANCE FOUND THE L1 (AALA202601127620) AND R1 (AALA202601128700) DOOR SLIDES CAUSING THE MESSAGE AND REPLACED BOTH OF THEM PER TASK CARD 26L00025011SDR SCNA20260129019Light Sys · inoperativeR1 DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. OPENSDR CALA2026011212871Resistor · burnedMANY STATUS MSGS NITRO GEN SYS ELEC ENG START R2. FOUND R2 ATRUC TRIPPED ON ESIC. PRESENT LEG FAULT MAINTENCE MSG 24-17504 RELATED TO THE MULTIPLE STATUS MESSAGES. FOUND R2 SOFT START RESISTOR (R2 SSRA) BURNED (DAMAGED) IN THE P200 PANEL. FOLLOWED FIM 24-30SDR CALA2026011212870Fitting · crackedLEFT & RIGHT WINDSHIELD CONTINUITY FITTINGS CRACKED. REMOVED & REPLACED LT & RT WINDSHIELD CONTINUITY FITTINGS ON EA 5310-07675 004.SDR AALA202601109787Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT AT FWD SIDE OF L3 DOOR IS INOPERABLE. MAINTENANCE REPLACED LIGHT BULB ON EMERGENCY EXIT LIGHT AT FWD SIDE OF L3 DOOR OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA202601099056Door Frame · bentAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR FRAME IS BENT AND LOOSE AND MAKES DOOR DIFFICULT TO OPEN. **SUPPLEMENTAL REPORT FOR (AALA202601089056) SUBMITTED 1/8/2026 BY DFW: RESECURE THE LOOSE DOOR FRAME AND RAIL. PER CMM 25-40-64. DOOR OPERATIONAL CHECK GOOD**SDR AALA202601093434Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: JUST AFTER TAKE OFF THE LEFT FORWARD FUEL LOW PRESSURE LIGHT ILLUMINATED AND REMAINED. REMOVED AND REPLACED PRESSURE SWITCH. ACCOMPLISHED OPERATIONAL TEST OF THE LEFT FORWARD BOOST PUMP. PER AMM 28-22-41-710-801 AND OPERATIONAL CHECSDR U2RA2026011000029Skin · crackedTHREE INCH CRACK WAS IDENTIFIED IN THE LEFT WING LEADING EDGE UPPER SPLICE PLATE. ACCOMPLISHED MAJOR REPAIR IAW FLIGHT VEHICLES CONSULTING INC. ENGINEERING ORDER CONTROL 25197-3.SDR ASAA2026010763648Battery Pack · intermittentFORWARD THREE INTERIOR EMERGENCY LIGHTS LOCATED AIRCRAFT LEFT TURN ON AND OFF INTERMITTENTLY IN FLIGHT. LIGHTS REMAINED ON EVEN WITH THE EMERGENCY LIGHT SWITCH IN THE OFF POSITION. GROUNDED - YES. REMOVED & REPLACED M2335 POWER SUPPLY/BATTERY PACK. OPS CK GOODSDR ASAA2026010763632Lamp · inoperativeWHILE ACCOMPLISHING T/C 33-010-00, FOUND SLIDE LIGHT FOR L2 DOOR IS INOPERATIVE. GROUNDED - YES. REMOVED & REPLACED L2 DOOR SLIDE LIGHT IAW AMM 33-51-04, OPS CHECKED GOOD.SDR SWAA2026010958903Mount · damagedAFT GALLEY ENTRY DOOR FWD SLIDE MOUNT BRACKET DAMAGED. AFT GALLEY ENTRY DOOR FWD SLIDE MOUNT; REMOVED AND REPLACED LOWER SUPPORT BRACKET REF. SRM 51-40-02.SDR SWAA2026010959153Light · detachedEMERGENCY LIGHT AT ROW 23 SEAT C, FELL OUT OF CEILING. REINSTALLED LIGHT ASSEMBLY AT ROW 23 SEAT C IAW AMM 33-51-03SDR SWAA2026010959181Ground Wire · pulledEMERGENCY LIGHT OUTSIDE OF MAIN ENTRY DOOR IS INOPERATIVE. FUTHER INVESTIGATION FOUND GROUND WIRE PULLED FROM GROUND BLOCK GD3876 DC. TERMINATED THE WIRE ONTO THE GROUND BLOCK GD3876 DC IAW WDM 33-51-12, SWPM 20-90-15. PERFORMED GOOD FUNCTIONAL TEST OF EMERSDR AALA202601094377Wire · brokenAIRCRAFT WAS NOT GROUNDED: ROW 7 SEAT EMERGENCY LIGHTS INOPERATIVE. MAINTENANCE REPAIRED BROKEN WIRE SPLICE AT SEAT 7A AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER ESPM 20-43-10.SDR AALA202601093540Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANTS PANEL SHOWS THE 4L DOOR UNARMED WHEN IT IS ARMED AND THE DOOR INDICATES ARMED IN THE FLIGHT DECK. MAINTENANCE SERVICED THE 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202601099646Handle · looseAIRCRAFT WAS NOT GROUNDED: DOOR 2R SLIDE ARMING HANDLE IS LOOSE. MAINTENANCE TIGHTENED R2 DOOR ARMING HANDLE PER AMM 52-22-22.SDR AALA202601095314Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601094315Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR ABXA20260107007Valve · defectiveDURING CRUISE, EXCESSIVE FUEL MIGRATION FROM THE LEFT MAIN TO THE CENTER FUEL TANK. REMOVED AND REPLACED FUELING SHUT-OFF VALVE IAW 28-21-02. REMOVED AND REPLACED VALVE CONTROL UNIT IAW 28-21-12. PERFORMED OPS CHECK AND LEAK CHECK IAW 28-11-00. NO DEFECTS SDR DXTA2026010906472Pressure Valve · faultedSHORTLY AFTER TAKEOFF POWER APPLIED, HP VALVE FAIL LT AMBER CAS LIGHT ILLUMINATED. COMPLETED APPROPRIATE QRH. INSPECTED GD001 GROUND. NO DISCREPANCIES. RANG WIRING FROM VALVE TO PYLON,. NO DISCREPANCIES. R & R HP VALVE. OPS CHKD GOOD, BUT LEAK CHECKS NOTSDR CALA2026010912834Spring · missingRIGHT MAIN LANDING GEAR UPLOCK SPRING FOUND MISSING.SDR CALA2026010912830Battery Pack · no testOPERATIONAL TEST FOUND L1 DOOR M33302 BATTERY PACK INOPERATIVE. REPLACED THE L1 DOOR BATTERY PACK AND CARRY OUT OPS TEST IAW AMM 33-51-06-960-802, REV 106. RESULT WAS NORMAL.SDR CALA2026010912829Battery Pack · no testOPERATIONAL TEST FOUND R4 DOOR, POWER PACK BATTERY INOP. REPLACED THE R4 DOOR M33408 POWER PACK BATTERY AND CARRIED OUT OPS TEST IAW AMM 33-51-06-960 -802, REV 106, THE RESULT WAS NORMAL BATTERY R4 M33408 PACK INOP.SDR CALA2026010912828Actuator · faultyFOUND RT WING SPOILER NR 8 CHATTERING. FOUND ON PVI. R & R NR 8 SPOILER ACTUATOR IAW AMM 27-61-51-400-801. OPS AND LEAK CHECKED GOOD.SDR CALA2026010912827Floor Skin · wornFLIGHT DECK FLOOR SKIN PANEL WEAR MARKS STA 259 LBL11 TO RBL 10. INSTALLED REPAIR AT FLIGHT DECK FLOOR IAW SRM 53-10-51-2R-2 AND SRM 51-40-02-0G-0.SDR CALA2026010912826Web · corrodedCORROSION AT AFT WET AREA BS 1016, RBL32 BEHIDE HARDPOINT FOOT. INSTALLED A NEW WEB IAW SRM 51-40-02-0G-0, AND DWG 147A5700.SDR CALA2026010912825Heat Shield · crackedONE MLG TIRE FOUND BEYOND AMM LIMITS. MLG NR 1 WHEEL, HEAT SHIELD CRACKED, NR 1 MLG WHEEL ASSY REPLACED IAW AMM 32-45-01/401.SDR DALA2026010900204Seat Track · corrodedCORRODED SEAT TRACK -Y765 AT AFT GALLEY AREA. REPLACED SEAT TRACK -Y765 AND FASTENERS LOCATED BETWEEN FR64 TO FR66 RH SIDE AT AFT GALLEY AREA IAW SRM 51-42-11, SRM 51-72-11, AND DWG 10N01048, REV A, (LP: 1390695)SDR DALA2026010900203Floorbeam · corrodedCORROSION FLOORBEAM -Y1162.5 LOC. FR 68 RH SIDE AT AFT GALLEY AREA. REPLACED FLOOR BEAM -Y1162.5, SPLICES 2 E/A AND FASTENERS LOC FR 68 TO FR 69 RH SIDE AT AFT GALLEY AREA IAW SRM 51-42-11 , SRM 51-72-11, DWG D53472089, ISSUE M, DWG D53474250, ISSUE V, DWG DSDR CALA2026010812818Panel · delaminatedPANEL 192AT DELAMINATION LOWER SURFACE EXPOSED DAMAGE DIMENSIONS ARE 3 INCHES LONG BY 1.5 INCHES WIDE. PIC INCLUDED. APPLIED TAPE PER SRM 51-75-12-911002 INSPECT TAPE EACH FLIGHT PERMANENT REPAIR WITHIN 30 DAYS ADD EMP:U116706 INFO: PAINT PEELING OFF. NO DAMGESDR CALA2026010812806Wire · damagedRIGHT WING, DURING REMOVAL OF W150 0-0095-20 DAMAGE ON CONNECTOR D6878. REMOVED AND REPLACED L MAIN TANK INDICATOR WIRE W1500-0096029 AT CONNECTOR 06878 WITH NEW WIRE IAW SWPM 20-10-11 AND SW PM 20-61-00, WDM 28-41-11 AND FUEL QTY IND SYST OPERATIONAL TEST WSDR CALA2026010812805Rib · crackedRT HORIZONTAL STAB RIB HSS 92.7 HORIZONTAL FLANGE AT STIFFENER NR 2 CRACKED. INSTALLED REPAIR AT RT HORIZONTAL STAB RIB HSS 92.7 STIFFENER NR 2 IAW SRM 55-10-09-2R-5.SDR CALA2026010812804Battery · no testWHILE OPS CHECKING FLOOR LIGHT AT 35F, FOUND ROWS. 33-38 AND ROWS 48-53 EMERGENCY LIGHTS INOPERATIVE. FOUND MAINT MESSAGE 33-11726 FOR WCU CLASS 26. AND MAINT MESSAGE 33-11729 FOR WCU CLASS 29 CONFIGURATION REPORT SHOWED FOR BOTH CLASS 26 AND 29 HAVING A FAILESDR CALA2026010812803Light · missingSEAT 35F IS MISSNG EMERGENCY FLOOR PATHWAY LIGHT AND MOUNT. INSTALLED NEW EMERGENCY LIGHT ASSEMBLY AND FLOOR PROXIMITY LIGHT IAW AMM 33-51-06-00A-720A-A AND PINNACLE 1096028 SERIES PASSENGER SEATS CMM 25-23-51 PAGE 10122. OPS CHECK GOOD.SDR CALA2026010812802Door · missingMIGRATED SHIM (P/N) 311A2103-4) AT RIGHT PYLON THRUST REVERSER STRUT FAIRING. PERFORM AN INSPECTION OF THE INBOARD SHIM AT THE RIGHT PYLON THRUST REVERSER STRUT FAIRING INSTALLATION PER PART 2 OF ECRA 5450-0302. 9 PERFORM AN INSPECTION OF THE INBOARD SHIM ATSDR CALA2026010812801Battery Pack · inoperativeOFAR FLASHLIGHT FAILED OPS TEST (RED LED OBSERVED). FLASHLIGHT TURNS OFF AUTOMATICALLY WITHIN 03 SECONDS FLASHLIGHT BATTERY PACK INOP. FLASHLIGHT BATTERY PACK REPLACED AT THE OFAR. INSTALLATION CHK AND OPS TEST CARRIED OUT, FOUND SATISFACTORY. IAW AMM B787-A-SDR CALA2026010812800Light · inoperativeFOUND SEAT 4D EMERGENCY LIGHT INOP REPLACED DUE TO INOPERATIVE. EMERGENCY LIGHT ASSY SEAT 4D EMERGENCY LIGHT REPLACED IAW B787-A-33-51-06-00A-520A/720A-A. OPS TEST SATIS.SDR CALA2026010812797Sensor · false indicationAT FL300, AFT ENTRY LIGHT ILLUMINATED RAN QRH LIGHT RESOLVED ON IT`S OWN AFTER 5 MINS VISUALLY INSPECTED AFT ENTRY DOOR SENSOR FOR SECURITY AND CONDITION, NO DISCREPANCY NOTED. PERFORMED ENTRY AND GALLEY SERVICE DOOR INDICATION SENSOR TEST IAW AMM 52-71-11-710SDR CALA2026010812795Lamp · inoperativeEMERGENCY LIGHTS TEST WITH TEST SWITCHES , EMERGENCY LIGHTS IN CEILING ABOVE POSITIONS 36K, 21B AND 6L DO NOT COME ON WHEN SWITCH IN TEST. IT WAS VERIFIED LAMP BURNED AND REPLACED IN REF AMM 33-51-04-002-001. IT IS OK FOR SERVICE.SDR CALA2026010812794Elec Connector · disconnectedFOUND RIGHT EMERGENCY OVER WING EXIT LIGHT AFT L562 INOP. (EXTERIOR) BULB, POWER SUPPLY CHARGER, AND BATTERY NO HELP. REF WDM 33-51-13. DURING TS FOUND RT AFT OVERWING EMERGENCY LIGHT DISCONNECTED BEHIND DADO PANEL. RESECURED CONNECTER, ALL EXTERIOR EMERGENCY SDR CALA2026010812793Battery Pack · faultedLT SIDE EMERGENCY DOOR BOTH EXIT SIGNS DO NOT ILLUMINATE. REMOVED & REPLACED BATTERY PACK I.A.W AMM 33-51-06. OPS CHECKED NORMAL OK FOR SVC.