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 F3LA202507140268Servo Valve · faultedLP461953 #2 ON CLIMB OUT IN A RIGHT TURN PLANE SHOOK VIOLENTLY SPEED 320 ALT 260 FOLLOWED BY FLT CTL AIL SERVO FAULT. FOLLOWED TSM 27-10-00-810-820-A, REMOVED AND REPLACED RH AILERON INBD SERVO CONTROL (33CE2) PER A320 AMM 27-14-51-000-001-A, 27-14-51-400-00SDR SCNA20250711255Slide · dislodgedR1 SLIDE PIN FELL OUT OF POUCH. REINSTALLED SLIDE PIN IN POUCH IAW AMM 25-66-01-400-803. AC OK FOR SERVICESDR K11A2025071100323Switch · unsecureAFT ENTRY LIGHT ILLUMINATED IN FLIGHT. FOUND MISSING HARDWARE ON DOOR SWITCH. RE INSTALLED HARDWARE AND PERFORMED OPS CHECK OF THE DOOR WARNING SYSTEM IAW B737 AMM 52-71-00 OPS CHECK GOOD.SDR CALA2025071106445Slide · partial deployPARTIAL DEPLOYMENT OF DOOR SLIDE 1R REMOVED AND REPLACED RIGHT FWD EMERGENCY ESCAPE SLIDE REF AMM 25-66-01. ACCOMPLISHED RII REQUIREMENTS FOR DOOR 1R EMERGENCY ESCAPE SLIDE INSTALL REF GMM 09-25-05.SDR HK0Y2025071100474Shaft · galledGALLING ON FRONT FACE 23 OF THE LP COMPRESSOR SHAFT ASSEMBLY WHICH IS NOT ACCEPTED IN RR EM LIMIT AND NO REPAIR IS AVAILABLE. THE PART WAS REJECTED IN ACCORDANCE WITH TIME LIMITS MANUAL TASK 05-10-01-800-801, THE DECLARED LIFE OF LP COMPRESSOR SHAFT IS 15000 SSDR DALA2026031101697Door Frame · corrodedFWD SERVICE DOOR CUTOUT FASTENER HOLES FOR TRIM NUT PLATES AT FR17 AND FR20 SHOW OXIDATION. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0568:5321-2013/003 00338 REPAIRED IAW PRI 627026-14 REV 0, PRI 627026-14 REV 1, PRI 627026-14 REV 2, PRI 627026-14 REV 3, SDR DALA2026031101696Door Frame · corrodedFWD PAX DOOR FRAME 19 HAS MULTIPLE FASTENER HOLES WITH CORROSION. REPAIRED IAW PRI 627025-14 REV 0, PRI 627025-14 REV 1, PRI 627025-14 REV 2, PRI 627025-14 REV 3, AND ER/A 627025-14 REV ORIGINAL SECTION 1. (LP# 1074103)SDR DALA2026031101695Door Frame · corrodedFWD PAX DOOR FRAME 22 HAS MULTIPLE FASTENER HOLES WITH CORROSION. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0567:5321-2009/003 00324 REPAIRED IAW PRI 627025-14 REV 0, PRI 627025-14 REV 1, PRI 627025-14 REV 2, PRI 627025-14 REV 3, AND ER/A 627025-14 REV ORISDR REXA2025120200996Hinge · damagedPAX DOOR FUSELAGE SIDE HINGE LUGS (13 OF THE 27 AFT LUGS) EXCEEDS .295"" AND REQUIRES REPAIR OR REPLACEMENT. IAW CRJ 700 SRM 53-21-23-201-A01. COMPLIED WITH MHI RJ REO 670-53-21-2676 REV -.SDR SWI2025F01495Restraint · corrodedFWD BAGGAGE BAY CARGO RESTRAINT NET MOUNT BRACKET HAS MULTIPLE SPOTS OF CORROSION AT APPOX. FS565.00 AND STR.23L (MARKED) 30466400 (C-CHECK RO 11/01/2025)BLENDED CORROSION AND FOUND OUT OF LIMITS. REMOVED AND REPLACED WITH NEW MOUNT BRACKET. REF. CRJ900 SRM SDR SWI2025F01494Retainer · damagedCENTER CARGO DOOR LOWER SEAL RETAINER PN LE670-39644-1 HAS RIVETS INSTALLED INCORRECTLY. SHOULD BE DOUBLE FLUSH PER DWG NO. LE670-39610 REV L. (C-CHECK RO 11/01/2025)REPAIRED THE OVERSIZED LOWER RETAINERATTATCHMENT HOLES ON THE CENTER BAGGAGE BAY DOOR STRUCTSDR SWI2025F01493Restraint · corrodedFWD BAGGAGE BAY CARGO RESTRAINT NET MOUNT BRACKET HAS MULTIPLE SPOTS OF CORROSION AT APPOX. FS565.00 AND STR.26L (MARKED). (C-CHECK RO 11/01/2025)BLENDED CORROSION AND FOUND OUT OF LIMITS. INSTALLED NEW MOUNT BRACKET REF. CRJ900 SRM 51-42-21-001-001-A01 REVSDR SWIA202511030710Restraint · corrodedFWD BAGGAGE BAY CARGO RESTRAINT NET MOUNT BRACKET HAS MULTIPLE SPOTS OF CORROSION AT APPOX. FS517.00 STR27 (MARKED). (C-CHECK RO 11/01/2025)REPLACED WITH NEW FWD BAGGAGE BAY CARGO RESTRAINT NET MOUNT BRACKET PER DWG SH670-33600 REV AD, CRJ900 SRM 51-42-2SDR SWAA2025081590303Scuff Plate · crackedAED (L2) SCUFF PLATE REQUIRES REPLACEMENT<[01] UPDATED TABLE MEASUREMENT;[02] REPLACED DAMAGE SCUFF PLATE DUE TO NO LIMITS FOUND ALL I.A.W SRM 51-10-02-0G-0 PAR 9.C AND AIPC 53-13-00-13; SCUFF PLATE TO BE INSTALLED ON CCN TTG8Q0029YBF STEP 18;[03] ADDED PART ISDR SWAA2025081489866Light · damagedG-4 EXIT LIGHT IS DAMAGED. REMOVED AND REPLACED G-4 EXIT LIGHT PER AMM 33-51-01-960-802. OPS CHECK TEST GOOD.SDR SWAA2025081290178Scuff Plate · crackedFWD CARGO COMPARTMENT FWD CORNER SCUFF PLATE IS CRACKED. REPAIRED FWD CARGO COMPARTMENT FWD CORNER SCUFF PLATE PER SRM 53-30-15-2R-1, SOPM 20-43-03, SOPM 20-41-02;SDR SWAA2025081289830Stub Frame · crackedCRACK FOUND ON STUB FRAME BS 294.5 +8.5'; ABOVE SEAL DEPRESSOR, BETWEEN S8R AND S9R; LENGTH 1.4'. REMOVED OLD FWD SERVICE DOOR STUB FRAME BS 294 +8.5' IAW SRM 51-40-02-0G-0 AND INSTALLED NEW FWD SERVICE DOOR STUB FRAME IAW SRM 51-40-02-0G-0 AND DWG 141A8370 SDR 3EJA2025081210001Pump · making metalON TAKEOFF AT ABOUT 40 KIAS, THE MASTER CAUTION ILLUMINATED ALONG WITH THE FUELFLTR BP LIGHT. RECEIVED FUEL SAMPLE 07/30/2025. SHOWED ALUMINUM FLAKES. TANKS EMPTIED AND CLEAN. REPLACING EJECTOR PUMP RH. THE FUEL CREW HAS FOUND ALL THE METAL SHAVINGS TO BE IN TSDR BAGA2025081200005Doubler · corrodedHEAVY CHECK SUBMISSION - FOUND CORROSION ON REAR BARREL WASTE DOUBLER, TEMP REPAIR PERFORMED.SDR SWAA2025081190124Stiffener · crackedFWD CARGO COMPARTMENT 540 BULKHEAD VERTICAL STRUCTURE STIFFENER HAS CRACK STA 540 LBL 24.97. REPLACED FWD CARGO COMPARTMENT BULKHEAD VERTICAL STRUCTURE STIFFENER ON STA 540 LBL 24.97 IAW-B737-700 SRM 51-40-02-0G-0; SRM- 51-10-02-0G-0; DWG# 111A2001 SHEET 77 SDR JJBA20250811025Gusset · corrodedRH GUSSET BTW FR 59-61 FOUND CORRODED. RH GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. RH GUSSET BTW FR 59-61 REMOVED AND REPLACED.SDR IXXA20250809009Repair · unknownUNIDENTIFIED REPAIR ON THE NO. 1 PYLON, INBOARD, SIDE STRUT SKINSDR AALA202508091691Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION SPIGOT FITTING RECEPTACLE ON RH PYLON MEASURE OF CORROSION ARE: L=13.600 INCH, W:1.345 INCH, D:0.009 INCH. MAINTENANCE REPLACED SPIGOT FITTING RECEPTACLE ON RH PYLON IAW A319 SRM 54-51-12-300-002.SDR IXXA20250809006Skin · not reportedNUMBER 2 PYLON, INBOARD SIDE, STRUT SKIN REPAIR HAS INSUFFICIENT TECH DATA.SDR SWAA2025080790229Floor Panel · delaminatedAFT CABIN FLOOR PANEL 242XF UPPER SURFACE HAS AREAS OF DELAMINATION. DUE TO EXTENT OF DAMAGE, FLOOR PANEL 242XF WAS REPLACED IAW SRM 51-10-02-0G-0 PAAR 9.A (1).SDR SWAA2025080790243Shield · corrodedCOROSSION ON FWD SHIELD AT AFT CARGO COMPARTMENT BS 778; RBL 29; WL 157. REMOVED AND REPLACED ACB FWD SHIELD IAW SRM 51-40-02 AND DWG 146A0081 ID:0025 REV: A.SDR SWAA2025080790223Shear Web · corrodedCORROSION ON SHEAR WEB AT BS986+7 RBL38; WL 208. REPAIRED PER EA#25-153-01909-WIP1.SDR SWAA2025080790236Attach Angle · corrodedCOROSSION ON ATTATCH ANGLE AT AFT CARGO COMPARTMENT BS 790; RBL 27; WL 158. AFTER FURTHER INVESTIGATION AND SOLVENT CLEANING DISCREPANCIES AREA PER SOPM 20-30-03. NO CORROSION FOUND ON DISCREPANCIES AREAS PER SRM 51-10-02.SDR SWAA2025080790235Intercostal · crackedCRACKED INTERCOSTAL ATTACH ANGLE AT FCB BS440 LBL25 WL155. REMOVED AND REPLACED ANGLE AT FCB BS440 LBL 25 WL 155<BR>IAW SRM 51-40-02 AND DWG 143A7505 REV:-.SDR SWAA2025080790242Shield · corrodedCORROSION ON AFT SHIELD AT FCB BS500 -BS500A RBL23 WL156. REMOVED AND REPLACED AFT SHIELD AT FCB BS500-BS500A RBL23 IAW B737-7 SRM 51-40-02-0G-0 AND DWG: 143A8126 ID:0010 REV: A.SDR SWAA2025080790233Stub Frame · crackedCRACK FOUND ON STUB FRAME BS 294.5 +8.5'; 0.6'' ABOVE EDGE OF SEAL DEPRESSOR; BETWEEN S-8R AND S-9R; LENGTH 1'. REMOVED AND REPLACED STUB FRAME P/N 141A8370U13 AT FSD UPPER CORNER FWD AREA PER SRM 51-40-02 AND DWG 141A8370 REV: D.SDR SWAA2025080790239Seat Track · corrodedCORROSION ON SEAT TRACK LBL 25 AT BS500A+8; BS500A+17; BS500C+11; BS500D+10.. REPLACED IN CUSTOMER CARD ID: TTG8Q013R6Z6.SDR SWAA2025080790248Seat Track · corrodedCORROSION ON SEAT TRACK LBL 45 AT BS480+16; BS500+7; BS500A+7. REPLACED IN CUSTOMER CARD ID: TTG8Q013R773.SDR SWAA2025080790261Seat Track · corrodedCORROSION ON SEAT TRACK LBL 45 AT BS500A+17; BS500B+18; BS500D+10. REPLACED IN CUSTOMER CARD ID: TTG8Q013R773.SDR SWAA2025080690226Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 231JF HAS AREAS OF DELAMINATION ON LOWER SURFACE. FABRICATION OF NEW 231JF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED PER SRM 53-00-50-2R-0-A00938.SDR SWAA2025080690227Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 241UF UPPER SKIN HAS AREAS OF DELAMINATION. FLOOR PANEL 241UF WITH AREAS OF UPPER SURFACE DELAMINATION WAS REPLACED BY FABRICATING A NEW PANEL IAW SRM 53-00-50-2R-0 AND DWG 146A5810-470.SDR SWAA2025080690228Floor Panel · delaminatedAFT CABIN FLOOR PANEL 242VF UPPER SURFACE HAS AREAS OF DELAMINATION. REPAIRED AFT CABIN FLOOR PANEL 242VF IAW EA 25-153-01883.SDR SWAA2025080690238Sidewall Support · corrodedFLOOR TO SIDE WALL SUPPORT HAS CORROSION BTW BS 727E+13 AND BS 759; RBL 29; WL 157. REMOVED AND REPLACED ACB R/H FLOOR TO SIDEWALL SUPPORT FROM BS 727+4.04 TO BS 767 IAW SRM 51-40-02 AND DWG 146A7500 ID:0001 REV: B. REFER TASK (TTG8Q013NK43).SDR SWAA2025080690240Sidewall Support · corrodedFLOOR TO SIDE WALL SUPPORT HAS CORROSION BTW BS 727B+7 AND BS 727E+10; RBL 29; WL 157. REMOVED AND REPLACED ACB R/H FLOOR TO SIDEWALL SUPPORT FROM BS 727+4.04 TO BS 767 IAW SRM 51-40-02 AND DWG 146A7500 ID:0001 REV: B.SDR SWAA2025080690241Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AT FCB BS480 - BS500B LBL23 WL156. REMOVED AND REPLACED SIDEWALL SUPPORT BS396 TO BS500D LBL23 WL156 IAW SRM 51-40-02-0G-0 AND DWG 143A7500 REV: -;[02] REJECTION OF STEP 4 ITEM 4: FWD BULKHEAD LOWER SUPPORT INSTALLED WISDR R61A2025073100326Skin · crackedLEFT WING LOWER SKIN IS CRACKED AT RIB 4A AND SPAR 2. REPAIRED LH WING LOWER SKIN AT RIB 4A AND SPAR 2 ETD2025-170-924781 REV.: BSDR NACA2025071000001Seal · deterioratedLEFT & RIGHT HEAT EXCHANGERS INTERAL SURFACE FOAM SEALS FOUND WORN. REMOVED AND REPLACED LT & RT HEAT EXCHANGERS INTERNAL SURFACE FOAM SEALS IAW CARD 21-017-00-01SDR JJBA20250731126Shear Tie · corrodedCF4, SHEAR CLIP AT FR54 BTW STR 21L-21R FOUND CORRODED. SHEAR CLIP FABRICATED AND INSTALLED.SDR JJBA20250731123Skin · corrodedINT SKIN BTW FR 61-62A AND STR 21L-19R FOUND CORRODED. REPAIR DOUBLER PERFORMED ON REAR FUSELAGE I RH LOWER SKIN AT FR62 AND BTW STR 19R-20R.SDR JJBA20250731122Frame · crackedCF2, FR25 BTW STR 15R-16R FOUND CRACKED. CF2 FR 25 BTW STR 15R-16R CUT OUT PERFORMED. FR25 BTW STR 15R-16R PART FABRICATED. CF2 FR25 BTW STR 15R-16R REPAIRED.SDR SWIA2025073000010Pressure Deck · out of positionPRESSURE FLOOR LOWER SIDE, AFT OF THE THE REAR SPAR AT RBL 27 DOUBLER CONTACTING THE REAR SPAR. REMOVED AND INSTALLED NEW PRESSURE FLOOR LOWER SIDE, AFT OF THE THE REAR SPAR AT RBL 27 DOUBLER. REF SRM 51-42-06-001-001-A01 AND DWG SH670-35820 REV-R. COMPLIED WSDR IPXA2025073057913Plate · corrodedAGING FINDING - LEFT ELEVATOR TIP STATIC WIC CONDUCTIVE PLATE HAS EVIDENCE OF CORROSION. AA026 INSTALLED SERVICEABLE L/H ELEVATOR IN REF TO B757 AMM 27-31-01-424-028SDR SWAA2025072490006Shield · corrodedFORWARD PIT DOOR CUT-OUT STRUCTURE AFT RH SHIELD CORRODED IN MULTIPLE AREAS FROM STATION 500 TROUGH 500A. REMOVED CORROSION IAW SRM 51-10-02-0G-0ITEM 15 EVALUATED REWORKED AREA WITH ORIGINAL THICKNESS 0.032'; LOSS 0.005'; REMAINING 0.027' WERE IS A MAXIMUM OFSDR SWAA2025072490004Angle · corrodedFORWARD CARGO LEFT Z-ANGLE HAS MULTIPLE AREAS OF CORROSION AROUND NUT PLATE HOLES FROM BS 500+10 - 500D. REMOVED CORROSION FROM LT ZEE ANFLE BS 500+10 - 500D. EVALUATED REWORKED AREA WITH ORIGINAL THICKNESS 0.040'; LOSS 0.020'; REMAINING .020'. MAXIMUM LOSS OSDR SWAA2025072490005Angle · corrodedAFT CARGO RIGHT Z ANGLE HAS CORROSION AROUND SEVERAL FASTENERS HOLES, BETWEEN BS 727A+17 - 727C+4. REMOVED CORROSION & VERIFIED WITH A 10X POWER MAGNIFYING GLASS IAW SRM 53-00-53-1A-2. EVALUATED REWORKED AREA WITH ORIGINAL THICKNESS 0.040, REMAINING THICKNESS