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 SWAA2025110520669Shield · corrodedCORRODED SHIELD, BS 767 - 794.3, STRINGER 25R, WL 165. REPLACED THE SHIELD AND FASTENERS IAW SRM 51-40-02, & DWG 146A0081, SHEET 49, REV A.SDR SWAA2025110520674Strap · corrodedCORROED STRAP, BS 767 - 787, STRINGERS 25L - 25R. REPLACED THE STRAP IAW SRM 51-10-02, ITEM 9, NO ALLOWABLE DAMAGE IN SRM.SDR SWAA2025110520675Web · crackedCRACKED WEB, BS 927 - 947.5, RBL 21. REPLACED THE WEB AND FASTENERS IAW SRM 51-40-02, AND DWG 147A7500, SHEET 37, REV -.SDR SWAA2025110520663Angle · crackedCRACKED ANGLE, BS 867 BTW STRINGERS 26L - 27L. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, AND DRAWING 149A8102, SHEET 19, REV A.SDR SWAA2025110520673Angle · corrodedCORRODED ANGLE BTW BS 767 - 787, STRINGER 25R, WL 165. REPLACED THE ANGLE & FASTENERS IAW SRM 51-40-02, AND DWG 146A8123, SHEET 16, REV-.SDR AALA202511052667Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL EXISTING REPAIR ANGLE AT FR 67 AND S23L. REPLACED LOWER SILL ASSEMBLY PER SRM 51-42-11.SDR AALA202511057614Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM AT FR 65 AND +Y1732. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR SWAA2025110420560Shield · corrodedCORRODED SHIELD WEB LOCATED BTW BS 492.4 - 500A, RBL 22, WL 208.1. REPLACED SHIELD WEB IAW SRM 51-10-02; B737-800 SRM 51-40-02 AND DRAWING 143A0080 SHEET: 39 REV: A.SDR SWAA2025110420563Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500F - 500I, RBL 22, FWD CARGO BAY. REMOVED DAMAGE AND EVALUATED REWORK AREA ON SUPPORT ZEE IAW SRM 53-00-53-1A-2 ALLOWABLE DAMAGE 2 PARAGRAPH 4.A(2)(A); FIGURE 103 DETAIL D.SDR SWAA2025110420566Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500A TO 500F, RBL 22, WL 208.1 IN THE FWD CARGO BAY. REMOVED DAMAGE AND EVALUATED REWORK AREA ON SUPPORT ZEE LOCATED BTW BS 500A TO 500F, RBL 22, WL 208.1 IAW SRM 53-00-53-1A-2, ALLOWABLE DAMAGE 2, PARAGRAPH 4 A, 2 A, SDR SWAA2025110320698Bracket · damagedELONGATE HOLES ON BRACKET, HORIZONTAL PRESSURE DECK BTW BS 663 - 675, LBL 45 - 54. FABRICATED NEW BRACKET IAW SRM 51-10-02, ITEM 9, AND DWG 144A7715, SHEET 2, REV -.SDR IPXA2025103160829Stringer · corrodedSTRUCTURES, AFT LOWER FUSELAGE FROM STA 1480 TO STA 1500, S-30, HAS PROTUBERANT DENT, FLL-018, ATA 53. INSTALLED FABRICATED STRINGER SECTION, NEW HAT SECTION AND REINSTALLED SPLICE AT STGR-30. IAW B757-200PF SRM 53-00-03-2R-1 REPAIR 1 AND SRM 51-40-02-0G-0.. SDR IPXA2025103060968Skin · corrodedAFT LOWER FUSELAGE FROM STA 1480 TO STA 1500, S-27R TO S-28R, HAS PROTUBERANT DENT, FLL-018, ATA 53. REINSTALLED RH FLOOR PANEL AT AFT CARGO COMP STA 1440 TO STA 1520 IAW B757-200PF SRM 51-40-02-0G-0. ACCOMPLISHED REPAIR PER B757-200PF SRM 53-00-03-2R REPAIR 1SDR VNAA202510310009Floor Support · corrodedCORROSION FLOOR FITTING ON ACCESS 305 (2EA´S) ON GALLEY 3 CORECTIVE ACTION: SUMMARY OF NRC00208: FLOOR FITTING (2 EAS) AND MANUFACTURED DOUBLER (1 EA) ON ACCESS 305 AT GALLEY 3 WERE REPLACED PER ZODIAC AEROSPACE CMM 25-33-30 AND FABRICATED PER REO 690-25-31-04SDR VNAA202510310008Floor Support · corrodedINTERIOR SHEET METAL: CORROSION FLOOR FITTING IN FRONT OF ACCESS 107 (1EA) ON GALLEY 1 FLOOR FITTING PN: CDSP2019-7C-620 ON ACCESS 107(1 EA) ON GALLEY 1 WERE REPLACED PER SAFRAN CMM 25-33-44SDR SWAA2025103020730Web · corrodedCORRODED WEB, BS 492.4 - 500A, S26R, WL 156 IN THE FWD CARGO BAY. REPLACED THE WEB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A0080, SHEET 23, REV-.SDR SWI2025F01465Seat Track · corrodedRIGHT HAND I/B SEAT TRACK AT FR 17 HAS CORROSION. (C-CHECK RO 10/28/2025) REMOVED AND REPLACED RIGHT HAND I/B SEAT TRACK AT FR12-20. REF EMB SRM 51-40-08.O.E.M. PART INSTALLED NO CHANGE TO WEIGHT AND BALANCESDR SWIA2025102900002Seat Track · corrodedLEFT HAND INBOARD SEAT TRACK FRAME 19 TO 16 FOUND CORROSION AND TOOLING DAMAGE AS MARKED (THREE TOTAL) (C-CHECK RO 10/28/2025)PERFORMED PERMANENT SEAT TRACK REPAIR AT FR 17 REF SRM 53-10-10 01P, FR 16 AND FR 19 FOUND TO BE WITHIN LIMITS REF SRM 53-10-10 AD01SDR CALA2025102910692Skin · wornFUSELAGE INTERIOR SKIN CHAFED, FORWARD OF L1 DOOR IN TORQUE TUBE AREA. REMOVED AND REPLACED L1 DOOR MIDDLE HINGE GAP COVER IAW DWG 141A3112 REV A, DWG 141A3110 REV-, AND SRM 51-40-02 RESTORED PROTECTIVE FINISH IAW AMM 51-21-73.SDR CALA2025102910690Stringer Splice · corrodedE&E COMPT, STRINGER SPLICE CORRODED BETWEEN STA 360 AND 380, 17.5" LBL. REPAIRED THE STRINGER SPLICE AND NEW STRINGER SECTIONS IN THE E&E COMP AT STA 360 STRINGER 27L IAW SRM 53-00-03-2R-1.SDR CALA2025102910688Floor Support · corrodedRIGHT AFT WET AREA BS 947-967 FLOOR SUPPORT HAS AREAS OF CORROSION. REMOVED, LOCATED, DRILLED, & REPLACED THE FLOOR SUPPORT IAW DWG 147A5760, REV-.SDR CALA2025102910686Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 986, RBL 34-44 HAD CORROSION ON UPPER SURFACE. REMOVED AND REPLACED EXISTING CORRODED TEE ANGLE REPAIR AT BS 987 FROM RBL 50 TO LBL 30 IAW SRM 53-70-51-2R-4, REPAIR 4.SDR CALA2025102910684Floorbeam · corrodedMAIN CABIN AFT WET AREA FLOORBEAM STA 947.5 RBL50 HAS CORROSION. REMOVED AND EVALUATED DAMAGE 50 PERCENT MAT LOSS FOUND TO BE OUT OF LIMITS IAW SRM 53-70-51-1A-1.CUTTOUT DAMAGED AREA AND REPAIRED WITH TEE CAP ANGLES, AND STRAPS PER SRM 53-70-51-2R-5.SDR SWAA2025102720583Scuff Plate · crackedCRACK ON AFT CORNER SCUFF PLATE AT AFT CARGO BAY. REPAIRED THE AFT CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025102720580Support Angle · crackedCRACK TRAILING EDGE SUPPORT ANGLE LOCATED INTERNAL CAVITY AT LEVEL ORSS 285 AT LT WING. REPLACED TRAILING EDGE SUPPORT ANGLE LOCATED INTERNAL CAVITY AT LEVEL ORSS 285 AT LT WING IAW SRM 51-40-02, SRM 51-10-02 ITEM 9, AND DWG 115A6200, SHEET 10, REV-. MEASURESDR SWAA2025102720581Support Angle · crackedCRACK TRAILING EDGE SUPPORT ANGLE LOCATED INTERNAL CAVITY AT LEVEL ORSS 270 AT LT WING. REPLACED TRAILING EDGE SUPPORT ANGLE LOCATED INTERNAL CAVITY AT LEVEL ORSS 270 AT LT WING I.A.W. B737-700 SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG 115A2930 SHEET 7 RESDR SWAA2025102720642Support Angle · crackedRIGHT WING INBD FIXED T/E PANEL OTBD OF NR 7 SPOILER, AFT SUPPORT ANGLE CRACKED. REMOVED AND REPLACED AFT SUPPORT ANGLE IAW SRM 51-40-02 AND AIPC 57-50-00-25.SDR SWAA2025102720644Plate · crackedRIGHT WING T/E WIGGLE PLATE JUST INBD OF NR 7 AFT CANOE FAIRING CRACKED, ORSS 318. REMOVED AND REPLACED RT WING T/E WIGGLE PLATE INBD OF NR 7 AFT CANOE FAIRING IAW SRM 51-40-02-0G-O.SDR SWAA2025102720645Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651GB ON THE INBD SIDE IS CRACKED. REMOVED AND REPLACED RT WING T/E WIGGLE PLATE COMMON TO PANEL 651GB ON THE INBD SIDE IAW SRM 51-40-02-0G-0.SDR SWAA2025102720646Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE INBD SIDE IS CRACKED. REMOVED AND REPLACED RIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE INBD SIDE IAW SRM 51-40-02-0G-0.SDR SWAA2025102720648Support Angle · crackedLEFT WING INBD FIXED T/E PANEL JUST OTBD OF NR 6 SPOILER AFT SUPPORT ANGLE CRACKED. REMOVED AND REPLACED LEFT WING I/B FIXED T/E PANEL AFT SUPPORT ANGLE JUST O/B OF NR 6 SPOILER IAW SRM 51-40-02; AIPC 57-50-00-25 AND AMM 20-50-11-910-801.SDR SWAA2025102720650Skin · debondedLEFT WING O/B AFT FLAP DISBONDED AT I/B LOWER CORNER. REMOVED AND REPLACED LT OTBD AFT FLAP IAW AMM 27-51-22-000-801 AND AMM 27-51-22-400-801.SDR SWAA2025102720741Rib · crackedCRACK INSPAR RIB LOCATED STAB STA 120.30 AND 9 INCHES OF REAR SPAR AT RT HORIZONTAL STABILIZER. PERFORMED REPAIR LOCATED STAB STA 120.30 AND 9 INCHES OF REAR SPAR AT RT HORIZONTAL STABILIZER IAW SRM 55-10-09-2R-5. REPAIR 5.SDR IPXA2025102661012Skin · corrodedAFT LOWER FUSELAGE FROM BS 1560 - 1580, S29R, HAS PROTRUDING DENT, FLL-018, ACCOMPLISH REPAIR PER SRM 53-00-01-2R REPAIR 28 REV. 124 REQUIREMENTS.SDR CALA2025102610520Skin · crackedR-1 DOOR,WINDOW CAVITY,INNER SKIN, LOWER FORWARD CORNER IS CRACKED. COMPLETED ESFR REMOVED AND REPLACED R-1 DOOR UPPER INNER SKIN IAW BAC DWG 141A6516 REV F.SDR CALA2025102610518Web · corrodedMAIN CABIN L/H SIDE CREASE BEAM WEB IS CORRODED ON THE UPPER SURFACE AT THE MID EXIT DOOR PLUG FWD LOWER BONDING WIRE CONTACT POINT. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS. ORIG MAT .063,MAT LOSS .014, REMAINING MAT .049 IAW SRM 51-10-02.SDR SWIA2025102400002Shear Tie · corrodedAFT WET AREA SHEAR CLIP IS CORRODED AT FRAME 88-89 BETWEEN STRINGERS 20L-21L. (C-CHECK RO 10/23/2025)REMOVED AND REPLACED AFT WET AREA SHEAR CLIP AT FRAME 88-89 BETWEEN STRINGERS 20L-21L REF EMB SRM 51-40-08. REPLACED WITH OEM PART AND DOES NOT EFFECT WEIGHT SDR IPXA2025102254371Strap · corrodedTAILCONE. APU INLET DOOR CUTOUT HAS CORROSION ON THE FWD EDGE.REMOVED FWD STRAP LOWER MIDDLE ANGLE AND FWD LOWER ANGLE AT APU INLET DOOR STRUCTURE IAW SRM 51-40-02-0G-0. SEVERE CORROSION ON REMOVED PARTS FWD STRAP PN, UPPER MIDDLE ANGLE, UPPER FWD ANGLE LOWER SDR AALA202510235097Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, FROM LBL 51 TO LBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-5 AND EA 368713.SDR CALA2025102310448Window Frame · crackedLEFT WINDSHIELD FWD NODE, MOST INBD HOLE FROM CENTER LINE HAS A CRACK INDICATION AT THE 6:O CLOCK POSITION 100% SH. PERFORMED REPAIR IAW PART 1 INTERIM REPAIR IAW EC/RA 5311-03390 AND REO-L25578 REV IR WITH NO DEVIATIONSSDR IPXA2025101554034Crease Beam · corrodedCORROSION FOUND ON CREASE BEAM ON MAIN CABIN FLOOR BETWEEN STA 1600-1580 LBL AT STR 17. REMOVED 1EA SIDEWALL LINING P/N:146N5509-7 FROM MAIN CABIN BETWEEN BS 1580 TO 1660 LBL-STGR 17 FOR ACCESS IAW 51-40-02-0G-0. ASSEMBLED AND INTALLED REPAIR PARTS IAW E.A. SDR SWI2025F01437Fitting · brokenFORWARD SERVICE DOOR EMERGENCY EVACUATION SLIDE FORWARD GIRT BAR FLOOR FITTING FLAP SLIDE SPRING HAS 1 BROKEN TAB. (C-CHECK RO 10/19/2025)REMOVED AND REPLACED FWD SERVICE DOOR EVACUATION SLIDE FWD GIRT BAR FLOOR FITTING SPRING. REF ERJ175 AMM 53-10-25. SEE SDR SWI2025F01436Seat Track · corrodedRH IB SEAT TRACK AT FR 16 CORRODED (C-CHECK RO 10/19/2025)REMOVED AND REPLACED RH INBOARD SEAT TRACK SEGMENT FR12-20, REF SRM 51-40-08. REPLACED WITH NEW OEM PART, NO WEIGHT AND BALANCE ADJUSTMENT REQUIRED. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA2025102000002Beam · corrodedR/H CENTER BEAM HAS SIGNS OF CORROSION AT FR 87 (C-CHECK RO 10/19/2025) REMOVED AND REPLACED RH CENTER BEAM AT FR87, REF SRM 51-40-08. THIS REPAIR DOES NOT AFFECT THE WEIGHT AND BALANCE OF AIRCRAFT.SDR AALA202510203273Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 947.5 AND BS 967 AT LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR R61A2025101900470Stringer · corrodedCENTER FUSELAGE III STRINGER 23L CORRODED. : REMOVED, REPAIRED AND REPLACED CENTER FUSELAGE III STRINGER 23L BETWEEN FR74-FR90 AND STRINGER 23L SPLICE FR81-FR82. REF:ETD2025-170-929671 AND EMB SRM 51-40-08.SDR IPXA2025101558814Skin · damagedMAJOR REPAIR, SKIN DOUBLER BS 700 - 720, STRINGERS 1R & 2R IS BENT AND DEFORMED, . ACCOMPLISHED REPAIR PER EO-95379-REQ1 AND VT-SAA EA 757-5330-01-B0577, REV. IR.SDR CALA2025101610167Frame · damagedEA2500-13122 OPS 011 F.S 727K TO 727L RT SIDE STRINGER 5R WAP#3 & GROUND CLIP INTERFERES WITH THE INTERCOSTAL INSTALLATION REQUESTING ENGINEERING ASSISTANCE. SUPPORT TASK NSA EMX NR 00224 ESFR CREATED FOR INT DURING CXF MOD. RELOCATED GROUND CLIP AND WAP #3 FRSDR IPXA2025101443697Channel · crackedMAJOR REPAIR, DURING PERFORM EO-26856-JIC001 FOUND CHANNEL CRACK AT STA 740 L/H AFT SIDE. PERFORMED THE HEAT TREATMENT FROM 2024-O-071 CLAD TO T42 CONDITION I.A.W. EGAT WORK SHEET 50730, STEP 4.I. (REFER TO SHOP LOG 2025-290). I.A.W. SRM 53-20-30-2R-2, REV.10SDR IPXA2025101354034Crease Beam · corrodedCORROSION FOUND ON CREASE BEAM ON MAIN CABIN FLOOR BETWEEN STA 1600-1580 LBL AT STR 17 . ATA 53-00 VERIFIED STEP 31, RESTORE ACCESS AT REPAIRED AREA PER EA 757-5300-01-B0575 STEP 13 WILL BE ACCOMPLISHED IN TASK CARD T3F18E0073RLF.