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 SCNA20250730287Angle · crackedWO 88395, INITIAL INSPECTION: CRACK ON INTERCOSTAL ANGLE STA 400, 500C, 500D, 500G AND 500H STGR 26L AT FWD CARGO COMPARTMENT. RESOLUTION: DUE TO CRACK ON INTERCOSTAL ANGLE STA 400, 500C, 500D, 500G AND 500H STGR 26L AT FWD CARGO COMPARTMENT (6EAS) WERE REPLACSDR SWAA2025072988571Access Panel · damagedELONGATED HOLE ACCESS PANEL 323CL AT VERTICAL STABILIZER. REPLACED ACCESS PANEL 323CL AT VERTICAL STABILIZER IAW B737-700 DWG 172A6120 SHEET 1 REV. F.SDR REXA2025072900774Floorbeam · corrodedINITIAL INSPECTION: CORROSION ON FLOOR BEAMS SPACER FS 310.00 LBL 11 AND FS 333.00 RBL 8 AT FWD PAX CABIN (W1) CORROSION ON FLOOR BEAMS SPACER FS 310.00 LBL 11 AND FS 333.00 RBL 8 AT FWD PAX CABIN (W1) WAS REMOMED PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE ESDR REXA2025072900773Fitting · corrodedCORROSION ON GALLEY FITTINGS (5 EAS) FS 288.00 LBL 37, FS 295.00 RBL 3, FS 316.00 RBL 4 AND FS 285.00 RBL 17 AND RBL 38 APROX AT PAX CABIN GALLEY FITTINGS (5 EAS) FS 288.00 LBL 37, FS 295.00 RBL 3, FS 316.00 RBL 4 AND FS 285.00 RBL 17 AND RBL 38 APROX AT PAX CSDR REXA2025072900765Strap · crackedCRACK ON JOINT STRAP BTW ACCESS PANEL 195DL AND 196DR STRAP ASSY (P/N: CC690-39171-5) WAS VERIFIED PER CRJ-900 IPC 53-82-83-10 AND REPLACED PER CRJ-900 SRM 51-42-13-001-001-A01.SDR REXA2025072900764Lug · corrodedRTN FINDING IN REF TO CARD 900-27-900-910: AFTER BEARING AND BUSHINGS REMOVAL ON LH AILERON, CORROSION WAS FOUND ON ALL LUGS BORES AT LH AILERON CENTER FITTING LUGS BORES L1, L2, L5 AND L6 AT LH AILERON CENTER FITTING WERE REPAIRED PER REO 670-57-61-107 REV - SDR DALA2025072905684Service Door · missing(LOG 7462944) EXTERIOR LAV PANEL DOOR MISSING. TOILET SERVICE DOOR WAS INSTALLED UNDER AMDS 5249-4001.SDR IPXA2025071179209Stringer · corrodedMAJOR REPAIR, LOWER AFT FUSELAGE, BS 1460 HAS EXFOLIATION CORROSION BETWEEN SKIN INNER AREA AND STRINGERS 29 AND 30. INSTALLED STRINGER 23 CLIPS. INSTALLED 2 SUPPORT CHANNELS. INSTALLED 8 FLOOR SUPPORT BRACKETS. INSTALLED 6 STRINGER SPLICES. INSTALLED ONE ANTSDR SCNA20250728279Frame · wornWEAR ON FRAME STA-440 BTW STGR 22L/26L AT FWD CARGO COMPARTMENT FRAME STA-440 BTW STGR 22L/26L AT FWD CARGO COMPARTMENT WAS BLENDED OUT PER B737-800 SRM 51-10-02-0G-0 AND EVALUATED WITHIN LIMITS PER B737-800 SRM 53-00-07-1A-1 ALLOWABLE DAMAGE 1SDR SCNA20250728278Floorbeam · corrodedCORROSION ON BEAM STA 986.5 BTW LBL 45 TO RBL45 AT CPAX W2. BEAM STA 986.5 BTW LBL 45 TO RBL45 AT CPAX W2 WAS REPAIRED PER B737-800 SRM 53-70-51-2R-4 REPAIR 4SDR IPXA2025072377856Tee Angle · corrodedSTRINGER RT WTB TEE-CHORD BETWEEN BS 1037 - 1060, RBL 65, HAS EXFOLIATION ON UPPER SURFACE.SDR IPXA2025070677817Intercostal · corrodedRIGHT PACK EXHAUST INTERCOSTAL FRAME SUPPORT AT FWD AREA HAS CORROSION INSTALLED NEW INTERCOSTAL IAW SRM 51-40-02. VERIFIED INSTALLATION OF RT PACK EXHAUST INTERCOSTAL FRAME FWD SUPPORT.SDR IPXA2025070677685Tee Angle · corrodedLOWER FUSELAGE INTERCOSTAL T-CHORD BETWEEN STA 1037-STA 1060 RBL 7 HAS CORROSION. INSTALLED T-CHORD P/N: UP-144N8180-48, STA 1037-STA 1060 RBL 7 IAW B757-200PF, SRM 51-40-02SDR IPXA2025070677526Tee Angle · corrodedWTB T-CHORD BETWEEN STA 1037 - STA 1060 LBL 65 HAS EXFOLIATION ON UPPER SURFACE. INSTALLED NEW WTB T-CHORD BETWEEN STA 1037 - STA 1060 LBL 65 IAW B757-200PF, SRM 51-40-02.SDR IPXA2025072374238Link · damagedWORN OUT - SUPPORT LINK, NO.2 ENG R/H HPT CASE COOLING FWD DUCT UPPER SIDE, NEAR FUEL SUPPLY LINE. I.A.W AMM 70-50-00-912-001-H00 REV.145, REPLACED THE LINK OF NO.2 ENGINE. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR IPXA2025072374286Link · damagedWORN OUT - SUPPORT LINK, NO.2 ENG L/H LPT CASE COOLING FWD DUCT LOWER SIDE, NEAR EGT. I.A.W. AMM 70-50-00-912-001-H00, REV.145, REPLACED THE LINK OF NO.2 ENGINE. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR IPXA2025071272165Rib · crackedNUMBER 10 SPOILER ACTUATOR SUPPORT HINGE RIB CRACK WS 640. INSTALL NEW FITTING I.A.W SRM 51-40-02-0G REV.92 AND BOEING DWG 112T1000 SH 14 REV: B, 113T1422 SH 1 REV: D, 112T1001 SH 43 REV: -, 113T1653 SH 1 REV: J. I.A.W AMM 27-61-01-424-019 REV 145 STEP 3A TSDR DALA2025071705398Stringer · damagedSHIP 3417 FOUND ELONGATED HOLES AT STR 2R. COMPLIED WITH ER/A 627124-14. (1064951).SDR DALA2025071605354Frame · damagedSHIP 3417 ELONGATED HOLES AND TOOLING DAMAGE AT FR 60, FR 61, FR 62, FR 63, FR 64. REPAIRED PER ERA 627125-14. (1064981)SDR SCNA20250716263Floorbeam · corrodedWORK ORDER 88395, N/R-00120: EMP 10002086 INITIAL INSPECTION: CORROSION ON BEAM STA 986.5 BTW LBL 45 TO RBL45 AT CPAX W2. - RESOLUTION: (OPEN)SDR IPXA2025071173048Strap · crackedCRACK - STRAP, FWD LOWER CARGO MAIN DECK FLOOR STRUCTURE STA 610 RBL 64.5. INSTALL THE REPAIR PARTS WET WITH BMS 5-95 FAYING SURFACE SEALANT. REFER TO FIGURE 2. INSTALL ALL HI-LOKS WET WITH BMS 5-95 SEALANT IN TRANSITION FIT HOLES PER 767-300F SRM 51-40-05. SHSDR KCSA202507110535Light · inoperativeRIGHT UPPER DECK GROUND MODE LIGHT INOPERATIVE. COMPLIED WITH (M) PROCEDURES IAW MEL 52-23-4-2. CYCLED DOOR C/B ON P180 DOOR MODE LIGHT TEST OK IAW AMM 52-23-16. THIS CLEARS DMI 100259027.SDR DALA2025070905187Pump · leakingSHIP 3575 - ATB - DUE TO NUMBER 2 ENGINE OIL QUANTITY DROPPING TO ZERO AT FL170. OIL PRESSURE AND TEMPERATURE ARE NORMAL. CORRECTIVE ACTION: MEL WAS APPLIED; R/R NUMBER 2 ENGINE OIL PUMP PER A350 AMM 79-22-61. (LP# 7476499)SDR DALA2025070905186Light · inoperativeCHK FOUND EMERGENCY LT ON L1 CEILING INOP. REPLACED LT ASSEMBLY P/N 8603-1-00 IAW AMM33-51-14. OPS CHECKED OK. (LP# 1064305)SDR P5CA2025070500032Flashlight · no testPORTABLE FLASHLIGHT CAPTAINS SIDE DOES NOT TEST.(<P>PERFORMED OPERATION TEST IAW AMM 25-64-01. GREEN LIGHT SHOWED UP, ITS STATUS IS THE SAME AS THE OTHER TWO, MDDR 233689 WAS CLEARED. A/C BACK TO NORMAL.</P>)SDR UIEA2025070500834Exhaust Duct · disconnectedFIRE APU WARNING ON TAXI IN RAN NON-NORMAL CHECKLIST. DEACTIVATED THE APU AND REMOVED THE APU EXHAUST DUCT IAW EA-4849A025 PART 1 & AMM 49-11-01. INSPECTIONS COMPLETED NO FURTHER FINDINGS. REMOVED AND REPLACED THE DAMAGED APU AND APU EXHAUST DUCT CLAMP AND RESDR ASAA2025070559190Cover · missingMID CABIN EXIT SIGN BACKSIDE OF SIGN IS MISSING. GROUNDED - YES. FOUND EXIT SIGN COVER. RE-INSTALLED EXIT SIGN COVER AND OP CHECK GOOD PER AMM 25-21-20.SDR SWAA2025070888465Battery Pack · inoperative2 AFT FLASHLIGHTS INOP<[01] REMOVED AND REPLACED BATTERIES IN 2 AFT FLASHLIGHTS IN REF TO AMM 25-64-00. OPS CHECK GOODSDR SWAA2025070889202Battery Pack · inoperative2 AFT FLASHLIGHTS INOP<[01] REMOVED AND REPLACED BATTERIES IN 2 AFT FLASHLIGHTS IN REF TO AMM 25-64-00. OPS CHECK GOODSDR SWAA2025070888459Lens · looseOVERHEAD EMERGENCY LIGHT LENS LOOSE FROM CEILING<[01] C/W EA M-24-133-00396. PERMANENT REPAIR DUE WITHIN 10 CYCLESSDR SWAA2025070888671Light · out of positionPIECE OF PLASTIC ON FLOOR NEXT. TO ROW 1 CAPTAIN SIDE STICKING UP<[01] RETAPED PHOTOLUMINESCENT STRIP ON CAPT SIDE IAW SIPSDR SWAA2025070888433Oxygen Bottle · low pressureCREW O2 LOW. REMOVED AND REPLACED CREW 02 BOTTLE PER AMM 12-15-21 AND IN ACCORDANCE WITH MT 835-PRD-01-01.SDR DALA2025070805115Frame · damaged(LOG 1065679) RIGHT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02. AMDS CARD 5311-01251-02B JOB NUMBER 039-0001 WAS ACCOMPLISHED.SDR DALA2025070805093Plate · corroded(LOG 1065565) CORROSION ON LH SIDE PLATE AT FWD CARGO COMPARTMENT FROM STA 500 TO 500I (C1). LH SIDE PLATE AT FWD CARGO COMPARTMENT FROM STA 500 TO 500I WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070805092Intercostal · corroded(LOG 1065412) CORROSION ON INTERCOSTAL BTW STA 986-992 OVER S-20LH AT AFT CARGO COMPARTMENT. INTERCOSTAL BTW STA 986-992 OVER S-20LH AT AFT CARGO COMPARTMENT WAS REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G PAR 7.C AND DWG 147A8801 REV: M.SDR DALA2025070805091Support · corroded(LOG 1065076) CORROSION ON FITTINGS SUPPORTS BTW STA 947.5 TO 967 AT RBL 51 AND LBL 51 PAX CABIN FLOOR STRUCTURE. FITTINGS SUPPORTS BTW STA 947.5 TO 967 AT RBL 51 AND LBL 51 PAX CABIN FLOOR STRUCTURE WERE REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070805090Floorbeam · corroded(LOG 1065025) CORROSION ON FLOOR BEAM STA 952 BTW RBL 55 TO RBL 45 AT PASSENGER CABIN. CORROSION ON FLOOR BEAM STA 952 BTW RBL 55 TO RBL 45 AT PASSENGER CABIN WAS REPAIRED PER B737-800 SRM 53-70-51-2R PROCEDURE 5 REPAIR 5.SDR DALA2025070805089Floorbeam · corroded(LOG 1064976) CORROSION ON FLOOR BEAM STA 947 LBL 47 BELOW LAVATORY FITTING AT PAX CABIN. FLOOR BEAM STA 947 LBL 47 BELOW LAVATORY FITTING AT PAX CABIN WAS REPAIRED PER B737-800 SRM 53-70-51-2R PROCEDURE 5 REPAIR 5.SDR DALA2025070805088Floorbeam · corroded(LOG 1064968) CORROSION ON FLOOR SUPPORT STA 947.5 AT RBL 47 PAX CABIN FLOOR STRUCTURE. FLOOR SUPPORT STA 947.5 BTW RBL 25 TO 50 PAX CABIN FLOOR STRUCTURE WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025070805087Floorbeam · corroded(LOG 1064946) CORROSION ON FLOOR BEAM STA 986.5 BTW RBL 31 TO RBL 39, ON PREVIOUS REPAIR RBL 39 TO RBL 47 , AT PAX CABIN FLOOR STRUCTURE. FLOOR BEAM STA 986.5 BTW RBL 31 TO RBL 47 WAS REPAIRED PERMANTLY PER ERA 464736-14MA REV. A.SDR DALA2025070805086Plate · corroded(LOG 1064902) SIDE PLATE AT AFT CARGO COMPARTMENT FROM STA 727-767 CORROSION WAS FOUND ON SHIELD BTW STA.787 AND STA.767 RH SIDE, UP OF STRG.25RH. AT AFT CARGO. SHIELD BTW STA.787 AND STA.767 RH SIDE, UP OF STRG.25RH AT AFT CARGO WAS REPLACED PER B737-800 SRM SDR DALA2025070805114Lens · detachedSHIP 5809 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:604. CORRECTIVE ACTION: RE-ATTACHED EMERGENCY LIGHT PANEL PER B757 AMM 33-51. OPS CHECK OF EMERGENCY LIGHT NORMAL. (1065346)SDR DALA2025070805112Girt Bar · fodSHIP 5814 R1 DOOR WOULD NOT ARM. CORRECTIVE ACTION: REMOVED OBSTACLES FROM GIRT BAR. OPS CK GOOD. (7529292)SDR DALA2025070805107Skin · not reportedSHIP 663 REPAIR TO LH WING UPPER SKIN COMMON TO DRAG FITTING ATTACHMENT REQUIRES SUPPLEMENTAL INSPECTIONS PER ERA 627083-14AD WINGS / OUTER WING / LHS UPPER SKIN & DRAG FITTINGS / HOLES #2, #3, #8 & #18 / CORROSION & CRACK. CORRECTIVE ACTION: REF ERA 627083-14SDR DALA2025070805104Battery Pack · inoperativeSHIP 6811 DURING SVC CHK FOUND EMERGENCY LIGHTS INOP IN MULTIPLE LOCATIONS. CORRECTIVE ACTION: T/S PER B757 FIM 33-51-00-815-802. FOUND BATTERY PACK M731 TO BE AT FAULT. R/R M731 BATT PACK REF. B757 AMM 33-51. OPS CHK OK. (7357348)SDR DALA2025070805095Door · corrodedSHIP 6711 CORROSION ON SETTLEMENT AREA OF AIR PACK DOOR LH BTW STA 900 TO STA 1040 LBL7 AT AIR PACK CONDITIONED LH. CORRECTIVE ACTION: SUMMARY OF NRC 00208, CORROSION LEVEL 2, SETTLEMENT AREA OF AIR PACK DOOR LH BTW STA 900 TO STA 1040 LBL7 AT AIR PACK CONDITISDR AALA202507085370Fitting · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED AT FR 16 AND DOOR STOP FITTING #1 THE INTERCOSTAL FITTING REQUIRES REPLACEMENT PER THE REPAIR INSTRUCTIONS OUTLINED ON EA 365203. REPLACED INTERCOSTAL FITTING PER EA 365203.SDR AALA202507084119Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL LOWER SURFACE AT RIB 8 AND 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364771.SDR AALA202507088489Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL LOWER SURFACE AT RIB 10 AND 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364771.SDR AALA202507089692Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TOP SKIN PANEL LOWER SURFACE BETWEEN RIB 17 AND RIB 18 AT 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364771.