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 SWAA2025071682180Panel · corrodedCORROSION O/B FIXED LEADING EDGE FUEL QUANTITY INDICATOR HOUSING AT RT WING . REPAIRED FUEL SYSTEM PANEL LEADING EDGE BTW SS150.81 & SS163.95 RT WING IAW EA# 25-157-01687 WIP1 AND EA# 25-157-01687.SDR SWAA2025071682181Stringer · corrodedCORROSION ON STRINGER 25L LOCATED BS947.5 TO BS967 AND WL156 AT AFT CARGO COMPARTMENT. SRM SUPPLEMENT WAS NOT CONSULTED FOR REPAIR INSTRUCTIONS STEP 15 ITEM 2;[04] VERIFIED SUPPLEMENT ARM90-7023-01 REV B PARAGRAPH 3.A TABLE 1002; PAGE 1002; AND THE REPAIR DOESDR SWAA2025071582057Angle · elongatedELONGATED HOLE ANGLE - CLIP BS 500A AFT FACE BTW S-25L AND S-26L FWD CARGO COMPARTMENT. REPLACED ANGLE - CLIP BS 500A AFT FACE BTW S-25L AND S-26L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG 143A7505 SHEET 82 REV -.SDR REXA2025071500736Angle · corrodedCORROSION ON LOWER SILL BTW FS319 TO FS349 AT GALLEY SERVICE DOOR. DUE TO EXCESIVE CORROSION ON ANGLE MOUNTING BETWEEN FS319 TO FS349 AT GALLEY SERVICE DOOR MUST BE REPLACED PER CRJ-900 SRM 53-21-23-101-002-A02, SRM 51-42-06-001-001-A01, SRM 51-42-34-001-001-ASDR IPXA2025070835259Intercostal · crackedSTR- RH A/C BAY HAS A CRACKED INTERCOSTAL JUST AFT OF A/C BAY DOOR APPROX STRINGER S31. <BR>49-032 ATA 53-00.REMOVED INTERCOSTAL AT A/C R/H COMP APPROX STRINGER S31 REF MD11 SRM 51-35-01 AND 51-33-01.FABRICATED INERCOSTAL WEB PN ACA3804-27SAAU FOR RH AC BAY DOSDR SWAA2025070882120Scuff Plate · crackedAFT CARGO BAY FWD CORNER SCUFF PLATE CRACKED<[01] REPAIRED AFT CARGO BAY FWD CORNER SCUFF PLATE PER SRM 53-60-15-2R-1. RESTORED FINISHES ON INNER SURFACE PER AMM 51-21-41-370-802; AMM 51-21-72-370-804.SDR SWAA2025070782119Scuff Plate · crackedFWD CARGO BAY AFT CORNER SCUFF PLATE CRACKED<[01] LOCATED AND DRILLED NEW FCB AFT CORNER SCUFF PLATE IAW SRM 51-40-05 AND DWG143A8331;[02] LOCATED AND DRILLED NEW FCB AFT CORNER SCUFF PLATE IAW SRM 51-40-05 AND DWG143A8331.<BR>PART WILL BE INSTALLED ON CUSTOMESDR SWAA2025063082147Rib · crackedRIGHT WING DEFLECTION RIB TO WEB; OB CLIP IS CRACKED<[01] REMOVED AND REPLACED RIGHT WING DEFLECTION RIB TO WEB; OB CLIP IAW SRM 51-40-02<BR>DESC: CLIP<BR>P/N: 115A6260-2;[02] VERIFIED CORRECTIVE ACTION 1SDR SWAA2025063082079Floor Panel · delaminatedFLOOR PANEL 242AF IS DELAMINATED<[01] FABRICATION OF NEW 242AF FLOOR PANEL REPLACEMENT HAS BEEN ACCOMPLISHED PER [SRM 53-00-50-2R-0-B00275 (REPAIR GENERAL - COMPOSITE FLOOR PANELS - PERMANENT)]SDR CALA2025062605928Frame · crackedAD 2023-06-08, REPAIR BEFORE FURTHER FLIGHT. FR55 LEFT, BOTTOM T ACK HOLE AT STR 36 HAS A CRACK INDICATION AT THE 9:O CLOCK POSIT ION, AFT LOOKING FWD, 100% SH. PERFORMED INTERIM REPAIR O F AFT CARGO LH FR55 WEB STGR36L-37L BOTTOM TACH HOLE IAW ECRA 53 40-022SDR ATVB202506250001Hinge Fitting · damagedWHILE PERFORMING A POST FLIGHT CHECK, MAINTENANCE CREWS NOTICED THE LH MAIN LANDING GEAR SHOCK STRUT DOOR MISSING FROM THE AIRCRAFT. THE TECHNICIANS NOTICED THAT THE DOOR ATTACH FITTINGS WERE STILL ATTACHED TO THE MLG AND THE HEADS OF THE COUNTERSUNK BOLTS WESDR AALA202506257553Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR AALA202506257200Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 10WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL TEST PER AMM 33-51-38.SDR AALA202506255117Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FLOOR STRUCTURE SHEAR PLATE FR69 TO FR70 AND STR23R IN PASSENGER CABIN. MAINTENANCE REPLACED SHEAR PLATE LOC FR69 TO FR70 AND STR23R IN PASSENGER CABIN IAW A319 SRM 51-42-11-801, SRM 51-72-11-911-001 AND DWG D53474180.SDR AALA202506242396Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 992, LBL 37. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202506232325Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR DOOR FORWARD HINGE FITTING BEARING IS LOOSE. REPLACED HINGE FITTING PER CMM 52-81-18.SDR AALA202506236618Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR RJEF20250601001Servo Control · failedF/CTL R AILERON WITH OSCILATION AFTER TAKE OFF INCREASING WITH AIRSPEED INCREASE.THIS CONDITION PRODUCE HIGHT VIBRATION ON THE AC//REMOVED AND REPLACED AILERON SERVO CONTROL 33CE4 PER AMM A320 27-14-51-400-001-A TOOL USED QD2R200 SN 12046034907 02 NOV 2025 PN SDR NACA2025061500001Meter · within limitsR ENGINE VIBE METER GOES UP AND DOWN FROM 0.0 TO 1.1 PERFORMED AMM 71-00-00 R ENG VIBRATION N1 WITHIN LIMIT. PERFORMED R ENG FAN BLADE PART-SPAN SHROUD LUBE PER TASK CARD 72-433-01-02SDR CALA2025061905709Power Supply · dischargedEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK (INTERIOR AND EXTERIOR) {MULT-33-3-0004} - M1673 FAILED FUNCTIONAL CHECK. REPLACED BATTERY PACK IN M1673 POWER SUPPLY TWICE, IAW AMM 33-51-06-960-805, UP TO AND INCLUDING STEP 4.E.(6)(B). TEST BUTTON ON POWER SUPPLY DSDR CALA2025061905696Compressor · stalledCRUISE ENG 2 COMPRESSOR VANE CAUT LED TO ENG2 STALL AND ENG2 FAI L EGT 757 OBTAINED EIS REPORT DMC1 EGT MAX REACHED OF 766.3. DUE TO #2 ENGINE BEING CHANGED, DISCREPANCY TRANSFERRED TO AC 8802 REF LP5246942SDR DALA2025061904612Light · inoperative(LOG 7445530) DURING SVC FOUND EMERGENCY FLOOR PATH LIGHT AT ROW 27 INOP. REMOVED AND REPLACED FLOOR PROXIMITY LIGHT ASSY PER B737 AMM 33-51. OPS CHECKED GOOD.SDR DALA2025061904611Floorbeam · not reported(LOG 1026390) OPEN HOLES WERE FOUND ON FLOOR BEAMS WHILE WORKING ON WORK CARD 5300-01163-01. ACCOMPLISH ER/A 627157-14 REV IR. ASSOCIATED AA 5300-01163 ADDED FOR AC 3935 ASSOCIATED ER/A 14-627157 ADDED FOR AC 3935.SDR DALA2025061904616Power Supply · inoperative(LOG 7487426) AFT LEFT EMERGENCY LIGHTS INOP. R/R AFT LEFT EMERGENCY LIGHTS POWER SUPPLY PER B737 AMM 33-51. ALL LIGHTS OPS NML.SDR DALA2025061904599Latch · unsecureSHIP 3243 DISC: O2 MASK DEPLOYED IMMEDIATELY AFTER ROTATION. I WAS ABLE TO RESTOW MASK, HOWEVER THE FITTINGS WHICH LATCH THE ACCESS PANEL ARE NOT FULLY SECURE. MASK WAS NOT ACTIVATED AND NO O2 WAS RELEASED. C/A: RESTOWED O2 MASKS AS PER A320 AMM 35-21. PANEL ISDR CALA2025061805673Landing Light · malfunctionedRIGHT LANDING LIGHT FLASHED ON/OFF UNCOMMANDED AFTER LANDING PERFORM LTRTL MAIN ARRAY - OPERATIONAL TEST PER 33-42-21-710-801, TEST PASSED, NO FLASHING NOTEDSDR CALA2025061805672Cover · unsecureEMERGENCY EXIT HANDLE COVER NEEDS TO BE RESECURED 21F NO DEFECTS NOTED WITH EMERGENCY EXIT DOOR HANDLE AT SEAT 21F. LOWER ACCESS COVER WAS KNOCKED LOOSE BY PASSENGER. LOWER COVER IS SECURED BY VELCRO. RESECURED AS NECESSARY.SDR CALA2025061805671Slide · no discrepancyESCAPE SLIDE PACK PRESSURE GAGE LOW PRESSURE/QUANTITY 01L SLIDE AT DOOR 1L SHOWS LOW PRESSURE. VISUALLY INSPECTED ESCAPE SLIDE PACK PRESSURE GAUGE ON DOOR 1L, PRESSURE IS WITHIN THE GREEN BAND. OK TO CONTINUE SERVICESDR CALA2025061805670Slide · no discrepancyEXCESSIVE SLIDE MATERIAL VISIBLE DOOR 1R OKAY FOR CONTINUED SERVICE , MATERIAL STILL WITININ LIMITS REF AMM 25-66-01 OPS CHECK GOOD AT THIS TIME DOOR 1RSDR CALA2025061805669Girt Bar · no discrepancyTOO MUCH SLIDE MATERIAL SHOWING. FRONT RIGHT DOOR. INSPECTED SLIDE GIRT MATERIAL AND FOUND WITHIN LIMITS, R1 DOOR OPERATES NORMALLY NO FURTHER DEFECTS NOTED.REF AMM 25-66-01.SDR CALA2025061805668Indicator · damagedOVER HEAD SLIDE TAMPER INDICATOR DAMAGED AT SEAT ROW 2 REPLACED OVER HEAD SLIDE TAMPER INDICATOR AT SEAT ROW 2SDR CALA2025061805667Warning Light · false activationR AFT ENT DOOR EICAS AND ENTRY DOOR OVERHEAD LIGHT ON DURING TA XI IN. AFTER R ENG SHUTDOWN. FAULT NOT CONFIRMED. INTERNAL AND EXTERNAL DOOR OPERATIONAL CHECK REF B767-300 AMM 52-11-00-715-128 PERF. SATISF. OK FOR SERVICE.SDR YENA2025061800635Unknown · odorFLT#169, JFK-PUJ. 'MAGIC MARKER SMELL DESCENDING THROUGH 11000, DISSIPATED AFTER APPROX 60 SECONDS; C/W INFORMATION NOTICE 2015-T015 SECTION A ISOLATED FAULT TO TYPE 10 PER TSM 05-50-00-810-805B NO CABIN ODOR DETECTED WHEN CREW REPORMED ENGINE RUN. A/C OK FOR SDR UIEA2025061400775Flashlight Assy · no testDURING PREFLIGHT CHECK PORTABLE FLASHLIGHT HOLDER DOES NOT TEST WITH TEST BUTTON BY L1 DOOR. REMOVED AND REPLACED FLASHLIGHT EMERGENCY ASSY IAW AMM 25-64-01. OPS CHK GOOD.SDR HALA20250617033Starter · leakingEMERGENCY DECLARED. LOW OIL ENG #1 0.0 DECREASING FROM 18.0. AT SHUTDOWN ENG 1 QT 3.5. PILOT NOTED DURING EVENT OIL PSI 152 AND NO INFLIGHT SHUT DOWN PERFORMED. FOUND ENG STARTER LEAKING. REMOVED AND REPLACED PER AMM 80-11-01. LEAK AND OPS CHECK GOOD. ENGINE OSDR ASAA2025061558784Lens · missingEMERGENCY LIGHT ON CEILING NEAR ROW 21 MISSING COVER. GROUNDED - YES. EMERGENCY EXIT AISLE LIGHT AT ROW 21 LENS REPLACED REF AMM 33-51-03-960-803. ALL OPS CHECKS GOOD.SDR ASAA2025061558744Cover · detachedCENTER AISLE EMERGENCY SIGN COVER DETACHED. GROUNDED - YES. SECURED CENTER AISLE EMERGENCY SIGN COVER PER AMM 33-51-01-960-802 PERFORMED EMERGENCY LIGHTS OPS TEST PER AMM 33-51-00-720-801, TEST OK.SDR CALA2025061705625Hub Cap · missingHUB CAP LMG OUTBOARD TIRE MISSING INSTALLED HUB CAP ASSY IN REF TO AIPC 32-42-50-01 AND AMM 32-45-11-400-801PARTS USED: 00-0583-3-1877,QTY :1 29-3242-3-0006,QTY :1 00-0595-3-5738,QTY :1SDR CALA2025061705624Intercostal · corrodedAFT CARGO FLOOR R/H FRAME WEB HAS CORROSION FROM STA 1300-1320, STR 27R TO 28R, ON THE O/B SIDE. EVALUATED CORROSION ON FRAME WEB IN AFT CARGO FLOOR BTW STA 1300 -1320 STR 27R-28R AND FOUND OUT OF LIMITS. REMOVED AND REPLACED WITH NEW WEB IAW B757-300 SRM 53SDR CALA2025061705590Transceiver · faultedWEATHER RADAR NOT INOP WX RADAR IS INOP, PER CREW COULD ONLY PAINT ONE STREAK OF PRECIP, FLYING INTO WEATHER AND HAD TO BE DIVERTED BY ATC. NOTHING ELSE SHOWING ON DISPLAY WITH WEATHER IN VICINITY. CREW PERFORMED MX WITH TOMC AND COULD NOT GET RADAR TO RESET. SDR CALA2025061705589Generator · faultedAT ROTATION LEFT GEN FAILED. BUS TIE DID NOT PICK UP. RAN AC BUS OFF CHECKLIST AND GOT RESET BITE CHECKED BPCU, FOUND FAULT MSG LEFT GCU REPLACED LEFT GCU, REF AMM 24-22-02. GCU PASSES INSTALL TEST. PERFORMED #1 ENGINE RUN, LEFT IDG OPERATED NORMALLY WITH ELESDR SWAA2025061782051Light · inoperativeCR RR LEFT OVER WING EMERGENCY EXIT DOOR LIGHT INOPERATIVE. VERIFIED LEFT OVER WING EMERGENCY EXIT DOOR LIGHT. OPS CHECK IS GOOD IAW SWA BOEING 737-700 AMM 33-51-04-960-802.SDR AALA202506171098Start Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DISPLAYED SHOWING ENGINE 1 OIL QUANTITY 0 IN FLIGHT, OIL PRESSURE AND TEMPERATURE INDICATIONS WERE NORMAL BUT EVENTUALLY OIL PRESSURE DROPPED, PRECAUTIONARY ENGINE SHUTDOWN. AIRCRAFT DIVERTED TO AND LANDSDR AALA202506170325Starter · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DISPLAYED SHOWING ENGINE 1 OIL QUANTITY 0 IN FLIGHT, OIL PRESSURE AND TEMPERATURE INDICATIONS WERE NORMAL BUT EVENTUALLY OIL PRESSURE DROPPED, PRECAUTIONARY ENGINE SHUTDOWN. AIRCRAFT DIVERTED TO AND LANDSDR AALA202506171728Hydraulic Line · leakingAIRCRAFT WAS GROUNDED: ON TAXI IN LOST HYDRAULIC SYSTEM-A. QUANTITY INDICATOR SHOWS 0%., AIRCRAFT COULD NOT MOVE AND WAS STUCK ON THE TAXIWAY. FIRE PERSONNEL INDICATES LEAKING HYDRAULIC FLUID FROM RIGHT SIDE OF AIRCRAFT. REMOVED AND REPLACED SPOILER DOWN A TUBSDR AALA202506174075Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT PYLON SPIGOT FITTING RECEPTACLE. REPLACED SPIGOT FITTING PER SRM 54-51-12.SDR AALA202506177278Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT PYLON SPIGOT FITTING RECEPTACLE. REPLACED SPIGOT FITTING PER SRM 54-51-12.SDR QXEA2025061700260Brake · crackedON ARRIVAL CHECK, #2 BRAKE ASSEMBLY INBOARD STATOR FOUND CRACKED WITH NOTABLE SEPARATION AT ONE AREA. REPLACED #2 BRAKE ASSEMBLY IAW PRODUCTION WORK ORDER 352702 TASK CARD E175-3249003.SDR VNAA2025061711102Unknown · noiseAFTER TAKEOFF LOUD ELECTRIC CRACKLING/BUZZING NOISE FROM FO SIDE OF FLIGHT DECK / INSPECTED NOSE COMPARTMENTS/AVIONICS BAY FOR ANY LOOSE ITEMS. PRESSURIZED PLANE IAW CRJ700 AMM 21-31-00-910-801-A01-PSA TO ~4.0 DELTA AND USED RADIOS TO CONTACT TOWER. OPS CHECKSDR DALA2025061704559Sign · detachedSHIP 6716 2R EXIT SIGN FELL OFF. CORRECTIVE ACTION: ATTACHED 2R EXIT SIGN PER B757 AMM 52-22. (7351200)