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 DALA2025081406086Skin · corrodedSHIP 3146 TRAILING EDGE OVERHANG AREA AT LOWER SURFACE, RH WING TOP SKIN PANEL 2 WAS FOUND WITH CORROSION. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142270).SDR DALA2025081406085Skin · corrodedSHIP 3146 FOUND CORROSION AT THE RH WING TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LOWER SURFACE. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142264).SDR DALA2025081406084Skin · corrodedSHIP 3146 RH WING TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LOWER SURFACE CORRODED. CORRECTIVE ACTION COMPLIED WITH ER/A 627459-14. (1142256).SDR DALA2025081406083Skin · corrodedSHIP 3146 RH WING TOP SKIN PANEL 2, TRAILING EDGE OVERHANG AREA, LOWER SURFACE FOUND WITH CORROSION. CORRECTIVE ACTION: COMPLIED WITH ER/A 627459-14. (1142252).SDR AALA202508147377Flap System · lockedAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED INBOUND INTO LAS DUE TO THE FLIGHT CREW REPORTING A FLIGHT CONTROL, FLAPS LOCKED - ALIGNMENT FAULT WHEN SELECTING FLAPS 2 DURING DESCENT, THE AIRCRAFT LANDED SAFELY AT LAS WITHOUT FURTHER INCIDENT. MAINTENANSDR DALA2025081406081Connector · damagedSHIP 3356 EMERGENCY LIGHT AT SEAT 50J INOP. CORRECTIVE ACTION: REPAIRED CONNECTOR PER A330 AMM 33-51. OK FOR SERVICE. (7850702)SDR DALA2025081406080Power Supply · faultedSHIP 3429 FOUND EMERGENCY POWER SUPPLY (16WL) FAULTING. CORRECTIVE ACTION: REMOVED AND REPLACED EMERGENCY POWER SUPPLY (16WL) OPS CHECKS GOOD REF A330 AMM 33-51-38. (7295688)SDR DALA2025081406079Bracket · damagedSHIP 3412 #16 BRACKET AT FRAME 20 FWD SIDE OF FRAME - TOOLING MARKS ON BACKSIDE OF FRAME 20. CORRECTIVE ACTION: REPAIRED PER ERA 628417-14 REV ORIGINAL. (1141540)SDR YENA2025081400838Engine · failedFLT#547, ISP-MCO. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO JFK, AFTER T.O. ENG #2 FAIL. OPENSDR AALA202508145425Battery · no testAIRCRAFT WAS NOT GROUNDED: R3 DOOR, EMERGENCY POWER SUPPLY UNIT 12WL BATTERY FAILED EMERGENCY LIGHTING SYSTEM TEST PER TASK CARD 26L00025010. MAINTENANCE REPLACED THE BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-61-00 AND TASK CARD 26LSDR AALA202508149678Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ELEVATOR INBOARD ACTUATOR FITTING LOCKING LUG CRACKED BETWEEN ELEVATOR RIBS 4 AND 5. REPAIRED FITTING PER SRM 55-26-47-300-001.SDR AALA202508143112Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508142293Gust Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: AT GATE ARRIVAL GATE AGENT NOTIFIED US THAT THE 1L DOOR GUST LOCK WAS NOT ENGAGING. MAINTENANCE LUBED 1L DOOR GUST LOCK ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 12-22-00.SDR AALA202508142339Bearing · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR DOOR FORWARD HINGE FITTING BEARING HAS EXCESSIVE PLAY. REPLACED HINGE FITTING PER CMM 52-81-18.SDR DALA2025081406076Sign · detachedSHIP 5810 EXIT SIGN BROKEN OFF OF FIXTURE BY 3L DOOR. CORRECTIVE ACTION: RESECURED EXIT SIGN BY 3L DOOR AS REQUIRED. (7735102)SDR FDEA202508131449Switch · inoperativeEMERGENCY LIGHT SWITCH INOP. GOES TO OFF INSTEAD OF ARMED WHEN THE GUARD IS CLOSED. REMOVED AND REPLACED EMERGENCY LIGHT PANEL. OPS CHECK NORMAL. AC OK FOR SERVICE.SDR FDEA202508131447Floor Panel · damagedHOLE ON FLOOR PANEL 241 FFF ON MIAN DECK. FLOOR PANEL 241 FFF ON MIAN DECK, WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R, REP. 4.B. , FIG. 201, REV. 92 APR 15,2025.SDR FDEA202508131446Floor Panel · damagedHOLE ON FLOOR PANEL 241 GFF ON MIAN DECK. FLOOR PANEL 241 GFF ON MIAN DECK, WAS REPAIRED I.A.W. B767 S.R.M. 53-00-50-2R, REP. 4.B. , FIG. 201, REV. 92 APR 15,2025.SDR FDEA202508131445Floor Panel · damagedBROKEN FLOOR PANEL 242 TFA ON MIAN DECK. FLOOR PANEL 242 TFA ON MIAN DECK, WAS REPAIRED I.A.W B767 S.R.M 53-00-50-2R, REP. 4.B. , FIG 201, REV. 92 APR 15, 2025.SDR YENA2025081400836Skin · damagedDURING HEAVY MAINTENANCE: CORROSION OVERHANG LOWER SURFACE BTW RIB 8 TO RIB 9 TRAILING EDGE AREA RH WING (CPCP RELATED); REF AEROMAN N/R 2025-458289, PERFORMED REPAIR OVERHANG LOWER SURFACE BTW RIB 8 TO RIB 9 TRAILING EDGE AREA RH WING IAW EC NO. A25-744-01 ANSDR YENA2025081400835Lock Pin · out of adjustDURING HEAVY MAINTENANCE: RH OFF WING ESCAPE SLIDE BALL LOCK PINS NOT FLUSH WITH OUTER SURFACE MUST BE REPLACED PER MAB 26-12-18-014C; REF AEROMAN NR 2025-458223 WO 2025 -185/1 R & R RH OFFWING ESCAPE SLIDE IAW AMM 25-62-42-000-001-A & AMM 25-62-400-001A.SDR DALA2025081406070Slat System · lockedSHIP 3247 - ATB - DUE TO THE SLATS BEING LOCKED AT FULL EXTENSION WITH A SLATS MECHANICAL OVERSPEED MESSAGE. CORRECTIVE ACTION: NO TROUBLE FOUND. RESET WING-TIP BRAKES AND LUBRICATED SLAT SYSTEM. AIRCRAFT RTS. (LP: 7455658)SDR CALA2025081407742Lamp · inoperativeR4 DOOR EXTERIOR EMERGENCY LIGHT INOP REF HAECO NON-ROUTINE NO.9473622, ORIGINATED BY EMP V909210, 85-3351-1-7003. PERFORMED BY EMP V909210, REPLACED R4 DOOR EXTERIOR EMERGENCY LIGHT LAMP AND TEST NORMAL AS PER AMM 33-51-04-960-801 REV.104. SDR- INFORMATION ONSDR CALA2025081407741Skin · puncturedLEFT ELEVATOR HAS HOLE ON UPPER SURFACE. REPAIRED LEFT ELEVATOR ON UPPER SURFACE IAW SRM 55-21-11-30 0-004. SANDWICH STRUCTURE AREA NEW STRUCTURAL REPAIR (DAMAGES LESS THAN 1000MNF (1.55IN)) CATEGORY A REPAIR ALL MAINTENANCE REPAIRS RII AND CIR REQUIREMENTS ASDR CALA2025081407740Chain · disconnectedR2 DOOR SLIDE CHAIN ASSY NOT ATTACHED TO SKIRT. REATTACHED R2 DOOR SLIDE CHAIN ASSY TO SKIRT IAW AMM 25-66-01.SDR CALA2025081407739Battery · failedDURING PREPERATION FOR APU RELAY REMOVAL FOUND BURNED SIGNES ON M2709004 BATTERY 10 MIN-R CASING. REMOVED R FCE BATTERY REMOVED ACC AMM 27-02-09-00A-520A. RH FCU 10 MIN BATTERY REPLACED AS PER AMM DMC-B787-A-27-09-00A-720A-A. OLD FCU BATTERY WAS SCRAPPED LOCASDR CALA2025081407738Floorbeam · corrodedSTA 987 FLOORBEAM TEE CAP HAS CORROSION. EVALUATED CORROSION BS 986.5, ORIGINAL THICKNESS 0.150, REMAINING MATERIAL 0.053, REMOVED 0.097. RBL ORIGINAL THICKNESS 0.150, REMAINING MATERIAL 0.091, REMOVED 0.059. FOUND BOTH TO BE OUT OF LIMITS IAW SRM 51-10-08 ANSDR CALA2025081407737Seat Track · corrodedBS 328, LBL45 HAS CORROSION ON THE END OF SEAT TRACK. REMOVED CORROSION, ORIGINAL THICKNESS 0.135, LOSS 0.0195, REMAINING 0.115 FOUND TO BE OUT OF LIMITS IAW SRM 53-10-51-1A-1 FIG 105 STEP B AND BAC DWG 141A5770 REV 'A'. LOCATED AND DRILLED NEW SEAT TRACK ISDR CALA2025081407736Hose · leakingFORWARD LAV LEAKING INTO FLIGHT DECK, FWD LAV WAS SERVICED IMPROPERLY FLUID ALL OVER FLOOR OF FLT DECK & FWD GALLEY, BLUE AND BROWN WATER COMING OUT OF BOTH EE BAY DRAINS. REMOVED OVERFLOWED LAV FLUID FROM LOWER FUELAGE AREA UNDER FLIGHT DECK & LOWER FUSELSDR CALA2025081407735Fuel Cap · missingAIRCRAFT ARRIVED WITH FUEL CAP MISSING. REF GMM 02-30-95. REF FUEL CAP CDL LOG PAGE 5902678.SDR CALA2025081407734Hose · deterioratedFOUND LIQUID LEAKING FROM FWD CARGO AFT BILGES ON ARRIVAL WALK AROUND. REMOVED CARGO FLOOR PANEL TO ACCESS INTERIOR OF FWD OVERBOARD DRAIN MAST. RUBBER ELBOW CONNECTION TO DRAIN MAST FOUND IN POOR CONDITION. REPLACED DRAIN MAST ELBOW FITTING, OPS CHECKED GOSDR CALA2025081407727Slide · no discrepancyL2 SLIDE PACK BOLTS STICKING OUT. VERIFIED THAT THE EMERGENCY ESCAPE SLIDE AT DOOR 2L IS PROPERLY SECURED WITH NO OTHER FAULTS NOTED. ACFT OK FOR CONTINUED SERVICE. REF 25-66-01-400-805 ESCAPE SLIDE PACK & COVER INSTALLATION.SDR CALA2025081407726Bottle · no discrepancyDOOR 2R SLIDE PRESS GAUGE IN THE RED. FOUND WITHIN LIMITS REF AMM 25-62-00-210-001-A GAUGE MODEL A.SDR CALA2025081407725Lock · malfunctionedDOOR FLIGHT LOCK 1L EICAS STATUS L1 PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 5211280. PSEU 2 (R2) REF FIM 52-11 TASK 809, MX MSG SHOWS NOT ACTIVE/LATCHED ON ARRIVAL, INTERSDR CALA2025081407724Slide · dislodgedMED 2R SLIDE FELL OUT OF DOOR, UNRAVELED BUT DID NOT INFLATE DUE TO IT'S BOTTLE BEING PINNED. SLIDE ASSY WAS REMOVED FROM FLOOR GIRT ATTACH POINTS. REMOVED OLD SLIDE INSTALLED NEW SLIDE. REF AMM 25-66-01-400-801. SOLD TO INSPECTION. VERIFIED THE SAFETY SECURSDR CALA2025081407717Switch · malfunctionedEMERGENCY LIGHTS UNARMED LIGHT ILLUMINATED WITH SWITCH IN ARMED OR ON POSITION WIGGLED ON LIGHT SWITCH, UNARMED LIGHT EXTINGUISHED, TOGGLE SWITCH OP CHECKED NORMAL AS WELL, OK TO CONTINUE.SDR CALA2025081407716Battery · faultyEMERGENCY FUEL SHUTOFF BATTERY OPS CHECK FAILED ON TEST FLIGHT PRE-FLIGHT CHECK. REMOVED AND REPLACED EMERGENCY FUEL SHUTOFF BATTERY AS PER B737 AMM TASK 28-22-14-400-801. OPS CHECKED NORMAL.SDR CALA2025081407715Wire · brokenFOUND ROW 29 EMERGENCY LIGHT INOPERATIVE. FOUND WIRES UNDER SEAT BROKEN. REPAIRED WIRES IAW SWPM206417. PERFORMED OPS CHECK. OPS CHECKED GOOD IAW 33-51-00.SDR HNAA2025081400570A/C Pack · odorAFTER SUSPECTED LIGHTNING STRIKE MUSTY SMELL FROM PACKS IN FLIGHT DECK. RAN PACK 1 & 2 FOR 10 MINUTES. COULD NOT DUPLICATE MUSTY SMELL COMING FROM PACKS.OK FOR SERVICE AT THIS TIME.SDR SCNA20250814319Girt Bar · no discrepancy1L GIRT BAR IS HARD TO OPERATE AND STICKY. INSPECTED OUTER SLIDE AND GIRT BAR NO DEFECTS NOTED AND OPS CHECK NORMAL AND FREELY IAW 25-66-00 OK FOR SRV.SDR SCNA20250814318Light · no discrepancyEMERGENCY LIGHT STRIP DETACHED FROM FLOOR NEAR SEAT 12C. INSPECTED LIGHT STRIP AT 12C IAW AMM 25-27-21, NO ISSUE FOUND. OK FOR SERVICE.SDR HNAA2025081400560A/C Pack · odorAFTER SUSPECTED LIGHTNING STRIKE MUSTY SMELL FROM PACKS IN FLIGHT DECK. FROM PACKS IN FLIGHT DECK. RAN PACK 1 & 2 FOR 10 MINUTES. COULD NOT DUPLICATE MUSTY SMELL COMING FROM PACKS.OK FOR SERVICE AT THIS TIME.SDR HNAA2025081400660A/C Pack · odorAFTER SUSPECTED LIGHTNING STRIKE MUSTY SMELL FROM PACKS IN FLIGHT DECK. FROM PACKS IN FLIGHT DECK. RAN PACK 1 & 2 FOR 10 MINUTES. COULD NOT DUPLICATE MUSTY SMELL COMING FROM PACKS.OK FOR SERVICE AT THIS TIME.SDR DALA2025081306067Oxygen Mask · unsecureFORWARD LAV OXYGEN MASK DOOR NEEDS TO BE RESECURED. RESECURED FWD LAV OXYGEN MASK DOOR PER A A319 AMM 25-25.SDR DALA2025081306066Unknown · odorCAPT AND F/O ALL OF A SUDDEN BOTH NOTICED A STRONG SULFER/ROTTEN EGG SMELL. INSP APU COMPARTMENT NO DEFECTS NOTED. RAN PACK NO ODOR DETECTED . C/W W/C 0550-2002.SDR DALA2025081306065Filter · odorSMELL OF FUMES WHEN TURNING ON APU BLEED. PERFORMED ECS DECONTAMINATION REVERSE DUCT BURN AND REPLACED BOTH AIR RECIRCULATION FILTERS. PER W /C 2100-2005.SDR DALA2025081306063Panel · delaminatedFOUND REPLACEMENT PANEL 192FB TO BE DAMAGED/DELAMINATING, FWD INBD CORNER. COMPLIED WITH ER/A 628505-14.SDR 2025FA0000543Control Arm · crackedARCHER RUDDER TRIM CONTROL ARM ASSEMBLY, CRACKED DUE TO METAL FATIGUE IN THE PART.SDR 7C7A2025081300026Skin · dentedDENT ON FUSELAGE SKIN STA 1697 BETWEEN S-18L AND S-19L.SDR 7C7A202508130001Hinge · damagedLH ENG OB LOWER BLOCKER FLAP #6 FROM 12 OCLOCK POSITION LOWER HINGE ATTACHEMENT PLATE HAS MISSING PIECE