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 DALA2025081906188Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTS INOP. R/R LI DOOR EMERGENCY LIGHT BATTERY PACK PER B737 AMM 33-51. OPS CKS NML.SDR 2WAA202508190181Angle · corrodedMAIN CABIN AFT R/H LAVATORY HAS CORROSION ALL AROUND THE FLOOR BASE AND INCORRECT HOSE INSTALL. ACCOMPLISHED AFT R/H LAVATORY STRUCTURAL REPAIR IAW E.O. WAA-250503.SDR UIEA2025081101119Torque Box · corrodedAFT CARGO COMPT TORQUE BOX PANEL AT STA 1840 TO STA 1860 RBL 6 TO RBL 23 FOUND WITH SURFACE CORROSION(<P>WEB REMOVED AND REPLACED AS PER BOEING DWG 65B06314. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025081601126Bulb · inoperativeEMER SLIDE LIGHT L01533 FOUND LIGHT FUSED.(<P>EMER SLIDE LIGHT LAMPS (2EA) REMOVED AND REPLACED AND OPS TEST CARRIED OUT AS PER B747 AMM 33-51-10-962-001 REV 114, FOUND SATIS.</P>)SDR UIEA2025081601127Battery · no testREF TO TASKCARD 33-050-01-01, FOUND EMER LIGHT AT SLIDE LIGHT L1533 AND EXIT SIGN NOT ILLUMINATED.(<P>EMER BATT ASSY M1969 REMOVED AS PER B747 AMM 33-51-04-002-009-001 REV 114 AND REPLACED AS PER B747 AMM 33-51-04-402-012-001 REV 114 AND OPS TEST CARRIED OUT. SDR UIEA2025081801129Floorbeam · corrodedMAIN DECK COMPT AFTER ADDITION FLOOR PANELS OPEN UP FOR REPAIR LH STA 988 LBL 77 TO 90 FLOOR BEAM UPPER CHORD FOUND CORROSION(<P>MAIN DECK COMPT LH STA 988 LBL 77 TO 90 DAMAGED FLOOR BEAM UPPER CHORD REPAIRED, COMPLIED AS PER B747-400F SRM 53-00-51 REPAIR 3 RESDR UIEA2025081801130Spar · crackedRHW I/B T/E REAR SPAR UPPER CHORD AT WS 540 AREA FOUND CRACKED(<P>CRACKED AT RHW I/B T/E REAR SPAR UPPER CHORD AT WS 540 AREA REPAIRED AS PER EN #3398-25 REV 0 REPAIR CATEGORIZED AS €ŒCATEGORY A€? PERMANENT REPAIR AND REPAIR CLASSIFIED AS €ŒMAJOR REPAIR€? SDR UIEA2025081801131Support Angle · corrodedAFT CARGO COMPT SUPPORT ANGLE AT STA 1900 LBL 6 & RBL 6 FOUND CORRODED(<P>AFT CARGO COMPT SUPPORT ANGLE AT STA 1900 LBL 6 & RBL 6 FOUND CORROSION OUT OF LIMIT AND REPAIRED CARRIED OUT AS PER B747-400F SRM 53-60-07-2R-6 REPAIR 6 REV 104 & EN# 3459-25 REV 0. NOSDR 2WAA202508190185Battery Pack · dischargedMULTIPLES INTERNAL AND EXTERNAL EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS AND EMERGENCY LIGHTSPER MD-80 AMM 33-53-00 OPS CKECK OK.SDR CALA2025081907935Display · faultedRT MCDU FAILED AFTER 1HOUR OF FLIGHT. CYCLED CB TOMC DIRECTION TWICE. STILL INOP. F/O MCDU REPLACEMENT PERFORMED IAW AMM34-61-02/401 REV 137TEST SATISSDR SWIA2025081875422Skin · dentedCOMPLY WITH PERMANENT REPAIR ON RA ID: 93923DENT ON RHS FUSELAGE SKIN PANEL BTWN FS185.00 - FS193.00 AND BL0.00 - BL6.10. COMPLIED WITH REO 601R-53-11-3946 NO OTHER DEFECTS NOTED. PERM REPAIR DUE WITH IN 1600 FH. COMPLIED RA93923-REO 601R-53-11-3946 MXCODEID7SDR SWIA2025081875419Skin · damagedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA91380-REO 601R-57-21-3841. COMPLY WITH PERMANENT REPAIR ON RA ID: 91380FASTENER HOLE ON LH WING FWD OF AILERON DAMAGED DURING SCREW EXTRACTION. LOCATED JUST SLIGHTLY IB OF WS 314.40 UNDER PANEL 598KT REFERENCE REO 601SDR SWI2026F00020Frame · corrodedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA92210-601R-53-61-8197 N454SW MXCODEID76131-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 92210CORROSION DAMAGE ON AFT WEB OF FS 574.00 BETWEEN STR20L - 21L. PERFORMED TEMPORARY REPAIR OF CORROSION DAMAGE ON AFT WEB OFSDR SWI2026F00019Skin · damagedPERMANENT DISPOSITION FOR BLENDED SKIN AND MISDRILL DAMAGE TO FUSELAGE SKIN BETWEEN FS559+112 €“ FS574.00 & STR15L €“ STR16L., COMPLIED WITH PERMANENT REPAIR ON FUSELAGE SKIN BETWEEN FS559+112-FS574.00, STGR15L-STGR16L, REF. REO 601R-53-61-8417, REV. --, DATSDR SWI2026F00018Skin · damagedPERFORMED TEMPORARY REPAIR TO 4 DAMAGED RIVETS AND 1 BURN MARK ON RH SIDE OF FUSELAGE BETWEEN FS409+16 AND FS409+32, ALSO BETWEEN STR23R AND STR24R. WORK DONE IN ACCORDANCE WITH REO 601R-53-31-1134 REV A DATED: 2020-08-19. COMPLIED WITH EDDY CURRENT INSPECTISDR SWIA2026010200818Not Reported · not reportedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA92498-601R-53-61-8196 MXCODEID76417-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 92498THE SUBJECT CONDITION IS STRUCTURALLY ACCEPTABLE FOR 1700 FLIGHT HOURS FROM INCORPORATION OF REO 601R-53-61-8196., PART NUMBER: - SDR SWIA2025123000818Stringer · corrodedSIGNS OF CORROSION ON AND NEAR FASTENERS ON STR 19R BETWEEN BS 597-613. REPAIRED DAMAGE AT STGR 19R BETWEEN BS 597 - 613 IAW SRM 51-42-06, 53-31-03, 53-00-03, 53-00-06, 51-24-16, 51-21-11, 51-25-06, 51-42-21, AMM 20-70-00, 21-23-00, 21-31-00, 21-23-04, 21-23-SDR SWIA202512120818Web · crackedRIGHT FWD EQUIPMENT BAY FLOOR WEB HAS A CRACK AFT OF DOOR. PERFORMED REPAIR ON RT EQUIPMENT BAY FLOOR WEB IAW AMM 20-70-00, SRM 550 51-42-06, SRM 51-21-11, SRM 51-25-06, SRM 51-25-16, REO 670-53-11-509, REV -E, AND REO 670-53-11-2193, REV -, NDT PERFORMED SDR SWI2025F01708Crossbeam · corrodedRIGHT CROSSBEAM AT BS 280 HAS CORROSION. REMOVED AND REPLACED THE CROSSBEAM IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, SRM 51-42-22-001-001-A01, AND DWG CC670-34010, REV -K.SDR SWIA202512020818Latch · crackedSUSPECTED CRACK IN FWD EQUIPMENT COMPARTMENT AROUND AFT LATCH FOR DOOR 212AR. REMOVED AND REPLACED WITH NEW RT DOOR LANDING IAW SRM 51-42-06-001-001-A01, REV 38, DWG CC670-33040, REV G, AND REO 690-53-11-2057 REV--. COMPLIED WITH ALL STEPS OF TASK CARD 51-SDR IPXA2025082531501Skin · bentNLG LEFT CUTOUT PANEL IS BENT AND HAS 2 CRACKS. INSTALLED NEW NLG LT CUTOUT PANEL IAW SRM 51-40-21.SDR SWAA2025093016355Rib · looseLEFT WING DEFLECTION CONTROL RIB LOOSE. REPAIRED IAW SRM 57-51-02-2R-4; LT WING DEFLECTION CONTROL RIB.SDR SWAA2025092905632Web · crackedCRACK ON WEB LOCATED BTW BS 277 TO BS 294.5 BL 0 WL 208.1 AT FWD GALLEY AREA. REPLACED WEB LOCATED BS 277 TO BS 294.5 BTW BL0 WL 208.1 AT FWD GALLEY AREA. IAW B737-800 SRM 51-40-02 AND DWG # 141A5400; SHEET 20 AND REV -.SDR SWAA2025092905812Angle · corrodedCORROSION ON ANGLE LOCATED BTW BS 992.8 TO BS 1016 LBL 32 WL 208.1 AT AFT GALLEY AREA. REPLACED ANGLE AND FASTENERS LOCATED BTW BS 992.8 TO BS 1016 LBL 32 WL 208.1 AT AFT GALLEY AREA IAW B737-800 SRM 51-40-02; SRM 51-10-02 AND DWG 147A5700 SHEET 121 REV A.SDR SWAA2025092905815Angle · crackedCRACKED ANGLE, BS 663.75, LBL 35 IN AIR CONDITIONING BAY. REPLACED THE ANGLE IAW 51-40-02, DWG 111A1000, SHEET 329, REV A, & DWG 111A1000, SHEET 331, REV A.SDR SWAA2025092905810Angle · corrodedCORROSION ON ANGLE LOCATED BS 992.8 RBL 36 WL 208.1 AT AFT GALLEY AREA . REPLACED ANGLE AND FASTENERS LOCATED AND 992.8 RBL 32 TO RBL45 WL 208.1 AT AFT GALLEY AREA IWA BOEING SRM 51-10-02 PARAGRAPH 9 BOEING 737-800 SRM 51-40-02 AND DWG 147A5700 SHEET 123 REVSDR SWAA2025092905634Plate · corrodedCORROSION ON PLATE LOCATED BS 312 LBL 52 WL 208.1 AT FWD GALLEY AREA. REPLACED PLATE LOC ON BS 312 LBL 52 WL 208.1 AT FWD GALLEY AREA; IAW B737-800 DWG: 141A5220 SHEET:1 REV:-. AND SRM 51-40-01 AND 51-10-02.SDR SWAA2025092905644Web · corrodedCORROSION ON WEB LOCATED BTW BS 986.5 TO BS 992.8 RBL 34 WL 208.1 AT AFT GALLEY AREA. REPLACED WEB AND FASTENERS LOCATED BTW BS 986.5 TO BS 1016 RBL 32 TO RBL 45 WL 208.1 AT AFT GALLEY AREA IAW B737-800 SRM 51-40-02 ; AND DWG: 147A5700 SHEET: 123 REV: A.SDR SWAA2025092905822Access Panel · debondedDEBONDED SEAL ACCESS PANEL 632EB AT RT WING. REPLACED SEAL ACCESS PANELS 632EB RT WING I.A.W. B737-800 A.M.M. 28-11-11-900-801. STEP 2.A. THRU 2.I.SDR SWAA2025092905823Access Panel · debondedDEBONDED SEAL ACCESS PANEL 531AB AND 532RB AT LT WING. REPLACED SEAL ACCESS PANELS 531AB AND 532RB LT WING I.A.W. B737-800 A.M.M. 28-11-11-900-801. STEP 2.A. THRU 2.I.SDR SWAA2025092605811Floor Support · corrodedCORROSION ON INTERCOSTAL LOCATED BTW BS 947 TO BS 967 LBL 51 WL 208.1 AT AFT GALLEY AREA. REPLACED INTERCOSTAL LOCATED BTW BS 947 TO BS 967 LBL 51 WL 208.1 AT AFT GALLEY AREA IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 147A5650 SHEET: 55 REV: A.SDR SWAA2025092605814Angle · crackedCRACK ANGLE LOCATED BODY STA 663.75 AND RBL35 AT AIR CONDITIONING BAY. REPLACED ANGLE LOCATED BS 663.75 BTW RBL 5 TO RBL 70 AT AIR CONDITIONING BAY. IAW B737-800 SRM 51-40-02 AND DWG 111A1000 SHEET 329 AND REV A.SDR K11A2025091900347Floorbeam · corrodedFLOORBEAM LOWER CHORD AT STA 767 APPROX RBL 34 HAS CORROSION.SDR K11A2025091900346Floorbeam · corrodedFLOORBEAM LOWER TEE AT BS 747 AT APPROX RBL 24 TO RBL 45 IS CORRODED.SDR SWAA2025091705637Access Panel · crackedCRACK ON FLOAT VALVE ACCESS PANEL 632QB AT RT WING.SDR SWAA2025091505630Girt Bar · corrodedCORROSION ON THE GIRT BAR AT BS 312, LBL 52, WL 208.1. REMOVED AND REPLACED TIE DOWN FOR GIRT BAR AT BS 312, LBL 52, WL 208.1 IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G, AND DWG 141A5220.SDR SWAA2025091505629Intercostal · crackedCRACKED INTERCOSTAL BS 312 - BS 328, LBL 45, WL 208.1. REMOVED AND REPLACED INTERCOSTAL BS 312- 328, LBL 45, WL 208.1 IAW SRM 51-40-02, AND DWG 141A5400.SDR HNAA2025091400633Seat Track · corrodedL/H LOWER SEAT TRACK #5 HAS CORROSION IN MULTIPLE AREAS. R&R LH LOWER SEAT TRACK #5 IAW EMB 145 AMM 53-01-06.SDR HNAA2025091400632Seat Track · corrodedR/H LOWER SEAT TRACK #4 HAS CORROSION IN MULTIPLE AREAS. R&R RH LOWER NUMBER 4 SEAT TRACK IAW EMB 145 AMM 53-01-06 SRM 53-00-11AD.SDR SWAA2025091205603Door · corrodedWATER SERVICE DOOR 146AR CORRODED ON EXTERNAL SKIN. HAND BLENDED AND REMOVED CORROSION DAMAGE ON DR PNL 146AR AND CHECKED WITH 10X MAG IAW SRM 52-40-01-1A-5 STEP 2C (1)UT IAW B737 NDT PART 4 51-00-00 PROCEDURE 2. ORIGINAL .120'; REMAINING .114'; LOSS .006'. SDR IPXA2025090630285Skin · dentedLEFT FWD SIDE OF FUSELAGE HAS 4EA DENTS AFT OF RADOME AT APPROX FS 211 L21L . REMOVED 2EA FASTENERS FOUND WITHIN 0.5" OF DENT PERIPHERY AT LT FUSELGE SKIN BETWEEN FRAMES 199.09/215.25 AND STGR 23L IAW SRM 51-40-02-0G-0. INSTALLED 2EA FASTENERS AT LT FUSELGE SSDR IPXA2025090530455Radome · dentedLEFT FWD SIDE OF FUSELAGE HAS A DENT AFT OF RAYDOME AT APPROX FS 205 L24L . 49-001 ATA 53-00. INSTALLED 1EA (-1) REPAIR DOUBLER AND 1EA (-2) FILLER ON L/H FWD SIDE OF FUSELAGE AFT OF RAYDOME AT APPROX FS L24L IAW E.A.#:757-5310-01-B0557 REV:P1, STEP 22 AND 2SDR IPXA2025090435259Skin · corrodedTHREE FASTENERS HAVE CORROSION AT LOWER FUSELAGE, APPROX BS 1380- 1385. ACCOMPLISHED REPAIR IN ACCORDANCE WITH EO-94896-REQ1 AND VT-SAA EA 757-5310-01-B0558 REV IR.SDR SWAA2025090305624Attach Angle · crackedLEFT BS663 UPPER ATTACH ANGLE IS CRACKED ON VAPOR BARRIER LBL 8 AND LBL 34, WL167.68. REMOVED, REPLACED, AND INSTALLED NEW ATTACH ANGLE IAW SRM 51-40-02-0G-0 AND DWG 11A1000 REV: -, DWG 11A7000 REV: -.SDR SWAA2025090308052Cap · crackedPASSENGER SEAT IN ARM FOOD TRAY ARMCAP CRACKED ON SEAT 1EF; 16F. REPLACED CRACKED PASSENGER SEAT IN ARM FOOD TRAY ARMCAP WITH NEW ON SEATS 1EF; 16F IAW CMM 25-23-67-4275 PAGE 3008; PARA. N(4) AND PAGE 7011 PARA. M(8). OPS CHECK GOODSDR AALA202509021869Fuel Control · low pressureAIRCRAFT WAS NOT GROUNDED: DURING CLIMB AT FL 360 THE RIGHT FUEL TANK, FORWARD PUMP, "LOW PRESSURE" LIGHT ILLUMINATED. FUEL TANK QUANTITY WAS 8,600 LBS. REMOVE AND REPLACED TANK NUMBER 2 FORWARD FUEL BOOST PUMP. PER AMM 28-22-41. OPERATIONAL AND LEAK CHECKS GOSDR SIMA20250818002Seat Track · corrodedRH LOWER SEAT TRACK BEAM CORRODED BETWEEN FR 84/85, JUST AFT OF TRACK. (MAJOR REPAIR) (LEVEL 2 CORROSION). ACCOMPLISHED REPAIR ON RH LOWER SEAT TRACK BETWEEN FR 84/85 AFT OF THE SEAT TRACK IAW ERJ 175 SRM 53-23-10 RE04SDR AALA202509029351Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION / CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR DALA2025082806384None · noneACCOMPLISH SECTION II OF ER/A 628644-14. COMPLY WITH SECTION II OF ER/A 628644-14 BY NEXT SCHEDULED C CHECK ASSOCIATED ER/A 14-628644 ADDED FOR AC 3512 RC SHORTAGE CREATED FOR MFG PN F53974669200 & STK # 0 IPC/CMM 46-41-XX DRAWING DETAIL PART LOG-PAGE. ENTR 0SDR IPXA2025082526064Battery · inoperativeFOUND THE UPPER DECK AISLE EMERGENCY LIGHT M4915 AND L5733 INOP. I.A.W AMM 33-51-04-902-001-001 REV.114 REPLACED EMERGENCY LIGHT BATTERY (M5169) AT UPPER DECK SIDEWELL & PERFORMED EMERGENCY LIGHT (M4915 L5733) TEST, RESULT WAS SATISFACTORY.