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 SWAA2026021361876Tie Clip · crackedCRACK TIE CLIP, BS 277, S10R. REPLACED THE TIE CLIP, MEASUREMENT OF DAMAGE: 1.650 INCH. REPLACED THE TIE CLIP, MEASURE OF DAMAGE: 1.650 INCH, & NO FOUND ALLOWABLE DAMAGE, IAW 51-40-02 AND DWG 141A1110, SHEET 18, REV-.SDR CALA2026021313748Web · corrodedFOUND EXCESSIVE CORROSION ON THE FWD CARGO MAIN SILL WEB, BTW BS 440 & 492. REMOVED, LOCATED, DRILLED, COUNTERSINK, & INSTALLED A NEW FWD CARGO SILL WEB IAW DWG 143A8330, REV M, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, SRM 51-40-02-0G-0, & SRM 51-40-02-0G-0.SDR SWAA2026021261874Web · crackedCRACKED INTERCOSTAL WEB, BS 294.5 - 303.9, S16L. PERFORMED A REPAIR CAT B ON THE INTERCOSTAL WEB IAW EA 26-153-00182-WIP1, & EA 26-153-00182.SDR SWAA2026021261873Light · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING ALONG PASSENGER CABIN (1KT). REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING IAW AMM 33-51-15-400-802.SDR SWAA2026021261762Shield · corrodedCORRODED SHIELD WEB, BTW BS 492.4 - 500A, RBL 21, WL 156 IN THE FWD CARGO BAY. REPLACED THE SHIELD WEB AND FASTENERS IAW SRM 51-10-02 ITEM 9, AND DWG 143A0080, SHEET 23, REV -.SDR SWAA2026021261877Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 291.5 TO 294.5, S17R. REPLACED THE FLOOR SUPPORT AND & FASTENERS IAW SRM 51-10-02 ITEM 9, AND 141A8310, SHEET 25, REV- .SDR JJBA20260211019Floor Support · corrodedREAR FUSELAGE FLOOR STRUCTURE AT FRAME 71, LT SILL HAS CORROSION AND BARE METAL AT FORWARD PART OF SILL. REMOVED AND REPLACED WITH NEW FROM STOCK REAR FUSELAGE FLOOR STRUCTURE AT FRAME 71 LT SILL.SDR AALA202602109148Blanking Plate · crackedAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 831 AFT GIRT BAR FITTING BLANKING PLATE CRACKED. REPLACED BLANKING PLATE PER TASK CARD 26C22053014.SDR AALA202602109230Blanking Plate · crackedAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 831 FORWARD GIRT BAR FITTING BLANKING PLATE CRACKED. REPLACED BLANKING PLATE PER TASK CARD 26C22053014.SDR ASAA2026011564139Crossbeam · crackedCROSSBEAM AT BS 540, LBL 1 - 24 CRACKED. GROUNDED - YES. R & R THE CROSSBEAM IAW SRM 51-40-02-0G-0.SDR ASAA2026011564137Crossbeam · crackedCROSSBEAM AT BS 540, RBL 1 - 24 CRACKED. GROUNDED - YES. R & R THE CROSSBEAM IAW SRM 51-40-02-0G-0.SDR ASAA2026011564136Crossbeam · crackedCROSSBEAM AT BS 540, RBL 24 - 36 CRACKED. GROUNDED - YES. R & R THE CROSSBEAM IAW SRM 51-40-02-0G-0.SDR ASAA2026011564135Crossbeam · crackedCROSSBEAM AT BS 540, LBL 36 - 48, CRACKED. GROUNDED - YES. R & R CROSSBEAM IAW SRM 51-40-02-0G-0.SDR ASAA2026011564130Fitting · corrodedFWD WET AREA GIRT BAR FITTINGS BS 312 & 344, LBL 54 CORRODED. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, R & R IAW SRM 51-40-02-0G, & AMM 20-50-11-910-801W- 1 O- .072 R- .053 L- 1 D- .019.SDR AALA202602035323Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT MAIN LANDING GEAR DOOR FORWARD ATTACH FITTING BORE. REPLACED ATTACH FITTING PER CMM 52-81-18.SDR AALA202602015367Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY AREA CORNER FITTING AT FR 68, AT LEVEL S23L. REPLACED CORNER FITTING PER SRM 51-42-11-801.SDR ASAA2026011564021Battery · inoperativeEMERGENCY LIGHTS AT R1 DOOR INOP. GROUNDED - YES. REMOVED AND INSTALLED SERVICABLE EMERGENCY LIGHTS BATTER, OPS CHECKS GOOD IAW B737-800 AMM 33-51-06-960-805.SDR AALA202601309803Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23L. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202601301481Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202601309680Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL AFT CORNER SHAPE FITTING AT FR 68 AND S23L. REPLACED CORNER SHAPE FITTING PER SRM 51-72-11.SDR HNAA2026012900104Frame · puncturedPUNTURED FRAME AT FR60, BTW4-5L.REPAIRED IAW ETD2025-145-934269SDR AALA202601281544Door Latch · chafedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME MOUNTED UPPER LATCH TRACK FITTING HAS A CHAFE. REMOVED AND REPLACED AFT ENTRY DOOR UPPER FORWARD DOOR LATCH. PER B737NG, SRM 51-40-02 PERFORMED SATISFACTORY AFT ENTRY DOOR FORSDR AALA202601275033Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500H AND BS 500G AT RBL 26. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202601273493Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB LINE AT STABILIZER STA 157.10, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR 3EJA202601270015Cable · out of adjustDURING CLIMB OUT WE RETRACTED THE LANDING GEAR, THE UNLOCK LIGHT WOULD NOT EXTINGUISH. WE RAN THROUGH THE CHECKLIST DID ALL THE PROPER PROCEDURES AND UNLOCK LIGHT STAYED ILLUMINATED. FOUND GEAR BLOW DOWN CABLE INSTALLED ON AFT SIDE OF UPLOCK BRACKET CAUSING SDR CALA2026012713317Channel · crackedAFT CARGO COMPARTMENT, RT ZEE CHANNEL BTW BS 727 - 727C, FOUND CRACKED. LOCATED, DRILLED AND INSTALLED A NEW ZEE CHANNEL BTW BS 727 - 727C IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0.SDR SWAA2026012661825Megaphone · damagedAFT GALLEY EMERGENCY MEGAPHONE DAMAGED. R & R MEGAPHONE IAW AMM 25-64-00.SDR WX0A2026012632712Screw · missing(AIRCRAFT NOT GROUNDED) SCREW MISSING ON OVER WING ESCAPE SLIDE PANEL (LEFT SIDE) / INSTALLED NEW SCREW REF AMM 25-62-42-400-001-A"SDR AALA202601266425Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING AT FR 66 AND S23L REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202601259366Shade · stuckAIRCRAFT WAS NOT GROUNDED: FA REPORTS WINDOW SHADE AT 14F STUCK IN CLOSED POSITION IN FLIGHT. WAS ABLE TO OPEN ON GROUND BUT MISSING FRAME INSIDE SHADE. **SUPPLEMENTAL REPORT FOR SDR AALA202601179366 SUBMITTED BY CLT ON 1/15/26.**(CLOSED)** MIANTENANCE REPLACSDR AALA202601230466Drain · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL PLATE AT FR 66 AND S23L. REPAIRED SILL PLATE PER SRM 53-41-14-300-001 REPAIR PRINCIPLE #9.SDR CALA2026012313184Light · damagedSEAT 3D EMERGENCY EXIT LIGHT DAMAGED, INOP. REQUESTING MEL. ALL OTHER LIGHTS OK. MEL 3351V APPROVED SECURED LIGHT. PLACED ON MEL. INSTALLED NEW EMERGENCY EXIT LIGHT, AISLE SIDE, AT SEAT 3D AND EMERGENCY LIGHT AT 3D OPS CHECKED GOOD.SDR SWAA2026012161745Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1674 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK M1674 AND TESTED GOOD IAW AMM 33-51-06-960-805.SDR SWAA2026012161746Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1668 INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M1668 AND TESTED GOOD IAW AMM 33-51-06-960-805.SDR AALA202601212672Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND RIVET INTERNAL SKIN BTW FR33 - FR 34 AND STR 41R - STR41L FWD CARGO COMPARTMENT. MAINTENANCE REWORKED FASTNER HOLSES IAW EA 370487.SDR DALA2026012100453Engine · odorRETURNED TO SEA DUE TO FUMES IN FLIGHT DECK AND CABIN. CREW DONNED O2 MASKS. TROUBLESHOT IAW MSI WORKCARDS. ISOLATED ODOR TO NR 2 ENGINE. PERFORMED ECS DECONTAMINATION IAW JIC 0550-2003. REPLACED RECIRCULATION FILTERS. (LP# 8195694)SDR UIEA2026012000015Elt · inoperativeELT LOCATED RT AFT OF OBSERVERS SEAT INOP. REQ REPLACEMENT(<P>R/R ELT FROM RH AFT OF OBSERVERS SEAT IAW B767 AMM 25-26-03. NO DEFECTS NOTED</P>)SDR DALA2026012100445Light · detachedTHE EXIT LIGHT ABOVE THE FLIGHT DECK DOOR IS SEPERATED FROM THE WALL. REINSTALLED THE LIGHT ASSY, OK FOR SERVICE. (7846582)SDR DALA2026012100441Skin · crackedFOUND CRACK .250 IN LENGTH AT HOLE 1 STRINGER 6.5L . C/W PRI 631584-14AD (1403068)SDR DALA2026012100439Floorbeam · corrodedFOUND CABIN FLOORBEAM UPPER TEE FITTING FWD FLANGE CORRODED AT BS 1480, RBL 43. THE REWORKED AREA REPAIRED IAW PRI631358-14. (1402427)SDR WX0A2026012032704Bottle · low pressure(AIRCRAFT NOT GROUNDED) ON FAP AFT OVERWING EMERGENCY EXIT INDICATION CHECK SLIDE INDICTION ILLUMINATED / PER TSM 25-62-00-810-805-A, REMOVED AND REPLACED LT OWS RESERVOIR ASSY. IAW AMM 25-62-46-000-001-A AND 25-62-46-400-001-A. OPS CHECK GOOD. THIS CLEARS MELSDR GTIA2026012039251Pump · inoperativeECAM - HYD Y SYS LO PR - APPEARED 20-30 MINUTES AFTER ITEM 1 ECAM ABOVE ACTUAL Y HDY SYSTEM PRESSURE INDICATED NORMAL AT 3000 PSI ALL RESERVOIR, VALVE, A/ENG PUMP PRESSURES WHERE NORMAL AND GREEN. THE TOP TRIANGLE AND YELLOW LETTERS ON TOP ON SYSTEMS PAGE DISPSDR SWAA2026012063028Fire Warning · intermittentF/O SIDE FIRE WARNING LT COMES ON INTERMITTENLY WITH NO BELL OR OTHER INDICATIONS AT GATE; ENGINE OFF.<[01] R+R F/O'S FIRE WARNING BASE PER AMM 33-11-00SDR IPXA2026012020848Cooling Turbine · warning messageEMERGENCY DECLARED, EQUIP COOLING EICAS MESSAGE AT TOP OF DESCENT, QRH PROCEDURE DID NOT CLEAR THE MESSAGE, STATUS MESSAGE EE CLNG EXH FAN AFTER BLOCK OUT, MULTIPLE EE STATUS MESSAGES ON BLOCK IN REF AMM 21-58-00-700-804. ++CYCLE EE COOLING PCA CB, ALL MSG CLSDR SWAA2026011962034Light · inoperativeLIGHT WAS FLICKERING ON CAPTAIN SIDE AROUND ROW 11 LIGHT WAS FLICKERING ON CAPTAIN SIDE AROUND ROW 11.FLIGHT ATTENDANT NOT SURE IF IT BURNT OUT BUT STRONG ODOR OF SOMETHING THAT MAY HAVE BURNT OUT.FLIGHT ATTENDANTS TURNED OFF LIGHTS AND SMELL DISSIPATED. REPSDR SWAA2026011961786Light · odorEMERGENCY EXIT LIGHTS ILLUMINATED THE EMERGENCY EXIT LIGHTS IN THE CABIN ILLUMINATED WITHOUT A LOSS OF AIRCRAFT POWER. THIS EVENT WAS ACCOMPANIED SIMULTANEOUSLY WITH AN ODOR IN THE COCKPIT & FORWARD GALLEY. AFTERWARDS ONLY SOME OF THE EMERGENCY EXIT LIGHTS REMSDR SWAA2026011962036Assist Handle · looseFORWARD ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR ASSIST HANDLE REF MM 52-11-31SDR SWAA2026011961618Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R RT OVERWING LIGHT IAW AMM 33-51-04.SDR SWAA2026011961493Battery Pack · no testBATTERY AT M1669 FAILED TIME CHECK. R & R THE BATTERY PACK AT M166 IAW AMM 33-51-06.SDR SWAA2026011961484Panel · pulledFOUR FASTENERS PULLED THROUGH LOWER WING PANEL OTBD OF NR 3 FLAP TRACK FAIRING ON LT WING. REMOVED AND REPLACED FASTENERS ON LOWER WING PANEL O/B #3 FLAP TRACK FAIRING ON LEFT WING PER SRM 51-40-02.