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 JR2R20251007300Mount Fitting · corrodedAFT, OUTBOARD GALLEY MOUNT UNDER RH SHEAR PANEL BETWEEN FR87 AND 88 AND AT RBL 36 IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R20251007299Mount Fitting · corrodedAFT, INBOARD GALLEY MOUNT UNDER RH SHEAR PANEL BETWEEN FR87 AND 88 AND AT RBL 28 IS CORRODED OUT OF LIMITS. REPLACEDSDR JR2R202510073000Mount Fitting · corrodedAFT, OUTBOARD GALLEY MOUNT UNDER RH SHEAR PANEL BETWEEN FR87 AND 88 AND AT RBL 36 IS CORRODED OUT OF LIMITS. REPLACEDSDR REXA2026052800835Seat Track · corrodedCORROSION ON SEAT RAIL 9RBL FS693 TO FS 847+16 (1E/A) FS847+16 TO FS977 (1E/A) AND SEAT RAIL 9LBL FS693 TO FS 847+16 (1E/A) FS847+16 TO FS977 (1E/A). CORROSION ON SEAT RAIL 9RBL FS693 TO FS 847+16 (1E/A) FS847+16 TO FS977 (1E/A) AND SEAT RAIL 9LBL FS693 TO FS SDR REXA2026052800834Strap · corrodedCORROSION ON INTERNAL STRAP, SETTLEMENT AREA OF FAIRING ACCESS PANEL 194AB & 193AB CORROSION ON INTERNAL STRAP, SETTLEMENT AREA OF FAIRING ACCESS PANEL 194AB & 193AB WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED OUT LIMITS PER CRJ900 SRM 51-1SDR REXA2026052800821Bonding Plate · corrodedCORROSION ON UPPER/LOWER BONDING PLATES AT AFT SKIN, LH/RH PYLONS. CORROSION ON UPPER/LOWER BONDING PLATES AT AFT SKIN, LH/RH PYLONS WAS EVALUATED WITH EXCESSIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND UPPER/LOWER BONDING PLATES AT AFT SKIN WERE REPLACSDR DALA2026031101709Seat Track · corrodedFWD FUSELAGE SEAT TRACK CORROSION RBL 23.0 AT FRAME 20. SSI: 53- 21-43-01. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0571:5321-2021/002 00304 COMPLIED WITH PRI 629359-14 REVISION 0 AND ER/A 629359-14 REVISIOSDR SWI2026F00021Skin · chafedLH AILERON LOWER LEADING EDGE CHAFFED. )REMOVED AND INSTALLED NEW LH AILERON INBOARD LOWER LEADING EDGE SKIN SHROUD P/N CC670-13053-1 REF. DWG CC670-13000 REV. -D, CRJ200 SRM 51-42-21 AND CRJ200 SRM 51-42-06. COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR SWIA2026010500006Skin · chafedLEFT AILERON UPPER LEADING EDGE CHAFED. REMOVED DAMAGED LH AILERON UPPER LEADING EDGE SKIN REF. SRM 51-42-06, SRM 51-42-21 AND SRM 51-42-22 AND INSTALLED NEW LH AILERON UPPER LEADING EDGE SKIN REF. DWG CC670-13000 REV. -D, SRM 51-42-06, SRM 51-42-21 AND SSDR SCNA20251020393SCover · debondedDISBOND WINDOW OF L1 AND R2 ESCAPE SLIDE COVERS. WINDOW OF L1 AND R2 ESCAPE SLIDE COVERS WERE BONDED PER BOEING SOPM 20-50-12.SDR SWIA2025121901006Intercostal · corrodedINTERCOSTAL FOUND TO BE SEVERELY CORRODED ON MORE THAN ONE ELEMENT REQUIRING REPLACEMENT LOCATED AT BS 364, S25L - 25R. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-42-06, AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WSDR EXFA2025120800728Pipe · crackedWHILE IN CRUISE FLIGHT, CREW NOTED HYDRAULIC LOW PRESSURE LIGHTS ON, ENGINES 1 AND 2 WITH A HYDRAULIC PRESSURE OF 2300 PSI. CREW DIVERTED TO AN ALTERNATE AIRPORT EXTENDING LANDING GEAR MANUALLY PRIOR TO LANDING.SDR AALA202512027160Bolt · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING LEADING EDGE SLAT 1 TRACK #2 UPPER AFT BOLT. REPLACED BOLT PER AMM 06-31-57.SDR IPXA2025111315848Support · corrodedRT APU DOOR SUPPORT LONGERON HAS MULTIPLE AREAS OF CORROSION. ACCOMPLISHED REPAIR PER EA 757-5330-01-B0582, REV IR.SDR SWAA2025111221679Nut Plate · crackedCRACK RAIL NUT PLATE LOCATED ORSS 297 TRAILING EDGE AT LT WING. REPLACED RAIL NUT PLATE LOCATED ORSS 297 TRAILING EDGE AT LT WING IAW B737-700 SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 ITEM 9 AND DWG:115A3712 SHEET: 5 REV: - AND PERFORMED ADJUSTMENT CHECK OF MISMASDR JJBA20251112040Strap · crackedCRACK ALONG FASTENER HOLE IN PANEL 195EL UPPER RETAINING STRAP AT FRAME 41. REMOVED AND REPLACED PANEL 195EL UPPER RETAINING STRAP AT FRAME 41.SDR JJBA20251112034Sill Drain · corrodedCORROSION ON THE MOP SILL FRAME 29 AT STR 16. REMOVED AND INSTALLED NEW RH FLOOR SILL AT FR 35-39SDR JJBA20251112030Floor Support · corrodedLH OMEGA BEAM HAS MULTIPLE AREAS OF CORROSION. PERFORMED BLEND OUT PROCEDURE ON 3 LOCATIONS ON THE LH OMEGA BEAM BETWEEN FR 58 TO FR 61SDR J7SA2025111000461Fce · faultedPTRIM BKP FAIL CAUTION CAS ILLUMINATED ON ROTATION; REMAINED ON AFTER POWER CYCLE AT DESTINATION. REPLACED FCE IAW AMM 27-03-01. PERFORMED FLAP SYSTEM ELECTRONIC RIGGING. OPERATIONAL TESTS SATISFACTORY.SDR VNAA20251109004Rib · crackedCRACK ON OUTBOARD MACHINED RIB OF WS163.00 TRAILING EDGE AT RH WING. ON OUTBOARD MACHINED RIB OF WS163.00 TRAILING EDGE AT RH WING. WAS REPAIRED PER REO 690-57-51-481 REV-.SDR VNAA20251109003Angle · corrodedCORROSION SEVERAL PLACES ON ANGLE MOUNTTING BTW FS=319 TO FS= 379 ON SURROUND STRUCTURE AT GALLEY SERVICE DOOR. CORROSION SEVERAL PLACES ON ANGLE MOUNTTING BTW FS=319 TO FS= 379 ON SURROUND STRUCTURE AT GALLEY SERVICE DOOR DUE TO EXCESSIVE DAMAGE FOUND OUT OFSDR SWAA2025110721822Panel · delaminatedPANEL 194CL HAS AREAS OF DELAMINATION ON OUTER SURFACE. PANEL 194CL WAS REPAIRED IAW SRM 51-70-05-2R-2.SDR CALA2025110410882Skin · crackedCRACK FOUND AT RIGHT HORIZONTAL STABILIZER LOWER SKIN AT STAB STA 120.30, 26" FROM FRONT SPAR, I/B ROW. CRACK LENGTH:1" REF. AAR N/R:99951969 INSTALLED NEW REPAIR DOUBLER ON RT HORIZONTAL STABILIZER LOWER SKIN AND 2EA REPAIR FILLERS AT STAB STA 120.30 PER SRM SDR SWAA2025102921985Stub Frame · crackedBS 295; ABOVE STR 8R; STUB FRAME ABOVE R1 DOOR SEAL DEPRESSOR CRACKED. REMOVED DAMAGE PART; LOCATED; DRILL AND INSTALLED NEW PART I.A.W. SRM 51-40-02-0G-0 AND IAW AMM 51-21-73-701 DWG 141A8370 REV D, SRM 51-40-05-0G-0,SDR SWAA2025102821840Seat Track · wornCABIN SEAT TRACK WORN ON UPPER CROWN AT STA 520 LBL 45 WL 208. REMOVED THE SEAT TRACK AT BS 500C+10.5' TO 520 IAW. SRM 51-40-02-0G-0, LOCATED AN DRILLED NEW SEAT TRACK IAW SRM 53-00-52-2R-4 REPAIR 4; INSTALLED NEW SEAT TRACK IAW SRM 53-00-52-2R-4, REPAIR 4,SDR SWAA2025102822036Access Panel · delaminatedDELAMINATED ACCESS PANEL 431AT AT RT PYLON. PERFORMED VISUAL INSPECTION ON ACCESS PANEL 431AT AT RT PYLON AND NOT FOUND DAMAGE ON FIBER SKIN ONLY WAS FOUND SURFACE PROTECTION DETERIORATED IAW B737-700 NDT PART 1. 51-05-01 PARAGRAPH 3 AND RESTORED SURFACE PROSDR SWAA2025102721975Web · corrodedCORROSION UPPER MAIN SILL WEB LOCATED BETWEEN BS440 TO BS492 AT LEVEL STR 18R AND WL 198.5. REPLACED WEB AND FASTENERS LOCATED BTW BS440 TO BS492 AT LEVEL STR18R RBL70 WL 198.5 IAW SRM 51-40-02-0G-0, SRM 51-10-02, ITEM 9, DWG 143A8111, SHEET 12, REV A, & DWGSDR SWAA2025102721977Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED ORSS 404 INTERNAL CAVITY UPPER AREA TRAILING EDGE AT RT WING. REPLACED RAIL NUT-PLATE LOCATED ORSS 404 INTERNAL CAVITY UPPER AREA TRAILING EDGE AT RT WING IAW SRM 51-40-02, SRM 51-10-02, ITEM 9.SDR SWAA2025102721832Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 265 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 265 AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9 AND DWG 115A2001 SHEET 29 REV. -.SDR SWAA2025102721978Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED ORSS 297 INTERNAL CAVITY TRAILING EDGE AT RT WING. REPLACED RAIL NUT-PLATE LOCATED ORSS 297 INTERNAL CAVITY TRAILING EDGE AT RT WING IAW SRM 51-40-02-0G-0 AND SRM 51-10-02 ITEM 9.SDR SWAA2025102721833Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED IRSS 216 AT LT WING . REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED IRSS 216 AT LT WING IAW SRM 51-10-02 ITEM 9 AND DWG 115A2001 SHEET 30 REV A.SDR SWAA2025102721831Support Angle · crackedCRACK ON SUPPORT ANGLE TRAILING EDGE LOCATED IRSS 212 AT LT WING. REPLACED SUPPORT ANGLE AND FASTENERS TRAILING EDGE LOCATED IRSS 212 AT LT WING IAW SRM 51-40-02 AND DWG 115A2001, SHEET 24, REV A. MEASUREMENT OF CRACK IS L= 0.813".SDR SWAA2025102721976Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED ORSS 376 INTERNAL CAVITY TRAILING EDGE AT RT WING.SDR SWAA2025102721851Support Angle · crackedCRACK SUPPORT ANGLE FLOOR STRUCTURE BS 695 AND RBL 1 PASSENGER CABIN. INSTALLED SUPPORT ANGLE AND FASTENERS LOCATED ON FLOOR STRUCTURE BS 695 AND RBL 1 PASSENGER CABIN IAW SRM 51-40-0G AND DRAWING 273A9110 SHEET 6 REV A.SDR SWIA202510240006Seat Track · corrodedRH SEAT TRACK BETWEEN FR 84/85 HAS CORROSION. (C-CHECK RO 10/23/2025)EVALUATED CORROSION ON RH SEAT TRACK BETWEEN FR 84/85(DAMAGE ON CROWN TEETH) AND REMOVED DAMAGE BY BLENDING. MAX. MEASURED MATERIAL LOSS ON CROWN TOOTH FR84-85= 0.3", L=0.380", W=0.3", MAX. SDR 2025FA0000728Hydraulic Line · leakingHYDRAULIC LOW PRESSURE LIGHTS #1 AND #2 FLIGHT LIGHTS IN HYDRAULIC PRESSURE INDICATOR READ 2300 PSI. CREW PERFORMED FREEFALLING LANDING GEAR PROCEDURE.SDR SWAA2025102221639Light · brokenLH FWD OVER WING EMERGENCY EXIT EXTERIOR EMERGENCY LIGHT ASSY HAS BROKEN NUT PLATE. R & R EMERGENCY LIGHT ASSY PER AMM 33-51-04 / OPS CHECK GOOD PER AMM 33-51-00.SDR MASA2025100600089Battery Pack · inoperativeFO FLASHLIGHT INOPERATIVE. R & R FO FLASHLIGHT BATTERY OPS CHECK GOODSDR SWAA2025102021958Battery · inoperativeLEFT OVERWING DOOR; EMERGENCY LIGHT FWD AND AFT ARE INOP LEFT OVERWING DOOR EMERGENCY LIGHT FWD AND AFT ARE INOP. REPLACED M1670 EMERGENCY BATTERY AND TESTED IAW AMM 33-51-06-960-805, NO DEFECTS NOTED. DADO PANEL SPRING CLIP HOLDER AT THIS LOCATION DAMAGEDSDR AALA202510208403Bellcrank · out of adjustAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 831 TORSION BAR BELLCRANK COMPENSATION MECHANISM IS OUT OF ADJUSTMENT. ADJUSTED TORSION BAR BELLCRANK COMPENSATION MECHANISM PER AMM 52-11-21.SDR AALA202510202922Bellcrank · out of adjustAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 841 TORSION BAR BELLCRANK COMPENSATION MECHANISM IS OUT OF ADJUSTMENT. ADJUSTED TORSION BAR BELLCRANK COMPENSATION MECHANISM PER AMM 52-11-21.SDR SCNA20251020394Retainer · faultedDUE TO HISTORY OF L1 DOOR GIRT BAR FALLING OFF DOOR RETAINER CLIPS-EXAMINE THE RETAINER CLIPS FOR DEFORMATION AND RADIUS OPENING IAW AMM 25-66-01-200-802 SECTION 3.C.(1)(D)(1-4). BEND OR REPLACE THE CLIPS PER VIEW A-A, FIGURE 602. ADJUSTED GIRT BAR CLIPS IAW ASDR SCNA20251020393Window · debondedDISBOND WINDOW OF L1 AND R2 ESCAPE SLIDE COVERS. OPEN.SDR SWAA2025101621957Battery Pack · inoperativeONLY ONE AISLE LIGHT ON THE LEFT SIDE IS OPERATIVE. REPLACED M2335 EMERGENCY BATTERY AND TESTED PER AMM 33-51-06-960-805; NO DEFECTS NOTED. DADO PANEL SPRING CLIP HOLDER AT THIS LOCATION DAMAGED; PREVENTING REINSTALLATION OF PANEL. DEFECT TTG8Q015M2AE GENERATSDR SWAA2025101621956Lamp · inoperativeLEFT SIDE AFT ESCAPE EMERGENCY LIGHT (L732) IS INOPERATIVE. REPLACED THE LAMP LT AFT ESCAPE EMERGENCY LIGHT IAW AMM 33-51-04-960-801 AND PERFORMED GOOD EMERGENCY LIGHT TEST IAW AMM 33-51-00-710-801.SDR SWAA2025101521991Battery Pack · inoperativeEMERGENCY FLOOD LIGHTS ARE OUT AT RT 6 FED, 10 FED, 13 FED, AND EXTERNAL OVERWING RT, BETWEEN THE DOORS. REMOVED AND REPLACED ONE BATTERY PACK AT 500C + 7 RT & OPS CHECKED GOOD OF AISLE LIGHTS AT 6 FED, 10 FED, & 13 FED, AND EXTERNAL OVERWING RT LIGHT, BETWESDR CALA2025101510118Stringer · corrodedAFT CARGO STR 33R HAS CORROSION, FRS 59-61. REMOVED AND REPLACED STRINGER 33R BETWEEN FRS 59-61 IAW SRM 51-72-11 -911-001.SDR DALA2025101307483Indicator · inoperativeR2 DOOR SLIDE LIGHT ON FA FWD PANEL INOPERATIVE. RESECURED CONNECTIONS ON THE BACKSIDE OF 2R SLIDE LIGHT ASSY. ARMED AND DISARMED DOOR AND LIGHT CHECKS GOOD PER B767 AMM 52-73 . MEL CLEARED. PLACARD REMOVED. (6531974)SDR DALA2025101307464Landing Gear · faultedATB - RETURNED TO MLB DUE TO LEFT MLG GEAR INDICATION. R & R LEFT MLG ASSEMBLY PER AMDS 3210-4001-LH. (LP# 6995824)SDR FDEA202510061965Rib · crackedRH WING CENTER FLAP INTERNAL STRUCTURE CRACK AT UPR RIB26 STGR-2.7 TO STGR-2.8. ACCOMPLISHED RIB FLANGE REPAIR AT RIB26, S-2.7~S-2.8 AND EXTERNAL PLATE REPAIR AT RIB26~27, REAR SPAR~S-2.2 I.A.W FEDEX EA NO:T6-5750-T0385072 P1, SEQ NO:XXXX, TITLE:WINGS- FL