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 MASA2025093000090Light · faultedR2 DOOR EMER EXIT LIGHT INOP. RESET ACFT PWR, OPS CHECK GOODSDR ASAA2025093061673Strap · corrodedAFT WET INTERCOSTAL STRAP AT STA 1016 TO 1026 HAS CORROSION AT LBL 3. GROUNDED - YES. REMOVED DAMAGE FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED AFT WET TINERCOSTAL STRAP AT STA 1016 TO 1026 IAW B737-700 SRM 51-40-02-OG-O.W= 1.25 O= .080 R= .069 L= 2.25 D=SDR ASAA2025093061662Shear Web · corrodedAFT WET IN/BD SHEAR WEB AT STA 847 TO 905 HS CORROSION AT RBL 45. GROUNDED - YES. AFT WET IN/BD SHEAR WEB AT STR 847 TO 905 HAS NO ALLOWABLE LIMITS. REMOVED AND REPLACED IAW B737-700 SRM 51-40-02-0G-0W= 1.25 O= .071 R= .00 L= 2.25 D= .071.SDR ASAA2025093061661Floor Support · corrodedAFT WET FLOOR SUPPORT AT STA 947.5 TO 967 RBL 60 HAS CORROSION. GROUNDED - YES. AFT WET FLOOR SUPPORT FOUND TO HAVE NO ALLOWABLE LIMITS. REMOVED AND REPLACED IAW BOEING 737-700 SRM 51-40-02-0G-0. W= 1.25 O= .080 R= .068 L= 2.75 D= .012.SDR AALA202510206309Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 947.5, RBL 54. REPLACED INTERCOSTAL PER SRM 53-70-51-2R-5.SDR AALA202510202158Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, RBL 54. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202510205659Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 737 PLUS 2 INCHES, AT LBL 24. REPAFIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR R61A2025101900473Skin · scratchedDURING HEAVY CHECK RIGHT HAND INBOARD LEADING-EDGE SKIN FOUND TO HAVE SCRATCHES IN FOUR LOCATIONS AS MARKED. REPAIRED SCRATCHES IAW EMB ETD02025-170-929517SDR ASAA2025093061558Web · corrodedAFT WET O/B SHEAR WEB AT STA 847 TO 905 HAS CORROSION AT RBL 60. GROUNDED - YES. UPON FURTHER EVALUATION FOUND TO HAVE NO ALLOWABLE LIMITS, REPLACED AFT WET O/B SHEAR WEB AT STA 847 TO 905 AND RBL 60 IAW B737-700 SRM 51-40-02-0G-0W=1.25 O=.071 R=.058 L= 2.25 DSDR FDEA202509301962Rib · cracked2EA CRACKS (5MM & 20MM) INDICATION WERE FOUND AT RH WING CENTER FLAP RIB27 AFTER RIB FLANGE AREA OF TOP SURFACE. ACCOMPLISHED RIB FLANGE REPAIR AT RIB27, S-2.7~REAR SPAR AND EXTERNAL PLATE REPAIR AT RIB26~27, REAR SPAR~S-2.2 I.A.W FEDEX EA NO:T6-5750-T0385SDR QMLA2025100420098Display · faultedJUST LIFTED OFF FROM A PR EVENT & HEADING BACK TO BASE, NOTICED UPPER SCREEN OF VEMD HAD REVERTED TO 3-PARAMETERS ENGINE PAGE & NG INDICATION MISSING & YELLOW. A CAUTION MESSAGE OF OVERLIMIT DETECTED SHOWING ON BOTTOM OF VEMD. LOWERED POWER & DIVERTED TO KRVSDR FDEA202509301946Skin · cracked1 EA CRACK (40MM) INDICATION WAS FOUND AT RH WING CENTER FLAP RIB17 AFTER RIB FLANGE AREA OF TOP SURFACE ACCOMPLISHED RIB FLANGE REPAIR AT RIB17, S-2.8~REAR SPAR AND EXTERNAL PLATE REPAIR AT RIB 16 ~18, REAR SPAR ~S-2.1 I.A.W FEDEX EA NO:T6-5750-T0385072P1, SDR FDEA202509301944Skin · cracked1 EA CRACK (30MM) INDICATION WAS FOUND AT RH WING CENTER FLAP RIB18 AFTER RIB FLANGE AREA OF TOP SURFACE. ACCOMPLISHED RIB FLANGE REPAIR AT RIB18, S-2.8~REAR SPAR AND EXTERNAL PLATE REPAIR AT RIB 16 ~18, REAR SPAR ~S-2.1 I.A.W FEDEX EA NO:T6-5750-T0385072PSDR FDEA202509301940Skin · cracked1 EA CRACK (20MM) WAS FOUND AT LH WING CENTER FLAP RIB27 AFT AREA OF TOP SURFACE RIB FLANGE. ACCOMPLISHED RIB FLANGE REPAIR AT RIB 27, S-2.8~REAR SPAR AND EXTERNAL PLATE REPAIR AT RIB 26~27, REAR SPAR~S-2.1 I.A.W FEDEX EA NO:T6-5750-T0385172 P1, SEQ NO: TSDR JJBA20251008037Frame · crackedCF2, BTW STR 15R-16R, RH FRAME 25 FOUND CRACKED. FRAME REPAIRED. U CHANNEL AND REPAIR SPLICE FABRICATED WITH AN ALTERNATE MATERIAL.SDR JJBA20251008030Crossbeam · corrodedCTR CROSSBEAM AT FR20 FOUND CORRODED. MADE REPAIR PART FABRICATEDSDR 2025FA0000693Air Box · crackedAIRBOX SEALS MISSING AND WELD CRACKEDSDR SWIA202510070930Windshield · crackedCAPTAIN SIDE FRONT WINDSHIELD HAS CRACKING VISIBLE IN ENTIRE VIEW (FLIGHT 3668 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30938236 WITH THE FOLLOWING CORRECTIVE ACTION: "REMOVED AND REPLACED THE CA SIDE WINDSHEILD IN REFERENCE TO CRJ 550 ASDR DALA2025100707314Sign · dislodgedSHIP 1821 3L EXIT SIGN DISLODGED FROM CEILING. CORRECTIVE ACTION: EXIT SIGN RESECURED AS REQUIRED. OK FOR SERVICE. (7591112)SDR DALA2025100707313Seat Track · brokenSHIP 194 PASSENGER CABIN RBL 11 SEAT TRACK BROKEN ON CROWN AT STA 1373+20. CORRECTIVE ACTION: REMOVED DAMAGED PASSENGER CABIN RBL 11 SEAT TRACK STA 1351+10- 1395+10 AND REPAIRED IAW B767 SRM 53-00-52-2R-1 AND ER/A 629572- 14 (1226804)SDR CALA2025100709753Skin · corrodedAFT LAV SERVICE PANEL COUTOUT AFT LOWER CORNER SKIN IS BULGING AND RIVETS PULLING THROUGH. AFT LAV SVC PNL CORROSION. PERFORMED REPAIR TO THE FUSELAGE SKIN P/N'S 146A3231-4,146A3201- 7 AND INTERNAL DOUBLER BETWEEN STA 807-887 AND S19L - S24R IAW EC/RA 5360-0SDR CALA2025100709732Frame · corrodedFOUND CORROSION AT LT MLG FAILSAFE STRAP EXTERNAL AT STA 663.75 WL199. PERFORMED A REPAIR TO THE OUTER SURFACE OF THE BS 663.75 REAR SPAR BULKHEAD FRAME LT FAILSAFE STRAP NEAR WL 199 IAW AAR-MIA ESR-WI NO.: 2023704-15-12772 AND EC/RA 5340-02240. INITIATE A DISDR SWAA2025100619350Slider · crackedR/H HORIZONTAL FWD UPPER. SLIDER CRACKED. REMOVED SLIDER REF AMM 53-31-31. INSTALLED SLIDER REF AMM 53-31-31.SDR AALA202510061833Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST BOTTLE LOW. MAINTENANCE SERVICED R4 DOOR IAW AMM 52-11-00.SDR IPXA2025100313786Stiffener · crackedMDC FLOOR, R/H SIDE, BTW FR 38.1 AND FR 38.2, DOG BONE SUPPORT BROKEN. REMOVED AND REPLACED THE DOG BONE SUPPORT BTW FR 38.1 AND FR 38.2 R/H SIDE IAW SRM 51-40-21.SDR IPXA2025100313780Stiffener · crackedMDC FLOOR, R/H SIDE, BTW FR 37 AND FR 38, DOG BONE SUPPORT BROKEN. REMOVED AND REPLACED THE DOG BONE SUPPORT BTW FR 37 AND FR 38 R/H SIDE IAW A300-600 SRM 51-40-21.SDR IPXA2025100308219Aileron · damagedWHILE RETRACTING FLAPS- INBOARD FLAP SKEWED CAUSING DAMAGE TO RIGHT WING ALL SPEED AILERON. PERFORMED PERMANENT REPAIR IAW EO-95289.SDR DALA2025100607256Panel · crackedRIGHT OVERWING EMERGENCY EXIT DOOR SLIDE (OWEED) PANEL TE (DAMAGED) CRACKS AND DELAMINATED. REMOVED AND REPLACED RT OWEED SLIDE PER AMDS 2563-4005. (LP# 1226999)SDR AALA202510032574Tube · leakingAIRCRAFT WAS GROUNDED: SOF EVENT. VERY STRONG SMELL OF SWEATY MUSTY SOCKS DURING GROUND OPERATIONS AND THE DESCENT PHASE. SMELL WAS PRESENT THROUGHOUT THE CABIN AND FLIGHT DECK. SMELL DISSIPATED WITH PACKS OFF. MAINTENANCE TROUBLESHOT PER TSM 30-21-00-810SDR SWAA2025100319564Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. RESECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025100319565Handle · looseAFT GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. RESECURED AFT GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025100319466Lamp · inoperativeENTRY DOOR L-1 EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP PER M/M 33-51-04.SDR SWAA2025100319477Battery Pack · failedLEFT FWD EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025100319478Battery Pack · failedL/H AFT EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025100319479Battery Pack · failedR/H AFT EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06.SDR SWAA2025100319757Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1695 INOP. REMOVED, REPLACED, AND PERFORMED GOOD INSTALLATION TEST OF EMERGENCY LIGHT BATTERY PACK; M1695 PER AMM 33-51-06-960-805.SDR SWAA2025100319756Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M2335 INOP. REMOVED; REPLACED; AND PERFORMED GOOD INSTALLATION TEST OF EMERGENCY BATTERY PACK M2335 PER AMM 33-51-06-960-805.SDR SWAA2025100320015Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1671 INOP. REMOVED AND REPLACE EMEREGENCY BATTERY PACK M1671 PERFORMED GOOD TEST PER AMM 33-51-06-960-805.SDR SWAA2025100319567Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. RESECURED FWD ENTRY DOOR UPPER ASSIST HANDLE REF AMM 20-50-11.SDR DALA2025100307193Seal · leakingDIRTY SOCK SMELL MOMENTARILY AT FL 340 BEFORE DESCENT, ALSO AT FL 190 + 13000FT STILL GIVE PUFFS OF SMELL THAT LINGER. FOUND OIL IN #1 SPINNER. REPLACED #1 ENGINE FAN SHAFT COVER SEAL AND LEAK CHK NML. (LP 7317990)SDR DALA2025100307192Seal · leakingFUMES EVENT AT CRUISE, DESCENT AND AFTER LANDING. NOTICABLE IN GALLEY DURING APPROACH. STRONGEST WITH POWER AT IDLE. FOUND #1 ENG SPINNER WITH EVIDENCE OF OIL. REPLACED #1 ENG FAN SHAFT COVER SEAL PER A321 AMM 72-15. C/W LEVEL B DECOMTIMINATION PER A321 AMM SDR CALA2025100309602Pump · low pressureHYDRAULIC PUMP A. ENG DRIVEN LOW PRESSURE. REPLACED NR 1 ENGINE DRIVEN PUMP IAW AMM 29-11-11.SDR CALA2025100309590Strap · corrodedDURING REMOVAL APU INLET DOOR, FOUND AFT CUTOUT STRAP WITH CORROSION (MARKED IN RED). DOT 34-024. REFERENCE N/R 134237 ESFR ENTRY REMOVED/REPLACED 2 EACH APU CUTOUT STRAPS FILLERS IAW SRM 53-80- 15-2R-1 PARTS FABRICATED IAW SRM 53-80-15-2R-1 TAB 201/202 DETAI SDR CALA2025100309588Stringer Clip · corrodedAFT CARGO STA 1621 BL0 STRINGER CLIP CORRODED. REMOVED AND REPLACED STRINGER SPLICE STA 1621 BL 0. FABRICATED O N TRAVELER#T25/1834399, APPLIED TREAT, PRIME AND TOP COAT. IAW S RM 51-40-02 AND DWG 146N3821SDR CALA2025100309586Gusset · crackedFOUND GUSSET CRACKED INNER RADIUS FWD CARGO COMPARTMENT AT S-21R STA 500I. REMOVED AND REPLACE GUSSET AT FWD CARGO COMPARMENT STR 21R STA 500I AS PER REF B737 SRM 51-40-02-0G-0 AND DWG # 143A7902.SDR CALA2025100309584Brace · gougedFR 1 BULKHEAD CENTER SUPPORT STRUT HAS A GOUGE. REMOVED AND REPLACED RH CENTER POST AT FR 1 BULKHEAD IAW A319 S RM 51-42-11/001 AND SRM 51-72-11-911-002.SDR CALA2025100309582Fairing · crackedFOUND CRACK NO-2 PYLON LOWER FIXED FAIRING INTERNAL AFT SUPPORT RIB MKD DOT 022 REF AAR N/R 99957175 ESFR ENTERED. REMOVED AND REPLECED # 2 PYLON AFT FAIRING EDGE ASSY AS PER B737 SRM 51-40-02-0G-0 AND DWG'S 313A2400 AND 313A2750.SDR CALA2025100309572Sign · damagedDOOR 2L EMERGENCY EXIT SIGN FWD STOPPER BROKEN. REPLACED STOPPER REF IPC 33-51-01-09A OPS CHECKS GOOD REF AMM TASK 33-51-00-710-801.SDR N6WA2025100308Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN FS310-FS333 AT STGR21L. REMOVED AND REPLACED INTERCOSTAL BETWEEN FS310-FS333 AT STGR21L IAW CRJ SRM 51-42-06SDR N6WA2025100307Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN FS333-FS349 AT STGR21L. REMOVED AND REPLACED INTERCOSTAL BETWEEN FS333-FS349 AT STGR21L IAW CRJ SRM 51-42-06