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 CALA2025072206834Skin · damagedR/W FUEL PANEL LANDING AT 640LB HAS HOLES OUT OF ROUND PER HAECO LCQ N/R 9298705/28705 GEN BY N078348ESFR COMPLETED AFTER EVALUATION, PERFORMED REPAIR ON ONE OUT OF ROUND HOLE AT RIGHT WING FUEL PANEL 640LB BETWEEN RIBS 16-17 IAW SRM 57-21-11-300-002. REAMED HSDR JJBA20250721069Shear Tie · corrodedSHEAR CLIP AT FR 59 AND BTW STR 19R-20R FOUND CORRODED. SHEAR CLIP AT FR59 AND BTW STR 19R-20R REMOVED AND INSTALLEDSDR DALA2025072105456Skate Angle · corroded(LOG 1084300) AFT MAIN CABIN LT SIDE SKATE ANGLE HAS CORROSION FROM STA 947- 980 LBL 50. REMOVED AND REPLACED NEW SKATE ANGLE AT MAIN CABIN STA 947-980 LBL 50 IAW B 737 SRM 51-40-02.SDR DALA2025072105455Strap · corroded(LOG 1084287) MAIN CABIN AFT WET AREA, CORROSION ON UPPER SURFACE STA 1026 LBL18. REMOVED AND REPLACED STRAP AT MAIN CABIN AFT WET AREA STA 1026 LBL18 IAW B 737 SRM 51-40-02.SDR DALA2025072105454Transition Panel · corroded(LOG 1084004) FWD CARGO LH TRANSITION PANEL BS 500B-4 - 500I CORRODED MULTIPLE AREAS. REMOVED AND REPLACED TRANSITION PANEL AT FWD CARGO BS 500B-4'' TO 500 I IAW B 737 SRM 51-40-02.SDR DALA2025072105453Floorbeam · corroded(LOG 1083971) MAIN CABIN, FLOOR BEAM HAS CORROSION AT STA 328 RBL 55 TO LBL 55. ACCOMPLISHED REPAIR AT MAIN CABIN FLOOR BEAM STA 328 FROM BL 0 TO RBL 65 IAW B 737 SRM 53-10-51-2R-7.SDR JJBA20250721066Shear Tie · crackedRH FR 73 BTW STR 8R-10R SHEAR CLIP FOUND CRACKED. CRACKED SHEAR CLIP AT RH FR 73 BTW STR 8R-10R REMOVED AND REPLACEDSDR REXA2025072100747Intercostal · corrodedPAX DOOR DD2 AFT FOUND TO BE CORRODED REQUIRES REPLACEMENT. REMOVED PAX DOOR AFT DD2 INTERCOSTAL IAW CRJ-700 SRM TASK 51-42-06-001-001-A01 INSTALLED NEW SERVICEABLE PAX DOOR AFT DD2 INTERCOSTAL IAW CRJ-700 SRM TASK 51-42-06-001-001-A01 NEW SERVICEABLE PAX DOORSDR CALA2025072106746Battery Pack · no testEMERGENCY PASSENGER CABIN LIGHTS M1694 FAILS BATTERY CAPCITY CHE CK (REF. AAR NR 1000043131). EMERGENCY LIGHTING BATTERY PACK AT M1694 FAILED FUNCTIONAL CHECK DURING D CHECK IN RFD. M1694 BATTERY PACK FAILED CAPACITY. REMOVED AND REPLACED BATTERY PACK M1694,SDR AALA202507188203Power Supply · no testAIRCRAFT WAS GROUNDED: FAULT CODE FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR FXTA20250718001Pressure Switch · failedLOW FUEL PRESSURE ANNUNCIATOR WITH ENGINE RUNNING AND ELECTRIC BOOST PUMP ON.SDR CALA2025071806735Fuel Cap · missingFUEL CAP MISSING ON ARRIVAL. ACFT DOES NOT HAVE A FUEL CAP. NO DAMAGE AROUND COUPLING NOTED AT THIS TIME. INSTALLED UNDERWING FUEL CAP AS REQUIRED IAW AMM 28-25-41.SDR CALA2025071806715Sdu · faultedFLT CREW REPORTS ACARS NOT WORKING, REPORTS CPDLC INOP. ACP DCMF SYS TEST, AMIS OPS TEST IAW AMM 23-27-00-740-801, 31-41-00- 710-801. HUI REPLACED LEFT AIMS M001 MODULE & OPS TEST CHEKED OK. R & R RT M001 MODULE, INSTALLED SOFTWARE, OPS CHECK GOOD. REF AMM SDR DXTA2025071804260Microphone · odorCOM 1 YELLOW X AS SOON AS WE KEYED THE MIC. SUSPECTED SHORT SMELLED IN COCKPIT ELECTRICAL BURNING SMELL. MM 31-41..05. AFTER ALL WORK COMPLETE, WE FULLY POWERED UP THE AIRCRAFT FOR A MINIMUM OF. 60 MINUTES, RAN ENGINES, PNEUMATICS, AND VCS AND VERIFIED NO SMELSDR DXTA2025071804268Relay · faultedFLAPS FAIL CAS MESSAGE WHEN MOVING THE FLAPS POSITION SWITCH FROM UP TO 1 ON APPROACH AT 3000FT. FLAPS REMAINED IN UP POSITION. RAN QRH AND QRC PROCEDURES, FLAPS WOULDNT RETURN TO NORMAL FUNCTION. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT IN THE NO FLAP CONFSDR DXTA2025071804269Light · no testTHE EMERGENCY LIGHTS DO NOT ACTIVATE WHEN CHECKED DURING THE PREFLIGHT INSPECTION. AFTER RUNNING THE APU FOR 30 MINUTES PER QRH PROCEDURE 25X, THE EMERGENCY LIGHTS TEST PROPERLY. CORRECTIVE ACTION: REPLACED BATTERIES. OPS CHECK GOOD. IAW CE-700 AMM 33-50-00.SDR QMLA2025071520074Unknown · odorDURING REPOSITION FLIGHT TO THE AIRPORT (3 MILES) CREW REPORTED A FUEL SMELL IN THE AIRCRAFT. LANDED AT PLANNED LOCATION, WROTE UP DISCREPANCY, AND CALLED MX.SDR DALA2025071705417Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FRAM 61 ANS STR 3. CORRECTIVE ACTION: REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084464).SDR DALA2025071705416Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FR 61 AND STR 2. CORRECTIVE ACTION: REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084422).SDR DALA2025071705415Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FR 61 ANS STR 3. CORRECTIVE ACTION: REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084416).SDR DALA2025071705414Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FR 61 AND STR 3. CORRECTIVE ACTION: REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084397).SDR DALA2025071705413Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FR 61 ANS STR 2. CORRECTIVE ACTION: REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084404).SDR DALA2025071705412Structure · mechanic errorSHIP 3415 MISDRILL BETWEEN FR 61 AND STR 1. REPLACED UPPER FRAME SECTION AT C61 PER A330 AMM 53-11. (1084411).SDR DALA2025071705403Door · inoperativeSHIP 3413 FWD CARGO DOOR COULDN'T CLOSE. T/S PER A330 TSM 52-36-00-810-803-A. (9123984).SDR DALA2025071705397Stringer · deformedSHIP 3415 FOUND DEFORMATIONS ON THE JUNCTIONS BETWEEN STR 2R AND FRAME 63, STR 2L AND FRAME 64, STR 1R AND FRAMES 61 AND 62. COMPLIED WITH ER/A 627666-14. (1083781).SDR SWAA2025071791871Washer · looseDURING NOSE GEAR LUBRICATION ; EXCESSIVE PLAY FOUND ON NOSE LANDING GEAR RETRACT ACTUATOR AT UPPER & LOWER ATTACH POINTS. INSTALLED REQUIRED WASHERS IAW AMM 32-33-11. INSPECTED PER AMM 32-33-11-401-NG (NOSE GEAR RETRACT ACTUATOR - REMOVAL/INSTALLATION - PERSDR SWAA2025071791330Scuff Plate · crackedAFT CARGO DOOR CENTER SCUFF PLATE HAS A LARGE CENTER DENT AND CRACK ON ITS RADIUS. REMOVED AND REPLACED PER AMM 53-11-02-401-NG (CARGO DOOR SCUFF PLATE - REMOVAL/INSTALLATION - PERMANENT) AFT CARGO DOOR CENTER SCUFF PLATE.SDR SWAA2025071791246Seat · out of adjustPASSENGER SEAT RECLINES INTO AN EXIT ROW 11F. READJUSTED HYDRO LOCK PER AMM 25-22-00. INSPECTION C/W READJUSTED HYDRO LOCK PER AMM 25-22-00.SDR SWAA2025071791255Slide · debondedAFT SERVICE DOOR ESCAPE SLIDE SKIRT RUBBER DISBONDED. R&R AFT SERVICE DOOR ESCAPE SLIDE IAW AMM 25-66-01. INSPECTION C/W R&R AFT SERVICE DOOR ESCAPE SLIDE IAW AMM 25-66-01.SDR SWAA2025071791508Hook · looseFWD SERVICE DOOR GIRT BAR HOOKS ARE REPORTED LOOSE. ADJUSTED FORWARD SERVICE DOOR GIRT BAR HOOKS IN REFERENCE TO AIRCRAFT MAINTENANCE MANUAL 25-66-00-201-NGSDR SWAA2025071791911Retainer · detachedFWD SERVICE DOOR SLIDE COVER RETAINING CLIP FELL OFF<[01] INSTALLED CLIO AS REQ PER AMM 25-66-01SDR SWAA2025071791914Retainer · detachedFWD. SERVICE DOOR SLIDE COVER RETAINING CLIP FELL OFF.<[01] INSTALLED CLIP AS REQ. PER AMM 25-66-01.SDR SWAA2025071791302Bulb · inoperativeR2 DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R2 DOOR EMERGENCY LIGHT BULB IAW AMM 33-51-04.SDR SWAA2025071791518Ballast · inoperativeCA SIDE WING EMERGENCY EXIT DOOR LIGHT INOP<[01] CA SIDE WINDOW LIGHT ABOVE EMERGENCY EXIT DOOR INOP OK TO CONTINUE PER MEL 33-2-03 SP1B AUTH#268976;[02] RELAMPED. NO JOY. REPLACED CAPTAIN SIDE OVERWING EXIT WINDOW LIGHT BALLAST. OPS CHECK OKAY. REF AMM 33-21SDR SWAA2025071791337Handle · looseFWD ENTRY DOOR L1 UPPER ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR L1 UPPER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791339Handle · looseFWD ENTRY DOOR L1 LOWER ASSIST HANDLE LOOSE.SECURED FWD ENTRY DOOR L1 LOWER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791335Handle · looseAFT ENTRY DOOR L2 ASSIST HANDLE LOOSE.SECURED AFT ENTRY DOOR L2 ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791257Plate · looseFWD SERVICE DOOR HANDLE CAM PLATE IS LOOSE. SECURED FWD SERVICE DOOR HANDLE CAM PLATE IAW AMM 20-50-11.SDR SWAA2025071791333Handle · lockedAFT SERVICE DOOR R2 ASSIST HANDLE LOOSE. SECURED AFT SERVICE DOOR R2 ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791336Handle · looseFWD SERVICE DOOR R1 ASSIST HANDLE LOOSE. SECURED FWD SERVICE DOOR R1 ASSIST HANDLE REF AMM 20-50-11.SDR AALA202507178211Skin Panel · departedAIRCRAFT WAS GROUNDED: PASSENGER INFORMED CREW THAT SMALL SKIN PATCH WAS LOOSE ON TAXI-OUT AND DEPARTED THE AIRCRAFT IN FLIGHT. PASSENGER ADVISED F/A AFTER TAKE-OFF AND EXTRA CREW MEMBER CONFIRMED MISSING PANEL. MAINTENANCE INSTALLED NEW PANEL USED ALT PARTS FSDR AALA202507172687Power Supply · inoperativeAIRCRAFT WAS GROUNDED: RIGHT OVER-WING EMERGENCY LIGHT WILL NOT ILLUMINATE WITH SWITCH ON. MAINTENANCE REPLACED EPSU IAW AMM 33-51-38.SDR AALA202507170019Bulb · burned outAIRCRAFT WAS NOT GROUNDED: CEILING EXIT LIGHT BETWEEN LAV 3R INOP. MAINTENANCE RELAMPED CEILING EXIT LIGHT BETWEEN LAV 3R OPS CKS OK.SDR AALA202507171395Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CONFIGURATION FROM FLAPS 25 TO FLAPS 30, OBSERVED TRAILING RIDGE FLAP DISAGREE BY A NEEDLE WIDTH. RECEIVED THE AMBER LEADING EDGE FLAPS TRANSIT AND NO GREEN LEADING EDGE FLAPS LIGHT. EXECUTED A GOSDR ASAA2025071559468Power Supply · inoperativeLIGHTS ASSOCIATED WITH EMERGENCY LIGHT POWER SUPPLY M1676 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M1676 PER B737-800 AMM 33-51-06-960-806, INSTALLATION TEST GOOD.SDR UIEA2025071600963Seal · brokenCAPT EVAS SECURITY TAPE/SEAL BROKEN. R/R TAMPER TAPE IAW AMM 25-60-99-404-006 STEP B.5 NO DEFECTS NOTED AT THIS TIME.SDR UIEA2025071600964Oxygen Mask · unwanted deployROW 17 SEATS K/H OXYGEN MASK FALL ON LANDING.(<P>RE-STOWED OXYGEN MASK IAW AMM 35-00-01. OPS CHECK GOOD.</P>)SDR DALA2025071705371Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT FR74 RBL 23. REMOVED AND REPLACED SEAT TRACK FROM STA FR 63 +10" TO FR 74 + 10" RBL 23 IAW A220 ASRP BD500-A-J51-42-21-00AAA-078A-A AND BOMBARDIER DWG# C01342701 REV. G. (LP# 1084227)SDR N6WA2025071701Skin · dentedDENT FOUND AT FS1126-FS1144 BETWEEN STRINGERS 18R-17R. REMOVED FASTENERS AND DRESSED BACK DENTED SKIN TO ORIGINAL CONTOUR AT FS1126-FS1144 BETWEEN STRINGERS 17R-18R IAW REO-670-51-00-085 REV ASDR DALA2025071705369Bottle · low pressureSHIP 3268 DISC: L2 DOOR OPEN ASSIST BOTTLE PRESSURE LOW. C/A: SERVICED L2 DOOR OPEN ASSIST BOTTLE PER A320 AMM 52-10-00-610- 801C1. FOUND FILLING VALVE LEAKING. R/R FILLING VALVE SEAL PER A320 CMM 5-11-05. SERVICED DOOR OPEN ASSIST BOTTLE. NO LEAKS NOTED. OK F