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 CALA2025100209541Pin · installedSAFETY PIN INSTALLED AT R1 DOOR EMERGENCY ASSIT BOTTLE AND SLI DE PACK FOR MX REMOVED SAFETY PIN AT L1 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE CORRECTION, REMOVED SAFETY PIN AT R1 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE C/SDR CALA2025100209540Cover · detachedDOOR 3L SLIDE BUSTLE COVER NEEDS REATTACHED REATTACHED BUSTLE COVER AT DOOR 3L REF AMM DMC-B787-A-52-11-24-03A-720A-ASDR CALA2025100209539Pin · installedSAFETY PIN INSTALLED AT L4 DOOR EMERGENCY ASSIT BOTTLE AND SLI DE PACK FOR MX REMOVED SAFETY PIN AT L4 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE C/W RII INSP. VERIFIED BOTH POWER RESERVOIR AND SLIDE INFLATION CYL VALVE PINS REMOVED AND STOWED SDR CALA2025100209538Pin · installedSAFETY PIN INSTALLED AT L2 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK FOR MX REMOVED SAFETY PIN AT L2 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE C/W RII INSP. VERIFIED BOTH POWER RESERVOIR AND SLIDE INFLATION CYL VALVE PINS REMOVED AND STOWED LSDR CALA2025100209537Seal · brokenAFT CABIN FWD OVHD LIFE RAFT TAMPER INDICATOR BROKEN. LIFE RAFT TAMPER INDICATOR INSTALLED.SDR CALA2025100209536Cover · chippedSLIDE COVER 2R PAINT CHIPPINGSDR CALA2025100209535Disk · brokenO2 GREEN DISK BROKEN. REPLACED BROKEN DISCHARGE INDICATOR DISK IAW AMM 35-12-51.SDR CALA2025100209534Cover · damagedR2 DOOR SLIDE COVER SCRAPED REF ECRA 2562-01170, ACCOMPLISHED PART 1 INTERIM REPAIR. ACP RII REQUIREMENTS OF INSTALLATION OF DOOR 4R BUSTLE IAW GMM 9-25-05 PER ECRA 2562-01170, PART 1 STEP 9 NEED TO CREATE OR UPDATE A DIP LOG PAGE TO ACCOMPLISH INSPECTIONS PSDR CALA2025100209533Access Door · unknownTHIS ITEM IS A LEVEL ONE CHRONIC, PLEASE REF FIM'S 52-40 T/801,802 FOR THE FWD ACCESS DOOR AND MAIN E/E DOOR CK BOTH SWITCHES THRU THE PSEU AND ENSURE BOTH ARE ADJUSTED CORRECLY. REF WDM 52-71-12 REMOVE CONN'S D10986/88 FROM THE PSEU CK PIN 6 ON BOTH CONN'S WISDR CALA2025100209532Battery Pack · expiredEMERGENCY FUEL SHUTOFF BATTERY REPLACE {B737-28-3-0190} - AS PER TASK CARD. TIME CHANGE. REMOVED AND REPLACED EMERGENCY FUEL BATTERY ASSY REF AMM 28-22-14-400-801SDR CALA2025100209531Lamp · inoperativeFWD LEFT OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD LT OVERWING EMERGENCY LIGHT BULB IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2025100209530Lamp · inoperativeEMERGENCY LIGHTS NOT ARMED LIGHT, ONE LAMP INOP. RELAMPED AND OPS CHKD OK.SDR CALA2025100209529Battery Pack · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. EMERGENCY LIGHTS INOP, ROW 7 TO 14. REPLACED BATTERY PACK AT ROW 8A, SN OFF 309032, SN ON 375810. REF AMM 33-51-06, ROWS 7 THRU 14 CHECK GOOD.SDR CALA2025100209528Light Sys · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. FLOOR PROXIMITY LIGHTS OF THE CABIN COMPARTMENT AT ISLES 34, 35, 36, 37, AND 38 DO NOT COME ON WHEN PERFORMING OPS TEST. REPLACED BATTERY CHECKED GOOD.SDR CALA2025100209527Bulb · inoperativeRIGHT FORWARD OVERWING EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-51-04-960-801, OPS CHECKED OK.SDR CALA2025100209526Lamp · inoperativeOVERHEAD PANEL NR 2 DRIVE, EMERGENCY EXIT LIGHT NOT ARMED ANNUNCIATOR LIGHT HAVE ONE BULB INOPERATIVE EACH, RELAMPED, OPS CHECK GOODSDR CALA2025100209525Light · malfunctionedEMERGENCY EXIT SIGNS ILLUMINATED. PERFORMED AN EMERGENCY LIGHT TEST IAW AMM 33-51-00, OPS CHECK GOOD IAW SDM 33-51-00/001, CONFIG 00. THE EMERGENCY LIGHTS COME ON AUTOMATICALLY WHEN NO SMOKING SWITCH 190RH IS IN THE ON POSITION. THEY ALSO COME ON, WHEN NO SSDR CALA2025100209524Unknown · odorCLEANERS REPORTED A FOUL ODOR THROUGHOUT THE ACFT, CANT SMELL FOUL ODOR AT THIS TIME. OKAY TO CONTINUE.SDR CALA2025100209523Oven · odorOVEN 204 EMMITS STRONG BURNING SMELL, CLEANED OVEN AND PEFORMED OPS CHKD GOOD.SDR CALA2025100209522Toilet · odorLAVATORY TOILET BOWL SMELLS BAD AT DR-1L FWD CABIN LAV A. REMOVED TOILET SHROUD NO LEAK DETECTED, SERVICED LAV A TWICE, CLEANED TRASH CAN AND CLEANED LAV A .SDR CALA2025100209521None · noneLIQUID OF UNKNOWN ORIGIN ALL ALONG RIGHT SIDE COCKPIT FLOOR. STRONG COFFEE SMELL ALSO. FLIGHT CREW SPILLED COFFEE DURING FLIGHT. SPILLAGE MOSTLY DRY UPON ARRIVAL. INSPECTED E+E NO FLUIDS FOUND.SDR CALA2025100209520Potable Water · odorSTRONG ODOR IN POTABLE WATER AND LAV WATER, PERFORMED POTABLE WATER SYSTEM DISINFECTION IAW JC B757-MP-6700-38-001-00SDR CALA2025100209519Unknown · odorLIGHT ODOR LIKE MELTING PLASTIC, HAPPENED FOR 5 MINUTES THEN DISAPATED. HAPPENED ON 2 LEGS. LOW CONTINUED ALTITUDE. 4000-5000FT. NO SMOKE OR OTHER SIGNS OF AN ISSUE. CAPT REPORTED SMELL OF BURNING PLASTIC FROM THE GASPER DURING TAXI & APPROACH. SMELL DISISDR CALA2025100209518O-Ring · damagedC HYD QTY EICAS MSG DURING CRUISE FLIGHT, QTY WAS SHOWING .48 DURING RECOVERY OF AIRCRAFT. NOTICED LARGE AREA OF HYD LEAKAGE UNDER LT WING. FURTHER EVALUATION REQUIRED. AIRCRAFT REPOSITIONED AT THE HANGAR WITH 28% ON CENTER HYD SYSTEM. AFTER INSPECTION OF SDR SWAA2025100220471Cover · unsecureL2 DOOR SLIDE COVER WINDOW NOT SECURE. SECURED L2 DOOR SLIDE COVER IAW SOPM 20-50-12.SDR JR2R20251002308Crossbeam · corrodedFR87 CROSSBEAM AT RBL 10 IS CORRODED OUT OF LIMITS. REPAIREDSDR QR9R2025100100008Control Lever · out of limitsCONTROL LEVER WAS RECEIVED BAD FROM SUPPLY BEYOND LIMITS (.050") IN WASHER/BUSHING AREA.SDR QR9R2025100200007Control Lever · out of limitsCONTROL LEVER WAS RECEIVED BAD FROM SUPPLY BEYOND LIMITS (.069") IN WASHER/BUSHING AREA.SDR FDEA202510021871Longeron Splice · crackedCAC COMPARTMENT APPROXIMATE BS 1159, LONGERON 47LT SPLICE, SUSPECT CRACK. CRACKED SPLICE AT BS 1159 TO BS 1129/6-100, L47L REMOVED IAW SRM 51-31-01-0G. SPLICE FABRICATED IAW DRAWING A6A7115 REVISION J. FABRICATED SPLICE INSTALLED IAW SRM 51-31-01-0G. REPAIR CSDR FDEA202510021870Longeron Splice · crackedCAC COMPARTMENT APPROXIMATE BS 1159, LONGERON 46LEFT, SPLICE SUSPECT CRACK. CRACKED SPLICE AT BS 1159 TO STATION 1129/6-100, LONGERON 46L REMOVED IAW SRM 51-31-01-0G. SPLICE FABRICATED IAW DRAWING A6A7115 REVISION J. FABRICATED SPLICE INSTALLED IAW SRM 51-3SDR FDEA202510021869Longeron · damagedLOWER CENTER CARGO COMPARTMENT BILGE AREA AFTER REMOVAL OF LONGERON SPLICE FITTING FOUND LONGERON 52 FASTENER HOLE ELONGATED AT STATION 1691. DAMAGED LONGERON 52 SECTION STATION 1691 AT LOWER CENTER CARGO BILGE AREA REPAIRED AS PER MD-11 SRM 53-00-0-2R, REPSDR QR9R2025100200006Control Lever · out of limitsCONTROL LEVER WAS RECEIVED BAD FROM SUPPLY BEYOND LIMITS (.070") IN WASHER/BUSHING AREA.SDR DALA2025100207169Skin · cracked(LOG 1229629) CRACK (3 EAS) ON LOWER SKIN STAB STA 101.90, 138.70 AND 147.90 AT RH HORIZONTAL STABILIZER. LOWER SKIN STAB STA 101.90, 138.70 AND 147.90 AT RH HORIZONTAL STABILIZER WAS REPAIRED PER B737-800 SRM 55-10-01-2R PROCEDURE 11 REPAIR 11.SDR IXXA20251002002Bracket · brokenREMOVED AND REPLACED BRACKET P/N 368-53-16-94490-206 IAW B767-300 SRM 51-40-05 AND 51-40-02 PAR 7. AFT SIDE OF FLOOR BEAM STA1562 RBL 82SDR 2025F00232Warning Light · illuminatedDURING FLIGHT AT FL3500, CARGO DOOR LIGHT ILLUMINATED. THE PILOT FOLLOWED PROCEDURE IAW QRH AND LANDED AT THE NEAREST AIRPORT (MDSD) WITHOUT FURTHER INCIDENT.SDR AALA202510024563Bottle · low pressureAIRCRAFT WAS GROUNDED: L2 DOOR DAMPER REQUIRES SERVICING. MAINTENANCE SERVICED L2 DOOR DAMPER IAW AMM 52-10-00.SDR DXTA2025100205176Oxygen Mask · unwanted deployCREW INADVERTENTLY DEPLOYED THE PASSENGER OXYGEN MASKS DURING THE COCKPIT PREPARARION FLOW. ALL MASKS IN CABIN DEPLOYED, ALL PINS ARE STILL IN PLACE. CORRECTIVE ACTION: PERFORMED STOWAGE OF PASSENGER OXYGEN MASKS AS REQUIRED. REINSTALLED CARTRIDGES AND CLOSEDSDR 7C7A1900010000041Sleeve · dentedNR 2 ENGINE INBD THRUST REVERSER SLEEVE HAS A DENT 18 INCHES FROM TOP EDGE AND 15 INCHES FROM FWD EDGE.SDR 7C7A2025100200040Heat Shield · crackedLEFT MLG BODY DOOR OUTER SURFACE HEAT SHIELD COVER IS CRACKED AND DELAMINATED.SDR QR9R2025100200005Fitting · brokenABORTED TAKEOFF FOR PILOT DOOR STRUT FAILURE (STRUT BRACKET BROKE). REPLACED DOOR STRUT FITTING IAW AMM 52-11-00, 4-2.SDR 2025FA0000677Brushes · faultedON 26 SEPT, DURING A PATIENT TRANSPORT FLIGHT, THE PILOT REPORTED CRITICALLY LOW VOLTAGE, ALL ELECTRONICS LOST AND MADE A PRECAUTIONARY LANDING WITHOUT FURTHER INCIDENT. BASE MECHANIC ARRIVED ON SCENE, CHECKED, & DETERMINED THAT BATTERY FAILURE WAS NOT AN ISSSDR QR9R2025100200004Actuator · failedPITCH ACTUATOR FAIL ON AUTOPILOT TEST. DURING TROUBLESHOOTING, FOUND THE P2 SEMA HAD A VALID SIGNAL IN BUT NO VALID SIGNAL OUT. REMOVED AND REPLACED SEMA ACTUATOR IAW AMM 67-10-00, 4-8.SDR HNAA2025100200654Wire · damagedCAPT YOKE CHART HOLDER LIGHT WIRING IS DAMAGED AND C/B H-11 IS POPPED. -C/B H-11 POWERS LIGHT- COLLARED C/B H-11 MEL 02OCT25 08:41 LYH C27511 33-1 FLT COMPARTMENT INSTRUMENT LIGHTINGSDR QR9R2025100200003Display · failedVEMD LANE 1 FAILED DURING NORMAL APPROACH AND WAS UNABLE TO BE RESET. REMOVED AND REPLACED VEMD IAW 31-60-00, 4-2; MOC SUCCESSFULLY COMPLETED.SDR JR2R20251002304Floor Support · corrodedFLOOR SILL AT FR12 TO FR14 BETWEEN RBL 36 AND 42 IS CORRODED OUT OF LIMITS. REPLACEDSDR QR9R2025100200002Altimeter · inoperativeRADAR ALTIMETER INOP DURING START RUNUP. REMOVED AND REPLACED RADAR ALTIMETER IAW NAV/COM 23-41-01; MOC SUCCESSFULLY COMPLETED.SDR AALA202510024810Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER, IN LEFT WHEEL WELL, LOCATED AT BS 663, FROM LBL 24.92 TO LBL 31.83. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR JR2R20251002295Mount · corrodedAFT GALLEY MOUNT FITTING UNDER TEXAS DOUBLER IS CORRODED OUT OF LIMITS. REPLACED.SDR IXXA20251002001Tube · dentedFUEL TUBE DENTED INSIDE THE LEFT FUEL TANK BEEN RIBS 20 AND 21, ACCESS PNL 541LBSDR QR9R2025100200001Gearbox · making metalABORTED TAKEOFF FOR T/R CHIP. CAUTION REMAINED ON AFTER ACTIVATING FUZZ BURN FOR ONE SECOND. CHIP FOUND DURING IGB CHIP DETECTOR INSP THAT REQUIRES REPLACEMENT OF GEARBOX IAW 65-32-00, 6-23 TABLE 1 ITEM D. REMOVED AND REPLACED GEARBOX IAW AMM 65-32-00, 4-1; MO