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 SIMA20250701002Stringer · corrodedSTRINGER 29R HAS CORROSION BETWEEN FR 76-77. (MAJOR REPAIR) (LEVEL 2 CORROSION) RAR STGR 29R BETWEEN FR 76-77 IAW ERJ 170 SRM 51-40-08.SDR SWAA2025072287469Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 241AF HAS AREAS OF PULLED STRANDS.<[01] FABRICATION OF NEW 241AF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED PER [SRM 53-00-50-2R-0-A00938 (REPAIR GENERAL - COMPOSITE FLOOR PANELS - PERMANENT)];[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2025072287463Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 232RF HAS AREAS OF PULLED STANDS.<[01] FABRICATION OF NEW 232RF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED PER [SRM 53-00-50-2R-0-A00938 (REPAIR GENERAL - COMPOSITE FLOOR PANELS - PERMANENT)];[02] VERIFIED CORRECTIVE ACTION STEP SDR SWAA2025072287462Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231XF HAS AREAS OF PULLED STRANDS. FABRICATION OF NEW 231XF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED PER SRM 53-00-50-2R-0-A00938 (REPAIR GENERAL - COMPOSITE FLOOR PANELS - PERMANENT).SDR SWAA2025072287065Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE IS CRACKED. CRACKED AFT CARGO BAY FWD CORNER SCUFF PLATE IS REPAIRED IAW SRM 53-60-15-2R-1.SDR SWAA2025072287494Attach Angle · crackedLH VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT BS 663 LBL 45 WL 167<[01] REMOVED AND REPLACED NEW UPPER ATACH ANGLE BS 663 BETWEEN LBL 8 TO LBL 64 VAPOR BARRIER AREA PER SRM 51-40-02 AND DWG#111A1000 REV:- AND DWG# 111A0150 REV A.;[02] VERIFIED CORRECTIVE ASDR SWAA2025072287502Attach Angle · crackedRH VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT BS 663 LBL 45 WL 167. REMOVED AND REPLACED NEW UPPER ATACH ANGLE BS 663 BETWEEN RBL 60 TO RBL 8 VAPOR BARRIER AREA PER SRM 51-40-02 AND DWG#111A1000 REV:- AND DWG# 111A0150 REV A.SDR SWAA2025072287466Panel · crackedVERTICAL STAB PANEL 323CL LOWER CLIP CRACKED. REMOVED AND REPLACED PANEL 323CL LOWER CLIP IAW SRM 51-40-02-0G-0 AND SRM 51-40-06-0G-0.SDR SWAA2025072287470Seal · crackedHORIZONTAL STAB PANEL 343AT SLIDE SEAL (SHARK FIN) CRACKED. REMOVED AND REPLACED HORIZONTAL STAB PANEL 343AT SLIDE SEAL (SHARK FIN) IAW SRM 51-40-02-0G STEP 4. B; E; FIGURE 8. VERIFIED INSTALLATION FASTENER CALLOUT IAW IPC 55-10-52-01H ITEM 60.SDR AALA202507217559Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE (C545117-01) ON LH PYLON MEASURES OF CORROSION ARE: L=13.603 IN, W=1.300 IN, D=0.001 IN. MAINTENANCE BLEENDED SPIGOT FITTING RECEPTICLE.SDR AALA202507211169Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE (C545117-01) ON RH PYLON MEASURES OF CORROSION ARE: L=13.603 IN, W=1.300 IN, D=0.002 IN. MAINTENANCE BLEENDED SPIGOT FITTING.SDR SWAA2025072187464Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 241BF HAS AREAS OF PULLED STRANDS. FABRICATION OF NEW 241BF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED IAW SRM 53-00-50-2R-0-A00938 (REPAIR GENERAL - COMPOSITE FLOOR PANELS - PERMANENT).SDR SWAA2025072187471Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 241DF HAS AREAS OF PULLED STRANDS. PASSENGER CABIN FLOOR PANEL 241DF HAD AREAS OF PULLED STRANDS REPAIRED IAW SRM 53-00-50-2R-0.SDR SWAA2025072187472Floor Panel · pulledPASSENER CABIN FLOOR PANEL 241EF HAS AREAS OF PULLED STRANDS ON LOWER SURFACE. REPAIRED IAW SRM 53-00-50-2R-0.SDR IPXA2025072014472Blocker Door · corrodedEVIDENCE OF CORROSION AT THE ENG#2 I/B T/R BLOCKER DOOR #5 UPPER TO LOWER. INSTALLED ENG#2 I/B T/R BLOCKER DOOR #5 IAW-300-AMM 78-32-13/401. #2 ENGINE I/B T/R WAS REPLACED AT TC T3F18E006YV81 BEFORE COMPLETE PNEUMATIC OPS CHECK, MANUAL OPERATION WAS COMPLETED SDR SWAA2025071786993Floor Panel · delaminatedCABIN FLOOR PANELS 241BF; 232RF; 231YF AND 242AF HAVE DENTS/DELAMINATION. REMOVED AND REPLACED PER AMM 53-21-00-400-801-NG (PASSENGER CABIN FLOOR PANEL INSTALLATION - PERMANENT).SDR SWAA2025071787165Support Web · crackedRIGHT WING INBD. FIXED UPPER SHELF PANEL SUPPORT WEB JUST INBD. OF DEFLECTION CONTROL RIB IS CRACKED. REMOVED CRACKED SUPPORT WEB PER SRM 51-40-02.SDR CALA2025071706651Floorbeam · corrodedAFT WET AREA RT FLOORBEAM BS 947 HAS SURFACE CORROSION. DAMAGE FOUND TO BE OUT OF LIMITS PER B737-800 SRM 53-70-51-1A-1. REMOVED AND T-ANGLE REPAIR PER B737-800 SRM 51-40-02. REFABRICATED AND REPLACED T-ANGLE REPAIR PER B737-800 SRM 53-70-51-2R-5.SDR REXA2025071600744Latch · out of toleranceONCE ARRIVE IN ATL PAX DOOR JAMMED AND UNABLE TO OPEN. FOUND DOOR INTERNALLY OUT OF RIG AND AFT SPIGOT OUT OF ADJUSTMENT TOLERANCE. PERFORMED ADJUSTMENT OF THE LATCH MECHANISM IAW CRJ900 AMM 52-11-02. ADJUSTED AFT SPIGOT IAW CRJ900 AMM 52-21-23. FUNCTIOSDR AALA202507142738Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT VACUUM WASTE TANK ENCLOSURE SUPPORT BRACKET AT BS 867. REPLACED BRACKET PER AARD 51-00-05-1.SDR SWAA2025071187194Power Supply · inoperativeR1 DOOR EMERGENCY LIGHTS INOP (HEADER; LOWER SIDE; EXTERNAL). REMOVE AND REPLACED FWD POWER SUPPLY IAW SWA BOEING 737-800 AMM 33-51-06-960-806. OPS CHECK IS GOOD.SDR JJBA20250711031Shear Tie · crackedCF2 RH SHEAR CLIP FR26 BTW STR 15R-16R CRACKED. CF2 RH SHEAR CLIP FR 26 BTW STR 15R-16R REMOVED AND INSTALLEDSDR SWAA2025071087170Floor Panel · strippedPASSENGER COMPARTMENT FLOOR PANEL #231XF HAS STRIPPED FIBERGLASS.<[01] OK TO CLOSE;[02] REMOVED AND REPLACED 231XF AS PER AMM 53-21-00.;[03] INSP VERIFIED CLOSEDSDR SWAA2025071087196Screw · unsecureR1 DOOR AFT GIRT BAR FITTING NEEDS SECURED. R1 DOOR AFT GIRT BAR FITTING SCREWS WERE SECURED IAW AMM TASK 25-66-02-400-801 AND AMM 20-50-11-910-801.SDR SWAA2025071087197Handle · unsecureCR RR R2 AIRFRAME SIDE / DOOR ASSIST HANDLES NEED SECURED<[01] SECURED AIRFRAME SIDE & DOOR ASSIST HANDLES IAW B737-800 AMM 52-41-31;[02] SECURED AIRFRAME SIDE & DOOR ASSIST HANDLES IAW B737-800 AMM 52-41-31.SDR FDEA202507011144Warning Light · false activationAFTER BLOCK OUT, EMER LIGHTS ICAS ALERT ILLUMINATED. WORKED WITH MANT. TURNED EMER LIGHT ARMING SWITCH TO OFF. CYCLE FLIGHT ATTENDANT EMER LIGHT SWITCH AND REARMED THE EMER SWITCH IN COCKPIT. ICAS CLEARED GMM 6-3-100 AT 37,127:43 HOUR(S), 6,163 CYCLESDR N3XR202507090003Hinge · crackedDURING A ROUTINE INSPECTION, THE LOWER RUDDER HINGE FITTING WAS FOUND CRACKED ON THE LOWER PORTION AROUND EACH CORNER BETWEEN RIVET HOLESSDR CALA2025070906374Bracket · wornR/H AFT FLAP STRUT SENSOR BRACKET PLATE BEARING HAS EXCESSIVE PLAY. REMOVED AND REPLACED DICREPANT R/H AFT FLAP STRUT SENSOR BRACKET IAW A319 SRM 51-42-11-001.SDR DALA2025070805172Hpc · damagedSHIP 1806- DIV - DIVERTED TO AMS DUE TO LEFT ENGINE COMPRESSOR STALL. CORRECTIVE ACTION: PERFORMED BORESCOPE, FOUND MULTIPLE 1ST STAGE HPC BLADES CURLED AND SHINGLED. ENGINE CHANGE REPLACED.SDR DALA2025070805170Warning Message · false activationSHIP 0179 AMBER L WING SLIDE MSG ON CLIMBOUT WHILE IN LEFT BANK TURN. CORRECTIVE ACTION: PERFROMED PSEU BITE PROCEDURE PER B767 FIM 32-09-00-815-803-001. (7469434).SDR AALA202507083269Handle · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS HANDLE OF THE DOOR ON AFT RIGHT LAVATORY-E IS DIFFICULT TO OPEN. CONFIRMED RIGHT AFT DOOR INTERMITTENT HARD TO OPEN, SEEMS HINGE MAY BE WORN. REMOVED AND REPLACED LAVATORY-E DOOR HANDLE. PER AARD 25-40-10. OSDR SWIA2025070800001Windshield · crackedUPON ENTERING THE RUNWAY FOR DEPARTURE BOTH FRONT WINDSCREENS CRACKED. (FLIGHT 3825 - FILED CLOSED)REMOVED AND REPLACED LH WINDSCREEN PER AMM 56-11-00. OPERATIONAL CHECK OF LH WINDSHIELD HEATING SYSTEM GOOD. PRESSURIZATION LEAK CHECK PASSED. PLEASE REFERENCESDR DALA2025070805078Seat Track · corrodedCORRODED SEAT TRACK @ FR74 TO 2 INCHES AFT OF FR74, LBL23, WL151.5. REMOVED AND REPLACED SEAT TRACK FROM FR 61 TO FR 74, LBL 23, WL 151.5. PER A220 ASRP BD500-A-J51-42-21-00AAA-078A-A AND DWG BOMBARDIER C01342701 REV. G . CORRECTION: IAW A220 ASRP BD500-A-J51-SDR DALA2025070805077Seat Track · corrodedCORROSION SEAT TRACK @ FR74 TO 2 INCHES AFT OF FR74, RBL43 , WL151.5. REMOVED AND REPLACED SEAT TRACK FROM FR 61 TO FR 74 RBL 43 PER A220 ASRP BD500-A-J51-42-21-00AAA-078A-A AND DWG BOMBARDIER PL C01342701 REV-G. (LP# 1059301)SDR DALA2025070805076Seat Track · corrodedCORRODED SEAT TRACK @ FR22, RBL23, WL151.5. REMOVED DAMAGED SEAT TRACK FROM FR19+9" TO FR 34+10", RBL 2, WL151.5. AND REPLACED WITH NEW SEAT TRACK IAW A220 ASRP BD500- A-J51-42-20-00AAA-078A-A AND BOMBARDIER DWG C01712000 REV-A. CORRECTION: RBL 23. (LP# 105940SDR DALA2025070805075Seat Track · corrodedCORRODED SEAT TRACK @ FR22, RBL43, WL151.5. REMOVED AND REPLACED SEAT TRACK AT FR 19 TO FR 30 RBL 43 PER A220 ASRP BD500-A-J51-42-20-00AAA-078A-A AND BOMBARDIER DWG C02312600 REV:-E. (LP# 1057778)SDR DALA2025070805074Skin · corrodedCORROSION FOUND ON FUSELAGE SKIN FWD OF THE WASTE BOX AND FRAME 75. (P). SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0549:0500-2020/004 00354 COMPLIED WITH ER/A PRI 597330-14 REV 0, REV 1, AND FINAL ERA 597330-14ADSDR AALA202507085591Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, RBL 10. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202507083174Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 10. REPAIRED PER SRM 57-10-10-2R-5.SDR SWAA2025070787513Battery Pack · inoperativeEMERGENCY EXIT BATTERY PACK M1670 WILL NOT CHARGE. REPLACED EMERGENCY BATTERY PACK M1670 AND ACCOMPLISHED OPS CHECK IAW AMM 33-51-960-805. TEST GOOD.SDR CALA2025070706258Floor Support · crackedREMOVED AND REPLACED FLOOR SUPPORT AT FWD WET AREA BETWEEN STA 312 TO STA 328 LBL 45.5 IAW SRM 51-40-02-0G-0 ,DWG # 141A5410. REMOVED AND REPLACED INTERCOSTAL AT FWD WET AREA BETWEEN STA 312 TO STA 328 LBL 45.5 IAW SRM 51-40-02-0G-0 ,DWG # 141A5410.SDR CALA2025070706257Floor Support · corrodedFWD WET AREA INTERCOASTAL BETWEEN STA 328 TO STA 344 LBL 44 HAS CORROSION. REMOVED CORROSION, FOUND OUT OF LIMITS, LOCATED AND DRILLED NEW INTERCOSTAL STA328 TO STA344 LBL 45.5, IAW SRM 51-40-02-0G-0 , 53-10-51-1A-1 AND THIS IS BEING INSTALLED ON WORK CARD 9SDR CALA2025070706245Slide · no discrepancyDOOR R2 ESCAPE SLIDE PRESSURE GAGE IS IN RED. ON THE HIGH SIDE FOUND NEEDLE TO WITH WITHIN 1 NEEDLES WITH TO THE RIGHT OF GREEN BAND PER AMM 25-66-01-200-801 DUE TO SLIDES INFLATION CYCLINDER NOT BEING AT A STABLE TEMP FOR MORE THEN 2 HOURS. 52 MINS ON THE GROSDR CALA2025070706244Battery Pack · faultedFOUND MED 4R EPAS GREEN LIGHT NOT BLINKING WHEN IN ARMED POSITION. REF. AMM 52-11-00. RESETTED CB AT P11 H 18. 4L EPAS GREEN FLASHING AND 4R NOT FLASHING. REMOVED AND REPLACED EMERGENCY POWER ASSIST SYSTEM (EPAS) BATTERY PACK REFERENCE: TASK 52-11-20-400-813. SDR CALA2025070706243Slide · no discrepancyREMOVED L1 DOOR BUSSEL AND PINNED EMERGENCY ESCAPE SLIDE TO F.O.M INSTALL L1 DOOR BUSTLE AND STOWELED CYLINDER SAFETY PIN, IAW AMM 25-66-01, L1 DOOR OPS CHECK GOOD. C/W RII OF L1 DOOR BUSTLE INSTALLATION AND SAFETY PIN STOWED OPS CKS GOODSDR CALA2025070706242Unknown · noiseFA REPORTED HISSING SOUND AT L OVERWING EXIT 4000 FT ON DESCENT PERFORMED A LEAK TEST PER MM TASK 05-51-24-782-001. NO HISSING OR LEAK OBSERVED.SDR SCNA20250707243Sign · detachedAFT OVERHEAD EXIT SIGN DETATCHED FROM CEILING. REPLACED AFT OVERHEAD HOUSING ASSY FOR EXIT SIGN EXIT LIGHT OPS CKS GOOD. REF AMM 33-51-00.SDR DXTA2025070304109Cooling Fan · failed"TAIL OTEMP" CAS MESSAGE APPEARED TWICE. ONCE IN BCT WITH APU POWER ON FOR ONLY 30 MINS. & AGAIN AFTER LANDING IN PDK ABOUT 15 MINS ON GROUND. RAN CHECKLIST IN BCT & IT CLEARED. DURING TAIL COMPARTMENT CHECK NOTICE IT ABNORMALLY HOT. LIKE NO AIR WAS BEING PUMPSDR AALA202507061123Vent · leakingAIRCRAFT WAS GROUNDED: PACKS HAS AN OIL SMELL. BELIEVED TO BE COMING FROM PACK 1. MAINTENANCE FOUND COKING ON THE GEARBOX VENT TUBE UNION. MAINTENANCE REPLACED GEARBOX VENT TUBE AND UNION, AND REPLACED ALL ASSOCIATED SEALS ON THE APU AIR/OIL SEPERATOR IAW JOB SDR AALA202507061290Engine · shutdownAIRCRAFT WAS GROUNDED: ENGINE 1 FAILURE. FIRST A LOW HUM WAS HEARD DUE TO VIBRATION. N2 VIBRATION SLOWLY INCREASED FROM 1 TO 4. ENGINE STALL ECAM FOLLOWED. THEN A SUBSEQUENT ENGINE FAILURE ECAM FOLLOWED. WE PERFORMED AN ENGINE SHUTDOWN AND HAD A SUCCESSFUL DI