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 AALA202601145321Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT CARGO MOUNT TIE DOWN TRACK AT BS 500I, RBL 14. REPAIRED TRACK FLANGE PER EA 369584.SDR AALA202601148116Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO BAY TRANSITION PANEL LOCATED FROM BS 500A TO 500I AND LBL 24. REPLACED TRANSITION PANEL IAW AARD 51-00-05-1.SDR AALA202601130172Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 400 TO BS 500A AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR SWI2026F00034Skin · chafedLEFT WING LOWER SKIN CHAFED AT WS 264 WHERE FLAP FAIRING MAKE CONTACT. REPAIRED LH WING LOWER SKIN WS 264 IAW REO 601R-57-21-3988, REV-, & SKYWEST TASK CARD 51-900-1003-SKY.SDR SWI2026F00033Intercostal · crackedBS 625.30, S14L, ATTACHING ANGLE FROM THE FRAME TO THE INTERCOSTAL ON THE REAR PRESSURE BULKHEAD, IS CRACKED. INTERCOSTAL AND REPLACED WITH NEW INTERCOSTAL IAW DWG 601-35012 REV D, REO 601R-53-61-422 REV NC, SRM 51-42-21, AND SKYWEST TASK CARD 51-900-1003-SKYSDR SWI2026F00032Skin · chafedLEFT WING LOWER SKIN CHAFFED AT WS127.25 WHERE FLAP FAIRING MAKE CONTACT. REPAIRED LT WING LOWER SKIN WS127.25 IAW REO 601R-57-21-3992 REV -.SDR SWIA2026010523Skin · gougedRIGHT WING LOWER SKIN FRETTING AND GOUGED AT TRAILING EDGE BL45.00 WHERE FAIRING MAKES CONTACT. REPAIRED RT WING LOWER SKIN FRETTING AND GOUGE AT TRAILING EDGE BL45.00 WHERE FAIRING MAKES CONTACT REF REO 601R-57-21-880 REV-D, , DWG# 601R10046 REV. V, SRM 51-1SDR AALA202512301941Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE LOWER RADIUS LH. CRACK L= 0.100 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOC ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDSDR AALA202512300198Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE UPPER RADIUS RH. CRACK L= 0.110 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOC WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE UPSDR AALA202512309193Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE LOWER RADIUS RH. CRACK L= 0.235 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR ON WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE LOSDR SCNA20251027409SAttach Angle · brokenBROKEN BASE OF STRAP EMERGENCY EXIT DOOR 832 & 842. BASE OF STRAP EMERGENCY EXIT DOOR 832 WAS REPLACED FOR ONE NEW PER B737-800 AMM 52-22-51 ALSO 842 WERE REMOVED, REPAIRED AND INSTALLED PER B737-800 AMM 52-22-51 AND B737-800 AMM 25-00-00SDR CALA2025121912233Beam · corrodedAFTER FURTHER EVALUATION FOUND CORROSION OUT OF LIMITS ON RH HORIZONTAL STAB, T/E LWR CHORD (BEHIND BALANCE PANEL NR 2), REQ REPAIR (REF AAR NR 1000057993). ALL WORK CAPTURED ON AAR RFD N/R 1000057993 UNDER PROJECT N76288-3. REPAIRED RT HORIZONTAL STAB, T/E LSDR CALA2025121612139Strap · corrodedAFT CARGO COMPARTMENT STRAP BTW STA. 767 AND STA 867 HAS CORROSI ON NEEDS TO BE REPLACED. (REF AAR NR 1000057636) ESFR AND SDR CREATED AND SENT REMOVED AND REPLACED AFT CARGO COMPARTMENT STRAP BTW STA. 767 A ND STA 867 IAW B737-800 , SRM 51-40-02-0G-0, DWG 14SDR REXA2025121201032Striker · corrodedCORROSION ON LOWER SILL OF GALLEY SERVICE DOOR (LOWER SURROUND STRUCTURE AREA) LOWER SILL OF GALLEY SERVICE DOOR (LOWER SURROUND STRUCTURE AREA) WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR REXA2025121201014Channel · corrodedCORROSION ON CHANEL (5 EA) OF SETTLEMENT AREA OF ACCESS PANEL 561AT CORROSION ON CHANEL (4 EAS) OF SETTLEMENT AREA OF ACCESS PANEL 561AT WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 51-21-06-001-001-A01 AND WERE REPLACED PER CRJ900 SRM 51-42-06-001-001-A01 AND CSDR REXA2025121201013Angle · crackedCRACK ON CLIP THAT ATTACHES STGR 7LH TO FS 1051.30 ON AFT BAGGAGE BAY DOOR SURROUND STRUCTURE. CLIP THAT ATTACHES STGR 7LH TO FS 1051.30 ON AFT BAGGAGE BAY DOOR SURROUND STRUCTURE WAS FABRICATED PER DWG MM670-36471 REV.A. AND WAS REPLACED PER CRJ900 SRM 51-42-SDR REXA2025121201012Support Angle · corrodedINITIAL INSPECTION': CORROSION AT FS 280.00 FLOOR ACCESS PANEL SUPPORT ANGLE. CORROSION AT FS 280.00 FLOOR ACCESS PANEL SUPPORT ANGLE WAS REMOVED PER CRJ900 SRM 51-21-06-001-001-A01, EVALUATED OUT OF LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PESDR REXA2025121201011Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT. CRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE BELOW FLIGHT COMPARTMENT. WAS REPAIRED PER REO 690-53-11-2073SDR REXA2025121201010Cleat · crackedCRACK ON INTERCOSTAL CLEAT AT FS 661.00+90 AND STGR 27 WING-TO-FUSELAJE FAIRING STRUCTURE (PT) FPI WAS PERFORMED ON INTERCOSTAL CLEAT, NO CRACKS WERE FOUND PER CRJ700/900/1000 NDT MANUAL PART 01, 51-20-008-230-A01 (EQUIPMENT: THERMOMETER C/N:1774 EXP:16/JAN/26SDR SWAA2025120427826Battery Pack · inoperativeINOPERATIVE GALLEY 3 BATTERY PACK. REPLACED GALLEY 3 BATTERY PACK IAW AMM 33-51-06-960-805. INSTALLATION TESTED OK.SDR SWAA2025120427823Skin · crackedCRACKED LOWER SURFACE SKIN OF LEADING EDGE SLAT 7, AT ACTUATOR LOCATION AROUND FASTENER ON RT WING. FAULT RESOLVED ON OTHER FAULT, TTG8Q015XHC7.;SDR SWAA2025120427822Skin · crackedCRACKED ON LOWER SURFACE OF LEADING EDGE SLAT 7, NOSE SKIN AT ACTUATOR AROUND FASTENER ON RT WING. PERFORMED PERMANENT REPAIR IAW SRM 57-42-01-2R-8, REPAIR 8.SDR JJBA20251204008Floor Support · corrodedRIGHT GUSSET BTW FR 59-51 CORRODED. RT GUSSET BTW FR 59-61 REMOVED AND REPLACED.SDR SWAA2025120341943Battery Pack · inoperativeINOPERATIVE BATTERY PACK AT FWD GALLEY AREA (2 EA). REPLACED BATTERY PACK AT FWD GALLEY AREA (2 EA) IAW AMM 33-51-06-960-805. INSTALLATION TESTED OK.SDR IPXA2025112822937Drag Fitting · damagedLEFT WING UPPER SKIN HOLES, UPPON VISUAL INSPECTION, IT WAS FOUND NR 1 HOLE CSK WITH CHATTERING, NR 8 HOLE CSK WITH CORROSION, NR 3 & 5 HOLES HAVE VISUAL DEFECTS NOTED AND VERIFIED HOLES BY MEASURES. ACCOMPLISHED REPAIR PER EO-95917-REQ1 AND VT-SAA EA 757-570SDR IPXA2025112816445Skin · damagedRIGHT WING OUTBOARD MAIN FLAP L/E SKIN HAS A GOUGE AT APPROX WS 652.50. CCOMPLISHED THE PERMANENT REPAIR PER EO-95912-REQ1 AND VT-SAA EA 757-5700-01-B0636, REV. IR.SDR SWAA2025120127592Lens · brokenBROKEN LENS ON EMERGENCY LIGHT AT HEADER PANEL FWD RT SIDE. REPLACED THE LENS IAW SOPM 20-50-01, REV 39.SDR SWAA2025120127598Scuff Plate · crackedCRACKED AFT CORNER SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED THE AFT CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2025120127596Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED FWD CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1 REPAIR 1 AND BAC 5975.SDR SWAA2025120127302Former · crackedWING TO BODY FAIRING FORMER CRACKED, BS 500D BETWEEN S19 & 20L. REMOVED AND REPLACED THE WING TO BODY FAIRING SUPPORT IAW SRM 51-40-02, AND DWG 116A3010, REV-.SDR SWAA2025120127597Access Panel · elongatedELONGATED HOLE ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR HNAA2025120100842Frame · crackedFRAME 59 CRACKED AT BETWEEN S15 & 16L. REPAIRED IAW ETD 2025-145-931141.SDR HNAA2025120100841Beam · crackedCARGO ENTRY LWR BEAEM CRACKED . R & R LOWER BEAM IAW SRM 51-40-02.SDR IPXA2025110922681Skin · corrodedRIGHT WING UPPER SKIN HAS EVIDENCE OF CORROSION AT APPROX BBL 70.50 AND STGR U-14 AREA, ACCOMPLISH REPAIR IN ACCORDANCE WITH EO-95795-REQ1 AND VT-SAA EA 757-5700-01-B0633 REV IR PRIOR TO FURTHER FLIGHT.SDR SWAA2025112027611Tee Angle · crackedCRACK ON TEE ANGLE LOCATED ON BS 663.75 RBL 25 MAIN WHEEL WELL COMPARTMENT. REPAIRED THE TEE ANGLE LOCATED ON BS 663.75, RBL 25 MAIN WHEEL WELL COMPARTMENT IAW EA- 25-153-03083-WIP1;SDR SWAA2025112027149Vapor Barrier · crackedCRACK (3) ON VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT. REPAIRED VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112027147Vapor Barrier · crackedCRACK (4) ON VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT. REPAIRED VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT IAW SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112027148Vapor Barrier · crackedCRACK (5) ON VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT. REPAIRED VAPOR BARRIER WEB LOCATED AT BS 663.75 AND BTW RBL 25 TO RBL 35 MAIN WHEEL WELL COMPARTMENT IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025112027488Floor Panel · pulledCABIN FLOOR PANEL 231XF HAS FIBERS PEELING ON UPPER SURFACE. REPLACED CABIN FLOOR PANEL 231XF WITH NEW FLOOR PANEL PER AMM 53-21-00.SDR SWAA2025112027688Seat Track · crackedFLOORBOARD SUPPORT STRUCTURE FOR PANEL 231UF LOCATED BETWEEN 0BL AND NR 3 SEAT TRACK IS CRACKED AT INBD ATTACH FASTENER . REMOVED FLOORBOARD SUPPORT STRUCTURE FOR PANEL 231UF LOCATED BETWEEN 0BL AND NR 3 SEAT TRACK PER SRM 51-40-02. INSTALLED NEW FLOORBOARD SSDR SWAA2025112027687Seat Track · crackedFLOORBOARD SUPPORT STRUCTURE FOR PANEL 231UF LOCATED BETWEEN BL 0 AND NR 2 SEAT TRACK IS CRACKED AT INBD ATTACH FASTENER . REMOVED FLOORBOARD SUPPORT STRUCTURE FOR PANEL 231UF LOCATED BETWEEN 0BL AND NR 2 SEAT TRACK PER SRM 51-40-02. INSTALLED NEW FLOORBOARDSDR SWAA2025112027218Attach Bracket · crackedSEAT TRACK NR 4 ATTACH BRACKET CRACKED ON BOTH INBD AND OTBD RADIUS'S AT BS 727B, UNDER FLOORBOARD 242DF. VERIFIED CRACKS IAW NDT MANUAL, PART 6, 51-00-00, PROC.23. REMOVED FASTENERS AND DISPLACED CRACKED GUSSET IAW SRM 51-40-02. REMOVED GUSSET, LOCATED, ASDR SWAA2025112027219Attach Bracket · crackedSEAT TRACK NR 1 ATTACH BRACKET CRACKED ON BOTH INBD & OTBD. RADIUS'S AT BS 727B UNDER FLOORBOARD 241FF. VERIFIED CRACKS PER 737 NDT MANUAL PART 6; 51-00-00 PROC.23. REMOVED CRACKED GUSSET PER SRM 51-40-02. LOCATED AND DRILLED NEW GUSSET PER SRM 51-40-02.SDR SWAA2025112027629Web · corrodedCORROSION WEB - INTERCOSTAL BTW BS 747 - 767, STR 25R, WL 156.4. REPLACED THE WEB - INTERCOSTAL IAW 51-40-02, AND DWG 146A7502, SHEET 50, REV-.SDR SWAA2025112027440Web · crackedCRACK ON WEB BTW BS 927 TO BS 947.5, STRINGER 25R. REPLACED THE WEB IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G, AND DWG 147A7500, SHEET 20, REV -.SDR SWAA2025112027447Support Angle · corrodedCORROSION ON SUPPORT ANGLE, BTW BS 767 - 792, RBL 21, WL 156.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 146A8123, SHEET 16, REV -.SDR SWAA2025112027446Web · corrodedCORROSION ON THE SHIELD WEB BS 767 - 792, RBL 21, WL 156.1. REPLACED THE SHIELD WEB IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, AND DWG 146A0081, SHEET 49, REV A.SDR SWAA2025112027178Fitting · deterioratedDETERIORATED GIRT BAR FITTINGS HARDWARE AND SHIMS ENTRY AND SERVICE DOOR. REPLACED GIRT BAR FITTINGS HARDWARE AND SHIMS ENTRY AND SERVICE DOOR AT AFT GALLEY AREA IAW AMM 25-66-02-400-801,SDR SWAA2025112027177Fitting · deterioratedDETERIORATED GIRT BAR FITTING HARDWARE AND SHIMS FWD ENTRY AND SERVICE DOOR. REPLACED GIRT BAR FITTING HARDWARE AND SHIMS. INSTALLATION WILL BE ACCOMPLISHED ON TTG8R008CEXW STEP 13.SDR SWAA2025112027438Angle · crackedCRACK ON ANGLE LOCATED BS 867, STRINGER 26L, WL 156.1. REPLACED THE ANGLE IAW SRM 51-10-02-0G, SRM 51-40-02-0G-0, AND DWG 149A8102, SHEET 19, REV A. MEASURE OF CRACK: 0.833 INCHES.