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 SWAA2025102014293Shear Plate · corrodedCORROSION ON FLOOR STRUCTURE SHEAR PLATE BTW BS 490 TO BS 500A AT RBL 21 AND WL 152 AT FWD CARGO COMPARTMENT (3 EA). REPLACED SHEAR PLATE AND FASTENERS LOCATED BTW BS 490 TO BS 500A AT RBL 21 AND WL 152 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 Ï¿½TESDR SWAA2025101614329Tray · brokenBROKEN FOODTRAY ON ROW SEAT 11A 11B 12A 12B 12C 14B 16C 17A 17B 18B 18C AT PASSENGER CABIN. REPLACED FOODTRAY ON ROW SEAT 11A 11B 12A 12B 12C 14B 16C 17A 17B 18B 18C AT PASSENGER CABIN IAW CMM 25-22-46-3500 REV. 8 STEP 3.Z.(1) PAGE: 7015 FIGURE 4 PAGE: 10096SDR SWAA2025101614295Support · corrodedCORROSION CHANNEL SUPPORT ZEE BTW BS 500C TO BS 500I AT LEVEL LBL 21 AND WL 152 AT FWD CARGO COMPARTMENT. REPAIRED CHANNEL SUPPORT ZEE BTW BS 500B MORE 13.5 INCH TO BS 500I AT LEVEL LBL 21 AND WL 152 AT FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02; DWG 14SDR ASAA2025091361445Web · corrodedPASSENGER COMPARTMENT, AFT GALLEY AREA, NEAR FWD LEFT FLOOR GALLEY MOUNT, FLOOR SKIN HAS CORROSION. STA 992-1006. GROUNDED - YES. REMOVED MOUNT FITTINGS (2), IAW B737-900 SRM 51-40-02. BLENDED OUT CORROSION, ORIGINAL THICKNESS OF WEB .080, REMAINING THICKNESS SDR SWIA2025100700913Angle · out of alignmentWHILE PERFORMING SB 670BA-53-036/670SH53-042 FOUND PILOT HOLES IN NEW SERVICEABLE L/H 36 BEAM MISALIGN WITH EXISTING FASTENER HOLES IN L/H SEAL ANGLE AT F.S.693 REQUIRING REPLACEMENT OF SEAL ANGLE. (C-CHECK RO 10/06/2025) INSTALLED NEW SERVICEABLE SEAL ANGLESDR JJBA20251006014Gusset · corrodedCFI, RH GUSSET BTW FR18-24 FOUND CORRODED. AT CF RH GUSSET BTW FR18-24 GUSSET BLENDED OUT OF LIMIT. CF1, RH GUSSET BTW FR 18-24 REMOVED AND INSTALLED.SDR CALA2025100609630Seal Depressor · crackedCRACK FOUND AT SEAL DEPRESSOR MAIN CABIN STA 294.5 BETWEEN STR 8R AND 9R R1 DOOR CUT OUT FWD UPPER CORNER. (REF AAR N/R 99950891) CREATED ESFR FOR LOG PAGE 6255534 NON-ROUTINE 99950891 REMOVED AND REPLACED SEAL DEPPRESOR AT FWD GALLEY DOOR STA.294.5 BET. STR8RSDR SWAA2025100314221Floorbeam · crackedCRACK PANEL BREAK LOCATED IN FLOORBEAM STA 540 BETWEEN BL 0 TO LBL 24.75. REPLACED FLOORBEAM IAW SRM 51-40-02; SRM 51-10-02 Ï¿½TEM 9 AND DWG 143A0060 SHEET 46; REV.-. CRACK LENGTH IS: 1.140.SDR SWAA2025100314368Bulkhead Web · crackedRH VAPOR BARRIER BULKHEAD WEB HAS CRACKED AT BS 663 RBL 26 WL 161 - 176. FAULT WILL BE RESOLVED ON ANOTHER FAULT; REFER TO TTG8Q0155JAJ.SDR SWAA2025100314370Attach Angle · crackedRH VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT BS 663 RBL 33 WL 176. INVESTIGATED FOR POSSIBLE CRACK AS PER SRM 51-10-02; UPON FURTHER INVESTIGATION AND ACCOMPLISHMENT OF NDI, NO CRACK WAS NOTED.SDR SWAA2025100314373Vapor Barrier · crackedR/H BS663 VAPOR BARRIER IS CRACKED RBL35 WL156. RIGHT BS663 VAPOR BARRIER WITH A CRACK AT RBL35 AND WL156 WAS REPAIRED IAW SRM 51-70-04-2R-10.SDR MASA20250930005Waste Box · corrodedWASTE AND WATER BOX COMPOSITE REPAIRED IAW SRM 53-23-60SDR MASA20250930003Fastener · corrodedCORRODED FASTENERS (QTY 42) WERE REMOVED AND REPLACED IAW ERJ175 SRM 51-43-04 ON RH LOWER SKIN AT RIB 26, AND SPAR 2.SDR MASA20250930002Doubler · corrodedCORRODED OXY OVERBOARD DOUBLER WAS REMOVED AND REPLACED IAW EMBRAER SRM 51-41-02SDR AALA202509268835Bracket · wornAIRCRAFT WAS GROUNDED, AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING A DOOR RIGHT OVERWING EXIT MESSAGE DURING CLIMB OUT AT 9K-10K. THE AIRCRAFT LANDED AT PHX WHERE IT TAXIED TO THE GATE. MAINTENANCE FOUND THE MOUNTING BRACKET FOR PROXIMITY SENSOSDR IPXA2025091696218Bulkhead · crackedNUMBER 2 ENG OUTBD INLET COWL AFT BULKHEAD HAS CRACK UNDER HARDLINE AT 3 OCLOCK POS. INSTALLED DOUBLER REPAIR AND NEW WEB IAW A300 PW SRM 54-10-00 REPAIR NO. 12 AND SRM 51-40-21. REVIEWEDSDR IPXA2025091906218Bulkhead · crackedNR 2 ENG OUTBD INLET COWL AFT BULKHEAD HAS CRACK UNDER HARDLINE AT 3 OCLOCK POS.SDR DALA2025091806866Transceiver · failedATB DUE TO WEATHER RADAR FAIL ADVISORY. REMOVED AND REPLACED WEATHER RADAR ANTENNA, OPS CHECK GOOD ACFT OK FOR SERVICE. (LP 7876389)SDR DALA2025091806857Control Module · faultedATB DUE TO DMC 2A FAIL WITH MULTIPLE FAULT MESSAGES. REMOVED AND REPLACED PPM AND DATA CONTROL MODULE ON DMC 2A. OPS CHECK GOOD. AIRCRAFT OK FOR SERVICE. (LP# 6804294)SDR DALA2025091706842Skin · puncturedRT DROOP NOSE HAS PUNCTURE DAMAGE AT INTERMEDIATE RIB 4. CUT OUT DAMAGED SKIN AND DRESSED PER ASR A350-A-57-44-63- 00001-664A-A, FIG 11, A(1) THRU (7). PERFORMED HFEC SURFACE SCAN OF CUTOUT AND BHEC OF RIB FASTENER HOLES PER A350 NTM 51-96-20. NO DEFECTS NOTESDR DALA2025091706838Warning Message · false activationATB TO BOS DUE TO LEFT ENGINE OIL FILTER EICAS MESSAGE. QRH STATES NOT TO INITIATE AN OVER WATER CROSSING. INSPECTED LEFT ENGINE MAGNETIC CHIP DETECTORS IAW FIM, NO TROUBLE FOUND. REMOVED, INSPECTED AND REPLACED LEFT ENGINE OIL FILTER IAW AMM, NO TROUBLE FOUNSDR DALA2025091706836Cover · missingDURING ETOPS PDC FOUND ON FWD ATTENDANT PANEL AT R1 DOOR ARMED COVER LIGHT MISSING. INSTALLED BUTTON ON ENTRY/SERVICE DOOR SLIDE IAW AMM 52-73, OPS TEST PASSED. ACFT OK FOR SERVICE . (7622485)SDR VNAA2025091711101Sensor · malfunctionedBRAKE OVHT WARNING MSG IN FLIGHT QRC + QRH COMPLETE. / REMOVED AND REPLACED #1 BRAKE TEMP SENSOR IAW AMM 32-46-01-000/401-801-A01. OPERATIONAL TEST THERMOCOUPLE SENSOR AND OPERATIONAL CHECK GOOD IAW AMM 32-4601€“740€“801-A01.SDR AALA202509178835Warning Message · illuminatedAIRCRAFT WAS GROUNDED: AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING A DOOR RIGHT OVERWING EXIT MESSAGE DURING CLIMB OUT AT 9K-10K. THE AIRCRAFT LANDED AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN POWER. (OPEN)SDR DALA2025091706832Oxygen Mask · dislodgedAFT GALLEY O2 MASK FELL ON LANDING. FWD TO MEL 35- 21-01D. M PROCEDURE C/W AND PLACARD INSTALLED. R/R AFT GALLEY OXYGEN PANEL DOOR ASSYEMBLY IN REF. TO A320 AMM 25-25. AFT GALLEY OXYGEN PANEL DOOR OPS CHECK NORMAL. MEL AND PLACARD REMOVED. " M " PROCEDURE REVSDR DALA2025091706830Oxygen Mask · unwanted deployOXYGEN MASKS DROPPED OVER SEAT 13ABC ON TAXI-OUT. RESET PASSENGER OVERHEAD OXYGEN STORAGE COMPARTMENT PER A320 AMM 35-21-43. A/C OK FOR SVC. (LP: 7870156)SDR DALA2025091706827Controller · inoperativeEMER LIGHTS STUCK ON WITH SWITCH IN THE OFF POS. CYCLED A/C PWR. PERFORMED CID TEST. R/R PWR CTL RELAY 8WL. AWM 33-51. ALL OPS FAIL. 189039. T/S REF TSM 33-50. FOUND CIDS R IN EMERGENCY MODE. REPLACED CIDS REF A320 MM 23-70. BITE TEST GOOD. RPLD EMERGENCY LIGSDR CALA2025091709003Stringer · corrodedAFT CARGO COMPARTMENT UNDER FLOOR CORROSION PREVENTION & CONTROL PROGRAM (CPCP) INSPECTION. AFT CARGO BAY LT STRINGER 25 AT BS 847 HAS HEAVILY CORRODED BUILD UP FORWAD OF BULKHEAD. CLEANED & INSPECTED S25L, BS 807-847. REMOVED FASTENERS FROM SHEAR TIES ATSDR CALA2025091709001Flap · no discrepancyFLAP OVERSPEED AT FL10 BY 4 KNOTS. PERFORMED PHASE 1 INSPECTION IAW AMM 05-51-08-210-801. NO DEFECTS FOUND. OK FOR SERVICESDR ASAA2025091360895Lens · missing17DEF EXIT PLACARD EXIT/LIGHT PLACARD IS MISSING. GROUNDED - YES. REPLACED EXIT SIGN LIGHT ASSEMBLY AT SEAT 17DEF REF AMM 33-51-01-960-802. OPS CHECK GOOD.SDR ASAA2025091360894Lens · missingL2 DOOR EMER EXIT LIGHT LENS BROKEN. GROUNDED - YES. REPLACED L2 DOOR EMER EXIT LIGHT LENS REF AMM TASK 33-51-01.SDR SWAA2025091614432Plate · missingR2 DOOR AFT GIRT BAR PLATE ASSY MISSING. FOUND MISSING PLATE ASSEMBLY AND REINSTALLED IAW AMM 25-66-02.SDR SWAA2025091614386Slide · out of positionAED SLIDE FOUND NOT EVENLY FULLY SEATED; BIG GAP FOUND AT THE LOWER AFT SIDE. REMOVED & REINSTALLED AED SLIDE IAW AMM 25-66-01-000-801 & AMM 25-66-01-400-801.SDR SWAA2025091614140Flashlight · inoperativeFWD FLASHLIGHT INOPERATIVE. REPLACED FORWARD FLIGHT ATTENDANT FLASHLIGHT BATTERY IN ACCORDANCE WITH AIRCRAFT MAINTENANCE MANUAL 25-64-00; OPS CHECKED GOOD.SDR SWAA2025091614187Handle · looseL1 DOOR CLOSE HANDLE IS LOOSE AT SIDEWALL. TIGHTENED L1 DOOR CLOSE HANDLE AT SIDEWALL IAW AMM 52-11-31-400-802 STEP 3.G.(2).SDR DALA2025091606801Skin · damaged(LOG 1197892) AIRCRAFT TAIL NUMBER N3742C WAS SUBJECT TO IMPACT DAMAGE DUE TO HIGH WIND EVENT IN DENVER COLORADO. FUSELAGE SKIN PN 141A5321-11 WILL BE REPLACED AND SO IS THE BEARSTRAP PN 141A3522-3 FORWARD SECTION. WHILE THE SKIN PN 141A3521-11 IS RUNNING FROMSDR AALA202509169219Cradle · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 4L FLIGHT ATTENDANT STATION INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT (AALA202509160304) AND FLASHLIGHT BASE / BRACKET ASSEMBLY (AALA202509169219) PER TASK CARD 26C00025003. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMSDR AALA202509168160Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509160304Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 4L FLIGHT ATTENDANT STATION INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT (AALA202509160304) AND FLASHLIGHT BASE / BRACKET ASSEMBLY (AALA202509169219) PER TASK CARD 26C00025003. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMSDR AALA202509160684Handle · looseAIRCRAFT WAS NOT GROUNDED: 3L DOOR HANDLE IS LOOSE. MAINTENANCE RESECURED 3L SLIDE ARMING LEVER HANDLE PER AMM 25-23-47.SDR AALA202509166648Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509163537Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD PASSENGER / CREW DOOR SLIDE GIRT BAR DOES NOT PROPERLY ENGAGE INTO AFT GIRT BAR FITTING. ADJUSTED FLOOR MOUNTED GIRT BAR FITTINGS PER AMM 52-11-22.SDR CALA2025091608965None · no discrepancy4R SLIDE PRESSURE IN THE RED. PRESSURE GAGE NEEDLE ON THE SLIDE INFLATION CYLINDER ON DOOR 4R IS IN THE GREEN BAND OR NOT MORE THAN 1/2 THE PRESSURE GAGE NEEDLE WIDTH ABOVE OR BELOW THE GREEN BAND AS PER AMM TASK 25-66-01-206-024. OK TO CONTINUESDR DXTA2025091604946Pushrod · bindingREAPEAT WRITE UP ON MAIN ENTRY DOOR. AFTER CLOSING DOOR AND PULLING THE T-HANDLE TO STOW EXTERIOR HANDLE, THE T-HANDLE IN THE STEPS WILL NOT STOW. IT FEELS AS IF ITS SPRING LOADED TO THE EXTENDED POSITION. WHEN YOU OPEN THE DOOR, YOU HEAR A MOMENTARY EUSH OF ASDR AALA202509155523Slide · inoperativeAIRCRAFT IN BASE MAINTENANCE: SLIDES NEEDS TO BE REMOVED. REMOVED AND REPLACED DOOR SLIDE. PER AMM 25-66-01.SDR AALA202509151885Locking Cam · undertorquedAIRCRAFT WAS GROUNDED: GIRT BAR BRACKET IN BACK OF AIRPLANE NEEDS TO BE TIGHTENED. BRACKET IS COMING UP. REMOVED AND REPLACED FLOOR MOUNTED ESCAPE SLIDE BRACKET HARDWARE. PER AMM 25-66-02.SDR AALA202509158574Bracket · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR FLOOR MOUNTED ESCAPE SLIDE AFT BRACKET HAS INCORRECT HARDWARE. REMOVE AND REPLACED L2 DOOR FLOOR MOUNTED ESCAPE SLIDE AFT BRACKET HARDWARE. PER AMM 25-66-02.SDR AALA202509153350Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-A DOOR IS DIFFICULT TO OPEN AND CLOSE IN FLIGHT. READJUSTED LAVATORY-A DOOR. PER CMM 25-40-64.SDR AALA202509155099Power Supply · no testAIRCRAFT WAS NOT GROUNDED: FOUND EMERGENCY LIGHTS AT R1 DOOR AND ALL OF FIRST CLASS INOPERATIVE WHILE ACCOMPLISHING W/C 09C20033003. REMOVE AND REPLACED BATTER POWER SUPPLY M02816, PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR SWAA2025091514509Sign · brokenCEILING EMERGENCY EXIT SIGN BROKEN. R & R CEILING EMERG EXIT SIGN HOUSING ASSY IAW AMM 33-51-01.