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 R61A2025111500505Splice · corrodedDURING HEAVY CHECK CF III L/H SPLICE PLATE BETWEEN FR87-FR88 LBL41 FOUND CORRODED. REMOVED AND REPLACED SPLICE PLATE IAW EMB 170/175 SRM 51-41-02SDR R61A2025111500504Shear Tie · corrodedDURING HEAVY CHECK CF III FR81 STR 25R - 26R FOUND CORRODED SHEAR CLIP. REMOVED AND REPLACED SHEAR CLIP IAW EMB 170/175 SRM 51-41-01 AND 51-41-02SDR AALA202511144072Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FORWARD CABIN SEAT TRACK AT FR 20 AND -Y1292. REPLACED SEAT TRACK PER SRM 51-72-11.SDR SWAA2025111328441Nut Plate · debondedAFT CARGO LEFT FLOOR TRANSITION ANGLE FROM BS 727I TO 787, DISBONDED NUTPLATES (QTY.10).<[01] INSTALLED BONDED NUTPLATES (QTY.10) ON AFT CARGO L/H FLOOR TRANSITION ANGLE FROM STA 727I TO STA 787 PER SRM 51-41-10.SDR SWAA2025111328439Angle · debondedAFT CARGO RT FLOOR TRANSITION ANGLE FROM STA 727J TO STA 767 DISBONDED NUTPLATES (QTY.6). INSTALLED BONDED NUTPLATES (QTY.6) ON AFT CARGO R/H FLOOR TRANSITION ANGLE FROM STA 727J TO STA 767 PER SRM 51-41-10.SDR SWAA2025111328440Support Angle · cracked#1 ENGINE I/B FAN COWL OIL ACCESS DOOR 414AR INNER SUPPORT ANGLE CRACKED. REMOVED AND REPLACED INNER SUPPORT ANGLE PER SRM 51-40-02.SDR AALA202511134887Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR BEAM-SEAT TRACK FR16 AND +Y1292. REPLACED BEAM-SEAT TRACK PER SRM 51-72-11.SDR CALA2025111311182Threshold Web · corrodedAFT CARGO COMPARTMENT, MAIN SILL WEB AFT CARGO DOOR HAS CORROSION NEEDS TO BE REPLACED. REMOVED AND INSTALLED NEW AFT CARGO COMPARTMENT MAIN SILL WEB AFT CARGO DOOR IAW DWG 146A8120-11A REV A. SRM 51-40-02-0G-0. SRM 51-40-05-0G-0. SRM 51-40-08-0G-0. AMM 5SDR SWAA2025111028118Scuff Plate · crackedCRACK CENTER SCUFF PLATE LOCATE AFT CARGO DOOR CUT OUT. REPAIRED CENTER SCUFF PLATE OF AFT CARGO DOOR IAW SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4.C.SDR IPXA2025110450848Fuel · out of balanceFUEL CONFIG MESSAGE IN CRUISE. RIGHT TANK 2000LBS LESS THAN LEFT. RAN QRH REBALANCING L&R. AFTER REBALANCING, ON DECENT 12.8 AS RH TANK WAS 1000 LESS THAN LEFT TANK. PERFORMED OPS CHECK OF LH AND RH DEFUEL VALVES IAW AMM 28-26-01-404-145. OPS CHECK GOOD.SDR AALA202511039050Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME 16 , HOLE 4, AT LEVEL OF DOOR STOP 7, RH SIDE AT FWD GALLEY AREA. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR LOC. ON FRAME16 RH SIDE IAW EA 367452.SDR IPXA2025102750848Fuel Sys · out of balanceFUEL CONFIG MESSAGE IN CRUISE. RIGHT TANK 2000LBS LESS THAN LEFT. RAN QRH REBALANCING L&R. AFTER REBALANCING, ON DECENT 12.8 AS RH TANK WAS 1000 LESS THAN LEFT TANK.SDR AALA202510313978Slide Raft · bulgedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE / RAFT FAILS OPERATIONAL CHECK DUE TO STIFF BULGING AFT END OF GIRT CONTACTING BULB SEAL OF DOOR. REPLACED SLIDE / RAFT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26L00025011.SDR IPXA2025103155348Window · cracked1R WINDOW CRACKED IN CRUISE FLT AT FL390. C/W STEPS OF R1 WIINDOW INSTALL IAW AMM 56-11-01. OPS AND LEAK CHECK GOOD.SDR AALA202510306330Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510304371Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510307028Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202510308918Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025103045555Handle · corrodedCREW ENTRY DOOR, EXTERIOR DOOR HANDLE, LIFT HANDLE OUT, STUD CORRODED AND WORN. OPENSDR AALA202510308671Windshield · arcedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER ENTERING IMC AT FL280 ARCING BEGAN EMANATING FROM FO R1 WINDSHIELD, CONTINUED AND WORSENED WITH CONTINUED FLIGHT IN IMC. FLIGHT CREW COULD PHYSICALLY FEEL BUILD UP OF STATIC ELECTRICITY. AIRCRAFT DSDR HEEA202510300001Chip Detector · dirtyDURING FLIGHT THE DISPATCH MESSAGE XMSN: MGB CHIP FRT AGB SENSOR DISPLAYED, CREW INITIATED RTB.SDR SWAA2025102928510Flashlight · no testEMERGENCY FLASHLIGHT IN FORWARD GALLEY, TEST FAILED. REMOVED AND REPLACED FWD GALLEY EMERGENCY FLASHLIGHT BATTERY IN REFERENCE TO AMM 25-64-00 OPERATIONAL TEST GOODSDR SWAA2025102928693Battery · inoperativeLEFT AFT GALLEY FLASHLIGHT INDICATOR LIGHT DOES NOT ILLUMINATE. R & R AFT GALLEY LEFT FLASH LIGHT BATTERY PER AMM 25-64-00; OPS CHECK GOOD.SDR SWAA2025102928704Flashlight · no discrepancyTWO AFT GALLEY FLASHLIGHTS INOP ON FIRST OFFICERS SIDE. PERFORMED OPS CHECK PER AMM 25-64-00-900-805 BOTH FLASHLIGHTS OPERATE CORRECTLY, OPS CHECK GOOD.SDR SWAA2025102929767Flashlight · no discrepancyTWO AFT GALLEY FLASHLIGHTS INOPERATIVE ON FIRST OFFICERS SIDE. PERFORMED OPS CHECK IAW AMM 25-64-00-900-805 BOTH FLASHLIGHTS OPERATE CORRECTLY OPS CHECK GOOD.SDR SWAA2025102928703Slide · low pressureCREW REPORTS L1 DOOR SLIDE PRESSURE GAUGE IN THE RED. REMOVED AND REPLACED L1 DOOR SLIDE PER AMM 25-66-00.SDR SWAA2025102928170Door · crackedLEFT MLG OUTTER DOOR CRACKED. REMOVED AND REPLACED THE LT MLG WING DOOR IAW AMM 32-13-21. OPS AND FITTMENT CHECKED GOOD.SDR SWAA2025102928336Socket · dirtyFWD SERVICE DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. CLEANED LAMP SOCKET CONTACTS AND VERIFIED NORMAL OPERATION OF FWD SERVICE DOOR EXTERIOR EMERGENCY LIGHT LAMP IAW AMM 33-51-00.SDR SWAA2025102928348Lamp · inoperativeLH EMERGENCY LIGHT (AFT OF WING) INOPERATIVE. REPLACED THE LAMP IN THE LT EMERGENCY LIGHT, AFT OF WING, IAW AMM 33-51-04. OPS CHECKED GOOD.SDR SWAA2025102928705Lens · detachedEMERGENCY EXIT AISLE LIGHT COVER CAME OFF. REINSTALLED THE LENS COVER PER SIP.SDR DALA2025102907936Proximity Switch · out of adjustSHIP 693 R2 DOOR SLIDE ARMED LIGHT REMAINS ILLUMINATED. CORRECTIVE ACTION: REF B757 AMM 25-66. PERFORMED GIRT BAR PROX SWITCH GAP ADJUSTMENT. OPS NOW NML. (7715288)SDR ASAA2025102561891Sign · detachedMID CABIN EXIT SIGN CEILING 13 HANGING BY WIRE. GROUNDED - YES. REATTACHED LIGHT ASSEMBLY PER AMM 33-51-01 OPS CHECK GOOD.SDR ASAA2025102561828Light Sys · malfunctionedROW 27ABC EMERGENCY LIGHT ON FOR HALF THE FLIGHT. GROUNDED - YES. CYCLING P5: PILOT EMERGENCY LIGHT SWITCH, PERFORMED GOOD OPERATIONAL TEST OF EMERGENCY LIGHT. 27ABC EMERGENCY LIGHT IS NORMAL. REF AMM 33-51-00/501.SDR UIEA2025102501279Bottle · no test#2 FIRE CARGO BOTTLE WON'T TEST(<P>PERFORMED ALL WIRING CHECKS FROM THE SQUIB TEST PANEL TO EACH SQUIB FOR BOTTLES 1, 2, & 2A PER WDM 26-23-12, FOUND PIN 14 ON D866 AND PIN 14 ON D864 HAD NO GROUND FOR TEST CIRCUIT. FOUND APU/CGO FIRE CONTROL PANEL REPLACED. LSDR AALA202510282276Elec Connector · looseAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS SEAT ROWS 11ABC, 12ABC AND 13ABC ARE INOPERATIVE. MAINTENANCE FOUND SEAT CONNECTOR AT WALL LOOSE, PLUG 7261VC3 SHEET 2 SWM 33-51-04, TIGHTENED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER SDR AALA202510282392Bottle · 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 AALA202510286199Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510283038Plate · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTREPORTS DISARMING LEVER AT DOOR 2R IS LOOSE. MAINTENANCE TIGHTENED GRIP PLATE HANDLE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-22-22.SDR AALA202510288759Bottle · low pressureAIRCRAFT WAS GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510286654Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT RIGHT-HAND FLASHLIGHT BATTERY DEAD. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202510287310Bottle · 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 AALA202510287345Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510286988Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510283685Proximity Sensor · faultyAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT THE 3R DOOR WILL NOT ARM. MAINTENANCE FOUND THE DOOR WAS OPENING AND CLOSING WITH NO ISSUES BUT NOTED THAT THE 3R DOOR SLIDE WOULD NOT INDICATE ARMED ON THE ECAM. MAINTENANCE FOUND THE 3R DOOR HANDLE PROXIMITY SDR AALA202510287256Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510285113Bottle · low pressureAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510280760Bottle · low pressureAIRCRAFT WAS GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510280255Screw · looseAIRCRAFT WAS NOT GROUNDED: SCREW LOOSE ON 3L DISARM HANDLE. MAINTENANCE RE-SECURED LOOSE SCREW ON 3L DOOR DISARM HANDLE PER AMM 52-22-00.SDR AALA202510281812Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT CONTROL PANEL INDICATES CHECK 4L DOOR PRESSURE. MAINTENANCE SERVICED THE 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR CALA2025102810669Controller · faultedCABIN ALT WARNING AT 290. CREW STATED AT 29000FT CABIN ALTITUDE WARNING DISPLAYED, CABIN CLIMB RATE SHOWING 1000FT PER MINUTE WHILE LEVELED OFF AT 290, DURING DESCENT AT 6000FT CABIN PRESSURE INDICATION SHOWING 30000FT. R & R NR 1 & 2 CABIN PRESSURE CONTROLLER