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 SWIA202512260915Window Frame · crackedPILOT WINDSHIELD SIDEPOST CRACKED, R & R CRACKED PILOT WINDSHIELD SIDEPOST WITH NEW SIDEPOST USING ALL NEW SEALS AND FASTENERS PER SRM 51-42-21-001-001-A01 AND DWG 601R33007, REV U. ALL CHECKS GOOD.SDR SWI2025F01836Intercostal · corrodedPAX DOOR DD7A FWD INTERCOSTAL FOUND TO BE CORRODED. REQUIRES REPLACEMENT. REPLACED PAX DOOR DD7A FWD INTERCOSTAL IAW SRM 51-42-06. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR SWI2025F01835Intercostal · corrodedPAX DOOR INTERCOSTAL DD3 MID CORRODED. REQUIRES REPLACEMENT. REMOVED AND REPLACED THE PAX DOOR MID INTERCOSTAL DD3 IAW SRM 51-42-06 AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA2025121900915Intercostal · corrodedPAX DOOR INTERCOSTAL DD2 MID FOUND TO BE CORRODED. REQUIRES REPLACEMENT. REMOVED AND REPLACED THE PAX DOOR MID INTERCOSTAL DD2 IAW SRM 51-42-06 AND 51-42-21, COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337. CONTINUATION CARD FOR WORK PERFSDR SWIA202512020915Doubler · scratchedWIFI FWD ATG ANTENNA CUTOUT HAS MULTIPLE SCRATCHES ON OUTER SKIN. INSTALLED NEW WIFI FWD ATG ANTENNA OUTER DOUBLER IAW DWG P13110-20110 REV M.SDR SWAA2025110415045Skin · no discrepancySUSPECT CRACK RT WING NR 5 SLAT LEADING EDGE AT ACTUATOR ATTACH FITTING, SLAT STATION 85.19. HFEC INSPECTED RT WING #5 SLAT LEADING EDGE AT ACTUATOR ATTACH FITTING SLAT STATION 85.19 IAW 737 NDTM PART 6; 51-00-00 PROCEDURE 23. NO CRACKS NOTED.SDR SWAA2025110415026Inlet · pulledPULLED THROUGH FASTENERS 2 O' CLOCK POSITION ON RIGHT INLET COWL OUTER LIP SKIN. REMOVED AND REPLACED RT INLET COWL OUTER LIP SKIN IAW SRM 54-10-01-1A-2 AND SRM 51-40-02. ACCOMPLISHED NDI INSPECTION IAW NDTM PART 6; 51-00-00. REMOVED AND REPLACED NR 2 ENGISDR CALA2025103010761Door Frame · corrodedCABIN R-2 DOOR CORROSION AT FR 68 BETWEEN STR 22 AND STR 23. EVALUATED CORROSION AT R2 DOOR FR68 RT BETWEEN STR 22 AND 23 IAW SRM 53-41-12-283-001, CORROSION FOUND TO BE OUT OF LIMITS, MAXI MUM REWORK ALLOWED .02 IN, FOUND DAMAGE TO BE .025 IN. IAW SRM 5 3-41SDR JJBA20251024070Bracket · corrodedLEFT WING OTBD FLAP OTBD FAIRING INTERIOR BRACKET HAS CORROSION. LH WING OB FLAP OB FAIRING REPLACED 1EA BRACKET.SDR IPXA2025102411698Panel · pulledAFT CARGO PANEL 143DF HAS TWO INSERTS PULLED THROUGH. 33-051. REMOVED 2EA DAMAGED INSERTS AND REPLACED WITH 2EA NEW INSERTS P/N SL618-3CM BATCH # 0004404298 IAW EO # A300-5320-16407.SDR SWAA2025102314819Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY IAW B737-700 SRM 51-40-02 AND DWG 212A1101; SHEET 3 REV-.SDR SWAA2025102314816Tie Clip · crackedCRACK TIE CLIP BS 277 AND STRINGER 10R PASSENGER CABIN. REPLACED TIE CLIP AND FASTENERS LOC.BS 277 AND STRINGER 10R PASSENGER CABIN IAW SRM 51-40-02; SRM B737-700 51-10-02 PARAGRAPH 9; DWG 141A1110 SHEET:18 REV:- AND DWG 141A8380 SHEET:14 REV-.SDR SWAA2025102314813Support Angle · crackedCRACK SUPPORT ANGLE BETWEEN BS 291.5 TO BS 294.5 AT LEVEL STRINGER 17R PASSENGER CABIN. REPLACED SUPPORT ANGLE LOC. BETWEEN BS 291.5 TO BS 294.5 AT LEVEL STRINGER 17R PASSENGER CABIN IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, DWG 141A8310 SHEET 25; REV.SDR SWAA2025102314821Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY . REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02-0G-0.SDR SWAA2025102214625Vapor Barrier · crackedCRACK ON VAPOR BARRIER BS 663.75 LH SIDE MAIN WHEEL WELL COMPARTMENT. REPAIRED VAPOR BARRIER BS 663.75 LH SIDE MAIN WHEEL WELL COMPARTMENT IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025102214626Light · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHT LT SIDE 7 EA AND RT SIDE 7 EA. REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING IAW AMM 33-51-15-400-802.SDR ASAA2025091561730Web · corrodedAFT CARGO DOOR THRESHOLD HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION ON AFT CARGO DOOR THRESHOLD LOWER SILL WEB FOUND TO BE OUT OF LIMITS IAW B737NG SRM 53-60-15-1A-1 FIG 103. REMOVED AND REPLACED THRESHOLD IAW B737NG SRM 51-40-02 + BAC SDR SWAA2025102114901Shear Plate · corrodedCORROSION FLOOR STRUCTURE SHEAR PLATE BTW BS 767 TO BS 787 RBL 21 AND WL 152 AT AFT CARGO COMPARTMENT (4 E/A). REPLACED SHEAR PLATE AND FASTENERS AT LEVEL OF STR 25R AND WL 156.4 BTW BS 767 TO BS 794.5 AFT CARGO COMPARTMENT IAW SRM 51-40-02 SRM 51-10-02 ITEM SDR SWAA2025102114900Rib · crackedCRACK ON LEADING EDGE RIB LOCATED LE STA 95.96 ACCESS PANEL 331B AT LT HORIZONTAL STABILIZER. REPLACED LEADING EDGE RIB LOCATED LE 95.96 ACCESS PANEL 331B AT LT HORIZONTAL STABILIZER IAW B737-800 SRM 51-10-02-0G-0 ITEM 9, SRM 51-40-02 AND DWG 186A1303 SHEET:1SDR SWAA2025102114906Rib · crackedCRACK ON LEADING EDGE RIB LOCATED LE STA 105.26 ACCESS PANEL 331B L AT LT HORIZONTAL STABILIZER. REPLACED LEADING EDGE RIB LOCATED LE STA 105.26 ACCESS PANEL 331B L AT LT HORIZONTAL STABILIZER IAW SRM 51-10-02-0G-0 ITEM 9, SRM 51-40-02 AND DWG 186A1304 SHEETSDR SWAA2025102114905Angle · crackedCRACK ANGLE LOC AT LEVEL OF BS 1016 VERTICAL STABILIZER. REPLACED ANGLE AND FASTENERS LOCATED AT LEVEL OF BS 1016 VERTICAL STABILIZER IAW B737-800 SRM-51-40-02-0G-0; DWG 176A3001 SHEET: 23 REV: D.SDR SWAA2025102114902Support Angle · crackedCRACK ANGLE - SUPPORT ON BS 867 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT. REPLACED ANGLE ON BS 867 AT LEVEL STR 26L AT AFT CARGO COMPARTMENT IAW SRM 51-10-02-0G ITEM 9; SRM 51-40-02-0G AND DWG: 149A8102 SHEET: 19 REV: A.SDR HNAA2025102100718Drag Angle · crackedF070245 VERTICAL STABILIZER RH DRAG ANGLE HAS POSSIBLE CRACK AT FR 76. REPAIRED VERTICAL STABILIZER RH DRAG ANGLE AT FR 76. IAW EMB 145 SRM 53-31-01RE DET B FIG 219 SH1 AND SRM 51-40-02.SDR HNAA2025102100717Drag Angle · crackedF070244 VERTICAL STABILIZER LH DRAG ANGLE HAS POSSIBLE CRACK AT FR 76. RAR VERTICAL STABILIZER LH DRAG ANGLE AT FR 76. IAW EMB 145 SRM 53-31-01RE DET B FIG 219 SH1 AND SRM 51-40-02.SDR SWAA2025102014903Crease Beam · corrodedCORROSION ON CREASE BEAM LOCATED BTW BS 847 TO BS 867 RBL 63 WL208.1 AT PASSENGER CABIN. PERFORMED REPAIR ON CREASE BEAM - INNER CHORD - BTW BSTA 847 & BSTA 887 AT WL 208.182 IAW EA 25-153-02686-WIP1; EA 25-153-02686.SDR SWAA2025101614671Fitting · deterioratedDETERIORATED BOTH GIRT BAR FITTING HARDWARE AT FWD GALLEY AREA. REPLACED BOTH GIRT BAR FITTING HARDWARE AT FWD GALLEY AREA IAW AMM 25-66-02-400-801 STEP 3. A. THRU STEP 3. D. ITEM (1).SDR SWAA2025101614673Fitting · deterioratedDETERIORATED BOTH GIRT BAR FITTING HARDWARE AT AFT GALLEY AREA. REPLACED BOTH GIRT BAR FITTING HARDWARE AT AFT GALLEY AREA IAW AMM 25-66-02-400-801.SDR ASAA2025091561447Web · corrodedAFT CARGO DOOR LOWER MAIN SILL UPPER WEB HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED WEB IAW DWG 146A8340 REV:- ORIGINAL THICKNESS OF WEB IS .050. ORIGINAL THICKNESS .050 REMAINING THICKNESS .035, MAT. LOSS .015 AND IS FOUND TO BE OUT OF LIMITS.SDR SWIA2025F01429Doubler · corrodedWASTE SERVICING ACCESS DOOR CUTOUT INTERNAL DOUBLER HAS CORROSION DAMAGE ON THE LEFT SIDE OF THE ACCESS DOOR HINGE. REMOVED AND REPLACED WASTE SERVICING DOOR CUTOUT INTERNAL DOUBLER REF EMB SRM 51-40-08. SEE CONTINUE CARD FOR WORK PERFORMED. PART REPLACED WITSDR SWIA2025100900015Rib · crackedRIGHT HORIZONTAL STABILIZER HAS SUSPECTED CRACK AT RIB 12A ON THE MIDDLE SPAR. REMOVED UPPER SKIN OF RT HORIZONAL STABILIZER TO FOM RIB 12A. PERFORMED CUT ALONG THE UPPER FWD FLANGE OF RT HORIZONTAL STABILIZER RIB 12A TO REMOVE CRACK. FABRICATED AND INSTALLESDR JJBA20251008036Channel · corrodedRFI, CARGO ENTRANCE CHANNEL BTW FR 65-68 FOUND CORRODED. RFI, CARGO ENTRANCE CHANNEL BTW FR 65-68 IS OUT OF LIMIT. RFI, CARGO ENTRANCE CHANNEL BTW FR 65-68 REPLACEDSDR JJBA20251008025Frame · corrodedENTRANCE CARGO L-FRAME 65 BTW STR 17L-19L FOUND CORRODED. RF1, ENTRANCE CARGO L-FRAME 65 BTW STR 17L-19L OUT OF LIMIT. RF1, ENTRANCE CARGO L-FRAME 65 BTW STR 15L-16L CUTOUT WAS DONE. RF1 ENTRANCE CARGO L-FRAME 65 CORROSION BTW STR 17L-19L REPAIRED.SDR JJBA20251008024Angle · crackedRF1, CARGO ENTRANCE ON AFT FR 68 BTW 17L-18L LOWER ANGLE FOUND CRACKED. RF1, CARGO ENTRANCE ON AFT FR68 BTW STR 17L-18L LOWER ANGLE REMOVED AND REPLACED.SDR IPXA2025100222743Seat Track · corrodedCENTER CARGO COMPARTMENT. SEAT TRACK LOCATED ON CEILING AREA BETWEEN STA 1541 AND 1561/LBL8 HAS CORROSION. HFEC SURFACE INSPECTED SEAT TRACK CUT OUT PER NDTSPM 06-10-01.001.FABRICATED SEAT TRACK SPLICE AND SPLICE PLATE REF MD11 SRM 53-00-52-2R-1.INSTALLED EWISDR IPXA2025100322180Seat Track · corrodedSEAT TRACK LOCATED AT STA 2007/LBL70 HAS CORROSION. VERIFIED STEP 31 C/W PER UPS GMM RII 04-02SDR IPXA2025100322188Seat Track · corrodedMAJOR REPAIR, WASTE TANK COMPARTMENT. SEAT TRACK LOCATED AT BS 2007, RBL70 HAS CORROSION. ACCOMPLISHED REPAIR PER EO-95277-REQ1 REV 2 (T3F18E007K49S) AND VT-SAA EA 011-5342-01-B0567, REV A.SDR SWAA2025100614961Seat Track · corrodedCORROSION ON TOP AND IN WELL OF PAX CABIN SEAT TRACK AT BS 687 LBL 45 WL 208. REMOVED PASSENGER CABIN SEAT TRACK AT BS 540-727B LBL 45 WL 208. INSTALLED NEW SERVICEABLE SEAT TRACK AT BS 540-727B LBL 45 WL 208 PER BOEING DWG 144A5300 REV E AND SRM 51-40-02-SDR IPXA2025100313296Channel · crackedAFT. ACCESORY COMP. HORIZ. STAB. FRONT SPAR RH CHANNEL CRACKED. DOT 139-19.REMOVED UPPER AND FWD APRON DISPLACED LOWER APRON IAW A300-600 AMM 55-15-11-401.REMOVED LEADING EDGES 341AB AND FAIRING SUPPORT IAW A300-600 AMM 55-12-11/401.REMOVED CHANNEL AT HORIZONTSDR JJBA20251006006Support Angle · crackedRFI, CARGO ENTRANCE AREA, SUPPORT ANGLE UNDER T-POST AT FR66 FOUND CRACKED. RFI, CARGO ENTRANCE AREA, SUPPORT ANGLE UNDER T-POST AT FR66 REMOVED AND REPLACED.SDR JJBA20251006005Support Angle · crackedRFI, CARGO ENTRANCE AREA, SUPPORT ANGLE UNDER T-POST AT FR67 FOUND CRACKED. RFI, CARGO ENTRANCE AREA, SUPPORT ANGLE UNDER T-POST AT FR67 REMOVED AND REPLACED.SDR R61A2025100300426Shear Tie · corrodedCORRODED SHEARCLIP FR78, STGR 27L-28L. FABRICATED, REMOVED AND REPLACED FR 78 STGR27L-28L SHEAR CLIP EMB SRM 51-40-08SDR SWAA2025100214965Floorboard · delaminatedPASSENGER CABIN FLOORBOARD 241RF TOP SURFACE DELAMINATED.. REMOVED PASSENGER CABIN FLOORBOARD 241RF IAW AMM 53-21-00-000-801;IDENTIFIED FLOOR PANEL 241RF MATERIAL IAW SRM 53-00-50-0I-1, FIG 5, TABLE 5. FOUND DELAMINATION DAMAGE TO BE OUT OF ALLOWABLE DAMAGESDR AALA202510015874Lens · crackedAIRCRAFT IN BASE MAINTENANCE: G7 EMERGENCY PROXIMITY LIGHTS LENS ARE CRACKED. REMOVED AND REPLACED G7 EMERGENCY PROXIMITY LIGHTS AND PERFORMED SATISFACTORY OPERATIONAL CHECK GOOD. PER B737NG AMM 33-51-14.SDR SWIA202509290015Shear Tie · corrodedCORRODED SHEAR CLIP AT FRAME 88, STGR 28R AS MARKED (C-CHECK RO 09/28/2025)REMOVED AND REPLACED SHEARCLIP AT FRAME 88, STGR 28R. REF SRM 51-40-08. REPLACED WITH NEW OEM PART, NO CHANGE TO WEIGHT AND BALANCE.(SEE CONTINUE CARD FOR ALL WORKED ACCOMPLISHED).SDR SWAA2025092914884Slide · out of positionL2 DOOR ESCAPE SLIDE FLAP DRAGGING ON DOOR THRESHOLD. REPOSITIONED L2 DOOR ESCAPE SLIDE USING MT 725-61-06 SEE SWA ID TTG8Q0157V6.SDR IPXA2025092911698Floor Panel · damagedAFT CARGO PANEL 143DF HAS TWO INSERTS PULLED THROUGH. 33-051 JOB COMPLETE. AUDIT COMPLETE.SDR ASAA2025091561058Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1671 ARE INOPERATIVE. GROUNDED - YES. REMOVED & REPLACED POWER SUPPLY M1671 S/N 125296 & INSTALLATION TEST GOOD IAW B737-900 AMM 33-51-06-960-806.SDR ASAA2025091561057Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH POWER SUPPLY M1673 ARE INOPERATIVE. GROUNDED - YES. REMOVED AND REPLACED POWER SUPPLY M1673 S/N 156088 & INSTALLATION TEST GOOD IAW B737-900 AMM 33-51-06-960-806.SDR AALA202509247685Bleed Valve · defectiveAIRCRAFT WAS GROUNDED: NUMBER 1 ENGINE STALL INFLIGHT. CLEARED ON ITS OWN BEFORE ECAM ACTION TAKEN. NUMBER 1 HP VALVE CLOSED. FELT LIKE MODERATE TURBULANCE AT OCCURANCE. **ORIGINAL REPORT WAS AALA202509192525** MAINTENANCE ACCOMPLISHED TSM 71-00-00-810-808-A. SDR AALA202509245255Solenoid Valve · defectiveAIRCRAFT WAS GROUNDED: NUMBER 1 ENGINE STALL INFLIGHT. CLEARED ON ITS OWN BEFORE ECAM ACTION TAKEN. NUMBER 1 HP VALVE CLOSED. FELT LIKE MODERATE TURBULANCE AT OCCURANCE. **ORIGINAL REPORT WAS AALA202509192525** MAINTENANCE ACCOMPLISHED TSM 71-00-00-810-808-A.