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 AALA202510143618Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD BETWEEN BS 767 AND BS 787 AT RBL 20. REPLACED SHIELD PER AARD 51-00-05-1.SDR DALA2025101307481Support Angle · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE CLIP. REPLACED CLIP REF BAC DWG 146T3244 (1233343)SDR DALA2025101307480Support Angle · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE CLIP PT 146T3248-8. REPLACED CLIP REF BAC DWG 146T3244 (1233342)SDR DALA2025101307479Support · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE DOOR SUPPORT PN 148T3248- 7. REPLACED DOOR SUPPORT REF BAC DWG 146T3244 (1233340)SDR DALA2025101307478Doubler · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE DOUBLER PLATE PN 146T3258 -1. CORRECTIVE ACTION: REPLACED DOUBLER PLATE REF BAC DWG 146T3244 (1233257)SDR DALA2025101307476Dump Valve · corrodedSHIP 185 DURING REPLACEMENT OF FWD WASTE TANK DUMP VALVE, FOUND CORROSION OF STRUCTURE SURROUNDING THE WASTE SERVICING PANEL. CORRECTIVE ACTION: DAMAGE AREA REPAIRED PER ER/A 629441-14 REV. ORIG SECTION II (1234151)SDR DALA2025101307490Angle · corrodedCORROSION ON AFT LAV SUPPORT STRUCTURE CLIP PT # 146T3248-15. REPLACED CLIP REF BAC DWG 146T3244 (1233344)SDR AALA202510105685Handle · damagedAIRCRAFT WAS GROUNDED: DOOR 4R DOES NOT OPEN FROM EXTERIOR HANDLE. MAINTENANCE FOUND EXTERIOR HANDLE MECHANISM TEETH STRIPPED. REMOVED AND REPLACED EXTERIOR HANDLE MECHANISM IAW AMM 52-11-02.SDR JJBA20251008016Flap System · faultedFLAP FAIL AT 9 DEGREES. ON DESCENT, FLAPS MOVED TO 9 DEGREES, GREEN FLAP LIGHT INDICATED, THEN FLAP FAIL MESSAGE. R & R FLAP RESET SWITCH. OPS CHKD SAT. NO FAIL MESSAGE. INSPECTED MECHANICAL LINES SHROUD, ROLLERS & CONNECTORS. SECURED CONNECTORS P3683 & P368SDR SWAA2025100921357Handle · unsecureR2 DOOR ASSIST HANDLE NEEDS SECURING. SECURED R2 DOOR ASSIST HANDLE IAW AMM 52-41-31.SDR SWAA2025100921358Handle · unsecureR1 DOOR ASSIST HANDLE NEEDS SECURING. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR CALA2025100909837Baffle · corrodedFWD CARGO BAY, STRINGER 26L BETWEEN BS 500F - 500G BAFFLE IS CORRODED ON UPPER FLANGE. AFTER INVESTIGATION, DAMAGED AREA AT WAS CONCLUDED THAT THE MATERIAL IS FOUND TO BE 100% OUT OF LIMITS DUE TO EVIDENT EXPOLATION IAW SRM 53-00-53-1A-2, FIG 103. LOCATEDSDR AALA202510093270Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 328, LBL 17. REPLACED TIEDOWN IAW AARD 51-00-05-1.SDR SWAA2025100821295Handle · looseCR RR R1 DOOR AIRFRAME SIDE ASSIST HANDLE NEEDS SECURED R1 DOOR AIRFRAME SIDE ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR AIRFRAME SIDE ASSIST HANDLE IAW B737-800 AMM TASK 52-11-31-400-802.SDR SWAA2025100821276Fuse · inoperativeSIDEWALL LIGHTS AT ROWS 13 14 &15 DEF DO NOT ILLUMINATE. REMOVED AND REPLACED WINDOW LIGHT FUSE IAW AMM 33-21-00. OPS CHECK GOOD.SDR DALA2025100807361Wire · shortedAT CRUISE THE CAPTAINS MAP LIGHT WIRES SHORTED OUT. DISPATCHED PER TYPICAL REPAIR ERA. MAP LIGHT REPLACED DOWNLINE. (LP# 7626782)SDR IPXA2025100885263Floor Panel · crackedCRACK- FLOOR PANEL, MAIN DECK COMPARTMENT FLOOR PNL (P/N: 144U5803-98). MAIN DECK COMPARTMENT FLOOR PNL (P/N: 144U5803-98).I.A.W AMM 25-59-01-004-175 REV.114 REMOVE MAIN DECK CARGO FLOOR PANEL/SEALANT AND PERFORM G.V.I CHECK RESULT WAS NORMAL. IAW AMM 53-21-02SDR N6WA2025100802Attach Angle · corrodedLH MLG WELL BURST PANEL ATTACH ANGLE IS CORRODED. REMOVED AND REPLACED LH MLG WELL BURST PANEL ATTACH ANGLE IAW CRJ SRM 51-42-21SDR CALA2025100809792Attach Angle · crackedFOUND CRACK LOWER FUSELAGE REAR SPAR LEFT VAPOR BARRIER UPPER ATTACHED ANGLE LBL 7, BS 663.75. INSTALLED REPAIR AT BS 663 LT VAPOR BARRIER ANGLE FROM LBL 5 TO LBL 30 PER SRM 57-10-10-2R-5.SDR CALA2025100809791Angle · corrodedFWD PIT, LEFT SUPPORT ASSY CORRODED AT LOWER AREA AT BS 500L APPROX. AT LBL-24. REMOVED SUPPORT ASSY (ANGLE) IAW SRM 51-40-02 AND REMOVAL DAMAGE CORROSION. MAT. REMAINED .037" FOUND WITHOUT LIMITS OF .056". LOCATED & DRILLED 1EA NEW SUPPORT ASSY (ANGLE) IASDR SWAA2025100721371Flashlight · low voltageFORWARD RT SIDE FA FLASHLIGHT LOW POWER. R & R FWD FLASHLIGHT BATTERY PER AMM 33-55-00.SDR SWAA2025100721282Flashlight · no testCOCKPIT EMERGENCY FLASHLIGHT DOESNT TEST. R & R FLASH LIGHT BATTERY PER AMM 25-64-00.SDR SWAA2025100721231Battery Pack · inoperativeR1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R RELATED EMERGENCY EXIT POWER SUPPLY BATTERY PACK. OPS OK IAW AMM 33-51-06.SDR ASAA2025100461414Fuse · inoperativeEMERGENCY AISLE LIGHTS AT SEAT ROW 17 & 19 FED INOP. GROUNDED - YES. REPLACED TWO EACH FUSES IN BATTERY PACK M1671 REF B737NG AMM 33-51-06-960-804. AISLE LIGHTS AT SEAT ROW 17 AND 19 FED OPS CHECK GOOD REF B737NG AMM 33-51-06-960-804.P.O. 1125797.1.SDR ASAA2025100461410Bulb · inoperativeEXTERNAL RIGHT EMERGENCY LOWER FUSELAGE SLIDE LIGHT INOP. GROUNDED - YES. REPLACED BULB IN EXTERNAL RIGHT EMERGENCY LOWER FUSELAGE SLIDE LIGHT, NO LONGER INOP REF. B737-600/700/800/900 AMM 33-51-04.SDR ASAA2025100461409Fuse · inoperativeEMERENCY EXIT LIGHT AT THE BOTTOM OF AFT RIGHT OVERWING DOOR INOP. GROUNDED - YES. REPLACED FUSES IN BATTERY PACK M1671 ON N/R 30983, EMERGENCY EXIT LIGHT PASSES OPS CHECK REF B737 NG AMM 33-51-06-960-804. (S/N 118163)SDR AALA202510075513Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN AIRCRAFT LEFT NEAR WING IS INOPERATIVE. MAINTENANCE RELAMPED , OPS NORMAL. OK FOR SERVICE.SDR QXEA2025100700315Pump · leakingFLIGHT 2737. FUEL LEAK ON #1 ENGINE. REMOVED FROM SERVICE. C/W E175 AMM MCN NO: E720036-01. FOUND FUEL LEAKAGE FROM #1 ENG DRAIN MAST OUT OF PERMISSABLE LIMITS AT 80 DROPS/MINUTE WITH ENGINE RUNNING. C/W TASK CARD E175-7200803 AND FOUND ENGINE FUEL PUMP LEAKSDR DALA2025100707282Outflow Valve · damagedSHIP 3152 - ATB - DUE TO CAB PR SYS 2 FAULT ECAM WARNING FOLLOWED BY CAB PR SYS 1 2 FAULT ECAM WARNING. CORRECTIVE ACTION: FOUND BROKEN DRILL BIT BETWEEN OUTFLOW VALVE AND THE CUTOUT FRAME NOT ALLOWING THE OUTFLOW VALVE TO CLOSE PROPERLY. REMOVED FOD AND OUTFLSDR UIEA2025100401256Hf Comm · abnormalBOTH HF COMM RADIO INOP AND SELCAL INOP(<P>T/S WITH FIM 23-11 FT 804. RESECURED CONNECTIONS AT HF ANTENNA. OPS CHK GOOD PER AMM 23-11-00</P>)SDR YENA2025100301009Wire Harness · failedFLT#287, BOS-LAX. (ETOPS) "( TCC/TACC VALVE ) ECAM MESSAGE ON TAXI IN. ENG 2 TURB COOL FAULT; UPON INSPECTION FOUND CHAFING/WIRE SHOWING ON "WC08" HARNESS. R/R "WC08" WIRE HARNESS IAW AMM 73-21-68-400-802-A. ALL OPS OK. VSV IFPC REQ OPS CHK DUE TO SYSTEMS DISTSDR YENA2025100301008Skin · damagedDURING HEAVY MAINTENANCE: FUSELAGE / AFT FUSELAGE / WASTE PANEL SURROUND SKIN DOUBLER AT FR75-76 AND STR31LH-36LH / CORROSION - TEMPORARY REPAIR; REFERENCES: /1/ AIRBUS REO-500-53-61-2180 REV -- /2/ AIRBUS CRC 00195904 /3/ AVIANOR REPORT JB-3132-C01-3035 REV 1SDR YENA2025100301000Battery · failedFLT#32, AMS-BOS. "PERFORMED TASK CARD A320-33-51-00-710-003. EMER BATTERY 10WL OVER TEMP MSG; REMOVED AND REPLACED 10WL EMER LIGHT BATTERY IAW AMM 33-51-38. OPS CHK GOOD. NO DEFECTS NOTED."SDR YENA2025100300999Seal · leakingFLT#1734, SFO-BOS. "FA REPORTED ODOR FROM FORWARD GALLEY VENT ON CLIMBOUT. IT WENT AWAY AFTER 5 MINS CAME BACK ON DESEENT. IT SMELLED LIKE DEICE FLUID. NOT NOTICED IN FLIGHT DECK. APU OFF, PACK 1 TURNED OFF USING ISOLATION CHECKLIST; FOUND LEAKING ON ENG 2 DEOSDR CALA2025100709737Intercostal · corrodedMAIN CABIN AFT WET AREA STA 952, RBL26, INTERCOSTAL ANGLE HAS CORROSION. REMOVED AND REPLACED INTERCOSTAL PER BAC DWG 147A5660 ID:0014 REV:- T05867-173.SDR CALA2025100709736Seat Track · corrodedMAIN CABIN RT FR20 SEAT TRACK Y-765 RT HAS CORROSION SPOT ON UPPER SURFACE. MAIN CABIN RH FR12 THRU FR24 SEAT TRACK Y-765 REMOVED AND REPLACED IAW SRM 51-42-11/001 AND 51-72-11-911-002.SDR CALA2025100709735Floor Support · corrodedMAIN CABIN FLOOR SUPPORT INTERCOSTAL FLOOR BOARD FASTENER HOLES 2EA HAVE CORROSION IN THE BORE BETWEEN STA 294.5 AND 312 AT APPROX LBL12. MAIN CABIN FLOOR STA 294.5 - 312 LBL 11.1 BLENDED AFFECTED AREA ON INTERCOSTAL TO REMOVED CORROSION, REMAINING MATERIALSDR CALA2025100709734Attach Angle · crackedFOUND CRACK LOWER FUSELAGE REAR SPAR RT VAPOR BARRIER UPPER ATTACH ANGLE RBL 7 STA 663.75. INSTALLED REPAIR AT STA 663 RH VAPOR BARRIER ANGLE FROM RBL 5 TO RBL 30 PER SRM 57-10-10-2R-5. ACCOMPLISHED REPAIR AT STA 663 LH VAPOR BARRIER ANGLE FROM LBL 5 TO LBSDR CALA2025100709733Floor Panel · puncturedFWD CARGO PIT FLOOR PANEL 120CF HAS TWO PUNCTURES. IAW SRM 53-30-53. FABRICATED NEW FWD CARGO FLOOR PANEL 120CF IAW EC/RA 5320-02744 REV A. PRIMED AND ALODINED FLOOR PANEL IAW SRM 51-20-01.SDR ASAA2025100461407Lamp · inoperativeWHILE PERFORMING TASK CARD 33-010-00, FOUND AFT RH EMERGENCY SLIDE LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED AFT RH EMERGENCY SLIDE LAMP REF AMM 33-51-04. OPS CK GOOD.SDR HALA20251006305Switch · out of positionENG CTL - ABORTED TAKE-OFF ENG THRUST LOSS ABNORMAL ENG A. ICE. REVIEWED MEL 30-21-1B PROCEDURE WITH CREW. DUE TO FAULTS DISPLAYED IN PFRR POSSIBIITY OF #2 A/ICE P/B SWITCH IN INCORRECT CONFIG FOR T/O, NO OTHER FAULTS NOTED.SDR HALA20251006304Plug · leakingETOPS - ON PDSC OIL WAS FOUND ON ENG#1 INBOARD COWL. ENG#1 SCAVENGE FILTER DRAIN PLUG FOUND TO BE LEAKING. REMOVED AND REPLACED #1 ENG SCAVENGE FILTER DRAIN PLUG WASHER P/N KB29665 PER A330 AMM 79-22-45-920-801-A STEPS A(1)-(7) ONLY. LEAK CHECK GOOD. OK FOR SESDR HALA20251006303Support Bracket · brokenETOPS - FOUND HP FUEL FILTER SUPPORT BRACKET BROKEN WHILE CARRYING OUT TASK CARD # 330-783201-R2-1-1. REMOVED AND REPLACED SUPPORT BRACKET PER AMM SUBTASK 73-11-42-420-052-A. A/C OK TO CONTINUE SERVICE.SDR SWAA2025100621252Engine · bird ingestionON DECENT AROUND 4000 FEET BURNT SMELL, NO ABNORMAL INDICATIONS. UPON INSPECTION, FOUND NR 1 ENG CORE INGESTED BIRD. PERFORMED BIRD STRIKE INSPECTION IAW AMM 05-51-18. PERFORMED #1 ENG BIRD STRIKE VISUAL INSPECTION PER MT 872-PRD-02-01 AND BOROSCOPE INSPECTSDR SWAA2025100621588Sign · unsecureISLE EXIT SIGN WONT STAY UP. R & R CENTER ISLE EXIT SIGN IAW AMM 33-51-02.SDR SWAA2025100621249Slide · out of positionFWD GALLEY SERVICE DOOR EMERGENCY SLIDE FELL OUT OF THE DOOR. R & R SERVICE DOOR EMERGENCY SLIDE REF AMM 25-66-01 C/W MT 725-61-06.SDR SCNA20251006396Girt Bar · damagedFWD ENTRY GIRT BAR. PLASTIC PIECE IS MISSING A PIN TO KEEP IT IN PLACE AND NOT SLIDE AROUND. FOUND FWD GIRT BAR RELEASE STOP ASSY ROTATED PREVENTING SPRING CLIP FROM SECURING PROPERLY. RE-ORIENTED TO THE CORRECT POSITON. ASSY WORKS AS SHOULD OKAY FOR SERVICESDR AALA202510061855Wire Harness · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY ESCAPE PATH LIGHT INOP SEA ROW 19ABC. MAINTENANCE REPLACED EMERGENCY ESCAPE PATH LIGHTS WIRE ASSY FROM WALL CONNECTOR 7260VC6 TO ROW 19ABC IAW AWM 33-51-06. OPS CHECK GOOD IAW AMM 33-51-00-710-001-A.SDR AALA202510060384Wire Harness · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY ESCAPE PATH LIGHTS INOP SEAT ROW 18ABC. MAINTENANCE REPLACED EMERGENCY ESCAPE PATH LIGHTS WIRE ASSY FROM WALL CONNECTOR 7260VC6 TO ROW 18ABC IAW AWM 33-51-06SDR AALA202510064190Sign · missingAIRCRAFT WAS NOT GROUNDED: 5L DOOR EXIT SIGN MISSING. MAINTENANCE REPLACED LIGHT ASSY. OPS CHECK NORMAL IAW AMM 33-51-01.