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 CALA2025120911932Battery Pack · no testCABIN EMERGENCY LIGHTING TEST FAILED, FAULTING EPSU BATTERY FWD L AND EPSU BATTERY AFT L PERFORMED EPSU OPS TEST FOR EPSU FWD L (10WL) AND AFT L (13WL), REF TSM 33-51-00-810-802-A. BATT FAULT RED LIGHT ON BOTH EPSUS. EPSU BATTERIES NIS AT ORD. ALLOWED EMERGENSDR CALA2025120911930Packing · leakingENGINE HAS EXPERIENCED AN INCREASE IN OIL CONSUMPTION. ACCOMPLISHED A SNIFF CHECK OF OIL FOR FUEL ODOR IN THE OIL SYS, IAW AMM 12-13-01-130-803-002, STEP F.(1). ACCOMPLISH FIM 71-05/805 TO TROUBLESHOOT FOR HOC. PERFORM TEST NR 6. POWER LEAK CHECK WITH ALL DSDR DALA2025120908968Light · detachedSEAT 16D FLOOR LIGHTING DETACHED FROM SEAT. RE-ATTACHED TRIM PER A319 AMM 33-52. A/C OK FOR SVC. (7935918).SDR DALA2025120908966Access Panel · crackedCRACK ACCESS PANEL 413DL ON LT PYLON. REPAIRED PER ER/A 540187-14. (1342068)SDR SCNA20251209469Elec Connector · brokenFOUND BROKEN CONNECTOR ON RT FWD EMERGENCY EXIT FWD HATCH HEATER. OPENSDR SCNA20251209468Light · unsecureROW 1A AND 13 ABC EMERGENCY EXIT PATH STRIP COMMING UP. SECURED THE LIGHT STRIP ON EXIT PATH LIGHT IAW AMM 33-14-00.SDR 2025FA0000802Seat Track · corrodedCORROSION FOUND ON WEB LOCATION Y2462 AT FR17. SEAT TRACK REPLACED.SDR J4YR202512084112Control Arm · brokenPILOT NOTICED THAT THE RUDDER TRIM SYSTEM WAS UNRESPONSIVE WHEN RUDDER TRIM ADJUSTMENT WAS MADE. UPON CLOSER EXAMINATION THE ARM THAT CONNECTS TO THE RUDDER TRIM ACTUATOR ON THE RUDDER CONTROL ARM ASSY (PN 63457-003) HAD SEPARATED FROM THE TUBE ADJACENT TO THESDR SWAA2025120843829Unknown · odorDURING PACK OPERATION WITH BLEED AIR SUPPLED BY APU, OBSERVED A FAINT BURNING RUBBER ODOR. PERFORMED CONDITIONAL INSPECTION IAW AMM 05-51-56, COULD NOT DUPLICATE ODOR IAW IFIM 21-00-00-810-830.SDR DALA2025120808950Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR75, YO. REPLACED SEAT TRACK PER ERA 630774-14 REV ORIGINAL. (1340913)SDR DALA2025120808949Fitting · crackedCRACK APPROX. 12MM IN LENGTH AT THE AFT DIRECTION OF THE FASTENER HOLE 555 TO THE AFT END EDGE OF THE KEEL BEAM FITTING. COMPLIED WITH ER/A 630620-14 REV ORIGINAL. (1341215)SDR DALA2025120808948Beam · misrepairedONE OVERSIZE COUNTERSINK AT FR64 BEAM 4 HOLE 5. ACCOMPLISHED COUNTERSUNK FREEZE PLUG REPAIR AT FR64 BEAM 4 HOLE 5 IN SKIN LAYER AS PER ER/A 630635-14 REV ORIGINAL. (1340949)SDR DALA2025120808947Skin · damagedAFT CARGO DOOR INNER SKIN BETWEEN FR63 AND FR63A DAMAGE ON EXISTING REPAIR. COMPLIED WITH ER/A 630743-14 REV ORIGINAL SECTION I. (1340940)SDR DALA2025120808946Skin · damagedAFT CARGO DOOR INNER SKIN BETWEEN FR61 AND FR61A EXISTING REPAIR DAMAGED. COMPLIED WITH ERA 630743-14 REV ORIGINAL. (1340932)SDR DALA2025120808932Sign · brokenCENTER LIGHTED OVERWING EXIT SIGN BROKEN. REPLACED THE SIGN, CKD GOOD. IAW AMM 33-51.SDR DALA2025120808930Battery Pack · inoperativeEMER CABIN LIGHTS INOPERATIVE. R & R FWD RIGHT, FWD LEFT, AND AFT RIGHT BATTERY PACKS PER B737 AMM 33-51.SDR BAGA2025120800003Battery Pack · failedEMERGENCY BATTERY FAULT MESSAGE, LT MID ELPU FAILED. REMOVED AND REPLACED LT MID ELPU.SDR 62MA2025120800797Autopilot Sys · false activationAFTER TAKEOFF MASTER WARNING COME ON, PRIMARY TRIM FAILED. NOTED FLIGHT DIRECTOR WENT DOWN (INDICATOR ERRATIC). ACCOMPLISHED RE RACK OF THE AUTO PILOT COMPUTERS OPS CHECK SUCCESSFUL AFTER THE MX ACTION PER. AMM 22-10-02SDR UIEA2025120801337Oxygen Bottle · inoperativePORTABLE BOTTLE L1 DOOR INOP. REMOVED AND REPLACED PORTABLE O2 BOTTLE ASSY & OPS CHECK OK IAW AMM 35-31-00-960-801 & IPC 35-31-51-10A.SDR BAGA2025120800002Slide · unwanted deployL2 DOOR EMERGENCY SLIDE DEPLOYED INADVERTENTLY, REMOVED AND REPLACED L2 DOOR EMERGENCY SLIDE.SDR DALA2025120808924Filter · dirtyAPPROXIMATELY 30 SECONDS AFTER CLEARING THE RUNWAY, SMOKE AND HAZE ENTERED THE COCKPIT. SMOKE WAS REPORTED BY THE FAS IN THE CABIN (FAS SAY IT WAS MOSTLY REAR CABIN.) PILOTS USED OXYGEN MASKS. SMOKE DISAPETED W/IN 2 MIN. INSPECTED ENGS FOUND EXCESSIVE SAND ANSDR 2025FA0000796Tip Cap · erodedRIGHT HORIZONTAL STAB TIP HAS PAINT EROSION.SDR 2025FA0000795Spar Cap · corrodedLEFT MLG WHEEL WELL AFT LOWER SPAR CAP HAS CORROSION.SDR SWIA2025120776453Cleat · corrodedEXFOLIATED CORROED CLEAT BS 319, S21R. CORROSION OVER 50% OF THICKNESS, LIMIT ALLOW. DAMAGE 10% OF CLEAT BS 319, S21R. OUT OF LIMITS IAW SRM 53-21-23-101-002-A02. REQ. REPLACEMENT.INSTALLED NEW CLEAT BS 319, S21R, IAW. SRM 51-42-06-001-001-A01, SRM 51-42-21-0SDR SWIA2025120775765Strap · corrodedFS559.00 RBL 27 - RBL 42, THE STRAP THAT CROSSES THE FLOOR BEAMS IS CORRODED. REPLACED BS 559, RBL 27 - RBL 42, THE STRAP THAT CROSSES THE FLOORBEAMS PER REO 601R-53-41-3393 REV-. AND SRM 51-42-06.COMPLIED WITH SKYWEST TASK CARD 51-900-1003-SKY.SDR SWIA2025120775764Pressure Deck · corrodedFS449.00 - 559.00 LH PRESSURE FLOOR SILL PANEL HAS NUMEROUS AREAS OF CORROSION. REPAIRED CORROSION DAMAGE TO LT PRESSURE FLOOR SILL PANEL FS449-FS559 REF. REO 601R-53-41-3379 REV -, STEPS 1-6, ALL STEPS COMPLIED WITH. COMPLETED ATTACHED TASK CARD 51-900-1003-SDR SWIA2025120775760Attach Angle · crackedFS484.00 RBL 27-36, THE FLT CONTROL CABLE GUIDE ROLLER ASSY, THE AFT OUTBD VERTICAL ATTACH ANGLE IS CRACKED IN THE UPPER RADIUS. PERFORMED REPAIR FOR CRACKED ANGLE AND DAMAGED INTERCOSTAL AT FS484.00 AND RBL36.00 IAW ALL STEPS OF MHIRJ REO 601R-53-41-3391 REVSDR SWIA2025120775750Attach Angle · crackedBS 484, LBL 27-36, THE FLT CONTROL CABLE GUIDE ROLLER ASSY, THE AFT INBD VERTICAL ATTACH ANGLE IS CRACKED IN THE UPPER RADIUS. REMOVED AND REPLACED WITH NEW ATTACH ANGLE, THE CONTROL CABLE GUIDE ROLLER ASSY. IAW SRM 51-42-21, AND DWG 601R31171, REV. B, AND LSDR SWIA2025120775744Floor Support · corrodedBS 424 - 559 RT PRESSURE FLOOR SILL PANEL HAS NUMEROUS AREAS OF CORROSION. REMOVED CORROSION ON RT PRESSURED FLOOR SUPPORT PANEL BETWEEN BS 424 - 559 AND REPAIRED PER REO 601R-53-41-666, REV-C, ALL STEPS COMPLIED WITH. COMPLIED WITH SKYWEST TASK CARD 51-9SDR SWIA2025120775738Strap · corrodedBS 559, LBL 27 - LBL 42, THE STRAP THAT CROSSES THE FLOOR BEAMS IS CORRODED. REMOVED AND INSTALLED NEW STRAP WITH SRM 51-42-06-00. COMPLIED WITH SKYWEST TASK CARD 51-900-1003-SKY.SDR DALA2026030201407Unknown · odorFUMES NOTED AFTER ROTATION AND DURING CLIMB. STRONG METALLIC TASTE AND BURNING SENSATION IN EYES NOTED. ACRID ODOR NOTED ALSO. BOTH ENGINES REPLACED. REF LOG #'S 1337408, 1337407, AND 133904 FOR CORRECTIVE ACTION. (LP# 7670644)SDR DALA2026012700605Hinge Fitting · corrodedCORROSION ON HARWARE AND AROUND OF BORE IN OTBD HINGE. LT WING FLAP. THE OTBD FLAP HINGE WAS REPLACED IAW AMM 57-55-25. (1340373)SDR VNAA20260125011Skin · dentedSEVERAL DENTS BTW THE 4 O'CLOCK TO 7 O'CLOCK ON THE LOWER EXTERNAL SKIN OF FAN COWL DOOR AND INLET COWL AT LT ENGINE. SKIN SKIN ON THE LEFT INLET COWL WAS REPAIRED IAW REO 690-54-11-592 REV - MUST BE ATTENDED ON NRC00267.SDR SWAA2026011543632Seal · crackedRIGHT HORIZONTAL STAB UPPER SLIDE SEAL AT FRONT SPAR LUG IS CRACKED.SDR 3EJA202601150001Engine · failedAT APPROX 400 FEET WE HAD A LEFT ENGINE EXCEEDANCE WITH RED CAS MESSAGE, AND THE ENGINE WENT TO IDLE. ENGINE REMOVED FOR REPAIRSDR AALA202601153526Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 951, AT LBL 24. REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA202601154499Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE FITTING AROUND LAVATORY MOUNT LOCATED AT BS 947, LBL 24 . REPAIRED UPPER TEE FITTING PER SRM 53-70-51-2R-5.SDR AALA202601153494Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT BETWEEN BS 947 AND BS 967, AT RBL 51. REPLACED FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA202601159120Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 951, RBL 49. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202601150480Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT PASSENGER CABIN LAVATORY FLOOR SUPPORT AT BS 951, RBL 20. REPLACED SUPPORT PER SRM 51-40-02.SDR SWAA2026011447666Lug · crackedRIGHT HORIZONTAL STAB UPPER SLIDE SEAL AT FRONT SPAR LUG IS CRACKED. CLOSED ACCESS PANEL 341A IAW AMM 20-50-11-910-801. REMOVED AND REPLACED THE RT HORIZONTAL STAB UPPER SLIDE SEAL AND REMOVED AND REINSTALLED ACCESS PANEL 341A IAW AMM 53-31-31-400-802 AND SDR AALA202601147420Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT SUPPORT INTERCOSTAL BETWEEN BS 947 AND BS 967, AT LBL 51. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA202601148738Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 986.5, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR SWAA2026011243640Support Angle · crackedCRACKED SUPPORT ANGLE, BS 663.5, LBL 41, REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-10-02, PARAGRAPH 9, SRM 51-40-02, DWG 111A1322, SHEET 5, REV-, AND DWG 111A1000, SHEET 202, REV -.SDR SWAA2026011243639Access Panel · crackedCRACKED LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 114.55 AT LT HORIZONTAL STAB. REPLACED LEADING EDGE RIB ACCESS PANEL 331B LOCATED LE STA 114.55 AT LT HORIZONTAL STAB AND FASTENERS IAW SRM 51-10-02-0G ITEM 9, SRM 51-40-02-0G, AND DWG 186A1001, SHEETSDR SWAA2026010943624Support Bracket · crackedCRACK ON SUPPORT BRACKET PNEUMATIC DUCT LOCATED BS 540, LBL 6 IN THE AIR CONDITIONING BAY.SDR SWAA2026010543643Floor Panel · crackedCRACK FLOOR PANEL 140CF AT AFT CARGO COMPARTMENT. FABRICATED AND REPLACED PANEL 140CF AT AFT CARGO COMPARTMENT IAW AMM 25-52-10-400-801, DRAWING 453A2610, SHEET 9 & REV E, AND EA M-22-125-02598.SDR SWAA2026010543713Skin · crackedCRACK LOWER SURFACE OF LEADING EDGE SLAT 8 NOSE SKIN AT ACTUATOR LOC. AROUND FASTENER AT RT WING. PERFORMED PERMANENT REPAIR LOCATED ON LOWER SURFACE OF LEADING EDGE SLAT 8 NOSE SKIN IAW SRM 57-42-01-2R-8 REPAIR 8.SDR SIMA20251207001Seal Depressor · gougedFORWARD PASSENGER DOOR SEAL DEPRESSOR HAS GOUGES IN 4 LOCATIONS ON AFT SECTION. (MAJOR REPAIR) RAR FORWARD PASSENGER DOOR SEAL DEPRESSOR IAW ERJ 175 SRM 51-40-08SDR CALA2026010212590Floorbeam · corrodedMAIN CABIN AFT WET AREA BS 967 FLOORBEAM CORRODED ON UPPER SURFACE AROUND FASTENER HOLE AT RBL 45. REMOVED CORROSION AT BS 967 FLOORBEAM ORIGINAL THICKNESS 0.125" MATERIAL LIMIT 0.107" REMOVED .058" MATERIAL .067" REMAINING MATERIAL WAS FOUND OUT OF LIMITS IA