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 SWAA2025122947745Fitting · looseFWD SERVICE DOOR FWD SLIDE SHROUD GIRT BAR ATTACHMENT FITTING IS LOOSE. FWD SERVICE DOOR FWD GIRT BAR SLIDE ATTACHMENT FITTING IS LOOSE. REMOVED AND REPLACED FWD SERVICE DOOR FWD SLIDE SHROUD GIRT BAR ATTACHMENT FITTING FASTENERS PER SRM 51-40-02.SDR SWAA2025122941588Fastener · looseFWD ENTRY DOOR FWD GIRT BAR ATTACHMENT FITTING IS LOOSE. REMOVED AND REPLACED FWD ENTRY DOOR FWD SLIDE SHROUD GIRT BAR ATTACHMENT FITTING FASTENERS IAW SRM 51-40-02 3.SDR SWAA2025122941590Fastener · looseFWD SERVICE DOOR FWD GIRT BAR ATTACHMENT FITTING IS LOOSE. REMOVED AND REPLACED FWD SERVICE DOOR FWD SLIDE SHROUD GIRT BAR ATTACHMENT FITTING FASTENERS IAW SRM 51-40-02 3.SDR SWAA2025122941322Attach Angle · crackedCRACK FOUND ON BS 663 VAPOR BARRIER UPPER ATTACH ANGLE AT RBL 34. REMOVED THE VAPOR BARRIER ATTACH ANGLE IAW SRM 51-40-02. COMPLIED WITH OPEN HOLE INSPECTION FOR THE REMOVED ATTACH ANGLE IAW NDT MANUAL PART 6, 51-00-00, PROC 16. NO FAULTS FOUND. THE ATTACH ASDR SWAA2025122947178Attach Angle · crackedCRACK FOUND ON BS 663 VAPOR BARRIER UPPER ATTACH ANGLE AT LBL 9. CUT OUT AND REMOVED CRACKED SECTION OF VAPOR BARRIER ANGLE IAW SRM 57-10-10-2R-5. COMPLIED WITH OPEN HOLE INSPECTION FOR THE REMOVED ATTACH ANGLE IAW NDT MANUAL PART 6; 51-00-00 PROC.16. NO FSDR SWAA2025122941499Attach Bracket · crackedSEAT TRACK NR 1 ATTACH BRACKET HAD POSSIBLE CRACK AT RADUIS BS 727B. VERIFIED CRACK INDICATION PER NDT PART 6 51-00-00 PROCEDURE 23. REMOVED THE SEAT TRACK NR 1 ATTACH BRACKET IAW SRM 51-40-02. MATCHED DRILLED FASTENER HOLES IN SPLICE STRAP IAW SRM 51-40-0SDR SWAA2025122941502Attach Bracket · crackedSEAT TRACK NR 4 ATTACH BRACKET HAS POSSIBLE CRACK AT RADUIS BS 727B. VERIFIED CRACK INDICATION PER NDT PART 6 51-00-00 PROCEDURE 23. REMOVED SEAT TRACK NR 4 ATTACH BRACKET SPLICE STRAP IAW SRM 51-40-02. MATCHED DRILLED FASTENER HOLES FOR THE NR 4 ATTACH BRASDR SWAA2025122941324Angle · crackedCRACK FOUND ON BS 663 VAPOR BARRIER UPPER ATTACH ANGLE AT RBL 9. CUT OUT AND REMOVED CRACKED PORTION OF VAPOR BARRIER ANGLE PER SRM 57-10-10-2R-5. COMPLIED WITH OPEN HOLE INSPECTION FOR REMOVED ATTACH ANGLE IAW NDT MANUAL, PART 6, 51-00-00, PROC 16. NO FAULSDR SWAA2025122341392Scuff Plate · crackedCRACKED AFT CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT. REPAIRED AFT CORNER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025122341393Scuff Plate · crackedCRACKED FWD CORNER SCUFF PLATE AT FWD CARGO BAY. REPAIRED FWD CORNER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025121941613Support Web · crackedCRACK SUPPORT WEB LOCATED OUTBOARD FAN COWL ON ENGINE. REPLACED WEB AND FASTENERS LOCATED OUTBOARD FAN COWL ON ENGINE 2 IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND CMM 71-13-30, REV 32, PAGE 10118, DETAIL P.SDR SWAA2025121841323Attach Angle · crackedCRACK FOUND ON BS 663 VAPOR BARRIER UPPER ATTACH ANGLE, LBL 9. CUT OUT AND REMOVED THE CRACKED SECTION OF THE ATTACH ANGLE IAW SRM 57-10-10-2R-5. COMPLIED WITH OPEN HOLE INSPECTION FOR THE REMOVED ATTACH ANGLE IAW NDT MANUAL, PART 6, 51-00-00, PROC 16. NO SDR SWAA2025121841612Rib · crackedCRACK LEADING EDGE RIB AT STA 95.96 OF THE RT HORIZONTAL STAB. REPLACED THE RIB IAW SRM 51-10-02, ITEM 9, AND INSTALLED FASTENERS IAW SRM 51-40-02, AND DRAWING 186A1001, SHEET 10, REV A.SDR SWAA2025121741123Housing · crackedAFT ENTRY CEILING EXIT LIGHT HOUSING IS CRACKED. REPLACED AFT ENTRY CEILING EXIT LIGHT IAW AMM 33-51-01-960-802. OPS TESTED GOOD IAW AMM 33-51-01-960-802, STEP 3.C.(7), AMM 33-51-00-710-801 & AMM 33-51-00-720-801. OPS TEST GOOD.SDR SWAA2025121241367Floorboard · delaminatedPASSENGER CABIN FLOORBOARD 231QF DELAMINATED. REMOVED AND REPLACED THE FLOORBOARD IAW AMM 53-21-00.SDR CALA2025121012004Frame · dentedONE DENT ON BS 1560 FRAME, BETWEEN STRINGERS 25R & 26R. PERFORMED A REPAIR IAW EA 757-5360-13-A4206, AND ECRA 5360-02065.SDR SWIA2025120900001Apu · faultedAPU OIL TEMP CAUTION AT CRUISE. (FLIGHT 5116) REF AML 1760814, REF AML 1760819, REF AML 1760821, DEFERRING APU IAW MEL 49-10-1A. REMOVED & REPLACED APU ASSY, & APU GENERATOR. OPS CHKD GOOD. APU OIL TEMP CAUTION NO LONGER DISPLAYED. DMI CLEARED AND PLACARSDR DALA2025120908983Lamp · inoperativeR2 SERVICE DOOR SLIDE ARMED INDICATING LIGHT SYSTEM. REPLACED THE LAMP IN THE FWD ENTRY DOOR WARNING LIGHT, TEST OK. (1330114)SDR AALA202512092913Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER REMOVABLE LEADING EDGE PANEL 331B IS CRACKED RIB AT LEADING EDGE BS 95.96. THE CRACKED RIB WAS REMOVED AND REPLACED WITH A NEW SERVICEABLE RIB. PER B737NG AARD 51-00-05-01 DRAWING #186A1001.SDR AALA202512094765Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER REMOVABLE LEADING EDGE PANEL 331B HAS A CRACKED RIB AT LEADING EDGE BS 105.26. THE CRACKED RIB WAS REMOVED AND REPLACED WITH A NEW SERVICEABLE RIB. PER B737NG AARD 51-00-05-01 DRAWING #186A1001.SDR SWAA2025120841318Support · crackedNUMBER 1 PYLON AFT FAIRING, AFT WEDGE CRACKED AT T/E SUPPORT. EVALUATED DAMAGED AFT WEDGE ASSEMBLY AND FOUND COMPONENT UNSERVICEABLE IAW SRM 54-50-90-1A-1. REMOVED AND REPLACED NR 1 ENGINE PYLON AFT WEDGE ASSY IAW SRM 51-40-02-0G-0, AND DWG 313A2752, SHEET 0SDR SWAA2025120841440Fitting · looseDURING OK TO CLOSE FWD ENTRY DOOR FOUND ESCAPE SLIDE GIRT BAR FITTING LOOSE. TIGHTENED FWD ENTRY DOOR ESCAPE SLIDE GIRT BAR FITTING IAW AMM 25-66-02-400-801.SDR SWAA2025120841438Fitting · looseDURING OK TO CLOSE AFT GALLEY DOOR FOUND SCAPE SLIDE GIRT BAR FITTING LOOSE. TIGHTENED AFT GALLEY DOOR ESCAPE SLIDE GIRT BAR FITTING IAW AMM 25-66-02-400-801.SDR SWAA2025120841439Fitting · looseDURING OK TO CLOSE, AFT ENTRY DOOR FOUND ESCAPE SLIDE GIRT BAR FITTING LOOSE. TIGHTENED AFT ENTRY DOOR ESCAPE SLIDE GIRT BAR FITTING IAW AMM 25-66-02-400-801.SDR DALA2025120808960Skin · crackedCRACK ON FUSELAGE SKIN BS 1037, BTW L-14L AND L-13L. FUSELAGE SKIN BS 1037 BTW L-14L AND L-13L WAS REPAIRED IAW PRI 630562-14 REV 5 AND ER/ A 630562-14 REV. (1330895)SDR AALA202512086906Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ASSEMBLY AT GALLEY M1 BROKEN LOCATED NEAR LAVATORY 2F-1R. **SUPPLEMENTAL REPORT FOR (AALA202512026906) SUBMITTED ON 12/02/2025 BY DFW: REPLACED EMERGENCY LIGHT ASSEMBLY. PER CMM 25-06-39**(CLOSED).SDR AALA202512080272Light · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT MOUNTED ON SEAT ROW 25 ABC IS INOPERATIVE. REPLACED LIGHT ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPS CHECKED IAW AMM 33-51-11.SDR CALA2025120811843Floor Support · corrodedCORROSION AFT WET AREA FLOOR SUPPORT BETWEEN BS 947.5 AND 967, RBL 16. REMOVED AND REPLACED THE FLOOR SUPPORT FROM BS 947.7 - 967, RBL-16 IAW SRM 51-40-02-0G-0 AND DWG 147A5650.SDR CALA2025120811841Skin · delaminatedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, LOWER SKIN DEBONDED, L=2 X W 1.5 INCHES. CLEANED, PREPPED, PERFORMED PERMANENT REPAIR, & RESTORED FINISH ON RT WING OTBD AFT FLAP LWR SKIN IAW SRM 57-53-01-2R-16, SRM 51-70-10-2R-0, AND AMM 51-21-99-300-801.SDR CALA2025120811839Skin · delaminatedRIGHT WING, OTBD FLAP, AFT FLAP, INBD END, UPPER SKIN WITH DISBONDED AREA, L=1 X W=1 INCHES. CLEANED, PREPPED, PERFORMED PERMANENT REPAIR AND RESTORED FINISH ON RT WING OTBD AFT FLAP UPPER SKIN IAW SRM 5 7-53-01-2R-16, SRM 51-70-10-2R-0, AND AMM 51-21-99-300-SDR KKVA20251205001Compressor · contaminatedAIRCRAFT DEPARTED BCT, ON INSTRUMENT FLIGHT PLAN IN VMC CLIMBING THROUGH 4,000’ MSL, CREW NOTICED AN ODOR, PASSENGERS ALERTED CREW OF A FOG & SMELL IN CABIN. FLT ATTENDANT EVACUATED HER SEAT TO INVESTIGATE POSSIBLE SOURCE & CONFIRMED SOURCE WAS NOT ORIGINATINGSDR AALA202512050272Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT MOUNTED ON SEAT ROW 25 ABC IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR ABXA202512051314Warning Message · illuminatedDURING MAINTENANCE INSPECTION, RT ENG FIRE LOOP 2 STATUS MESSAGE ILLUMINATED. ITEM PLACED ON MEL ABX 26-11-1-1. PLACARD INSTALLED MBCM DATE 12/11/2025. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025120508881Stringer · failed inspGAP BETWEEN R/H S-18A WEB AND STA 727 INNER CHORD FOUND TO BE GREATER THAN 0.006". REPAIRED BY INSTALLING SHIM PER FORECAST CARD 38-0553-8-0156 WORK CARD 5311-01251-02B.SDR CALA2025120511783Wire · brokenEMERGENCY LIGHT AT ROW 35ABC IS INOPERATIVE. RELAMPED NO HELP. VERIFIED THAT NO TWO ADJACENT EMERGENCY LIGHTS ARE INOPERATIVE. VERIFIED THAT ITS THE RED LIGHT THAT WERE INOPERATIVE AND VERIFIED BLUE LIGHTS WORK CORRECLTY. DEFERED UNDER MEL 3350C, COMPLIESDR ASAA2025120162740Power Supply · intermittentR2 EMERGENCY EXIT LIGHTS FLASHED ON & OFF INTERMITTENTLY DURING INITIAL CLIMB. OCCURED AT ROTATION. GROUNDED - YES. FOUND TEST BUTTON ON AFT RT POWER SUPPLY STICKING/ INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AFT RT SIDE REF AMM 33-51-06. OPS CHK GOOD. OKSDR SWAA2025120441101Flashlight · no testTWO FLASHLIGHTS AFT GALLEY RIGHT SIDE WILL NOT TEST. R & R BOTH AFT GALLEY RT FLASHLIGHTS IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025120442746Flashlight · no testTWO FLASHLIGHTS AFT GALLEY RIGHT SIDE WILL NOT TEST.SDR SWAA2025120441420Fuel Sys · leakingUPON TRYING TO START THE NR 1 ENGINE, RAMP NOTICED A LARGE AMOUNT OF FUEL DRIPPING FROM THE NR 1 COWLING.SDR DALA2025120408877Unknown · odorCREW REPORTED DIRTY SOCK SMELL ON DESCENT. PILOTS ON O2 AND EMERGENCY DECLARED. T/S PER MSI WORKCARDS. ISOLATED PNEUMATIC SYSTEM, RAN ENGINES USING P-TRAK. NO ABNORMAL ODORS PRESENT. REPLACED RECIRC FILTERS. NO ODORS. ACFT RTS. (LP# 8035472)SDR DALA2025120408875None · noneDAMAGE TOLERANCE EVALUATION. ERA 621788-14, REV B, PROVIDES STAGE 2 APPROVAL FOR SECTION IV REPAIR. FOLLOW ON ACTION IS REQUIRED ON THE FUSELAGE SKIN FWD OF FR 15, STR. 6R - STR 8R. MAJOR REPAIR, SDR YES. ACCOMPLISH ERA 621788-14 REV B SECTION V WITHIN 15,000SDR AALA202512040737Lamp · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT LEFT SIDE SEAT ROW 15 IS INOPERATIVE. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202512046844Lamp · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT LEFT SIDE SEAT ROW 19 INOPERATIVE. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202512046466Control Unit · faultedAIRCRAFT WAS GROUNDED: AIRCRAFT DIVERTED TO DFW DUE TO THE FLIGHT CREW REPORTING A POTENTIAL FUEL LEAK LEFT SIDE (#1) FUEL TANK SYSTEM. AFTER GETTING AN ECAM FUEL CENTER TANK PUMP LOW PRESSURE. FLIGHT CREW DIDN'T NOTICE A FUEL IMBALANCE BUT AFTER MONITORING THSDR AALA202512041589Lamp · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT LEFT SIDE SEAT ROW 14 IS INOPERATIVE. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202512042088Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512043015Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512044153Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202512043491Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT PASSENGER / DREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512041376Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.