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 AALA202509263952Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE, EXCESSIVE PLAY ON HINGE ARM END FITTING BEARING NR 4 ON LT ELEVATOR. MAINTENANCE REPLACED HINGE ARM END FITTING NR 4 ON LT ELEVATOR IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR CALA2025092609315Skin · crackedTWO CRACKS SIGNAL NOTED AT STAB RH SIDE HSS 147.90, FIRST CRACK L=1 INCH LOCATED TO 9.125 INCH FWD FROM AFT SPAR, SECOND CRACK L=1.500 INCH LOCATED TO 16.500 INCH FWD FROM AFT SPAR. PERFORMED PERMANENT REPAIR AT RT SIDE HORIZONTAL STABILIZER HSS 147.90, LOCATESDR CALA2025092609314Skin · crackedCRACK SIGNAL NOTED AT STAB RH SIDE HSS 129.50, L=0.500 INCH LOCATED TO 9 INCH AFT FROM FRONT SPAR. PERFORMED PERMANENT REPAIR AT RH SIDE HORIZONTAL STABILIZER HSS 129.50, LOCATED 9 INCHES AFT OF FRONT SPAR, THIS REPAIR IS CATEGORY "B", REQUIRES REPETITIVE INSSDR CALA2025092609291Floor Support · corrodedAFT CABIN FLOOR RT CREASE BEAM CORRODEED BETWEEN BS 1340 - 1405 UNDER FLOORBOARD 252FF AND 252GF. CORRODED CABIN FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND SRM 51-40-05.SDR DALA2025092507001Seat Track · corrodedAFT FUSELAGE SEAT TRACK CORROSION RBL 23.0 AT FRAME 72 AND EXTENDING UNDER NICKEL MAT. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. REMOVED AND REPLACED TRACK REF A220 ASRP 51-77-00. (LP# 1209371)SDR DALA2025092507000Seat Track · corrodedAFT FUSELAGE SEAT TRACK CORROSION LBL 43.5 AT FRAMES 71-72 AND EXTENDING UNDER NICKEL MAT. SSI: 53-61-43-01. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. (M)(P). REMOVED AND REPLACED TRACK REF A220 ASRP 51-77-00.SDR AALA202509259225Outlet · corrodedAIRCRAFT WAS GROUNDED, AFT LAVATORY VACUUM VENT OUTLET APPEARS TO HAVE CORROSION. (OPEN)SDR DXTA2025092405035Pin · fodAFTER LANDING, MAIN CABIN DOOR WAS VERY DIFFICULT TO OPEN AND CREW WAS UNABLE TO LOCK THE DOOR FROM THE INSIDE. TECHS CLEANED ALL DIRT AND DEBRIS FROM THE LOCKING PINS AND THEIR RESPECTIVE PIN SOCKET TECHS LUBRICATED ALL LOCKING PINS ON THE MAIN CABIN DOOR ASDR DXTA2025092405030Uplock Switch · faultedAFTER SELECTING LANDING GEAR UP DURING TAKEOFF, NOSE GEAR REMAINED DOWN FOR APPROXIMATELY 15 TO 20 SECONDS. GEAR DISAGREE N CAS MESSAGE + A SECOND AMBER CAS MSG DISPLAYED (DO NOT RECALL WHICH MSG SPECIFICALLY). AFTER 20SEC, NOSE GEAR CAME UP AND CAS MSG WAS SDR ASAA2025092061008Door · out of limitsF/A REPORT R1 DOOR DIFFICULT TO CLOSE. GROUNDED - YES. PERFORMED GALLEY SERVICE DOOR SYSTEM TEST. R1 DOOR CLOSE FORCE IS WELL ABOVE 600 IN-LBS AND IS OUT OF LIMITS. REF AMM 52-41-00. FOUND R1 DOOR OUT OF RIG, ADJUSTED R1 DOOR REF AMM 52-41-00, AND PERFORMED DOSDR ASAA2025092060983Cover · detachedFA'S FOUND EMERGENCY SIGN COVER FELL OFF AT ROW 16 ABC. GROUNDED - YES. REINSTALLED EMERGENCY COVER REF AMM 33-51-01.SDR ASAA2025092060981Battery · inoperativeMULTIPLE EMERGENCY LIGHTS OUT IN CABIN. GROUNDED - YES. WORK PERFORMED ON WO: 1023397-2000-0115 C/C: N8233008 SN: 9680137. (S/N 428895)SDR ASAA2025092060980Battery · inoperativeMULTIPLE EMERGENCY LIGHTS OUT IN CABIN. GROUNDED - YES. WORK PERFORMED ON WO: 1023397-2000-0115 C/C: N8233008 SN: 9680137. (S/N 426347)SDR SWAA2025092316551Pressure Deck · crackedFLIGHT DECK AFT FLOOR WEB DENT WITH CRACKS AT STATION 255 AND LBL 3. REMOVED AND REPLACED WEB SECTION PER SRM 51-40-02 AND IAW EA M-21-153-00734 WHICH HAD BEEN INITIALLY REPLACED ON NR TTG8Q0100AU9 DURING ACCOMPLISHMENT OF EA M-21-153-00734.SDR SWAA2025092316611Panel · crackedFWD CARGO PANEL 122AW HAS MULTIPLE CRACKS WITHIN 2 INCHES OF THE EDGE. REPAIRED CARGO PANEL 122AW IAW EA# M-21-125-00669.SDR SWAA2025092316610Panel · cracked141FW HAS MULTIPLE CRACKS WITHIN 2 INCHES OF THE EDGE. REMOVED AFT CARGO PANEL 141FW IAW AMM 25-52-10. FOUND MULTIPLE BROKEN NUT PLATES. REMOVED AND REPLACED AFTER CARGO PANEL 141FW IN REF TO AMM 255-52-06.SDR SWAA2025092316609Floor Panel · cracked142FW HAS CRACK WITHIN 2 INCHES OF THE EDGE. ALONG WITH WRONG SCREWS INSTALLED IN CAP STRIP. REMOVED AFT CARGO PANEL IAW AMM 25-52-10. FOUND MULTIPLE BROKEN NUT PLATES. REMOVED AND REPLACED AFT CARGO PANEL 142FW IN REF TO AMM 25-52-06.SDR SWAA2025092316607Floor Panel · crackedFWD CARGO PANNEL 122EW HAS MULTIPLE CRACKS WITHIN 2 INCHES OF THE EDGE. REPAIRED CARGO PANEL 122EW IAW EA# M-21-125-00669.SDR SWAA2025092316469Panel · crackedAFT CARGO PANEL 142FW HAS 2 CRACKS COMING FROM CAP STRIP AREA. PATCHED CRACKS PER EA M-21-125-00669.SDR SWAA2025092316650Megaphone · inoperativeAFT GALLEY MEGAPHONE GREEN LIGHT DOESN'T BLINK AFTER REPLACING BATTERIES. AFT GALLEY MEGAPHONE R & R IAW AMM 25-64-00-SWA-806-MAX-01.SDR SWAA2025092316459Megaphone · inoperativeAFT GALLEY MEGAPHONE GREEN LIGHT DOESN'T BLINK AFTER REPLACING BATTERIES. REPLACED AFT GALLEY MEGAPHONE; OPS CHECK GOOD REF AMM 25-64-00.SDR SWAA2025092316622Flashlight · inoperativeAFT LEFT F/A FLASHLIGHT INOPERATIVE. OPERATED AFT LEFT OTBD FLASHLIGHT TEST IAW AMM 25-64-00. CKS OK.SDR SWAA2025092316604Girt Bar · out of adjustFORWARD SERVICE DOOR GIRT BAR EXTENDED MORE THAN NORMAL. ADJUSTED FWD SERVICE DOOR GIRT BAR PER AMM 25-66-01.SDR SWAA2025092316679Battery Pack · inoperativeROW 14ABC AND 15BC EMERGENCY LIGHTS INOPERATIVE. R & R EMERGENCY BATTERY PACK IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2025092316594Battery Pack · inoperativeFWD SERVICE DOOR AREA EMERGENCY LIGHT INOPERATIVE. R & R THE POWER SUPPLY BATTERY PACK IAW AMM 33-51-06 AND OPS CHECK GOOD.SDR DALA2025092306960Doubler · damagedFUEL LEAK FOUND DURING INSPECTION OF THE L/H WING AFT LOWER SKIN DOUBLER IN THE BRACE FITTING AREA AT XRS = 164, REF: EM 5720- 01103-01A. COMPLIED WITH ER/A 628888-14AD REV. ORIG. PRI REV. (1209016)SDR AALA202509235566Oven · faultedAIRCRAFT WAS NOT GROUNDED: LEFT GALLEY OVEN BEEPING AND HOT WHEN NOT ON. COULD SMELL FROM THE FLIGHT DECK. (OPEN)SDR DALA2025092306944Indicator · obstructedDOOR 3L KNUCKLE KNOCKER GETS STUCK WHEN ARMING DOOR, WILL NOT POP OUT. FOUND KNUCKLE KNOCKER PLACARD DAMAGED KEEPING IT FROM DEPLOYING. REMOVED PLACARD AND KNOCKER OPS CK NORMAL. (7645584)SDR DALA2025092306941Control Panel · faulty(LOG 7643946) ON TAKEOFF AFTER V2 FIRE WARN LIGHT ILLUMINATED WITH FIRE BELL AND ENG 1 & 2 FIRE HANDLES ILLUMINATED. WENT AWAY AFTER APPROX. 1 SECOND. R/R FIRE CONT PANEL IAW B737 AMM 26-00. A/C OK FOR SVC.SDR DALA2025092306932Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHT AT 30ABC INOP. REMOVED AND REPLACED M2626 EMERGENCY LIGHT BATTERY REF. B737 AMM 33-51. CHECKS GOOD.SDR DXTA2025092305029Uplock Switch · defectiveDURING APPROACH PUT GEAR HANDLE DOWN & IMMEDIATELY GOT A GEAR DISAGREE L AMBER CAS MESSAGE & A YELLOW X ON LT GEAR INDICATOR. TERMINATED APPROACH & RAN THRU EMER/ABNORMAL CHECKLIST FOR CAS MESSAGE. IAW CHECKLIST, PULLED LANDING GEAR BLOWDOWN HANDLE & GEAR STATSDR DXTA2025092305031Battery · inoperativeNOTICED THE CABIN ROOF AND EXIT LIGHTS BLINKING DURING THE FLIGHT. CYCLED THE EMER LT SWITCH AND THE CABIN ROOF LIGHTS, EXIT SIGNS, AND ONE RED AND ONE WHITE FLOOR LIGHT CAME ONE SOLID IN THE ARM POSITION. WE SWAPPED BATTERIES AND FOUND THAT THE ISSUE FOLLOSDR CALA2025092309164Battery Pack · no testEMERGENCY LIGHTING SYSTEM OPS CHECK, FIRST CLASS FLOOR PROXIMITY LIGHTS INOPERATIVE. REPLACED BATTERY PACK IAW AMM 33-51-06. OK FOR SERVICE.SDR CALA2025092309163Bumper · damagedSEAT 21C EMERGY LIGHT HOUSING HANGING DOWN SEAT 19C. REPLACED ARM SHROUD REF CMM 25-22-59 NO OTHER FAULTS FOUND.SDR CALA2025092309162Bracket · damagedFWD CARGO DOOR SENSOR (S52001) BRACKET DAMAGED. INSTALLED BRACKET FOR PROXIMITY SWITCH WITHIN LIMITS IAW AMM 52-34-20-201 PERFORMED INDICATION PROXIMITY SENSOR TEST 52-71-02-730-801 OK FOR SERVICE. INSTALLED STRIKER PLATE TARGET FROM AIRCRAFT 2139 PER IPC 5SDR CALA2025092309161Smoke Detector · malfunctionedAFT LAVATORY SMOKE DETECTOR AND LIGHT CAME ON THEN OFF. NEITHER AFT LAVATORY FIRE EXTINGUISHER IS DISCHARGED. NEITHER AFT LAVATORY OVERTEMP LABEL INDICATES OVERTEMP. NEITHER LAV SMELLS OF SMOKE. BOTH AFT LAV SMOKE DETECTORS OPS CHECK GOOD IAW AMM 26-14-00SDR CALA2025092309160Bustle · no discrepancyL2 DOOR ESCAPE SLIDE PACK BUSTLE LOOSE, SEVERAL SCREWS ARE LOOSE ON THE SLIDE PACK COVER. PERFORMED AN INSPECTION ON ESCAPE SLIDE COVER AND THE SREWS ARE TIGHT IAW AMM 25-66-01-400-801 REV. 25.SDR CALA2025092309159Girt Bar · out of adjustR1 DOOR WILL NOT ARM. ADJUSTED GIRT BAR MECHANISM OF THE SLIDE RAFT. ACCOMPLISHED IAW AMM SUB TASK 25-66-10-712-031. CYCLED ARM LEVER DOOR OPENED/CLOSED PROPERLY IS TIME.CHECK GOOD.SDR YENA2025092300960Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB HOLE OF FR 68 LH DOOR STOP FITTING Ñ1. CRACK DIRECTION 5 AND 11 OCLOCK. CRACK D= 0.160 INCH; (RESOLVED ON W/O: 1404606 TASKCARD: NR-00036) PERFORMED PERMANENT REPAIR ON FR68 LH AT LOWER INBOARD HOLESDR YENA2025092300959Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB HOLE OF FR 68 RH DOOR STOP FITTING Ñ1. CRACK DIRECTION 5 OCLOCK. CRACK D= 0.160 INCH; (RESOLVED ON W/O: 1404606 TASKCARD: NR-00037) PERFORMED PERMANENT REPAIR ON LOC. ON LOWER INB HOLE OF FR 68 RH DSDR YEN2025F00008Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB HOLE OF FR 68 RH DOOR STOP FITTING Ñ1. CRACK DIRECTION 5 OCLOCK. CRACK D= 0.160 INCH; PERFORMED PERMANENT REPAIR ON LOC. ON LOWER INB HOLE OF FR 68 RH DOOR STOP FITTING #1 IAW A320 SRM 53-41-12-300SDR YENA2025092300958Beam · corrodedDURING HEAVY MAINTENANCE: CORROSION ON LONGITUDINAL BEAM LOCATED BTW FR. 40 TO FR.41 AND AT LEVEL STR 20A . R/H SIDE EMERGENCY EXIT DOOR AREA IN PASSENGER CABIN; (RESOLVED ON W/O: 1404606 TASKCARD: NR-00038) REMOVED AND REPLACED LONGITUDINAL BEAM LOC. BTW FR40SDR YENA2025092300957Hinge Arm · corrodedDURING HEAVY MAINTENANCE: AFTER REMOVED BEARING CORROSION WAS FOUND ON HINGE ARM FITTING Ñ5 ON VERTICAL STABILIZER; (RESOLVED ON W/O: 1404606 TASKCARD: NR-00040) REMOVED AND REPLACED HINGE FITTING #5 LOC. VERTICAL STABILIZER I.A.W A320 SRM 55-36-42-300-008 ALLSDR YENA2025092300956Bearing · corrodedDURING HEAVY MAINTENANCE: AFTER REMOVE BEARING CORROSION WAS FOUND ON HINGE ARM FITTING Ñ4 ON VERTICAL STABILIZER; (RESOLVED ON W/O: 1404606 TASKCARD: NR-00041) REMOVED AND REPLACED HINGE FITTING #4 LOC. VERTICAL STABILIZER I.A.W A320 SRM 55-36-42-300-008. ALLSDR DALA2025092306931Selector Valve · faultyATB DUE TO L/G LGCIU 1 FAULT ECAM WARNING. FOUND SELECTOR VALVE (40GA) FAULTING. REPLACED SELECTOR VALVE (40GA) AND LGCIU-1. OPS CHECK GOOD. (LP: 1209243)SDR AALA202509227296Sign · faultedAIRCRAFT WAS NOT GROUNDED: 2R EMERGENCY EXIT SIGN PARTIALLY LIT. MAINTENANCE REPLACED DOOR 2R EMERGENCY EXIT PANEL LIGHT ASSY. REF AMM 33-51-00.SDR AALA202509229062Battery · no testAIRCRAFT WAS NOT GROUNDED: R2 DOOR REAR FACING F/A SEAT EMERGENCY FLASHLIGHT WON'T PRESS-TO-TEST. MAINTENANCE REPLACED BATTERY AT R2 DOOR REAR FACING F/A SEAT EMERGENCY FLASHLIGHT IAW AMM 25-64-00.SDR WX0A2025092232575Tab · missing(AIRCRAFT NOT GROUNDED) BOTH EMERGENCY EGRESS TABS MISSING OFF BLOW OUT PANEL IN COCKPIT. REPLACED COCKPIT DOOR EGRESS PINS IAW AMM 52-51-11-960-002-A.SDR WX0A2025092232572Light · inoperative(AIRCRAFT NOT GROUNDED) L2 AND R2 LOWER WALL MOUNTED EXIT MARKING SIGN INOP, REF TSM 33-51-00-810-814-A, PERFORMED AN OPERATIONAL TEST OF CABIN EMERGENCY LIGHTS AND SIGNS IAW MM 33-51-00-710-009-A. BOTH LOWER DOORS L2 AND R2 WALL MOUNTED EXIT SIGNS DID NOT COSDR HALA20250922286Isolation Valve · faultedETOPS - COND CAB REST ISOL FAULT DISPLAYED ON ECAM. REMOVED AND REPLACED LDMCR ISOL VALVE W/REF TO A330 AMM 21-21-56-400-801-A. OPS CHECK GOOD. LEAK CHECK GOOD. OK FOR SVC.