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 EE4Y2025090323025Floorbeam · corrodedDURING THE ACCOMPLISHMENT OF 737-AE-53-837_P1-OP-UP NAC TASK CARD, IT WAS FOUND AT STA.767, THE FLOOR BEAM WITH SEVERAL CORROSION SPOTS BETWEEN LBL 60 AND RBL 60, SPECIFICALLYON UPPER CHORD, UPPER AND LOWER SURFACES. SINCE THE MENTIONED FLOOR BEAM IS AFFECTED SDR EE4Y2025090323024Floorbeam · corrodedDURING THE ACCOMPLISHMENT OF 737-AE-53-837_P1-OP-UP NAC TASK CARD, IT WAS FOUND AT STA. 727J, THE FLOOR BEAM WITH SEVERAL CORROSION SPOTS BETWEEN LBL 60 AND RBL 60, SPECIFICALLY ON UPPER CHORD, UPPER AND LOWER SURFACES. SINCE THE MENTIONED FLOOR BEAM IS AFFECTSDR AALA202509035276Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR OPEN POWER ASSIST CYLINDER LOW IN NITROGEN READING 1000PSI. MAINTENANCE SERVICED THE L4 EMERGENCY OPERATION CYLINDER IAW AMM 52-13-14.SDR AALA202509035114Battery · missingAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT DOOR 4R INOP. CHECKED AND FOUND BATTERY EMPTY. MAINTENANCE REPLACED BATTERY.SDR EE4Y2025090323022Floorbeam · corrodedDURING THE ACCOMPLISHMENT OF 737-AE-53-837_P1-OP-UP NAC TASK CARD, IT WAS FOUND AT STA. 727F, THE FLOOR BEAM WITH SEVERAL CORROSION SPOTS BETWEEN LBL 60 AND RBL 60, SPECIFICALLY ON UPPER CHORD, UPPER AND LOWER SURFACES. SINCE THE MENTIONED FLOOR BEAM IS AFFECTSDR IPXA2025090382863Window · scratchedL2 WINDOW HEAVILY SCRATCHED AND IMPAIRS VIEW DURING TAXI IN WITH BRIGHT LIGHTS LEAK CHECK GOOD. REF MM 05-51-24-201.SDR IPXA2025090383839Fuel Sys · faultedDIVERSION, EMERGENCY DECLARED. SUSPECTED FUEL LEAK LEFT OUTER, FINAL FUEL LT OUTTER 5.88, RT OUTTER 8.07 LT USED 10.99, RT INNER 11.82, CTR 1.58 TRIM TANK EMPTY. FUEL REMAINING 38.2 FUEL, USED 23.5 START FUEL, WAS 62.2 DEFERED AUTO FUEL FEED SYSTEM IAW MEL2SDR QR9R2025090300001Display · failedDURING START RUNUP, PILOT'S NAV DISPLAY WOULD NOT DISPLAY. REMOVED AND REPLACED NAV DISPLAY IAW AMM 31-61-00, 4-2. MOC SUCCESSFULLY COMPLETED.SDR IXXA20250903008Skin · corrodedTWO SMALL AREAS OF CORROSION ON LEFT WING UPPER SURFACE LOCATED AT WSTA. 126.00SDR DALA2025090306533Battery · no testON SVC CK, FOUND AFT EMERGENCY LIGHTS INOP AT LAST 3 ROWS AND AT R4 DOOR. R/R BATTERY AT M736. OP CKS NORMAL. (7353738)SDR IXXA20250903007Skin · corrodedCORROSION ON UPPER SURFACE OF LEFT WING LOCATED AT WSTA. 150.00SDR IXXA20250903006Skin · corrodedCORROSION ON LEFT WING UPPER SURFACE LEADING EDGE AT WSTA. 341.50SDR IXXA202509030017Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT FWD SPAR AT APPROX. WING STA 350SDR IXXA20250903005Skin · corrodedCORROSION ON LEFT WING UPPER SURFACE LEADING EDGE AT WSTA. 349.50SDR IXXA20250903004Skin · corrodedCORROSION ON LEFT WING UPPER SURFACE LOCATED AT WSTA. 425.50SDR IXXA20250903003Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT AFT SPAR AT APPROX. WING STA 95SDR IXXA2025090300017Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT FWD SPAR AT APPROX. WING STA 350SDR 2025FA0000623Brake Assy · misoverhauledINTERNAL CONTAMINATION BLOCKING THE BLEED PORTS AND STATOR MISALIGNMENT WERE DISCOVERED DURING INSTALLATION/ROUTINE MAINTENANCE OF ELEVEN (11) BRAKE ASSEMBLIES OVERHAULED BY VSE AVIATION (FORMERLY AERO WHEEL AND BRAKE SERVICE CORP) ON OR AFTER 07/16/2025. P/NSDR IXXA2025090300018Tube · dentedLEFT WING FUEL DISTRIBUTION TUBE HAS A DENT, LOCATED INSIDE 532BB BETWEEN LOWER STRINGER L-6 AND L-7SDR 2025F00213Flow Valve · failedECS 1 & 2 FAILED IN FLIGHT, DEPRESSURING VALVE, PASSENGERS HEARD A POP SOUND, OXYGEN MASKS CAME OUT.SDR IXXA20250903001Skin · corrodedRW TOP EXTERNAL SKIN CORRODED AT FWD SPAR AT APPROX. WING STA 400SDR 2025F00212Fire Warning · false activation1.FWD CARGO FIRE INDICATION//2. FWD CARGO FIRE BOTTLE WAS DISCHARGE. AFTER REPLACING FIRE EXTINGUISHER COMPONENTS REF ITEM 2, OPS CHECK FOUND NORMAL IAW MD80AMM 26-18-02. 2. PERFORMED MAINTENANCE PROCEDURES FOLLOWING SYSTEM DISCHARGE. REPLACED COMPONENTS IAW MSDR DALA2025090306528Power Supply · no testDURING SCC CHECK, FOUND MULTI ROWS OF CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED EPSU (11WL) IAW. AMM 33-51. (LP 7722087)SDR DALA2025090306527Frame Angle · damagedTOOLING DAMAGE FOUND AT FRAME CLIP ON FORWARD SIDE OF F60 BETWEEN P'1 AND P '2. REPAIRED PER ERA 627429-14 REV. ORIG. (1179479)SDR DALA2025090306526Bracket · damagedCABIN FRAME C41 RT-WAP #3 INBD BRACKET HAS TOOLING MARKS AFT SIDE OF FRAME. REPAIRED PER ERA 627429-14 REV. ORIG. (1179458)SDR DALA2025090306525Fitting · wornRIGHT ELEVATOR HINGE FITTING BEARING WORN. R & R RT ELEVATOR #2 HINGE ARM FITTING PER AMM 55-16. (1179103)SDR KCSA202509031150Closeout Panel · crackedL/H CANTED PRESSURE DECK COMPOSITE CLOSEOUT PANEL CRACKED AT STA 1240 APPROX LBL 86SDR QEMY20250903001Seal · dentedDURING INCOMING INSPECTION AT GE WALES, DEFECTS ON THE INTERSTAGE SEAL HAVE BEEN NOTED. THE INTERSTAGE SEAL HAS 6 DENTS TO 5 CROSSOVER PAD HOLE EDGES. DR # 02214321 WAS REJECTED BY THE OEM AS THE CONDITION COULD NOT BE SUBSTANTIATED. PLEASE NOTE, THE PART WISDR KCSA202509031149Panel · crackedLEFT WING BL 432.6504 FIXED PANEL UPPER CHORD HAS EVIDENCE OF CRACKSDR SWIA2025090275311Skin · gougedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA91625-REO 670-53-21-2419 REV-, COMPLY WITH PERMANENT REPAIR ON GOUGE ON FUSELAGE SKIN BELOW PASSENGER DOOR, BETWEEN BS333 AND 349, S19L AND S20L. BLENDED DISCREPANT AREA PER REO 670-53-21-2419 REV-. THIS TEMPORARY DISPSDR SWI2025F01847Angle · crackedLEFT WING, BATTERY RIB AT WS 53.60 ANGLE ON INBD SIDE OF WEB IS CRACKED AND WEB IS CRACKED AS WELL. REMOVED AND REPLACED LT WING BATTERY RIB IAW SRM 51-42-06. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202512190902Angle · crackedLEFT WING, BATTERY RIB AT WS 48.30 ANGLE IS CRACKED. REMOVED AND REPLACED THE LT UPPER BATTERY RIB ANGLE IAW SRM 51-42-06. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR SWIA202512080902Intercostal · corrodedCORROSION NOTED ON THE LT INTERCOSTAL, BETWEEN BS 265-280, STR27. REMOVED DAMAGED LT INTERCOSTAL, BETWEEN BS 265 - 280, STR27, NOSE JACKING SUPPORT IAW SRM 51-42-06-001-001-A01,SRM 51-42-21-001-001-A01. INSTALLED NEW LT INTERCOSTAL BETWEEN BS 265 - 280, STR27SDR VNAA202511250007Intercostal · corrodedCORROSION ON LATCH PIN INTERCOSTAL LEFT TO STG•R 27 AND BTW FS394 TO FS400 INTERNAL STRUCTURE AT AVIONICS COMPAR•TMENT. LATCH PIN INTERCOSTAL LEFT TO STGR27 AND BTW FS394 TO FS400 INTERNAL STRUCTURE AT AVIONICS COMPARTMENT WAS REPLACED PER SRM 51-42-06-001-0SDR AALA202511138586Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU RIGHT HAND LATERAL FITTING WORN BETWEEN FR 23 AND FR 24, BETWEEN S31R AND S32R. REPLACED LATERAL FITTING PER EA 367830.SDR SWI2025F01467Frame · corrodedAFT FUSELAGE - FRAME HAS CORRISON AT FS 1000.00 BETWEEN STRG 25L TO 25R. ACCOMPLISHED REO 670-53-61-2572 FOR REPAIR BLENDED CORROSION DAMAGE TO FS 1000 LOWER FRAME SECTOR BETWEEN STRG 26L/H TO STRG 25 R/H. TASK CARD 53-900-1002-SKY CIMPLETED.SDR SWIA2025110300902Frame · corrodedAFT FUSELAGE - FRAME HAS CORROSION AT FS 863.00 BETWEEN STRG 25L TO STRG 25R. REMOVED AND INSTALLED NEW FRAME AT FS. 863.00 BETWEEN STRG 20 R/H TO STRG 20 LT. IAW SRM 51-42-06, SRM 51-42-21 NO FURTHER ACTION IS REQUIRED, JOB COMPLETED.SDR SWAA2025101410713Frame · crackedCRACK FRAME LOCATED BS259.5 BTW STR8R TO STR9R AT PASSENGER CABIN. REPAIRED FRAME WEB AT BSTA 259.5 BTW WL 240 AND WL 280 AND RBL 20 AND RBL 50 IAW EA-25-153-02403 WIP1 AND EA-25-153-02403.SDR SWAA2025100610717Web · corrodedCORROSION WEB LOCATED BTW BS 492.4 TO 500A, S26R, WL 152, FWD CARGO COMPARTMENT. REPLACED WEB LOCATED BTW STA 492.4 TO STA 500A STR 26R WL 152 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02 AND DWG 143A0080 SHEET 39 REV-.SDR SWAA2025100610722Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 BL 0 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 BL 0 WL 208.1 AT PASSENGER CABIN IAW SRM-51-40-02, SRM 51-10-02, ITEM 9, DWG 143A5400, SHEET 154, REV -, AND DWG 143A5400SDR SWAA2025100610723Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 10 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 10 WL 208.1 AT PASSENGER CABIN IAW SRM-51-40-02, SRM 51-01-02, ITEM 9 AND DWG 143A5400, SHEET 142, REV -, DWG 143ASDR SWAA2025100610727Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 50 WL 208.1 AT PASSENGER CABIN . REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 50 WL 208.1 AT PASSENGER CABIN IAW SRM 51-10-02; SRM 51-40-02 AND DWG 143A5400 SHEET 141 REV - .SDR SWAA2025100610718Tie Clip · crackedCRACK TIE CLIP LOCATED STA 500I STR 26R AT FWD CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED STA 500I STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 143A1234 SHEET 14 REV. A.SDR SWAA2025100610725Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 13 WL 208.1 AT PASSENGER CABIN. REMOVED AND REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 13 WL 208.1 AT PASSENGER CABIN IAW SRM 51-10-02 ITEM 9; SRM 51-40-02; DWG 143A5400 SHEET 138 REV -.SDR SWAA2025100610726Support Angle · corrodedCORROSION ANGLE - SUPPORT LOCATED STA 500I AND BTW STR 26L TO STR 26R WL 152 AT FWD CARGO COMPARTMENT. REPLACED ANGLE - SUPPORT AND FASTENERS LOCATED STA 500I AND BTW STR 26L TO STR 26R WL 152 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02; SRM 51-10-02 ÏSDR CALA2025100609627Seat Track · corrodedAFT WET AREA, SEAT TRACK SUPPORT HAS CORROSION AT AFT END, STA 1640 AT RBL-24.75. INSTALLED NEW SEAT TRACK SUPPORT AND EXISTING SEAT TRACK BETWEEN STA 1600 AND STA 1640 AND RBL-24.75 PER SRM 51-40-02. REPAIR WAS ACCOMPLISHED ON NO SEATS WERE REMOVED OR DISTRSDR CALA2025100609626Deck Plate · corrodedDECK PLATE AT STA 1680 TO 1720 HAS SEVERAL CORRODED AREAS REPLACED DECK PLATE BETWEEN STA 1680 TO 1720 PER SRM 53-60-51 AND SRM 51-40-02. REPLACED DECK PLATE BETWEEN STA 1680 AND 1720 PER SRM 53-60-51 AND SRM 51-40-02 DMG IF THE CORRODED DECK PLATES HAVE BEESDR CALA2025100609625Floor Support · corrodedFORWARD PASSENGER CABIN FLOOR SUPPORT HAS CORROSION SPOTS ON UPPER SURFACE B.S.312+5" LBL. 12". REMOVED AND REPLACED FLOOR SUPPORT AT FORWARD PASSENGER CABIN B.S. 312 TO 328, LBL . 12" REF SRM 51-40-02-0G-0. AND DWG: 141A5400.SDR SWAA2025100310728Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 40 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 40 WL 208.1 AT PASSENGER CABIN IAW B737-800 SRM 51-40-02 ; SRM 51-10-02 Ï¿½TEM 9 AND DRAWING 143A5400 SHEET 138 RESDR SWAA2025100310716Angle · crackedCRACK ANGLE - CLIP AFT FACE OF FRAME LOCATED STA 400 STR 26L FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP LOC. ON AFT FACE OF FRAME LOCATED STA 400 STR 26L FWD CARGO COMPARTMENT I.A.W B737-800 SRM 51-40-02 AND DWG 143A7505; SHEET 123 AND 124 REV-.