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 JR2R20250624705Intercostal · corrodedINTERCOSTAL AT RBL 10 BETWEEN FR90 AND FR90A IS CORRODED OUT OF LIMITS. REPLACED.SDR JR2R20250624706Angle · corrodedL-ANGLE THAT ATTACHES TO INTERCOSTAL AT RBL 10 BETWEEN FR90 AND FR90A IS CORRODED OUT OF LIMITS. REPLACED.SDR KCSA202506241096Battery · inoperativeAFT SECTION OF EMERGENCY LIGHTS IN THE UPPER DECK ARE INOPSDR SWIA202509020024Fitting · gougedRIGHT WING AILERON HINGE FITTING NR 2 (WING SIDE) OUTBOARD LUG GOUGED. REPAIRED RT WING AILERON HINGE FITTING NR 2 (WING SIDE) REF REO 670-57-51-615 REV--.SDR AALA202508090339Fitting · burredAIRCRAFT IN BASE MAINTENANCE: DAMAGE RACK 80VU BURRED MATERIAL ON LOWER LATERAL FITTING LH IN AFT AVIONIC COMPARTMENT MEASURE BURRED MATERIAL IS L=0.027 INCH. MAINTENANCE PERFORMED INTERIM REPAIR, REPLACEMENT LOWER LATERAL FITTING LH LOC. ON AFT LOWER AVIONICSDR AALA202508091529Fitting · burredAIRCRAFT IN BASE MAINTENANCE: DAMAGE RACK 80VU BURRED MATERIAL ON LOWER LATERAL FITTING RH AND WAS FOUND IN CONTACT WITH STRUCTURE IN AFT AVIONIC COMPARTMENT MEASURE BURRET MATERIAL 0.116 INCH. MAINTENANCE PERFORMED INTERIM REPAIR, REPLACEMENT LOWESDR ASAA2025062359921Floorbeam · crackedSTA 540 PANEL BREAKS CRACKED LBL 44 TO RBL 22. GROUNDED - YES. REMOVED AND REPLACED 3EA PANEL BREAKS AT STA 540 FROM LBL 44 TO RBL 22 I.A.W. B737-700 SRM 51-40-02-OG-0.SDR IPXA2025071168744Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S11R. ACCOMPLISHED REPAIR IAW EO-94311-REQ 1, REV 1, EGAT WORK SHEET 50461, AND SRM 53-60-03-2R-4 REV 46.SDR SWAA2025072984627Web · crackedCRACK WEB LOCATED BS 294.5 TO BS303.9 AND S-16L AT PASSENGER CABIN. PERFORMED PERMANENT REPAIR CATEGORY B ON WEB LOCATED BS 294.5 TO BS303.9 AND S-16L AT PASSENGER CABIN IAW EA 25-153-01804-WIP1 AND EA 25-153-01804.SDR SWAA2025072986534Vapor Barrier · deterioratedTHE RT B.S.663 VAPOR BARRIER HAS A DETERIORATE INTERIM REPAIR AT APPROXIMATELY RBL 35. REPAIRED PER SRM 51-70-04-2R-10-A00755 REPAIR 10 - REPAIR OF DAMAGE THAT IS MORE THAN 0.50 INCH IN SOLID LAMINATES - AIRFRAME - PERMANENT.SDR SWAA2025072986186Vapor Barrier · deterioratedTHE LT B.S.663 VAPOR BARRIER HAS A DETERIORATE INTERIM REPAIR AT APPROXIMATELY LBL 35. THE LT BS 663 VAPOR BARRIER DETERIORATE INTERIM REPAIR AT APPROXIMATELY LBL 35 HAS BEEN REMOVED AND REPLACED PER SRM 57-10-10-2R-2-A01256 REPAIR 2.SDR SWAA2025072984620Floorbeam · crackedCRACK FLOORBEAM LOCATED BS 294.5 AND RBL 52 FWD GALLEY AND LAV. PERFORMED PERMANENT REPAIR CAT A; FLOOR BEAM LOCATED BS 294.5; BTW RBL 20 TO RBL 60 IAW B737-700 SRM 53-10-51-2R-16 REPAIR 16.SDR SWAA2025072984625Floor Support · crackedCRACKED FLOOR SUPPORT LOCATED BS312 TO BS 328 AND LBL 46, FWD GALLEY AND LAV REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02 Ï¿½TEM 9 AND SRM 51-40-02 AND DWG 141A5400 SHEET 26 REV -.SDR SWAA2025072984621Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND LBL 11 FWD GALLEY AND LAV. REPLACED WEB INTERCOSTAL AND FASTENERS ON FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND LBL 11 FWD GALLEY IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 141A5400 SHESDR SWAA2025072984624Tie Clip · crackedCRACK TIE CLIP LOCATED BS 277, S10R PASSENGER CABIN. REPLACED THE TIE CLIP IAW SRM 51-40-02, AND DWG 141A1110, SHEET 18, REV-.SDR SWAA2025072984623Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND BL 0 FWD GALLEY AND LAV. REPLACED WEB - INTERCOSTAL AND FASTENERS ON FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND BL 0 FWD GALLEY AND LAV IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 14SDR SWAA2025072984622Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 277 TO BS 294.5 AND BL 0 FWD GALLEY AND LAV. REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 277 TO BS 294.5 AND BL 0 FWD GALLEY AND LAV IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02, AND DWG 141A5400, SHESDR QMLA2025022720081Door · no discrepancyWHILE AT CRUISE ALTITUDE, THE SLIDING DOOR BEHIND THE PILOT CAME OPEN. AFTER SLOWING DOWN THE AIRCRAFT THE CREW WAS ABLE TO CLOSE THE DOOR. THE DOOR THEN OPENED A SECOND TIME A FEW MINUTES LATER AND AFTER CLOSING THE DOOR THE CREWMEMBER DECIDED TO HOLD THE DOOSDR SCNA20250725274Skin · damagedWO 95798, NR 00001: REF EA 53-0249 ACCOMPLISH A PERMANENT REPAIR OF THE FUSELAGE SKIN BETWEEN STRA 370 – 380 AT S-24R PER SRM 53-00-01-2R-3 WITHIN 5 FLIGHT HOURS OR 2 FLIGHT CYCLES, WHICHEVER OCCURS FIRST ( REINSPECT - TEMP REPAIR, SPEED TAPE, FASTENERS OR TEMSDR AALA202507218671Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO SHEAR TIE ANGLE AT FORWARD SIDE OF BS 318 FRAME, AT S23L. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202507216277Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD SIDE TO BS 318 FRAME ABOVE S23L, REPLACED FRAME PER AARD 51-00-01-05,SDR SWAA2025071684592Attach Angle · crackedR/H BS 663 VAPOR BARRIER UPPER ATTACH ANGLE CRACKED AT RBL 34. FABRICATED & MATCH DRILLED REPAIR PARTS PER SRM 57-10-10-2R-5. INITIAL AREA AND FASTENER HOLES REQUIRE NDT & GVI.;[03] PERFORMED NDT PER BOEING 51-00-00 PART 6. PROCEDURE 16 WITH NO DEFECT NOTEDSDR SWAA2025071684698Attach Angle · crackedCRACK FOUND AT L/H BS 663 VAPOR BARRIER UPPER ATTACH ANGLE LBL 9. CUT OUT AND REMOVED BS 663 ATTACH ANGLE FROM APPROX LBL 18-LBL 5. ALL WORK DONE IAW SRM 57-10-10-2R-5.SDR SWIA2025071600623Beam · corrodedREAR FUSELAGE L/H BEAM CORRODED FR 86 TO FR 89. REMOVED AND REPLACED REAR FUSELAGE LH BEAM AT FR86-89, REF EMB SRM 51-40-08. LH BEAM REPLACED WITH OEM PART. THERE IS NO CHANGE TO WIEGHT AND BALANCESDR AALA202507146680Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK EXTERNAL SKIN BTW FR69-FR70 STR23R, L=0.362 INCHES.SDR JJBA20250711010Support · corrodedRH SILL BTW FR53-59 CORRODED. BTW FR 53-59 RH SILL BLENDED OUT OF LIMITS. RH SILL BTW FR 53-59 REMOVED AND REPLACED.SDR AALA202507118082Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 959, RBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-5.SDR AALA202507112604Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 960, RBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-5.SDR AALA202507110608Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986, RBL 50. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202507110368Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986, LBL 50. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR ASAA2025062359331Floor Support · corrodedREMOVAL OF FLOOR PANELS FOR ACCESS REVEALED SUPPORT Z ON RH SIDE FROM 727I-727G HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. VERIFIED AREAS OF CORROSION TO BE AT .028 BEFORE DAMAGE REMOVAL. ORIG THICKNESS .040 PER BAC 1496-377. MAT LOSS IS .012. AREA OUT OSDR ASAA2025062359328Floor Support · corrodedUPON REMOVAL OF FLOOR PANELS FOR ACCESS MAINTENANCE FOUND A SUPPORT ZEE TO BE CORRODED IN NUMEROUS PLACES FROM RH SIDE 767-727L. GROUNDED - YES. VERIFIED AREAS OF CORROSION TO BE AT .028 BEFORE DAMAGE REMOVAL. ORIG THICKNESS .040 PER BAC 1496-377 MAT LOSS .012SDR ASAA2025062359305Floor Support · corrodedREMOVAL OF FLOOR PANELS FOR ACCESS REVEALED SUPPORT Z ON RH SIDE FROM 727I-727L HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. VERIFIED AREAS OF CORROSION TO BE AT .030 BEFORE DAMAGE REMOVAL. ORIG THICKNESS .040 PER BAC1496-377 AREA OUT OF LIMITS PER B737-90SDR IPXA2025070973491Frame · dentedUPON REMOVAL OF ISOLATOR STA.600 R/H LWR. DATO PANEL T3F18E006W161 FOUND DENT ON FRAME ATA 53-10. INSTALLED REPAIR PARTS 3EA (FRAME FILLER, FILLER ANGLE AND REPAIR ANGLE), 1 EA CLIP AT FRAME STA 600 RH STGR 16, 1 EA WEB CLIP P/N 143N5269-1 AND 1 EA FILLER P/N:SDR IPXA2025070973399Frame · dentedUPON REMOVAL OF ISOLATOR STA. 520 LWR. DATO PANEL T3F18E006W14Y FOUND DENT ON FRAME. INSTALLED REPAIR PARTS 3EA (FRAME FILLER, FILLER ANGLE AND REPAIR ANGLE) AND 1 EA CLIP AT FRAME STA 520 RH STGR 16 IAW B757-200PF SRM 53-30-07-2R-1 REP. 1 DETAIL VI PAR.4 STESDR AALA202507084178Control Module · faultedAIRCRAFT WAS GROUNDED: AUTO BRAKE DISARM LIGHT REMAINS ILLUMINATED WHEN SETTING THE AUTO BRAKE. REMOVED AND REPLACED (AACU)-AUTOBRAKE PRESSURE CONTROL MODULE. PER AMM 32-42-81. LEAK AND OPERATIONAL CHECK GOOD.SDR AALA202507081915Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 959, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR DALA2025070705006Light · detached(LOG 6402874) SEAT 18D EMERGENCY EXIT LIGHT TORN OFF SEAT. REMOVED AND REPLACED SEAT 18D EMERGENCY EXIT LIGHT. OPS CHECK GOOD IN REF B737 AMM 33-51.SDR SCNA20250707246Pressure Deck · crackedCRACK OF 0.625 IN LENGTH ON VERTICAL PRESSURE WEB AT LEFT SIDE OF VERTICAL PRESSURE DECK WEB STA 663 LBL 34 IN REFERENCE TASK CARD ENG-57SCA-11508 STEP 5. A). PRESSURE WEB AT LEFT SIDE OF VERTICAL PRESSURE DECK WEB STA 663 LBL 34 WAS REPAIRED PER B737-800 SRMSDR SCNA20250707245Floorbeam · corrodedCORROSION IN BEAM OF FLOOR SUPPORT AT LBL 44 & STA 986 AT W2 PASSENGER CABIN. BEAM OF FLOOR SUPPORT AT LBL 44 & STA 986 AT W2 PASSENGER CABIN WAS REPAIRED PER B737-800 SRM 53-70-51-2R-6 REPAIR 6.SDR SWIA202507030623Valve · faultedAIRCRAFT SUFFERED LOSS OF PRESSURIZATION TWICE. BLEED 2 FAIL CAUTION IN FLIGHT OCCURRED TWICE. BOTH AT FL220. RAN QRH FOR BOTH OCCURRENCES. CAUTIONS AND ADVISORIES PRESENT USING EVENT WERE: ICE CONDITION, PACK 1 OFF, BLEED 2 FAIL. (FLIGHT 5746 - FILED CLOSED)SDR IPXA2025070367755Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD SIDE OF BS 2360, S10L. PERFORM EO-94293-REQ1, REV 1, EI F2025A53M-1359, REV 0, AND EGAT WORK SHEET 50454.SDR IPXA2025070366217Support · crackedCRACK, SUPPORT OF OUTBD ELEVATOR L/E AREA NEAR ELEN STA 265 (REPLACE). FABRICATE P/N(183U3424-3) PER BOEING DWG 183U3424 SH2 REV. A; 183U3424-3 PL REV."A"AND ORIGINAL PART AS A SAMPLE IAW GMM-MTX CH 9.08 REV.12 REQUIREMENT AND EGAT WORK SHEET NO.50465. INSTALSDR AALA202507031040Cable · disengagedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE RAFT COVER RELEASE CABLE DISENGAGED FROM SLIDE. REPLACED SLIDE RAFT PER TASK CARD 26L00025011.SDR ASAA2025062359152Floorbeam · crackedSTA 540 PANEL BREAKS CRACKED LBL 44 TO RBL 22. GROUNDED - YES. REMOVED AND REPLACED 3EA PANEL BREAKS AT STA 540 FROM LBL 44 TO RBL 22 I.A.W. B737-700 SRM 51-40-02-OG-0.SDR ASAA2025062359123Shield · corrodedREMOVAL OF FLOOR PANELS FOR ACCESS REVEALED FWD SHIELD TO BE CORRODED IN NUMEROUS PLACES. GROUNDED - YES. AFT CARGO FWD SHIELD FOUND TO BE OUT OF LIMITS. IAW B737-900 SRM 53-00-53-1A-2. REMOVED SHIELD AND L ANGLE IAW B737-900 SRM 51-40-02. LOCATED AND DRILLED SDR SWIA2025070100623Buttstrap · damagedREPAIR FS 280 LOWER BUTT-STRAP BETWEEN STR25L (C-CHECK RO 06/29/2025)PERFORMED REPAIR FS 280 LOWER BUTT-STRAP BETWEEN STR25L BY COMPLYING WITH REO 690-53-21-1936 REV-- DATED 2025-06-27, COMPLIED WITH 51-900-1002-SKY, LEAK CHECK PASSEDSDR IPXA2025062878934Lamp · inoperativeDURING PREFLIGHT FOUND SLIDE PRESSURE PRESS TO TEST ON R1 INOP. RE-LAMPED R1 DOOR SLIDE PRESSURE TEST BUTTON PER AMM 25-61-04. OPS CHECK GOOD. DEFERRAL CLEARED. PLACARD REMOVED.SDR DXTA2025062704029Seal · leakingDURING CRUISE WE NOTICED AN AUDIBLE SQUEAL COMING FROM THE EMERGENCY EXIT DOOR AREA. THERE WAS NO PRESSURIZATION ISSUES NOTED. AS WE DESCENDED THE SQUEAL WENT AWAY AROUND 27000 FEET WITH A PSI OF 8.6. NO VISIBLE ISSUES WITH THE EMERGENCY EXIT DOOR FROM INSISDR CALA2025063006078Water System · leakingWATER SOAKING CARPET AFT 3 ROWS. RAMP FOUND WATER LEAKING INSIDE AFT CARGO BIN.