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 CALA2025092409191Unknown · odorOBVIOUS AND OVERWHELMING SMELL OF CIGARETTE SMOKE IN PACK 1 SYSTEM. STRONG IN FLIGHT DECK. RAN PACKS, NO SMELL COMING FROM VENTS. TESTED SMOKE DETECTOR AS A PRECAUTION. CHECKED OK. INSPECTED IN ALL CABINETS AND BEHIND LAV SHROUD. INSPECTED LT PACK BAY. NO DEFESDR SWAA2025092317070Slide · dislodgedFWD SERVICE DOOR SLIDE DISLODGED. R & R FWD SERVICE EMERGENCY ESCAPE SLIDE IAW AMM 25-66-01.SDR SWI2025F01323Warning Message · illuminatedWOW INPUT CAUTION MESSAGE SHORTLY AFTER TAKEOFF. (FLIGHT 5121)SDR SWIA2025092300022Acm · odorERRONEOUS TEMPERATURE READINGS ON ESC PAGE ON AIR DUCT FROM PACKS , UNABLE TO MAKE TEMPERATURE ADJUSTMENTS, STRANGE ALMOST BURNING SMELL THROUGHOUT FLIGHT DECK AND PASSENGER CABIN. MEL 21-61-1CCAT: C DUE: 2OCT25. ERRONEOUS TEMPERATURE READINGS ON ESC PAGE ONSDR DALA2025092306961Strap · damagedCOMPLY WITH ER/A 626909-14AD SECTION IV LT WING REAR SPAR LOWER STRAP REPAIR. COMPLIED WITH ER/A 626909-14AD REV. E SECTION IV AND PRI 626909- 14AD REV. E REV 0 - 4. LH WING REAR SPAR LOWER STRAP REPAIR. (1212786)SDR HALA20250923288Heater · faultedETOPS - 2HR INTO FLIGHT ELEC CB TRIPPED APU 5000VU. REMOVED AND REPLACED APU OIL HEATER PER AMM 49-96-11 LEAK CHECK GOOD OKAY TO CONTINUESDR DALA2025092306958Gust Lock · faultedL2 SERVICE DOOR GUST LOCK DOES NOT LOCK DOOR IN OPEN POSITION. FOUND GUST LOCK UNIT RETURN SPRING DAMAGED, CAUSING GUST LOCK HOOK TO BE INCORRECT POSITION. REPLACED SPRING AS REQUIRE REF A319 AIPC 52-13. (7183162)SDR DALA2025092306957Skin · scratchedFOUND SCRATCHES AAFFECTING THE FUSELAGE SKIN PANEL BETWEEN FR 57 AND STR 26L-27L. COMPLIED WITH ER/A 629166-14AD. (1212433).SDR DALA2025092306956Skin · scratchedSCRATCH ON EXTERNAL SKIN LOCATED BTW FR 57 TO FR 58 AND STR 26L TO ST R 27L AT LOWER FUSELAGE. COMPLIED WITH ER/A 629166-14AD. (1212626).SDR DALA2025092306955Cover · damagedSLIDE COVER NEEDS TO BE REPLACED. REMOVE AND RE-INSTALL SLIDE COVER AND INSTALL AND REMOVE SAFETY LOCK P IN ON RESERVOIR ASSY OF ESCAPE SLIDE OF PASSENGER CREW DOOR 831, 832, 841 AND 842. (1212191).SDR AALA202509237548Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER UPPER ATTACH ANGLE LOCATED IN LEFT HAND ECS BAY, AT AFT BULKHEAD BS 663, RBL 13. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR AALA202509231791Power Supply · failedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY AT L1 DOOR FAILED. REPLACED BATTERY PACK POWER SUPPLY PER AMM 33-51-00 OPERATIONAL CHECKED GOOD.SDR DALA2025092306953Frame · damagedFRAME 19R DAMAGED BETWEEN STRINGER 37R. REPLACED FRAME 19R PER A330 SRM 51-42-11. (1212144)SDR DALA2025092306952Stringer · damagedSTRINGER 38R DAMAGED BETWEEN FR 18. REPLACED STRINGER PER A330 SRM 51-42. (1212147)SDR DALA2025092306951Stringer · damagedSTRINGER 39R DAMAGED BETWEEN FR 18. REPLACED STRINGER PER A330 SRM 51-42. (1212141)SDR DALA2025092306950Seal · faultedDIV - TO HNL DUE TO EXCESSIVE NOISE/SQUEAL IN THE FORWARD GALLEY NEAR THE R1 DOOR. FOUND A LOOSE PORTION OF THE EXTRUDED RUBBER STRIP AT THE LOWER PART OF THE DOOR STICKING OUT PAST THE DOOR SEAL. SECURED EXTRUDED RUBBER STRIP. (LP 7680667(SDR DALA2025092306949Oven · failedAIRCRAFT 1007, OVEN 104 IN FWD GALLEY WAS USED TO WARM UP BREAD FOR ONLY 5 MINUTES. STARTED TO SMELL AN ELECTRICAL BURNING SMELL, THEN THE SCREEN GAVE AN ERROR MESSAGE. SHUT OVEN 104 DOWN. CORRECTIVE ACTION: REPLACED OVEN 104 REF A321 AMM 25-35-19. OPS CHK NMLSDR DALA2025092306948Mount · brokenEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:10D. SECURED LIGHT TO SEAT WITH TAPE. DEFERRED TO MEL, PLACARDS INSTALLED. (NOTE: MOUNT POINT ON SEAT BROKEN- WILL NEED SEAT SHROUD REPAIR/REPLACE). (LP: 1212089)SDR AALA202509234353Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FWD FLIGHT ATTENDANT FLASHLIGHT BATTERY DEPLETED. MAINTENANCE REPLACED FWD FLIGHT ATTENDANT FALASH LIGHT BATTERY PER AMM 25-60-00.SDR AALA202509239658Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 11WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38 WITH NO FAULTS NOTED.SDR AALA202509230614Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT BETWEEN FR 68 AND FR 70 AT +Y160.5. REPLACED FLOOR SUPPORT PER SRM 51-72-11.SDR AALA202509238198Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT BETWEEN FR 68 AND FR 70 AT -Y160.5. REPLACED FLOOR SUPPORT PER SRM 51-72-11.SDR AALA202509238880Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT LEFT HAND SLIDE LIGHT INOPERATIVE. REMOVE AND REPLACED EPL BATTERY M1670 (AALA202509235892), PER AMM 33-51-66. ALSO, FOUND CONNECTOR D11083 DISCONNECTED, RECONNECTED CONNECTOR (AALA202509230084), PER WDM 3SDR AALA202509236857Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EXTERIOR EMERGENCY LIGHT LEFT HAND SLIDE LIGHT INOPERATIVE. REMOVE AND REPLACED EPL BATTERY M1670 (AALA202509235892), PER AMM 33-51-66. ALSO, FOUND CONNECTOR D11083 DISCONNECTED, RECONNECTED CONNECTOR (AALA202509230084), PER WDM 3SDR AALA202509232513Battery Pack · no testAIRCRAFT IN BASE MAINTENANCE: FAILED EMERGENCY BATTERY AT L1 DOOR. REMOVED AND REPLACED L1 DOOR EMERGENCY BATTERY PACK. PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA202509230682Girt Bar · dirtyAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT L1 GIRT BAR IS DIFFICULT TO INSTALL AND REMOVE WHEN ARMING AND DISARMING THE L1 DOOR. REMOVED DIRT CLEAN AND LUBRICATED GIRT BAR, OPERATIONAL CHECK GOOD. PER AMM 25-66-01.SDR AALA202509230745Lens · brokenAIRCRAFT WAS NOT GROUNDED: L2 DOOR EMERGENCY EXIT LIGHT AND LENS BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT AND LENSE. OPERATIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202509237431Lock · brokenAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR WILL NOT OPEN FROM OUTSIDE. LOCK FAIL LIGHT ILLUMINATED ON FLIGHT DECK. TROUBLESHOT AND FOUND STRIKER LOCK BROKEN. REMOVE AND REPLACED STRIKER LOCK. GROUND OPERATIONAL CHECK GOOD FOUND SATISFACTORY AT THIS TIME. PER AMM SDR AALA202509234190Fitting · unsecureAIRCRAFT WAS NOT GROUNDED: R2 GIRT BAR CLIPS APPEAR TO BE DAMAGED AND NOT CLIPPED. RESECURED GIRT BAR ATTACH BRACKET. PER SRM 51-40-02.SDR AALA202509237751Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR 1R DIFFICULT TO ARM AND DISARM. LUBED GIRT BAR, OPERATIONAL CHECK GOOD. PER AMM 25-66-01.SDR FDEA202509221765Power Supply · no testENTRY AREA EMERGENCY EXIT LIGHTS WON'T TEST OR LIGHT UP DURING PREFLIGHT. SUSPECT ESPU BATTERY. FOUND EMERGENCY POWER SUPPLY UNIT WON'T BITE TEST. REPLACED POWER SUPPLY UNIT BATTERY REF A300 AMM 33-51-14-04. EMERGENCY LIGHTS AND POWER SUPPLY UNIT TESTS GSDR FDEA202509221764Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221CFF HAS NUMEROUS DENTS. REPAIRED FLOOR PANEL 221CFF, MPN: 141T5856-105, LBL 11-RBL 11, STATION 285-412 IN REF TO BOEING DWG 141T5856-105. THIS IS A MAJOR REPAIR. INSTALLATION OF THIS PANEL WILL BE ACCOMPLISHED ON WSDR QXEA2025092300309Unknown · odorFLIGHT 2218. WHILE CLEANING FWD LAV, CLEANER INFORMED FLIGHT ATTENDANT SHE SMELLED SMOKE. ACCORDING TO FA & FO THE LAV SMOKE MASTE WARNING ILLUMINATED ON EICAS MOMENTARILY. THIS OCCURED AFTER ALL PASSENGERS HAD DEPLANED. REMOVED FROM SERVICE. PERFORMED A GVI ISDR DALA2025092306942Engine · failedIFSD/ATB- AIRCRAFT RETURNED TO ATL DUE TO LEFT ENGINE FAILURE DURING CLIMB. METAL FOUND IN TAILPIPE, ENGINE REPLACEMENT PER AMDS WC 7100-4423-LH AND LOG PAGE 1211244.SDR DALA2025092306936Floor Support · corrodedCORROSION ON FLOOR SUPPORTS BTW STA 312 TO 344 LBL12 AT CPAX. FLOOR SUPPORTS BTW STA 312 TO 344 LBL12 AT CPAX WERE REPLACED AND INSTALLED PER B737-800 SRM 51-40-02-0G.SDR DALA2025092306935Floorbeam · corrodedBOTH LEFT FLOORBEAM FROM LBL 24 TO 27 AND 49 TO 53 FWD OF BS 967 CORROSION. REMOVED AND REPLACED BOTH LT FLOORBEAM FWD OF STA 967 LOCATED LBL 24" TO 27" AND LBL 49" TO LBL 53" AS PER REF SRM 51-40-02.SDR DALA2025092306934Bear Strap · ground damageDUE TO IMPACT DAMAGE, FUSELAGE BEARSTRAP P/N 141A3522-3 FORWARD SECTION DAMAGED FROM STA 203.8 - 196.5. REPAIRED DAMAGED BEARSTRAP PER ER/A 628235-14 REV ORIGINAL COMPARED TO PRI 628235-14 REV 0 AND 1. IDENTIFIED REPAIR STEPS 10 AND 11 ADDED TO ER/A 628235-14 SDR DALA2025092306933Skin · mechanic errorDURING THE LOCATION AND DRILLING OF SKIN P/N 141A3521Y33, 12 HOLES WERE MISDRILLED ON THE SKIN @ RBL 17 AND BS 178 - 188. TRIMMED OUT MINIMAL AMOUNT OF MATERIAL ONLY TO REMOVE MISDRILLED HOLES PER STEP 3 PN 628289-14 REV 0. REMOVED THE NECESSARY NUMBER OF FASSDR YENA2025092300963Exciter · faultedFLT#2289, AMS-JFK. (ETOPS) "ENG 2 IGN B FAULT ( IGNITION SYSTEMS B) SYSTEM B ); (RESOLVED ON W/O: 1443473 TASKCARD: NR-00003) REMOVED AND REPLACED ENG 2 IGNITER B& R/R IGNITER B CABLE IAW AMM 74-21-61 OPS CHK GOOD MX-4 UPDATED, PLACARD REMOVED.SDR YENA2025092300962Fire Loop · faultedFLT#2260, MAD-BOS. (ETOPS) "ENG 2 LOOP A FAULT ( ENGINE FIRE DETECTION SYSTEMS 1) LOOP A ); PREVIOUS T/S (TROUBLE SHOOTING ON W/O: 1443299 TASKCARD: NR-00002) T/S PER TSM 26-12-00-810-805-A. FOUND PINA/C & A/A OF CORE AGB LOOP A DETECTOR (4002WD1) NULL. R/R COSDR HNAA2025092300638Bleed Valve · failedBLEED 1 VALVE FAILED MESSAGE ON TO ROLL. R & R THE BLEED VALVE IAW AMM 36-11-05. OPS CHECKED GOOD IRT AMM 36-00-00-700-803-A. GROUND RAN AIRCRAFT. NO LEAKS NOTED AT THIS TIME. OKAY FOR SERVICE.SDR HNAA2025092300637Hydraulic Line · leakingENGINE HYD 1 PUMP FAIL & HYD 1 LOW QTY. PERFORMED GVI INSPECTION ENG #1 DUE TO SUSPECTED ENG #1 HYD LEAD. FOUND ABUNDACE OF HYD FLUID IN COWLING. SUSPECTED HYD RETURN LINE. FURTHER TROUBLESHOOTING REQUIRED. R & R NR 1 EDHP IRW AMM 29-10-03. OPS & LEACH CHECSDR DXTA2025092305050Light Sys · malfunctionedCABIN EMERGENCY LIGHTS CAME ON BY THEMSELVES WITH SWITCH IN THE ARM POSITION. EXTINGUISHED BY THEMSELVES APPROX 5 MINS LATER DURING CLIMB. AFTER LANDING, WITH THE MAIN SHIP BATTERIES BOTH OFF, THE EMER LIGHTS TURNED ON & OFF NORMALLY WITH THE SWITCH. RECOMMENSDR CALA2025092309171Support Beam · corrodedRH AFT EMERGENCY HATCH INTERNAL STRUCTURE, ABOVE WINDOW, HAS 2 G OUGES WITH EVIDENCE OF CORROSION. REMOVED & REPLACED BEAM SUPPORT AT R/H AFT EMERGENCY HATCH INTER NAL/STRUCTURE IAW A320 SRM 51-72-11 & 51-42-11.SDR CALA2025092309170Battery Pack · inoperativeEXIT ROW EMERGENCY LIGHTS INOPERATIVE ROWS 15-21, RED EMERGENCY AISLE LIGHTS INOPERATIVE. REPLACED ALL 4 FUSES IN POWER SUPPLY AND SWAPPED IN NEW BATTERY AT BS 570 ON ACFT LEFT (FWD OF ROW 20A FLOOR PANEL), NO HELP. SWAPPED IN NEW BATTERY CHARGER WITH NEW SDR CALA2025092309169Connector · disconnectedEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. 21A SIDEWALL EMERGENCY LIGHT INOPERATIVE. EMERGENCY LIGHT FUNCTION OF 21A SIDEWALL LT INOPERATIVE. FOUND CONNECTOR BEHIND LIGHT ASSY DISCONNECTED. CONNECTED LIGHT ASSY. OPS CK OF SIDEWALL AND EMER LT GOOD REF AMSDR FDEA202509221763Floor Panel · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 222AFF HAS NUMEROUS DENTS. JM31 FABRICATED FLOORPANEL# 222AFF MPN# 141T5856-107 RBL 11- RBL 33 STA 285-412 IN REF TO BOEING DWG 141T5856-107. SEE JPF FOR ALL WORK STEPS ACCOMPLISHED. THIS A MAJOR REPAIR.SDR FDEA202509221762Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 252DFF HAS A PUNCTURE DAMAGE. M36 REPAIRED FLOOR PANEL 252DFF, MPN: 146T5869-2, RBL 77.50- RBL 89.50, STA. 1087- 1197, IN REF. TO 767 SRM 53-00-50-2R, FIG 201, SHEET 2, AND BOEING DWG# 146T5869-2. FLOOR PANEL WAS NSDR FDEA202509221761Doubler · crackedRIGHT WING - LEADING EDGE LOWER ACCESS PANEL CUTOUT FORWORD EDGE DOUBLER AT STATION XOS 488 FOUND CRACK ABOUT 1 INCH. RIGHT WING LEADING EDGE LOWER ACCESS PANEL CUTOUT FORWORD EDGE CRACKED DOUBLER ABOUT 1 INCH AT STATION XOS 488. FABRICATED DOUBLER PER DOUSDR FDEA202509221760Fitting · not reportedDOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR (MDCD) ACTUATOR BEARING FITTINGS AT FRAME 23 AND 24 - AOT A52W016-24 COMPLIED WITH EO: 6-5230-E0378588 B P5. TITLE: DOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION