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 SWAA2025111334715Light · inoperativeEMERGENCY LIGHT ON RIGHT OVER WING EXIT DOOR INOPERATIVE. REMOVED AND REPLACED RIGHT OVER WING EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-5106. OPS CHECKED GOOD.SDR FDEA202511132173Skin · dentedSLAT NR 3 UPPER SURFACE T/E HAS A SKIN DEFORMATION REPAIRED SLAT NR 3 UPPER SURFACE IAW SRM 57-43-02-1A REMOVED AND REINSTALLED SLAT NR 3 AND OPS CHECK IAW AMM 27-81-02-4, OPS CHECK SATISTFACTORY AND PERFORMED O/B SLAT LOSS SENSING TEST IAW AMM 27-81-00-5, SDR FDEA202511132172Floor Panel · dentedMAIN DECK CARGO COMP - FLOOR PANEL 242UFF (145T5876-112) REQUIRES REPAIR. REPAIRED MAINDECK FLOORPANEL 242UFF MPN# 145T5876-112 STA 980-1114.82 RBL 54.75- RBL 74.25 IN REF TO B767 SRM 53-00-50-2R FIG 201 SH 2 REPAIR 1. SEE JPF FOR ALL WORKSTEPS ACCOMPLISHESDR FDEA202511132171Seat Track · corrodedMAIN CARGO STA 1200 BETW BL 0 TO LBL 58 FLOOR BEAM UPPER T CHORD HAS CORROSION 7 SPOTS CUT OUT UPPER FLOOR BEAM FOUND AREA OUT OF LIMITS STA 1200 BL 0 TO LBL 58 IAW B757 SRM 53-00-51-2R FIG 201 REP 8 AND B757 SRM 53-00-51-1A DET II MANUFACTURE (FORMED) SDR FDEA202511132170Door · faultedL1 DOOR WILL NOT DISARM. REVERSED MEL 52-11-01-01. FOUND WITH LOWER COVER REMOVED DOOR DISARMS AND ARMS NORMALLY. REINSTALLED LOWER COVER AND DOOR CONTINUES TO OPERATE NORMALLY. LOWER COVER WAS DAMAGED AND PLACED ON OIL REF WRI 52-10/5586.SDR FDEA202511132169Slide · dislodgedLEFT FORWARD ENTRY DOOR WILL NOT DISARM. THE LEVER WILL NOT MOVE ALL THE WAY TO THE DISARM POSITION. MEL: 52-11-01-02 ESCAPE SLIDE CAME LOOSE FROM L1 DOOR, ESCAPE SLIDE REMOVED FROM DOOR, BUT REMAINS ONBOARD IN HAZMAT CONTAINER.SDR FDEA202511132168Slide · faultedLEFT FORWARD ENTRY DOOR WILL NOT DISARM. THE LEVER WILL NOT MOVE ALL THE WAY TO THE DISARM POSITION. THIS ITEM WAS ON MEL 52-11-01-01. THE ESCAPE SLIDE HAS COME LOOSE FROM THE STORE, TRANSFERRING WRI 52-10/5579 TO THIS WRI AND PLACING ITEM ON MEL 52-11-SDR GTIA2025111339178A/C Pack · odorDURING CRUISE FL370 FLIGHT ATTENDANT REPORTED ODOR IN AFT CABIN AND FAINTLY IN FOWARD FWD CABIN.REFERRED TO ODOR CHKLIST. PACK 2 SUSPECTED AND TURNED OFF. 5 MINS LATER F/A CONFIRM ODOR HAD DISSIPATED-PERFORMED TSM 05-50-00-810-831-A, ACCOMPLISHED LEVEL A DECONSDR GTIA2025111339177Megaphone · inoperativeDURING REPLACEMENT OF MAGEPHENO BATTERIES FOUND MAGAPHONE DAMAGED. R & R AFT MEGAPHONE IAW AMM 25-65-51 OPS CK GOOD. TC 256551-01-1 C/W.SDR GTIA2025111339174Epsu · inoperativeDURING SVC CHECKED, FOUND EPSU BATTERY 12WL FAILED. R & R EPSU BATTERY 12WL IAW AMM 33-51-38. OPS CHKD GOOD.SDR DALA2025111308342O-Ring · failedDIVERTED TO MSP DUE TO DIRTY SOCK SMELL IN CABIN. COMPLETED AMDS CARD 0550-2001, 0550- 2003 AND 0550-9001-A220. COMPLETED MD LOG #1299655 STEP 1-5. #1 & #2 ENGINES SPINNER O-RINGS REPLACED. REPLACED RECIRCULATION FILTERS, JOB COMPLETE. (LP# 8035421, 1301555, SDR AALA202511135072Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR QR9R2025111300002Headrest · brokenDURING POSTFLIGHT INSPECTION, CO-PILOT HEADREST WAS FOUND TO BE BROKEN AT BASE. REPLACED HEADREST ASSEMBLY IAW CMM 25-10-17.SDR DALA2025111308334Wire · damagedSEAT 43H EPL INOPERATIVE. REPAIRED WIRING PER A330 AMM 33-51. OK FOR SERVICE. (7959083)SDR DALA2025111308333Angle · damagedTOOLING DAMAGE ON ANGLE AFT SIDE OF FRAME 60, INBD OF P'1. REPAIRED PER ERA 630300-14 REV 1. (1301903)SDR QR9R2025111300001Bracket · brokenPILOT DOOR STRUT BROKE WHILE AT A HOVER. REMOVED AND REPLACED DOOR STRUT BRACKET IAW MTC 20-03-02-403.SDR EE4Y2025111323455Skin · dentedDURING A STRUCTURAL INSPECTION, A DENT WAS IDENTIFIED ON THE CENTER FUSELAGE LOWER SKIN AT FRAME 27 AND BETWEEN STRINGERS 27LH-28RH. ACCORDING TO DOCUMENTATION FROM THE PREVIOUS OPERATOR, THE DENT WAS ASSESSED UNDER REFERENCE ETD2017-190-094601. THE AREA IS CSDR EE4Y2025111323452Inlet · dentedDURING THE STRUCTURE INSPECTION, WAS IDENTIFIED AN EXISTING DENTS REPAIR LOCATED ON THE ENGINE NR 2, INLET COWL, INNER BARREL. ACCORDING TO DOCUMENTATION PROVIDED BY THE PREVIOUS OPERATOR, THE REPAIR WAS PERFORMED IN ACCORDANCE WITH CV20-09120. THE CONDITION RSDR EE4Y2025111323451Inlet · dentedDURING THE STRUCTURE INSPECTION, WAS IDENTIFIED AN EXISTING DENTS REPAIR LOCATED ON THE ENGINE NR 1, INLET COWL, INNER BARREL. ACCORDING TO DOCUMENTATION PROVIDED BY THE PREVIOUS OPERATOR, THE REPAIR WAS PERFORMED IN ACCORDANCE WITH CV20-09114 REV B. HOWEVER,SDR JGVR20251113002Skin · corrodedFOUND CORROSION ON THE UPPER INBOARD WING SKINS LOCATED ALONG AND UNDER THE DRAG ANGLES (FUSELAGE TO WING FARING ATTACH STRUCTURE), REMOVED THE DRAG ANGLES, BLENDED CORROSION, REPORTED FOR REPAIR DISPOSITION. REPLACED BLENDED FASTENERS AS REQUIRED, CLEANED TRESDR EE4Y2025111323457Skin · damagedDURING A STRUCTURAL INSPECTION, NICKS WERE FOUND ON THE FUSELAGE SKIN AT FR 26 AND STRINGER 27L. THE DAMAGE WAS REMOVED VIA BLEND-OUT IN ACCORDANCE WITH SRM 51-10-03. THE RESULTING BLENDED AREA WAS EVALUATED PER SRM 53-21-01 AD51 AND DETERMINED TO BE OUT OF LISDR F3LA202511130324Switch · malfunctionedREF LP483843 FLIGHT 1953. EMERGENCY EXIT LIGHTS ACTIVATING SPORADICALLY ON THE GROUND AFTER LANDING. PER TSM 33-57-00-810-819-A, REMOVED AND REPLACED SWITCH 190RH. PERFORMED OPS TEST IAW AMM 33-51-007-100-001. OPS TEST GOOD NO FAULTS FOUND. A/C OK FOR SERVICSDR EE4Y2025111323456Skin · nickedDURING A STRUCTURAL INSPECTION, NICKS WERE IDENTIFIED ON THE FUSELAGE SKIN FROM FR 32 TO FR 32 + 175 MM, BETWEEN STRINGERS 27R AND 28R. THE DAMAGE WAS REMOVED VIA BLEND-OUT IN ACCORDANCE WITH SRM 51-10-03. WHILE MOST OF THE BLENDED AREA WAS CLASSIFIED AS NON-SSDR DALA2025111308314Control Valve · faultedDIV, DE- DIVERTED TO ATL DUE TO UNABLE TO MAINTAIN CABIN PRESSURE WITH LT PACK ON MEL. PERFORMED RT PACK BITE AND SINGLE PACK CONFIDENCE CHECK. NO TROUBLE FOUND. RT PACK OPS CHECK GOOD. REPLACED FLOW CONTROL VALVE FOR LT PACK MEL. OPS OF BOTH PACKS NORMAL.SDR EE4Y2025111323454Skin · dentedDURING A STRUCTURAL INSPECTION, A CRACK WAS FOUND IN FWD FUSELAGE SKIN DENTED, BTWN FR18/19, BTWN STR-18R/19R. THE AFFECTED AREA WAS REPAIRED IAW ETD2014-190-051915 AND DOCUMENTED PER COOPESA EO COO-EO-2025-23345. UNDER JOB A1Q219 NRI 21-81.SDR EE4Y2025111323453Skin · damagedDURING STRUCTURAL INSPECTION, A DENT WITH OIL CANNING AND SEVERAL NICKS LOCATED BETWEEN FR17 AND FR19 WERE FOUND, AND BETWEEN STRINGERS 26R AND 26L. MOST NICKS WERE REMOVED BY BLENDING AND CLASSIFIED AS NON-SIGNIFICANT DAMAGES PER SRM 51-75-16. HOWEVER, THREE SDR JGVR20251113001Tunnel Wall · corrodedBLENDED CORRODED AREAS OF THE NOSE LANDING GEAR TUNNEL, PERFORMED NDT, AND REPORTED FOR REPAIR DISPOSITION. FABRICATED AND INSTALLED REPAIR DOUBLERS AS REQUIRED TO ENGINEERING ORDER.SDR EE4Y2025111323450Skin · crackedDURING INSPECTION, A CRACK WAS FOUND ON THE LH SKIN PANEL OF THE VERTICAL STABILIZER, LOCATED NEAR THE AFT EDGE JUST BELOW RIB 06. THE AFFECTED AREA FALLS WITHIN A NON-REPAIRABLE ZONE AS DEFINED IN SRM 55-30-01/REPAIR 58P. THE CONDITION REPORTED WAS REPAIRED ISDR EE4Y2025111323449Skin · damagedDURING A STRUCTURAL INSPECTION, LIGHTNING STRIKE DAMAGE (LSD) WAS FOUND ON THE FUSELAGE SKIN AT FR 97 + 25 MM, STR-27LH, DUE TO ITS PROXIMITY TO THE STRINGER 27L FASTENER ROW, THREE FASTENERS WERE REMOVED. AFTER DAMAGE REMOVAL VIA BLEND-OUT IN ACCORDANCE WITH SDR 3J7R2025011300001Light · inoperativeON THE RIGHT SIDE MOST AFT EMERGENCY OVERWING LIGHT IS OUT.SDR EE4Y2025111323447Skin · damagedDURING STRUCTURAL INSPECTION, LIGHTNING STRIKE DAMAGES (LSD) WERE FOUND ON THE FUSELAGE SKIN. THE LSDS WERE REMOVED BY BLENDING THE AFFECTED AREAS IN ACCORDANCE WITH SRM 51-10-03 (BLEND-OUT TYPES A AND D). THE CONDITION REPORTED WAS REPAIRED IAW ETD2025-190-93SDR EE4Y2025111323445Skin · damagedDURING STRUCTURAL INSPECTION, SMALL NICKS AND LIGHTNING STRIKE DAMAGES (LSD) WERE FOUND ON THE FUSELAGE SKIN. MOST NICKS WERE REMOVED VIA BLEND-OUTS. SIX (6) LSDS WERE REMOVED BY DRILLING THE SKIN. THE CONDITION REPORTED WAS REPAIRED IAW ETD2025-190-930784 ANDSDR EE4Y2025111323444Skin · crackedDURING A STRUCTURAL INSPECTION, A CRACK WAS FOUND IN THE RH WING LEADING EDGE SKIN CUTOUTBETWEEN RIBS 19 AND 20. THE AFFECTED AREAWAS TRIMMED IN ACCORDANCE WITH SRM 57-49-01 REP51. THE FINAL DIMENSIONS AFTER REWORK EXCEED THE MINIMUM ALLOWABLE LIMITS. THECONDISDR EE4Y2025111323443Skin · crackedDURING A STRUCTURAL INSPECTION, A CRACK WAS FOUND IN THE LH WING LEADING EDGE SKIN CUTOUT BETWEEN RIBS 19 AND 20. THE AFFECTED AREA WAS TRIMMED IN ACCORDANCE WITH SRM 57-49-01 REP 51. HOWEVER, THE FINAL DIMENSIONS AFTER REWORK EXCEED THE MINIMUM ALLOWABLE LIMISDR EE4Y2025111323442Skin · damagedDURING A STRUCTURAL INSPECTION, CUSTOMER IDENTIFIED AN EXISTING SKIN REPAIR LOCATED BETWEEN FR23 AND FR24, AND BETWEEN STRINGERS 16L AND 17L. ACCORDING TO DOCUMENTATION PROVIDED BY THE PREVIOUS OPERATOR, THE REPAIR WAS PERFORMED IN ACCORDANCE WITH ETD2014-190-SDR SWIA2026031875530Angle · crackedLEFT BATT CAP ANGLE AT WS48.3 IS CRACKED. REMOVED AND REPLACED WITH NEW LT BATT CAP ANGLE IAW SRM 51-40-11, SRM 51-42-21, & DWG 600-10389, REV -.SDR SWIA2026031875523Angle · crackedRIGHT BATT CAP ANGLE AT WS 48.3 IS CRACKED. REMOVED CRACKED RT BATT CAP ANGLE AT WS48.3 AND INSTALLED NEW REPLACEMENT IAW DWG 600-10204, REV M, DWG 601R10212, REV A, & SRM 51-42-21.SDR SWIA2026022575321Skin · dentedTHERE ARE 2 ADJACENT DENTS ON THE R/H RUDDER SKIN BETWEEN STA 60.73 AND STA 66.76 LOCATED 6" FORWARD OF THE TRAILING EDGE. (C-CHECK RO 02/22/2026)PERFORMED REPAIR ON THE R/H RUDDER SKIN BETWEEN STA 60.73 AND STA 66.76, 6" FWD OF TRAILING EDGE WITH REFERENCE TSDR SWIA2025111275288Roller · damagedRIGHT FWD INBD & AFT OTBD SLAT TRACK 3-2 ROLLERS HAS A FLAT SPOT. (2 EA). REMOVED AND INSTALLED 1 EA NEW RT FWD INBD. AND AFT OTBD SLAT TRACK 3-2 SIDE ROLLERS REF. AMM 27-81-44-400-803-A01. GAPS CHECKED GOOD AT THIS TIME.SDR SWIA2025111275287Roller · damagedRIGHT FWD OTBD SLAT TRACK 2-2 ROLLER HAS A FLAT SPOT. REMOVED AND INSTALLED 1EA NEW RT FWD OTBD SLAT TRACK 2-2 SIDE ROLLER IAW AMM 27-81-44-400-802-A01. GAP CHECKED GOOD.SDR SWIA2025111275286Roller · damagedFLAT SPOTS FOUND ON LH SLAT TRACK 3-2 ROLLERS (2EA) FWD INBD AND FWD OTBD (C-CHECK RO 02/12/2026)REMOVED AND REPLACED LH SLAT TRACK 3-2 ROLLERS FWD INBD AND FWD OTBD WITH NEW SERVICABLE ROLLERS REF CRJ700 AMM 27-81-44-400-803-A01. GAPS CHECK GOOD AT THIS TIMESDR SWIA2025111275285Roller · damagedFLAT SPOTS FOUND ON LT SLAT TRACK 2-2 ROLLERS (1EA) FWD INBD. REMOVED AND INSTALLED NEW LT SLAT TRACK 2-2 ROLLERS FWD INBD REF AMM 27-81-44-400-802-A01, TORQUE WRENCH ID TUC6225 CAL 31-DEC-25 &DIGITAL CALIPERS TUC10067 CAL DUE 31-MAY-26. GAP CHECK FAILED BETWSDR SWAA2025122234469Access Panel · crackedCRACKED ACCESS PANEL 195CL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 195CL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-10 REPAIR 10.SDR SWAA2025121934313Plate · corrodedCORRODED PLATE, FLOOR PANEL 140CF BS 807, RT SIDE AT AFT CARGO BAY. REPLACED THE PLATE IAW SRM 51-40-02.SDR SWAA2025121934463Gusset · crackedCRACK GUSSET LOCATED AT, BS 500D, FWD CARGO BAY. REPLACED GUSSET AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEET, 209, REV - .SDR SWAA2025121934466Gusset · crackedCRACKED GUSSET, BS 500D, 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, SHEET 209, REV -.SDR SWAA2025121834245Floor Panel · pulledAFT FLOOR PANEL 241XF UPPER SKIN HAS AREAS OF PULLED STRANDS. REPAIRED THE FLOOR PANEL IAW SRM 53-00-50-2R-1-A00939, REPAIR 1.SDR SWAA2025121834250Floor Panel · pulledAFT FLOOR PANEL 242PF UPPER SKIN HAS AREAS OF PULLED STRANDS. FOUND THE FLOOR PANEL 242PF BEYOND ECONOMICAL REPAIR. THE FLOOR PANEL WAS REPLACED WITH A NEW ONE IAW SRM 51-10-02-0G-0, PARAGRAPH 9.SDR SWAA2025121834255Floor Panel · pulledFLOOR PANEL 231ZF UPPER SKIN HAS AREAS OF PULLED STRANDS. DUE TO EXTENT OF THE DAMAGE, FABRICATED A NEW 231ZF FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2025121834256Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAS AREAS OF PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0,