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 QR9R2025112000002Pressure Switch · displayedFUEL PRESSURE CAUTION MESSAGE DISPLAYED ENG 1 ON CAD AFTER .7 OF FLIGHT TIME. PRIME PUMP WAS PLACED ON AND MESSAGE REMAINED. PRIME WAS THEN TURNED OFF AND MESSAGE DISAPPEARED AFTER APPROXIMATELY 12 MORE MINUTES OF FLIGHT. REMOVED AND REPLACED #1 ENGINE FUEL PRSDR JR2R20251120567Gusset · corrodedAFT WET AREA, GUSSET AT FR90 BL0 IS CORRODED. REPLACED.SDR QR9R2025112000001Drain Valve · leakingSMOKE COMING OUT OF #2 ENGINE COMPARTMENT DURING POSTFLIGHT. #2 ENGINE START DRAIN VALVE WAS FOUND TO BE LEAKING EXCESSIVELY AT DRAIN AND THREE WAY UNION AND DRIPPING ONTO HOT SECTION CAUSING SMOKE. REMOVED AND REPLACED #2 ENGINE DRAIN VALVE.SDR DXTA2025112005773Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACK, NOT HOLDING CHARGE PERFORMED QRH CHARGE PROCEDURE TWICE CORRECTIVE ACTION: REMOVED LT AFT EMERGENCY BATTERY DUE TO NOT HOLDING CHARGE AND INSTALLED NEW EMERGENCY BATTERY. REMOVED RT AFT EMERGENCY BATTERY. DUE TO NOT HOLDING CHASDR DALA2025112008489Stringer · damagedFOUND HOLE IN STRINGER 3 RT AT FRAME 61. REPAIRED PER ERA 630262-14 REV. ORIG. (1312922)SDR 2025FA0000773Belt · shearedPER PILOT REPORT: UPON IMMEDIATELY DEPARTING THE AIRFIELD, THE TWO CREW MEMBERS IN THE REAR OF THE AIRCRAFT STATED THAT THEY SMELLED SOME KIND OF SMOKE. UPON HEARING THE AFOREMENTIONED INFORMATION, I IMMEDIATELY EXECUTED A 180 DEGREE TURN TOWARD THE LANDING ARSDR AALA202511206347Plate · looseAIRCRAFT WAS GROUNDED: RIGHT HAND AFT EMERGENCY EXIT DOOR 844 ARM / DISARM HANDLE GRIP PLATE IS LOOSE. TIGHTENED ARM / DISARM HANDLE GRIP PLATE PER AMM 52-22-00.SDR AALA202511201566Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202511202795Guide Fitting · looseAIRCRAFT WAS GROUNDED: RIGHT HAND FORWARD EMERGENCY EXIT DOOR 843 AFT DOOR FRAME LOWER GUIDE FITTING UPPER BOLT AND NUT LOOSE. MAINTENANCE TIGHTENED GUIDE FITTING BOLT AND NUT PER AMM 52-22-00.SDR DALA2025112008487Angle · corrodedFWD CARGO RT TRANSITION ANGLE HAS CORROSION FROM STA 500B TO STA 500L. REMOVED AND REPLACED R/H TRANSITION ANGLE FROM STA 500B TO STA 500L AS PER REF B737-900 SRM 53-00-53.SDR DALA2025112008486Heater · odorF/A REPORTED BURNING SMELL IN AFT GALLEY. REMOVED AFT DOOR AREA HEATER REF AMM 21-45. SMELL WENT AWAY FOUND DISCOLORATION IN THE HEATING ELEMENTS. INSTALLED AFT DOOR HEATER PER B737 AMM 221-45. OPS GOOD.SDR JR2R20251120556Seat Track · corrodedFWD WET AREA SEAT TRACK BEAM AT FR17 RBL10 IS CORRODED. REPAIRED PER SRM.SDR JR2R20251120558Floorbeam · corrodedFWD WET AREA LBL10 FLOORBEAM AT FR18 IS CORRODED. REPAIRED PER SRM.SDR JR2R20251120577Repair · corrodedAFT WET AREA, EXISTING REPAIR DOUBLER ON FLOORBEAM AT FR87 LBL10 IS CORRODED. REPAIRED PER SRM.SDR JGVR20251120001Fitting · corrodedTHE NOSE LANDING GEAR ACTUATOR FITTING WAS FOUND CORRODED BEYOND REPAIR. CUT FUSELAGE STRUCTURE FOR ACCESS, REMOVED THE CORRODED FITTING AND INSTALLED NEW FITTING P/N 7411213-5 AND REPAIRED FUSELAGE STRUCTURE PER TEXTRON STANDARD REPAIR.SDR JR2R20251120283Skin · corrodedFWD CARGO DOOR ENTRY LOWER SURFACE HAS MULTIPLE AREAS OF CORROSION ON SKIN. REPAIRED PER ETD.SDR JR2R20251120336Support · chafedRH MAIN LANDING GEAR I/B FLAP CARRIAGE SUPPORT ASSY/SPAR L/E HAS CHAFE DAMAGE. REPAIRED PER ETD.SDR JR2R20251120429Profile · gougedFORWARD AVIONICS ACCESS HATCH HAS GOUGES ON AFT EDGE. REPAIRED PER ETD.SDR JR2R20251120419Spar · damagedLEFT WINGTIP, FRONT SPAR FITTING CRACKED & SCRATCHED AT OTBD LOWER BOLT HOLE TO CABLE FEED THROUGH HOLE. REPAIRED PER ETD.SDR JR2R20251120288Skin · gougedL2 DOOR OUTER SKIN LOWER AFT CORNER HAS DEEP GOUGES AND SCRATCHES. REPAIRED PER ETD.SDR QEMY20251120001Seal · failedSEAL-ROTATING AIR HPT FRONT (FOS) THE SUBJECT FOS HAS FAILED FPI FOR CRACKS ON DIM E SEAL TEETH. FPI INDICATION "1 OFF CRACK 0.06" IN LENGTH GOING OVER INNER SEAL TEETH. 3 OTHER INDICATIONS ALSO OBSERVED; 0.04", 0.025", 0.015".
DR 02298827 WAS REJECTED BY TSDR SWIA2025111975726Skin · dentedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA84579-REO 601R-53-11-3871. COMPLY WITH PERMANENT REPAIR ON RA ID: 845792+ CM DENT RIGHT SIDE NOSE, ADJACENT TO N/W DOOR. PERMANENT REPAIR IS DUE WITHIN 5650 FLIGHT HOURS FOR THE DENT DAMAGE TO FUSELAGE SKIN BETWEEN FSSDR IXXA03142026CC01Frame · corrodedRH AFT WING TO BODY FAIRING ATTACH FRAME AT STA 1220 IS CORRODED.SDR IXXA20262026003Door · gougedLEFT MLG DOOR GOUGED.SDR SWIA2026021375269Door Frame · crackedRIGHT TRU DOOR LOWER SILL HAS POSSIBLE CRACKS AT FWD AND AFT LATCH CUTOUTS. RT TRU DOOR LOWER SILL REPLACED AND INSTALLED IAW REO 670-53-11-2233 REV -A DATED 2025-12-22. ALL STEPS COMPLIED WITH ON THE REO, COMPLIED WITH 51-900-1002-SKY. SEE CONTINUATION CARD SDR SWIA2026021375268Skin · gougedFOUND GOUGING & CORROSION ON FWD CARGO SURROUND STRUCTURE INNER CLOSING SKIN EDGE BETWEEN BS 533 AND 581. REPAIRED FWD CARGO SURROUND STRUCTURE INNER CLOSING SKIN IAW REO 670-53-31-1141 REV-. COMPLIED WITH ALL STEPS OF REO 670-53-31-1141 REV-. COMPLIED WITH SDR SWIA2025111975246Door Sill · gougedFOUND GOUGED & CORRODED ON FWD CARGO SURROUND STRUCTURE S25L BETWEEN BS 533 - 581. REMOVED DAMAGE ON S25L (DOOR SILL) APPROX. BS 533 AND 581 IAW SRM 51-12-00-001-001-A01, COMPLIED WITH REO 670-53-31-1141 REV -. STEPS 1-3 AND, STEPS 8-10, STEPS 4-7. NOT APPLSDR SWIA2026020975225Frame · chafedRIGHT ACM WATER INJECTOR LINE HAS CHAFED INTO FRAME BS 1144 AT STR 11R. REPAIRED THE FRAME AT BS 1144, STR 11R IAW REO 670-53-61-2636 REV--.SDR SWIA2026020270111Floorbeam · corrodedFWD CABIN- UNDER FLOOR FRAME FS 333.00 HAS CORROSION BETWEEN STRG 23L TO 23R. REMOVED AND REPLACED FWD CABIN- UNDER FLOOR FRAME FS 333.00 BETWEEN STRG 18LH TO 23RH IAW SRM 51-42-06, SRM 51-42-21.SDR 2026FA0000022Stabilizer · crackedREFENCES ARE MADE TO SDR UNIQUE CONTROL #2026FA0000017, #2026FA0000018 AND #2026FA0000020 RAISED PREVIOUSLY. #2026FA0000017 - ERRORS WERE MADE WHEN ENTERING THE AIRCRAFT SERIAL NUMBER (9Y-TKB) THIS SHOULD READ "41395" AS CORRECTED, #2026FA0000018 - DIFFICULTY SDR 2026FA0000017Stabilizer · crackedDURING A VISUAL INSPECTION OF 9Y-TKB AFTER FLIGHT THE LINE SUPERVISORS DISCOVERED THE CRACK ON THE TAILPLANE ASSEMBLY LEFT LEADING EDGE LOWER PANEL. LOCATION OF CRACK IS ESTIMATED TO BE STA 12370 AND BL (-940 THRU -718). A LOGBOOK ENTRY (LBE 206/25) WAS RAISESDR SWAA2025123036983Skin · corrodedCORROSION ON FUSELAGE LOWER INTERNAL BLIGE SKIN COMMON TO EXTERNAL DOUBLER INSTALLED AS PER REPAIR-53EO-00182 BS747 TO BS767 BL-0 WL149. REPAIRED IAW EA 25-153-03257 WITH AN INSPECTION THRESHOLD DEFINED IN 25-153-03257-DTI.SDR SWAA2025123036980Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS 767+3 - 794, RBL 22, WL 156. REMOVED AND REPLACED ACB FWD SHIELD IAW SRM 51-40-02-0G-0, & DWG 146A0081 REV -.SDR SWAA2025123036981Support Plate · corrodedCORROSION AFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE HAD MULTIPLE AREAS AROUND NUT PLATE HOLES, BS 727B - 767, LBL 22, WL 156. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT PLATE IAW SRM 51-40-02, DWG 146A7500, REV-.SDR SWAA2025123036982Support Plate · corrodedCORROSION AFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT PLATE HAD MULTIPLE AREAS AROUND NUT PLATE HOLES BS 727B - 767, RBL 22, WL 156. REMOVED AND REPLACED THE FLOOR TO SIDEWALL SUPPORT PLATE IAW SRM 51-40-05, DWG 146A7500, REV-.SDR SWAA2025123036979Attach Angle · corrodedCORROSION AFT CARGO BAY ATTACH ANGLE UNDER SHIELD HAS MULTIPLE AREAS UNDER NUT PLATES BS 767 TO 787, RBL 21, WL 156. EVALUATED, LOCATED, DRILLED, REMOVED, AND REPLACED THE ATTACH ANGLE UNDER SHIELD IAW SRM 51-40-05-0G-0, SRM 51-40-02-0G-0, AND DWG 146A8123 RSDR SWAA2025122936853Pressure Deck · crackedCRACK FOUND ON HORIZONTAL PRESSURE DECK WEB AT BS 663+2 LBL 31. .20' L. REMOVED DAMAGE PART OF THE HORIZONTAL PRESSURE DECK BSB663-BS674 LBL30-LBL60 WL 202 AND REPAIRED IAW SRM 53-40-51-2R-2, REPAIR 2. TASK COMPLETED.SDR SWAA2025121936995Floor Panel · delaminatedDELAMINATED FLOOR PANEL 242UF IN THE AFT GALLEY AREA. REPAIRED THE FLOOR PANEL 242UF IAW SRM 53-00-50-2R-1, REPAIR 1.SDR SWAA2025121736964Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727A, S3R. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02 & DWG 146A1101, REV: E.SDR SWAA2025121736965Stringer Clip · crackedCRACKED STRINGER CLIP, BS 706, S2L. REMOVED AND REPLACED WITH A NEW STRINGER CLIP IAW SRM 51-40-02 & DWG 144A1107. REV B.SDR SWIA2025121700119Support Bracket · crackedFORWARD PRESSURE BULKHEAD, LOWER RADAR SUPPORT BRACKET RT ANGLE IS CRACKED.SDR SWI2025F01826Skin · damagedLIGHTNING STRIKE DAMAGE UPPER FUSELAGE ON SKIN BETWEEN FRAMES 20-21 AND STRINGERS 1 - 2L. DAMAGE IS 0.067, NOMINAL=0.040, DAMAGE IS 0.375" FROM FRAME 20, DRILLED A # 40 HOLE AND INSTALLED FASTENER REF ETD 2025-170-932740.SDR SWAA2025121636996Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT 2 NOSE SKIN AT ACTUATOR LOCATION, AROUND FASTENER AT LT WING. REPAIRED SLAT 2 LOWER SURFACE OF LEADING EDGE NOSE SKIN IAW SRM 57-42-01-2R-8, REPAIR 8, FIGURE 202, ALTERNATIVE 1, SHEET 2.SDR SIMA20251119001Seal · chafedFUSELAGE CUTOUT AT FWD PASSENGER DOOR AFT SILL HAS 4 DEEP CHAFES. (MAJOR REPAIR) RAR FWD PAX DOOR CUT OUT AFT SILL IAW ERJ 170 SRM 51-40-08.SDR AALA202512159520Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202512151686Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202512158150Light · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR SWAA2025120836545Wire · detachedFWD ENTRY DOOR BS 303, S17L WIRE NOT PINNED TO GROUND BLOCK. REPAIRED THE WIRE W4142-0152-20 AND TERMINATED ON GD3752 IAW WDM 33-51-21 AND SWPM 20-90-15.SDR JJBA20251208020Floorbeam · corrodedCENTER FUSE I, CENTER CROSSBEAM AT FRAME 20, LOWER AND UPPER SURFACE CORRODED. CENTER FUSE I CENTER CROSSBEAM AT FR20 BLENDED OUT OF LIMITS. CENTER FUSE I, CENTER CROSSBEAM AT FRAME 20 MADE REPAIR PART FABRICATED. CENTER FUSE I, CENTER CROSSBEAM AT FRAME 20 MASDR SWAA2025120336818Glowstrip · damagedCABIN PHOTOLUM, SHIP SET FOUND DAMAGED REQUIRE REPLACEMENT. INSTALLED PHOTOLUMINESCENT STRIPS EXCEPT SEGMENTS AP AND AN PER SWA DWG 33500007 REV 2, AND AMM 33-51-15-400-802.