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 SWIA2025121877089Skin · corrodedPAINT DAMAGE WITH SIGNS OF CORROSION FOUND ON BELLY AT BS 559+80 - 574, STR 24L - 24R. REMOVED CORROSION ON BELLY SKIN AT BS 559+80 - 574, STR 24L-24R IAW SRM 51-21-06. DAMAGE FOUND TO BE WITHIN ALLOWABLE LIMITS IAW REO 601R-53-00-930 REV--. REMOVED AND REPSDR CALA2026090119148Repair · undocumentedDURING AGING AIRCRAFT INSPECTION FOUND EXISTING EXTERNAL FUSELAGE REPAIR AT APPROX BS 375-390, STR 19R-21R. UNABLE TO FIND ANY DOCUMENTATION OF REPAIR INSTALLATION OR ASSOCIATED DIPS FOR CAT B REPAIR INSPECTION. ACCOMPLISHED SKIN REPAIR AT RT SIDE BS 360-400,SDR SWIA2025121876170Skin · damagedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA88272-REO 670-53-00-045-PR1 - COMPLY WITH PERMANENT REPAIR ON RA ID: 88272FUSELAGE SKIN LIGHTNING STRIKE DAMAGE. REF REO 670-53-00-045. COMPLY WITH PERMANENT REPAIR FOR REO 670-53-00-045 REV -K DATED 1/15/2021 PART 2 LSDR SWIA2025121876142Skin · damagedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA89829-SRM 53-00-00-201-003-A01 TYPE 3-PR1 - COMPLY WITH PERMANENT REPAIR ON RA ID: 89829FOUND LIGHTNING STRIKE DAMAGE TO FUSELAGE SKIN ON THE RH SIDE AROUND A FASTENER AT FS 311.5 WL 57 GREATER THAN 0.005" DEEP. REPAISDR SWIA2025121876141Fastener · damagedLIGHTNING STRIKE PITTING DAMAGE TO A FASTENER ON RT OF BS 383 WL 59 GREATER THAN 20% OF RIVET HEAD SPECIFICED BY SRM. UPON CLEANING FOUND DAMAGE TO COUNTER SINK AREA DEEPER THAT 0.005 IN. REPAIRED DAMAGE TO FASTENER AREA ON RT SIDE OF FUSELAGE AT FS 383 WL 59 SDR SWIA2025121875899Bulkhead Web · corrodedSIGNS OF CORROSION BETWEEN THE LT 280 WEB AND THE POST AT LBL 12. R & R BULKHEAD LOWER WEB IAW AMM 20-70-00, SRM 53-00-00, 51-42-06, 51-42-13, 51-42-21, 53-11-10, 51-21-11, 51-25-06, & 51-42-24.SDR SWIA2025121875730Frame · crackedDURING AUDIT OF RA 44367, BS 333 UPPER FRAME IS CRACKED BTWN STR 0 - 2L. REPAIRED IAW REO 601R-53-21-3018, REV--, IT WAS FOUND THAT THE SHIMS FOR THE REPAIR ARE THE WRONG DIMENSIONS AND ARE INSTALLED INCORRECTLY. INSTALLED NEW SHIM FABRICATED (ITEM -2) PER SDR IXXA04022026CC01Fitting · deformedREMOVED FOR ACCESS THE RW SIDE LINK ATTACH FITTING "MICKEY MOUSE FITTING" FOR SIDE LOAD FITTING ALIGHNMENT. DURING REMOVAL FOUND DAMAGED FREEZE PLUG/BUSHING IN HOLE.SDR SWIA202602274765Floor Support · corrodedCOMPLY WITH REO 670-53-11-745 DATED: 2016-10-28 REV: A GENERIC REPAIR FOR NOSE FUSELAGE CENTER FLOOR ANGLE REPLACEMENT AND DOOR POST AT FS 28.00 ( LBL 11.128 AND RBL 11.128) DUE TO CORROSION FOUND ON THE DOOR POST. (C-CHECK RO 02/25/2026)COMPLIED WITH REO 670SDR JJBA20260130063Support · corrodedCORROSION ON THE LH SILL AT FRAME 29. REMOVED AND INSTALLED NEW SILL ON THE LH AT FRAME 29SDR JJBA20260130062Floor Support · corrodedCORROSION ON THE RH SILL FRAME 29-35. INSTALLED NEW RH FLOOR SILL AT FR 29-35SDR JJBA20260130049Gusset · corrodedCORROSION ON GUSSET AFT OF SERVICE DOOR AT FR 22. REMOVED CORROSION ON GUSSET AFT OF SERVICE DOOR AT FR 22 AND REPAIRED GUSSET BUY INSTALLED FABRICATED DOUBLER FOR AFT FLOOR SILL REPAIR BETWEEN FR 22 - 23SDR SWAA2026012853686Angle · corrodedCORRODED ANGLE, BS 986.5 + 10, RBL 42, WL 208.1. REPLACED THE ANGLE & FASTENERS IAW SRM 51-40-02, DWG 147A5700, SHEET 123, REV A, SRM 51-10-02, STEP 9 ITEM A.SDR SWAA2026012853839Vapor Barrier · crackedCRACKED VAPOR BARRIER RT SIDE, RBL 40. REPAIRED THE VAPOR BARRIER IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026012653642Angle · crackedCRACKED ANGLE, BS 500G, STRINGER 26R. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7505, SHEET 137, REV-.SDR SWAA2026012653636Angle · crackedCRACKED ANGLE, AFT FACE BS 500G, STRINGER 26R IN THE FWD CARGO BAY. REPLCED THE ANGLE AND FASTENERS IAW SRM 51-40-02 AND DWG 143A7505, SHEET 137, REV-.SDR SWAA2026012653640Angle · crackedCRACKED ANGLE LOCATED AFT FACE BS 500H, STRINGER 26R IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02 AND DWG 143A7505, SHEET 138, REV-SDR SWAA2026012653641Angle · crackedCRACKED ANGLE, FWD FACE, BS 500H, STRINGER 26R IN THE FWD CARGO BAY. REPLACED THE ANGLEP AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7505, SHEET 138, REV -.SDR SWAA2026012653643Angle · crackedCRACKED ANGLE, AFT FACE, BS 500G, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 143A7505, SHEET 138, REV -.SDR SWAA2026012653637Angle · crackedCRACKED ANGLE, FWD FACE, BS 500G, STRINGER 26L IN THE FWD CARGO BAY. FAULT RESOLVED ON FAULT TTG8Q019HTE5.SDR SWAA2026012353649Web · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 500D TO BS 500E AT STR 26R IN THE FWD CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL LOCATED IAW SRM 51-10-02, STEP 9, & SRM 51-40-02, AND DWG 143A7505, SHEET 138 REV -.SDR SWAA2026012253645Tie Clip · crackedCRACKED TIE CLIP, FWD FACE, BS 500I, STR 26R IN THE FWD CARGO BAY. REPLACED THE TIE CLIP AND FASTENERS LOCATED IAW SRM 51-40-02, & DRAWING 143A1234, SHEET 14, REV A.SDR SWAA2026012253639Angle · crackedCRACKED GUSSET ANGLE, BS 500I, STR 21L IN THE FWD CARGO BAY. REPLACED THE GUSSET ANGLE AND FASTENERS IAW SRM 51-10-02, ITEM 9, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2026012253634Angle · crackedCRACK GUSSET ANGLE, BS 500I, STR 19R IN THE FWD CARGO BAY. REPLACED GUSSET AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEETS 256 AND 257, REV B .SDR SWAA2026012253635Angle · crackedCRACKED GUSSET ANGLE, BS 500I, STR 21R IN THE FWD CARGO BAY. REPLACED THE GUSSET AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEET 257, REV B.SDR SWAA2026012153650Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 500A TO BS 500I RBL 23 WL 156.1 AT FWD CARGO COMPARTMENT ( 10 POINTS). DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 (REPAIR 5) AND EA M-22-153-01550. SEE INDIVIDUAL SIGN OFF BELOW. DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 SDR SWAA2026012153646Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS 500B TO BS 500I LBL 23 WL 156.1 AT FWD CARGO COMPARTMENT ( 10 POINTS) 2025-753402<[01] DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 (REPAIR 5) AND EA M-22-153-01550'. SEE INDIVIDUAL SIGN OFF BELOW. DAMAGE WAS REPAIRED IAW SRSDR SWI2026F00085Slide · misinstalledFORWARD SERVICE DOOR EVACUATION SLIDE NOT PACKED CORRECTLY ON THE BOTTOM. LANYARD WITH ATTACHING D RINGS NOT INSTALLED UNDER SLIDE COVER. REMOVED AND REPLACED ON RACK FWD SERVICE DOOR EVACUATION SLIDE. REF AMM 25-65-01SEE CP31206690 FOR INSTALLATION ON ACFT.HSDR SWIA2026011900218Backboard · crackedAFT PAX DOOR EVACUATION SLIDE COMPOSITE BACK CRACKED AT THE UPPER ATTACH POINT. REMOVED AND REPLACED ON RACK AFT PAX DOOR EVACUATION SLIDE. IAW AMM 25-65-01SEE CP31206689 FOR INSTALLATION ON ACFT.HG2-50002 DUE 9/18/26SDR 3EJA202601150007Static Line · faultedWE LOST THE CAPTAIN AND FO’S ALTITIMER, ALTITUDE SELECT AT NIGHT IN MOUNTAINOUS TERRAIN. PURGED PILOT AND COPILOT STATIC SYSTEM, FOUND PILOT SIDE FITTING ON THE MOISTURE DRAIN VALVE LOOSE.SDR NACA202601138001Boot · damagedRIGHT COOLING HEAT EXCHANGER PLENUM BOOT IS DAMAGED. REMOVED AND REPLACED RT COOLING HEAT EXCHANGER BOOT IAW AMM 21-51-02-004-001, & AMM 21-51-02-404-019. OPS CHKD GOOD.SDR IXXA20260111001Support Channel · corrodedRH AFT LOWER WING TO BODY FAIRING FRAME BS 1037 IS CORRODEDSDR AALA202601066384Lubrication Unit · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE NEAR TOP OF DECENT AT FL210, #1 ENGINE OIL QUANTITY INDICATED 0, SHUTDOWN NUMBER 1 ENGINE. AIRCRAFT EMERGENCY LANDED SAFELY AT OMA. **SUPPLEMENTAL REPORT FOR (AALA202512196384) SUBMITTED 12SDR AALA202601063655Scavenge Pump · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE NEAR TOP OF DECENT AT FL210, #1 ENGINE OIL QUANTITY INDICATED 0, SHUTDOWN NUMBER 1 ENGINE. AIRCRAFT EMERGENCY LANDED SAFELY AT OMA. **SUPPLEMENTAL REPORT FOR (AALA202512196384) SUBMITTED 12SDR DALA2026010600087Unknown · odorDECLARED AN EMERGENCY AND DIVERTED TO ABQ DUE TO CHEMICAL SMELL IN THE CABIN. PERFORMED LEVEL A DECONTAMINATION. (LP 7435638)SDR R61A2026010600005Skin · ground damageAIRCRAFT SKIN DAMAGED FROM BAGGAGE CART BETWEEN FRA 84 TO FRA 85 AND STR 20R TO 22R.REPLACED SHEER CLIP AT FRA 85 AND STRINGERS 21R AND 22R AND CUTOUT DAMAGE AND INSTALLED FILLER,DOUBLER AND TRIPLER IAW ETD2025-170-934453 REV A AND EMB SRM 53-23-01/ REPAIR 13SDR IXXA20260106001Skin · puncturedHOLE IN MAIN CARGO DOOR OUTER SKINSDR AALA202601017013Handle · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PLATE EMERGENCY EXIT DOOR 844 IN PASSENGER CABIN. MAINTENANCE REPLACED HATCH CONTROL HANDLE PLATE ON EMERGENCY EXIT DOOR 844 IN PASSENGER CABIN I.A.W AMM 52-21-11-000-002-A STEP 4.A(1) ITEM (D),(E) AND AMM 52-21-11-400-002SDR AALA202601018982Control Handle · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN PLATE EMERGENCY EXIT DOOR 834 IN PASSENGER CABIN. MAINTENANCE REPLACED HATCH CONTROL HANDLE PLATE ON EMERGENCY EXIT DOOR 834 IN PASSENGER CABIN I.A.W AMM 52-21-11-000-002-A STEP 4.A(1) ITEM (D),(E) AND AMM 52-21-11-400-002-SDR AALA202512310157Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202512314214Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 153, ALONG AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR SWAA2025123053829Fuse · inoperativeEMERGENCY EXIT INDICATOR LIGHT L1358 (AFT RH OVERWING DOOR) IS INOP EMERGENCY EXIT INDICATOR LIGHT L1358 (AFT RH OVERWING DOOR) IS INOP RELATED TO BATTERY PACK M1671. UPON FURTHER INVESTIGATION, FOUND THAT EMERGENCY EXIT INDICATOR LIGHT L1358 AND OVERWING ESSDR IPXA2025122718415Skin · crackedAFTER REMOVAL NR 2 ENG. PYLON LEADING EDGE FOUND OUTER SKIN CRACKED. ACCOMPLISHED REPAIR PER EO-96111-REQ1 AND VT-SAA EA 757-5741-01-B0649, REV. IR.SDR AALA202512301329Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE FITTING 5 ON LH ELEVATOR. MAINTENANCE INSTALLED NEW ELEVATOR HINGE ARM END FITTING 1 LH IAW AMM 55-16-42-400-001-A STEP 4.SDR AALA202512308248Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE FITTING 6 ON LH ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 6 LH IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202512303554Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE FITTING 4 ON LH ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 4 LH IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202512304303Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE FITTING 2 ON LH ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 2 LH IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202512307406Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE FITTING 3 ON LH ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 3 LH IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202512300709Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON HINGE 1 ON LH ELEVATOR. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 1 LH IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202512302207Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB AT STABILIZER STA 92.70, 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.