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 CALA2025120511807Bracket · crackedONE BRACKET CRACKED AT THE LOWER LEFT WING OT BODY FAIRING STRUCTURE AT BS 1040, LOCATED AT THE FWD END OF THE BEAM. REMOVED AND REPLACED THE BRACKET ON LT WTB FAIRING STRUCTURE AT BS 1040 IAW SRM 51-40-02-0G. & DWG 149N7553.SDR CALA2025120511805Elt · false activationELT TRANSPONDER IS REPORTING AN EMERGENCY. REPORTED BY CITY OPS TOWER. AIRPLANE WAS SQUAWKING DURING TOW. TOW WAS ABORTED AND AIRPLANE DEENERGIZED. UPON ARRIVAL TO AIRPLANE, POWERED UP AIRPLANE AND TUNED INTO ELT FREQUENCY. NO TRANSMISSION HEARD. NO CFDS MESSASDR CALA2025120511803A/C Pack · contaminatedPER CAPTAINS CALL. DEICING CREW SPRAYED GLYCOL INTO THE APU INTAKE, WHICH CAUSED THE A/C SYSTEM TO FILL THE CABIN AND JET BRIDGE WITH DENS GLYCOL SMELL. RAN PACKS WITH APU BLEED AIR NO FURTHER SMELL FOUND REF FIM 21-00 TASK 830.SDR CALA2025120511801Battery Pack · inoperativeFIRST CLASS EEPL LIGHTING AND R1 DOOR EMERGENCY LIGHTING INOP. SUPPORT TASK NSA EMX N/R 00159. REMOVED FWD ENTRY PANEL IAW AMM 25-21-71-000-807 SUBTASK 25-21-71-010-010. REMOVED BATTERY PACK AT BATTERY SUPPLY UNIT M1674 IAW AMM 33-51-06. INSTALLED SERVICEABLSDR CALA2025120511799Lamp · burned outFOUND CIDS FAULT, EPSU EXT LOAD EMER R. DURING EMERGENCY LIGHT TEST. RELAMPED RT OVERWING LIGHT LAMP IAW AMM 33-51-15. OPS CHECKED GOOD. NO FURTHER DEFECTS NOTED.SDR CALA2025120511788Reservoir · no discrepancyDOOR 1 EMERGENCY POWER RESERVOIR REPLACEMENT REQUIRED DUE TO PLANNED DEPLOYMENT OF SLIDE. REPLACED RESERVOIR AT DOOR 1R ON AAG TASK CARD 1003863014-0010 IAW AMM 52-11-30 REV 138. SAFETY PINS REMOVED ON AAG TASK CARD 100386301-0010 AS PER AMM 52-11-30 REV 1SDR CALA2025120511786Light · inoperativeOVERWING EMERGENCY EXIT CABIN WINDOW LIGHT 20A INOPERATIVE. REPLACED OVERWING EXIT WINDOW LIGHT ASSY IAW AMM 32-21-00-960-802. OPS CHECKED GOOD.SDR SWAA2025120442494Mount · crackedFWD SERVICE DOOR AFT SLIDE MOUNT ISOLATOR CRACKED. R & R FWD SERVICE DOOR AFT SLIDE MOUNT ISOLATOR IAW SRM 51-40-02.SDR SWAA2025120442489Mount · damagedAFT ENTRY DOOR FWD SLIDE MOUNT ISOLATORS DAMAGED. R & R AFT ENTRY DOOR FWD SLIDE MOUNT ISOLATORS IAW SRM 51-40-02.SDR SWAA2025120442421Stop · damagedAFT SERVICE ESCAPE SLIDE GIRT BAR RELEASE STOP DAMAGED. REPLACED AFT SERVICE ESCAPE SLIDE GIRT BAR RELEASE STOP IAW AMM 25-66-01.SDR SWAA2025120442501Nut · looseR2 DOOR INTERIOR STRUCTURE FORWARD OF DOOR OPENING ASSIST HANDLE LOOSE. LOWER NUT CRACKED. R & R INTERIOR STRUCTURE FORWARD OF DOOR OPENING ASSIST HANDLE LOWER NUT IAW AMM 20-50-11.SDR SWAA2025120442593Battery Pack · inoperativeRIGHT FWD SERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED FWD EMERGENCY EXIT BATTERY PACK IAW AMM 33-51-06. OPS TESTED GOOD.SDR SWAA2025120442496Handle · looseFWD SERVICE DOOR INNER HANDLE LOOSE. SECURED FWD SERVICE DOOR INNER HANDLE IAW AMM 20-50-11.SDR SWAA2025120442497Acoustic Panel · delaminatedNR 2 ENGINE HAS TWO AFT ACOUSTICAL PANELS THAT ARE DELAMINATED LOCATED ABOVE AND BELOW THE 3 OCLOCK STRUT. REMOVED AND REPLACED THE AFT ACOUSTICAL PANELS IAW AMM 72-23-02.SDR SWAA2025120442732Girt Bar · brokenFWD ENTRY DOOR SLIDE GIRT BAR HOOK ON COVER HAS BROKEN FASTENER. ACCOMPLISHED EA M-23-125-01839 WITH SAFETY WIRE.SDR SWAA2025120442741Apu · shutdownAT CRUISE FL 400 RECEIVED APU LOP LIGHT. APU DID AUTO SHUTDOWN NH30. PERFORMED OPERATONAL TEST OF APU AND TEST PASS IAW AMM 49-11-00.SDR DALA2025120408873Proximity Sensor · false indicationDOOR 3R SHOWS ARMED AFTER DOOR IS DISARMED. REPLACED PROX SENSOR 34MJ PER A330 52-71-12. OK FOR SERVICE. (8015300)SDR DALA2025120408865Floorbeam · corrodedSHIP 3315 CABIN FLOORBEAM UPPER SURFACE FOUND CORROSION AT FR78, BETWEEN Y0 TO Y450. REPAIRED PER ERA 630593-14 REV ORIGINAL. (1334590)SDR DALA2025120408864Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE FOUND CORROSION AT FR75, BETWEEN Y0 TO -Y450. REPAIRED PER ERA 630555-14 REV ORIGINAL. (1334586)SDR YENA2025120401174Fmc · faultedFLT#1189, JFK-SAN. (ETOPS) 1-35. PERFORMED BITE TEST + NO FAULT NOTED. C/W TSM 28-42-00-810-147A. THIS CLEAR MDDR. MX-4 UPDATED MCC REQUEST ETOPS TO REMAINS DOWNGRADED.SDR VNAA202512020044Fitting · damagedLEFT HSTA SCREW JACK FITTING HAD DAMAGE AND REQ REPAIR.SDR VNAA202512020043Window Frame · gougedWHILE CLEANING COCKPIT DISCOVERED THERE TO BE A GOUGE IN RH BELOW WINDSHIELD SILL SUPPORT STRUCTURESDR VNAA202512020042Hinge Fitting · gougedNR 1 SIDE OF INBD MULTI FUNCTIONAL SPOILER ATTACHMENT HINGE FITTING IS GOUGED.SDR VNAA202512020041Lug · chafedHORIZONTAL STABILIZER OTBD LUG FITTINGS HAVE CHAFING DAMAGE FROM CONTACT WITH THE ANTI-ROTATION DEVICES.SDR VNAA202512020040Skin · corrodedPITTING CORROSION LOCATED ON THE EXTERIOR OF FUSELAGE BETWEEN F.S 501 AND F.S 517 AT STRINGER 27. REQUIRES EVALUATION. SH670-33202 SKINSDR VNAA202512020039Skin · damagedFOUND TWO ELONGATED FASTENER HOLES ON SKIN AT FS 986 STGR 27.SDR VNAA202512020038Window Frame · crackedLEFT WINDSHIELD POST SHOWS SIGNS OF CRACKING ON UPPER SIDE.SDR VNA2025F00043Window Frame · crackedLEFT WINDSHIELD POST SHOWS SIGNS OF CRACKING ON UPPER SIDE.SDR VNAA202512020037Window Frame · crackedRIGHT WINDSHIELD POST SHOWS EVIDENCE OF CRACKING ON UPPER SIDE.SDR VNAA202512020036Ring · corrodedCORROSION FOUND IN RT ENGINE RING AT A4 ATTACHMENT BOLT HOLE (1EA) MARKED WITH ZIP TIE THROUGH DISCREPANT BOLT HOLE.SDR VNAA202512020035Web · corrodedRUDDER LOWER WEB HAS AREAS OF CORROSION ON INNER SURFACE. CC670-22135-3 LOWER WEBSDR VNAA202512020034Web · crackedPAX DOOR FWD WEB FOUND TO BE CRACKED.SDR VNAA202512020033Web · crackedPAX DOOR AFT WEB FOUND TO BE CRACKED. REQUIRES REPLACEMENT.SDR IXXA20251204003Window · crackedREPAIR VIEWPORT WINDOWS PRISM ASSY. LEFT AND RIGHT AFT PASSENGER ENTRY DOOR ASSY. B767SDR VNAA202512020032Seat Track · corrodedRBL 9 SEAT TRACK IS CORRODED BETWEEN F.S. 985 TO F.S. 1000.SDR QR9R2025120400001Shutoff Valve · damagedTHE FUEL SHUTOFF VALVE WAS RECEIVED FROM SUPPLY WITH A DAMAGED HELI-COIL.SDR VNAA202512020031Seat Track · corrodedLBL 18 SEAT TRACK IS CORRODED BETWEEN BS 939 - 985.SDR VNAA202512020030Frame · corrodedFOUND CORROSION ON BS 379 RT FRAME BETWEEN S20R AND S25R.SDR VNAA202512020029Plate · corrodedPAX DOOR KICKPLATE ANGLE CORRODED OUTBOARD SIDE, FWD TO AFT.SDR VNAA202512020028Mount Bracket · corrodedLEFT PYLON LOGO LIGHT MOUNTING STRUCTURE HAS CORROSION IN MULTIPLE PLACES. MM 670-37285-S0201 LOGO LIGHT MOUNTING PLATE.SDR VNAA202512020027Seat Track · corrodedLEFT SIDE SEAT RAIL BETWEEN CS 860 AND 969 IS CORRODED.SDR VNAA202512020026Seat Track · corrodedSEAT TRACK LBL 9, BS 517 - 549 IS CORRODED.SDR VNAA202512020025Bracket · chafedRIGHT MLG SIDE STAY BRACKET IS CHAFED.SDR VNAA202512020024Angle · corrodedPAX DOOR MID CAP ANGLE IS CORRODED.SDR DALA2025120408853Door · leakingLEFT MID CABIN EMERGENCY DOOR HISSING IN FLIGHT. REMOVED AND INSTALLED LT EMERGENCY HATCH DOOR AND INSPECTED SEAL IAW AMM 52-21-11. (1334540).SDR DALA2025120408850Seal · leakingAIRCRAFT 5008, ON DESCENT EXPERIENCED MUSTY GYM SOCK ODOR. BEGAN APPROXIMATELY 18,000 FT AND CONTINUED THROUGH DESCENT. REPLACED NR 1 & 2 ENGINE FAN SHAFT COVER SEAL PER AMM 72-15. PERFORMED LEVEL B DECONTAMINATION OF ECS SYS PER AMM 21-00. C/W LEVEL B DECONSDR VNAA202512020023Mount Fitting · corrodedGALLEY MOUNT FITTING IS CORRODED BETWEEN F.S. 280 TO F.S. 295 AND BETWEEN RBL 9 TO RBL 18.SDR VNAA202512020022Striker · corrodedGALLEY SERVICE DOOR LOWER SEAL STRIKER IS CORRODED ON THE AFT SIDE AROUND SCREW HOLES.SDR VNAA202512020020Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED BETWEEN F.S. 319 TO F.S. 333.SDR VNAA202512020019Seat Track · corrodedRBL 9 FLOOR SEAT TRACK IS CORRODED BETWEEN F.S. 349 TO F.S. 469