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 CALA2025082108002Life Raft · expiredCEILING FWD SIDE FWD INFLATABLE LIFE RAFT EXPIRES WITHIN 150 DAYS EXPIRES 9/2025 WHILE PERFORMING W/C 29-2564-1-2104 FOUND THE FWD SIDE FWD LIFE RAFT TO EXPIRE WITHIN A 150 DAYS. EXPIRES 09/25SDR CALA2025082108001Control Rod · out of adjustL2 DOOR IN FLT HANDLE CAME UP, LIGHT CAME ON, PREFORMED A VISUAL INSPECT OF DOOR, LATCHES, ROLLERS & AREA AROUND DOOR CLEAR OF FOD, BURRS, & DEBRIS. PERFORMED AFT DOOR TEST IAW AMM 52-13-00-700-801. AFT DOOR LIGHT TURNS ON & OFF WHEN L2 DOOR OPENED & CLOSED. SDR CALA2025082108000Hook And Loop · wornOVERWING EXIT HANDLE ON RIGHT SIDE OF ACFT ON ROWS HOOK AND LOOP WONT HOLD COVERS SECURED. COVER ON RT EMERGENCY EXIT DOOR. OK TO CONTINUESDR CALA2025082107999Lock · warning messageL2 DOOR FLIGHT LOCK EICAS STATUS, L2 DOOR FLIGHT LOCK COMMAND, FLT LK RLY, SENS OR DISAGREEMENT.DB PSEU 2 (R2) DB PSEU 2 (L2) AMM 5211300 AND 5212090. BOTH NOT ACTIVE. OK FOR SVC PER FIM 52-11 TASK 805.SDR CALA2025082107998Girt Bar · unsecureR2 DOOR HAS FABRIC HANGING OUT. GIRT BAR HITS EXTRA FABRIC AS ONE MOVES BAR. STOWED ADDITIONAL MATERIAL BACK INTO BUSTLE AND Z-FOLD OK REF AMM 25-66-01. OK TO CONTINUE.SDR CALA2025082107997Reservoir · dischargedOVERWING SLIDE INFLATION RESERVOIR DISCHARGED. REMOVED & REPLACED THE LEFT OVERWING SLIDE INFLATION RESEVOIR IAW AMM 25-62-46 & SRM 51-40-02, NO DEFECTS NOTED. REF FAS W/O FS250137, N/R 00028.SDR CALA2025082107996Fastener · strippedCREW REPORTS LEFT FASTENER FOR SLIDE ON DOOR 2L LOOSE. FOUND THREAD INSIDE OF INSERT TO BE STRIPPED OUT. DOOR 2L FOUND NUTPLATE WITH GOOD RUN ON TORQUE REPLACED AFT FASTENER WITH CORRECT LENGTH FASTENER. IAW AMM 25-66-01-400. VERIFIED DR 2L SLIDE PACK INSTALLSDR CALA2025082107995Slide · not reportedREMOVED DOOR L1 ESCAPE SLIDE PACK IAW AMM 25-66-01-000-801. REINSTALLED ON L1 DOOR SLIDE IAW AMM 25-66-01-400-803.SDR QMLA2025081920089Motor · failedBURNING ODOR PRODUCED WHILE RUNNING AIR CONDITIONING SYSTEM.SDR HALA20250820256Starter · failedETOPS - DURING ENG 1 STARTER SOAP FOUND STARTER EMPTY AND DETECTOR FULL OF CHIPS. REMOVED AND REPLACED ENG 1 STARTER (E1-5000ES) IAW A330 AMM 80-11-41. OPS AND LEAK CHECK GOOD NO FURTHER DEFECTS NOTED.SDR HALA20250820255Fire Loop · faultedETOPS - ENG 1 FIRE LOOP B FAULT IN FLT. REMOVED & REPLACED ENG 1 FIRE LOOP B PER AMM 26-12-17. OPS CK BITE TEST GOOD. OK FOR SVC.SDR SWIA2025082000019Windshield · crackedCA WINDSHIELD CRACKING DELAMINATING (FLIGHT 5111)SDR DALA2025082006235O-Ring · leakingDURING CRUISE, GOT ECAM HYD B RSVR LOW LEVEL. HYD SYS PAGE SHOWS FLUID LEVEL BELOW THE LOW LEVEL LIMIT. R&R O-RING PER A319 AMM 29-12-42. OP-CHECK LEAK CHECK NORMAL. OK FOR SVC. (7781718)SDR DALA2025082006233Strut · corrodedCORROSION INTERCONNECTING STRUT OB FLAP ON LH WING. REPLACED INTERCONNECTING STRUT OB FLAP ON LH WING AS PER A320 FAM AMM 27-51-44-000-001-A. (1152557)SDR DALA2025082006232Shear Plate · crackedCRACK SHEAR PLATE STR 23 L LOCATED BETWEEN FR69 TO FR70 AT AFT GALLEY AREA. REPLACED SHEAR PLATE STR 23 L LOCATED BETWEEN FR69 TO FR70 AT AFT GALLEY AREA AS PER A319 SRM 51-42-11. (1153011)SDR DALA2025082006231Floor Support · corrodedCORROSION FLOOR BEAM +Y1162.5 AT FR68 AT AFT GALLEY AREA. REPLACED FLOOR BEAM Y1162.5 LOCATED BTW FR68 TO FR69 AS PER A319 SRM 51-42-11 AND A319 SRM 51-72-11. (1153001)SDR F3LA202508200285Servo Valve · failedAIRCRAFT WAS UNDERGOING SERVICE CHECK DURING RON MAINTENANCE AND WORKING MDDR# 1235083, NO FLIGHT DELAY. LP599245 ITEM 1 F/CTL AIL SERVO FAULT PLACED ON MEL 27-14-01B CN 1235081 PLACARD INSTALLED AND R/H WING INBOARD SERVO VALVE 33CE2 DEACTIVED. REMOVED ANDSDR ABXA20250819181Start Valve · failedDURING TAXI OUT, LEFT ENGINE START VALVE FAILED TO OPEN. NO ROTATION, L ENG STARTER EICAS , VALVE LIGHT. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE DEFERRED IAW MEL C ABX-80-00-2-1. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025082006230Sign · detachedEXIT SIGN OVER L2 DOOR HAS FALLEN. RESECURED EXIT SIGN OVER L2 DOOR. (7776980)SDR DALA2025082006229Girt Bar · no discrepancyL3 ESCAPE SLIDE ARMED LIGHT INOP. SECURED GIRT BAR .OPENED AND CLOSED DOOR 2 TIMES. GIRT BAR ENGAGES SATIS PER B757 AMM 5210. (7373566)SDR DALA2025082006227Sign · detached3R DOOR EXIT SIGN FELL OFF. INSTALLED COVER BACK ON 3R DOOR EMERGENCY EXIT LIGHTS. (7735127)SDR DALA2025082006226Battery Pack · inoperativeL2 DOOR EMERGENCY LIGHT INOP. R/R L2 DOOR EMERGENCY LIGHT BATTERY PACK (M11613) PER B757 AMM 33-51. OPS CHECK GOOD. (7753563)SDR FDEA202508191507Skin Panel · damagedLH FUSELAGE SKIN BETWEEN STA 368/390 AND STG 26 LH WITH PREVIOSLY REWORK WAS REPAIRED LH FUSELAGE SKIN BETWEEN STA 368/390 AND STG 26 LH IAW SRM 53-00-01-2R REPAIR 12 REV 92 APR 15 2025SDR FDEA202508191506Skin · damagedRH WING, INBD MAIN FLAP, UPPER SURFACE, 68" FROM OUTBD EDGE AND 20" FROM TRAILING EDGE, PUCTURE, RH WING, INBD MAIN FLAP UPPER SURFACE, 68" FROM OUTBD EDGE AND 20" FROM TRAILING EDGE WAS REPAIRED I.A.W. B767 SRM 57-53-01-2R, FIGURE 201 SHEET 2 AND SRM 51-SDR FDEA202508191505Floorboard · damagedMAIN CARGO COMPT ZONE 230 FLOORBOARD PANEL 231 MTF DAMAGED. FABRICATED MAIN CARGO COMPT. ZONE 230 FLOORBOARD 231 MTF VTMAE ON TRAVELER # T25/1826241 IAW DWG 11862182 REV N. MAJOR REPAIR.SDR FDEA202508191504Floorboard · delaminatedMAIN DECK CABIN AFT R/H STA 1681 PNL 252MWF DELAMINATED. FABRICATED MAIN CARGO COMPT. ZONE 250 FLOORBOARD 252MWF VTMAE ON TRAVELER # T25/1826237 IAW DWG 11864180 REV N. MAJOR REPAIR.SDR DXTA2025082004656Door · no discrepancyMAIN ENTRY DOOR EXTREMELY HARD TO OPEN FROM THE OUTSIDE. ALSO WHEN OPENING DOOR FROM INSIDE IT UNLOCKS EASILY BUT TAKES A LOT OF PRESSURE TO GET IT STARTED TO GO DOWN. OPERATED DOOR MULTIPLE TIMES FROM INSIDE AND OUTSIDE AND SEEMS TO OPERATE NORMAL UNABLE TO SDR IXXA20250819046Cover · out of positionEMERGENCY LIGHTS SWITCH COVER TURNS SWITCH OFF WHEN CLOSED. METAL BAR FOUND OUT OF POSITION AND WOULD FORCE SWITCH INTO OFF POSITION. ADJUSTED METAL BAR BACK INTO POSITION IN ACCORDANCE WITH BOEING 767 AIRCRAFT MAINTENANCE MANUAL 33-51-01. OPERATIONAL CHECK GSDR AALA202508205151Power Supply · brokenAIRCRAFT IN BASE MAINTENANCE: CABIN SEAT 17ABC ENDBAY HOLDING EMERGENCY LIGHT IS BROKEN. MAINTENANCE REMOVED AND REPLACED ENDBAY ASSEMBLY AND EMERGENCY LIGHT IAW CMM 25-22-52.SDR AALA202508206234Elec Connector · looseAIRCRAFT WAS NOT GROUNDED: ROW 18ABC PATH EMERGENCY LIGHT INOP. MAINTENANCE FOUND LOOSE CONNECTOR UNDER SEAT 18ABC, SECURED CONNECTOR, OPS CHECKS GOOD PER AMM 33-51-00.SDR AALA202508208248Power Supply · no testAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING BITE CHECK OF ESPU SYSTEM DUE TO L/H WING OVER-WING SLIDE REPLACEMENT. LOW BATTERY FAULT DISPLAYED DURING BITECHECK. MAINTENANCE REMOVED AND REPLACED BATTERY AT LOCATION 11WL IAW AMM 33-51-38.SDR AALA202508209035Door Latch · looseAIRCRAFT WAS NOT GROUNDED: LAV 4R DOOR KNOB JUST SPINS PAX GET LOCKED IN LAV. MAINTENANCE TIGHTENED DOOR KNOB MECHANISM OPS CHKS NORMAL.SDR AALA202508206288Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DONT PASS OPERATIONAL TEST DAMPING FUNCTION OF THE DOOR DAMPER AND EME RGENCY OPERATION CYLINDER PASSENGER CREW DOOR 831 AT FWD GALLEY AREA. MAINTENANCE REPLACED DOOR ASSIST BOTTLE.SDR AALA202508200416Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT FORWARD MAIN FUEL TANK PUMP LOW PRESSURE LIGHT CAME ON AFTER TAKEOFF AND THROUGH CRUISE. (OPEN).SDR AALA202508207405Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS THAT LAVATORY-D DOOR HARD TO OPEN AND CLOSED. LUBRICATED LAVATORY-D BI-FOLD LATCH AND PERFORMED, OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202508206435Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 25C HANGING BY WIRE. RESECURED LIGHT ASSEMBLY. PER AMM 33-20-00. OPERATIONAL CHECK GOOD.SDR AALA202508209791Carpet · odorAIRCRAFT WAS GROUNDED, STRONG ODOR LINGERING IN AFT SECTION OF AIRCRAFT. PREVIOUS CREW REPORTED SMELLING THE ODOR COMING FROM VENTS ON CLIMB OUT AND DESCENT. REMOVED AND REPLACED ROW 30-33 CARPET. PER AFMM 20-25-17. AFT GALLEY TRASH CART REPLACED BY CATERING SDR AALA202508200259Pressure Switch · failedAIRCRAFT WAS GROUNDED. AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THROUGH APPROXIMATELY 3000FT, GOT NUMBER 1 ENGINE OIL FILTER BYPASS. HAD TO REDUCED THRUST TO IDLE BEFORE LIGHT EXTINGUISHED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. ACCSDR ABXA20250819179Handle · out of positionDURING MAINT. INSPECTION, FOUND R2 WINDOW EMERGENCY HANDLE NOT FLUSH. MAINTENANCE RESET EXCESS HANDLE TO FLUSH IAW B767 AMM 56-00-00. AIRCRAFT RETURNED TO SERVICE.SDR YENA2025082000852Unknown · odorFLT # 861, BOS-SJU. ODOR EVENT ON DESCENT WITH MILD ODOR, DIRSTY SOCKS / MUSKY-ISLOATED PALK ONE OFF, AFTER 5 MIN ODOR DISSIPATED WITH PACK ONE OFF; COMPLIED WITH INFORMATION NOTICE 2017-T015 SECTION B2 SEE LOG PG 4349298-2 FOR ENGINE 1 BLEED DEFERAL. DECONTASDR AALA202508209243Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202508201263) AND BATTERY (AALA202508209243) PER AMM 33-51-38. A SATISFACTORY OPERATIONAL CHECK WAS ACCOSDR AALA202508201263Power Supply · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 10WL DISPLAYED DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (AALA202508201263) AND BATTERY (AALA202508209243) PER AMM 33-51-38. A SATISFACTORY OPERATIONAL CHECK WAS ACCOSDR AALA202508205314Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508203362Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508202470Lamp · no testAIRCRAFT IN BASE MAINTENANCE: CEILING EMERGENCY EXIT LIGHT AT SEAT ROW 28 INOPERATIVE. REPLACED LAMP AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202508204082Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR DALA2025082006220Wire · disconnectedSEAT 30B EMERGENCY EXIT FLOOR LIGHT INOP. RETERMINATED CONNECTOR UNDER SEAT PER A330 20-48. OK FOR SVC. (7863427)SDR DALA2025082006219Bracket · damagedNR 16 BRACKET AT FRAME 20 FWD SIDE OF FRAME TOOLING DAMAGE. REPAIRED PER ERA 628599-14 REV ORIG. (1152481)SDR CALA2025082007973Structure · misrepairedEA4435-04300 REV D OPS 018, STEP B1(D), 1 HOLE DRILLED FOR GROUND STUD PER VIEW B-B, SHEET 2, AT STA 380LH PER DRAWING DG235-141882 REV B PRIOR TO ECRA 4435-04614 RELEASE TO N/A OPS 18 PER ITEM 8. REQUEST ENGINEERING APPROVAL TO PLU HOLE OR INSTALL THE GROUND SDR CALA2025082007972Plate · wornLOWER WING CHORD AT BS 540 GOUGE AT STRIKER PLATE LOCATION. CUTOUT DAMAGE IAW SRM 57-10-13-2R-3 (4) PARAGRAPH (E) HFEC IS REQUIRED VERIFIED DAMAGE REMOVAL AND NO EXISTING CRACKS WITH EDDY CURRENT REF NDTM PART 6 51-00-00 PROCEDURE 23. REF SRM 57-10-13-2R-3 ITE