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 CALA2025082608137Frame · crackedFRAME 35, S30R HOLE #1, #3, #9 DAMAGED.ACCOMPLISHED INTERIM REPAIR PER ECRA 5311-02126 REV C. WITH NO DEVIATIONS. ACCOMPLISH INSPECTION REQUIREMENTS AT RH FR35 STGR30RH ANGLE FITTING AND LH/RH FR35 STGR30 HOLES #1, #3-#9 PER PART 2B OF THE LATEST REVISION OF ESDR DALA2025082206253Not Reported · not reportedER/A 628422-14AD REVISION ORIGINAL. REPAIR AT LT SIDE OF VERTICAL STAB SPAR AT ZFS=52.267. (1144341)SDR CALA2025082208056Control Unit · faultedRTO DUE TO LEFT ENG SURGE AND STALLDEBRIEF FROM CREW PUSHING THROTTLES UP TO 70% N1 LH ENG SLOW TO ACCELERATE. ENGAGED AUTO THROTTLE AND ENGINE SPOOLED UP AND THENN1 ROLLED BACK TWICE TO 90% N1. F/O MAY HAVE SEEN EXCEEDANCE BUT NO RED BOX SHOWING. CREW HAD NO SDR CALA2025082208054Elt · no testTHE FOWARD PORTABLE ELT DOES NOT TURN ON. PERFORMED PORTABLE EMERGENCY LOCATOR TRANSMITTER BITE TEST, NO HELPS DUE TO ELT IS NOT TURNING ON. IT HAS OBSCURED ASSOCIATED ELT PLACARD USING MASKING TAPE. INSTALLED INOPERATIVE STICKER ON AFFECTED ELT. , DEFER FWD SDR AALA202508215184Tube · missingAIRCRAFT IN BASE MAINTENANCE: L2 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE NEED REPLACED AT AFT. REPLACED HEAT SHRINK TUBING. PER 737MAX AARD 25-66-00.SDR CALA2025082108003Skin · dentedCOMPLETE RE-SKIN OF FWD CARGO DOOR ASSEMBLY TO CLEAR ALL DENT DMG DEFERRALS. (REF AAR RFD NR 1000045300) REMOVED AND REPLACED FWD CARGO DOOR EXTERNAL SKIN ALL IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08- 0G-0, SRM 51-20-01-0G-0, AMM 51-21-72-370-8SDR AALA202508205835Flashlight · missingAIRCRAFT IN BASE MAINTENANCE: FLASHLIGHT MISSING IN FORWARD FLIGHT ATTENDANT SEAT AT LEFT HAND SIDE. REPLACED MISSING FLASHLIGHT. PER AMM 25-64-00.SDR AALA202508205583Slide Raft · bulgedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE HITS FUSELAGE WHEN OPENING DOOR. MAINTINANCE INSTALLED NEW L1 DOOR SLIDE ON ROUTINE JOB CARD 26L0002511-L1.SDR AALA202508203648Life Vest · openAIRCRAFT IN BASE MAINTENANCE, SEAT 4B PASSENGER LIFE VEST PLASTIC BAG OPENED. REMOVED AND REPLACED PASSENGER LIFE VEST AT SEAT 4B. PER AMM 25-22-00.SDR CALA2025082007983Skin · crackedON THE LH WING LOWER OUTBOARD SKIN PANEL EXTERNAL REPAIR LOCATED AT STRINGER L-9 AND WSTA 556, SKIN CRACK REPAIRED AT OTBD FASTENER OF STR 9. FLANGE. BETWEEN STA. 564.5 - STA. 537.5. PER ECRA: 5725-01165. ON THE LH WING LOWER OUTBOARD SKIN PANEL EXTERNAL REPASDR CALA2025082007969Skin · wrinkledFOWARD CARGO DOOR SKIN REQUIRES RESKIN. REMOVED AND REPLACED OUTER DOORE SKIN PN: 143A612Y2 PO 1121069.1 IAW BAC 737-800 SRM 52-30-01-2R-3 REPAIR #3 AND SRM 51-40-02 AND BAC DWG 143A6110 SH 3 REV D.SDR DALA2025081906216Support · gougedTHREE GOUGES ON WTBF SUPPORT STRUCTURE AT FR38, BETWEEN RBL25 AND RBL30. REMOVED AND REPLACED WING TO BODY SUPPORT P/N: C02381124-002, PO :1049347 IAW A220 ASRP BD500-A-J51-42-21-00AAA-078A-A. AT FR 38 RH SIDE BETWEEN RBL 25 AND RBL 30. (LP# 1145374)SDR DALA2025081906213Service Panel · corrodedCORROSION ON WASTE WATER SERVICE PANEL SURROUNDING SKIN CUTOUT, FWD INBOARD CORNER [SSI:53-61-56-02]. GENERATED FOR SCEPTRE ENTRY UPDATE. REMOVED AND REPLACED WASTE SERVICE PANEL INTERNAL DOUBLER IAW ER /A 628360-14AD REV ORIGINAL. WORK ACCOMPLISHED ON CUSTOMESDR ASAA2025081560172Light · malfunctionedAFT EMERGENCY LIGHT OVERHEAD ROW 26ABC ILLUMINATED FOR FIRST HALF OF FLIGHT. GROUNDED - YES. PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTING SYSTEM. OPS TEST NORMAL IAW AMM 33-51-00.SDR AALA202508199726Tube · tornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE NEED REPLACED BOTH FORWARD AND AFT. REMOVED AND REPLACED L1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE. PER AARD 25-66-00.SDR AALA202508192436Tube · crackedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR RED HEAT SHRINK TUBING CRACKED AND TORN ON BOTH ENDS OF GIRT BAR. REMOVED AND REPLACED L1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE. PER AARD 25-66-00.SDR AALA202508194429Tube · degradedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR RED HEAT SHRINK TUBING DEGRADED ON BOTH ENDS OF GIRT BAR. REMOVED AND REPLACED R1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE. PER AARD 25-66-00.SDR AALA202508195478Tube · missingAIRCRAFT IN BASE MAINTENANCE: R1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE NEED REPLACED AT AFT. REMOVED AND REPLACED R1 DOOR SLIDE CASE GIRT BAR RED SHRINK TUBE. PER AARD 25-66-00.SDR AALA202508194559Girt Bar · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY AND FORWARD SERVICE DOORS BOTH GIRT BARS REQUIRED EXCESSIVE FORCE TO ARM AND DISARM. CORRECTED Z-FOLD, PER AMM 25-66-01-601.SDR AALA202508197772Grip · damagedAIRCRAFT IN BASE MAINTENANCE: FORWARD LEFT HAND OVERWING EMERGENCY EXIT DOOR "GRIP ASSEMBLY ACCESS" WHERE THE LIFT HANDLE GETS MOUNTED TO ON THE DOOR LINER FOUND DAMAGED. REPLACED DAMAGED GRIP ASSEMBLY ON FORWARD LEFT HAND OVERWING EXIT DOOR. PER AMM 52-22-51.SDR AALA202508196179Strap · frayedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EMERGENCY EXITD DOOR RED PULL STRAP IS FRAYED. REMOVED AND INSTALLED A SERVICABLE RED PULL STRAP ON THE RIGHT HAND OVERWING EMERGENCY EXIT DOOR. PER AMM 52-22-00.SDR SWAA2025081904973Battery Pack · inoperativeEMERGENCY AISLE LIGHTS INOP LT & RT ROWS 3-14 INOPERATIVE. FOUND TWO BATTERY PACKS TO BE AT FAULT. REMOVED, REPLACED, AND OP CHECKED NEW M2335 AND M1676 BATTERY PACKS IAW AMM 33-51-06-960-805. OPS CHECKED GOOD.SDR SWAA2025081904811Tire · blown#2 MAIN TIRE BLOWN AT APPROXIMATELY 110 KNOTS ON TAKEOFF. NO ENGINE OR FLT CONTROL ABNORMALITIES NOTED. NO OVER-WEIGHT LANDING. MIN BRAKING USED ON LONG RUNWAY WITH LONG ROLLOUT. REMOVED & REPLACED NR 1 & 2 MWA'S IAW AMM 32-45-11.SDR AALA202508192006Control Panel · odorAIRCRAFT WAS GROUNDED: ACRID SMELL IN FLIGHT DECK. ACCOMPLISHED CARD 08L00021001. FOUND TCAS AND ATC PANEL PRODUCING ACRID ODOR. REMOVED AND REPLACED PANEL, PER AMM 34-53-03.SDR AALA202508195088Radar · intermittentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WEATHER RADAR FAILED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. TROUBLESHOOTING PER FIM 34-43-00-810-814, NOT FAULTS NOTED, NO FAILT FOUND. OPERATIONAL CHECK GOOD.SDR AALA202508195038A/C Pack · contaminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF SMOKE REPORTED IN THE CABIN BY FLIGHT ATTENDANTS AND PASSENGER. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT BZN. ACCOMPLISHMENT W/C 08L00021001. INSPECTED APU COMPARTMENT AND INLESDR AALA202508195754Slide Raft · wornAIRCRAFT WAS GROUNDED: INFLIGHT DOOR 2R DISARMS INTERMITTENTLY ON DOOR SD PAGE AND FA REPORTS ARMING HANDLE DOESN'T STAY FLUSH BUT IS FLUSH ON THE GROUND. MAINTENANCE FOUND GIRT BAR WORN AND REPLACED EMERGENCY SLIDE IAW AMM 25-62-44.SDR AALA202508198950Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY MARKER LIGHT ASSEMBLY HAS MULTIPLE BULBS INOP. RELAMPED EMERGENCY EXIT LIGHT AT DOOR R1, OPS GOOD.SDR AALA202508198093Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1. DOOR BOTTLE PRESSURE LOW. MAINTENACE SERVICE EMERGENCY DOOR ASSIST BOTTLE PER AMM 52-11-14.SDR AALA202508196355Cradle · brokenAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT LOCATED BELOW FWD FLIGHT ATTENDANT SEAT (OUTBOARD SEACORRECTION: INOP FLASHLIGHT IS INSIDE INBOARD SEAT CLOSET.T) INOP DUE TO MIC #1437655 MEL 25-15B. MAINTENANCE REPLACED FLASHLIGHT HOLDER/CHARGER.SDR SWAA2025081905058Fseu · inoperativeFLAPS & SLATS PRIMARY CONTROL INOP. ALT FLAPS NORMAL. PERFORMED BITE CHECK ON FSEU AND FOUND 27-81224, FOLLOWED FIN TASK AND FOUND FSEU BAD. R & R FSEU PER AMM 27-51-01. SYSTEM OPS CHECKS OK.SDR CALA2025081907941Bracket · out of adjust1L GIRT BAR BRACKETS NEED ADJUSTMENT. GIRT BAR WAS TIGHT AND HARD TO REMOVE FROM HOLDING BRACKETS. LOOSTENED BRACKETS GIRT BAR EASIER TO REMOVE. 25-64-00SDR CALA2025081907915Unknown · odorCONDITIONAL INSPECTION 05-05-58-800-801-C3 SMOKE/ODOR IN THE FLIGHT DECK/CABIN - MAINTENANCE PRACTICES NEEDS TO BE REFERENCE FOR ANY SMOKE OR ODOR OCCURRENCE. GENERAL ACCOMPLISHED INSPECTION ON THE MID GALLEY OVENS, NO DEFECT OR BURN FOUND. ACCOMPLSHED PER AMMSDR CALA2025081907913Door · damagedFLIGHT DECK DOOR HEAVILY DAMAGED BY LOOSE GALLEY CART ON LANDING. UPDATED LABOR TO 6, 2 TECHS NEEDED FOR R&R UPDATED ITEM WITH SDR INFOMATION. SEE IPC 52-51-01-01 ITEM #20,MFG P/N: B221250-505. R&R PER AMM REF TASK 52-51-01-400-801. DOOR OPENS CLOSE AND LOCKSSDR CALA2025081907911Oxygen Gen · dischargedSEAT 30ABC O2 GENERATOR ACCIDENTLY DISCHARGED. MASKS ARE STOWED REF AMM TASK 35-22-11-400-804-001. COMPLETED REMOVE AND REPLACE OF SEAT 30 ABC O2 GENERATOR. ACCOMPLISHED IDT REQUIREMENTS PER GMM 09-10-05 FOR OXYGEN GENERATOR REPLACEMENT AT ROW 30ABC.SDR GTIA2025081839050Epsu · faultyEPSU 10WL DISPLAYS UNIT FAULT.-REMOVED AND REPLACED EPSU 10WL IAW AMM 33-51-38 AND AMM 33-51-00. OPS CHECK GOOD.SDR NACA2025081500001Sensor · failedLEFT PACK TEMP EICAS MESSAGE CAME ON THEN WENT OUT BEFORE WE COULD DO THE QRH. PERFORMED L PACK TEMP CONTROLLER BITE PER FIM 21-51 FT 803. FOUND COMPUTER SENSOR FAULT,. REMOVED AND REPLACED LEFT PACK COMPRESSOR AUTO OUTLET SENSOR PER AMM 21-51-05 OPS CHECK GOOSDR JJBA20250818039Pump · inoperativeHYD 2 LOW QTY ON EICAS IN FLIGHT. REMOVED AND REPLACED EDP. PERFORMED OPS CHECK. RAN ENG 2. OPS CHECK GOOD. NO LEAKS NOTED AT THIS TIME. SERVICED #2 HYD.SDR HALA20250818252Bleed Valve · malfunctionedETOPS - AIR ENG 2 BLEED NOT CLOSED AFTER APU BLEED TURNED ON. REMOVED AND REPLACED ENG 2 PRESSURE REGULATOR VLV PER AMM 36-11-52-400-804-A. OPSC CHECK GOOD. NO FUALTS NOTED. OK FOR SVC.SDR HALA20250818250Jumper · wornETOPS - DURING TASK CARD E1128-321-26-011 PYLON. FOUND JUMPER ON LPT ACC COOLING TUBE ON 3 OCLOCK WORN OVER LIMIT. REMOVED LPT ACC COOLING TUBE PER AMM 75-00-00-210-802-A ALEX 023895. INSTALLED LPT ACC TUBE WITH NEW JUMPER 1EA. IDLE RUN. FOUND NO LEAK. OK FOR SDR YENA2025081800846Slide Raft · failedFLT # 133, MCO-SJU.R2 DOOR SHOWS DISARMED IN FLIGHT . SHOWS ARMED ON THE GROUND. ARM HANDLE DOES NOT STAY DOWN IN FLIGHT ; R/R RH 2 DOOR AFT ESCAPE-SLIDE RAFT IAW AMM 25-62-44-400-803-A. OPS CKS PERFORMED NORMAL AT THIS TIME.SDR YENA2025081800845A/C Pack · odorFLT # 1567. PBI-HPN.AT 10,000' WE GOT A LVL 1 ODOR FUMES EVENT. TURNED OFF PACK #1 FUMES ODOR WENT AWAY. ODOR WAS IN COCKPIT; COMPLIED WITH INFO NOTICE 2017-T01, SECTION A, ISOLOATED FAULT TO TYPE 10, INSULATION FOUND IN DUCT TO HOT AIR VALVE (REMOVED) PERSDR YENA2025081800844Computer · failedFLT # 2427 FLL-MBJ, AIR RETURN BACK INTO FLL. DUAL INPUT CALL AT ABOUT 2500FT, WHEN THERE WAS NO DUAL INPUT ECAM FOR ELAC 2 PERFORMED THE RESET PROCEDURE BUT THE ECAM CAME BACK THE AIRCRAFT DID TWO SHARP JERKS AFTER TAKEOFF TO THE RIGHT;TWO AIRCRAFT MOVEMENTSSDR YENA2025081800843Computer · failedFLT # 2427 FLL-MBJ, AIR RETURN BACK INTO FLL. DUAL INPUT CALL AT ABOUT 2500FT, WHEN THERE WAS NO DUAL INPUT ECAM FOR ELAC 2 PERFORMED THE RESET PROCEDURE BUT THE ECAM CAME BACK THE AIRCRAFT DID TWO SHARP JERKS AFTER TAKEOFF TO THE RIGHT;TWO AIRCRAFT MOVEMENTSSDR YENA2025081800842Pump · failedFLT # 1793 JFK-SJO, DIVERTED TO MCO.DIVERTING TO MCO DUE TO THE LOSS OF THE YELLOW HYDRAULIC PUMP LEVEL AND PRESSURE.1 PRIOR YELLOW HYD SYS LEAK FROM THE #4 SPOILER ON THE 3RD-THE SPOILER WAS REPLACED, PER TSM 05-50-00-810-802-A. NO MX ACTION REQUIRED- NO HARDSDR SWIA2025081800015Warning Message · illuminatedD:AFTER TAKE OFF RECEIVED GEAR OVHT FOLLOWED BY BRAKE OVHT. BOTH EXTINGUISHED AND RE ILLUMINATED. (BELIEVE TO BE ERRONEOUS BECAUSE OF HISTORY AND AFTER RUNNING QRH BTMS OFFENDING #4 ONLY SHOWED TEMP OF 1). RETURN TO DENVER EXTENDING GEAR BRAKE OVHT WARNING TRSDR DALA2025081806175Skin · corrodedRIGHT WING TOP SKIN PANEL 2 LOWER SURFACE T/E OVERHANG AREA, AT RIB 17 +190MM SKIN WITH CORROSION. PERFORMED REPAIR AT TOP SKIN PANEL 2 LOWER SURFACE, T/E OVERHANG AREA AT RIB 17+410MM (AREA 10) I/A/W ER/A 627459-14AD. (1145846)SDR DALA2025081806174Skin · corrodedLEFT WING, TOP SKIN PANEL 2 LOWER SURFACE, TRAILING EDGE, OVERHANG AREA, WITH CORROSION AT RIB 11 + 115MM. PERFORMED REPAIR BY INSTALLED EXTERNAL REPAIR DOUBLER AT TOP SKIN PANEL 2, T/E OVERHANG AREA AT RIB 11+115MM (AREA 5) I/A/W ER/A 627460-14AD. (1145623)SDR DALA2025081806173Skin · corrodedLEFT WING TOP SKIN PANEL 2 LOWER SURFACE, TRAILING EDGE, OVERHANG AREA AT RIB 11+490MM WITH CORROSION. PERFORMED REPAIR BY INSTALLED EXTERNAL REPAIR DOUBLER AT TOP SKIN PANEL 2, T/E OVERHANG AREA AT RIB 11+490MM (AREA 6) IAW ER/ A NO. 627460-14AD. (1145536)SDR DALA2025081806172Skin · corrodedRIGHT WING TOP SKIN PANEL 2 LOWER SURFACE T/E OVERHANG AREA, AT RIB 14 +45MM SKIN WITH CORROSION. PERFORMED REPAIR AT TOP SKIN PANEL 2 LOWER SURFACE, T/E OVERHANG AREA AT RIB 14+45MM (AREA 6) I/A/W ER/A 627459-14AD. (1145496)