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 AALA202506190172Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R, REPLACED SHEAR PLATE PER SRM 51-72-11.SDR DXTA2025061903943Battery · faultedDURING FLIGHT WE NOTICED THE EMER LIGHTS WERE ILLUMINATED, THE SWITCH WAS IN THE ARM NOT ON POSITION. REPLACED EMERGENCY BATTERY. PERFORMED CHARGE AND OPS CHECK OF BATTERY. OPS CHECK GOOD ALL WORK PERFORMED IN REF TO EMB 505AMM 32-52-00, 32-52-01SDR DXTA2025061903960Warning Light · false activationCHECK DOORS AND CABIN DOOR OPEN LIGHT IN FLIGHT. MAINTAINED PRESSURIZATION AS EXPECTED. COULD NOT VERIFY DOOR PIN POSITION ON GROUND DUE TO RAIN, MISSED, AND FOG IN INDICATOR WINDOW. MAIN DOOR HANDLE HAS A BIT OF A CATCH WHEN CLOSING. RAN APPROPRIATE QRH, SDR DXTA2025061903959Bolt · brokenTRYING TO RAISE DOOR AND HARDWARE FELL OFF FROM THE MOTOR ROD AND DISCONNECTED THE TIE ROD TO THE DOOR. REPLACED HARDWARE IAW CE-680A AMM 52-15-10 PERFORMED OPS CHECK IAW CE-680A 52-10-00 NO DEFECTS NOTEDSDR DXTA2025061903953Handle · bindingMAIN CABIN DOOR HANDLE BECOMING MORE DIFFICULT TO STOW FROM INSIDE AIRCRAFT AFTER CLOSING. REQUIRES EXCESSIVE PULLING FORCE AND MULTIPLE PULLS TO FINALLY GET HANDLE TO STOW PROPERLY. PERFORMED FUNCTIONAL TEST IAW AMM 52-11-00 OPS CHECK GOOD NO DEFECTS NOTEDSDR SCNA20250619220Button · inoperativeDEFECT 788705: LEFT REAR LAV EMERGENCY CALL BUTTON INOP. - - RESOLUTION: RELAMPED LEFT REAR LAV CALL LIGHT.REF AMM 33-27-00. OK FOR SERVICE.SDR AALA202506198128Slide · low pressureAIRCRAFT WAS NOT GROUNDED: FOUND L1 DOOR NITROGEN PSI TO BELOW LIMITS PER PS RON. MAINTENANCE SERVICED L1 DOOR SLIDE PRESSURE PER PS W/C 26L00005005.SDR AALA202506197324Door Frame · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR EXTREMELY DIFFICULT TO OPEN IN FLIGHT. DOOR FEELS LIKE IT IS BINDING ON THE BOTTOM. FLIGHT CREW FOUND LOOSE SCREW AT COCKPIT DOOR. MAINTENANCE TIGHTENED COCKPIT DOOR JAM SCREWS AMM 52-10-00.SDR AALA202506191779Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 2F-1R LAV EMERGENCY LIGHT INOP. MAINTENANCE REPLACED DOME LIGHT IAW CMM 33-26-00.SDR AALA202506190619Light · inoperativeAIRCRAFT WAS NOT GROUNDED: 3F-1L LAV EMERGENCY LIGHT INOP. MAINTENANCE REPLACED DOME LIGHT IAW CMM 33-26-00.SDR SCNA20250619219Cover · brokenDEFECT 796445: EMERGENCY LIGHT COVER SIGN BROKEN AND FALLING OUT OF MOUNT. MC NOTIFIED DG 6199. - - RESOLUTION: REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-01-960-802. LIGHT OPS CK GOOD. A/C OK FOR SERVICE.SDR F3LA202506190250Slide Raft · failedFAULT HAPPENED DURING A SCHEDULED RON HEAVY CHECK. NO DELAY OCCURRED. LP537214 ITEM 2 R2 DOOR SLIDE IS FAILING EPSU TEST. REMOVED AND REPLACED R2 DOOR SLIDE REF AMM 25-62-44-400-007-A EPSU TEST GOOD, OPS TEST OF ARMING DEVICE GOOD, T/W F9TAB11495C CAL DUE 07SDR F3LA202506190249Slide Raft · failedFAULT HAPPENED DURING A SCHEDULED RON HEAVY CHECK. NO DELAY OCCURRED. LP537214 ITEM 1 L2 DOOR SLIDE IS FAILING EPSU TEST. REMOVED AND REPLACED L2 DOOR SLIDE (AFT SERVICE DOOR) REF AMM 25-62-44-400-007-A EPSU TEST GOOD. OPS TEST OF ARMING DEVICE GOOD, T/W F9TSDR DALA2025061904602Coffeemaker · odorSHIP 3238 DISC: APPROX 10 MIN AFTER TAKEOFF FA'S REPORTED ELECTRICAL SMELL IN BACK {ROWS 25-32} ODOR DISSIPATED WITHIN A FEW MINUTES. C/A: INSPECTED ENGINES AND APU NO SIGNS OF OIL. PERFORMED ENGINE AND APU PNEUMATIC RUN NO SIGN OF SMOKE SMELL. REMOVED AND REPSDR DALA2025061904595Stow Switch · faultedSHIP 3270 DISC: ON TAKEOFF, GOT REV 2 UNLOCK GOING THROUGH 40KTS @ FLEX 41. STOPPED THE AIRCRAFT NO FACTOR BRAKES 275/300 180/165. R & R #2 ENG THRUST REV HCU 4101KS. ALL TESTS OK. MCO/PLAC REMOVED. ATO - AT 45KTS DUE TO A #2 ENGINE THRUST REVERSER UNLOCKED MESDR MTNA20250616001Flex Hose · leakingDURING PREFLIGHT OF FLIGHT 7500 MYR-CAE WITH AIRCRAFT N810FX, IT WAS DISCOVERED THAT THE F/O OXYGEN MASK WAS LEAKING. MAC MAINTENANCE TROUBLESHOT THE ISSUE TO THE OXYGEN LINE.SDR 2025FA0000409Crankcase · crackedCASE CRACKED AT TOP BASE OF #2 CYLINDER, LEAKING OILSDR 21GA20250618012Winglet · damagedPERFORMED PERMANENT REPAIR TO RH WINGLET LIGHTNING STRIKE DAMAGE PER IAAC EO 21A-250530.SDR 2025FA0000408Oil Cooler · crackedWHILE PERFORMING AN OIL CHANGE, IT WAS DISCOVERED THE DIAGONAL STIFFENERS ON BOTH SIDES OF THE OIL COOLER WERE BROKEN AND HALF GONE. THE OIL COOLER WAS NOT LEAKING. THE OIL COOLER WAS REPLACED WITH NEW. INSTALLED PART NUMBER: 658767, SERIAL NUMBER: H22-12342-2SDR Y2PA2025061825006Skin Splice · corrodedDISCREPANCY: WHILE AT C-CHECK IN KBQK, STAMBAUGH AVIATION FOUND CORROSION ON THE L/H WING LOWER SURFACE AT STR. 17 (SKIN SPLICE) AND AT XCW 85. BLENDED OUT THE DAMAGED AREA, PERFORMED HFEC OPEN HOLE INSPECTION AND FABRICATED A REPAIR DOUBLER USING 2024T3 .12SDR 2025FA0000407Flex Coupling · brokenAN AIR TRACTOR AT802A WAS INVOLVED IN A TAKE-OFF INCIDENT, CAUSING SUBSTANTIAL DAMAGE. THE PIC LOOKED TO HIS LEFT AND RIGHT DURING TAKEOFF AND NOTICED THE FLAPS WERE RETRACTING UNCOMMANDED AFTER SELECTING 20 DEGREES FOR TAKEOFF. ASI DISCOVERED THAT THE FLAP ACSDR FDEA202506180990Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 241XFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 241XFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025.SDR FDEA202506180989Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252HFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252HFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180988Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252GFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252GFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180987Warning Light · false activationON A 10 MILE FINAL WITH THE GEAR DOWN, WE SELECTED FLAPS 25 AND GOT A MASTER CAUTION, LE SLAT DISAGREE LIGHT. WE ELECTED TO DO A GO AROUND AND SELECTED FLAPS 20 AND RAISED THE GEAR AND THE CAUTION LIGHT EXTINGUISHED. WE CAME BACK AROUND AND REATTEMPTED A SDR FDEA202506180986Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252DFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252DFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180985Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 251DFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 251DFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180984Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231RFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231RFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180983Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231QFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231QFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180982Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231JFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231JFF WAS REPAIRED IAW B767 SRM 53-00-50- 2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180981Floor Panel · puncturedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221DFF WITH PUNCTURE. MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221DFF WAS REPAIRED IAW B767 SRM 53-00- 50-2R PAR 4B FIG 201 SHEET 2 REV.92 APR-15-2025SDR FDEA202506180980Floorboard · damagedNR# 204: MAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221EFF DENTED, APPROXIMATELY STATION 400. GM44 FABRICATED NEW FLOORBOARD (PNL# 221EFF MPN: 141T5856-109) AT STA. 285-412 BETWEEN LBL 33 AND LBL 54.75 REF EA# H-5321-T0383793 P1 AND BOEING DRW# 141T5856-109 SDR FDEA202506180979Skin · corrodedUPON REMOVED FAIRING FOR EXISTING REPAIR EVALUATION ACCESS FOUND CORROSION AT RIGHT HAND FUSELAGE SKIN AT APPROXIMATE STATION 2160 LONGERON 12 RIGHT AREA. CORROSION REMOVED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-70-01-2R FIGURE 201 SHEET 3 REPAIR 3 ASDR R61A2025061800261Stringer · corrodedWHILE IN HEAVY CHECK - CORROSION ON STGR 19L FROM FR88-89. REPLACED STRINGER 19L SECTION BETWEEN FR89/90 TO FR80/81 PER ETD2025-170-922184.SDR R61A2025061800260Stringer · corrodedWHILE IN HEAVY CHECK - CORROSION ON 19 RIVETS ON STGR 29R OB BETWEEN FR78-79. REPLACED FASTENERS AND INSTALLED REPAIR PARTS PER ETD2025-170-922466-A.SDR R61A2025061800259Stringer · corrodedWHILE IN HEAVY CHECK - CORROSION ON STGR 23L FROM FR77-78. REPLACED STRINGER 23L SECTION BETWEEN FR73/74 IAW ETD2025-170-922414 & SRM 53-23-03.SDR R61A2025061800258Stringer · corrodedWHILE IN HEAVY CHECK - CORROSION ON STGR 23L FROM FR88-89. REPLACED STRINGER 23L SECTION BETWEEN FR83-90 IAW ETD2025-170-922175 & SRM 53-23-03.SDR R61A2025061800257Stringer · corrodedWHILE IN HEAVY CHECK - CORROSION ON STGR 22R & 22L AT FR80/81. PERFORMED SPLICE REPAIR STGR 22R & 22L BETWEEN FR80-84 IAW ETD2025-170-922403 & SRM 53-23-03 R02.SDR AALA202506182949Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS FLASHLIGHT AT LAVATORY L FAILED TO SHOW GREEN LIGHT FOR PUSH TO TEST. MAINTENANCE REPLACED BATTERY PACK AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER TASK CARD 26C00025003.SDR DALA2025061804581Oxygen Mask · leakingSHIP 3330 - ATB - DUE TO CREW OXYGEN LEAK. CORRECTIVE ACTION: REPLACED F/O MASK AND 2ND OBSERVERS MASK STORAGE BOX. OK FOR SERVICE. (7069062)SDR DALA2025061804582Compressor · stalledDIV- DIVERTED AND DECLARED EMERGENCY TO HNL DUE TO LEFT ENGINE COMPRESSOR STALLS ON TAKEOFF. CORRECTIVE ACTION: PERFORMED GVI WITH NO EVIDENCE OF BIRD INGESTIONS. REPLACED LEFT ENGINE.SDR REXA2026073001253Hinge Fitting · corrodedCORROSION WAS FOUND ON LT & RT NLG AFT DOOR UPPER FITTINGS AND CORROSION WAS FOUND ON RT HINGE FITTING OF NLG AFT DOOR IAW TASK CARD 900-32-710-902. LT AND RT NLG AFT DOOR UPPER FITTINGS AND RT HINGE FITTING OF NLG AFT DOOR WERE REPLACED IAW SRM 51-41-02-001-0SDR SWAA2025072982548Glowstrip · brokenBROKEN PHOTOLUMINESCENT STRIP LT SIDE AT PASSENGER CABIN (5 EA). GENERAL FAULT RESOLVED ON OTHER FAULT TTG8Q00AVU0B.SDR SWAA2025072982558Glowstrip · brokenBROKEN PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN ( 7 EA). GENERAL FAULT RESOLVED ON OTHER FAULT TTG8Q00AVU0B.SDR JJBA20250723087Fairing · corrodedCORROSION FOUND AROUND LH, RH EXTERNAL EMERGENCY LIGHTS ON FWD BODY FAIRING. FWD BODY FAIRING LIGHTS FROM FAIRING PLATE REMOVED, CORROSION REMOVED OUT OF LIMITS. FWD BODY FAIRING PLATE NEW DRILLED. FWD BODY FAIRING PLATE AND LIGHT EMERGENCY INSTALLED.SDR CALA2025072206837Pressure Web · crackedCENTER WING REAR SPAR VERTICAL PRESSURE WEB BETWEEN WL192.0 AND WL 200.6, 01 CRACK BETWEEN LBL 31.83/LBL 40.00 AND 01 CRACK BETWEEN LBL 40.00/LBL 45.64. (REF: AAR NR 1000038583)ESFR CREATED AND SUBMITTED. REPAIRED DAMAGE CRACK AT THE CENTER WING REAR SPAR VERTSDR SWAA2025072182790Stringer · crackedCRACK ON STRINGER 7L LOCATED BTW BS294.5 TO BS303.9 PASSENGER CABIN. PERFORMED PERMANENT REPAIR ON STRINGER 7 LOCATED BTW BS294.5 TO BS303.9 PASSENGER CABIN IAW SRM 53-00-03-2R-1 REPAIR 1.SDR SWAA2025072182789Rib · crackedCRACKS (2 E/A INBOARD AND 1 OUTBOARD ) INSPAR RIB 120.30 LOCATED ON WEB BTW UPPER CHORD AND FRONT SPAR FITTING AT RT HORIZONTAL STABILIZER. PERFORMED REPAIR ON INSPAR RIB 120.30 LOCATED ON WEB LOCATED RT HORIZONTAL STABILIZER IAW EA 25-155-01736 AND EA 25-155SDR SWAA2025072182793Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS277 AND STR10R PASSENGER CABIN. REPLACED TIE CLIP LOCATED BS277 AND STR10R PASSENGER CABIN IAW SRM 51-40-02 AND DRAWING 141A1110 SHEET 18; REV- .SDR SWAA2025072186072Access Panel · elongatedELONGATED HOLE ON ACCESS PANEL 551BB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 551BB TRAILING EDGE AT LT WING IAW SRM 51-70-04-2R-9 REPAIR 9.