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 SWIA2025121900906Floor Support · corrodedRBL 9 FLOOR SUPPORT TOP INBD FLANGE IS CORRODED FROM BS 409+5 TO BS 409+118. REMOVED AND REPLACED THE FLOOR SUPPORT CAP AT RBL9 FROM FS409+5-409+118 IAW SRM 51-42-06, 51-42-21, AND REO 601R-53-31-1350, REV-- DATED 2025-09-25. REF CONTINUATION CARD FOR ALL WORSDR SWI2025F01726Retainer · corrodedEXFOLIATED CORROSION ON PAX DOOR FWD LOWER CORNER RETAINER SEAL. REMOVED AND INSTALLED NEW PAX DOOR FWD LOWER CORNER RETAINER IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. CSDR SWI2025F01725Angle · corrodedFOUND CORROSION ON ANGLE DATUM 7A BETWEEN FS 327.763 AND FS338.963. REMOVED PAX DOOR ANGLE DATUM 7A BETWEEN FS 327.763 AND FS338.963 AND INSTALLED NEW ANGLE DATUM 7A BETWEEN FS 327.763 AND FS338.963 IAW. SRM 51-42-06-001-001-A01. AND SRM 51-42-21-001-001-A01SDR SWI2025F01724Support Angle · corrodedFOUND CORROSION ON PAX DOOR FWD ANGLE SUPPORT FWD FS 311.75. REMOVED AND INSTALLED NEW PAX DOOR FWD ANGLE SUPPORT FS311.75 IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRM 51-42-13-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHSDR SWI2025F01723Angle · corrodedFOUND CORROSION ON CLIP FS 338.963 DATUM 7A. REMOVED PAX DOOR CLIP FS 338.963 DATUM 7A. IAW SRM 51-42-06-001-001-A01 & SRM 51-42-21-001-001-A01 AND INSTALLED NEW CLIP BS 338.963 DATUM 7A. IAW SRM 51-42-06-001-001-A01. AND SRM 51-42-21-001-001-A01 AND DWG 601SDR SWI2025F01722Bracket · corrodedFOUND CORROSION ON FWD BRACKET DD5 FS 311. REMOVED AND INSTALLED NEW PAX DOOR FWD BRACKET DD5. IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TASK CARD 51-90SDR SWI2025F01721Intercostal · corrodedFOUND CORROSION ON PAX DOOR FWD INTERCOSTAL DD5. REMOVED AND INSTALLED NEW PAX DOOR FWD INTERCOSTAL DD5. IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TASK CSDR SWI2025F01720Retainer · corrodedEXFOLIATED CORROSION ON PAX DOOR FWD TOP CORNER RETAINER SEAL. REMOVED AND INSTALLED NEW PAX DOOR FWD TOP CORNER SEAL RETAINER REF DWG 601R31702 REV N AND SRM 51-42-06-001-001-A01. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. SDR SWI2025F01719Former · crackedSUSPECTED CRACK ON FORMER, BS 347.27 UNDER MOUNTING PULLEY BRACKET. REMOVED AND INSTALLED NEW PAX DOOR AFT FORMER AT FS347.27 IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG 601R31702 REV N. PERFORMED PRESSURE LEAK CHECSDR SWIA202512080906Angle · corrodedFOUND CORROSION ON CLIP BS 327.763 DATUM 7A. REMOVED AND REPLACED DAMAGED CLIP ON PAX DOOR IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, DWG 601R31702 REV N. COMPLIED WITH 51-900-1002-SKY.SDR AALA202512028316Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE AT RIB 10. REPAIRED SKIN PANEL PER EA 368592.SDR AALA202512024234Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE AT RIB 7. REPAIRED SKIN PANEL PER EA 368592.SDR IPXA2025092541438Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 740, S42L. PERFORM EO-95167-REQ1, REV 1 AND EI F2025A53M-2129 REV 0, AND EGAT WORK SHEET 50687.SDR CALA2025101510110Wire Harness · damagedEEPL HARNESS AT STA. 430 LS HAS A BROKEN PIN LOCK ON THE CONNECTOR AND 2 SECTIONS OF DAMAGED WIRING. REMOVED AND REPLACED CONNECTOR (PN BACC45-FT10-5P), HARNESS ASSEMBLY (BR9635-120-24), CABLE ASSEMBLY (BR9635-30-24) ON EEPL HARN ESS AT STA. 430 LS IAW DWG 4SDR 3EJA202510070006Door · damagedAT 14:19Z, ATC CLEARED TO DESCEND TO FL410 FROM FL450. A 1500 FPM DESCENT BEGAN. AT APPROXIMATELY 14:22Z, SIMULTANEOUSLY HEARD A POP AND FELT A DEPRESSURIZATION. HEARD A LOUD, CONTINUOUS NOISE (LIKE A TRUMPET) FROM THE PASSENGER CABIN, SAW A DOOR SEAL LIGHTSDR AALA202510044918Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500I TO BS 500C, AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202510046306Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B TO BS 500A, AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR SWAA2025100311955Handle · wornWORN NUT OF ASSISTANT HANDLE LOCATED ON FWD SERVICE DOOR 2 EA AND AFT SERVICE DOOR 2 EA. REPLACED NUT OF ASSISTANT HANDLE LOCATED ON FWD SERVICE DOOR 2 EA AND AFT SERVICE DOOR 2 EA IAW 737-800 AMM 52-41-31-400-802 STEP 3.F(2).SDR SWAA2025100311954Handle · wornWORN NUT OF ASSISTANT HANDLE LOCATED ON FWD ENTRY DOOR LOWER SIDE 2EA. REPLACED NUT OF ASSISTANT HANDLE LOCATED ON FWD ENTRY DOOR LOWER SIDE 2EA IAW AMM 52-11-31-400-802 STEP 3.G Ï¿½TEM (2) (D).SDR SWAA2025100311957Handle · wornWORN NUT OF ASSISTANT HANDLE LOCATED ON DOORWAY LININGS AT FWD ENTRY DOOR 4 EA AND FWD SERVICE DOOR 2 EA AT FWD GALLEY AREA. REPLACED NUT OF ASSISTANT HANDLE LOCATED ON DOORWAY LININGS AT FWD ENTRY DOOR 4 EA AND FWD SERVICE DOOR 2 EA AT FWD GALLEY AREA IAW ASDR SWAA2025100311956Handle · wornWORN NUT OF ASSISTANT HANDLE LOCATED ON DOORWAY LININGS AT AFT ENTRY DOOR 2 EA AND AFT SERVICE DOOR 2 EA AT AFT GALLEY AREA. REPLACED NUT OF ASSISTANT HANDLE LOCATED ON DOORWAY LININGS AT AFT ENTRY DOOR 2 EA AND AFT SERVICE DOOR 2 EA AT AFT GALLEY AREA IAW ASDR ASAA2025090661253Transition Panel · corrodedFWD CARGO COMPARTMENT, LEFT SIDEPLATE CHANNEL (21 LBL, FROM STA 420 - 500I), HAS CORROSION ON SEVERAL AREAS. GROUNDED - YES. REMOVED CORROSION FROM LT TRANSITION PANEL STA 420-500I IAW B737-800 SRM 53-00-53-1A-1. REMOVED .020 REMINING .020 ORIGINAL .040 FOUND SDR AALA202510025704Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS & DELAMINATION TO PASSENGER CABIN FLOORBEAM LOCATED AT BS 540, FROM LBL 24 TO LBL 45. REPLACED THE FLOORBEAM IAW AARD 51-00-05-1.SDR AALA202510026316Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS & DELAMINATION TO PASSENGER CABIN FLOORBEAM LOCATED AT BS 540, FROM BL 0 TO RBL 24. REPLACED THE FLOORBEAM IAW AARD 51-00-05-1.SDR AALA202510025091Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS & DELAMINATION TO PASSENGER CABIN FLOORBEAM, BS 540 FROM LBL 45 TO LBL 60. REPLACED FLOORBEAM IAW AARD 51-00-05-1.SDR SWAA2025100112130Floorbeam · crackedCRACK BRAKE PANEL FLOOR STRUCTURE LOCATED BETWEEN BS540 AND BL0 TO LBL24.75 AT PASSENGER CABIN 2025-549876<[01] REPLACED BRAKE PANEL FLOOR STRUCTURE LOCATED BETWEEN BS540 AND BL0 TO LBL24.75 AT PASSENGER CABIN IAW. B737-700 SRM 51-10-02 ITEM 9 AND DWG 143A0060SDR SWAA2025100112132Floor Support · crackedCRACK ANGLE FLOOR STRUCTURE, BS 695, BL 0. REPLACED THE FLOOR SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02-0G-0, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2025100112133Floor Support · crackedCRACK ANGLE FLOOR SUPPORT, BS 695, RBL 24.75. REPLACED THE FLOOR SUPPORT AND FASTENERS IAW SRM 51-40-02-0G-0, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2025092912193Panel · delaminatedPANEL 194CR HAS AREA OF DELAMINATION ON OUTER SURFACE. PANEL 194CR WAS REPAIRED IAW SRM 51-70-05-2R-2.SDR SWAA2025092912110Attach Angle · crackedRIGHT WING T/E FIXED PANEL MID ATTACH ANGLE CRACKED. R & R RT WING T/E FIXED PANEL MID ATTACH ANGLE IAW SRM 51-40-02, AIPC 57-50-00-25, AND AMM 20-50-11-910-801.SDR SWAA2025092912108Attach Fitting · crackedRIGHT WING T/E FIXED PANEL SUPPORT BEAM, ATTACHMENT FITTING CRACKED, JUST INBD OF DEFLECTION CONTROL RIB. R & R ATTACH FITTING IAW 51-4002-0G-0.SDR IPXA2025092150063Support Angle · delaminatedAFT UPPER FUSELAGE AT APU INLET AREA, BS 1787.45, STR 6R, FWD LOWER ANGLE DELAMINATED. INSTALLED NEW FWD LOWER ANGLE IAW SRM 51-40-02-0G.SDR IPXA2025092248757Support Channel · crackedRIGHT WW FWD SEAL RETAINER SUPPORT FRAME O/B AREA HAS A CRACK. INSTALLED SUPPORT CHANNEL AT RT WW IAW SRM 51-40-02.SDR 454A250906075836Heater · dirtyCREW OBSERVED SMOKE IN CABIN WITH HEATER ON CLIMB-OUT. THE PIC DECIDED TO ABORT THE FLIGHT AND RETURN TO STARTING POINT. UPON INVESTIGATION, IT WAS DISCOVERED THAT THIS WAS THE FIRST TIME THAT HEATER HAS BEEN TURNED ON SINCE THE SPRING MONTHS. LINT AND DUST WISDR IPXA2025090647468Floor Panel · delaminatedMCD FLOOR PANEL 231WG IS BADLY DELAMINATED. MCD FLOOR PANEL 231 WG IAW SREO-16407-REQ001 ((APPX B).PANEL INSTALLATION IS CONTROLLED ON TASK CARD T3F18E006XTN7.SDR IPXA2025092341988Crank Assy · gougedCREW ENTRY DOOR FWD EDGE LOWER ROLLR CRANK FITTING GOUGED. VERIFIED ACCOMPLISHED SREO 14721-REQ001 REV 1.SDR IPXA2025092341857Crank Assy · gougedCREW ENTRY DOOR FWD EDGE UPPER ROLLER CRANK FITTING GOUGED AT BOTTOM SIDE. VERIFIED ACCOMPLISHED SREO 14721-REQ001 REV 1.SDR IPXA2025092241519Stringer · crackedMAJOR REPAIR - STRINGER CRACKED, FWD SIDE OF BS 740, S39L. PERFORMED EO-95267-REQ 1, REV 1 & EI F2025A53M-2009, REV 2.SDR IPXA2025092141490Stringer · crackedSTRINGER CRACKED, FWD & AFT SIDE OF BS 740, S47L. PERFORMED SRM 53-20-03-2R-5 REV.46, TR 53-161, & EGAT WORK SHEET 50685, STEPS 1-21. PERFORMED EO-95169-REQ 1, REV 1, & EU F2025A53M-2105, REV 0 & EGAT WORK SHEET 50685.SDR CALA2025092209082Floorbeam · crackedPASSENGER CABIN FLOORBEAM CRACKED AT STA 540 BETWEEN BL0 TO RBL 24 . INSTALLED FLOORBEAM AT PASSENGER CABIN STA 540 BETWEEN BL 0 TO RBL 24 IAW SRM 51-40-02-0G-0 AND IPC 53-42-11-66. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-02-0G-0 AND DWG 143A0060.SDR IXXA2025091801Former · crackedRH WING LE 3 NOSE FORMERS FOUND CRACKED AT OSS446, OSS499 AND OSS550. P/N 114T2512U14, 114T2511U14, AND 114T2202-22.SDR FDEA202509061737Repair · noneEXISTING DOUBLER REPAIR ON EXTERIOR SKIN BETWEEN FR 83 & FR84, STRINGER 39R & 42R REQUIRES EVALUATION TO DETERMINE IF MAJOR OR MINOR AND IF THE REPAIR CONFORMS TO FAA APPROVED DATA. REPAIR WAS EVALUATED & FOUND IN CONFORMITY WITH SRM 53-10-12 FIG.208. EO SDR R61A2025091700392Skin · crackedMAJOR REPAIR. RH WING LOWER SKIN CRACK GOING THROUGH BOTH SIDES OF A FASTENER HOLE OUTBOARD OF THE MLG DOOR JUST AFT OF SPAR 2. REMOVED OLD DOUBLER AND CUT OUT CRACK 1.94" X 0.8" AND INSTALLED NEW, LARGER DOUBLER AND A FILLER IAW ETD 2025-170-927888 REV A.SDR DALA2025091606813Lanyard · unsecureDOOR 1R EMERGENCY SLIDE ARMING BAR DETACHED AND BROKEN. MEM DELTA MX NOTIFIED. REINSTALLED GIRT BAR LANYARD ON 1R EMERGENCY SLIDE IAW AMM 25-61 (7587364)SDR IPXA2025091541450Stringer · crackedMAJOR REPAIR - STRINGER CRACKED, FWD AND AFT SIDE OF BS 740, S43L. PERFORMED EO-95168-REQ 1, REV 1, & EI F2025A53M-2184, REV 1, & EGAT WORK SHEET 50686.SDR IPXA2025091541511Stringer · crackedMAJOR REPAIR - STRINGER CRACKED, FWD AND AFT SIDE OF BS 740, S47R. PERFORMED EO-95170-REQ 1, REV 1, EI F2025A53M-2217, REV 0 & EGAT WORK SHEET 50684.SDR CALA2025091508888Wire Harness · damagedEEPL HARNESS AT STA. 430 LS HAS A DAMAGED SECTION OF WIRING. NOTED TO BE PART NUMBER BR9635-120-24. SUPPORT TASK NSA EMX N/R 00250. UPDATE SDR INFORMATION ONLY REMOVED AND REPLACED DAMAGED SECTION OF HARNESS ASSY AT STA. 430 LS IAW B737 DWG 40N01810 SH2 PG3 RESDR IPXA2025091043242Elevator · inoperativeADD SDR FOR EO-85445-JIC1 STEP 137 PAPER FINAL CHECKED OK.ACCOMPLISHED ADD SDR FOR EO-85445-JIC1 STEP 137.SDR IPXA2025091043210Elevator · inoperativeADD SDR FOR EO-85445-JIC2 STEP 137 PAPER FINAL CHECKED OK.ACCOMPLISHED ADD SDR FOR EO-85445-JIC1 STEP 137.SDR DALA2025091106706Oxygen Mask · unwanted deployONE ROW 17 MASKS DROPPED ABC. REPACKED AND RESTOWED OXY MASKS IAW AMM 35-21. A/C OK FOR SVC.