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 FDEA202510011860Spar Cap · corrodedLEFT WING, TRAILING EDGE REAR SPAR UPPER CAP UPPER SURFACE AT STATION XORS 1046 FOUND CORROSION. LT WING TRAILING EDGE REAR SPAR UPPER CAP UPPER SURFACE AT STATION XORS 1046 CORROSION REMOVED AND FOUND EXCEEDED LIMIT IAW SRM 57-00-10-1A ALLOWABLE DAMAGE, RESDR FDEA202510011859Spar Cap · corrodedLEFT WING, TRAILING EDGE REAR SPAR LOWER CAP UPPER SURFACE AT STATION XORS 1063 FOUND CORROSION. LT WING TRAILING EDGE REAR SPAR LOWER CAP UPPER SURFACE AT STATION XORS 1063 CORROSION REMOVED AND FOUND EXCEEDED LIMIT IAW SRM 57-00-10-1A ALLOWABLE DAMAGE, REASDR 2025FA0000674Pin · disengagedSEAT BACK CAM RETAINING PINS LOOSE, MISSING AND OR SHEARED FOUND SAFETY-WIRED IN PLACE. THERE APPEARS TO BE MANY OF THESE INFINITE ADJUSTABLE LOWER SEAT FRAMES WITH THE NAS SPLIT-PINS SAFETY-WIRED IN PLACE. THERE IS NO REQUIREMENT TO ADD SAFETY-WIRE TO THESE SSDR CALA2026090119127Frame · crackedRIGHT FR 16 DOUBLE JOGGLE HOLE NR 7 CRACKED AT 9 O' CLOCK IN FRAME LAYER. ACCOMPLISHED OVERSIZING REPAIR ON THE RT FR 16 DOUBLE JOGGLE IAW SRM 53-11-12-300-012. REAMED HOLE TO .2170" (SECOND OVERSIZE) PERFORMED ROTO SCAN WITH NO DEFECTS NOTED. TSDR REXA2026052800825Structure · crackedCRACK AT OVERWING EMERGENCY EXIT DOOR RH AFT TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER). EMERGENCY EXIT DOOR RH AFT TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER) WAS REPAIRED PER REO 670-52-21-103 REV. --SDR REXA2026052800824Structure · crackedCRACK AT OVERWING EMERGENCY EXIT DOOR RH FWD TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER). EMERGENCY EXIT DOOR RH FWD TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER) WAS REPAIRED REO 670-52-21-103 REV. --SDR REXA2026052800812Drag Angle · crackedCRACK ON RH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 61.56% STRG DATUM TO 67.5% REAR SPAR DATUM REPAIR ON CRACK ON RH VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 61.56% STRG DATUM TO 67.5% REAR SPAR DATUM WAS PERFORMED PESDR REXA2026052800811Striker · crackedCRACK AT OVERWING EMERGENCY EXIT DOOR LH FWD TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER). EMERGENCY EXIT DOOR LH FWD TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER) WAS REPAIRED PER REO 670-52-21-103 REV -.SDR REXA2026052800810Door · crackedCRACK AT OVERWING EMERGENCY EXIT DOOR LH AFT TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER). EMERGENCY EXIT DOOR LH AFT TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER) WAS REPAIRED PER REO 670-52-21-103 REV. --SDR REXA2026052600638Retainer · corrodedAFTER SEAL AFT BAGGAGE-BAY DOOR REMOVAL IN REF NRC 00112, CORROSION ON SEAL RETAINER LOWER WAS FOUND. SEAL RETAINER LOWER WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01SDR DALA2026031101708Seat Track · corrodedAFT FUSELAGE SEAT TRACK CORROSION RBL 43.5 AT FRAME 72 AND EXTENDING UNDER NICKEL MAT. SSI: 53-61-43-01. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. COMPLIED WITH PRI 629430-14 REVISION 0 AND ER/A 629430-14 REVISION ORIGINAL. (LP# 1227036)SDR DALA2026031101707Seat Track · corrodedFWD FUSELAGE SEAT TRACK CORROSION LBL 43.5 AT FRAME 22. SSI: 53- 21-43-01. NO EVIDENCE OF PREVIOUS RE-WORK OR REPAIR NOTED. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0571:5321-2021/005 00307 COMPLIED WITH PRI 629427-14 REVISION 0 AND ER/A 629427-14 REVISIOSDR DALA2026022301265Frame · corrodedCORROSION ON STA 1809.5 BULKHEAD AFT LOWER CHORD AT LBL 2. C/W ER/A 629475-14 REV ORIGINAL (1226698)SDR SWIA20260105930Fairing · damaged1EA ELONGATED HOLE NOTED UNDER FUSELAGE FAIRING 191BB, BETWEEN STR18L-STR19L AT FS409+96. REPAIRED 1EA ELONGATED HOLE UNDER FUSELAGE FAIRING 191BB, BETWEEN STR18L-STR19L AT FS409+96, REF. REO REO 601R-53-31-1356 REV -.SDR SWIA2025121900930Intercostal · corrodedINTERCOSTALS FOUND TO BE SEVERELY CORRODED ON MORE THAN ONE ELEMENT REQUIRING REPLACEMENT. REMOVED AND REPLACED THE INTERCOSTALS IAW SRM 51-42-06, AND 51-42-21 06. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR AALA202512083975Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 25R FR66 IN AFT CARGO COMPARTMENT MEASURES ARE: L=5.845 INCH W=0.649 INCH, D=0.110 INCH. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR INSTRUCTIONS (PARTIAL STRINGER REPLACEMENT) ON STRG 25R LOC. FROM FR65 TO FR67 SDR SWI2025F01697Stringer Splice · damagedELONGATED HOLES FOUND ON STRINGER SPLICE 21L. REPLACED THE STRINGER SPLICE 21L, FS333 IAW DWG SH670-32420, REV E, AND SRM 51-42-06-001-001-A01.SDR SWIA2025120100930Floor Support · corrodedUPON REMOVAL OF SEAT TRACK FOUND CORROSION ON FLOOR SUPPORT LBL9, FS549. REPAIRED THE FLOOR SUPPORT BS 533 - 581 IAW SRM 53-00-41-201-001-A01, SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, & DWG: SH670-33415 REV E.SDR SWAA2025110519729Seat Track · deterioratedDETERIORATED SEAT TRACK SEAT ROWS 3(INB) AND 20(OUT) AT PASSENGER CABIN. REPLACED SEAT TRACK IAW CMM 25-22-46-3500 REV. 8 PAGE 3015 DISASSEMBLY STEP 3.AA.(5) AND PAGE 7003 ASSEMBLY STEP 3.B.(3).SDR ASAA2025093061977Shear Web · corrodedAFT WET SHEAR WEB AT STA 907 HAS CORROSION AT RBL 60. GROUNDED - YES. UPPON FURTHER EVALUATION FOUND TO HAVE NO ALLOWABLE LIMITS FABRICATED AND REPLACED AFT WET SHEAR WEB ON STA 907 TO STA 927 AND RBL 60 IAW B737-700 SRM 51-40-02-09-0W= 125 O= .071 R= .065 L= SDR SWAA2025110319909Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BETWEEN BS 294.5 - 303.9, S16L. PERFORMED A MAJOR REPAIR ON WEB INTERCOSTAL IAW EA 25-153-02714-WIP1, TTG8Q015JTW1 AND EA 25-153-02714, TTG8Q015TCU5.SDR SWAA2025110319913Floorbeam · corrodedCORROED FLOORBEAM, BS 986.5, RBL 42, WL 208.1. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2025110319914Floorbeam · corrodedCORROSION FLOOR BEAM, BS 986.5, LBL 42, WL 208.1. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6.SDR SWAA2025110319906Strap · corrodedCORRODED STRAP, FLOOR STRUCTURE LOCATED BETWEEN BS 1016 TO 1040, LBL 4, WL 208.1. REPLACED THE STRAP IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 147A5600, SHEET 32, REV B.SDR SWAA2025110319910Tie Clip · crackedCRACK TIE CLIP LOCATED BS 277, STR 10R. REPLACED THE TIE CLIP AND FASTENERS AT BS 277, S10R IAW SRM 51-40-02-0G-0 AND DWG 141A1110 SHEET 18 REV-.SDR SWAA2025103119889Floorbeam · crackedMAIN CABIN FLOORBEAM CRACKED AT BS 540, BL 0 - RBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-40-02 AND DWG 143A0060 SHEET 46 REV-.SDR SWAA2025103019746Floor Support · crackedCRACKED FLOOR SUPPORT BS 328 - 344, LBL 46 REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02, DRAWING 141A5400, SHEET 44, REV-.SDR SWAA2025103019745Floor Support · crackedCRACKED FLOOR SUPPORT LOCATED BETWEEN BS 312 - 328, LBL 46. REPLACED FLOOR SUPPORT IAW SRM 51-40-02, SRM 51-10-02, AND DWG 141A5400, SHEET 26, REV-.SDR SWAA2025103019912Strap · corrodedCORROSION STRAP FLOOR STRUCTURE LOCATED BETWEEN STA1016 TO STA1040 AND RBL18 WL208.1. REPLACED STRAP FLOOR STRUCTURE IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 147A5730 SHEET 23 REV C.SDR SWAA2025103019891Support Angle · elongatedAFT CARGO COMPARTMENT BULKHEAD; SUPPORT ANGLE HAS SEVERAL FASTENERS HOLES ELONGATED; BTW STA 867 AND STA 947. REPLACED SUPPORT ANGLE LOC. AFT CARGO COMPARTMENT BULKHEAD; ON BTW STA 867 AND STA 947 IAW SRM 51-40-02.SDR SWAA2025103019744Angle · crackedCRACK ON ANGLE WING TO BODY FARING STRUCTURE BS 500D AT LEVEL STR19L AT LOWER FUSELAGE. REPLACED THE ANGLE IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, AND DWG 116A3010, SHEET 39, REV-.SDR SWAA2025103019747Nut Plate · crackedCRACK ON RAIL NUT-PLATE LOCATED ORSS 286 INTERNAL CAVITY TRAILING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED ORSS 286 INTERNAL CAVITY TRAILING EDGE AT LT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR N6WA2025093003Fitting · damagedHORIZONTAL STABILIZER ACTUATOR FITTING HOLES FOUND OVERSIZED DURING HSTA REMOVAL AND REPLACEMENT. REPAIRED IN ACCORDANCE WITH GOJET EO C550-55MR-003-R1 AND MHIRJ REO 670-55-11-423SDR SWAA2025102719923Light · brokenBROKEN PHOTOLUMINESCENT STRIP ON LH SIDE (7EA) AT PASSENGER CABIN 2025-611549<[01] REPLACED PHOTOLUMINESCENT STRIP ON LH SIDE (7EA) AT PASSENGER CABIN IAW B737-700 AMM 33-51-15-400-802;[02] REPLACED PHOTOLUMINESCENT STRIP ON LH SIDE (7EA) AT PASSENGER CABIN IASDR SWAA2025102719924Light · brokenBROKEN PHOTOLUMINESCENT STRIP RH SIDE (7EA) AT PASSENGER CABIN. REPLACED PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN IAW B737-700 AMM 33-51-15-400-802;[02] REPLACED PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN IAW B737-700 AMM 33-51-15-400-802SDR SWAA2025102719390Threshold · crackedFORWARD CARGO BAY AFT CORNER THRESHOLD IS CRACKED. REPAIRED FORWARD CARGO BAY AFT CORNER THRESHOLD IAW SRM 53-30-15-2R-1.SDR N6WA2025093002Skin · damagedRH FUSELAGE SKIN DAMAGED BETWEEN FS364.00 TO FS409.00. REPAIRED IAW GOJET EO C550-53MR-095-O AND AWATS EO 25-CRJ5-53-303SDR N6WA2025093001Skin · damagedR/H SIDE FUSELAGE SKIN DAMAGED BETWEEN FS333.00 TO FS364.00. REPAIRED IAW GOJET EO C550-53RM-096-O AND AWATS EO 25-CJR5-53-304SDR AALA202510266232Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSEMBLY LOCATED FROM BS 767 TO BS 787 AT RBL 20. REPLACED SHIELD PER AARD 51-00-05-1.SDR SWIA2025102400930Seat Track · gougedR/H LATERAL SEAT TRACK SEGMENT FR 59/73 IS GOUGED 59/60 AND 60/73. )REMOVED AND REPLACED R/H LATERAL SEAT TRACK SEGMENT BETWEEN FR 59/73. REF: SRM 51-40-08. FACTORY REOLACEMENT PART INSTALLED NO CHANGE TO AIRCRAFT WEIGHT AND BALANCE. SEE CONTINUATION CARD FORSDR SWAA2025102219703Seal · crackedLEFT HORIZONTAL; UPPER FORWARD SLIDING SEAL CRACKED. REMOVED LH HORIZONTAL UPPER FWD SLIDING SEAL PER AMM 53-31-31.;[02] REPLACED LH HORIZONTAL UPPER FWD SLIDING SEAL PER AMM 53-31-31.SDR SWAA2025102219704Seal · crackedRIGHT HORIZONTAL; UPPER FORWARD SLIDING SEAL CRACKED. REMOVED RH HORIZONTAL UPPER FWD SLIDING SEAL PER AMM 53-31-31. REPLACED RH HORIZONTAL UPPER FWD SLIDING SEAL PER AMM 53-31-31.SDR NACA2025093000008Seal · deterioratedNR 2 ENGINE SEAL ATTACHED TO OIL DRAIN COLLECTOR IS DAMAGED & DETERIORATING. REMOVED & REPLACED NR 2 ENG SEAL ATTACHED TO OIL DRAIN COLLECTOR IAW AMM 51-31-01-302-001 AND 51-31-01-392-013.SDR NACA2025093000007Exciter · damagedNR 1 ENG TOP IGNITION EXCITER INSIDE OUTPUT RECEPTACLE WELL HAS DAMAGE / SIGNS OF ARCING ON THE CONTACT BUTTON. REMOVED AND REPLACED #1 ENG TOP IGNITION EXCITER IAW B767 AMM 74-11-01-004-001-N00 AND AMM 74-11-01-404-019 STEP 3.SDR NACA2025093000006Igniter · wornNR 1 ENG. SYS. 1 TOP IGNITION EXCITER PLUG IS WORN BEYOND LIMITS. IGNITER PLUG REPLACED IAW AMM 74-21-02-404-014-N00.SDR NACA2025093000005Sealant · missing10 O'CLOCK (FWD LOOKING) FAN EXIT STRUT LOWER SURFACE MISSING SEALANT ON NR 2 ENGINE. APPLIED SEALANT ON FAN EXIT STRUT LOWER SURFACE #2 ENG AT 10 O'CLOCK PER B767 AMM 73-3405 TASK 72-34-05-404-005-N00 PAR D (3) (E).SDR NACA2025093000004Liner · misinstalled6 TO 7 O'CLOCK (LOOKING FWD) FAN EXIT LINER NOT PROPERLY FAIRED ON #2 ENGINE. REPAIRED FAIRED FAN EXIT LINER ON #2 ENGINE AT 6 TO 7 O'CLOCK POSITION, REPLACED BROKEN SUPPORT BRACKETS FOR LINER REF MAN-PW4ENG-109 PG 18 AND SRM 51-40-02 STEP 4 (B).SDR NACA2025093000003Control Unit · faultedBUSS POWER CONTROL UNIT HAS A FAULT MESSAGE IDG / OIL OUT. PERFORMED BPCU BITE PROCEDURE PER B-767 FIM 24-30 FAULT TREE 801. BITE PROCEDURE OK.SDR NACA202510229002Clamp · misinstalledNR 2 ENGINE IDG WIRING HARNESS CLAMPS NOT PROPERLY INSTALLED PERFORMED PROPERLY INSTALLATION OF THE CLAMPS IN THE IDG WIRE HARNESS AT #2 ENGINE IAW SWPM 20-10-12 STEP Y PG 148.SDR NACA2025093000001Oil Tube · unsecureBROKEN CLAMP ON OIL TUBE FWD OF OIL TANK ON #1 ENGINE. INSTALLED NEW CLAMP ON FIRE EXT. TUBE FWD OF OIL TANK ON #1 ENGINE PER AMM 20-11-00 TABLE 213/20-11-00-993-830