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 HNAA2025112500795Seat Track · corrodedLEFT LOWER SEAT TRACK NR 4 HAS VARIOUS CORROSION SPOTS. R & R LT LOWER SEAT TRACK NR 4 IAW AMM 53-01-06.SDR HNAA2025112500794Seat Track · corrodedLEFT UPPER SEAT TRACK NR 5 HAS MULTIPLE CORROSION SPOTS. REMOVED AND REPLACED LT OTBD SEAT TRACK NR 5 IAW AMM 53-01-06.SDR HNAA2025112400791Skin · dentedDENT ON LWR SKIN AT FR80-81 BTW STR17-19R. REPAIRED DENT IAW ETD2025-145-931822 AND EO1-53-25-0421SDR SWAA2025111929796Scuff Plate · crackedCRACK ON SCUFF PLATE FWD SERVICE DOOR. REPAIRED THE CENTER SCUFF PLATE FWD SERVICE DOOR IAW SRM 53-10-15-2R-2 REPAIR 2. PARAGRAPH 4. B; FIGURE 203. REFER TO BAC 5975.SDR R61A2025111900512Stringer · corrodedWHILE IN HEAVY CHECK - STR 21L HAS EVIDENCE OF CORROSION FROM FR 88 TO 91. REPAIRED STR 21L FROM FR 88 TO 91 BY INSTALLING SPLICE AND REPAIR FILLER REF EMB SRM 51-40-08 AND ETD2020-170-007474SDR R61A2025111900511Skin · crackedWHILE IN HEAVY CHECK - LH WING HAS 1EA CRACK ON LOWER SKIN TRAILING EDGE AT MLG CUTOUT BETWEEN RIBS 3 AND 3A AS MARKED. PERFORMED REPAIR ON LH WING 1EA CRACK ON LOWER SKIN TRAILING EDGE AT MLG CUTOUT BETWEEN RIBS 3 AND 3A AS MARKED AS PER ETD--2025-170-931384SDR AALA202511194180Splice · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON UPPER SPLICE O/B SIDE ON LOWER SILL AT LEVEL FR66 STRG 23L. MEASURES OF CORROSION ARE: L= 0.525 INCH, W= 0.260 INCH, D= 0.018 INCH. MAINTENACE REPLACED UPPER SPLICE OUTBOARD POSITION LOCATED ON LOWER SILL ON FR66 AT LEVEL OFSDR R61A2025111900510Skin · crackedWHILE IN HEAVY CHECK - CRACKED SKIN UNDER LH SLAT #2 INBD TRACK CUTOUT TOP SIDE. REPAIRED A CRACK ABOVE THE L/H FIXED LEADING EDGE AT THE INBOARD SLAT TRACK CUT-OUT OF SLAT #2 BY CUTTING THE DAMAGE OUT AND INSTALLING A FABRICATED INTERNAL DOUBLER. IAW ETD2025SDR AALA202511183097Splice · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER SPLICE INBD SIDE ON LOWER SILL AT LEVEL OF FR66 STRG 23L. MEASURES OF CORROSION: L= 0.950 IN, W= 0.550 IN, D= 0.025 IN. MAINTENANCE REPLACED UPPER SPLICE, INBOARD POSITION LOCATED ON LOWER SILL ON FR 66 AT LEVELSDR SCNA20251118442Skin · crackedCRACK ON HOLE #7 AT 12 O´CLOCK POSITION, WING INBOARD LEADING EDGE SKIN PANEL FASTENER, KRAS 206, AT WING LEFT IN REF. CARD ENG-57SCA--11486. CRACK ON HOLE #7 AT 12 O´CLOCK POSITION, WING INBOARD LEADING EDGE SKIN PANEL FASTENER, KRAS 206, AT WING LEFT WAS RESDR SWAA2025111730034Plate · crackedLEFT WING T/E WIGGLE PLATE COMMON TO PANEL 551EB ON THE I/B SIDE IS CRACKED. REMOVED AND REPLACED LEFT WING T/E WIGGLE PLATE COMMON TO PANEL 551EB ON THE I/B SIDE IAW SRM 51-40-02-0G-0, RESTORED EXTERNAL FINISH ON LOWER SURFACE OF LT WING, AROUND THE FASTENESDR SWAA2025111730036Support Beam · crackedLEFT WING T/E AFT PANEL SUPPORT BEAM COMMON TO PANEL 561AB IS CRACKED. REMOVED AND REPLACED LEFT WING T/E AFT PANEL SUPPORT BEAM COMMON TO PANEL 561AB IAW SRM 51-40-02-0G-0 AND AMM 20-50-11-910-801.SDR SWAA2025111730037Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651GB ON THE INBD SIDE IS CRACKED. REMOVED AND REPLACED RIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651GB ON THE I/B SIDE. IAW SRM-51-40-02-0G-0.SDR SWAA2025111730038Plate · crackedRIGHT WING T/E WIGGLE PLATE COMMON TO PANEL 651EB ON THE I/B SIDE IS CRACKED. REMOVED AND REPLACED RIGHT-WING T/E WIGGLE PLATE P/N 115A2781-4 COMMON TO PANEL 651EB; IAW SRM 51-40-02 AND DWG#115A2781 REV B.SDR SWAA2025111730033Support Angle · crackedLEFT WING FIXED T/E PANEL JUST O/B OF THE NR 6 SPOILER LOWER SUPPORT ANGLE CRACKED. REMOVED AND REPLACED LEFT WING FIXED T/E PANEL JUST O/B OF THE #6 SPOILER LOWER SUPPORT ANGLE.<BR>IAW SRM 51-40-02-0G-0.SDR SWAA2025111129876Lamp · inoperativeLEFT EMERGENCY EXIT DOOR SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-03-960-801 AND REMOVED AND REPLACED FUSE TO RH EMERGENCY EXIT DOOR SIDEWALL LIGHT AND PERFORMED GOOD OPS TEST IAW AMM 33-21-00-960-803.SDR SWAA2025111129921Cargo Track · crackedCRACKED CARGO TRACK, RBL 13.84, BTW BS 727D - 787. PERFORMED A PERMANENT REPAIR ON THE CARGO TRACK IAW SRM 53-00-53-2R-3, REPAIR 3, PARAGRAPH 2 A, FIGURE 203, ALTERNATIVE 1 & 2.SDR FXTA20251029001Cylinder · leakingPILOT FELT STRONG LEFT RUDDER PRESSURE ON TWO CONSECUTIVE TAKE OFFSSDR ASMF2025110800295Engine · fault messageDURING TAXI, ENGINE CONTROL LIGHT ILLUMINATES FAULT CODE 732 301 52.SDR DALA2025110708147Girt Bar · detachedSHIP 9504 DOOR 1R GIRT BAR DETACHED FROM SLIDE MECHANISM. CORRECTIVE ACTION: RESECURED PER B717 AMM 25-61. A/C OK FOR SERVICE. (7954750)SDR DALA2025110708139Skin · crackedCRACK SKIN INSIDE OF ACCESS PANEL 370BL FWD /UPPER CORNER AT VERTICAL STABILIZER DORSAL FIN. CORRECTIVE ACTION: UPPER CORNER AT VERTICAL STABILIZER DORSAL FIN WAS REPAIRED PER B717 SRM 55-30-01 (1278507)SDR SWIA2025110600029Window Post · crackedCRACK ON RT COCKPIT WINDSHIELD POST DETERMINED TO BE OUT OF LIMITS AND SIDE POST REQUIRES REPLACEMENT. THIS IS CLASSIFIED AS A MAJOR REPAIR. REMOVED AND REPLACED THE RT WINDSHIELD POST IAW SRM 51-40-11, SRM 51-42-06, SRM 51-42-21, SRM 51-45-00, SRM 51-25-06, SDR DALA2025110608102Access Panel · delaminatedFOUND RH WING O/B FLAP UPPER ACCESS PANEL 666KT AT 62" FROM I/B SIDE DELAMILATION. RH WING O/B FLAP UPPER ACCESS PANEL 666KT AT 62" FROM I/B SIDE REPAIRED AS PER PRI REV.0 OF ER/A 629898-14. (1277913)SDR DALA2025110608101Web · crackedFOUND NO.1 PYLON AFT UPPER WEB AT NSTA 290 CRACK. THE CLOSEOUT ANGLE REMOVED AND REPLACED AS PER B767-400 SRM 51-40-02 REV 76.00 AUG-29-2025. REFER TO ER/A 629817-14 (1277534)SDR DALA2025110608100Skin · crackedFUSELAGE SKIN AT STA1654.5 S4L+3 FOUND CRACK. THE CRACK FUSELAGE SKIN AT STA 1654.5 S4L+3 REPAIRED AS PER PRI 629901-14 (1277526)SDR DALA2025110608099Seat Track · corrodedCABIN RH SEAT TRACKS FOUND CORROSION AT STA1208 TO STA1428,RBL88.5. THE CORROSION ON SEAT TRACK FROM STA 1208 TO STA 1428 RBL 88.5 REPAIRED AS PER 629816-14 (1277465)SDR CALA2025110610950Floor Support · corrodedFWD WET AREA FLOOR SUPPORT CORRODED BETWEEN BS 294.5 - 312, RBL 12. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0 AND DWG 141A5410 SHEET 8.SDR CALA2025110610948Skin · crackedRIGHT WING LEADING EDGE SLAT NR 5 LOWER SKIN CRACKED AT ACTUATOR FASTENER HOLE. ACCOMPLISHED REPAIR AT RT WING L/E SLAT NR 5 LOWER SKIN, DOUBLER REPAIR IAW SRM 57-42-01-2R-8, STEP 4.H.SDR AALA202511058097Strip · debondedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING OUTBOARD AILERON TRAILING EDGE METALLIC STRIP PEELING OFF THE INBOARD SIDE. REPLACED AILERON PER AMM 27-14-41.SDR 2025FA0000741Control Cable · brokenELEVATOR CONTROL CABLE SEPARATED AT THE TURNBUCKLE DURING TAKEOFF ROLL; THE TAKEOFF WAS ABORTED WHEN A (NOISE) BANG WAS HEARD AND THE AIRCRAFT NOSE DROPPED. THE CABLE ATTACHMENT BROKE AS IT ENTERED THE TURNBUCKLE AND WAS ONLY HELD TOGETHER BY THE SAFETY WIRE. SDR DALA2025110508066Heater · failedSMOKE SEEN & BURNT ELECTRICAL ODOR IN FWD GALLEY IN CRUISE. COMPLETED SMOKE, FIRE, OR FUMES CHECKLIST 8.6 IN QRH. SMOKE & FUME ODOR DISSAPATED. PERFORMED OPS TEST OF FWD DOOR AREA HEATER IAW AMM 21-45. GOT AN ODOR FROM DOOR HEATER OUTLET. SUSPECT FWD DOOR ASDR AALA202511040653Air Filter · contaminatedAIRCRAFT WAS GROUNDED: DIRTY SOCK SMELL ON CLIMB OUT AND LANDING IN THE CABIN AND COCKPIT. COMPLIED WITH JOB CARD 08L00021001 AND FOUND NO DEFECTS AT HIS TIME WITH EITHER ACM, RECIRCULATING FANS, HEAT EXCHANGERS OR CONDENSERS. CHANGED RECIRCULATING FILTERS ASDR AALA202511044014Door · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. SECURED TRIM ON FORWARD LAVATORY. PER AMM 20-30-11.SDR IPXA2025103113680Floor Panel · damagedFLOOR PANEL 132AH IS BROKEN IN HALF. FLOOR PANEL 132AH FAB COMPLETED IAW SREO-16407-REQ002 ((APPX C) A300 FWD/AFT LOWER CARGO COMPARTMENT FLOOR PANEL FABRICATION (SREO)). REVIEWEDSDR AALA202511030755Web · crackedAIRCRAFT IN BASE MAINTENANCE: 1.5" CRACK AT FRAME 68, STRINGER 22R. MAINTENANCE CUT OUT WEB AND INSTALLED NESTED FITTING IAW EA 369221 & DRAWING R3534222.SDR SWAA2025110330138Sign · looseOVERWING EMERGENCY EXIT ROW CEILING LIGHT ASSEMBLY LOOSE. SECURED THE OVERWING EMERGENCY EXIT SIGN IAW AMM 33-51-01.SDR SWAA2025110329991Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT LT SIDE AFT EMERGENCY EXIT DOOR LOWER SIDE. RELAMPED AND PERFORMED GOOD TEST OF EMERGENCY LIGHT AT LH SIDE AFT EMERGENCY EXIT DOOR LOWER SIDE IAW AMM 33-51-01-960-801.SDR DALA2025110308036Reservoir · inoperativeDURING SERVICE CHK, WHILE PERFORMING THE EMERGENCY ESCAPE SQUIB TEST 2, THE LEFT BOTTLE INDICATOR DID NOT COME ON. T/S BOTH LIGHTS ILLUMINATE WHEN DEPRESSED, PUSHING TEST 2 SWITCH ON SQUIB TEST PANEL, ONLY R ILLUMINATES. PER FIM R/R SQUIB TEST PANEL, M32. L SDR DALA2025110308024Bulkhead · crackedFUSELAGE BULKHEAD AFT OUTER CHORD CRACK AT STA 1809 AND S-12L LOWER. THE FUSELAGE BULKHEAD AFT OUTER CHORD REMOVED AND REPLACED AS PER ER/A 629814-14 REV ORIGINAL PRI REV 0, COMPARED AND COMPLIED WITH ER/A 629814 REV ORIGINAL. NO DEVIATION. (1277521)SDR IPXA2025103116091Web · crackedNR 1 PYLON AFT MEMBER BETWEEN RIB 18 AND RIB 21 CRACKED. JP-110. REMOVED AND REPLACED AFT MEMBER (WEB) IAW A300-600 SRM 51-40-21.SDR GTIA2025110339161Hydraulic System · lowHYD Y RSVR LO LEVEL ECAM.-FOLLOW TSM 29-13-00-810-801-A. FOUND YLW RSVR LOW. SERVICE AS REQ NO LEAKS NOTED AS PER AMM 29-00-00. OPS CK GGOD, A/C OK TO CONT SERV.SDR DXTA2025110305492Battery Pack · malfunctionedTAXIING FOR TAKEOFF, ALL EMERGENCY LIGHTS STARTED FLICKERING. WHEN EMERGENCY SWITCH IN THE OFF POSITION, EMERGENCY LIGHTS SOMETIMES ON & SOMETIMES OFF. REMOVED NR 1 EMERGENCY BATTERY DUE TO LIGHTS FLICKER AND INSTALLED A REPAIRED ASSY IAW AMM 33-52-01. ALL CHESDR CALA2025110310838Wire · shortedL2 DOOR, EMERGENCY EXIT LIGHT SIGN DOES NOT ILLUMINATE. M1672 BATTERY PACK REMOVED AND DISCONNECTED FROM D10744. AFT GALLEY CEILING LIGHT ASSEMBLY(M01678) REMOVED AND DISCONNECTED FROM D11460. D40100P AND J DISCONNECTED. D40044 P & J DISCONNECTED. TROUBLESHOOTSDR CALA2025110210799Oxygen Mask · no testRIGHT AFT GALLEY MANUAL OXYGEN DEPLOYMENT DROP FAILED. RT AFT GALLEY OXYGEN BOX DOOR AND OXYGEN PASSENGER RIGHT CIRCUIT BREAKER IAW AMM 35-22-00-700-802. RT AFT GALLEY MANUAL OXYGEN OPS TESTED GOOD IAW AMM 35-22-00-700-802.SDR CALA2025110210797Oxygen Mask · no testLEFT SEAT 34 MANUAL OXYGEN DEPLOYMENT DROP FAILED. SEAT 34ABC OXYGEN BOX DOOR ON PSU AND OXY INDICATOR AND OXYGEN PASSENGER LEFT CIRCUIT BREAKERS IAW AMM 35-22-00 -700-802. MANUAL OXYGEN DEPLOY OPS TEST GOOD IAW AMM 35-22-00-700-802.SDR CALA2025110210795Oxygen Mask · no testRIGHT SEAT 1 MANUAL OXYGEN DEPLOYMENT DROP FAILED. RECYCLED SEAT 1EF O2 BOX DOOR ON PSU AND O2 IND AND O2 PASSENGER RH CB IAW AMM 35-22-00-700-802. MANUAL O2 MASK OPS CHECK GOOD IAW B737-800 AMM 35-22-00-700-802.SDR CALA2025110210793Floor Support · corrodedFWD WET AREA FLOOR SUPPORT CORRODED BETWEEN BS 312 - 328 LBL-11. REMOVED AND REPLACED INERCOSTAL AT FWD WET AREA FLOOR STRUCTURE WITH BETWEEN BS 312 - 328 LBL 11 IAW DRAWING 141A5400 & SRM 51-40-02-0G-0.SDR AALA202510319525Wire · faultyAIRCRAFT WAS GROUNDED: GEAR INDICATION SYSTEM STATUS MESSAGE. PERFORMED TEMPORARY WIRE REPAIR. PER AMM 20-10-07-02A-663A AND SWPM 20-10-11.SDR QXEA2025103100334Valve · damagedDURING REPLACEMENT OF THE FILL DRAIN VALVE FAOUND THE WATER HEATER VALVE TO BE DAMAGED AND THE INSULATION BURNT. INSTALLED NEW WATER HEATER FILL VALVE IAW E175 AMM 30-71-05-400-801-A AND REPAIRED INSULATION IAW E175 AMM 20-15-300-801-A. RETURNED TO SERVICE.SDR DALA2025103107995Slip Joint · leakingATB- RETURNED ATL DUE TO LEFT ENGINE OVERHEAT ON CLIMB OUT. CORRECTIVE ACTION: FOUND ECS BLEED DUCT SLIP JOINT LEAKING. REPLACED DUCT AND CLAMP. ALSO FOUND PRESSURE SENSE LINE TO BAR BROKEN. REPLACED SAME. RAN ENGINE TO TAKE OFF POWER. NO OVERHEAT WARNING. OPS