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 AALA202510233008Strap · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED A STRAP HANGING OUTSIDE OF DOOR 4R. MAINTENANCE SECURED LOOSE STRAP BEHIND PLASTIC BUCKLE FOR 4R DOOR ESCAPE SLIDE PER AMM 25-62-44.SDR AALA202510231992Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 12WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202510236610Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: LEFT HAND FORWARD PASSENGER / CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DXTA2025102305380Proximity Switch · out of adjustDURING CLIMB EMERGENCY EXIT OPEN CAS MESSAGE ILLUMINATED AND REMAINED ON UNTIL LANDING. REPEAT WRITE UP. GAINED ACCESS AND ADJUSTED PROXIMITY SWITCH. OPS CHECK GOOD. WORK IAW MM 52-70-15. PRESSURIZED AIRCRAFT TO MAXIMUM DIFFERENTIAL PRESSURE (9.7 PSI). EMSDR DALA2025102307750Actuator · faultedLANDING GEAR NOT LOCKED PASSING THROUGH 14,000FT. LGCIU FAULTING NLG UPLOCK PROXIMITY SENSOR (266082) T/S REF A 320 TSM 32- 31-00-810-827-A POST FLIGHT REPORT FAULTS NLG PROXIMITY SENSOR 12GA AND 13GA TARGET GROUND SCAN OF LDCIU NO FAULTS. REQUIRES FURTHERSDR DALA2025102307749Oil System · leakingDURING PREFLIGHT CREW NOTICED FUMES/OILY SMELL WHEN APU BLEED AIR WAS ACTIVATED . SMELL ESPECIALLY STRONG AROUND ROW 26. C/W W/C 0550-2002 CLASSIFED AS TYPE 1 APU LEAK. C/W W/C 4900- 2001 PLACED APU ON MEL REF LOG 7967753 . C/W LEVEL B DECONTAMINATION OF THE SDR CALA2025102310433Doubler · crackedNR 1 PYLON UPPER FWD SPAR DOUBLER CRACKED AT LT SKIN. REPAIRED THE NR 1 PYLON UPPER FWD SPAR DOUBLER LT SKIN IAW SRM 54 -52-12-300-024.SDR CALA2025102310432Support Angle · crackedLEFT VAPOR BARRIER SUPPORT SIDE ANGLE CRACKED AT BS 663, LBL 5. REMOVED AND REPLACED STIFFENER AT LT VAPOR BARRIER AT BS 663, LBL 5 IAW SRM 51-40-02-0G-0 AND DWG 144A7100.SDR CALA2025102210416Oven · contaminatedOVEN 707 IN AFT GALLEY WAS SMOKING. OVEN 707 INSERT SOILED IN BURNED FOOD DEBRIS. OVEN REQUIRES CLEAN WHEN TIME ALLOWS. OVEN DEACTIVATED.SDR DXTA2025102205386Steering Sys · faultyNOSE GEAR FAILED TO RETRACT ON DEPARTURE. RAN CHECKLIST. BLOWDOWN BOTTLE USED. CORRECTIVE ACTION: REMOVED FAILED NLG POWER STEERING SYSTEM PN:9914650-2 SN:0452, INSTALLED CUSTOMER SUPPLIED OVERHAULED NLG POWER STEERING SYSTEM PN:9914650-2 SN:0191. OPERATIONAL SDR DXTA2025102205381Anti-Skid Valve · faultyTAXIING OUT OF RAMP FELT BRAKES SLIP MOMENTARILY. ON RETURN TO RAMP, APPLIED BRAKES LIBERALLY AT TAXI SPEED AND GOT DISTINCT SLIPPAGE AGAIN WITH ASSOCIATED RIGHT YAW. BELIEVE THE LEFT BRAKE TO BE SLIPPING. DO NOT SEE ANY FLUID OR INDICATIONS OUT OF THE ORDISDR DALA2025102207732Handle · wornPASSENGER ENTRY DOOR L1, EXTERIOR HANDLE MECHANISM PAWL HAS WEAR DAMAGE. REMOVED AND REPLACED PASSENGER ENTRY DOOR L1 EXTERIOR HANDLE MECHANISM PAWL IAW B767 AMM 52-11-26-004-001 AND IAW B767 AMM 52 -11-26-404-003 OPS CHECK GOOD (1262186)SDR DALA2025102207731Handle · wornSERVICE DOOR R1, EXTERIOR HANDLE MECHANISM PAWL HAS WEAR DAMAGE. REMOVED AND INSTALLED NEW SERVICE DOOR R1, EXTERIOR HANDLE MECHANISM PAWL IAW B767 AMM 52-11-26-004-001 AND IAW B767 AMM 52 -11-26-404-003 AND IAW B767 AMM 52-11-26-710-801. OPS CHECK GOOD (126SDR DALA2025102207717Seal · fodDIVERTED TO BOS DUE TO R1 GALLEY DOOR HIGH PITCH SQUEAL. CLEANED DEBRIS & LUBED DOOR SEAL, PRESSURIZED AIRCRAFT. NO DEFECTS NOTED.(7584826)SDR DALA2025102207715Cable · twistedSHIP 9520 DURING SSE WAS FOUND TWISTED PULL CABLE OF TAIL CONE RELEASE SISTEM AT AFTER ACCESSORY COMPARTMENT. CORRECTIVE ACTION: PULL CABLE OF TAIL CONE RELEASE SISTEM AT AFTER ACCESSORY COMPARTMENT WAS INSTALLED CORRECTLY PER B717-200 AMM 53-52-01-830-802 ONLSDR DALA2025102207714Cable · twistedDURING SSE WAS FOUND TWISTED PULL CABLE OF TAIL CONE RELEASE SISTEM AT AFTER ACCESSORY COMPARTMENT. PULL CABLE OF TAIL CONE RELEASE SISTEM AT AFTER ACCESSORY COMPARTMENT WAS INSTALLED CORRECTLY PER AMM 53-52-01-830-802 ONLY STEP E. (1) (S). (1262180)SDR SCNA20251022404Slide · detachedL1 SLIDE DETACHED. OPENSDR KCSA2025102057Relay · faultedDOOR FLIGHT LOCK R1 STATUS MESSAGE. ACTION TAKEN: REMOVED AND REPLACED RELAY K52201 IAW FIM 52-11 TASK 826 AND SWPM 20-81-22, NO HELP. CORROSION FOUND ON R1 DOOR FLIGHT LOCK MECHANISM SPRING. LUBRICATED FLIGHT LOCK MECHANISIM IAW AMM 12-21-20, OPS CHECKED GOODSDR N6WA2025102202Light · missingEMERGENCY ROW FLOOR STRIP LIGHT MISSING. INSTALLED EMERG. ROW FLOOR STRIP IAW CRJ AMM 33-51-01. OPS CHECK GOOD.SDR N6WA2025102201Strap · corrodedAFT WING TO FUSELAGE FAIRING CENTER STRAP HAS CORROSION. REMOVED AND REPLACED AFT WING TO FUSELAGE FAIRING CENTER STRAP IAW CRJ AMM 53-82-83SDR DXTA2025102205387Fuse · blownSEAT NR 4 EMERGENCY PATH LIGHT INOPERATIVE. REMOVED FAULTY SEAT NR 4 PATH LIGHT FUSE AND REPLACED WITH A CUSTOMER SUPPLIED NEW UNIT, OPS CHECKS.ARE GOOD AT THIS TIME. ALL WORK DONE IAW AMM 33-50-15.SDR DALA2025102207705Oxygen Mask · unwanted deployOXYGEN MASK DEPLOYED IN AIRCRAFT RIGHT AFT LAV DUE TO MALFUNCTION. REPACKED AND SECURED O2 MASK IN LAV 202 IAW A320 AMM 35-21-41. OK FOR SERVICE. (LP: 1261184)SDR ASAA2025102061745Door · no discrepancyL1 DOOR JAMMED WHILE OPENING. EXCESSIVE FORCE WAS REQUIRED TO GET IT TO SWIVEL. GROUNDED - YES. VERIFIED WITH CSA AGENT L1 DOOR NOT LATCHED AND CLOSED WHEN ATTEMPTING TO OPEN DOOR FROM THE INSIDE OF ACFT. ACCOMPLISHED AMM TASK 52-11-00-200-801, FWD DOOR ENTRY SDR QXEA2025102100327None · odorFLIGHT 2273. SULFUR OR SEWAGE SMELL COMING THROUGH CABIN GASPERS. CONFIRMED NO LAV CART IN AREA OF EXTERNAL AIR INTAKES. REMOVED FROM SERVICE. SMELL COMING FROM OUTSIDE SOURCE AFTER SOURCE REMOVED, SMELL DEPARTED. COULD NOT DUPLICATE. RETURNED TO SERVICE. NO PSDR SWI2025F01453None · no discrepancySTRONG SMELL OF SMOKE DURING TAKEOFF IN BURBANK. BECAME VERY PRONOUNCED IN TO THRUST AND THEN DISSIPATED WHEN THRUST WAS REDUCED TO CLIMB. FLIGHT ATTENDANTS NOTICED THE STRONG SMELL OF SMOKE WHEN I CALLED THEM AT 10,000 FT. NO FURTHER ANOMALIES IN FLIGHT. (FSDR SWI2025F01452Landing Gear · warning messageD: GEAR DISAGREE WARNING MESSAGE AFTER TAKEOFF. RAN QRH, MESSAGE CLEAREDC: MEL 32-30-1CAT: A DUE DATE: 21 OCT 2025CAT 2 DOWNGRADED ODI EVENT REQUIRES SMOD APPROVAL TO CLEAR MEL. GEAR DISAGREE WARNING MESSAGE AFTER TAKEOFF. RAN QRH, MESSAGE CLEARED (FLIGHT 5SDR SWIA2025102100000Bracket · crackedAFT CARGO DOOR, AFT COUNTER BALANCE BRACKET CRACKED AROUND MOUNTING BOLT (FILED OPEN)SDR DALA2025102107699Oven · odorATB/FUME/DE- DUE TO ODOR IN THE COCKPIT. REPLACED CAPT NAV DISPLAY SCREEN AND FWD GALLEY NR 2 OVEN.SDR DALA2025102107696Outlet · inoperativeACRID ELECTRICAL SMELL IN AFT CABIN ROW 25/ 26. INSPECTED ITEMS IN STEPS 1-5. PED POWER OUTLET IS INOPERATIVE AT SEAT 26 C. REPLACED PER POWER OUTLET IAW AMM 24-58. INSPECTED RECIRCULATION FANS AND REPLACED FILTERS OPS NORMAL IAW AMM 21-25. (1262145)SDR DALA2025102107694Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE ON ROWS 23,24,25,26. R & R BATTERY CHARGER (M10567) REF AMM 33-51. OPS CHECKED GOOD. (7957579)SDR AALA202510212775Fuel Sys · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CRUISE, SUSPECTED FUEL LEAK ON ENGINE NUMBER 1. VERIFIED LEFT MAIN FUEL QUANTITY INOPERATIVE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. (OPEN).SDR AALA202510210129Flap System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING APPROACH FLAP INDICATION WERE SPLIT CONDUCTED A GO AROUND. AIRCRAFT EMERGENCY LANDED SAFELY AT DFW. (OPEN).SDR AALA202510213148Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 18C EMERGENCY LIGHT PANEL ON THE SIDE IS BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT PANEL ON SEAT 18C. PER CMM 25-23-67. OPERATIONAL CHECK GOOD.SDR AALA202510210424Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS LAVATORY-D DOOR IS HARD TO OPEN. (OPEN).SDR AALA202510210915Sliding Window · lack of lubeAIRCRAFT WAS NOT GROUNDED: L2 SLIDE WINDOW DOES NOT SLIDE FREELY. LUBRICATED TRACK. PER AMM 25-11-00. OPERATIONAL CHECK GOOD.SDR AALA202510212086Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN COVER IN FORWARD GALLEY NEAR SERVICE DOOR IS BROKEN. REMOVED AND REPLACED RIGHT HAND FORWARD EXIT SIGN COVER NEAR SERVICE DOOR. PER AMM 33-51-01.SDR AALA202510218266Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY-D IS DIFFICULT TO OPEN AND UNLOCKED. TIGHTENED DOOR CUTOUT SCREW. PER AMM 25-40-14.SDR AALA202510216829Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY PACK FLASHING RED. REPLACED FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202510218349Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR HARD TO OPEN. LUBED LAVATORY-E DOOR.SDR HNAA2025102100721Light · inoperativeRH OVERWING EXTERIOR AFT EMERGENCY LIGHT INOP. RAR LIGHT ASSY IAW AMM TASK33-50-10SDR DALA2025102107693Controller · faultySHIP 3274 - ATB - DUE TO CABIN PRESSURE ISSUES AND LOW CABIN DIFFERENTIAL PRESSURE MESSAGE. CREW WAS ABLE TO REGAIN PRESSURE USING MANUAL CONTROL. CORRECTIVE ACTION: REPLACED OUTFLOW VALVE AND CPC 2. (LP: 7368374)SDR AALA202510214204Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK CENTER WINDSHIELD FRAMING LEFT HAND CONTINUITY FITTING BETWEEN FR 2 AND FR 3 AT Y0 LEFT. REPLACED CONTINUITY FITTING PER EO 5319Y017-002.SDR AALA202510218031Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK CENTER WINDSHIELD FRAMING RIGH HAND CONTINUITY FITTING BETWEEN FR 2 AND FR 3 AT Y0 RIGHT. REPLACED CONTINUITY FITTING PER EO 5319Y017-002.SDR HALA20251021325Controller · faultedETOPS - BTB > DURING ENGINE 2 START UP GOT ENG OVSPD PROT FAULT FOLLOWED BY: FO AOA HEAT, FO PITOT HEAT, FO TAT HEAT, FO STATIC HEAT. REMOVED AND REPLACED PHC 2 PER AMM 30-31-34. BITE CHECK OK. OPS CHECK W/ PROBE/ WINDOW HEAT SWITCH OK. CHK'D WIRING ON PHC 2 -SDR YENA2025102101051Relay · faultedFLT#353, BOS-DUB. (ETOPS) CLASS 2 AIRBLEED MESSAGE ON THE STATUS PAGE. ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED); (RESOLVED ON W/O: 1448775 TASKCARD: NR-00002) REPLACED RELAY 21HV ISDR YENA2025102101049Coffeemaker · odorFLT#1552, RSW-HPN. "CABIN ODOR WITNESSED BY INFLIGHT CREW AT CRUISE. DIRTY SOCK PLASTIC BURNING AFT OF ROW 22 STRONGEST AFT GALLEY A.C LEFT; PERFORMED INFO NOTICE 2017-T015L. C/W APU COMPARTMENT INSPECTION NO OIL/FUEL LEAKS NOTED VISUAL OR WITH BLACK LIGHT. APSDR BAGA2025102100002Power Supply · failedLH OVERWING EMERGENCY DOOR INTERIOR EXIT SIGN AND LH OVERWING FWD EXTERIOR EMERGENCY LIGHTS INOP. REPLACED EMERGENCY LIGHTING ELPU #4.SDR YENA2025102101048Fcu · leakingFLT#734, SFO-BOS. "OIL FUME EVENT RECOGNIZED BY PILOTS, INTERMITTENT THROUGHOUT DESCENT FROM 10,000 FT TO THE GROUND. UNABLE TO ISOLATE/IDENTIFY SOURCE. F/A'S DID NOT RECOGNIZE ODOR; C/W INFO NOTICE 2017-T015 SECTION B2, FOUND SOURCE TO BE APU TYPE 1, FOUND FCSDR AJXA202510200038Electrical Sys · faultedPILOT REPORTED A PARTIAL ELECTRICAL FAILURE IN COCKPIT. POWER WAS LOST ON THE COPILOTS MFD AND PFD.SDR DALA2025102107683Shear Tie · gougedGOUGE SHEAR TIE LOCATED FR25 AND BTW STR39L TO STR40L IN FWD CARGO COMPARTMENT. REPLACED SHEAR TIE LOCATED FR25 AND BTW STR39L TO STR40L IN FWD CARGO COMPARTMENT AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1262195).