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 DXTA2026020306741Oil Cap · looseRIGHT, NR 2 ENGINE, OIL SERVICE BEFORE FLIGHT. IN FLIGHT ENGINE TWO OIL PRESSURE LOW ENG 2 OIL PRESS LO CAS ILLUMINATED APPROXIMATELY THREE HOURS INTO THE FLIGHT. CHECKLIST FOLLOWED AND BROUGHT THE NUMBER TO ENGINE TO IDLE TO KEEP THE OIL PRESSURE IN THE GRESDR DXTA2026020306742Door · faultedIT TOOK MULTIPLE ATTEMPTS TO GET THE DOOR OPEN FROM THE OUTSIDE. ALSO COULDN'T GET OUT OF THE AIRCRAFT WITHOUT PUSHING ON THE DOOR. WHEN IT CLOSES THERE SEEMS TO BE POPPING AND GRINDING WHILE IN TRANSIT. CORRECTIVE ACTION: CLEANED THE OUTER DOOR SEAL AND MAISDR AALA202602036015Acm · contaminatedAIRCRAFT WAS GROUNDED: CREW NOTICED STRONG WET SUCK ODOR BEGAN AT 9000K ON DESCENT FROM REAR TO FRONT. REMOVED AND REPLACED LEFT HAND (AALA202601307475) AND RIGHT HAND (AALA202602038634) HEAT EXCHANGERS, PER JOB CARD 72L00021001. REMOVED AND REPLACED RIGHT HASDR AALA202602038634Heat Exchanger · contaminatedAIRCRAFT WAS GROUNDED: CREW NOTICED STRONG WET SUCK ODOR BEGAN AT 9000K ON DESCENT FROM REAR TO FRONT. REMOVED AND REPLACED LEFT HAND (AALA202601307475) AND RIGHT HAND (AALA202602038634) HEAT EXCHANGERS, PER JOB CARD 72L00021001. REMOVED AND REPLACED RIGHT HASDR AALA202602037475Heat Exchanger · contaminatedAIRCRAFT WAS GROUNDED: CREW NOTICED STRONG WET SUCK ODOR BEGAN AT 9000K ON DESCENT FROM REAR TO FRONT. *REMOVED AND REPLACED LEFT HAND (AALA202601307475) AND RIGHT HAND (AALA202602038634) HEAT EXCHANGERS, PER JOB CARD 72L00021001. REMOVED AND REPLACED RIGHT HASDR DALA2026020300806Door · icedFLIGHT ATTENDANTS ARE UNABLE TO DISARM DOOR 2L AFTER ARRIVAL AT DESTINATION. CLEARED OBSTRUCTION & ICE FROM DOOR 2L DRAINS, DOOR DISARMED & OPS CHECK NOW GOOD. OK FOR SVC. (LP# 7728258)SDR AALA202602034838Light · missingAIRCRAFT IN BASE MAINTENANCE: EXIT LIGHT NOT INSTALLED IN CENTER OF CABIN. INSTALLED EMERGENCY EXIT LIGHT ON CENTER CEILING PANEL. PER AMM 33-51-01SDR AALA202602039533Sign · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT SIGN AT THE L2 DOOR IS BROKEN. REMOVED AND REPLACED EMERGENCY EXIT SIGN ASSEMBLY AT L2 DOOR. PER AMM 33-51-01.SDR AALA202602036726Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER FLIGHT ATTENDANT FORWARD JUMPSEAT REPORTED TO BE DEAD. REMOVED AND READJUSTED BRACKET SENSORS. PER AMM 25-64-00.SDR AALA202602034218Housing · brokenAIRCRAFT WAS GROUNDED: 22C EMERGENCY LIGHT STRIP INOPERATIVE. REMOVED AND REPLACED BROKEN HOUSING FOR LIGHT. PER CMM 25-23-11.SDR F3LA202602030354Slide · no testAIRCRAFT WAS GROUNDED, R1 DOOR UNABLE TO ARM SLIDE. AIRCRAFT WAS GROUNDED ACFT REMOVED FROM SERVICE. R & R R1 DOOR SLIDE (7501MM) IAW AMM 25-62-44-00-804-A/400-803-A. OPS CHECKED GOOD. ACFT OK FOR CONT. SERVICE.SDR DALA2026020300797Wire · detachedROW 35AB WHITE EMERGENCY LIGHT INOPERATIVE. RECONNECTED A WIRE IAW AMM 33-51. OK FOR SERVICE. (8562832)SDR REXA2026020300029Pushrod · inoperativeMAIN PASSENGER DOOR UNABLE TO OPEN. FOUND PUSH ROD AT MID PIVOT OUT OF ADJUSTMENT. ADJUSTED PUSH ROD TO PAWL CONTROL ROD IAW AMM 52-11-02.SDR KCSA2026013003Fitting · out of adjustAFTER SHUTDOWN AND DISARMING DOORS, L1 DOOR WOULD NOT OPEN. TRANSFERRED TO DMI #100297816 IAW KA MELB 25-10 52-11-01-01B. CAT C. DUE 2-10-26 (M) PROCEDURE C/W PLACARDS INSTALLED. PERFORMED ADJUSTMENT OF GIRT BAR FLOOR FITTING IAW B777/200/300 AMM 52-11-18.SDR CALA2026020313537Panel · brokenPIECE OF METAL MISSING ON LEFT WING. FWD SLAT INBD OF NR 1 ENGINE. REMOVED PANEL & HARDWARE OF PANEL. NO OTHER DAMAGE FOUND.SDR CALA2026020313530Pressure Switch · faultedLEFT FUEL FILTER BYPASS LIGHT ILLUMINATED. PERFORMED T/S IAW FIM 73-05 TASK 801, FOUND NR 1 ENG FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (FFDPS) DEFECTIVE (INTERNAL SHORT), R & R THE NR 1 ENG FFDPS IAW AMM 73-43-01, REPLACED NR 1 ENG FUEL FILTER IAW AMM 73-1SDR CALA2026020313529Accumulator · overservicedAT 85 KTS, DURING TAKE OFF ROLL, HYD B ELEC PUMP LOW PRESSURE ECAM. B QTY BELOW RANGE AFTER REJECT. UPON RETURN TO GATE, PRESSURE NORMAL & QTY NORMAL SECOND REJECTED TAKE OFF IN 2 DAYS. ACCUMULATOR PRESSURE 700 PSI. PRESSUIZED HYD B SYS. ONLY GOT 700 SDR WX0A2026020232723Epsu · no testAIRCRAFT NOT GROUNDED, EPSU BATTERY 10WL, FAILED EPSU SYS TEST. R & R ESPU BATTERY 10WL IAW AMM 33-51-38-400-002-A. OPS TESTED GOOD.SDR WX0A2026020232722Megaphone · no testAIRCRAFT NOT GROUNDED, FA REPORTED THAT THE FWD MEGAPHONE NOT PREFLIGHTING PROPERLY. REMOVED THE MEGAPHONE & OPS CHECKED SIREN AND MADE SURE BATTERIES WERE CHARGED IAW AMM 25-65-51-710-002-A. NO DEFECTS NOTED AT THIS TIME.SDR DALA2026020200786Door Frame · crackedCRACKS FOUND AT THREE FASTENER HOLES, BS 1640 LT FUSELAGE FRAME, OUTER UPPER HOLE PRESENTS A CRACK ON THE FRAME WEB, OUTER ANGLE & HINGE FITTING AT 6 CLOCK; OUTER LOWER HOLE PRESENTS CRACKS ON THE FRAME WEB, OUTER ANGLE & HINGE FITTING AT 3 & 9 O`CLOCK, INNESDR DALA2026020200785Frame Splice · damagedFUSELAGE FRAME, BS 1640, S14L CRACKED AND MISDRILLED IN THE PARTIAL FRAME SPLICE, MONITOR INSPECTION LOG. REPAIRED THE FRAME SPLICE BS 1640 BTWN S9 - 20L IAW ERA 631259-14AD. (1426571)SDR SWAA2026020265773Battery · no testCOCKPIT FLASHLIGHT DOES NOT TEST. OK TO CONTINUE PER MEL 25-64-02A. R & R THE FLASHLIGHT BATTERY IAW SIP. OPS. CHKD GOOD.SDR SWAA2026020265962Megaphone · inoperativeFWD GALLEY MEGAPHONE INOPERATIVE. - R & R IAW AMM 25-64-00-SWA-806-01.SDR SWAA2026020265928Power Supply · inoperativePASSENGER CABIN, RIGHT OVERWING UPPER AND LOWER FWD EMERGENCY LIGHTS INOPERATIVE. R & R THE BATTERY POWER SUPPLY M1669 IAW AMM 33-51-06-960-806.SDR SWAA2026020265838Battery Pack · inoperativeTHREE FWD LT EMERGENCY OVERHEAD BIN LIGHTS NOT WORKING. R & R CHARGER ASSEMBLY AND BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026020265956Battery Pack · inoperativeAFT RT MULTIPLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE RT EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026020265897Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE OVER R2 DOOR. R & R THE RT AFT GALLEY EMERGENCY BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2026020266359Lens · detachedOVERHEAD CIELING EXIT LIGHT LENS FELL OFF. R & R LIGHT ASSY REF AMM 33-51-01SDR SWAA2026020265938Panel · crackedAFT RH CARGO PANEL 142DW HAS CRACKED ON LOWER EDGE AT CAPSTRIP. REMOVED AND REPLACED PER AMM 50-10-02-401, CARGO COMPARTMENT SIDEWALL LINERS.SDR SWIA2026020275107Check Valve · faultedON TAKEOFF FROM PSC, RT MAIN GEAR DID NOT COME UP ALL THE WAY. RECEIVED RED MLG LEVER DISAGREE MESSAGE. RT MLG STILL SHOWED RED. RAN QRH WITH GEAR LEVER DOWN, RECEIVED 3 GREEN. CYCLED GEAR AGAIN, RT MLG HUNG UP, NOT RETRACTING. (FLIGHT 4744) TROUBLESHOT ISSUSDR AALA202602026720Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS AFT LAVATORY-D DOOR HARD TO OPEN. ADJUSTED DOOR HEIGHT. PER CMM 25-40-64.SDR AALA202602024030Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED THAT THE FORWARD LAVATORY DOOR IS HARD TO OPEN. LUBRICATED DOOR LOCKING MECHANISM. PER CMM 25-40-61.SDR AALA202602020992Acm · seizedAIRCRAFT WAS NOT GROUNDED: ON APPROACH AT AROUND 10,000 FT NOTED SMOKE ODOR AND HAZE IN COCKPIT FLIGHT ATTENDANT NOTED AS WELL. ACCOMPLISHED J/C 72L00021001 FOUND LEFT HAND ACM SEIZED. REMOVED AND REPLACED LEFT HAND ACM-AIR CYCLE MACHINE (AALA202602024265) ANDSDR AALA202602029276Valve · failedAIRCRAFT WAS NOT GROUNDED: ON APPROACH AT AROUND 10,000 FT NOTED SMOKE ODOR AND HAZE IN COCKPIT FLIGHT ATTENDANT NOTED AS WELL. ACCOMPLISHED J/C 72L00021001 FOUND LEFT HAND ACM SEIZED. REMOVED AND REPLACED LEFT HAND ACM-AIR CYCLE MACHINE (AALA202602024265) ANDSDR ASAA2026013064062Guide Arm · out of adjustTHE R-1 DOOR IS DIFFICULT TO CLOSE, WHILE CLOSING THE AFT SIDE OF THE DOOR IS NOT MOVING OUTBOARD ENOUGH. GROUNDED - YES. FOUND THE R-1 DOOR GUIDE ARM OUT OF ADJUSTMENT, ADJUSTED THE GUIDE ARM TO WITHIN LIMITS REF AMM 52-41-00-820-801 STEP 2I.THE R-1 DOOR OPERSDR ASAA2026013064061Door · no discrepancyCATERING REPORTS L2 DOOR HARD TO OPEN. GROUNDED - YES. OPENED AND CLOSED THE L2 DOOR 2X REF AMM 52-13-00. OPS NORMAL.SDR ASAA2026013064044Jam-Nut · backed outL1 DOOR DIFFICULT TO OPEN & CLOSE. GROUNDED - YES. PERFORMED GVI OF GUIDE ARM REF. AMM 52-11-00, FOUND JAM NUT FOR GUIDE ARM FULLY BACKED. J.C. 1093779 01/30/26. OFF DIMENTIONS OF FWD AND AFT EDGE WERE OUT OF LIMITS. ADJUSTED PER AMM 52-11-00, DOOR STILL DIFFISDR ASAA2026013064043Power Supply · faultedROW 16 ABC EXIT SIGN COVER MISSING. GROUNDED - YES. RMVD AND REPLACED ROW 16 ABC EXIT LIGHT ASSY, DURING OPS CHK FOUND 16 ABC / 16 DEF EXIT LIGHTS BOTH INOP. RMVD AND REPLACED PWR SUPPLY FOR BOTH 16 ABC 16 DEF, OPS CHKS GOOD TEST / OPS CHKS GOOD REF: MM 33-51-SDR IPXA2026020247576Handle · brokenCREW ENTRY WAY ASSIST HANDLE BROKEN. REPLACED THE CREW ENTRYWAY ASSIST HANDLE IAW IPC 52-12-51-01.SDR IPXA2026020246985Lamp · inoperativeEMERGENCY EXIT LIGHT- MANY LAMPS INOP. RELAMPED ALL EMERGENCY EXIT LIGHT, OPS CHECKS NORMAL IAW AMM 33-51-00-501.SDR IPXA2026013058217Warning Message · illuminatedLEFT FWD ENTRY DOOR EICAS MESSAGE ON PUSH BACK, DMP C/W IAW MEL 52-71-1-1A.SDR IPXA2026020246402Handle · fodCANNOT SECURE THE ENTRY DOOR FROM THE INSIDE. REMOVED DEBRIS FROM EXTERIOR DOOR HANDLE, OPERATED DOOR FROM INSIDE AND OUTSIDE OPS CHK NORMAL IAW AMM: 52-12-00/201SDR IPXA2026020258624Pump · failedCLIMBING THRU FL 300 ALL 4 INNER TANK PUMPS FAILED. DIVERTED TO LOUISVILLE SDF. DEFERRED PER MEL 28-21-09-1. DMP C/W PLACARD INSTALLED.SDR DALA2026020200780Battery Pack · no testDURING A SERVICE CHECK, LAST 5 ROWS AND AFT GALLEY EMERGENCY LIGHTS OUT. R & R THE BATTERY PACK M1673 IAW AMM 33-51. OPS CHKD GOOD.SDR DXTA2026020206739Battery Pack · defectiveWHEN PLANE IS POWERED IN EMERGENCY LIGHTS ARE ON THE ARM OR OFF POSITION. ALL EMERGED LIGHTS ARE OFF AS EXPECTED. WHEN THE AP IS SHUTDOWN THE FWD EMERGENCY LIGHTS ARE RECEIVING POWER & ON. THIS INCLUDES THE EXTERIOR EMERGENCY LIGHTS TO RT OF CABIN DOOR AS WELLSDR AALA202602023189Mechanism · stickingAIRCRAFT WAS NOT GROUNDED: DOOR 1L ARMING LEVER VERY STIFF. MAINTENANCE CLEANED, LUBRICATED 1L DOOR GIRT BAR FLOOR ATTACH POINTS (AALA202601318829) AND THE SLIDE ARMING LEVER CONTROL HANDLE MECHANISM (AALA202602023189) PER AMM 52-11-22. A SATISFACTORY OPERATISDR AALA202602020096Light · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AND HOUSING ON SEAT 8C MISSING. MAINTENANCE INSTALLED EMERGENCY LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM.SDR AALA202602026988Coffeemaker · sparksAIRCRAFT WAS NOT GROUNDED: AFT GALLEY COFFEE MAKER (CM4) ARCING WHEN TURNED ON. MAINTENANCE REPLACED COFFEEMAKER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-35-15.SDR AALA202602026047Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202602022783Bottle · low pressureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS PRESSURE ANNUNCIATION FOR DOOR L4 ON THE DISPLAY. SLIDE PRESSURE GAUGE READS NORMAL THROUGH ITS WINDOW. MAINTENANCE SERVICED THE L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00-614-001.