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 SWAA2026012864562Flashlight · inoperativeFWD F/A EMERGENCY FLASHLIGHT INOPERATIVE. R & R FWD FLASHLIGHT IAW AMM 25-64-00SDR SWAA2026012864904Flashlight · no testFWD F/A FLASHLIGHT NOT TESTING. R & R FWD F/A FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD. ACFT GOOD TO GO.SDR SWAA2026012864891Battery · no testAFT RT F/A FLASHLIGHT WILL NOT TEST. R & R AFT RT F/A FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS GOOD.SDR SWAA2026012864544Slide · dislodgedRAMP REPORTED FWD ENTRY DOOR SLIDE FELL OUT OF IT`S COVER. REPACKED THE FWD ENTRY DOOR ESCAPE SLIDE IAW MT 725-61-06.SDR WX0A2026012832717Bulb · inoperative(AIRCRAFT NOT GROUNDED) RIGHT OVERWING EXIT SIGN HAS INTERNAL BULB INOP / REMOVED EXIT SIGN, REPLACED LIGHT BULB AND INSTALLED EXIT SIGN IAW AMM 33-5-17-000-001-A AND AMM 33-51-17-400-001-A"SDR DALA2026012800666Wire Harness · faultedWHITE EMERGENCY LIGHT INOPERATIVE, THREE ROWS AFT OF OVERWING EMERGENCY EXIT. REPLACED THE EMERGENCY LIGHT & INTERMEDIATE WIRE HARNESS FROM FLOOR CONNECTOR TO LIGHT.SDR DALA2026012800662Controller · faultedPACK LIGHT ILLUMINATED IN FLT. FOLLOWED QRH. TRIP RESET WORKED, BUT TEMPORARY. ALSO HAD INTERMITTENT BURNING-CHEMICAL ODOR DURING DESCENT. R & R LT PACK TEMP CONTROLLER IAW AMM 21-61. OPS CHKD GOOD.SDR SIMA20260126002Flashlight Assy · missingMISSING AFT EMERGENCY GALLEY FLASHLIGHT. DEFERRED AFT FLASHLIGHT PER MEL 25-51 AUTH 011447D-C. M PROCEDURES C/W. AFT GALLEY FLASHLIGHT ASSY REPLACED IAW AMM 33-51-01. OPS CHECK GOOD. MEL RESTORED.SDR DXTA2026012806693Water Separator · odorDIRTY SOCK ODOR OCCURRED DESCENDING THROUGH FL210 AND CONTINUED FOR THE REST OF THE FLIGHT. BOTH PACS ON N1 60% N2 77% ITT 450. ODOR IS SIGNIFICANT ENOUGH TO CAUSE EYE DISCOMFORT. CLEANED WATER SEPARATOR SOCK. OPS CHECK GOOD. IAW CL650 AMM 21-51-13-160-801SDR DXTA2026012806685Battery Pack · defectiveEMERGENCY LIGHTS REMAIN ON, RIGHT SIDE OF FUSELAGE WITH THE BATTERY OFF, PASSENGER SAFETY OFF AND EMERGENCY LIGHT SWITCH OFF. INSIDE THE CABIN TWO EXIT LIGHTS REMAIN ON IN THE REAR OF THE CABIN AND ONE RT SIDE ISLE LIGHT STAYS ILLUMINATED. REPEAT WRITE -UP. SDR ANCF20260126002Engine · vibrationNR 1 ENGINE HIGH VIBRATION DURING TAKEOFF BEFORE 80 KTS. SECOND TIME IAW TSM 77-00-00-810-864-A, CHECKED WIRING, CONNECTORS, & RECEPTACLES BTWN THE NR 1 VIBRATION SENSOR (4002EV) TO EVMU (2EV) THE TRF VIBRATION SENSOR (4003EV) TO THE EVMU (2EV) IAW ASM 77-32-SDR CALA2026012813406Power Supply · no testEMERGENCY LIGHTS OPS CHECK, OUTDOOR RT OVER WING AFT EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY IAW AMM 33-51-06. TEST PASSED. CHECKED OPS OK.SDR CALA2026012813405Battery · faultedREPLACE EMERGENCY FUEL SHUTOFF BATTERY. REPLACED EMERGENCY FUEL SHUTOFF BATTERY IAW AMM 28-22-14-400-801.SDR N6WA2026012803Mount · damagedHORIZONTAL STAB RT UPPER FITTING MOUNT HOLES ARE DAMAGED. REPAIRED RT UPPER FITTING MOUNT HOLES IAW EO-C550-55MR-007.SDR N6WA2026012802Cover · crackedPAX DOOR COVER AFT UPPER CORNER CRACKED. REMOVED AND REPLACED CRACKED PAX DOOR COVER AT AFT UPPER CORNER IAW SRM 51-42-06SDR N6WA2026012801Sign · wornLH OVERWING EMERGENCY DOOR HANDLE BETA LIGHT WORN. REMOVED AND REPLACED LT EMERGENCY DOOR BETA LIGHT IAW AMM 33-51-13.SDR K11A2026012600366Door Seal · damagedLOWER MAIN CARGO DOOR FRAME DAMAGED. HIT BY UNKNOWN OBJECT. AIRCRAFT FERRIED TO KTUS FOR DOOR FRAME SEAL REPAIR.SDR SWIA2026012675098Rib · damagedDAMAGE ON THE LT WING CANTED RIB LOCATED AT WS398.93 WAS FOUND TO BE OUT OF LIMITS PER SRM 57-21-12. DAMAGE IS OUT OF LIMITS AND THE REPLACEMENT OF THE STRUCTURALLY SIGNIFICANT ITEM IS CLISSIFIED AS A MAJOR REPAIR. REMOVED AND REPLACED THE LT CANTED RIB AT SDR DALA2026012700635Door · frozenR1 DOOR WILL NOT ARM. THAWED DOOR, INSPECTED GIRT BAR FITTINGS AND LUBED IAW FIM 52-11, OPS CHECKS GOOD. (7495050)SDR DALA2026012700634Starter · failedFLAMES & SPARKS COMING FROM THE RT ENGINE DURING TAKEOFF. ACCOMPANIED BY FUMES IN REAR CABIN, CONFIRMED BY FA'S. INSPECTED NR 2 ENGINE FOR DAMAGE, NO TROUBLE FOUND. INSPECTED FOR LEAKS, NO LEAKS NOTED. FOUND METAL ON STARTER CHIP DETECTOR, R & R THE STARSDR DALA2026012700632Skin · debondedSKIN IS DEBONDED ON INNER SKIN, DAMAGE ALSO TO OUTER SKIN. REMOVED THE DAMAGED ON THE INNER SKIN, CORE & PREVIOUS EXTERNAL SKIN REPAIR AT LOWER PANEL.. PREPPED REPLACEMENT SKIN (INTERNAL), CORE, FILLER & INTERNAL DOUBLER (FOR PREVIOUS REPAIR) FOR BONDING IAW SDR DALA2026012700641Seat Track · corrodedCORRODED SEAT TRACK, FRM 74, LBL 23. REMOVED SEAT TRACK, FRMS 61 - 74, LBL 23, AND INSTALLED A NEW SEAT TRACK IAW ASRP BD500-A-J51-42-06- 00AAA-078A-A, AND DWG C01342701, REV-G. (LP# 1420611)SDR YENA2026012700073Sense Line · looseFLT #1107 JFK-LHR (ETOPS). "ANTI -ICE ENG 1 VAVLE CLSD RECYCLED MULTIPLE TIMES AND RETURNS OFTEN A FEW MINTUES. ( ENGINE ANTI-ICE VALVES DEACTIVATED IN THE OPEN POSITION ).; PER TSM 30-21-00-810-813-A TIGHTENED SENSE LINE 21 ON UPPER NAI VALVE REF AMM 30-21-12SDR IPXA2026012682273Start Valve · faultedAIR TURN BACK, NR 3 STARTER CUTOUT EICAS MESSAGE IN CLIMB, CONTINUED THROUGH FLIGHT. QRH PROCEDURE FOLLOWED. R & R NR 3 ENG START VALVE IAW AMM 80-11-02/401 & OPS CHECKED NORMAL.SDR AALA202601274171Microphone · inoperativeAIRCRAFT WAS GROUNDED: FIRST OFFICER HEADSET JACK AND MICROPHONE INOPERATIVE. CANNOT PERFORM EMERGENCY PROCEDURES ON BLOCK 1 AIRCRAFT WITHOUT BOOM MIKE INOPERATIVE. REMOVE AND REPLACED FIRST OFFICER MICROPHONE JACK. PER SWPM 20-30-12 AND PROPERLY STOWED FIRST SDR AALA202601272525Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY ESCAPE SLIDE GIRT CATCHES ON DOOR THRESHOLD WHEN CLOSING. ADJUSTED GIRT BAR FOLD. PER AMM 25-66-01.SDR AALA202601270779Light · dislodgedAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT HAS FELL OUT. REINSTALLED OVERHEAD EMERGENCY LIGHT. OPS CHECKS GOOD.SDR AALA202601277730Girt Bar · out of adjustAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EMERGENCY ESCAPE SLIDE GIRT CATCHES ON DOOR THRESHOLD WHEN CLOSING. READJUSTED FOLD OF GIRT BAR MATERIAL. PER AMM 25-66-01.SDR ASAA2026012663970Wire Harness · pinchedWHILE PERFORMING T/C 78233008, FOUND RT AFT OVER DOOR EXIT SIGN AND OVERWING HATCH HANDLE EMERGENCY LIGHTS INOPERATIVE. GROUNDED - YES. ACCESSED CONNECTORS D12460, D12462, AND D12464 IAW AMM 33-21-00. IAW WDM 33-51-13-8 EXPECTED 6 VDC, FOUND 0 VDC ACROSS 464SDR DALA2026012700630Wire · damagedFLOOR EMERGENCY LIGHT, SEAT 35A WHITE, INOPERATIVE. REPAIRED THE WIRING AND REPLACED THE LAMP ASSY IAW AMM 33-51. (8562810)SDR DALA2026012700629Wire · damagedFOUND RED EMERGENCY LIGHT, SEAT 41H & R3 DOOR INOPERATIVE. WIRE REPAIRED IAW AMM 33-51-22. TESTED OK. (8562809)SDR DALA2026012700628Bottle · low pressureR1 DOOR ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE IAW AMM 52-15. (8572050)SDR AALA202601275671Cylinder · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR #4 SHOWS CHECK DOOR PRESSURE. MAINTENANCE SERVICED THE R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601277437Light · missingAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT SEAT 30 ABC MISSING. MAINTENANCE INSTALLED EMERGENCY LIGHT AT SEAT 30 ABC PER CMM 25-21-61.SDR AALA202601273637Battery · abnormalAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS FLASHLIGHT AT THE L2 DOOR NOT WORKING. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202601274234Life Vest · openAIRCRAFT WAS NOT GROUNDED: PASSENGER OPENED LIFE VEST POUCH AT SEAT 26C. MAINTENANCE INSTALLED NEW LIFE VEST AT SEAT 26C PER AMM 25-66-52.SDR BAGA2026012700010Power Supply · failedLH AFT ELPU FAULTY. ELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. REPLACED LH AFT ELPU.SDR BAGA2026012700009Power Supply · failedRH AFT ELPU FAULTY. ELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. REPLACED THE RH AFT ELPUSDR BAGA2026012700008Power Supply · failedELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. LH MIDDLE ELPU REPLACEDSDR BAGA2026012700007Power Supply · failedELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. REPLACED THE RH CENTER ELPU.SDR DALA2026012700612Seal · leakingDIVERTED TO BOS DUE TO BURNING RUBBER SMELL IN THE CABIN. FOUND OIL IN LEFT ENGINE SPINNER. REPLACED FAN SHAFT COVER SEAL. PERFORMED LEVEL B DECONTAMINATION WITH SNIFFER. (LP 8388058)SDR BAGA2026012700006Power Supply · failedELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. REPLACED FWD LH ELPU.SDR BAGA2026012700005Power Supply · failedRH FWD ELPU FUALTY. ELPU'S FAULTING CAUSING THE EMERGENCY LIGHTS TO FLICKER AND TURN ON UNCOMANDED WITH THE LIGHTS IN THE ARMED POSITION. REPLACED FWD RH ELPUSDR REXA2026012700026Bulb · inoperativeROW 15 CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED ROW 15 CEILING EMERGENCY FLOOD LIGHT BULB IAW AMM 33-51-09, OPS TEST GOOD.SDR SIMA20260126001Oil System · low pressureNR 1 ENGINE LOW PRESSURE DURING DESCENT, QUICKLY LOSING OIL PRESSURE. MANUAL SHUTDOWN IAW QRH. PRECAUTIONARY ENG 1 SHUT DOWN. DIVERTED TO LBB DUE TO BETTER FICON. EMERGENCY DECLARED. LANDED SAFLEY. MTX INSPECTING. PERFORMED GVI OF E1. FOUND NO ACTIVE LEAKS. RSDR CALA2026012713351Floor Support · corrodedSUPPORT TASK FOUND CORROSION AFT CABIN WET AREA FLOOR SUPPORT INTERCOSTAL FASTENER HOLE & UNDER LAV HOT SPOT BETWEEN STA 907 AND 927 LBL 50 MKD DOT 003 REF AAR N/R 99992011 REMOVED AND INSTALLED NEW FLOOR SUPPORT INTERCOSTAL AT AFT CABIN WET AREA BETWEEN STA 9SDR CALA2026012713350Battery Pack · inoperativeEMERGENCY AISLE LIGHTS OUT FROM ROW 22CBA TO 31 CBA REPLACED M1670 BATTERY PACK REF AMM 33-51-06-960-805. OPS CHECK OF EMERGENCY EXIT PATH LIGHTS GOOD. SDR FILED.SDR CALA2026012713349Light · missingFLOOR PROXIMITY LIGHT MISSING AT SEATS 8D AND 10D. INSTALLED MISSING PROX LIGHT SEATS 8D AND 10D AS PER REF DMC-B787-A-33-51-06-00A-720A-A.SDR CALA2026012713348Wire · detachedEMERGENCY LIGHT BULB NEAR AISLE UNDER SEAT 31C BURNT OUT. REMOVED AND REPLACED LIGHT MODULE. OPS CHECK FAILED. FOUND WIRING PULLED OUT OF CONNECTOR. TERMINATED EMERGENCY LIGHTING WIRE AND MOLEX CONNECTOR IAW ESPM 20-44. REPLACED SEAT MOUNTED EMERGENCY LIGHTISDR CALA2026012713347Access Panel · missingLANDING GEAR CONTROL ACCESS DOOR FOUND MISSING ON ARRIVAL PANEL 198GR INTERIM REPAIR ACCOMPLISHED PER ECRA 5390-01096, REF LOG 7723200.