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 DALA2025111108247Skin · damagedRAMP REPORTS DAMAGE AT AFT CARGO SURROUNDING SKIN LOWER AFT SIDE. REPAIRED PER SRM 63-41-11. OK TO CONTINUE. (8149048)SDR DALA2025111108246Frame · damagedFRAME 64 FWD SIDE RT SIDE BRACKET FOR SKIN SUPPORT U-CHANNEL GOUGED AT FWD FLANGE. REPLACED PER SRM 53-11. (1297634)SDR DALA2025111108241Bracket · damagedTOOLING DAMAGE ON BRACKET AFT SIDE OF FRAME 62 JUST INBOARD OF S2. REPLACED THE BRACKET IAW SRM 53-11 AND DRAWING F5349104243. (1297739)SDR DALA2025111108224Oxygen Mask · unwanted deployOXYGEN MASKS AT 14DEF DEPLOYED, ONE MASK. LANYARD WAS PULLED AND OXYGEN WAS FLOWING. OXYGEN GEN DID NOT ACTIVATE, VERIFIED BY TEMP & ARMING PIN STILL INSTALLED. RESTOWED MASKS AT 14DEF IAW AMM 35-21. OK FOR SVC. (LP: 7997714)SDR DALA2025111108223Radome · delaminatedDURING BIRDSTRIKE INSPECTION FOUD DELAMINATION & BUBBLE ON THE INSIDE OF RADOME NOSE. REMOVED NOSE RADOME IAW AMM 53-15. INSTALLED RADOME IAW AMM 53-15-11. OK FOR SVC. (LP: 7726841)SDR DALA2025111108222Antenna · corrodedSHIP 3272 DISC: DURING BIRD STRIKE INSPECTION, FOUND CORROSION DMG ON WEATHER RADAR ANTENNA. R & R WEATHER RADAR ANTENNA ASSEMBLY PER AMM 34-41. OPS CHKD. PERFORMED SYS TEST PER A320 AMM 34-41-00-730 -001-A. OPS CHECK GOOD. NO FAULTS, ACFT OK FOR SVC. (LP: 77SDR 2025FA0000752Probe · faultedDURING START UP PILOT REPORTED POSSIBLE OVER TEMP OF ENGINE. AFTER FURTHER INSPECTION FOUND A BAD TEMP PROBE.SDR DALA2025111008208Access Panel · erodedEROSION ACCESS PANEL 191DB AT LOWER FUSELAGE. COMPLIED WITH ER/A 629770-14. (1296589).SDR DALA2025111008207Door Frame · crackedCRACK INDICATION FOUND ON FRAME 20 LH DOUBLE JOGGLE AREA HOLE 6 DOOR STOP FITTING 7. CORRECTIVE ACTION: COMPLIED WITH ER/A 629422-14AD. (1296575).SDR DALA2025111008219Shutoff Valve · bypassingDECLARED EMERGENCY AND DIVERTED TO ONT DUE TO FLT CONTROL 'B' LOW PRESSURE LIGHT ILLUMINATED. FOUND SYSTEM 'B' FLIGHT CONTROL SHUTOFF VALVE BYPASSING. REPLACED SAME. OPS CHECK GOOD.SDR GTIA2025111039173Megaphone · inoperativeMEGAPHONE INOP-REMOVED AND REPLACED MEGAPHONE PER A321 CEO EMERGENCY EQUIPMENT LAYOUT.SDR IPXA2025111093190Elec Connector · damagedAIR TURN BACK DUE TO RIGHT ENG TAI INOP LIGHT & EICAS MSG. ENG. A/I CHECKLIST WAS RUN W/NO RELIEF. ICING CONDITIONS AT DESTINATION THIS OCCURRED ON CLIMB-OUT. REPLACED CONNECTOR D1318 FOR ENG ANTI-ICE VALVE IRW B757 SWPM 20-60-03. REVERSED DMP 30-21-1-1. PERFSDR DALA2025111008184Bottle · low pressureL4 DOOR PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8023086)SDR 2025F00269Isolation Valve · faultedDURING CRUISE CREW HEARD A SMALL MUFFLED POP. IN A FEW SECONDS, GOT A BAGGAGE ALTITUDE CAS MESSAGE. CREW STARTED TO DISCUSS CAS MESSAGE WHILE NOTICING CABIN ALTITUDE WAS RISING PAST 8600. CO PILOT REACHED FOR QRH AND NOTICED HE STARTED TO FEEL A LITTLE LIGHT HSDR DALA2025111008159Floor Support · corrodedCORROSION IN INTERCOSTAL BTW STA 1520 TO STA 1540 RBL2.9 AT AFT CARGO COMPARTMENT. CORROSION LEVEL 2: INTERCOSTAL BTW STA 1520 TO STA 1540 RBL2.9 AT AFT CARGO COMPARTMENT.WAS FABRICATED PER B757-300 DWG 146N8401 REV. B. AND REPLACED PER B757-300 SRM 51-40-02-SDR AALA202511102428Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR ASSIST BOTTLE REQUIRES SERVICING. MAINTENANCE SERVICED R1 DOOR DAMPER PER AMM 52-10-00.SDR JGVR20251110003Skin · corrodedMECHANICALLY REMOVED CORROSION LOCATED ON RH VERTICAL STABILIZER SKIN, JUST FORWARD OF ACCESS PANEL 341BR PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION, CLEANED, TREATED AND PRIMED AREAS PER NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR JGVR20251110002Skin · corrodedBLENDED 7 AREAS OF CORROSION PLUS 1 ADDITIONAL AREA LOCATED ON RH UPPER WING SKIN AT WS 294 TO THE WING TIP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. CLEANED, TREATED AND PRIMED AREAS NETJETS REQUEST FOR TECHNICAL SERVICES REPORT.SDR JGVR20251110001Skin · corrodedMECHANICALLY BLENDED 1 AREA OF CORROSION LOCATED ON E-EXIT EXTERIOR SKIN LOCATED ON INNER EDGE PERIMETER OF CONTOUR RINGS, LOWER AREA OF E-EXIT PERFORMED NDT AND FOUND BLEND TO BE WITHIN LIMITS, CLEANED, TREATED AND PRIMED BLENDED AREA IAW TEXTRON ENGINEERING SDR 2025F00268Skin · corrodedFOUND 43 AREAS OF CORROSION UNDER AFT BELLY PANEL 316CBC. MECHANICALLY REMOVED CORROSION WHERE 36 NUTPLATES WERE REMOVED AND 4 ADDITIONAL AREAS IN BAY 316CBC IAW SRM 51-70-03. FOUND CORROSION BLENDS TO BE BEYOND LIMITS IAW SRM 51-70-03 EXCEEDING .002" OF MATERSDR CALA2025111011029Switch · out of positionVMO GEAR DOWN MEMO MSGS DISPLAYED ON UPPER EICAS FOUND THE ALTERNATE GEAR DOWN DISPATCH SWITCH IN THE VMO POSITION, PLACED BACK TO NORMAL POSITION, MEMO MSG CLEARED. REF FIM 31-51 TASK 957.SDR CALA2025111011028Limit Switch · abnormalCREW REPORTS ALL LAVS NOT FLUSHING IN AIR, AVIATAR FAULT LOG REPORTS LIQUID LEVEL TRANSMITTER (40MG) AND LIQUID LEVEL SENSOR (41MG) FAULTS ON PREVIOUS LEG, ALSO ON CFDS LAST LEG REPORT. REF TSM 38-31-00-810-844-A, SUSPECT CLOG IN LLT LINE OR BAD TRANSMITTER SDR CALA2025110911008Battery · inoperativeEMERGENCY LIGHTS TURNING ON DURING FLIGHT AT SEATS 45D&G. AHM & CMCF ALSO SHOWS MMSG 33-12116 & 32-12127. FEW RESET ATTEMPTS HAVE BEEN MADE STILL HITTING. DUE TO HISTORY NEED TO REPLACE THE FOLLOWING 3 WELLS UNIT & LOAD/CHECK CORRECT SOFTWERE IS INSTALLED. FOSDR JR2R20251110472Skin · chafedLEFT HAND WING LEADING EDGE PANEL, ABOVE PYLON, HAS A PREVIOUS REPAIR CHAFED OUT OF LIMITS. REPAIREDSDR 2026F00198Cylinder · damagedORIGINAL INSTALL DATE 8-28-2023. NEW CYLINDERS REMOVED AT 434HRS BY MECHANIC DUE TO RING FLUTTER, RING CHATTER, WASHBOARDING. INCONSISTENT METAL WEAR PATTERN ON THE NITRIDE BORE. DISCOVERED BY BORESCOPE AT 100HR INSPECTION. MANUFACTURER REPLACED CYLINDERS WITHSDR REXA2026051200573Angle · corrodedAFTER KICKPLATE ANGLE REMOVAL, CORROSION ON AFT CAP AND MID CAP ANGLE WAS FOUND MID CAP ANGLE WAS REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01, CRJ-900 SRM 51-41-04-001-001-A01 AND AFT CAP WAS INSTALLED UNDER NRC 178 IN REFERENCE TO WIP 14.SDR SWIA2026030275402Hinge · gougedALL 27 LUGS ON PAX DOOR HINGE HAVE GOUGES/CHAFE DAMAGE (PAX DOOR SIDE) BLENDED AND EVALUATED AREA OF 27 LUGS ON PAX DOOR HINGE, FOUND TO BE WITHIN LIMITS IAW REO 670-52-11-511, REV -E, SRM 51-21-11, 51-25-06, 51-25-16.SDR DALA2026030201405Spinner · contaminatedON TAKEOFF COCKPIT HAD DIRTY SOCK SMELL BUT MASKED BY TYPE I FLUID THAT HAD JUST BEEN APPLIED. NO SMELL ANYWHERE ELSE. SMELL RETURNED WITH THRUST REVERSE APPLICATION. DISSIAPATED WITH APU USE. INSPECTED BOTH ENG INLETS , PACK INLETS AND APU INLETS NO EVIDENCE SDR AALA202601148998Threshold Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB FROM BS 794 TO BS 847, AT S25R, AT RBL 22. REPLACED WEB PER PER AARD 51-00-05-1.SDR SWIA20260112109Floor Support · corrodedLBL9 FLOOR BEAM IS CORRODED BETWEEN F.S. 409 TO F.S 409+128. REMOVED, FABRICATED NEW AND INSTALLED NEW FLOOR BEAM CAP AT LBL 9, FS409 TO FS409+128 IAW REO 601R-53-31-1359 REV - -, DATED 2025-11-17. SEE CONTINUATION CARD FOR DETAILS OF WORK PERFORMED. COMPLSDR SWI2026F00046Floor Support · corrodedRBL 9 FLOOR SUPPORT IS CORRODED BETWEEN F.S. 409 TO F.S. 409+128. REPLACED RBL 9 FLOOR BEAM CAP AT FS 409 - FS 409+128 IAW REO 601R-53-31-1358 REV --. COMPLETED MAJOR REPAIR TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337. NO WEIGHT CHANGE NOTEDSDR SWAA2025121843415Battery Pack · no testBATTERY PACK M1675 FAILED A CAPACITY CHECK. REMOVED & REPLACED BATTERY PACK M1675 IAW AMM 33-51-06-960-805. TEST WILL BE COMPLET ON TASK CARD TTG8Q018RYAS.SDR SWAA2025121743416Battery Pack · no testBATTERY PACK M1670 FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK M1670 IAW AMM 33-51-06-960-805. TEST WILL BE COMPLET ON TASK CARD TTG8Q018RYAS.SDR SWAA2025121743417Battery Pack · no testBATTERY PACK M1669 FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK M1669 IAW AMM 33-51-06-960-805. TEST WILL BE COMPLET ON TASK CARD TTG8Q018RYAS.SDR SWAA2025121533215Support Angle · crackedCRACKED SUPPORT ANGLE BS 663.75 AND LBL 42. PERFORMED PERMANENT REPAIR ON SUPPORT ANGLE IAW SRM 57-10-10-2R-5, REPAIR 5. CERTIFIED RII MAJOR REPAIR WORK PERFORMED.SDR SWAA2025121546413Skin · crackedCRACK INDICATION FOUND ON RT HORIZONTAL STAB, LOWER IN-SPAR SKIN AT HSS 193.90, RIB, 9 INCH REAR SPAR IN SIDE OF RIB. CRACK LENGTH = 1.000 INCH. PERFORMED A REPAIR IAW SRM 55-10-01-2R-11, REPAIR 11.SDR SWAA2025121533441Skin · crackedCRACK INDICATION FOUND ON RT HORIZONTAL STAB LOWER IN-SPAR SKIN AT HSS 193.90, RIB, 9 INCHES REAR SPAR INSIDE OF RIB. CRACK LENGTH = 1.000 INCH. PERFORMED REPAIR IAW SRM 55-10-01-2R-11, REPAIR 11.SDR SWAA2025121533437Angle · corrodedCORROSION ANGLE LOCATED ON UPPER MAIN SILL AT LEVEL BS 827, S18R, WL 200 IN THE AFT CARGO BAY. REPLACED ANGLE LOCATED ON UPPER MAIN SILL IAW SRM 51-10-02, SRM 51-40-02, AND DWG 146A8313, SHEET 2, REV-.SDR SWAA2025121533439Strap · corrodedCORROSION STRAP LOCATED BTW BS 787 - 794.3, S25R - 26R, WL 156 IN THEAFT CARGO BAY. REPLACED STRAP & FASTENERS LOCATED IAW SRM 51-40-02-0G-0, AND DWG 146A0081, SHEET 37, REV -.SDR SWAA2025121533438Sill Drain · corrodedCORROSION LOWER SILL LOCATED BTW BS 794.3 - 847, RBL 22, WL 156 IN THE AFT CARGO BAY. REPLACED LOWER SILL AND FASTENERS IAW SRM 51-40-02, & DWG 146A8340, SHEET 28, REV -.SDR SWAA2025121533216Plate · crackedCRACKED CORRUGATED PLATE, TRAILING EDGE IRSS 215, RT WING. REPLACED THE CORRUGATED PLATE AND FASTENERS IAW SRM 51-10-02-0G-0, PARAGRAPH 9, AND SRM 51-40-02-0G-0. LENGTH OF CRACK: 1.117 INCHES.SDR SWAA2025121533213Web · crackedCRACKED WEB TRAILING EDGE FIXED PANEL ORSS 271, LT WING. REPLACED THE WEB AND FASTENERS IAW SRM-51-10-02-0G-0, ITEM 9, SRM-51-40-02-0G, & DWG 115A2512, SHEET 16, REV-.SDR SWAA2025121033223Bracket · crackedCRACK ACCESS PANEL 651FB TRAILING EDGE BRACKET RT WING. REPLACED BRACKET ON ACCESS PANEL 651FB TRAILING EDGE BRACKET RT WING IAW SRM 51-40-02 AND SRM 51-10-02. MEASUREMENT OF CRACK: L=0.895".SDR SWAA2025121033220Bracket · crackedCRACK ACCESS PANEL 551FB TRAILING EDGE BRACKET LT WING. REPLACED BRACKET ON ACCESS PANEL 551FB TRAILING EDGE LT WING IAW SRM 51-40-02, SRM 51-20-01, AND DWG 115A2710, SHEET 9, REV A.SDR SWAA2025121033221Access Panel · damagedELONGATED HOLE ACCESS PANEL 651FB TRAILING EDGE LOCATED ON STIFFENER RT WING. REPLACED BEAM ON ACCESS PANEL 651FB TRAILING EDGE LOCATED ON STIFFENER RT WING IAW SRM 51-40-02 AND SRM 51-10-02, PARAGRAPH 9, AND DWG 115A2710 SHEET 9, REV A.SDR SWAA2025121033222Support Angle · crackedCRACK ACCESS PANEL 551GB TRAILING EDGE SUPPORT ANGLE LT WING. REPLACED SUPPORT ANGLE ON ACCESS PANEL 551GB TRAILING EDGE IAW SRM 51-40-02; SRM 51-10-02, AND DWG 115A2714 SHEET:10 REV-.SDR KCSA20251209073Battery Pack · inoperativeEMERGENCY LIGHT STA 322 BL0 SUPERNUMERARY AREA DOES NOT STAY ON, COMES ON FOR ONLY .5 SECONDS. R & R EMERGENCY LIGHT POWER SUPPLY BATTERY PACK M23424 IAW AMM 33-51-06, OPS CHECK GOOD.SDR SWAA2025120833407Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 727B - 847, LBL 21, WL 155. FOUND TO BE OUT OF LIMITS. REMOVED, FABRICATED, AND INSTALLED A NEW FLOOR TO SIDEWALL SUPPORT AT BS 727 TO 847, & SPLICE AT BS 727E+9.8, LBL 21, WL 155 IAW SRM 53-00-53-1ASDR SWAA2025120833412Support · corrodedCORROSION ON AFT CARGO BAY SHEILD SUPPORT AT BS 847 - 867, RBL 24, WL 155. REMOVED AND REPLACED AFT CARGO BAY SHEILD SUPPORT IAW SRM 50-40-02 & DWG 1460081.SDR SWAA2025120833411Support · corrodedCORROSION ON AFT CARGO BAY SHEILD SUPPORT AT BS 767 - 794, RBL 24, WL 155. REMOVED AND REPLACED THE SHIELD SUPPORT IAW DWG 146A0081, REV A, AND SRM 51-40-02.