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 SWAA2025121246032Tail Cone · delaminatedTHE FORWARD TAIL CONE FAIRING IS DELAMINATED WITH DAMAGE TO THE FACE SHEETS WITH FIBERS AND HONEYCOMB EXPOSED AND CONTAMINATED WITH HYDRAULIC FLUID, BS 1193.5; 24.5' RT OF TOP. CRACK LENGTH, L=3' W=1.5'. TAIL CONE R & R WITH A NEW ONE.SDR SWAA2025121242833Tail Cone · delaminatedTHE FORWARD TAIL CONE FAIRING IS DELAMINATED, BS 1190 21 INCHES RIGHT OF TOP. CRACK LENGTH: L=2.3' W=2.2'. LOCATED & DRILLED INITIAL TAIL CONE SCREW HOLES WITH EXCEPTION OF HOLES AROUND ELEVATOR PUSH ROD CUT OUTS IAW MM 51-40-02 & SIP. TAIL CONE WAS R & R SDR SWAA2025121243221Elec Connector · damagedLEFT AFT OVERWING LIGHT HAS DAMAGED ELEC CONNECTOR. REPLACED THE ELEC CONNECTOR D14726 IAW WDM 33-51-13, AND SWPM 20-63-02. PERFORMED OPS CHECK ON THE LT AFT OVERWING LIGHT IAW AMM 33-51-00-710-801. CHECKED GOOD.SDR HYIA20251212003Elec Connector · burnedPILOT REPORTED PITOT HEAT INOP. UPON INSPECTION THE PITOT SWITCH & SWITCH CONNECTION WERE FOUND TO BE BURNT. BOTH WERE REPLACED WITH NO ADDITIONAL DEFECTS NOTED.SDR REXA2025121101001Light · inoperativeRIGHT AFT EMERGENCY LIGHT (EXTERNAL) INOPERATIVE. R & R AFT EXTERNAL EMERGENCY LIGHT IAW AMM 33-51-15. ACFT GOOD FOR SERVICE.SDR SWAA2025121043206Battery Pack · inoperativeR1 DOOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND INSTALLED EMERGENCY BATTERY PACK FOR R1 DOOR AMM 33-51-06-960-805 AND OPS CHECK GOOD. REMOVED AND INSTALLED EMERGENCY BATTERY PACK FOR R1 DOOR IAW AMM 33-51-06-960-805 AND OPS CHECK GOOD.SDR DALA2025121009019Threshold · corrodedCORROSION IN THRESHOLD PAN SEVERAL LOCATIONS. CORROSION DAMAGE SPLICE REPAIR - CHECKED AND REPLACED HI-SHEAR FASTENERS REF: B717-200 SRM 51-41-04 (1336682)SDR DALA2025121009016Relay · faultedEMERGENCY LIGHTS FLICKER ON & OFF. REMOVED & REPLACED RELAY R2-5133 REF AIPC 24-50-22-01 ITEM 40, WDM 33-51-11. OPS CHECK NORMAL AT THIS NORMAL AT THIS TIME. (7961086)SDR DALA2025121009009Skin · crackedCRACKS ON FUSELAGE SKIN ON BS 1037 & 1022, L12R & L14R AT RH FUSELAGE. DAMAGED AREA REPAIRED PER ER/A 630558-14 REV.ORIG. (1337089)SDR CALA2025121012009Blade · damagedACFT AIR TURN BACK DUE TO BIRD STRIKE, FOUND FAN BLADE DAMAGE ON RT ENG & MULTIPLE DAMAGE ON RT & LT TE FLAPS. BIRD STRIKE CONDITIONAL INSPECTION ACCOMPLISHED IAW AMM 5-51-18. FOUND DAMAGED. NO OTHER DAMAGE WAS FOUND, INCLUDING TO NR 1 ENGINE. DAMAGE WAS DUESDR ASAA2025120562880Light · malfunctionedEXIT LIGHTS IN ROW 16 ABC AND ROW 17 DEF ARE INOPERATIVE. GROUNDED - YES. PERFORMED OPS CHECK OF EMERGENCY LIGHTS IAW AMM 33-51-00-710-801ALL EMERGENCY LIGTHS WORKING. NO DEFECTS NOTED.SDR SWAA2025120942771Lamp · burned outRIGHT EMERGENCY EXIT CUTOUT OVERHEAD LIGHTS ARE BURNED OUT. R & R CABIN EMERGENCY EXIT LIGHTS IAW AMM 33-51-01. INSPECTED IAW AMM 33-51-01-960-801-NG. EXIT SIGN - LAMP REPLACEMENT.SDR SWAA2025120942761Door · out of adjustAFT ENTRY DOOR NEEDS ADJUSTMENT. ADJUSTED IAW AMM 52-13-00.SDR SWAA2025120943260Handle · loosePAX CABIN AFT LEFT DOOR LINING ASSISTANT HANDLE LOOSE. PAX CABIN AFT LEFT DOOR LINING ASSISTANT HANDLE IAW AMM-52-13-31-400-802 STEP 3.G.(2).SDR SWAA2025120942768Light · inoperativeEMERGENCY LIGHTS ABOVE OVERHEAD BINS ARE INOP ON LEFT SIDE. R & R CABIN CEILING NIGHT LIGHTS IAW AMM 33-22-00.SDR SWAA2025120943186Handle · brokenR1 DOOR CLOSING ASSIST HANDLE BROKEN., REPLACED HANDLE NUT IN REF W/ MM 52-41-31.SDR DALA2025120908990Wire · detachedWHITE SEAT MOUNTED EMERGENCY ESCAPE PATH MARKING LIGHT INOP AT 18 RIGHT. FOUND WIRE DE-PIN FROM SEATS GOING INTO SIDE WALL BUNDLE RE-PIN WIRES. IAW B763 SWPM 20-13. LIGHT CHECKED GOOD. (7797934)SDR DALA2025120908989Lens · crackedEXTERIOR EMERENCY LIGHT, LEFT WING SLIDE ILLUMINATION LIGHT LENS CRACKED. INSTALLED A NEW LENS FOR LT EMERGENCY SLIDE LIGHT IAW AMM 33- 51. OK FOR SVC. (8053598)SDR DALA2025120908986Light · unsecureEXTERIOR EMERGENCY LIGHT L2 DOOR LIGHT ASSY REQUIRES MOUNTING. SECURED LIGHT ASSY PER B767-300 AMM 33-51. OPS CHECK GOOD. (8053599)SDR DALA2025120908985Spar · crackedLEFT STRUT FORWARD UPPER SPAR WEB CRACKED AT LT EQUIPMENT CUTOUT. REPAIRED AS PER PRI630407-14 REV 0. (1336211)SDR AALA202512093308Slide · out of positionAIRCRAFT WAS NOT GROUNDED: THE SLIDE ON THE FRONT SERVICE DOOR IS STICKING OUT OF THE SLIDE BUSSEL. RESET AND SECURED FRONT SERVICE DOOR SLIDE. PER MM 25-33-00.SDR AALA202512096677Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR IS NOT STAYING OPEN IN THE SECURE POSITION. YELLOW DOOR SECURE LOCK INOPERATIVE OR STUCK. LUBED L1 DOOR GUST LOCK.SDR AALA202512096377Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: 2R EXIT DOOR GIRT BAR HARD TO DISARM FROM UPPER BRACKET. LUBED 2R GIRT BAR RETAINING CLIPS.SDR AALA202512098160Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT ROW OVER IS DETACHED. RESECURED EXIST SIGN. PER AMM 33-51-01.SDR DALA2025120908978Oil System · leakingDESCENDING THRU FL100, STINKY FEET SMELL IN CABIN. FAINT SMELL IN COCKPIT. DONNED O2 MASK. RAN QRH. DECLARED AN EMERGENCY. DECISION TABLE SHOWS APU AS PROBABLY SOURCE. OIL LEAK FOUND AT FCU DRAIN LINE. APU WILL BE PLACED ON MEL. ECS DECONTAMINATION COMPLETEDSDR YENA2025120901180Fire Loop · faultedFLT#32, AMS-BOS. (ETOPS), CR2 ALERT-APPROVAL REQUIRED FOR RESOLUTION, ENG 2 FIRE LOOP B FAULT. OPENSDR CALA2025120911947Floor Support · corrodedCORROSION AFT WET AREA FLOOR SUPPORT BETWEEN BS 967 AND 986.5 AT LBL 16. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 140A9870.SDR CALA2025120911945Floor Support · corrodedCORROSION AFT WET AREA PANEL BREAK BETWEEN STA 947.5 AND 967 AT LBL 16 AROUND FASTENER HOLES. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0, DWG 147A5650,SDR CALA2025120911943Floorbeam · corrodedCORROSION AFT WET AREA FLOORBEAM BS 986.5 AROUND FASTENER HOLES BETWEEN RBL 4 AND 44. ACCOMPLISHED REPAIR IAW SRM 53-70-51-2R-4, AND SRM 51-40-02-0G-0.SDR CALA2025120911941Floor Support · corrodedCORROSION AFT WET AREA FLOOR SUPPORT CHANNEL BETWEEN STA 947.5 AND 967 AT LBL 49. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 147A5650.SDR CALA2025120911939Frame · gouged(B737-06-3-0443) NO.2 ENG PYLON FWD STRUT FAIRING, BOTTOM SIDE OF FRAME IS GOUGED FROM PANEL 441AT AFT UPPER LATCH. FABRICATED AND INSTALLED REPAIR IAW SRM 54-50-71-2R-4 .SDR CALA2025120911937Frame · wornAFT FRAME TOP WHERE PANEL LATCH SITS HAS WEAR, GOUGE. FABRICATED AND INSTALLED REPAIR IAW SRM 54-59-71-2R-4.SDR CALA2025120911935Floorbeam · corrodedCORROSION AFT WET AREA LATERAL PANEL BREAK BS 947.5+4 BETWEEN RBL 27 AND 49. REMOVED AND REPLACED FLOORBEANM AT BS 947.5+4.0", BETWEEN RBL-27 AND RBL-49, IAW SRM 51-40-02-0G-0 AND DWG 147A5650. REMOVED AND REPLACED FLOORBEAM, BS 947.5+4.0", BETWEEN RBL 27 ASDR AALA202512096857Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5 AND S9L. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202512095087Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5 AND S9R. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR SWAA2025120843083Tailpipe · fireAFTER PULLING INTO GATE AND ENGINE SHUTDOWN RAMP ADVISED US OF A FIRE IN NR 2 ENGINE. QRC & QRH COMPLIED WITH. ENGINE NR 2 FIRE BOTTLE DISCHARGED. THERE WERE NO INDICATIONS OF FIRE ON ENGINE INSTRUMENTS OR ON FIRE CONTROL PANEL SEE AMM 71-00-00-200-801-G00. SDR SWAA2025120843389Girt Bar · bentFORWARD ENTRY DOOR GIRT BAR RETAINING HOOK BENT. RESECURED GIRT BAR PER AMM 25-66-01. A/C OK FOR SERVICE.SDR SWAA2025120843022Girt Bar · out of positionAFT ENTRY DOOR SLIDE GIRT BAR HANGS LOW. REPACKED AFT ENTRY DOOR SLIDE GIRT BAR IAW AMM 25-66-01.SDR SWAA2025120843032Glowstrip · out of adjustCABIN FLOOR PHOTOLUMINESCENT STRIP DISPLACED 12FED. ADJUSTED DISPLACED PHOTOLUMINESCENT STRIP AT 12FED IAW AMM 33-51-15.SDR AALA202512080979Elec Connector · disconnectedAIRCRAFT WAS GROUNDED: DURING SAFA INSPECTION FOUND, LOWER AISLE EMERGENCY LIGHTS INOP FROM ROW 13 TO 15. MAINTENANCE FOUND CONNECTOR P1 FROM WIRE 4NS047-2100 LOOSE FROM UNDER SEATS ROW 17 D.E.F.G, RECONNECTED PLUG AND SECURED ALL SATIS IAW WDM 33-51-58 AND SSSDR DALA2025120808958Light · inoperativeSEAT 33B EMERGENCY EXIT LIGHT INOP. REPAIRED WIRING PER AMM 33-52. OK FOR SERVICE. (7978895)SDR DALA2025120808943Proximity Sensor · icedSHIP 688 MULTIPLE ERRONEOUS L FWD ENT DOOR EICAS MSGS ON TAXI-IN. DOOR WAS IN FACT NOT OPEN. REMOVED CHUNK OF ICE FROM PROX SWITCH. NOW CKS OK. (7788632)SDR DALA2025120808937Drag Fitting · looseDURING INSPECTIONS WAS FOUND LOOSE FASTENERS 8, 9, 10, ON STEP 15, LOOSE FASTENERS 12, 16 ON STEP 16, LOOSE FASTENERS 7, 8, 9, 10 ON STEP 17, AND LOOSE FASTENERS 12, 16 ON STEP 18, IN REFERENCE TO AMDS 5720-01100-02A (LH WING). LH ENG DRAG FITTING WAS REPAIRESDR DALA2025120808936Doubler · corrodedCORROSION WAS FOUND ON SETTLEMET AREA OF TCAS ANTENNA AT REINFORCEMNET DOUBLER BTW. STA .440 TO 460 AND S-30 TO S29 AT EXTERNAL USELAGE SKIN. CORROSION LEVEL 2: SETTLEMET AREA OF TCAS ANTENNA AT REINFORCEMNET DOUBLER (ADAPTOR P/N 143N3003-2 ) BTW. STA.440 TO SDR DALA2025120808935Drag Angle · looseDURING INSPECTION BY STEP 15 AND 16, LOOSE FASTENERS NBR: #2, #3 WERE FOUND AT LH DRAG FITTING. LOOSE FASTENERS NBR: #2, #3 AT LH DRAG FITTING WERE REPAIRED PER PRI 583990-14 REV 1 AND ERA 583990- 14AD REV. G SECTION VIII: PERMANENT REPAIR. (1336975)SDR AALA202512085359Control Unit · faultyAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR UNLOCKED IN FLIGHT AND WHEN POWER WAS SWITCHED TO APU GEN. WAS ABLE TO CLOSE DOOR AND IT RE-LOCKED. CHECKED HISTORY AND FOUND UPPER AND CENTER STRIKERS TO HAVE ALREADY BEEN REPLACED, FAULT STILL CONTINUED. MAINTENANCE RESDR AALA202512085105Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT LH LAV LOWER FWD EMERGENCY LIGHT INOP. MAINTENANCE REPLACED AFT L/H LAV LOWER FWD EMERGENCY LIGHT, OPS CHECK GOOD. IAW AMM 33-51-19.SDR DXTA2025120805991Battery Pack · faultedNO EMERGENCY LIGHTS TEST WHEN THE EMER LIGHT SWITCH IS TURNED TO ON. REMOVED AND REPLACED ALL FOUR EMERGENCY LIGHTING BATTERY PACKS IAW MM 33-50-10.OPS CHECK GOOD IAW MM 33-50-00 NR 1 BATTERY PACK: NR 2 BATTERY PACK. NR 3 BATTERY PACK, NR 4 BATTERY PACK.SDR DXTA2025120805998Power Supply · inoperativeEMERGENCY FLOOR EXIT LIGHTS NOT WORKING ON RIGHT SIDE OF AIRCRAFT. TWO OVER WING EMERGENCY EXIT LIGHTS NOT WORKING. DEBRIEFED THE CREW EARLIER, AND UPON POWER-UP, FOUND THAT ELPS 2 AND ELPS 4 WERE NOT ILLUMINATING DESCRIBED EMERGENCY LIGHTS. ALLOWED THE ELPSSDR DXTA2025120806001Battery Pack · inoperativeEMERGENCY LIGHTS TURN ON WHEN ARMED, & FLICKER IN FLT. REPLACED BOTH EMERGENCY LIGHT BATTERY PACKS DUE TO NOT HOLDING CHARGE & OPS CHKD GOOD IAW AMM 33-52-01.