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 CALA2025070806320Slide · unsecureDOOR 2R EMERG EXIT EMERG EXIT SLIDE IS PROTRUDING FROM BOTTOM OF THE DOOR. SECURED DOOR SLIDE 2R PER REF AMM 25-66-01 PERFORMED REQUIRED RII INSP FOR THE RE-SECURING OF 2R DOOR SLIDE AS REQUIRED. REF AMM 25-66-01.SDR CALA2025070806319Bottle · abnormalLEFT SIDE OVERWING ESCAPE SLIDE RESERVOIR REQUIRES PRECAUTIONARY REPLACEMENT DUE TO EXPOSER TO HIGH TEMP REF LOGPAGE 5426683. REMOVED & REPLACED LH OVER WING SLIDE RESERVOIR PER AMM 25-62-46. REMOVAL AND INSTALL OF LH O/W SLIDE BOTTLE, FOR THE ABOVE AMM, SDR 3EJA928JS070425Cabin Pressure · lostLOST PRESSURIZATION AT FL240. NOTIFIED ATC AND REQUESTED A DECENT.SDR SWAA2025070788447Unknown · odorFLT ATTENDANTS REPORTED A SLIGHT EXHAUST SMELL IN THE FORWARD GALLEY AREA ONLY. PERFORMED FUMES IN CABIN CONDITIONAL INSPECTION PER M/M 05-51-56. NO ABNORMAL FUMES NOTED AT THIS TIME.SDR SWAA2025070788863Tire · blown#2 MAIN TIRE BLOWN ON TAKEOFF FROM MCO. R&R #2 MLG WHEEL AND TIRE ASSY IAW AMM 32-45-11.SDR DALA2025070705023Unknown · odorSHIP 3115 DIRTY SOCK ODOR ON THE GROUND, PRIOR TO BOARDING NO PAX ON BOARD. CORRECTIVE ACTION: RAN BOTH PACKS FOR TWO HOURS AT VARIOUS TEMPS. (7172594).SDR SWIA202507070004A/C Pack · odorBURNING SMELL FOR 1-2 MINUTES COMING FROM CAPTAINS SIDE COCKPIT VENT. ONCE WE IDENTIFIED IT WAS COMING FROM CA SIDE VENT, SMELL STARTED TO GO AWAY ON ITS OWN WITHOUT ANY INTERVENTION. REFER TO ML 30434357 FOR REMOVAL AND REPLACEMENT OF THE LH AIR CYCLE MACHINESDR AALA202507075469Controller · faultedAIRCRAFT WAS GROUNDED: IN DESCENT, MULTIPLE ECAMS CAB PRESS LO ECAM FAULTS. MAINTENANCE REPLACED #2 CABIN PRESSURE CONTROLLERS IAW AMM 21-31-34.SDR AALA202507071642Controller · faultedAIRCRAFT WAS GROUNDED: IN DESCENT, MULTIPLE ECAMS CAB PRESS LO ECAM FAULTS. MAINTENANCE REPLACED #1 CABIN PRESSURE CONTROLLERS IAW AMM 21-31-34.SDR DALA2025070705063Proximity Sensor · out of adjustSHIP 3436 DOOR R FWD CABIN ECAM MESSAGE AFTER LANDING. CORRECTIVE ACTION: FOUND PROX SENSOR (12MJ) OUT OF ADJUSTMENT. ADJUSTED PROX SENSOR (12MJ) PER A330 AMM 52-71-11. OPS CHECK GOOD. (6805082)SDR DALA2025070705059Attach Bracket · mechanic errorSHIP 3417 FR63 BRACKET ATTACHED TO U-CHANNEL @ STGR 1-2R FOUND MIS-DRILLED. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1063910)SDR DALA2025070705058Former · damagedSHIP 3417 AFT SIDE OF FRAME 63 HAS TOOLING DAMAGE BETWEEN STRINGERS 1L AND 1R. CORRECTIVE ACTION: REPLACED FRAMES PER A330 AMM 53-11. (1063892)SDR DALA2025070705057Frame · damagedSHIP 3417 AFT SIDE OF FRAME 63 BETWEEN STRINGERS 1L AND 1R, LH U-CHANNEL BRACKET HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPLACED BRACKET PER A330 SRM 53-11. (1063889)SDR DALA2025070705056Stringer · damagedSHIP 3417 APPROX 6" FWD OF FRAME 63 STRINGER 2L HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPLACED FRAMES PER A330 SRM 53-11. (1063883)SDR DALA2025070705055Shear Tie · damagedSHIP 3417 FWD SIDE OF FRAME 63 SHEAR TIE AT STRINGER 1R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV B. (1063873)SDR DALA2025070705054Frame Angle · damagedSHIP 3417 FWD SIDE OF FRAME 63 CLIP BETWEEN STRINGER 1R AND 2R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV B. (1063870)SDR DALA2025070705053Channel · damagedSHIP 3417 AFT SIDE OF FRAME 62 U-CHANNEL BETWEEN STRINGER 1R AND 2R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV. B. (1063867)SDR DALA2025070705038Wire · damagedSHIP 3402 SEAT 3J FLOOR PATH LIGHT INOP. CORRECTIVE ACTION: REPAIRED WIRING PER A330 AMM 33-51. (7316675)SDR DALA2025070705037Frame · damagedSHIP 3416 FRAME 64 BETWEEN 1L AND 2L FASTENER HAS TOOLING MARK. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. ORIG. (1062911)SDR DALA2025070705036Stringer · damagedSHIP 3412 TOOLING DAMAGE LOCATED ON STRINGER R2 FWD OF FRAME 64, 2ND HOLE FWD FROM FRAME 64. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1062899)SDR DALA2025070705035Stringer · damagedSHIP 3412 TOOLING DAMAGE LOCATED ON STRINGER R1 FWD OF FRAME 64, 2ND HOLE FWD FROM FRAME 64. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1062873)SDR DALA2025070705033Bracket · damagedSHIP 3406 #5 BRACKET ON FR60 NOTED WITH TOOLING DAMAGE NEAR RIVET HEAD. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-72-11. (1063987)SDR DALA2025070705032Bracket · damagedSHIP 3406 #4 (BRACKET) ON FR60 NOTED WITH TOOLING DAMAGE NEAR RIVET HEADS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-72-11. (1063982)SDR DALA2025070705030Frame · damagedSHIP 3408 FWD SIDE OF FR62 REINFORCEMENT BETWEEN STRINGERS 2L & 3L HAS 2 SPOTS OF TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV O. (1063051)SDR IPXA2025070762233Sleeve · wornFOUND SUPPLY FAN JOINT SLEEVE WORN OUT.SDR IPXA2025070763772Inlet · crackedCRACK - FLANGE, NO. 2 PYLON FAN AIR VALVE INLET. (REPLACE) OK TO WORKSDR IPXA2025070762480Manifold · brokenBROKEN - MANIFOLD, NO.2 ENG LPT CASE COOLING, NEAR 11:00 AREA. I.A.W. AMM 75-24-03-004-050-H00 AND 75-24-03-404-037-H00, REV.145, REPLACED THE LPT COOLING MANIFOLD OF NO.2 ENGINE. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR IPXA202507071812A/C Pack · odorWITH LEFT PACK ON AND ONLY APU PNEUMATICS, STRONG SMELL OF JET FUEL IN FLIGHT DECK. TXFRD TO MAINTENIX TASK ID T3F18E006ZXJX FOR DEFECT RECTIFICATION.SDR CALA2025070706284Tire · leakingTIRE PRESSURE EICAS INTERMITTENT NOSE GEAR YELLOW INDICATION REMOVED AND REPLACED LEFT NOSE TIRE DUE TO SLOW AIR LEAK. REF AMM 32-45-02-400-801. MSG CLEARED. INDICATION NORMAL.SDR CALA2025070706283Scuff Plate · deformedPRESSURIZATION LEAK HEARD AT DOOR L1 EXTREMLY LOUD AT 8000 FEET. PILOT AND CABIN CREW STATED IT WAS DOOR 1L FA REPORTED SQUEALS HEARD FROM BOTTOM LEFT OF DOOR 1L. PILOTS STATED AT 10000FT PRESSURE RATE FLUCTUATED TO NEGATIVE RATE .5 TO 1, RESULTING CABIN PRESDR CALA2025070706253Lamp · inoperativeL2 DOOR OUTSIDE EMERGENCY LIGHT INOP RELAMPED REF AMM 33-51-00. OPS CHECK GOODSDR CALA2025070706241Battery Pack · dischargedEMERGENCY LIGHTS OPERATIONAL CHECK {B767-33-3-7000} - ALL EMERGENCY LIGHT FROM PREMIUM SEAT AISLE DOES NOT COMES ON PERFORMED WDM 33-51-11-901 FOUND M6758 AND M6759 EMER LTS POWER SUPPLY WITH LOW BATTERY CHARGE. REPLACED BATTERIES AS REF AMM 33-51-07-022-005-0SDR CALA2025070706239Switch · faultedEMER LTS ON W/ SWITCH IN OFF POSITION OFF W/SWITCH IN ARMED ON ARRIVAL TO AIRCRAFT EMERGENCY LIGHTS FOUND OFF WITH THE FLIGHT DECK SWITCH ALSO IN THE OFF POSITION. EMERGENCY LIGHTS TEST CARRIED OUT IAW AMM 33-51-00-710-803 FROM FLIGHT DECK AND ALL CABIN LOCATISDR CALA2025070706229Unknown · leakingFUEL LEAK REPORTED, LEFT WING AFTER TAKEOFF PILOTS REPORTED: (TOWER AND TRAILING PLANE INFORMED CREW THAT FUEL WAS LEAKING FROM LEFT WING. LEFT FUEL TANK IMBALENCE OF 300LBS, ENGINE FUEL FLOW WAS EVEN BETWEEN LEFT AND RIGHT ENGINES. LEAK STOPPED IN FLIGHT AFTESDR WX0A2025070732491A/C Pack · odor(AIRCRAFT NOT GROUNDED) ODOR EVENT. APU BLEED OFF ENG AND PACKS ON WHILE LEVEL AT 5000 MSL. / TROUBLESHOOTING IN PROGRESS"SDR WX0A2025070732489Engine · failed(AIRCRAFT GROUNDED) ENG 1 FAIL DUE TO BIRDSTRIKE / COMPLIED WITH ON WO 525591. REMOVAL OF THE POWER PLANT, COMPLIED WITH A32X-71-400-001. INSTALLATION OF THE POWER PLANT, COMPLIED WITH A32X-71-400-002.SDR YENA2025070700683Unknown · odorFLT#1520, ATL-JFK,"DIRTY SOX ODOR ON DESCENT THROUGH 10.000 DISSIPATED WHEN PACK 2 SELECTED OFF; REF INFO NOTICE 2017-T015L AND TSM 05-50-00-810-831-A. NO PHYSICAL EVIDENCE OF OIL FOUND IN APU. ACCOMPLISHED BLEED ISOLATION PROCEDURE OF ENG #1, ENG #2, APU PACKSDR DALA2025070705019Latch · faultedSHIP 6710 3L DOOR WILL NOT ARM PROPERLY. CORRECTIVE ACTION: RESECURED PROX LATCH. OPS NML. (7414780)SDR DALA2025070705015Wire · damagedSHIP 5813 DURING SVC CK. FOUND AISLE SEAT MOUNTED EMERGENCY LIGHT FROM ROWS 41-45 INOP & EXTERIOR EMERG SLIDE LIGHT OUTSIDE DOOR 4L INOP. CORRECTIVE ACTION: R/R BATTERY PACK PER B757 AMM 33-51. R/R POWER SUPPLY PER B757 AMM 33-51 . FOUND FUSE ON POWER SUPPLY MSDR DALA2025070705014Drag Fitting · corrodedSHIP 663 A.A. IN REF TO AMDS 5720-01100-04A, STEP 13, CORROSION ON FASTENERS # 1 TO 10 AT LH ENG DRAG FITTING. CORRECTIVE ACTION: SUMMARY OF NRC 00147: P/N OF NEW FASTENERS # 1 TO #10 AT LH ENG DRAG FITTING WERE VERIFIED PER STEP 1(A) TO STEP 1(D) PART H OF PRSDR DALA2025070705013Sidewall Panel · dentedSHIP 663 IN REF TO: NRC 00052: AFTER REMOVAL SIDEWALL PANELS: DENT ON FRAME 1300 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00152: FRAME 1300 BTW STGRS 25L AND 26L IN AFT CARGO COMPARTMENT WAS REPAIRED PER PRI 627367-14 RSDR AALA202507073149Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507071859Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507075205Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 15WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTYORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507072345Lever · looseAIRCRAFT WAS NOT GROUNDED: SCREW MISSING ON 2R DOOR ARMING LIFTING ARM. MAINTENANCE DETERMINED SCREW WAS NOT MISSING AND TIGHTENED BOLT ON ARMING LEVER.SDR JJBA20250707001Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR SIMA20250704001Flashlight Assy · unserviceableFOUND AFT EMERGENCY FLASHLIGHT AND CRADLE ASSY UNSERVICEABLE CONDITION RAR AFT EMERGENCY FLASHLIGHT AND CRADLE ASSY IAW AMM 33-51-01OPS CHECK GOODSDR SIMA20250704002Hydraulic System · lowHYD 2 LO QUANTITY ON ARR. EMERGENCY DECLARED LANDED SAFELY. SERVICED HYD SYS 2 WITH HYD FLUID AS PER AMM 12-12-01.SDR UIEA2025070400832Fmc · odorCAPT REPORTS ELECTRICAL ODOR IN COCKPIT AFTER BLOCK, DETERMINED CAPT FMS CDU BLANKED AND CIRCUIT BREAKER OPEN.(<P>COLLARED CIRCUIT BREAKER, PART ORDERED FOR NGO. REPLACED CA FMC CDU IAW AMM 34-61-02. CLEARED MDDR 233639. NO FURTHER DEFECTS NOTED.</P>)SDR FDEA202507041120Skin · damagedDENT ON OUTBOARD FLAP LOWER SKIN, BETWEEN WS 746 AND 772 LH WING. OUTBOARD FLAP LOWER SKIN, BETWEEN WS 746 ON 772 LH WING WAS REPAIRED IAW B767 SRM 57-53-012R TABLE II FIGURA 201 SHEET 6 AND SRM 51-70-17-09 PARAGRAPH 4.A, FIGURE 10 REV 92.0 APR 15/2025. P