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 HNAA2025120800852Control Valve · faultedBRAKE OTBD INOPERATIVE ON GEAR DOWN SELECTION. R & R NR 100 BRAKE CONTROL VALVE IAW AMM 32-41-06. OPS CHECKED GOOD. LEAK CHECKED GOOD. ACFT OK FOR SERVICE.SDR FVJA2025120800413Cooling Turbine · faultedDUCT TEMP OVERHEAT ANNUNCIATOR FOLLOWED BY SMOKE REPORTED IN CABIN. PERFORMED GROUND RUNS FOR TROUBLESHOOTING AND DUPLICATED PROBLEM. LOWER COOLING TURBINE PASSENGER LOWER COOLING TURBINE PRODUCING A DUCT OVER HEAT AND SMOKE IN CABIN. SUSPECT TURBO COOLER BEASDR DALA2025120808933Light · inoperativeSEAT 2A LIGHT INOPERATIVE.SDR DALA2025120808929Pin · corrodedDURING INSPECTION OF RT HORIZONTAL FWD AND AFT ATTACH BOLTS/PINS FOUND CORROSION ON RT AFT LOWER HORIZONTAL LUG SURFACE. COMPLIED WITH PRI 630625-14 REV 02 AND RECIVED FINAL ERA 630625-14, NO DEVIATIONS NOTED FROM PRI. JOB COMPLETE.SDR YENA2025120801176A/C Pack · odorFLT 547, ISP-MCO. ODOR EVENT ON DESENT 17FL DOWN TO 9K WITEN ISOLATION OF PACK 1 STOPPED SMELL MUSTY DIRTY SOCK OIL SMELL MD-27 OUT ODOR COCKPIT TO AFT CABIN. OPENSDR YENA2025120801175Unknown · odorFLT 1533, JFK-CTG. ON APPROACH TAXI IN AND DEPLANING AFT F/A COULD SMELL A DIRTY MUSTY SMELL CUSTOMER SAID SMELLED LIKE A SKUNK; PER INFO NOTICE 2017-T015L ACCOMPLISHED TSM 05-50-00-810-831-A AND INSPECTED APU COMPARTMENT PER AMM 49-00-00200-812-A FOR ANY EVIDSDR AALA202512081989Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 831 DAMPER AND EMERGENCY OPERATION CYLINDER FAILS THE DAMPING FUNCTIONAL TEST. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-111-14.SDR AALA202512080189Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: SMOKE LAVATORY SMOKE ECAM ALERTED IN FLIGHT FOR 2 MINUTES. FLIGHT ATTENDANTS REPORTED ALL LAVATORIES UNOCCUPIED AT TIME OF ALERT, AND NO INDICATIONS OF SMOKE OR SCENTS IN ANY LAVATORY. MAINTENANCE ACCOMPLISHED RESET OF LAVATORY SMOKSDR AALA202512088099Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT CIDS CAUTION LIGHT ON FLIGHT ATTENDANTS PANEL INDICATES MID LEFT DOOR PRESSURE LOW. MAINTENANCE SERVICED THE L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR UIEA2025120501334Warning Message · illuminatedEICAS APU INDICATION IN FLIGHT. APU DUCT LEAK STATUS MSG. QRH COMPLIED WITH (APU FIRE HANDLE PULLED)(<P>OPERATED APU FOR ABOUT 3 HOURS WITH BLEED ON, NO LEAKAGE OBSERVED AND DETECTED REF AMM 49-11-00-862-001.SDR SCNA20251208466Lamp · inoperativeEMERGENCY EXIT LOWER SIGN AT L1 DOOR IS INOPERATIVE. REPLACED L1 LOWER EXIT SIGN LIGHT LAMPS IAW AMM 33-51-01. OPS CHECK GOOD.SDR SCNA20251208465Lamp · inoperativeEMERGENCY LIGHT AT 17DEF IS INOPERATIVE. REPLACED EMERGENCY AREA LIGHT LAMP AT ROW 17DEF IAW AMM 33-51-03. OPS CHECK GOOD.SDR SCNA20251208464Lamp · inoperative14DEF NO SMOKING LIGHT INOPERATIVE. REMOVED AND REPLACED 14DEF NO SMOKING LAMPS IAW 33-25-00, OPS CHECKED GOOD.SDR CALA2025120811926Rib · crackedACCOMPLISH INSPECTION ON THE RT WING I/B FIXED TRAILING EDGE AUX D RIB. REPAIRED RT WING I/B FIX T/E AUX D-RIB ASSEMBLY UPPER O/B FLANGE REPAIR IAW ECRA 5733-01054 REV A VERIFIED ECRA 5733-01054 IS ACCOMPLISHED IN ITS ENTIRETY TO BE DIPPED PER PART 1 INTERIMSDR CALA2025120811897Battery · no testR4 DOOR EMERGENCY LIGHT BATTERY M33408 CAPACITY CHECK FAIL. BATTERY M33408 REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2025120811895Battery · no testR4 DOOR EMERGENCY LIGHT BATTERY CAPACITY CHECK FAILED. BATTERY REPLACED AND TESTED NORMAL IAW AMM 35-51-06.SDR CALA2025120811893Charger · no testR4 DOOR EMERGENCY LIGHT BATTERY CHARGER FAILED TO TEST. BATTERY CHARGER REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2025120811891Battery · no testL3 DOOR EMERGENCY LIGHT BATTERY M33405 FAILED CAPACITY CHECK. BATTERY M33405 REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2025120811889Web · corrodedL2 DOOR SILL AREA FLOOR WEB NEAR AFT GIRT BAR FITTING CORRODED FR68 S32L PERFORMED REPAIR ON L2 DOOR SILL AT FR68 IAW SRM 53-41-14-3 00-001. REPAIR IS 2 CAT A NO FUTHER ACTIONS REQUIRED.SDR CALA2025120811887Skin · gougedAFT CARGO LOWER AFT CUT OUT BS 847 BTW S23R TO S24R AT TANGENT POINT OF THE DOOR CORNER HAS GOUGE. PERFORMED REPAIR ON AFT CARGO LOWER AFT CUT OUT BS 847 BTW S23 R TO S24R IAW EO 250440, REV P1, EO 250440 REV IR, AND EC/RA 5360-02069. MINOR REPAIR.SDR CALA2025120811885Angle · crackedCABIN FLOOR SUPPORT BS 380 +3, RBL 10 STABILIZER ASSY UPPER ANGLE CORRODED. REMOVED AND REPLACED UPPER ANGLE IAW SRM 51-40-02-0G-0 AND DWG 143A5410.SDR CALA2025120811883Web · corrodedDOOR SILL AREA, FLOOR WEB NEAR AFT GIRT BAR FITTING CORRODED. REMOVED DAMAGE AND R2 DOOR SILL AREA FLOOR WEB IAW SRM 53-41-14-300-001 CAT A.SDR CALA2025120811881Lens · missingVERIFIED LENS OF FLOOR PROXIMITY LIGHT MISSING AT POSITION 11D SEAT. PERFORMED FLOOR PROXIMITY LIGHT INSTALLATION OF A NEW LIGHT AT POSITION 11D SEAT. GOOD FOR FLIGHT. IAW DMC-B787-A-33-51-06-00A-720A-A.SDR CALA2025120811879Angle · crackedCABIN FLOOR SUPPORT BS 380 - 400, BL 0 STABILIZER ASSY UPPER ANGLE CRACKED. REMOVED AND REPLACED UPPER ANGLE IAW SRM 51-40-02-0G-0, AND DWG 143A5410.SDR CALA2025120811877Angle · crackedCABIN FLOOR SUPPORT BS 380-400, LBL 13 STABILIZER ASSY UPPER ANGLE CRACKED. REMOVED AND REPLACED THE UPPER CHORD IAW SRM 51-40-02-0G-0 AND DWG 143A5410.SDR CALA2025120811875Battery Pack · inoperativeEMERGENCY LIGHT ABOVE SEAT ROW 12DEF INOPERATIVE. REMOVED UNSERVICEABLE BATTERY PACK AT BATTERY SUPPLY UNIT M1695 IAW AMM 33-51-06. INSTALLED SERVICEABLE BATTERY PACK IAW AMM 33-51-06. PERFORMED OPS TEST OF NEW SERVICEABLE BATTERY PACK IAW AMM 33-51-06, SUSDR CALA2025120811873Angle · corrodedUPON REMOVAL OF TRANSITION PANEL AT AFT CARGO BAY BS 1360 - 1380, S26R - S27R, FOUND WEB ASSY WITH CORROSION. REMOVED AND EVALUATED DAMAGE AT WEB ASSY AND FOUND WITHIN LIMITS IAW SRM 53-60-04-1A, AFTER FURTHER EVALUATION CORROSION IN ANGLE NOTED, EVALUATESDR CALA2025120811871Drag Fitting · crackedRIGHT UPPER WING SKIN AND DRAG FITTING HAD A CRACK INDICATION, NOTED IN HOLE NR 4 IN ALL LAYERS. ACCOMPLISHED ECRA 5720-03589 AND VT MAE EA 757-5720-13-A4212 REV-.SDR CALA2025120811869Skin · deformedAFT CARGO DOOR SKIN DEFORMED. REMOVED, FABRICATED, AND INSTALLED NEW AFT CARGO DOOR EXTERNAL SKIN IAW SRM 51-40-02-0G-0 SRM 52-30-01-2R-3 AND DWG#146A6110.SDR CALA2025120811867Tee Angle · corrodedCORROSION FOUND AT TEE CHORD LOWER SURFACE AT BS 900 BOTTOM SECTION. PERFORMED TEE CHORD REPAIR ON BS 900 BOTTOM, FABRICATED PARTS ON TRAVELER'S T25/1841651, T25/1841652 AND T25/1841653 IAW SRM 51-70-06, APPLIED TREAT, PRIMER, TOP COAT AND CIC.SDR CALA2025120811865Frame · deformedAFT CARGO BAY, BS 1560, S25L-S26L FRAME HAS 2 DENTS. COMPLIED WITH EC/RA 5360-02067, AND VT MAE EA 757-5360-13-A4218 REV-.SDR CALA2025120811863Wire Harness · damagedDAMAGE FOUND TO NR 2 ENG ON LOOM FROM PYLON DISCONNECT TO EEC CONNECTOR D11686. HARNESS DISCONNECTED FOR FURTHER TROUBLESHOOTING. FOUND BENT PIN T ON CONNECTOR D11686. FOUND DAMAGE TO EEC CONNECTOR F THAT CONNECTES TO D11686. EEC REPLACEMENT CARRIED OUT ON SDR CALA2025120811861Stringer · corrodedSTRINGER 27L HAS CORROSION BETWEEN BS 360 & 380 AT PRODUCTION SPLICE. CUT STRINGER 27L FROM BS 338 TO FACTORY SPLICE AND FROM FACTORY SPLICE IAW SRM 51-10-02. STR 27L FWD OF FACTORY SPLICE WILL NOW BE COVERED BY LOG PAGE 7064237. PERFORMED HFEC INSPECTION OFSDR CALA2025120811828Girt Bar · no discrepancy1R GIRT BAR DIFFICULT TO OPERATE. EXCESSIVE DRAG PERFORMED OPERATIONAL CHECK OF DOOR 1R IAW AMM 52-00-00, OPS CHECKED GOOD, DOOR CLOSES FINE. PERFORMED ESCAPE SLIDE PACK CHECK OF DOOR 1R IAW AMM 25-66-01, OPS CHECK GOOD, GIRT BAR STOWED CORRECTLY.SDR CALA2025120811827Slide · faultyFOUND R1 DOOR SLIDE PRESSURE LOW. REMOVED R1 SLIDE. PARTIALLY INSTALLED NEW SLIDE, NEW SLIDE CAME WITH INCORRECT GIRT BAR. GIRT BAR NEEDS REPLACED IAW AMM TASK 25-66-01-404-044 UP TO AND INCLUDING STEP H(17). VERIFIED SLIDE INSTALLATION UP TO AND INCLUDINSDR CALA2025120811824None · noneROW 39 EMERGENCY CHECKLIST OUT OF DATE ROW 39 EMERGENCY CHECKLIST OUT OF DATE WAS CONFUSED FOR DATE CHECKED. FOUND EMERGENCY EQUIPMENT TO BE SERVICEABLE.SDR CALA2025120811823Lamp · inoperativeCOCKPIT EMERGENCY EXIT LIGHTS NOT ARMED LIGHT PARTIALLY INOPERATIVE. RELAMPED EMERGENCY LIGHTS NOT ARMED ANNUNCIATOR IAW AMM 33-18-00. OPS CHECKED GOOD.SDR CALA2025120811822Ground Wire · looseEXTERIOR EMERGENCY LIGHT AT DR-1L INOP CLEANED LAMP SOCKET AND RELAMPED SEVERAL TIMES NO HELP. REPLACED POWER SUPPLY AND BATTERY NO HELP. MEASURED 5V AT EXTERIOR LAMP SOCKET. MEASURED 6V AT INTERIOR EMERGENCY LAMP SOCKET. DEFERRED EMERGENCY SLIDE EXTERIOR LIGHSDR CALA2025120711820A/C Pack · failedLEFT PACK TRIPPED OFF UNCONTROLLABLE TEMP EVEN AFTER RESET REQUESTING MEL 2151AM. FMCS BITE AGREES WITH POSITION WITH PACK. NO LOW AIR SUPPLY MESSAGE. BITE TEST OF CPC 1 . NO PRESENT FAULTS. BITE TEST OF CPC 2. NO FAULTS. APPROVED IAW MEL 2151AM ECS AGREES WISDR CALA2025120711819Engine · odorROTTEN ODOR FROM PACK SYSTEM, BELOW 19000 FEET WC 29-0572-8-0107 INSP EA 7200-02341, NR 1 ENGINE CORE WASH WAS PERFORMED ON ENGINE 1. RESULTING IN ODOR. NO OTHER HISTORY NOTED OK TO CONTINUE.SDR ABXA202512065320Pump · low pressureDURING TAXI OUT, RT AFT FUEL PUMP LOW PRESSURE LIGHT AND EICAS MESSAGE CAME ON, ACFT RETURNED TO THE GATE (BTB) AND MTX GROUNDED A/C , MTX DEFERRED RT AFT FUEL PUMP IAW MEL 28-22-1. AND RETURNED A/C TO SERVICE.SDR AALA202512053642Flashlight · no testAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTENDANT FLASHLIGHT FLASHES RED DURING PUSH TO TEST. REMOVED AND REPLACED L1 FLASHLIGHT BATTERY. OPS CHECKED GOOD IAW AMM 25-64-00.SDR AALA202512057776Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: AFT LEFT HAND OUTBOARD FLASHLIGHT NOT CHARGING. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY, OPS CHECKED GOOD IAW AMM 25-64-00.SDR AALA202512059539Sign · inoperativeAIRCRAFT IN BASE MAINTENANCE: DURING PS CHECK, FOUND L2 EXIT SIGN ABOVE FLIGHT ATTENDANT JUMPSEAT INOPERATIVE. (OPEN).SDR QMLA2025120520121Transfer Pump · failedFAILED AFT FUEL TRANSFER PUMP.SDR DALA2025120508902Wire · damagedFLOOR PROXIMITY LIGHTS ARE INOP SEAT ROWA 4,5 AND MID GALLEY 2(2 WHITE) AND LAV "V" RED. INSPECTED MOLEX CONNECTOR ON SEAT 4. 5 AND 6- ALL ARE SECURE. INSPECTED SEAT TO SEAT WIRING AND FOUND ONE RED WIRE IN FRONT OF SEAT 5CD DAMAGED. REFERENCE B757 WD 33- 51-SDR DALA2025120508901Lanyard · unsecureL4 DOOR NOT ARMING. LANYARD HANGING OUT OF DOOR. RESTOWED LANYARD & BUSTLE AT 4L DOOR. DOOR ARMS NORMALLY. (6789006)SDR DALA2025120508897Power Supply · inoperativeL2 DOOR OUTSIDE EMERGENCY LIGHT INOP. CORRECTIVE ACTION: REMOVED AND REPLACED M730 POWER SUPPLY PER B757 AMM 33-51 OPS NORMAL. SEE LOG PAGE 7646084. (7646087)SDR DALA2025120508896Power Supply · inoperativeL1 DOOR OUTSIDE EMERGENCY LIGHT INOP. REMOVED AND REPLACED M730 POWER SUPPLY PER B757 AMM 33-51. OPS NORMAL. SEE LOG PAGE 7646084. (7646086)SDR DALA2025120508895Drag Angle · damagedA.D.//A.A. DAMAGES WERE FOUND ON OPEN HOLES AT RH ENG DRAG FTG AS FOLLOW; HOLE #2 SCRATCHES ON SKIN & FITTING 1 O CLOCK POSITION, HOLE #4 GOUGE ON FITTING 9 O CLOCK POSITION, IN REF. CARD 5720-01100-04B. JOB # 108-0001 STEP 20. RH ENG DRAG FTG WAS REPAIRED PE