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 SWAA2025111829417Doubler · crackedCRACK ON EXISTING DOUBLER REPAIR LOCATED ON BS 235.5 AFT POSITION ELECTRICAL GROUND POWER ACCESS. PERFORMED PERMANENT REPAIR LOCATED ON BS 235.5 AFT POSITION ELECTRICAL GROUND POWER ACCESS IAW SRM 51-40-02 AND SRM 53-10-15-2R-4 REPAIR 4 IAW SRM 51-40-02 AND 5SDR SWAA2025111729432Attach Angle · crackedB.S. 663 LOWER COMPOSITE BULKHEAD UPPER ATTACH ANGLE IS CRACKED AT LBL 45, WL 167. REMOVED, REPLACED, AND INSTALLED A NEW 663 LT UPPER ATTACH ANGLE LBL 4- TO LBL 65 IAW SRM 51-40-02-0G-0, AND DWG 111A1000, REV -.SDR SWAA2025111729691Attach Angle · crackedCRACKED ATTACH ANGLE AT MID CABIN BS 690, RBL 1, WL 206. REMOVED FABRICATED AND REPLACED ATTACH ANGLE AT PASSENGER COMPARTMENT BS 690, RBL 1, WL 206 IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G-0 AND DWGS 273A9112, REV H, 273A9112, REV-, 273A9110, REV A.SDR SWAA2025111729694Tab · crackedRIGHT WING T/E DEFLECTION CONTROL RIB UPPER TAB CRACKED. REPAIRED RIGHT WING T/E DEFLECTION CONTROL RIB UPPER TAB IAW SRM 57-51-02-1A-1, SRM 57-51-02-2R-3, AND AMM 57-50-01-820-801.SDR SWAA2025111729690Strap · corrodedCORROSION ON STRAP AT MID CABIN BS 709, RBL 63, WL 204. REMOVED, FABRICATED, AND REPACED STRAP AT MID CABIN BS 709, RBL 63, WL 204 IAW EA 25-153-03005.SDR IPXA2025111101314Skin · corrodedRIGHT WING OTBD TRAILING EDGE HAS 3 PIECES OF SPEED TAPE. REMOVED CORROSION AT ALUMINUM EXTRUSION IAW SRM 51-74-10. FOUND TO BE OUT LIMITS IAW SRM 57-51-12 PAR.(3)(H). INSTALLED REPAIR PLATES (2EA) AND INSERTS (2EA) AT RT WING OTBD TRAILING EDGE IAW SRM 57-51-SDR 2025FA0000754Capacitor · brokenDURING ROUTINE FLIGHT OPERATION THERE WAS A SUDDEN DECREASE IN ENGINE POWER AND A RISE IN VIBRATION WAS FELT, SO THE AIRCRAFT MADE A PRECAUTIONARY UNSCHEDULED LANDING AND SHUT DOWN WITHOUT INCIDENT. UPON INSPECTION OF THE AIRCRAFT IT WAS FOUND THAT ONE OF TWO SDR CALA2025111211139Strap · crackedEA 5311-01827 REV F - CRACK FOUND AT FLANGE RADIUS LOCATED AT THE INTERCOSTAL STRAP AT S14L AT FR 1640. ACCOMPLSIHED EC/RA 5360-02050 AND EA 757-5360-13 A4156 PRELIMINARY 1.SDR DALA2025111008162Shear Tie · low pressureAFT CARGO SHEAR TIE FOUND CORROSION AT STA1329 TO STA 1351 S-36R TO S-35R. CORRECTIVE ACTION: REMOVED AND REPLACED THE SHEAR TIE AS PER B767-400 SRM51-40-02 (1275980)SDR J7SA2025111000459Microwave Oven · faultedMICROWAVE SMOKED WHILE HEATING WET TOWEL. REPLACED THE MICROWAVE IAW G450 AMM 25-37-02. OPS CHECK GOOD.SDR CALA2025111011086Skin · debondedLEFT WING, OTBD FLAP, AFT FLAP, INBD END, LOWER SKIN WITH TWO DISBONDED AREAS , 4 X 3 INCHES, 6.5 X 3.5 INCHES. CLEANED, PREPPED, PERFORMED A PERMANENT REPAIR AND RESTORED FINISHED IAW SRM 57-53-01-1A-4, SRM 57-53-01-2R-16, SRM 51-70-10-2R- 0, AMM 51-21-41-SDR SWAA2025110729436Light · brokenREPLACE BROKEN & WORN PHOTOLUMINESCENT FLOOR LIGHT STRIPS. REPLACED THE PHOTOLUMINESCENT FLOOR LIGHT STRIPS IAW AMM-33-51-15-960-801, PAGE 2, STEP F.SDR SWAA2025110729234Panel · delaminatedPANEL 191FL LOWER AFT EDGE HAS EDGE DELAMINATION. REPAIRED PER [AMM 51-21-99-300-802.SDR SWAA2025110729423Fastener · looseASD AFT SLIDE ATTACHMENT BRACKET HAS LOOSE FASTENERS. TIGHTENED ASD AFT SLIDE ATTACHMENT BRACKET FASTENERS IAW AMM 20-50-11-910-801 AND SOPM 20-50-01.SDR SWAA2025110729422Fastener · looseAED AFT SLIDE ATTACHMENT BRACKET HAS ONE LOOSE FASTENER. TIGHTENED AED AFT SLIDE ATTACHMENT BRACKET FASTENER 1EA PER AMM 20-50-11-910-801 AND SOPM 20-50-01.SDR DALA2025110708148Latch · dirtySHIP 9575 1L DOOR GRIT BAR VERY DIFFICULT TO ARM SLIDE. CORRECTIVE ACTION: FOUND BOTH 1L DOOR RETENTION LATCHES STICKY AND DIRTY. CLEANED AND VERIFIED NORMAL OPERATION REF B717 AMM 25-61. (7816646)SDR AALA202511077622Apu · contaminatedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT DIRTY FEET SMELL ON DECENT. A FAINT ODOR WAS NOTED IN THE FLIGHT DECK. MAINTENANCE ACCOMPLISHED SMOKE / ODOR / FUME APU TROUBLESHOOTING TASK CARD 26L00021002 AND ACCOMPLISHED A DECONTAMINATION OF THE ENVIRONMESDR DALA2025110608105Skin · dentedFUSELAGE SKIN DENT LOCATED JUST FWD OF FR 26 JUST AFT OF L1 DOOR AT FLOOR LINE HAS DENT STICKER CAN NOT FIND LOG PAGE ON STICKER. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0807:5245-2003/004 00651 COMPLETED PRI 6SDR SWIA2025110600028Window Frame · damagedWHILE REMOVING THE RT WINDSHIELD SIDE POST STRAP, THE WINDSHIELD FRAME STRUCTURE WAS DAMAGED AT THE THIRD FASTERNER HOLE FROM THE CENTER OF THE RT SIDE POST ON THE BOTTOM FASTENER ROW OF THE RT SIDE WINDOW. THE DAMAGE MEASURES .098" IN DEPTH, 0.125" IN WIDTH SDR DALA2025110608098Shear Tie · corrodedSHIP 1813 AFT CARGO SHEAR TIE FOUND CORROSION AT STA 1197+154 S -37R TO S-38R CORRECTIVE ACTION: REMOVED AND REPLACED THE SHEAR TIE AS PER B767-400 SRM51-40-02 (1275953)SDR DALA2025110608092Web · corrodedCABIN RT FLOOR WEB BETWEEN STA 986 AND STA 1006 CORRODED. C/W ALL STEPS OF PRI 629967-14 REVO.SDR CALA2025110610946Skin · damagedFWD CARGO DOOR SKIN REPLACED DUE TO DAMAGE. REMOVED AND REPLACED OUTER SKIN IAW DWG 143A69110, REV D, SRM 52-30-01-2R-3, REPAIR 3, AND CMM 52-31-15.SDR DALA2025110508073Power Supply · inoperativeSEAT ROW 26 DEF UNDER BIN EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY M10699 IAW AMM 33-51. EMERGENCY LIGHTS OPS NORMAL. (7956820)SDR AALA202511047189Elec Connector · shortedAIRCRAFT WAS NOT GROUNDED: ANTI-SKID INOPERATIVE ON TOUCHDOWN AUTO-BRAKE DISARMED AND ANTI-SKIP INOPERATIVE LIGHT ILLUMINATED. ACCOMPLISHED BITE OF AACU FOUND FAULT FOR XDCR3. PERFORMED FIM 32-42-00-810-806. FOUND CONNECTOR D11124 IS INTERNALLY SHORTING. REPLSDR AALA202511042890Probe · faultedAIRCRAFT WAS GROUNDED: 4000 POUND FUEL IMBALANCE AT THE TOP OF DESCENT AFTER 10HRS OF FLIGHT. REMOVED AND REPLACED RIGHT CENTER NUMBER 5 FUEL TANK PROBE.SDR AALA202511042488Slide · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT CABIN PANEL INDICATES AN ORANGE CAUTION MESSAGE TO CHECK THE 4L DOOR SLIDE PRESSURE. MAINTENANCE REPLACED THE L4 DOOR ESCAPE SLIDE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26L00025010.SDR CALA2025110410890Skin · damagedFWD ENTRY DOOR - IT WAS FOUND A CRACK INDICATION IN ONE HOLE, THE CRACK IS PRESENT ON THE SKIN AND BEAR STRAP APPROXIMATELY 9 O'CLOCK POSITION.PERFORMED INTERIM REPAIR AT FUS.SKIN ENTRY DOOR 1L AFT LWR CORNE R AS PER ECRA5310-08702 AND SRM 53-10-01-2R-1. IT WESDR SWAA2025110329295Arm · brokenSEAT 14F TRAY TABLE BROKEN. SECURED SEAT 14F TRAY TABLE AND ASSIGNED TO MEL 25-10-01 XC SP1B. R & R ARM ON SEAT 14F TRAY TABLE IAW CMM 25-22-46. THIS CLEARS MEL.SDR DALA2025110308023Skin · crackedOPEN HOLE HFEC INSPECTION OF ALL FASTENER HOLES AT THE FORWARD SERVICE DOOR CUTOUT AFT LOWER CORNER,FOUND 01EA CRACK IN THE FASTENER NO.4,THE CRACK LOCATIONED AT 2 O'CLOCK,. REPAIRED PER ER/A:629689-14AD. (1275915)SDR DALA2025110308022Skin · crackedFUSELAGE SKIN 02 EA FASTENERS CUTOUT CRACK AT STA 1654.5 AND S-4R. CORRECTIVE ACTION: THE FUSELAGE SKIN MADE DOUBLER REPAIR AS PER B767-400 SRM 53-80- 01-2R-4 REV 76.00 - AUG-29-2025 AND ER/A 629840-14 (1275639)SDR DXTA2025110305485Battery Pack · inoperativeCABIN EMERGENCY LIGHTS WERE FLASHING IN FLIGHT IN THE ARM POSITION. REMOVED AND REPLACED FWD AND AFT EMERGENCY BATTERIES IAW AMM 33-52-01. OPS TEST CHECKED GOOD AND RECHARGED. NO DEFECTS NOTED.SDR QXEA2025103100335Brake · no discrepancyFLIGHT 2042. AFTER LANDING FELT LIKE BRAKES WHERE DRAGGING, HAD TO USE A LOT OF THRUST TO TAXI WITH BOTH ENGINES RUNNING BRAKES TEMPS LEFT OB 161 IB185 RIGHT TEMPS INBD 285 OB85 SUSPECT RIGHT IB BRAKE IS STUCK. REMOVED FROM SERVICE. NO HISTORY IN TRAX FOR THISSDR AALA202510312488Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT CABIN PANEL INDICATES AN ORANGE CAUTION MESSAGE TO CHECK THE 4L DOOR SLIDE PRESSURE. (OPEN)SDR AALA202510313213Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT ABOVE ROW 11ABC DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR AALA202510318499Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: SEAT 19C EMERGENCY ESCAPE PATH LIGHT INOPERATIVE. MAINTENANCE FOUND P1 CONNECTOR LOOSE, RESECURED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19 WITH NO ISSUES NOTED.SDR AALA202510318590Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT ABOVE THE L1 DOOR DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR AALA202510317479Warning Light · false activationAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT THE APU DISCHARGE SWITCH LIGHT WAS ON IN FLIGHT. NO RELATED ECAM MESSAGES WERE NOTED. MAINTENANCE PERFORMED OPERATIONAL TEST OF THE APU FIRE EXTINGUISHING LOOP/SQUIB PER AMM 26-22-00 AND NO ISSUES WERE NOTEDSDR AALA202510318730Bottle · leakingAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT A CHECK PRESSURE, SLIDE 4L DISPLAYED ON THE CIDS PANEL. MAINTENANCE REPLACED THE L4 DOOR DAMPER AND EMERGENCY OPERATION CYCLINDER PER AMM 52-13-14. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUESDR AALA202510317198Fan · fault messageAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON 2 MILE FINAL EXPERIENCED ODD/ACRID SMELL FOLLOWED BY VENT BLOWER FAULT POPPED AVIONICS VENT BLOWER FAN AND ECAM VENT BLOWER FAULT. FLIGHT CREW COMPLIED WITH ECAM AND SMELL DISSIPATED BUT RESIDUAL SMELL REMAINSDR AALA202510317622Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT DIRTY FEET SMELL ON DECENT. A FAINT SMELL WAS NOTED IN THE FLIGHT DECK. (OPEN)SDR UIEA2025102801283Icu · faultedCABIN ALT AUTO EICAS MSG. C/W QRH. RETURNED TO ANC(<P>FOUND MX MSG 21234, CHECK FAIL. R/R ICU PER AMM 21-31-10 & IPC 21-31-10-01 ITEM 236, TEST PASSED. R/R DIODES M3349 & 47008 PER SWPM 20-00-00, TEST PASSED. DMI 240995 CLOSED.SDR SWAA2025103129302Lamp · inoperativeEMERGENCY LIGHT AT 14 ABC INOPERATIVE. RELAMPED EMERGENCY LIGHT AT ROW 14ABC PER AMM 33-51-03.SDR SWAA2025103129421Battery Pack · inoperativeEMERGENCY LIGHTS ON RT OVERWING EXIT DO NOT TURN ON. REMOVED & REPLACED THE M1695 BATTERY AND PERFORMED A GOOD OPS CHECK IAW AMM 33-51-06.SDR SWAA2025103129408Battery Pack · no testALL EMERGENCY LIGHTS RELATED TO BATTERIES PACK M1670 AND M1671 FAILED TO TEST. PERFORMED GOOD DEEP CYCLE AND FUNCTIONAL TEST OF EMERGENCY BATTERY PACK M1670 IAW AMM 33-51-06-600-802. REMOVED & REPLACED WITH SERVICEABLE UNIT AND PERFORMED GOOD INSTALLATION TSDR SWAA2025103129197Lamp · inoperativeOVERHEAD BIN EMERGENCY BULL NOSE LIGHT INOP AT 24ABC. RELAMPED O/H BIN EMERGENCY LIGHT AT SEAT 24C PER AMM 33-51-03SDR WX0A2025103132618Battery · inoperative(AIRCRAFT NOT GROUNDED) LFA FLASHLIGHT CHARGE LIGHT NOT BLINKING. REMOVED AND REPLACED FLASHLIGHT BATTERY REWF AMM 25-65-00-00-B OPS NORMAL"SDR IPXA2025103191965Fuel Tank · out of balanceIN FLIGHT RIGHT FUEL TANK WENT 3000 LBS LESS THAN LEFT. INITIALLY WHEN BALANCED RIGHT TANK DROPPED 500 LBS IN TEN MINS THEN 1200 IN 30 MINS. LANDED WITH 3800 LBS LESS IN RIGHT TANK. REMOVED AND REPLACED LEFT WING FUELING SHUTOFF VALVE I.A.W. UPS B757 AMM 28-2SDR CALA2025103110790Service Door · missingLEFT LAVATORY SERVICE DOOR MISSING, DEFERRED REF LOGPAGE CDL 6683578.SDR CALA2025103110777Feeder Cable · arcedGENERATOR 2 FAULT AFTER ENGINE START. COMPLIED WITH ECAM. MSG REMAINS. CREW RESET NO HELP. CREW COMPLIED WITH MEL IDG DISCONNECTED PRIOR TO CLEARING. FOUND ARCING ON IDG FEEDER CABLE FIREWALL CONNECTOR, TERMINAL C. REF AD2011-19-01 R1. CABLE REMAINS DISSDR CALA2025103110769Wire Harness · misroutedSEAT 38C EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 38C MOUNTED EMERGENCY LIGHT ASSY IAW AMM 33-51-19/401. OPS CHECK FAILED. C/W EMERGENCY LIGHT CONNECTOR WAS FOUND DISCONNECT UNDER SEAT 38A AND NOT BEING ROUTED PROPERLY. REROUTED EMERGENCY LIG