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 SWAA2026011341029Adapter · deterioratedDETERIORATED ADAPTER PLATE AND SHIM ON GIRT BAR FITTING, FWD ENTRY, & SERVICE DOORS. REPLACED THE ADAPTER PLATE AND SHIM IAW AMM 25-66-02-400-801, STEP 3 D, 1, A, B,J, AND WILL BE INSTALLED ON TASK CARD 725-025-00-01Y TTG8Q0194LLX ,STEP 13.SDR SWAA2026011341036Adapter · deterioratedDETERIORATED ADAPTER PLATE AND SHIM ON THE GIRT BAR FITTING ON THE AFT ENTRY AND SERVICE DOORS. REPLACED THE ADAPTER PLATE AND SHIM IAW AMM 25-66-02-400-801, STEP 3.D, 1 A, B, J, & WILL BE INSTALLED ON TASK CARD 725-025-00-02Y TTG8R008CU1R STEP 13.SDR SWAA2026011341035Nut · deterioratedDETERIORATED NUT ON ASSIST HANDLE OF THE AFT ENTRY AND SERVICE DOORWAY LINING. REPLACED THE NUT IAW AMM 25-21-25-420-801, STEP 3.B, ITEM 5.SDR SWAA2026011341038Rib · crackedCRACK LEADING EDGE RIB, LE HSS 151.75 ON RT HORIZONTAL STAB. REPLACED RIB ON RT HORIZONTAL STAB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 186A1001, SHEET 19, REV -.SDR SWAA2026011341133Skin · debondedDEBONDED EXTERNAL SKIN ON LT WING OTBD AFT FLAP. REPLACED LT WING OTBD AFT FLAP IAW AMM 27-51-22. REMOVAL AND INSTALATION SEE TTG8Q0197FMU.SDR SWAA2026011341134Skin · debondedDEBONDED EXTERNAL SKIN ON OTBD AFT FLAP, LOCATED INBD END AT RT WING. REPLACED THE RT WING OTBD AFT FLAP IAW AMM 27-51-22. FOR REMOVAL AND INSTALLATION SEE TTG8Q0197FS0.SDR SWAA2026010940918Light · deterioratedDETERIORATED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING ON ALONG PASSENGER CABIN. REPLACED PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING AT PASSENGER CABIN IAW AMM 33-51-15-400-802 INSTALLATION IS DOCUMENTED WHIT TTG8Q0022SA4 AND TTG8Q0022TU0.SDR SWAA2026010948328Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB, LBL 30, BS 663. PERFORMED PERMANENT REPAIR ON PRESSURE DECK WEB, BS 663.75 - 675, LBL 25 - 60 IN THE MAIN WHEEL WELL IAW SRM 53-40-51-2R-2, REPAIR 2, STEP 4.SDR SWAA2026010740916Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB LBL 30 STA 663 AT PASSENGER CABIN. CRACK LENGTH 0.200 INCH.SDR SWAA2025123040878Floor Panel · delaminatedCABIN FLOOR PANEL 242MF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 242MF PER AMM 53-21-00.SDR SWAA2025123040879Floor Panel · delaminatedCABIN FLOOR PANEL 241RF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 241RF PER AMM 53-21-00.SDR SWAA2025123040877Floor Panel · delaminatedCABIN FLOOR PANEL 241SF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 241SF PER AMM 53-21-00.SDR SWAA2025123040880Floor Panel · delaminatedCABIN FLOOR PANEL 241MF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 241MF PER AMM 53-21-00.SDR SWAA2025123040881Floor Panel · delaminatedCABIN FLOOR PANEL 241LF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 241LF PER AMM 53-21-00.SDR SWAA2025123040882Floor Panel · delaminatedCABIN FLOOR PANEL 242HF HAS DELAMINATION BULGE ON SURFACE. REMOVED AND REPLACED CABIN FLOOR PANEL 242HF IAW AMM 53-21-00.SDR SWIA2025122400130Seat Track · corrodedCORROSION ON R/H FLOOR SEAT TRACK BETWEEN FR 84-85 IN 3 LOCATIONS AS MARKED. (C-CHECK RO 12/23/2025)PERFORMED AND ACCOMPLISHED SEE TRACK SPLICE REPAIR AT R/H FLOOR SEAT TRACK FR 84-85 REF ETD2022-170-022163-C. SEE CONTINUATION CARD FOR WORK PERFORMED. NO CHANSDR SWAA2025122348643Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT NR 8 NOSE SKIN AT ACTUATOR LOCATION AROUND FASTENER AT RT WING. REPAIRED LOWER SURFACE OF LEADING EDGE SLAT 8 NOSE SKIN AT ACTUATOR LOCATION AT RT WING IAW SRM-57-42-01-2R-8-REPAIR 8.SDR SWAA2025122341247Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT NR 2 NOSE SKIN AT ACTUATOR LOCATION AROUND FASTENER AT LT WING. REPLACED LEADING EDGE SLAT 2 AND PERFORMED ADJUSTMENT AND OPERATIONAL TEST ARE OK LT WING IAW AMM 27-81-21-000-801, & AMM 27-81-21-400-801.SDR SWAA2025122348644Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT NR 1 NOSE SKIN AT THE ACTUATOR LOCATION, AROUND FASTENER AT LT WING. REPAIRED LOWER SURFACE OF LEADING EDGE SLAT 1 NOSE SKIN AT ACTUATOR LOCATION, AT LT WING IAW SRM 57-42-01-2R-8, REPAIR 8.SDR SWAA2025122341248Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT NR 1 NOSE SKIN AT ACTUATOR LOCATION. AROUND FASTENER AT LT WING.SDR SWAA2025122341244Skin · crackedCRACK LOWER SURFACE OF LEADING EDGE SLAT NR 8 NOSE SKIN AT ACTUATOR LOCATION. AROUND FASTENER AT RT WING.SDR AALA202512238128Access Panel · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER AFT SPAR UPPER SLIDER PANEL 333AT FORWARD GUIDE IS WORN THROUGH AT THE TOP AFT CORNER. REPLACED PANEL 333AT PER SRM 51-40-02.SDR AALA202512233095Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO STRINGER S9R AT BS 1040. REPLACED STRINGER PER AARD 51-00-05-1.SDR AALA202512189616Strip · splitAIRCRAFT IN BASE MAINTENANCE: RUDDER APEX STRIP FOUND TO BE SPLITTING IN TWO AREAS. APPROXIMATELY 2 FEET AND 4 FEET FROM BOTTEM EDGE. MAINTENANCE REPAIRED RUDDER PER SRM 55-41-19-300-011.SDR ASAA2025113063086Support · corrodedMAIN CABIN AFT WET AREA STA 986 AT RBL 32 HAS A WALL SUPPORT (PN: 147A5710) THAT HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW B737-800 SRM 53-70-51-1A-1 ORIGINAL .050" REMAINING .030" REMOVED AND REPLACED WALL SUPSDR ASAA2025113063085Support · corrodedMAIN CABIN AFT WET AREA BS 986, LBL 32 HAS A WALL SUPPORT (PN:147A5710) THAT HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION AND FOUND OUT OF LIMITS ORI. MAT .050, MAT. REMAINING .032 IAW B737-800 SRM 53-70-51-1A-1. REMOVED FLOOR WALL SUPPORT STA 98SDR ASAA2025113063084Floor Support · corrodedMAIN CABIN AFT WET AREA (SEC. 47) STA 947 TO STA 967 FLOOR SUPPORT AT RBL 16 HAS CORROSION ON THE UPPER SURFACE. GROUNDED - YES. REMOVED CORROSION ON FLOOR SUPPORT AT STA 951 RBL 16-RBL 24, LOST .018" OF MATERIAL. FOUND BEYOND LIMITS IAW SRM 53-70-51-1A-1, REMSDR ASAA2025113063083Floor Support · corrodedAFT WET AREA FLOOR SUPPORT, BS 967 - 986, LBL 14 HAD AREAS OF CORROSION. GROUNDED - YES. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 53-70-51-1A-1, ORIGINAL .071" REMAINING .051" REMOVED .020". REMOVED AND REPLACED THE FLOOR SUPPORT IAW DWG 140A9SDR SWAA2025121640842Handle · looseBOTH R2 AND L2 DOOR ASSIST HANDLES (NOT THE LINER) ARE LOOSE. SECURED BOTH R2 & L2 DOOR ASSIST HANDLES IAW AMM 25-21-25-420-801, STEP 3.B.(5).SDR ASAA2025113063015Web · corrodedMAIN CABIN SUPPORT WEB 147A5712-35 CORRODED AT STA 986.5. GROUNDED - YES. REMOVED CORROSION IAW B737-800 SRM 51-10-02 , NO ALLOWABLE DAMAGE STATED, DRILLED TO FIT NEW WEB P/N 147A37U35 PO:1137807.1 IAW B737-800 SRM 51-40-05 AND INSTALLED NEW WEB IAW BOEING DWGSDR ASAA2025113063014Floorbeam · corrodedMAIN CABIN FLOOR SUPPORT INTERCOSTAL CORRODED AT STA 986.5 L/H. GROUNDED - YES. REMOVED CORROSION IAW B737-800 SRM 51-10-02. NO ALLOWABLE DAMAGE STATED DRILLED TO FIT NEW INTERCOSTAL 147A5705Y1 PO:1137794.2 B737-800 SRM 51-40-05 AND BOEING DWG 147A5700 REV. B SDR ASAA2025113063011Floor Support · corrodedMAIN CABIN FLOOR SUPPORT INTERCOSTAL CORRODED AT STA 986.5 RT. GROUNDED - YES. REMOVED CORROSION IAW SRM 51-10-02, NO ALLOWABLE DAMAGE STATED, DRILLED TO FIT NEW INTERCOSTAL IAW SRM 57-40-05 P/N 147A570541 PO:113779.2 AND BOEING DWG 147A5700 INTERCOSTAL INSTALSDR AALA202512152854Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ESDR AALA202512150132Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ELSDR AALA202512150455Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ESDR AALA202512158319Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ELSDR AALA202512159663Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ELESDR AALA202512157099Hinge Fitting · excess playAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT ON CLIMB THRU FL 200 AT 325 IT'S INDICATED WE GOT FLIGHT CONTROL FLUTTER. WE BROUGHT SPEED BACK AND IT WENT AWAY. FLIGHT ATTENDANTS FELT IT AS WELL. MAINTENANCE REPLACED ALL 6 HINGE FITTINGS ON THE LEFT-HAND ELSDR ASMF202512090324Brake · faultedTHE PARKING BRAKE SET MSG DOES NOT SHOW IN THE EICAS WHEN THE PARKING BRAKE IS SET. REPLACED PARKING SER BULB AND CONFIRMED MAINT PAGE ATA 32. PARKING BRAKE OPERATION IAW MEL 32-45-01.SDR DALA2025120808961Unknown · odorFWD FAS SAYS THAT GOT A GOOD WIFT OF THE DIRTY SOCK SMELL ON CLIMB OUT. NO OTHER COMPLAINTS ON ACFT. FUME WAS SHORT TERM MAYBE A MINUTE OR TWO. TROUBLESHOT ODOR SMELL PER NO GO ODI PREVENTION REF TO LOG 1327715 FOR CORRECTIVE ACTION (7952142)SDR AALA202512083436Spring · missingAIRCRAFT IN BASE MAINTENANCE: L1 DOOR ESCAPE SLIDE GIRT BAR NYLON SPRING CLIP MISSING ON OUTER SLEEVE. REPLACED L1 DOOR OUTER SLEEVE. PER AMM 25-66-01.SDR AALA202512085552Stop Pad · missingAIRCRAFT IN BASE MAINTENANCE: L2 DOOR ESCAPE SLIDE GIRT BAR NYLON SPRING CLIP MISSING OWN OUTER SLEEVE. INSTALLED SERVICEABLE GIRT BAR STOP. PER JOB CARD 08C20025031.SDR AALA202512081048Bracket · brokenAIRCRAFT WAS NOT GROUNDED: 9C FLOOR EMERGENCY EXIT LIGHTING IS DANGLING AND INOPERATIVE. REPLACED EMERGENCY EXIT LIGHTING BRACKET FOR SEAT 9C AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-22-52. ** (CLOSED)SDR CALA2025120811836Structure · corrodedCORROSION AFT WET AREA INNER CHORD RT SIDE BETWEEN BS 907+16 AND 986.5. REMOVED AND REPLACED R2 INNER CHORD FROM BS 887 TO 1006 IAW DWG 147A8501 AND SRM 51-40-02,SDR AALA202512055002Skin · bentAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR INTERNAL DOOR SKIN AFT UPPER CONER BENT AND GOUGED. REWORKED THE FORWARD ENTRY DOOR INTERNAL DOOR SKIN AFT UPPER CORNER TO ITS ORIGINAL CONTOUR. PER B737NG SRM 51-70-01.SDR DALA2025120508917Pin · brokenATO- APPROX 80KTS DUE TO PREDICTIVE WINDSHEAR WARNING. FOUND COAXIAL CABLE PIN BROKEN. REPLACED SAME. OPS NORMAL.(7952152)SDR CALA2025120511795Eec · faultedCAPTAIN REPORTED MOMENTARY NOISE/BANG/SHUTTER DESCENDING THROUGH 37K, ENG PARAMETERS NORMAL. FELT LIKE GEAR COMING OUT BUT GEAR NOT DOWN. POSSIBLE CARGO SHIFT? NORMAL THROUGH REST OF DECENT.C/O GVI OF STAB, CONTROL SURFACES, GEAR & BAY PER AMM 05-41-07, 05-41-SDR ASAA2025113062685Door · unknownFLIGHT ATTENDANT REPORTS L1 DOOR DOES NOTCLOSE PROPERERLY WHEN RELEASED BY GATE AGENT. DOOR DOSE CLOSE ALL THE WAY BY ITS SELF AND REQUIERS FLIGHT ATTANT TO FORCE THE FINAL CLOSURE. GROUNDED - YES. INSPECTED L1 DOOR FOUND NO DAMMAGE PERFORMED FWD DOOR SYSTEM TSDR ASAA2025113061951Lamp · inoperativeL1 ENTRY LIGHT TURNS ON EMERGENCY EXIT LIGHT (EMERGENCY EXIT LIGHT OPS NORMAL) ( CABIN INTERIOR ILLUMINATION CONFIG WITH PHOTOLUMINESCENT EMERGENCY ESCAPE PATH MARKING SYSTEM ). GROUNDED - YES. RE-LAMPED FWD ENTRY LIGHT, OPS TEST GOOD, EMERG. EXIT SIGNS DID NOSDR DALA2025120408859Battery · inoperativeEMERGENCY LIGHTS BATTERY INOPERATIVE AT M1695. R & R EMERGENCY LIGHTS BATTERY AT M1695 PER B737 AMM 33-51.