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 SIMA202602239001Seat Track · corrodedCORROSION ON SEAT TRACK AT FR 82 Y+10" (MAJOR REPAIR) (LEVEL 2 CORROSION) BLENDED AREA ON AFT RH SEAT TRACK AT FR 82 AND Y= +10? PER EMB 175 SRM 51-10-03. BLENDED AREA MEASURES (L: 1.00? W: .50? D: .024?) AND IS FOUND TO BE OUT OF ALLOWABLE LIMITS, PART REQUIRSDR AALA202602239594Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 3 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END-FITTING 3 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM55-16-42-400-001-A.SDR AALA202602231198Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 2 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED BEARING HINGE ARM 2 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202602234439Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 4 ELEVATOR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END-FITTING 4 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR CALA2026021813888Battery · inoperativeFWD RT EMERGENCY FLASHLIGHT IN CABIN INOPERATIVE. REPLACED FWD RT FLASHLIGHT BATTERY. OPS CHECKED GOOD IAW AMM 25-64-00-900-806.SDR SWAA2026021665876Support Bracket · crackedCRACKED SUPPORT BRACKET, ORSS 269, RT WING. REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0 ITEM 9. & DWG 115A2930, SHEET 7, REV -. MEASURE OF CRACK: L: 0.475 INCHES.SDR SWAA2026021665878Support Bracket · crackedCRACKED SUPPORT BRACKET, ORSS 278, RT WING T/E. REPLACED THE SUPPORT BRACKET IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, AND DWG 115A6200, SHEET 10, REV-.SDR SWAA2026021665877Support Angle · crackedCRACKED TRAILING EDGE SUPPORT ANGLE, ORSS 270, RT WING. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0.SDR AALA202602160748Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT AFT UPPER PAD ROTATED OUT OF POSITION. REPOSITIONED LEFT HAND AFT OVERWINGING EXIT DOOR FORWARD UPPER STOP PAD, PER B737-NG-AMM 52-22-01 AND B737-NG-SOPM 20-50- 03. PERFORMED SATISFACTORY EMERGENCY EXITSDR IPXA2026021236278Frame · crackedNR 1 ENGINE LOWER AFT FAIRING 475AL FORWARD SKIN ASSY LH FWD FRAME HAS A CRACK. REMOVED DOUBLER P/N 221-0081-244 IAW A300-600, SRM 51-40-21. REMOVED FORWARD RIB DUE TO CRACK IAW A300-600 SRM 51-40-21. INSTALLED L/H FWD FRAME ASSY USING FASTNERS NAS1097DD6 B#SDR R61A2026021600043Window Post · damagedWHILE ON HEAVY CHECK - RT DV WINDOW POST HFEC ROTO TEST FOUND RELEVANT INDICATION DUE TO HOLE DAMAGE ON BOTTOM OF FASTENER HOLESDR DALA2026021601056Bezel · damagedSEAT 19D EMERGENCY LIGHT BEZEL DAMAGED. R & R SEAT 19D BEZEL ASSY IAW CMM 25-22-56 .SDR CALA2026021613770Hydraulic System · overservicedPACK LIGHT COMES ON DURING FLT, LT PACK LIGHT CLB THRU FL200 BURN ODOR FOLLOWED BY PACK LIGHT ON. QRH TRIP R ESET UNSUCCESSFUL. FAULT HISTORY SHOWS MAINTENANCE MESS. 21-55100 (LT PACK OVERHEAT SHUTDOWN IN FLT ) FIM 21-51 TASK 819 ALSO MAINTENANCE MESGE. 21-30SDR SWAA2026021365575Crossbeam · crackedCRACKED CROSSBEAM, BS 540, RBL 2. REPLACED THE CROSSBEAM & FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A0060, SHEET 121, REV B.SDR SWAA2026021365576Floor Support · crackedCRACK FLOOR SUPPORT BRACKET, BS 696, BL 0. REPLACED THE FLOOR SUPPORT BRACKET AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, & DWG 273A9110, SHEET 6, REV A.SDR SWAA2026021265496Floor Panel · pulledFLOOR PANEL 231XF UPPER SKIN HAD AREAS OF PULLED STRANDS. FABRICATION OF A NEW FLOOR PANEL REPLACEMENT ACCOMPLISHED IAW SRM 53-00-50-2R-0.SDR SWAA2026021265498Floor Panel · pulledFLOOR PANEL 241AF UPPER SKIN HAD AREAS OF PULLED STRANDS. THE FLOOR PANEL WAS FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-50-1A-1, PARA 4.F, & FABRICATED A NEW FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWAA2026021265497Floor Panel · pulledFLOOR PANEL 232SF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL FABRICATION COMPLETE. THE FLOOR PANEL WAS REPLACED WITH THE NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR REXA2026021200054Angle · corrodedFWD BS 280 J-ANGLE HAS EVIDENCE OF CORROSION. REMOVED 280 J ANGLE IAW SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01. INSTALLED NEW J ANGLE IAW SRM 51-42-06-001-001-A01, AND SRM 1-42-21-001-001-A01.SDR CALA2026021213716Skin · dentedDURING INBOUND WALK AROUND OF AIRCRAFT, NOTED EXCESSIVE EXISTING KNOWN DAMAGE, REMOVED AND REPLACED AFT CARGO DOOR EXTERNAL SKIN IAW SRM 52-30-01-2R-3, SRM 51-40-02-0G-0, AND DWG 146A6110.SDR DALA2026021100986None · noneINITIATING MONITOR LOG PER AMDS TASK CARD 5331-01288-04. FWD SERV DOOR CUTOUT PER AMDS TASK CARD 5331-01288-04 AND SRM 53-10-01 REPAIR 1. (1426037)SDR JJBA20260211012Stringer · corrodedAFT WET AREA STRINGER 21R AT FR 61, HAS CORROSION. REMOVED CORROSION AND REPAIRED AFT WET AREA STRINGER 21R AT FR61.SDR JJBA20260211008Stringer · corrodedAFT WET AREA, STRINGER 21L AT FR 61 HAS CORROSION. REMOVED CORROSION AND REPAIRED AFT WET AREA STRINGER 21L AT FR 61.SDR JJBA20260211004Bezel · corrodedWING TO BODY PANEL 191ZB LT EMERGENCY LIGHT BEZEL HAS CORROSION. INSTALLED NEW EMERGENCY LIGHT BEZEL ON WING TO BODY PANEL 191ZB.SDR DALA2026021000962Fitting · corrodedNR 1 ENGINE ATTACHMENT SPIGOT FITTING OUT OF LIMITS, LEVEL 2 CORROSION. REPLACED NR 1 PYLON LOWER SPIGOT FITTING IAW A319 SRM TASK 54-51-12-300-001. (LP 1443400)SDR FDEA202601290157Frame · crackedCENTER BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 RH SIDE, FASTENER "H" HOLE FOUND CRACK SIGNAL. COMPLIED WITH EA 6-5710-T0386164. REPAIRED THE CRACKED CENTER BOX REAR SPAR RT FRAME 47 HOLE H. CAT -B- REPAIR AND THE POSTSDR AALA202602091980Separator · leakingAIRCRAFT WAS GROUNDED: MUSTY SOCK SMELL IN DESCENT TO WARM MOIST CLIMATE AT AUA. FLIGHT CREW REPORTED IT SMELLED STRONG IN CABIN SEAT 4C AND VERY STRONG FROM FLIGHT DECK OVERHEAD VENTS. **ORIGINAL REPORT WAS AALA202602024344 SUBMITTED 2/2/26 BY TUL** MAINTENANSDR AALA202602094344Vent Line · cloggedAIRCRAFT WAS GROUNDED: MUSTY SOCK SMELL IN DESCENT TO WARM MOIST CLIMATE AT AUA. FLIGHT CREW REPORTED IT SMELLED STRONG IN CABIN SEAT 4C AND VERY STRONG FROM FLIGHT DECK OVERHEAD VENTS. MAINTENANCE REPLACED THE APU GEARBOX VENT LINE PER AMM 49-26-55 AND THE ASDR DALA2026020700885Unknown · odorWALKED BOARDED THE AIRCRAFT AND INTO THE FLIGHT DECK, INSTANTLY SMELLED A METALLIC ODOR, APU INOPERATIVE ONLY GROUND AIR CONNECTED HAD GROUND AIR DISCONNECTED AND THE ODOR GOT WORSE TO THE POINT OF BEING ABLE TO TASTE IT. INSPECTED APU FOR OIL LEAKS IAW WC 4SDR ASMF2026020500001Actuator · failedSLATS DRIVE 278 121 00, LE SLAT GRA WAS REPLACED IAW AMM DMC -B787-A-27-81-04-01A-520A-A/720A-ASDR SWAA2026020567948Weep Hole · blockedNR 1 ENGINE WOULD NOT SPOOL UP FOR TAKEOFF . N1 WOULD NOT SPOOL UP, N2 WOULD. FOUND NR 1 ENGINE PS3 SENSE LINE WEEP HOLE BLOCKED. CLEANED IAW AMM 72-00-00. ENGINE RUN UP NORMAL.SDR R61A2026012800031Rib · crackedWHILE IN HEAVY CHECK, A CRACK WAS FOUND ON LT WING WHEEL WELL OPENING ON THE FWD EDGE, BETWEEN RIB 3 AND 4.SDR DALA2026020500826Web · abnormalAD / EM-EO TASK - FOUND NO.1 PYLON FWD UPPER WEB FOUND WITH AN EXISTING REPAIR AT NAC STA 221.250 TO NAC STA 237.500. REPAIRED THE WEB IAW ER/A 631985-14. (1425083)SDR IPXA2026020329998Engine · bird ingestionSUSPECTED BIRD STRIKE DURING TAKE OFF. ENG #2 N1 VIBRATION REACHED 7.5 DURING CLIMBOUT. REPLACED FAN BLADES ON #2 ENG ACCOMPLISHED ENG RUN OPS CK NORMAL.SDR DALA2026020300810Unknown · odorATB- RETURNED TO SEA DUE TO DIRTY SOCK SMELL IN THE FLIGHT DECK. NO VISIBLE HAZE/SMOKE. DONNED MASK DECLARED EMERGENCY. MTC IN PROGRESSSDR DALA2026020300809Apu · degradedFIRE/ATB - APU IN OPERATION DURING FLIGHT DUE TO ATA 24 MEL APPLIED FOR EPC 3 DEGRADED FAULT. DURING CLIMB, SHUDDER FELT IN BACK OF A/C WITH APU FAULT FOLLOWED BY FIRE INDICATION. APU FIRE HANDLE PULLED, BOTTLE DISCHARGED. RETURNED TO MCI. CORRECTIVE ACTION: ASDR DALA2026020300808Anti-Ice Valve · failedATB - DUE TO "WING A/ICE FAIL". REPLACED PRESSURE SENSOR AND ANTI-ICE VALVE. (LP# 7204983)SDR AALA202602032947Light · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT ON LEFT HAND SIDE OF FUSELAGE IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LAMP ON LEFT HAND SIDE OF FUSELAGE. PER AMM 33-51-04. OPS CHECK NORMAL.SDR FDEA202601290113Snubber · failedTHE L1 DOOR WILL NOT OPEN COMPLETELY. R & R THE L1 DOOR ROTARY SNUBBER UP TO BUT NOT INCLUDING STEP 3.G.(12) IAW AMM 52-11-10-4. COMPLETED INSTALLATION OF L1 DOOR, PNEUMATIC LINE. RECONNECTED AND SAFETY PIN REMOVED. INSTALLATION OF L1 ROTARY SNUBBER PER SDR WX0A2026020232721Spring · brokenAIRCRAFT NOT GROUNDED. WHILE REPLACING L2 DOOR SLIDE, FOUND L2 DOOR DAMPER CYLINDER STRIKER MECHANISM HAD BROKEN SPRING & PRESSURE GAUGE PLUG MISSING LIQUID LEAKED OUT. L2 DOOR DAMPER EMERGENCY CYLINDER INSTALLED IAW AMM 52-13-14-400-001-B, C/W AMM 52-11-14SDR DALA2026020200792Proximity Switch · faultedDURINB CRUISE, LT FWD EMERGENCY DOOR MESSAGE APPEARED MOMENTARILY WITH MOMENTARY PITCH CHANGE, & AUTOPILOT ANNUNCIATOR. NO NOISE, BANGING OR VIBRATION FELT BY FA OR PAX. 10 MIN LATER RT WING SLIDE MESSAGE APPEARED MOMENTARILY. MCC SUSPECT INDICATION ISSUE ANSDR DALA2026020200790Girt Bar · lack of lubeDURING WALK AROUND, FOUND R2 DOOR SLIDE LIGHT ILLUMINATED. WHILE THE SLIDE WAS DISARMED. LUBED GIRT BAR, OPS CHKD GOOD IAW AMM 25-66. (8379446)SDR SWAA2026020265702Flashlight · no testFLIGHT ATTENDANT FLASHLIGHT IN FWD GALLEY NO TEST. REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHKD GOOD. CLEARS MEL.SDR DXTA2026020206725Transfer Valve · inoperativeWHEN TRYING TO TRANSFER FUEL FROM LT TO RT, RECEIVED AN AMBER FUEL TRANSFER FAIL CASS MESSAGE. WHEN VIEWING THE FUEL PAGE, THE FUEL TRANSFER VALVE DID NOT MOVE.SDR DXTA2026020206727Oxygen Bottle · leakingOXYGEN BOTTLES LOST PRESSURE WHILE IN FLIGHT. BOTH OXYGEN BOTTLES WERE AT 1500-1600 ON PREFLIGHT.SDR DALA2026020200779Baffle · corrodedCORROSION LOWER BAFFLES ON SIDE TRACK RT AT BS 500H AT NUT AREA AT FWD CARGO BAY. THE BAFFLE WAS REPLACED IAW SRM 51-40-02-0G.SDR DALA2026020200778Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER TEE BS 947, RBL 53. THE FLOORBEAM UPPER TEE WAS REPAIRED IAW SRM 53-70-51-2R, PROCEDURE 8, REPAIR 8.SDR DALA2026020200776Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER TEE (LOWER/ UPPER SURFACE) STA 986.5 RBL 43 (APPROX) AT W2. FLOORBEAM UPPER TEE WAS REPAIRED IAW SRM 53-70-51-2R-6, REPAIR 6.SDR DXTA2026020206726Warning System · no discrepancyAT FL410 WE ENCOUNTERED SEVERE TURBULENCE. ACFT OVERSPEED TWICE WITH 10KTS IAS ABOVE VMO. SPEED BRAKES DEPLOYED WITH IDLE THRUST TO ATTEMPT TO COUNTERACT CONDITION. OVERSPEED LASTED APPROX 3 SECS EACH WITH AT LEAST 2 AURAL WARNINGS OF HIGH SPEED EACH TIME. ASDR DXTA2026020206736Downlock Switch · defectiveAFTER TAKEOFF AND SELECTING THE GEAR UP, RECEIVED AN AMBER GEAR DISAGREE N CAS MESSAGE. THE NOSE GEAR REMAINED DOWN AND LOCKED. AFTER TROUBLESHOOTING, R & R FAULTY NLG DOWNLOCK SWITCH. PERFORMED RIGGING & OPS CHECKING GOOD WITH 15 GEAR SWINGS. ALL OPS CHECKED