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 NACA2025082600002Blade · damaged21418 #1 ENG FAN BLADE # 27 HAS A DING APPROX 1.75" ON L/E FROM BLADE TIP DOT 063629. EVLAUATED DING AT #1 ENG FAN BLADE #37 1.75 ON L/E FROM BLADE TIP FOUND TO BE IN LIMITS IAW B767 AMM 72-31-02 PERFORMAED HFEC NO CRACKS FOUND IAW B767 AMM 72-31-02-206-100.SDR NACA2025082600001Blade · damaged#1 ENGINE FAN BLADE #37 HAS A DING APPROX 1.75" REPAIRED DING AT #1 ENG FAN BLADE #37 ON LE BLADE TIP IAW B767 AMM 72-31-308. ENGINE INFORMATION UNAVAILABLE.SDR IPXA2025092565497Profile · chafedLEFT WING FAIRING 34AT HAS CHAFING ON FWD ATTACH ANGLE 109, INSTALLED NEW PROFILE ON FAIRING 534AT IAW AIRBUS SRM 51-40-21 & SRM 51- 40-23.SDR IPXA2025092358524Support Plate · crackedPANEL 575AB SUPPORT PLATE CRACKED. DOT NO. 17-48.INSTALLED SUPPORT PLATE, IAW SRM 51-40-21. VERIFIED ACCOMPLISHMENT OF REPAIR IAW EO-95135-REQ1 AND VT-MAE EA 300-5751-27-A4146, REV.SDR ASAA2025082661090Floor Support · corrodedAFT CARGO COMPARTMENT LONGITUDINAL FLOOR SUPPORT ASSEMBLY B/N STA 727I & 767, S -25R & S -26R, HAS MULTIPLE CORROSION SPOTS. GROUNDED - YES. DAMAGE FOUND TO BE CORRODED THROUGH IN MULTIPLE LOCATIONS WITH 100% MATERIAL LOSS. FOUND TO BE OUT OF LIMITS PER SRM 53SDR SWAA2025092408416Channel · crackedRIGHT WING TRAILING EDGE FIXED PANEL SUPPORT CHANNEL ATTACH BRACKET WAS CRACKED. REMOVED SUPPORT CHANNEL WEB IAW SRM 51-40-02. LOCATED & DRILLED FASTENER HOLES IN NEW CHANNEL IAW SRM 51-40-05. INSTALLED THE CHANNEL IAW SRM 51-10-02, & SRM 51-40-02.SDR SWAA2025092408417Skin · delaminatedR WING OTBD TRAILING EDGE AFT FLAP LOWER INBD SURFACE HAS DELAMINATION.SDR BAGA2025092400005Doubler · corrodedAIRCRAFT IN HEAVY CHECK, REAR FUSELAGE WASTE DOUBLER FOUND CORROSION AT FR75/76. REAR FUSELAGE WASTE DOUBLER REPAIRED PER REO.SDR IPXA2025091964060Floor Panel · damagedAFT CARGO FLOOR PANEL 151QF HAS DAMAGED EDGES . FABRICATION OF FLOOR PANEL 151QF, IAW SREO-16407-REQ002 ((APPX C). PANEL WILL BE INSTALLED ACCORDING TO CARD NO T3F18E006P978.SDR IPXA2025091970836Floor Panel · damagedFWD CARGO FLOOR PANEL 132MG HAS DAMAGE IN 10 PLACES. SH 91148554 VERIFIED FABRICATION OF FLOOR PANEL 132MG, IAW SREO-16407-REQ002 ((APPX C).SDR IPXA2025092070520Floor Panel · damagedFWD CARGO FLOOR PANEL 132QG HAS DAMAGED EDGES ON UNDERSIDE OF PANEL DOT 55-104. REPAIRED FLOOR PANEL IAW A300-600 SREO-42722-REQ001. PANEL 132QG TO BE INSTALLED ON TASK CARD T3F18E006XTNH. JOB COMPLETE.SDR SIMA20250826002Floorbeam · corrodedSSI 53-23-005: RH CENTER FLOOR SUPPORT IS CORRODED AROUND TWO RIVET HEADS AT FR 87 (LEVEL 2 CORROSION). RAR RH CENTER FLOOR SUPPORT AT FRAME 87 IAW ERJ 175 SRM 51-40-08.SDR SIMA20250826003Doubler · corrodedSSI 53-23-018: WASTE SERVICE DOOR CUTOUT DOUBLER CORRODED AT DOOR HINGE AREA (LEVEL 2 CORROSION). REMOVED AND REPLACED WASTE SERVICE DOOR CUTOUT INTERNAL DOUBLER IAW ERJ 175 SRM 51- 40-08SDR SIMA20250826001Shear Panel · corrodedSSI 53-23-005: CENTER FLOOR SHEAR PANEL BETWEEN FRAMES 87-88 IS CORRODED. REMOVED AND REPLACED CENTER FLOOR SHEAR PANEL BETWEEN FRAMES 87-88 IAW SRM 51-40-08.SDR ASAA2025082660966Transition Panel · corrodedFWD CARGO RT TRANSITION HAS MULTIPLE AREAS OF CORROSION FROM STA 500A TO 500I. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS IAW B737-800 SRM 53-00-55-1A-2, REMOVED & REPLACED RH TRANSTION IAW B737-800 SRM 51-40-02-0G-0. W 2, O .040, R 0, L 3, D.040SDR ASAA2025082660964Shield · corrodedSHIELD PANEL FWD OF FWD PIT DOOR CUT OUT HAS CORROSION. GROUNDED - YES. REMOVED CORROSION, ON SHEILD PANEL IN FWD CARGO STA 420-440 RH & FOUND TO BE OUT OF LIMITS IAW 53-30-15-1A-1 & REMOVED & REPLACED IAW B737-800 SRM 51-40-02-0G-0, W 1, O .032, R .027, L 2, SDR ASAA2025082660963Angle · crackedFWD PIT CRACKED BAFFLE CLIP ON FWD SIDE FRAME STA 500G LBL25. GROUNDED - YES. REMOVED & REPLACED BAFFLE CLIP IAW B737-800 SRM 51-40-02-0G-0.SDR ASAA2025082660959Floor Support · corrodedAFT CARGO FLOOR STRUCTURE, RT INTERCOSTAL STA 727A-727B HAS CORROSION AT NUTPLATE HOLE. VIEW UNDER TRANSTIION PANEL. GROUNDED - YES. FOUND TO BE OUT OF LIMITS, REMOVED & REPLACED INTERCOSTAL IAW B737-800 SRM 51-40-02 W= 1.0" O= .032 R= .025 L= 1.0" D= .007.SDR ASAA2025082660957Frame Splice · corrodedAFT CARGO COMPARTMENT RH LOWER FRAME B/N: STA 787, S-25R & S-24R HAS CORROSION. GROUNDED - YES. SPLICE HAS NO ALLOWABLE LIMITS REMOVED CORRODED SPLICE AND INSTALLED P#146A1300-3 PER B737-900ER SRM 51-40-02 AND BDWG 146A1262 REV J.SDR ASAA2025082660939Shield · corrodedAFT CARGO COMPARTMENT LONGITUDINAL FLOOR SUPPORT ASSEMBLY BETWEEN: BS 767 & 787. S25R & S26R, HAS MULTIPLE CORROSION SPOTS. GROUNDED - YES. BLENDED AWAY CORROSION, ORIGINAL THICKNESS (SHIELD) .050 MAT LOSS .017, REMAINING THICK .033, AREA OUT OF LIMITS PER SRMSDR ASAA2025082660849Web · corrodedFWD CARGO DOOR SCUFF PLATE SUB-STRUCTURE HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION FROM FWD PIT CARGO DOOR LOWER WEB IAW SRM 53-30-15-1A-1 ORIGNAL MATERIAL THICKNESS IS 0.050 IAW SRM 53-30-15-01-1, REMOVED 0.020, REMAINING THICKNESSDR ASAA2025082660847Transition Panel · corrodedRIGHT TRANSITION PANEL HAD CORROSION BS 727 - 767. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REMOVED & REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R-G, W 1, O .040, R 0, L2, D .040.SDR ASAA2025082660846Transition Panel · corrodedLEFT TRANSITION PANEL HAD CORROSION FROM BS 727 - 847. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. REMOVED & REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R-6. W 1, 0, .040, R 0, L 2, D .040.SDR CALA2025091508885Floor Support · corrodedFOUND EXFOLIATED CORROSION AT SUPPORT INTERCOSTAL BS 948 RBL 27.25. REMOVED & REPLACED INTERCOSTAL AT BS 948, RBL 27.25 IAW SRM 51-40-02-0G-0 AND DRAWING 147A5650.SDR R61A2025091200390Skin · crackedBIRD STRIKE DAMAGE 2 EA SKIN CRACKS AT FRA 1 BETWEEN STR 20R TO 22R. REMOVED CRACKS AND INSTALLED DOUBLER IAW EMB ETD2025-170-928075. REF VP-036808-2025 N/R 12 FOR WORK ACCOMPLISHED.SDR R61A2025091200389Skin · dentedBIRD STRIKE LH FWD FUSELAGE SKIN DENTED BETWEEN FRA 1 TO FRA 6 AND FROM STR 6L TO 19L. REMOVED AND REPLACED SKIN IAW EMB170/175 SRM 51-41-01 AND 51-41-02 AND ETD2025-170-927883. REF VP-036808-2025 N/R 49 FOR WORK ACCOMPLISHED.SDR R61A2025091200388Frame · bentBIRD STRIKE RH FWD FUSELAGE AT FRA 1 BENT BETWEEN STR 20R TO 24R. REMOVED AND REPLACED FRA 1 IAW EMB 170/175 SRM 51-41-01,51-41-02 AND 51-43-02. REF VP-036808-2025 N/R 8 FOR WORK ACCOMPLISHED.SDR ASAA2025082660792Floor Support · corrodedAFT WET AREA FLOOR SUPPORT FROM STA 947 TO STA 967 RBL 47 HAS CORROSION. GROUNDED - YES. REMOVED AND REPLACED ON AFT WET AREA FLOOR SUPPORT FROM STA 947- 967 RBL 47 IAW B737-800 SRM 51-40-02-0G-0W= 1" O= .080 R= .064 L= 1" D= .016".SDR ASAA2025082660791Strap · corrodedAFT WET AREA FLOOR STRAP AT STA 1016 RBL 3 HAS CORROSION. GROUNDED - YES. REMOVED & REPLACED AFT WET AREA FLOOR STRAP AT STA 1016 RBL 3 IAW B737-800 SRM 51-40-02-0G-0 W- 1" O= .071 R= .054 L= 1.5" D= .017.SDR ASAA2025082660789Strap · corrodedAFT WET AREA FLOOR STRAP AT STA 1016 LBL 3 HAS CORROSION. GROUNDED - YES. REMOVED & REPLACED AFT WET AREA FLOOR STRAP AT STA 1016 LBL 3 IAW B737-800 SRM 51-40-02-0G-0. W 1, O .071, R .059, L 1 1/12, D .018.SDR SWIA2025091000826Slide · unraveledDURING INSTALLATION, AFT SVC DOOR EMERG EVAC SLIDE BECAME UNRAVELED. REPLACED AFT SERVICE DOOR EVAC. SLIDE. REF AMM 25-65-01. SEE CP 30612430 FOR INSTALLATIONSDR 2025FA0000636Impulse Coupling · failedI HAVE NOW HAD 2 QUALITY AICRAFT ACCESSORIES (QAA/HARTZELL)-OVERHAULED SLICK 4372 MAGNETOS W/ IMPULSE COUPLINGS VIOLENTLY SELF-DESTRUCT IN THE SPAN OF 200 HOURS. HARTZELL, THE PARENT COMPANY OF QAA, HAS INFORMED ME THAT BOTH MAGNETOS HAD BRAND NEW OEM CHAMPIOSDR DALA2025090906669Pulley Bracket · damagedL/E CAVITY AFT OF LT #2 SLAT. REPLACED PULLEY BRACKET PER BOEING DWG 5920286 (1164395)SDR R61A2025090700381Doubler · damagedLH HORIZONTAL STABILIZER RIB 14 LOWER FLANGE HAS A DRILL START.REPAIRED LH HORIZONTAL STABILIZER RIB 14 LOWER FLANGE REF. ETD2025-170-927444SDR ASAA2025082660611Transition Panel · corrodedFWD PIT L/H TRANSITION HAS MULTIPLE AREAS OF CORROSION FROM STA 500C TO 500I. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53-1A-2 REPAIRED OUT OF LIMITS SECTION OF SIDE PLATE IAW SRM 53-00-53-2R-6 AND RESTORED FINISH TO IN LIMITS SDR ASAA2025082660601Attach Angle · corrodedAFT PIT RH FWD SHIELD LOWER ATTACH ANGLE IS CORRODED. GROUNDED - YES. REMOVED AND REPLACED ATTACHED ANGLE IAW BOEING 737-800 SRM 51-40-02-OG-OW:.500 O:.050 R:.041 L:.750 D:.009.SDR ASAA2025082660600Shield · corrodedAFT PIT RBL 22 RH FWD SHIELD IS CORRODED. GROUNDED - YES. REMOVED AND REPLACED SHIELD IAW BOEING 737-800 SRM 51-40-02-OG-OW:.800 O:.050 R:.015 L:1.2 D:.035.SDR IPXA2025090663534Bracket · crackedAFT CARGO COMPARTMENT WEB AT FR54, Y0, CRACKED. JP-110. INSTALLED NEW BRACKET IN STR-ZONE 150- AFT CARGO COMPARTMENT WEB AT FR54, Y0, I.A.W. SRM 51-40-21 WITH SEALANT,SDR IPXA2025090663530Bracket · crackedAFT CARGO WEB AT FR54, Y1959, CRACKED. JP-110. INSTALLED NEW BRACKET IN STR-ZONE 150-AFT CARGO WEB AT FR54, Y1959, I.A.W. A300-600 SRM 51-40-21 WITH SEALANT.SDR IPXA2025090657922Skin · corrodedLEFT WING TIP UPPER SURFACE BONDING STRIP AFT END CORRODED. DOT NO. 17-35. INSTALLED 1 EA FILLER 1 EA DOUBLER 1 MOUNTING STATIC DISCHARGE IAW SRM 51-40-21.SDR R61A2025090800384Skin · dentedDENT DUE TO BIRD STRIKE ON LH FWD FUSELAGE AT FRA 9 BETWEEN STR 12L TO 13L. REMOVED AND REPLACED SHEAR CLIP AT FRA 9 IAW EMB 170/175 SRM 51-41-01 AND 51-41-02 AND REPAIRED DENT ON SKIN IAW EMB ETD2025-170-927483. REF VP-036808-2025 N/R 6,40 FOR WORK ACCOMPLISHSDR R61A2025090800383Shear Tie · bentBIRD STRIKE LH FWD FUSELAGE BETWEEN FRA 1 TO FRA 6 AND STR 6L TO 19L WITH 5EA BENT SHEAR CLIPS.REMOVED AND REPLACED SHEAR CLIPS IAW EMB 170/175 SRM 51-41-01 AND51-41-02 . REF VP-036808-2025 N/R 11,23,24,26,50 FOR WORK ACCOMPLISHED.SDR R61A2025090800382Shear Tie · bentBIRD STRIKE ON FWD FUSELAGE BETWEEN FRA 3 AND 4 AND STR 4R TO 8R 3 EA BENT SHEAR CLIPS. REMOVED AND REPLACED 3 EA SHEAR CLIPS IAW EMB 170/175 SRM 51-41-01 AND 51-41-02 .REF VP-036808-2025 N/R 42,43 AND 44 FOR WORK ACCOMPLISHED.SDR ASAA2025082660581Shield · corrodedSHIELD PANEL AFT OF FWD PIT DOOR CUTOUT IS CORRODED. GROUNDED - YES. REMOVED CORROSION ON SHIELD PANEL IN FWD CARGO STA 500-500A R/H AND FOUND TO BE OUT OF LIMITS IAW B737-800 SRM 53-30-15-1A-1 AND REMOVED AND REPLACED SHIELD PANEL IAW SRM 51-40-02-0-0GW= 2" SDR SCNA20250905362Window Frame · crackedL1 WINDOW FRAME CRACK - PERMANENT REPAIR - LH - - C/W BY ATS 80761C ACCOMPLISHED SB 737-53-1336 REV 1 DATED OCT 23, 2014SDR SWAA2025090508443Floor Panel · peelingMAIN CABIN FLOOR PANEL 231ZF HAS PEELING STRANDS. NEW FLOOR PANEL INSTALLED ON TTG8Q014T1H8.SDR J7SA2025090500457Control Cable · low tensionDURING SCHEDULED MAINTENANCE WHILE RE-TENSIONING AILERON CABLE, DISCOVERED LH WING CABLE SAWING THROUGH PULLEY BRACKET. REPLACED LH AILERON WING PULLEY BRACKET IAW CL300 SRM 51-40-08 AND 51-42-36. LH WING AILERON CABLE REPLACED AND TENSIONED IAW AMM 27-11-35-0SDR CALA2025090508500Floorbeam · corrodedAFT WET AREA, FLOORBEAM STA.986 RBL 41 FOUND CORRODED ON PREVIOUS REPAIR. REMOVED AND REPLACED DAMAGE PREVIOUS REPAIR IAW EC/RA 5321-01491.SDR CALA2025090508499Floor Support · crackedFORWARD PASSENGER CABIN FLOOR SUPPORT CRACKED AT FASTENER HOLES, BS 312 - 328, RBL 31. REMOVED AND REPLACED FORWARD CABIN FLOOR SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 141A5400.SDR ASAA2025082660553Floor Support · corrodedAFT CARGO COMPARTMENT LONGITUDINAL FLOOR SUPPORT ASSEMBLY B/N STA 727I AND 847, S-25L & S-26L HAS MULTIPLE CORROSION SPOTS. GROUNDED - YES. DAMAGE FOUND TO BE CORRODED THROUGH WITH 100 PERCENT MATERIAL LOSS. FOUND TO BE OUT OF LIMITS IAW B737-900 SRM 53-60-53-