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 DALA2025121009036Fuel Sys · out of balanceATB, DUE TO "FUEL IMBALANCE" AND "FMS FUEL" CAUTION MESSAGES. CORRECTIVE ACTION: RH AND LH EJECTOR PUMPS AND 90 ELBOW TUBES FOUND DAMAGED ALONG WITH ONE LH CHECK VALVE. ALL DAMAGED COMPONENTS REPLACED. R/R LH TRANSFER FLOAT SOV. A/C RTS. (LP# 7950252, 1335358,SDR DALA2025121009027Vent · corrodedCORROSION WAS FOUND ON ACTUATOR VENT INSIDE ACCESS PANEL 196HL AT RH OVER-WING ESCAPE SYSTEM. OFF-WING ESCAPE SYSTEM ACTUATOR RH WITH WAS REPLACED PER B757-200 AMM 25-65-05. (1341788)SDR DALA2025121009022Floorbeam · corrodedUPPER CABIN, FS 1681 FLOORBEAM UPPER SURFACE, CORROSION, LEFT OF CENTER GOING OTBD APPROX 20 INCHES INCLUDING SCREW HOLES. REMOVED CORROSION AT UPPER CABIN STA 1681 FLOORBEAM, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE AND REPAIRED FLOORBEAM IAW SRM 53-00-51 SDR DALA2025121009013Housing · dirtyATB, CREW REPORTED CABIN ODOR IN AFT CABIN ON TAKEOFF CLIMB. BORESCOPE BOTH ENGINES, NO DEFECTS NOTED. INSPECTED THE BOTH PACKS COALESCER BAGS AND FOUND THE HOUSING DIRTY. PERFORMED HIGH POWER RUNS WITH SNIFFER, NTF.SDR DALA2025121009012Switch · faultedATB, CREW REPORTED SMOKE IN THE COCKPIT WITH ASSOCIATED ELECTRICAL SMELL. FOUND ELECTRICAL ODOR TO BE EMITTING FROM THE FIRST OFFICERS MASTER CAUTION PUSH BUTTON SWITCH AND WARM TO TOUCH. REPLACED SWITCH.(7791702)SDR DALA2025121009011Slide · dislodgedL1 EVACUATION SLIDE COMPARTMENT OPEN, SLIDE DISMOUNTED. INSTALLED L1 DOOR EVACUATION SLIDE IAW AMDS WORKCARD 2561-9004. (7796904)SDR YENA2025121001191Metering Unit · failedFLT 424, LAX-JFK. (ETOPS) ENG 2 FADEC SYS FAULT ENG 2 MINOR FAULT OIL SYSTEM FAULT GATE RETURN HAVING CB RESET; REMOVED AND REPLACED R/H ENGINE PHMU IAW AMM CH. 77-31-01. RAN ENGINE, NO FAULTS FOUND.SDR DALA2025121009006Fitting · corrodedCORROSION WAS FOUND ON THE LH MLG RIB 6 FITTING, FORWARD LUG. COMPLIED WITH ERA 630453-14. (1342024)SDR AALA202512100699Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER CYLINDER PRESSURE IS LOW (1300PSI 32 DEGREES). MAINTENANCE CHARGED L1 DOOR DAMPER CYLINDER WITH NITROGEN IAW AMM 52-10-00-614-001-A.SDR AALA202512109326Slide · out of adjustAIRCRAFT WAS GROUNDED: 1R DOOR ARMING HANDLE IS NOT FLUSH WHEN ARMED. MAINTENANCE REPLACED R1 SLIDE RAFT IAW J/C 26L00025011.SDR AALA202512103632Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: FWD MEGAPHONE FOUND DAMAGED. MAINTENANCE REPLACED FWD MEGAPHONE IAW J/C 26C00025003.SDR AALA202512100363Oxygen Mask · unwanted deployAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: O2 MASKS OVER ROW 19 SEATS ABC DEPLOYED AND EXPANDED OXYGEN. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. REPLACED OXYGEN GENERATOR. PER MM 35-22-11.SDR AALA202512107219Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS CIDS PANEL SHOWS 2R DOOR WILL NOT ARM DURING PREFLIGHT. FLIGHT DECK INDICATIONS SHOW THAT IT IS ARMING SUCCESSFULLY. MAINTENANCE SERVICED THE 2R DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512104767Elec Connector · damagedAIRCRAFT WAS GROUNDED: SEAT ROW 37ABC SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND A DAMAGED CONNECTOR BEHIND THE SIDEWALL, REPALCED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUES NOTED.SDR R61A2025121080523Skin · damagedMAJOR REPAIR: NUMEROUS DAMAGES AROUND EXISTING DOUBLER REPAIR BETWEEN FR 9-12 AND STR 14L-19L. CUT OUT OIL CANNING SECTION AFT OF FR.9 BELOW STR.18L, REMOVED PREVIOUS REPAIR DOUBLER, AND INSTALLED 1 DOUBLER AND 2 FILLERS IAW ETD2025-170-933646.SDR CALA2025121011990Stringer Clip · corrodedSTRINGER CLIP CORRODED. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-OG-0.SDR CALA2025121011988Skin · corrodedAFT CABIN METALIC PRESSURE DECK BETWEEN BS 1680 - 1720, UPPER SURFACE CORRODED BETWEEN LT CREASE BEAM TO RT CREASE BEAM. REF NRC 137952. REMOVED CORROSION AT AFT CABIN FLOOR METALIC PRESSURE DECK BETWE EN BS 1680 - 1720 UPPER SURFACE AND FOUND WITHIN LIMITSSDR CALA2025121011986Skin · corrodedCROWN SKIN BS 727C - 727F, S3L-S4R FOUND WITH CORROSION & SCRATCHES. SKIN BS 727C - 727F, S3L-S4R REPAIRED IAW ECRA 5331-03190, REV A.SDR CALA2025121011984Floorbeam · crackedMAIN CABIN LEFT BS 540 FLOORBEAM CRACKED AROUND FASTENER HOLE. REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-40-02, AND DWG 143A5240, REV-.SDR CALA2025121011982Floorbeam · corrodedCABIN FLOORBEAM, BS 328, RBL 38 UPPER SURFACE CORRODED. FLOORBEAM BS 328 EXISTING REPAIR TEE ANGLE BETWEEN LBL 6 & RBL 63 FOUND OUT OF LIMITS ,TEE ANGLE WAS REMOVED AND REPLACED IAW 51-40-02-0G-0, AND DWG 141A5720.SDR CALA2025121011980Floor Support · crackedCABIN FLOOR SUPPORT,BS 500I - 520, BL 0 STABILIZER ASSY UPPER ANGLE CRACKED. REMOVED AND REPLACED IAW SRM 51-40-02-0G-0 AND DWG 143A5400.SDR CALA2025121011978Doubler · damagedUPPER FUSELAGE CROWN BS 727D, S3R LTV FAIRING ATTACH FITTING SKIN DOUBLER HAS FASTENER HEADS IN THE CHAMFER. EDGE OF THE DOUBLER IS DEFORMED. REMOVED AND REPLACED SKIN DOUBLER IAW EC/RA #5331-03191, DWG 739K2207 AND 739N2200.SDR SWIA202512090008Trim System · runawayROUGHLY 2000FT AFTER TAKEOFF. STAB TRIM & MACH TRIM CAUTION APPEARED. REENGAGED BRIEFLY & BEGAN HAVING STAB TRIM RUNAWAY. DISCONNECTED TRIM & USING MEMORY ITEMS. SHORTLY AFTER, AILERON TRIM KICKED OFF AND RECEIVED AILERON LWD AND RWD. AIRCRAFT BECAME EXTREMESDR AALA202512098048Skin Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER UPPER SKIN PANEL DELAMINATED BETWEEN FRONT SPAR STA 177.9 AND 228.526. REPAIRED PANEL PER SRM 55-10-01-2R REPAIR 2.SDR SWAA2025120943954Slide · dislodgedR1 DOOR SLIDE DISLODGED. INSTALLED R1 DOOR ESCAPE SLIDE IAW MT 725-61-06 AND AMM 25-66-01.SDR F3LA202512090335Battery Pack · inoperativeACFT WAS GROUNDED. WHILE PERFORMING EPSU TEST, BATTERY/EPSU 10WL FWD L FLAGGED. AIRCRAFT REMOVED FROM SERVICE. R & R EPSU BATTERY 10WL IAW AMM 33-51-38-400-002-A, OPS CHECK GOOD. ACFT OK FOR SERVICE.SDR AALA202512094733Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE DOOR IS IMPOSSIBLE TO OPEN UP WHEN CLOSED WITH THE ELECTRONIC SWITCH IN OFF POSITION. SPRAYED LUBRICANT ON LATCH ASSEMBLY ON FLIGHT DECK DOOR. PER FIM 52-50-00. OPERATIONAL CHECKED GOOD.SDR AALA202512098506Slide · wornAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ESCAPE SLIDE LOWER FABRIC TORN AND WORN. REMOVED AND REPLACED SLIDE. PER AMM 25-66-01-401.SDR AALA202512090987Door · bindingAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR APPEARS TO BE BINDING IN THE CLOSED POSITION. IT IS DIFFICULT TO INITIALLY PULL OPEN. SECURED LOOSE HARDWARE AT LAVATORY DOOR HINGE.SDR AALA202512095799Elec Connector · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INTERMITTENT SPEED LIMITS FLAG ON BOTH PRIMARY FLIGHT DISPLAY AND ON HUD. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHL. REMOVED AND REPLACED PLUG D365 (AALA202512095799), PER SWPM 20-26-11. ALSO, REMOVESDR AALA202512093233Computer · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INTERMITTENT SPEED LIMITS FLAG ON BOTH PRIMARY FLIGHT DISPLAY AND ON HUD. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHL. REMOVED AND REPALCED PLUG D365 (AALA202512095799), PER SWPM 20-26-11. ALSO, REMOVESDR KCSA20251209872Door · unsecureFLT DECK DOOR OVHD. CLOSED HANDLE ON OVHD HATCH VERIFIED SECURED SHUT STATUS CLEARED IAW AMM 52-21-00 NO FURTHER DEFECTS.SDR YENA2025120901187Unknown · odorFLT 1499, BOS-DAB. INFLIGHT REPORTED AN INTERMITTENT ODOR DURING FLIGHT. WAS REPORTED AS SMELLING LIKE KEROSENE BY ONE INFLIGHT CREW MEMBER. ODOR WAS NOT STRONG BUT NOTICABLE. ODOR WAS RIGHT SIDE ROWS 22-26; FIM 21-22-00 PERFORMED CABIN INSPECTION NO EVIDENCE SDR YENA2025120901186Unknown · odorFLT 503, JFK-SJU. ODOR DETECTED DURING DESCENT BELOW 10,000. CONFIRMED WITH CABIN CREW. LOCATION OVERWING EXITS STRONGEST, AND FWD. LASTED A MINUTE THEN DISSAPATED. FOUL HEATED PLASTIC TYPE ODOR, FOLLOWED INFO NOTICE 2017-T015L WITH MX-270 PROVIDED. TSM 05-5SDR IXXA20251208084Power Supply · inoperativeEMERGENCY EXIT SIGN BY L1 DOOR DOES NOT ILLUMINATE DURING LIGHT TEST. REMOVED AND REPLACED POWER SUPPLY IAW B767 AIRCRAFT MAINTENANCE MANUAL 33-51-07. OPS CHECKED GOOD.SDR DALA2025120908976Power Supply · dischargedSEVERAL EMERGENCY LIGHTS OUT IN AFT RIGHT CABIN. R & R EPSU 18WL IAW AMM 33-51. OK FOR SERVICE. (7790019)SDR DALA2025120908974Lug · corrodedCORROSION WAS FOUND ON THE LT MLG RIB 6 FITTING FED LUG. REPAIRED CORROSION IAW ERA 630453-14. (1342015)SDR DALA2025120908973Doubler · damagedL4 DOOR EXTERNAL SURFACE AFT LOWER CORNER FOUND EXISTING REINFORCING REPAIR THAT WAS DAMAGED. RE-WORKED DOUBLER ON CABIN L4 DOOR EXTERNAL SURFACE AFT LOWER CORNER AS PER ER/A 630741-14 REV ORIGINAL. (1341275)SDR DALA2025120908972Bottle · low pressureR4 DOOR DAMPER LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8216939)SDR AALA202512094291Handle · detachedAIRCRAFT WAS NOT GROUNDED: 2R DISARM DOOR HANDLE CAME OFF WHEN DISARMING UPON ARRIVAL. MAINTENANCE RESECURED LOOSE HARDWARE AT 2R DISARM DOOR HANDLE AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 52-22-21.SDR AALA202512094093Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS 1L DOOR CHECK DOOR PRESSURE MESSAGE DISPLAYED. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202512090384Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFTER ARMING ALL DOORS CIDS PANEL AT 1R SHOWS CHECK DOOR PRESSURE IN AMBER FOR DOOR 4R. MAINTENANCE SERVICED THE 4R DOOR DAMPER AND EMERGENCY OPERATION CYCLINER PER AMM 52-10-00.SDR AALA202512090062Bottle · leakingAIRCRAFT WAS GROUNDED: R1 DOOR WILL NOT FULLY OPEN TO GUST LOCK POSITION. MAINTENANCE FOUND THE R1 DOOR R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW, REPLACED THE R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-01. A SATISFACTORY SDR AALA202512098011Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND UNDER LAVATORY L4F-1L THRESHOLD AT BS 1744 BETWEEN LBL 53 AND LBL 81. REPAIRED LAVATORY BELOW THRESHOLD PER EA 369916.SDR AALA202512096814Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN BS 274 AND BS 294.5 AT BL 0. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202512092076Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR YENA2025120901181Controller · failedFLT#411, JFK-LAS. (ETOPS) AIR PACK 1 REGULATOR FAULT ( AIR COND PACK RAM AIR INLET FLAPS ); REMOVED AND REPLACED ACSC 1 IAW AMM 21-61-34. OPS CHECK GOOD. NO FAULTS.SDR CALA2025120911966Battery Pack · dischargedM/D R3 DOOR FWD EMERGENCY LIGHT POWER SUPPLY M33404 BATTERY PACK FOUND LOW CAPACITY. RAISED FROM TASK CARD 86-3350-1-0002. REPLACED M/D R3 DOOR FWD EMERGENCY LIGHT POWER SUPPLY M33404 BATTERY AND PERFORMED NEW BATTERY PACK INSTALLATION TEST & CAPACITY CHECK. SDR CALA2025120911964Battery Pack · dischargedM/D L3 DOOR AFT EMERGENCY LIGHT POWER SUPPLY M33401 BATTERY PACK FOUND LOW CAPACITY. RAISED FROM TASK CARD 86-3350-1-0002. REPLACED M/D L3 DOOR AFT EMERGENCY LIGHT POWER SUPPLY M33401 BATTERY PACK AND PERFORMED NEW BATTERY PACK INSTALLATION TEST & CAPACITY SDR CALA2025120911962Smoke Detector · false activationLAV E SMOKE DETECTOR WENT OFF PER FAS NO PAX IN LAV COULD NOT FIND FAILURE WITH AFFECTED SMOKE DETECTOR, SMOKE DETECTOR PASSES SELF TEST AND SMOKE TEST IAW AMM 26-14-00/501. NO SMOKE ODOR PRESENT, VERIFIED NO TAMPERING WITH SMOKE DETECTOR. OK TO CONTINUE NO N