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 NACA2025070400002Valve · faultedFOUND RT LOW LIMIT VALVE TORQUE MOTOR TEST FAILED. (CAN NOT TO MOVE TO OPEN.) REMOVED AND REPLACED RT LOW LIMIT VALVE AND CARRIED OUT LEAK TEST IAW AMM 21-51-11 REV 145, NO LEAK.SDR NACA2025070400001Plenum · perforatedRIGHT AIR CONDITIONING COMPARTMENT, PLENUM FOUND PERFORATION. REMOVED AND REPLACED RT AIR CONDITIONING PLENUM COMPARTMENT IAW AMM 21-51-02, REV 145.SDR IPXA2025071160849Elevator · not reportedEO-85445-JIC2 STEP 137 REVIEWED TASK PER GMM-MTX 09.05.01.09.SDR IPXA2025072970736Seat Track · corrodedMAJOR REPAIR, FLOOR C73 TO C74 AND Y 852 SEAT TRACK WITH EVIDENCE OF CORROSION INSTALLED NEW SEAT TRACK SECCTION ON MDC FLOOR STRUCTURE C71 TO C74 AND Y 852 IAW SRM 53-10-16. RESTORED PROTECTIVE SURFACE ON SEAT TRACK REPAIRED IAW SRM 51 75 10.51 10 16.SDR SWAA2025072988395Seat Track · corrodedCORROSION FOUND ON PASSENGER SEAT TRACK AT LBL 45, WL 208, BS 360+9 ON WELL, BS 360+14 ON CROWN BS 360+16 ON WELL, BS 380 ON CROWN & WELL, BS 400+1 ON CROWN & WELL, BS 420+11 ON CROWN. REMOVED CORROSION ON SEAT TRACK IAW SRM 53-00-52-1A-1. FOUND TO BE OUT OFSDR REXA2025072900771Angle · corrodedCORROSION ON ANGLE OF ATTACH POINT BONDING JUMPER AT FWD SERVICE ACCESS DOOR CORROSION ON ANGLE OF ATTACH POINT BONDING JUMPER AT FWD SERVICE ACCESS DOOR WAS REMOVED AND EVALUATED OUT OF LIMITS PER CRJ-900 SRM 51-21-06-001-001-A01 AND CRJ-900 SRM 53-00-00-101SDR IPXA2025072870669Web · crackedMDC FLOOR BETWEEN C73 TO 74 Y2127.5 WEB WITH EVIDENCE OF CRACK IN THE LOWER SURFACE INSTALLED NEW WEB BTW FR73 AND FR74 AT 2127.5 IAW A300-600 SRM 51-40-21.SDR AALA202507258775Attach Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY THRUST REVERSE AFT ATTACH FITTING BEARING INBOARDON RH PYLON. MAINTENANCE REPLACED THRUST REVERSER AFT ATTACH FITTING INBOARD ON RH PYLON IAW AMM 54-57-17-000-003-A AND AMM 54-57-17-400-003-A AND A319 SRM 51-49-00-SDR SWAA2025072388409Bracket · crackedNR 2 ENGINE 4 O'CLOCK COOLING BRACKET FOUND TO BE CRACKED. REMOVED AND REPLACED THE NR 2 ENGINE 4 O'CLOCK COOLING BRACKET PER SRM 51-40-02-0G-0.SDR IPXA2025070770161Panel · crackedNUMBER 6 SLAT O/B END LWR LEADING EDGE LWR SURFACE CLOSING PLIE HAS A CRACK AS MARKED. INSTALLED CLOSING PLIE IAW SRM 51-40-02.SDR IPXA2025071160892None · noneEO-85445-JIC1 STEP 137 REVIEW COMPLETEDSDR IPXA2025072362233Fan · damagedFOUND SUPPLY FAN JOINT SLEEVE WORN OUT. I.A.W AMM 21-58-06-004-283 REV.145 AND AMM 21-58-06-404-284 REV.145 REPLACED THE SLEEVE.SDR IPXA2025072363772Valve · damagedCRACK - FLANGE, NO. 2 PYLON FAN AIR VALVE INLET. I.A.W. AMM 36-11-16-004-001-006, AND 36-11-16-404-015-006, REV.145, REPLACED THE FAN AIR VALVE OF NO.2 ENGINE. I.A.W AMM 36-11-16-404-015-006 REV.145, DID THE OPERATIONAL TEST, RESULT: NO LEAK WAS FOUND AND TESTSDR AALA202507230870Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500C, AT S27L. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202507230701Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 495 PLUS 15 INCHES, AT S27L. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA202507210254Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT DOOR OPENING THRESHOLD WEB FROM BS 440 TO BS 480 AT RBL 36. REPLACED WEB PER AARD 51-00-05-1.SDR JJBA20250721063Floor Support · crackedCF3, RH ANGLE OMEGA BEAM OB AND IB BTW FR 48-50 CRACKED. CF3, RH AT FR51 ANGLE BTW ANGLE OMEGA BEAM OB AND IB 8 RIVETS REMOVED FOR ACCESS. CF3, RH ANGLE OMEGA BEAM OB AND IB BTW FR 48-50 REMOVED AND REPLACED.SDR FDEA202507041121Gust Lock · failedLEFT MAIN DOOR GUSTLOCK WILL NOT ALWAYS DISENGAGE WHEN CLOSING DOOR AND WILL NOT ALLOW DOOR TO CLOSE FULLY. REMOVED UPPER HINGE ARM LINK BOLT. FOUND SPHERICAL BEARING WORN. ALSO REMOVED HINGE ARM FAIRING TO ACCESS SPHERICAL BEARING. R & R UPPER HINGE ARM SDR DALA2025071605356Stringer · damagedSHIP 3417, DAMAGE TO STR 4RT JUST FORWARD OF FR61. REPAIRED PER ER/A 627173-14.SDR DALA2025071605355Stringer · damagedSHIP 3417, DAMAGE TO STR 3LT AT FR 60-61. REPAIRED PER ER/A 627250-14.SDR DALA2025071605352Stringer · damagedSHIP 3417 DAMAGE TO STR-2LH AT FR 61-64. REPAIRED PER ER/A 627159-1.SDR DALA2025071605351Stringer · damagedSHIP 3417 DAMAGE TO STR-3RH JUST FORWARD OF FR61 AND 62. REPAIRED PER ER/A 627221-14.SDR AALA202507167449Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500E TO BS 500F AT RBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND AARD 51-00-05-1.SDR AALA202507163994Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER AFT CORNER SHAPE FITTING AT FR 68 AND S23L. REPLACED AFT CORNER SHAPE FITTING PER SRM 51-72-11.SDR JJBA20250716055Shear Tie · crackedSHEAR CLIP AT FR58 AND BTW STR 15L-16L FOUND CRACKED. SHEAR CLIP AT FR58 AND BTW STR 15L-16L REMOVED AND INSTALLEDSDR CALA2025071606633Proximity Switch · faultedDOOR FWD CARGO ECAM 2 TIMES ON GND DURING BRAKING. PRESS NORMAL IN FLT. PLACED FWD CARGO INDICATION ON MEL 5270U. DOOR WAS VISUALLY CHECKED & CONFIRMED CLOSED & LATCHED FOR DEPARTURE. PROXIMITY SWITCH WAS REPLACED. INSPECT WIRES TO PROXIMITY SWITCH FOR COSDR IPXA2025071169520Floor Panel · corrodedFWD CARGO COMPT FLOOR PANEL 121DF HAS SURFACE CORROSION. INSTALLATION OF ROLLER TRAY, PN- 81658-1. INSTALLED FWD CARGO PIT MBA SYSTEM IAW 757-200 SRM 51-40-02-0G-0 AND AMM 25-57-01-404-003-001.SDR AALA202507140727Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500E, S24R, RBL 32. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202507125692Proximity Sensor · faultedAIRCRAFT WAS NOT GROUNDED: DOOR 3L SLIDE NOT SHOWING ARMED. MAINTENANCE REPLACED THE L3 DOOR PROXIMITY SWITCH 6WN1 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-73-11.SDR DALA202507100528Check Valve · leakingSHIP 3255, DECLARED EMERGENCY DUE TO LOSS OF THE BLUE SYSTEM QUANTITY AT CRUISE. REPLACED LEAKING CHECK VALVE AT BLUE SYSTEM MANIFOLD. CHECK VALVE WAS LEAKING FROM THE O-RING AT THE BASE. (LP: 7451561)SDR IPXA2025071171812Unknown · odorWITH LEFT PACK ON AND ONLY APU PNEUMATICS, STRONG SMELL OF JET FUEL IN FLIGHT DECK. PERFORMED 20 MINS OF APU OPERATION BOTH AC NO FUMES EVIDENT I.A.W AMM 21-00-21-102-030 REB 145.00. TXFRD TO MAINTENIX TASK ID T3F18E006ZXJX FOR DEFECT RECTIFICATION.SDR JJBA20250711006Shear Tie · crackedCF2 RH SHEAR CLIP FR25 BTW STR 15R-16R CRACKED. CF2 RH SHEAR CLIP FR25 BTW STR 15R-16R REMOVED AND INSTALLED.SDR JJBA20250711005Shear Tie · crackedCF2 RH SHEAR CLIP FR25 BTW STR 16R-17R CRACKED. CF2 RH SHEAR CLIP FR 25 BTW STR 16R-17R REMOVED AND REPLACED.SDR JJBA20250711004Shear Tie · crackedFR72 BTW STR 17L-18L SHEAR CLIP FOUND CRACKED. FR72 BTW STR 17L-18L SHEAR CLIP REPLACEDSDR AALA202507115451Wire Harness · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY PATHWAY LIGHTING INOPERATIVE AT SEAT ROW 23. MAINTENANCE RE-ROUTED AND CONNECTED WIRING HARNESS OF THE EMERGENCY ESCAPE-PATH MARKING-SYSTEM FROM ROW'S 21 TO 23 PER AMM 33-51-04. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMSDR DALA2025071005193Light · detachedSHIP 3265 DISC: DURING PREFLIGHT, FA'S FOUND EMERGENCY EXIT LIGHT BOX AND WIRE HANGING BELOW SEAT IN ROW 25. C/A: REATTACHED LIGHT. OK FOR SVC. (LP: 7436202)SDR DALA2025070905188Servo · faultedSHIP 3568 -ATB- DUE TO RIGHT ELEVATOR SERVO FAULT. CORRECTIVE ACTION: REPLACED RIGHT OUTBOARD YELLOW ELEVATOR SERVO (1CT2). (LP# 7307576)SDR DALA2025070805158Proximity Switch · inoperativeSHIP 3140 FWD CARGO DOOR SENSOR INDICATION INOP. CORRECTIVE ACTION: R/R FWD CARGO DOOR INDICATION PROXIMITY SWITCH 30WV PER A319 AMM 52-71. (6471942).SDR AALA202507086655Elec Connector · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB THE AIRCRAFT PITCHED UP AND DOWN WITH THE LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHL. FOUND PIN 34 OF CONNECTOR DM22 TO HAVE LOW SDR DALA2025070805094Skin · dented(LOG 7433100) WHILE RON IN SMF, MAINTENANCE REPORTED A DENT ON THE UPPER INSPAR SKIN (P/N: 182A3002-1) COMMON TO THE LH HORIZONTAL STABILIZER. DAMAGE REPAIRED PER ERA 627160-14 AND 737 SRM 55-10-01 REPAIR 3.SDR DALA2025070805085Plate · corroded(LOG 1063956) CORROSION_ON RH SIDE PLATE_AT AFT CARGO COMPARTMENT (C2) FROM STA 727-787. RH SIDE PLATE AT AFT CARGO COMPARTMENT (C2) FROM STA 727-787 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070805084Plate · corroded(LOG 1063947) CORROSION_ON LH SIDE PLATE_AT AFT CARGO COMPARTMENT (C2) FROM STA 727-847. CORROSION LEVEL 2: LH SIDE PLATE_AT AFT CARGO COMPARTMENT (C2) FROM STA 727-847 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070805083Skin · damaged(LOG 1062480) FWD CARGO DOOR CUTOUT SKIN DAMAGE AFT SIDE STA 492.4 BETWEEN S22R AND S23R. INSTALLED REPAIR PER B737 AMM SRM 53-00-01-2R PROC 24 AND ERA 627564-14 REV 0.SDR DALA2025070805082Ballscrew · not reported(LOG 1062443) ACCOMPLISH AMDS 2740-01077-0101, HORIZONTAL STABILIZER TRIM BALLSCREW, B737, SECTION 0101 REFERENCE STEP 11. COMPLIED WITH AMDS CARD 2740-01077-0101. REPLACE HORIZONTAL STABILIZER TRIM ACTUATOR. CARD 2740-01077-0301.SDR AALA202507085692Indication Sys · no indicationAIRCRAFT WAS NOT GROUNDED: DOOR 3L SLIDE NOT SHOWING ARMED.SDR AALA202507086682Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS STICKING. REMOVE AND REPLACED LAVATORY-D BI-FOLD DOOR ASSEMBLY. PER CMM 25-40-64. OPERATIONAL CHECK GOODSDR CALA2025070806324Slide Raft · no testDOOR 1R MED SLIDE NEEDS MUST BE REPLACED. THE SLIDE EXTERIOR LIGHT FAILS THE EPAS TEST CAUSING A CIDS EXTERIOR LIGHT FAULT. SEE LOGPAGE 5439758. SILDE IS ON AOG AND DUE IN AT 10:08PM LOCAL TIME. REMOVED SLIDE FROM DOOR 1R REF AMM: 25-62-44-000-804-A. REQUEST CSDR CALA2025070806323Handle · bindingAFT EMERGENCY DOOR HANDLES ON INTERIOR FA REPORTS HANDLES HAVE R ESTRICTED MOVEMENT. CHECKED BOTH AFT PASS DOORS ARMING AND DID ARMING WIRH NO ISSUES, CHKD OPEN AND CLOSE AND NO ISSUES, THRESHOLD IS CLEAR, REF AMM 52-13-11.SDR CALA2025070806322Slide · no testWHEN ACCOMPLISHIG CIDS EMERGENCY LIGHT TEST REF AMM 33-51-00-710-001-A. FOUND DEFECT ON DOOR 2L. DOOR SLIDE AT LOCATION 1R WAS JUST REPLACED, FAULT SUGGESTS TSM 25-62-00-810-811A, INSTALLED ESCAPE SLIDE INDICATOR SHUNT P.N.31-2125-0-8002 AT DOOR 1R, EPSUSDR CALA2025070806321Slide · out of adjustDOOR 1R SLIDE HAS EXCESS MATERIAL SHOWING. ADJUSTED DOOR 1R SLIDE PACK Z FOLD TO BACKING PAN SHELF, OK FOR CONTINUED SERVICE, REF AMM 25-66-01