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 CALA2025071106469Seat Track · corrodedFOUND CORROSION AT MAIN CABIN LH I/B SEAT TRACK 727A. ACCOMPLISHED I/B SEAT TRACK REPAIR LBL 24.75" FROM STA 727+9 TO STA 727B IN REF SRM 53-00-52-2R-2, AND BOEING DRAWING 144A5300.SDR CALA2025071106468Floor Panel · corrodedAFT CARGO ENTRY DOOR FLOOR HAS CORROSION SPOTS ON UPPER SURFACE. REMOVED AND REPLACED DOOR SILL AT AFT CARGO DOOR IAW A319 SRM 51 -42-11-001.SDR CALA2025071106467Reservoir · unserviceableREF LOGPAGE 5503810, DOOR 2R EPAS SYSTEM DEPLOYED DURING SCHEDULED SLIDE REPLACEMENT. SYSTEM WAS DEACTIVATED AND DISARMED, BUT ACTIVATED DURING SLIDE REMOVAL REGARDLESS. SLIDE DID NOT DEPLOY. REPLACED DOOR 2R EPAS BATTERY PACK AS A PRECAUTIONARY MEASURE DUE TOSDR CALA2025071106466Angle · corrodedCORROSION AT R1 DOOR CUTOUT FLOOR INNER CHORD. INSTALLED NEW INNER CHORD AT MAIN CABIN R1 DOOR PER SRM 51-40-0G -0 AND DWG# 141A8310. CORROSION FOUND OUT OF LIMITS, REMOVED AND REPLACED INNER CHORD AT MAIN CABIN R1 DOOR STA 259 - STA 360 PER SRM 51-40-02-0GSDR CALA2025071106465Floor Support · corrodedFOUND CORROSION AFT CABIN WET AREA SUPPORT INTERCOSTAL LBL 24.75 STA 947.5. FOUND CORROSION OUT OF LIMITS PER SRM 53-70-51-1A-1 4.A FIG 103, REMOVED AND REPLACED INTERCOSTAL AT CABIN FLOOR STRUCTURE STA 947.5 TO 967 RBL 24.75 IAW SRM 51-40-02-0G-0, DWG 147A56SDR CALA2025071106457Light · brokenECONOMY PASSENGER SEAT EMERGENCY PATH LIGHTING (EPL) ROW 8 L/H, EMERGENCY PATH WHITE LIGHT BROKEN. REPLACED SEAT LIGHT AT ROW 8. LIGHT OPS CHECK GOOD IAW AMM 33-51-11.SDR CALA2025071106456Light · damagedFLOOR EMERGENCY LIGHT AT 5D DAMAGED ADJACENT LIGHTS OP OK, PLACED ON MEL. REMOVED AND REPLACED FLOOR EMERGENCY LIGHT AT 5D, OPS TEST GOOD IAW AMM DMC-B787-A-33-51-06-00A-720A-A.SDR 2025FA0000473Support · crackedLANDING GEAR ACTUATOR AFT LUG SUPPORT BRACKET CRACKEDSDR SWAA2025071089979Unknown · smokeON DECENT, NOTICED POSSIBLE SMOKE COMING FROM CAPTAINS SIDE VENT, SMELL DISSIPATED ONCE LT PACK TURNED OFF. FA DID NOT NOTICE ANY ODORS. PERFORMED CONDITIONAL INSPECTION IAW AMM 05-51-56 AND FIM 21-00 TASK 806. COULD NOT DUPLICATE. PERFORMED REPAIR CONFIRMSDR SWAA2025071089980Slide · partial deployFWD SERVICE DOOR ESCAPE SLIDE PARTIALLY DEPLOYED. SECURED PER STANDARD INUSTRY PRACTICES. OPS CK GOOD.SDR SWAA2025071089985Switch · overheatedB HYD OVERHEAT AT CRUISE. FL340. ELECTRIC PUMP. ALT FLAP EXT & LANDED FLAPS 15. NO BRAKE OVHT. T/S PER FIM 29-30 TASK 806 FOUND HYD SYS B OVERHEAT SWITCH AND CONNECTOR SHORTED. REMOVED AND REPLACED SYS B OVERHEAT SWITCH PER AMM 29-32-12. REMOVED AND REPLACSDR SWAA2025071090043Elec Connector · overheatedB HYD OVERHEAT AT CRUISE. FL340. ELECTRIC PUMP. ALT FLAP EXT & LANDED FLAPS 15. NO BRAKE OVHT. T/S PER FIM 29-30 TASK 806 FOUND HYD SYS B OVERHEAT SWITCH AND CONNECTOR SHORTED. REMOVED AND REPLACED SYS B OVERHEAT SWITCH PER AMM 29-32-12. REMOVED AND REPLACSDR SWAA2025071090044Filter · faultedB HYD OVERHEAT AT CRUISE. FL340. ELECTRIC PUMP. ALT FLAP EXT & LANDED FLAPS 15. NO BRAKE OVHT. T/S PER FIM 29-30 TASK 806 FOUND HYD SYS B OVERHEAT SWITCH AND CONNECTOR SHORTED. REMOVED AND REPLACED SYS B OVERHEAT SWITCH PER AMM 29-32-12. REMOVED AND REPLACED SDR SWAA2025071090038Slide · out of adjustFWD ENTRY DOOR SLIDE OUT OF POSITION<[01] C/W ESCAPE SLIDE PACK CHECK AND REPOSITIONED GIRT BAR IAW AMM 25-66-01SDR 4TXA2025071000470Skin · crackedA 2.75 INCH HORIZONTAL CRACK WAS FOUND BETWEEN FUSELAGE STATIONS 967 AND 986.5 AND AT STRINGER 21L. THE CRACK WAS 5.6 INCHES BELOW THE LAP SPLICE.SDR R61A2025070500301Support Web · corrodedDURING HEAVY CHECK CF III INTERNAL AFT PASSENGER DOOR BEAM CORROSION FOUND ON SUPPORT WEB BETWEEN FR85-86 STR 17-18L. REPLACED REPAIR PARTS IAW SRM 51-40-08SDR R61A2025070500300Beam · corrodedDURING HEAVY CHECK AFT PASSENGER DOOR CUT OUT LOWER BEAM FOUND CORRODED BETWEEN FR 85-87. REPLACED BEAM IAW SRM 51-42-01SDR R61A2025070500299Seal Rest · corrodedDURING HEAVY CHECK AFT PASSENGER DOOR CUT OUT LOWER BEAM SUPPORT SEAL REST FOUND CORRODED. REPLACED SEAL REST IAW SRM 51-41-01SDR R61A2025070500298Access Door · corrodedDURING HEAVY CHECK WASTE ACCESS DOOR FOUND TO HAVE CORROSION IN MULTIPLE LOCATIONS. REPLACED WASTE DOOR IAW AMM 20-10-07-910-801-ASDR JR2R20250710792Frame · corrodedFRAME 87 IS CORRODED BETWEEN STRINGERS 27R AND 28R. OUT OF LIMITS. REPAIRED.SDR R61A2025070500297Service Panel · corrodedDURING HEAVEY CHECK POTABLE WATER SERVICE DOOR FOUND TO HAVE CORROSION IN MULTIPLE AREAS. REPLACED PANEL IAW AMM 50-03-62-040-801=A00 AND AMM 53-03-62-440-801-A00SDR R61A2025070500296Support · corrodedDURING HEAVEY CHECK AFT WET AREA CORROSION FOUND ON INTERCOSTALS BETWEEN FR 90-91 RBL 24. REPLACED INTERCOSTAL IAW SRM 51-43-03SDR R61A2025070500295Web · corrodedDURING HEAVEY CHECK CFIII INTERNAL CORROSION FOUND ON BEAM UPPER SHEET BETWEEN FR 84-86 RBL 10. REPLACED UPPER SHEET IAW SRM 51-41-01SDR R61A2025070500294Shear Tie · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR CLIP FR 82 STR 28R-29R. REPLACED SHEAR CLIP IAW SRM 51-41-01SDR R61A2025070500293Shear Tie · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR CLIP FR 84 STR 27R-28R. REPLACED SHEAR CLIP IAW SRM 51-41-01SDR R61A2025070500292Shear Tie · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR CLIP FR 85 STR 27R-28R. REPLACED SHEAR CLIP IAW SRM 51-41-01SDR R61A2025070500291Shear Tie · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR CLIP FR 85 STR 28R-29R. REPLACED SHEAR CLIP IAW SRM 51-41-01SDR R61A2025070500290Floor Support · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED FLOOR PANEL BEAM FR 85-89 LBL 11. REPLACED BEAM IAW SRM 51-43-03SDR R61A2025070500289Floor Support · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED FLOOR PANEL BEAM FR 85-89 LBL 11. REPLACED BEAM IAW SRM 51-43-03SDR R61A2025070500288Shear Panel · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR PANEL LH FR 87-88. REPLACED SHEAR PANEL IAW SRM 51-43-03SDR R61A2025070500287Shear Panel · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR PANEL FR 87-88. REPLACED SHEAR PANEL IAW SRM 51-42-01SDR R61A2025070500286Shear Panel · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SHEAR PANEL FR 87-88. REPLACED SHEAR PANEL. IAW SRM 51-43-03SDR R61A2025070500285Splice Plate · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SPLICE PLATE FR 87-88. REPLACED SPLICE PLATE. IAW SRM 51-42-02SDR HNAA2025071000466Engine · smokeAFTER E-2 SHUTDOWN THERE WAS SMOKE OUT THE EXHAUST WITH A SMOKEY SMELL IN THE CABIN. COULD NOT DUPLICATE E2 SMOKE, SEE SEQ #2 FOR DMT. FOUND APU LEAKING OIL, SEE SEQ #3 FOR APU MEL. RAN PACKS AS REQ NO MORE OIL SMELL. A/C OK FOR SERVICESDR R61A2025070500284Floor Support · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED FLOOR PANEL SUPPORT LH O/B FR 88-90. REPLACED SUPPORT IAW SRM 51-41-01SDR R61A2025070500283Splice Plate · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SPLICE PLATE FR 89 RBL 10. REPLACED SPLICE PLATE IAW SRM 51-43-03SDR R61A2025070500282Splice Plate · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED SPLICE PLATE FR 90 BL-0. REPLACED SPLICE PLATE IAW SRM 51-43-03SDR R61A2025070500281Plate · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED GUSSET PLATE FR 90 RBL 11. REPLACED GUSSET IAW SRM 51-41-02SDR R61A2025070500280Floor Support · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED FLOOR PANEL SUPPORT FR 84 LBL48. REPLACED PANEL SUPPORT IAW SRM 51-41-02SDR JR2R20250710997Skin · chafedL/H WING FIXED LEADING EDGE PANEL HAS CHAFE MARKS.SDR R61A2025070500279Plate · corrodedDURING HEAVEY CHECK CFIII INTERNAL FLOOR STRUCTURE CORRODED GUSSET PLATE BETWEEN FR 90 STR 24. REPLACED GUSSET PLATE IAW SRM 51-41-02SDR JR2R20250710793Shear Tie · corrodedSHEAR TIE AT FRAME 87 BETWEEN STRINGERS 27R AND 28R IS CORRODED. OUT OF LIMITS. REPLACEDSDR 2025FA0000469Beacon · failedON OCCASION, THE UPPER AND LOWER ANTICOLLISION BEACON LIGHTS HAVE FAILED (STOPPED FLASHING) AFTER FIRST ENGINE START USING BOTH 24V BATTERY POWER AND EXTERNAL 28V GPU POWER. SUSPECTED ROOT CAUSE IS LOW VOLTAGE ON THE DC BUS, INCURRED BY HIGH DC BUS LOADS EXPESDR JR2R20250710187Skin · chafedR/H WING FIXED LEADING EDGE OVER PYLON HAS CHAFE MARKS.SDR R61A2025070500278Shear Tie · corrodedDURING HEAVEY CHECK CFIII INTERNAL LOWER FUSELAGE CORRODED SHEAR CLIP BETWEEN FR 85 STR 28R-29R. REPLACED SHEAR CLIP IAW SRM 51-41-01SDR JR2R20250710933Shear Tie · corrodedSHEAR TIE AT FRAME 87 BETWEEN STRINGERS 29R AND 29L IS CORRODED. OUT OF LIMITS. REPLACEDSDR R61A2025070500277Floor Support · corrodedDURING HEAVY CHECK CF III INTERNAL LOWER FUSELAGE CORRODED CARGO FLOOR SUPPORT BRACKET BETWEEN FR 80-81 STR 25R-26R. REPLACED BRACKET IAW SRM 51-41-02SDR JR2R20250710795Shear Tie · corrodedSHEAR TIE AT FRAME 87 BETWEEN STRINGERS 28R AND 29R IS CORRODED. OUT OF LIMITS. REPLACEDSDR IPXA2025071047769Packing · leakingC HYD QTY EICAS DECREASING RESERVIOR QTY. OBSERVED UPON DESCENT AND ARRIVAL C HYD PRESS EICAS QRH PROCEDURES FOLLOWED INCLUDING ALT FLAP AND GEAT EXTENSION. FOUND PRESSURE OUTLET UNION PACKING DAMAGED/TORN. REPLACED PACKING AND UNION IAW AMM 29-11-19 AND AMM SDR DALA2025071005210Support · corrodedAIRCRAFT 3095, CORROSION LOWER SILL LOCATED BETWEEN FR68 AND STR23L AT AFT GALLEY AR EA (SSI 534147). CORRECTIVE ACTION: PERFOMED PERMANENT REPAIR ON LOWER SILL LOC.FR 68 LH AT LEVEL STR23L AFT GALLEY AREA AS PER A321 SRM 53-41-14-300-001, MEASURE OF CORROSION