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 IXXA20251020002Stub Beam · crackedFRAME INNER CHORD IS CRACKED IN THE TRANSITION RADIUS STUB BEAM STA 903.5 RIGHT SIDESDR UIEA2025102001275Engine · no discrepancyON TAKE OFF ROLL, RECEIVED LT & RT ENG BLEED EICAS MSG & MASTER CAUTION LIGHT. RTO, PERFORMED BITE TEST IAW FIM 36-20 FT 804. FOUND 0 MSG ON THIS FLT LEG. EICAS MSG CLEARED. ALSO, PERFORMED WEU TEST IAW AMM 31-51-00, OPS CHK GOOD. FOUND MSG TO BE NORMAL.SDR 2025FA0000725Warning Message · illuminatedNOTIFICATION REGARDING AN IFSD THAT OCCURRED A FEW HOURS AGO ON ESN 569885 INSTALLED ON PR-TYA/1. THE EVENT HAPPENED DURING THE APPROACH INTO GYN AIRPORT. THE PILOT REPORTED HIGH N2 VIBRATION IN ENGINE 1, WHICH WAS FOLLOWED BY AN OIL FILTER CLOG MESSAGE AND THSDR FDEA202510202055Switch · out of positionAT FL350 AFTER APPROXIMATELY 2 HOUR STARRED RECEIVING INTERMITTENT OVERSPEED WARNING AND THE UPPER ZIPPER KEPT MOVING UP AND DOWN. THEN AFTER 10 MIN OVERSPEED WARNING STAYED ON AND ZIPPER WENT TO 240 IT S AND STAYED ON. THEN THE OVERSPEED GEAR VMO/MMO ADVISORSDR IXXA20251020001Skin · cracked1 CRACK FOUND ON THE R1 DOOR CUTOUT AFT CORNER 2ND FASTENER HOLE FROM THE BOTTOM, .CRACK TO BE IN EXTERNAL SKIN ONLY.SDR IPXA2026021846164Skin · puncturedMAJOR REPAIR, DURING JACKING OF AIRCRAFT, AIRCRAFT FELL OFF ALL THREE JACKS. ACCOMPLISH THE CATEGORY C MAJOR REPAIR PER EO-96552-REQ1.SDR SWIA2026022575331Structure · corrodedLARGE AMOUNT OF CORROSION ALONG THE LOWER EDGE SPAR ON FWD BAGGAGE-BAY DOOR (C-CHECK RO 02/22/2026)REMOVED AND REPLACED LOWER EDGE SPAR ON FWD BAGGAGE BAY DOOR (P/N LE670-39500-2, S/N 054) WITH REFERENCE TO SRM 51-42-06, SRM 51-42-13, AND REO 670-52-35-591 SDR 2026FA0000083Hydraulic Line · failedHYDRAULIC SYSTEM FAILURE FOLLOWED BY NUMBER 2 ENGINE FAILURE. ROOT CAUSE DETERMINED TO BE FAILURE OF NUMBER 1 ENGINE HYDRAULIC PRESSURE LINE.SDR REXA2025121201007Retainer · corrodedCORROSION ALONG SEAL RETAINER OF MAIN AVIONICS COMPARTMENT DOOR SEAL RETAINERS (3EAS)OF MAIN AVIONICS COMPARTMENT DOOR WERE EVALUATED OUT OF LIMITS PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND SEAL RETAINER (1EASDR IPXA2025112848914Skin · dentedPROTRUDING DENT AT APROX STA 1620-1640 STR 23L-24L NEAR LT OUTFLOW VALVE. ACCOMPLISHED REPAIR IAW EO-95813-REQ1 AND VT-SAA EA 757-5300-01-B0619, REV IR.SDR IPXA2025112848783Skin · dentedTHREE DENTS FOUND BETWEEN BS 1460 & 1480. STR 25L-26L. ACCOMPLISHED REPAIR IAW EO-95807-REQ1 & VT-SAA EA 757-5300-01-B0620 REV IR.SDR IPXA2025111846321Support Beam · corrodedLEFT WING OTBD FLAP INBD HINGE STRUCTURE FAIRING 535 DL AREA UPPER SUPPORT BEAM HAS EVIDENCE OF CORROSION, INSTALLED FAIRING SUPPORT BEAM AND 3EA ANGLES IN LH WING OUTBOARD FLAP I/B HINGE REF EA# 011-5700-01-B0623 REV P1 STEP 9, MD-11 SRM 51-33-01-0G-0 AND SSDR SWAA2025112025725Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT RT WING. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT RT WING. IAW B737-700 SRM 51-10-02-0G-0 ITEM 9 AND SRM 51-40-02-0G-0. MEASUREMENT OF CRACK IS: 0.215 INCHES.SDR SWAA2025112025727Plate · crackedCRACK ON CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT LT WING. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE IRSS216 AT LT WING IAW SRM 51-40-02 SRM 51-10-02, ITEM 9 AND DWG 115A2001 SHEET 30 REV A.SDR SWAA2025112025843Angle · crackedCRACKED ANGLE, BS 420, RBL 24 IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02-OG-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 143A7505, SHEET 81, REV -.SDR SWAA2025112025842Angle · crackedCRACK ANGLE, LOCATED BS 440, LBL 24 AT FWD CARGO COMPARTMENT. REPLACED THE ANGLE AND FASTENERS LOCATED BS 440 LBL 24 AT FWD CARGO BAY IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, & DWG 143A7505 SHEET 82, REV.SDR HNAA2025112000780Stringer · crackedSTRINGER 6R IS CRACKED AT FR13. REMOVED AND REPLACED STRINGER 6R BTW FR 12A-14 IAW EMB 145 SRM 51-40-02.SDR HNAA2025112000779Shear Tie · crackedFRAME 79 SHEAR CLIP INBD OF STR 3L CRACKED. REMOVED AND REPLACED FRAME 79 SHEAR CLIP INBD OF STR 3L IAW EMB145 SRM 51-40-02.SDR HNAA2025112000778Shear Tie · crackedF078897 FRAME 80 SHEAR CLIP BETWEEN STR 5R/7R CRACKED. REMOVED AND REPLACED CRACKED FRAME 80 SHEAR CLIP BETWEEN STR 5R-7R IAW EMB 145 SRM 51-40-02 AND EMB 145 SRM 51-40-03.SDR HNAA2025112000777Bulkhead · chafedF078881 LH COCKPIT AFT BULKHEAD GUIDE PIN HOLE UPPER OTBD IS CHAFED. ACCOMPLISHED REPAIR OF LH COCKPIT AFT BULKHEAD UPPER GUIDE PIN OUTBD PLATE IAW EMB145 SRM 53-21-02 ITEM 4 FIGURE 204 AND EO1-53-25-0405.SDR HNAA2025112000776Shear Tie · crackedF078880 SHEAR CLIP IS CRACKED AT FR15 BETWEEN STRGS 15R-16R. RAR SHEAR CLIP AT FR15 BETWEEN STRGS 15R-16R IAW EMB 145 SRM 51-40-02.SDR HNAA2025112000775Stringer · crackedSTRINGER 3L AT FR20 IS CRACKED. REMOVED AND REPLACED MACHINED STGR 3L BTW FR 19-20 IAW EMB 145 SRM 51-40-02.SDR HNAA2025112000769Floor Support · corrodedFWD GALLEY RT CENTER FLOOR SUPPORT HAS CORROSION AROUND NUTPLATE HOLES. PERFORMED PERMANENT REPAIR ON FWD GALLEY RT CENTER FLOOR SUPPORT IAW EO1-53-25-0387 AND SRM 53-21-02, ITEM 2, FIG 201.SDR HNAA2025112000766Floor Support · corrodedLEFT FLOOR SUPPORT NR 2 IS CORRODED. R & R LT FLOOR SUPPORT IAW SRM 51-40-02.SDR SWAA2025111925841Web · corrodedCRACK WEB - INTERCOSTAL LOCATED BTW BS 460 - 480, LBL 24 IN THE FWD CARGO BAY. REPLACED WEB - INTERCOSTAL IAW SRM 51-40-02-0G, DWG 143A7510, SHEET 3, REV B, AND DWG 143A7505, SHEET 81, REV -.SDR SWAA2025111925840Web · corrodedCORROSION WEB SHIELD LOCATED BTW BS 492 - 500A, RBL 24, WL156 IN THE FWD CARGO BAY. REPLACED WEB SHIELD AND FASTENERS IAW SRM 51-40-02-0G-0, 51-10-02, ITEM 9, DWG 143A0080, SHEET 23, REV -.SDR SWAA2025111925844Web · corrodedCORROSION WEB SHIELD LOCATED BTW BS420 - 440, RBL 24 AND WL 156 IN THE FWD CARGO BAY. REPLACED WEB SHIELD AND FASTENERS LOCATED IAW SRM 51-40-02-0G-0, 51-10-02, ITEM 9, & DWG 143A0080, SHEET 23, REV -.SDR SWAA2025111925847Glowstrip · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (10 EA). REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN (10 EA) IAW AMM 33-51-15-400-802.SDR SWAA2025111925722Nut Plate · corrodedCORROSION ON RAIL NUT PLATES LOCATED INTERNAL CAVITY LEADING EDGE OFSS706 AT LT WING. REPLACED RAIL ON NUT PLATES (GANG CHANNEL) LOCATED INTERNAL CAVITY LEADING EDGE OFSS706 AT LT WING IAW B737-700 SRM 51-40-02; SRM 51-10-02 Ï¿½TEM 9 AND DWG 112A4402 SHEET 14SDR IPXA2025111949614Shim · damagedFUSELAGE SKIN HAS A BULGE AT BS 1460 STR 28R , FABRICATED, LOCATED, AND DRILLED NEW SHIM IAW B757-200 SRM 51-40-05-0G-0 AND DWG# 146N3400. REVIEWEDSDR IPXA2025111246321Support Beam · inoperativeLEFT WING OTBD FLAP INBD HINGE STRUCTURE FAIRING 535 DL AREA UPPER SUPPORT BEAM HAS EVIDENCE OF CORROSION, ACCOMPLISHED REPAIR IAW VT-SAA EA 011-5700-01-B0623, REV IR.SDR IPXA2025110748720Spar Cap · corrodedRIGHT WING T/E UPPER FLANGE LOCATED AT STA XORS 484 HAS CORROSION. ACCOMPLISHED IN ACCORDANCE WITH EO-95601-REQ1 AND VT-SAA EA 011-5710-01-B0604 REV IR. EO 95601 ACCOMPLISHED ON T3F18E007R61J.SDR AALA202511175408Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN VERTICAL STABILIZER LEFT HAND LOWER CLOSURE ANGLE ON TOP OF FUSELAGE AFT OF THE DORSAL FIN FROM STA 1005 TO STA 1016. REPAIRED ANGLE PER SRM 53-80-71-2R-6SDR SWAA2025111325736Panel · crackedLOWER LT WING FIXED TRAILING EDGE PANEL AFT OF PANEL 571EB CRACKED WS688. REQUIRES EVALUATION AND REPAIR. LOWER LEFT WING FIXED TRAILING EDGE PANEL AFT OF PANEL 571EB CRACKED WAS ACCOMPLISHED ON FAULT TTG8Q015ULYV.SDR SWAA2025111225713Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561AB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561AB IAW B737-700 SRM 51-70-04-<BR>2R-10 REPAIR 10.SDR SWAA2025111025706Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT. REPAIRED FWD CORNER SCUFF PLATE AT AFT CARGO COMPARTMENT IAW BOEING 737-700 SRM 53-60-15-2R-1 REPAIR 1 PARAGRAPH 4.B. AND BAC 5975.SDR AALA202511056272Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-42-11.SDR AALA202511051088Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT PASSENGER / CREW DOOR CUTOUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23L. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 STEP 2.A FIGURE 001 PRINCIPLE 5.SDR AALA202511058831Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL EXISTING REPAIR BETWEEBN FR 66 AND FR 68 AT S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001. PRINCIPLE 7.SDR IPXA2025110149647Plate · crackedLEFT WING CENTER FLAP, METALIC PLATE ON TOP SURFACE LE SIDE HAS GOUGING AND SHOWS EVIDENCE OF A CRACK. REMOVED AND REMPLACED METALIC PLATE ON TOP SURFACE LE SIDE IAW SRM 51-40-21.SDR SWIA2025100300019Track · gougedAFT CARGO DOOR AFT TRACK NEAR THE MID SECTION HAS DEEP GOUGED AND DAMAGE TO IT ALONG WITH BEING WORN DUE TO AFT CARGO DOOR REPEATEDLY COMING OFF THE TRACKS. REMOVED AND REPLACED CARGO DOOR AFT TRACK IN REFERENCE TO SRM 51-42-06, DWG 601R36008 REV. BC, AND DWGSDR DALA2025102407808Seat Track · corrodedPRODUCTION REQUEST: RH OB FWD SEAT TRACK HAS EVIDENCE OF CORROSION AT FR22. REMOVED AND REPLACED R/H O/B FWD SEAT TRACK AT FR22 IAW A220 ASRP J51-40-11, J51-42-21. REMOVED CORROSION, FOUND OUT OF LIMITS IAW A220 ASRP J51-21-06, J53-21-49. (LP# 1259632)SDR SWAA2025102326021Wire Harness · faultedENG 1 FIRE DETECT LOOP FAULT ILLUMINATED IN FLIGHT A + B. R & R ENG NR 1 FIRELOOP A HARNESS IAW AMM 26-11-02. OPS TEST GOOD.SDR AALA202510235627Oil System · leakingAIRCRAFT WAS GROUNDED: ON DESCENT GOT FUMES OF BURNT PLASTIC THROUGH 8000 FT. UPON LANDING FA'S REPORTED SMELLS OF BURNT OIL AND DIRTY SOCKS. MAINTENANCE REPLACED APU.SDR DALA2025102307761Bleed Air Sys · contaminated(LOG 8004328) ODOR ON T/O DISSIPATED WHILE CLIMBING ODOR RETURNED WHILE ON APPROACH THROUGH FL180. ISOLATED ODOR FROM APU BLEED AIR. PERFORMED OIL DECONTAMINATION. COMPLETED BLACK LIGHT USE AT APU DUCT, LIGHT OIL RESIDUE NOTED. DUCT REASSEMBLED. BLACK LIGHT USSDR DALA2025102307757Seat Track · cracked(LOG 1261048) CRACK ON OUTBOARD RH SEAT TRACK IN STA 812 AT CPAX. OUTBOARD RH SEAT TRACK IN STA 812 AT CPAX WAS REPAIRED PER B737-800 SRM 53-00-52-2R PROCEDURE 5 REPAIR 5.SDR AALA202510230911Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT STA 663, LBL 40. REPLACED ANGLE PER AARD 51-00-05-1.SDR SWAA2025102225663Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED PER [AMM 33-51-06-960-805-NG.SDR SWAA2025102225689Battery Pack · inoperativeL2 DOOR EMERGENCY EXIT EXTERIOR LIGHT IS OUT. REPLACED AFT LH (M1673) EMERGENCY SLIDE/OVERWING DOOR LIGHT BATTERY PACK PER [AMM 33-51-06-960-805-NG.SDR SWAA2025102225681Battery Pack · inoperativeLH SIDE EMERGENCY EXIT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY PACKS ON LEFT HAND SIDE CABIN FWD OF THE EMERGENCY EXIT AND LEFT HAND AFT CABIN IN ACCORDANCE WITH AMM 33-51-06. OPERATIONAL CHECK IS SATISFACTORY AND NO DEFECTS NOTE