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 DALA2025070705048Channel · damagedSHIP 3417 AFT SIDE OF FRAME 62 LH U-CHANNEL BRACKET BETWEEN STRINGER 1R AND 2R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065344)SDR DALA2025070705047Frame · damagedSHIP 3417 AFT SIDE OF FRAME 62 UPPER SURFACE HAS TOOLING DAMAGE, BETWEEN STRINGER 1R AND 2R. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065341)SDR DALA2025070705046Frame · damagedSHIP 3417 AFT SIDE OF FRAME 62 BETWEEN STRINGER 3R AND 4R FRAME HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065329)SDR DALA2025070705045Frame · damagedSHIP 3417 FRAME 62 AFT SIDE BETWEEN STRINGERS 2L AND 3L - TOOLING DAMAGE OBSERVED NEAR FASTENERS. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065319)SDR DALA2025070705044Frame · damagedSHIP 3417 FRAME 62 AFT SIDE STRINGER 3L - TOOLING DAMAGE OBSERVED NEAR FASTENER ON FRAME. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065314)SDR DALA2025070705043Frame · damagedSHIP 3417 FRAME 62 AFT SIDE BETWEEN STRINGERS 1L AND 1R - TOOLING DAMAGE OBSERVED ON FRAME. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065281)SDR DALA2025070705042Frame · damagedSHIP 3417 FRAME 62 FWD SIDE STRINGER 2L - TOOLING DAMAGE OBSERVED ON FRAME. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1065261)SDR DALA2025070705041Bracket · damagedSHIP 3417 AFT SIDE OF FRAME 62 BRACKET BELOW STRINGER 1R HAS TOOLING DAMAGE. CORRECTIVE ACTION: R/R BRACKET PER ERA 626805-14 REV B. (1065249)SDR DALA2025070705034Skin · gougedSHIP 3412 SKIN GOUGED AT FRAME 63 BETWEEN P-1R AND P-2R. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1064177)SDR DALA2025070705031Channel · damagedSHIP 3406 AT FR61 OTBD OF STR 1L. REINFORCEMENT FOR U-CHANNEL TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627575-14 REV ORIGINAL. (1064142)SDR DALA2025070705029Shear Tie · damagedSHIP 3417 FR64 AND JUST INBD OF STR1R ATTACH BRACKET FROM FRAME TO SKIN STIFFENER ANGLE HAS TOOLING DAMAGE BETWEEN LOWER HILOKS. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV B. (1065453)SDR DALA2025070705026Angle · damagedSHIP 3412 TOOLING DAMAGE ON CLIP AT FASTENERS ON FR 1R BETWEEN 62 AND 63. REPAIRED PER ERA 627461-14 REV ORIG. (1064585)SDR GTIA2025070738983A/C Pack · odorMUSTY SMELL AFTER LEVELING AT 5000' ODOR DISSIPATED AFTER TURNING OFF PACK 1-REF TSM 05-50-00-810-831-A. FOUND ENG 1 PACK 1 TO BE CAUSE. PERFORMED DECONTAMINATION LEVEL A OF PACK 1, ENG 1 IAW AMM 21-00-00-615-802-A. NO ODORS OR FUMES NOTED DURING DURATION OF DSDR GTIA2025070738982Unknown · odorON DESCENT, A STRONG ODOR OF NAIL POLISH LIKE SCENT SENSED IN THE FRONT OF A/C-INSPECTED FRONT OF A/C FOR NAIL POLISH ODOR. COULD NOT SMELL ANY ODOR. REF AMM 12-21-12.SDR IPXA2025070774321Hinge Fitting · crackedCRACK - FITTING, INBD SIDE OF L/H WING T/E INBD MAIN FLAP T/E MID LINK FITTING, WBL 174. PERFORM SRM 57-53-02-2R-1 REV.92 AND EGAT WORK SHEET NO. 50533 STEP 14 TO 15 14.ASSEMBLE THE REPAIR PARTS WITH BMS 5-95 SEALANT BETWEEN MATING SURFACES. REFER TO 767-300F SDR IPXA202507074238Link · wornWORN OUT SUPPORT LINK, NO.2 ENG R/H HPT CASE COOLING FWD DUCT UPPER SIDE, NEAR FUEL SUPPLY LINE. (REPLACE) OK TO WORKSDR CALA2025070706272Static Inverter · warning messageSTBY INVERTER STATUS MESSAGE. REPLACED STATIC INVERTER MM 24-33-03, OPS CHECK GOOD.SDR CALA2025070706271Coffeemaker · faultedAIRCRAFT GATE RETURNED DUE TO SMELL OF SMOKE IN AFT GALLEY. FLAGGED AS SDR FOR A/R DEBRIEFED FA AND STATED THAT A POPPING SOUND IN AFT GALLEY WAS HEARD AND VISIBLE WHITE SMOKE CAME FROM COFFEE MAKER GRILL AREA (SEE PHOTO) WITH AN ELECTRICAL BURN ODOR. FA OPENESDR CALA2025070706270Battery · failedRH EPSU BATTERY FAULT REPLACED RH OVERWING EPSU IAW AMM 33-51-38, OPS CHECK GOOD.SDR WX0A2025070732486Battery Pack · inoperative(AIRCRAFT NOT GROUNDED) EPSU BATTERY 10WL, 11WL, & 13WL FAULT ON EPSU SYSTEM TEST / REMOVED ADN REPLACED BATTERIES AT LOCATIONS 10WL, 11WL, & 13WL IAW AMM 33-51-38-000-002-A & 33-51-38-400-002-A. OPS CHECK GOOD. "SDR WX0A2025070732485Slide · no test(AIRCRAFT NOT GROUNDED) WHILE PERFORMING EMERGENCY LGITHING TEST FOR WO:525348 WEEKLY CHECK FOUND SEVERAL MESSAGES RELATED TO FWD EPSU 10WL / WITH REF TO TSM 25-62-00-810-811-A AND TSM 33-51-00-810-8360-A FOUND BOTH L1 AND R1 DOOR SLIDES FAULTING REMOVED AND RSDR R61A2025070500276Strut · dischargedLG WOW SYS FAIL AFTER RETRACTION. CREW DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT. PERFORMED NLG SERVICING WITH FAULT CLEARED.SDR YENA2025070700682Motor · failedFLT#302, FLL-JFK. (AN EMERGENCY WAS DECLARED) "FLAPS FAULT-ON CLIMB OUT F/CTL FLAP SYS 1 FAULT ON APPROACH F/CTL FLAPS FAULT SLATS EXTENDED TO POSITION 2 FLAPS DID NOT EXTEND AND STAYED AT ZERO. LANDED IN THAT CONFIGURATION @ 157 KTS. BRAKES STAYED BELOW 300 DSDR DALA2025070705007Regulator · inoperativeSHIP 3707 -ATB- RETURNED TO JFK DUE TO PRESSURIZATION ISSUES AND NO LT DUCT PRESSURE. CORRECTIVE ACTION: REPLACED LT PRSOV SENSE LINE AND LT HPV MUSCLE AIR LINE FOR LT ENGINE BLEED ISSUE. REPLACED RT BLEED AIR REGULATOR, RT SECONDARY HEAT EXCHANGER AND RT TCV SDR AALA202507070181Fmc · frozenAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DEN DUE TO THE FLIGHT CREW REPORTING MULTIPLE FAILURE MESSAGES FOR AUTO THRUST, AUTOPILOT 1 AND 2, FMGC 1 AND 2 BEING FROZEN. THE AIRCRAFT WAS OVERWEIGHT AND LANDED SAFELY AT DEN. WHSDR AALA202507074158Fmc · frozenAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DEN DUE TO THE FLIGHT CREW REPORTING MULTIPLE FAILURE MESSAGES FOR AUTO THRUST, AUTOPILOT 1 AND 2, FMGC 1 AND 2 BEING FROZEN. THE AIRCRAFT WAS OVERWEIGHT AND LANDED SAFELY AT DEN. WHSDR AALA202507076606Light · detachedAIRCRAFT WAS NOT GROUNDED: WHITE EMERGENCY LIGHT SHROUD FOUND DETACHED FROM SEAT 33C BY MAINTENANCE WHICH CREW LEFT IN THE FLIGHT DECK. MAINTENANCE REPLACED EMERGENCY LIGHT SHROUD / HOUSING AT SEAT 33C AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM SDR AALA202507079819Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507072492Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507074701Bottle · 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-14.SDR AALA202507078769Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507074479Wire Harness · defectiveAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED AISLE EMERGENCY LIGHTS DO NOT ILLUMINATE AT ROWS 24 AND 25ABC. REPLACED EMERGENCY ESCAPE PATH LIGHTING HARNESS 351WL7 FOR SEAT ROWS S4 AND 25 ABC PER AMM 33-51-18. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202507078782Bottle · 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 JJBA20250707002Light · no discrepancyLH OVER WING EMERGENCY EXIT IDENTIFIER SIGN INOPERATIVE. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHT EXIT IDENTIFIER. OPS CHECK SAT.SDR UIEA2025070500833Flashlight · inoperativeDURING PRE-FLIGHT INSPECTION, FOUND L-1 DOOR F/A SEAT EMERGENCY FLASHLIGHT INOP. REMOVED & REPLACED EMERGENCY FLASHLIGHT AT L-1 DOOR F/A SEAT IAW B767 AMM 25-60-00. OPS CHECK GOOD.SDR HNAA2025070700465Strut · dischargedLDG AIR GRND FAIL WITH E1-E2 REV DISAGREE MESSAGE IN FLIGHT MESSAGE DISAPEARED WHEN GEAR DOWN AND LOCKED. SERVICED NLG SHOCK STRUT IAW AMM 32-20-01. PERFORMED AIR/GROUND SYSTEM SIMULATION ADJUSTMENT TEST IAW 32-63-00 & SWUNG GEARS MULTIPLE TIMES. NO DEFECTS NSDR AALA202507066456Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM 4 ELEVATOR ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM END FITTING 4 ON LH HORIZONTAL STABILIZER I.A.W AMM 55-16-42-000-001- A AND AMM 55-16-42-400-001-A.SDR AALA202507062363Latch · separatedAIRCRAFT WAS NOT GROUNDED: FLIGHT DEC DOOR DIFFICULT TO OPEN. DEADBOLT NOT WORKING PROPERLY WITH LATCH DOOR SEPARATE FROM SECURED DOOR FRAME. MAINTENANCE REPLACED COCKPIT DOOR DECOMPRESOR PANEL LATCH IAW AMM 52-51-14.SDR MASA2025070500054Light · no discrepancyAFT CABIN EMER CEILING LTS INOP - INSPECTED, OPS CHECKED - NO DEFECTS FOUND.SDR 2025FA0000450Air Box · inflt separationINSTALLED NEW UNIVAIR FAA/PMA CARBURETOR AIR-BOX, P/N U4-601-1 (144348). AFTER 1.3 HOURS FLIGHT TIME THE AIR OUTLET TUBE FLANGE ON THE BOTTOM OF THE BOX WHICH HAD BEEN ATTACHED BY SPOT WELDING, COMPLETELY SEPARATED AT THE SPOT WELDS AND DEPARTED FROM THE AIRCRSDR JR2R20250705799Channel · corrodedDRAIN MAST C-CHANNEL JUST AFT OF FR87 BETWEEN STR27R AND STR28R.SDR JR2R20250705800Angle · corrodedDRAIN MAST C-CHANNEL ANGLE JUST AFT OF FR87 BETWEEN STR27R AND STR28R.SDR JR2R20250705802Angle · corrodedDRAIN MAST C-CHANNEL ANGLE JUST AFT OF FR86 BETWEEN STR27R AND STR28R.SDR JR2R20250705801Channel · corrodedDRAIN MAST C-CHANNEL JUST AFT OF FR86 BETWEEN STR27R AND STR28R.SDR JR2R20250705941Web · corrodedWATER TANK SUPPORT BOX RH WEB LOWER FLANGE CORRODED. REPAIREDSDR JR2R20250705732Cam · chafedAFT CARGO DOOR BOTH FWD AND AFT VENT FLAP CAMS CHAFED. REPAIREDSDR JR2R20250705733Cam · chafedFWD CARGO DOOR BOTH FWD AND AFT VENT FLAP CAMS CHAFED. REPAIREDSDR REXA2026072901295Strap · crackedCRACK ON OVERWING FAIRING 171CL. OVERWING FAIRING 171CL WAS REPAIRED PER REO 670-53-82-430 REV: - -SDR REXA2026072901294Housing · crackedCRACK ON AFT LATCH HOUSING CUTOUT FS 188.00 OF ACCESS DOOR 212AR, CRACK ON AFT LATCH HOUSING CUTOUT (LANDING) FS 188.00 OF ACCESS DOOR 212AR WAS FABRICATED PER EA CRJ953-19746 REV IR AND INSTALLED IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01.SDR NACA2025070400003Plenum · damagedRH AIR CONDITIONING COMPARTMENT PLENUM FOUND PERFORATION. REMOVED AND REPLACED RH AIR CONDITIONING PLENUM COMPARTMENT AS PER B767-300 AMM 21-51-02 REV 145.