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 AALA202601143014Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: LEFT WING NR 3 SPOILER CENTER HINGE PINS FOUND TO BE DEFECTIVE AND WERE REPLACED IAW AMM 27-64-43.SDR SWAA2026011342430Intercostal · corrodedCORROSION ON INTERCOSTAL BTW BS 947 - 967, LBL 50, WL 208.1. REPLACED THE INTERCOSTAL IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 147A5650, SHEET 54, REV A.SDR SWAA2026011342674Nut Plate · corrodedCORROSION OTBD FRONT SPAR RAIL NUT PLATE OFSS 548 ON LT WING. REPLACED THE SPAR RAIL NUT PLATE OFSS 548, FASTENERS IAW SRM 51-40-02, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026011342675Nut Plate · corrodedCORROSION OTBD FRONT SPAR RAIL NUT PLATE OFSS 449 LT WING. REPLACED RAIL NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026011342673Nut Plate · corrodedCORROSION OTBD FRONT SPAR RAIL NUT PLATE OFSS 652 ON LT WING. REPLACED OTBD FRONT SPAR RAIL NUT PLATE IAW SRM 51-40-02, 51-10-02, ITEM 9, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026011342676Nut Plate · corrodedCORROSION OTBD FRONT SPAR RAIL NUT PLATE OFSS 421 ON LT WING. REPLACED THE RAIL NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 112A4402, SHEET 40, REV A.SDR SWAA2026011342677Nut Plate · corrodedCORROSION OTBD FRONT SPAR RAIL NUT PLATE OFSS 527 ON LT WING. REPLACED RAIL NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02 AND DWG: 112A4402, SHEET 40, REV A.SDR SWAA2026011242700Stringer · crackedCRACKED STRINGER 25L, BS 540. PERFORMED A PERMANENT REPAIR ON STRINGER 25L, BTWN BS 500D & 540 IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2026011242702Stringer · crackedCRACKED STRINGER 26L, BS 540. PERFORMED A PERMANENT REPAIR ON STRINGER 26L BTWN BS 500D & 540 IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2026011242703Stringer · crackedCRACKED STRINGER 25R, BS 540. PERFORMED PERMANENT REPAIR ON STRINGER 25R BTW BS 500C - 540 IAW SRM 53-00-03-2R-1, REPAIR 1.SDR SWAA2026011242705Support Bracket · crackedCRACKED SUPPORT BRACKET, BS 867 BTW S2 & 3R. REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02, AND DWG 146A7901, SHEET 66, REV A.SDR SWAA2026011242946Bracket · corrodedCORROSION GROUND PLATE LOCATED BTW HINGE 7A TO HINGE 8 AT VERTICAL STABILIZER. REPLACED BRACKET PLATE LOCATED BTW HINGE 7A TO HINGE 8 AT VERTICAL STAB IAW SRM 51-10-02 PARAGRAPH 9, SRM 51-40-02, AND DWG 175A1601, SHEET 18, REV A.SDR SWAA2026011242863Support Angle · crackedCRACK SUPPORT ANGLE AT BULKHEAD BS 663.75 AND LBL 10 CENTER SECTION. PERFORMED PERMANENT REPAIR ON ANGLE LOCATED AT BS 663 BTW LBL 6 TO LBL 25 IAW B737-800 SRM 57-10-10-2R-5.SDR SWAA2026011242864Support Angle · crackedCRACK SUPPORT ANGLE AT BULKHEAD BS 663.75 AND RBL 10 CENTER SECTION. PERFORMED PERMANENT REPAIR ON ANGLE LOCATED AT BS 663 BTW RBL 6 TO RBL 25 IAW SRM 57-10-10-2R-5.SDR SWAA2026010942699Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BS 500D - 520, S28R, FWD CARGO BAY. REPLACED INTERCOSTAL IAW SRM-51-10-02, ITEM 9, & DWG 143A7902, SHEET 126, REV A.SDR SWAA2026010942701Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BS 500D TO BS 520 AND S-28L FWD CARGO BAY. REPLACED WEB - INTERCOSTAL BS 500D - 520, S28L IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7902, SHEET 126, REV A.SDR SWAA2025123042648Seal · crackedLEFT WING OTBD AFT FLAP PLASTIC SEAL 2ND FROM O/B END CRACKED. R & R OTBD AFT FLAP IAW AMM 27-51-22.SDR SWAA2025123042649Seal · crackedRIGHT WING OTBD AFT FLAP PLASTIC SEAL 2ND FROM INBD END CRACKED. REMOVED AND REPLACED WITH SERVICEABLE RT WING OTBD AFT FLAP IAW AMM. 27-51-22.SDR SWAA2025122942887Stringer Clip · crackedCRACKED STRINGER CLIP IN PAX CABIN, BS 727A, S8L. REMOVED AND REPLACED THE STRINGER CLIP, BS 727A, S8L IAW SRM 51-40-02-0G-0, AND DWG 146A1101, SHEET 15, REV -.SDR SWAA2025122942892Stringer Clip · crackedCRACKED STRINGER CLIP IN PAX CABIN, BS 727B, S-7L. REMOVED AND REPLACED THE STRINGER CLIP BS 727B S7L IAW SRM 51-40-02-0G-0, AND DWG 146A1102, SHEET 15, REV -.SDR SWAA2025122942893Stringer Clip · crackedCRACKED STRINGER CLIP BS 727C S-7L. REMOVED AND REPLACED STRINGER CLIP 7L IAW SRM 51-40-02-0G-0 AND DWG 146A1103, SHEET 11, REV -.SDR SWAA2025122942894Stringer Clip · crackedCRACKED STRINGER CLIP BS 727C, S8L. REMOVED AND REPLACED THE STRINGER CLIP 8L IAW SRM 51-40-02-0G-0 AND DWG 146A1103, SHEET 11, REV -.SDR SWAA2025122942895Stringer Clip · crackedCRACKED STRINGER CLIP BS 727D, S6L. REMOVED AND REPLACED STRINGER CLIP 6L IAW SRM 51-40-02-0G-0 AND DWG 146A1111, SHEET 11, REV -.SDR SWAA2025122942478Former · crackedWING TO BODY FAIRING FORMER IS CRACKED BS 500D BETWEEN STRINGERS 19 & 20R. REMOVED AND REPLACED FAIRING FORMER ON WING BODY BS 500D BETWEEN S19 AND S20R IAW SRM 51-40-02; 51-40-05 AND DWG 116A3010 REV A.SDR SWAA2025122942687Skin · crackedCRACK NOTED ON LT HORIZONTAL STABILIZER LWR SKIN AT HSS 193.90; 17.5' FROM FWD EDGE; L: 0.6'. REPAIRED LT LOWER HORIZONTAL STAB SKIN IAW SRM 55-10-01-2R-11, REPAIR 11, TABLE 201, TABLE 202, FIG. 204, DETAIL B, AND SRM 51-40-02-0G-0.SDR AALA202512249104Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: LEFT WING #4 SPOILER ATTACH FITTING CENTER HINGE PINS FOUND TO BE DEFECTIVE. REPLACED HINGE PINS PER AMM 27-64-44.SDR AALA202512242211Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: LEFT WING #2 SPOILER ATTACH FITTING CENTER HINGE PINS FOUND TO BE DEFECTIVE. REPLACED HINGE PINS PER AMM 27-64-44.SDR SWAA2025122348650Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 661AB, RT WING T/E. REPAIRED ACCESS PANEL 661AB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025122348651Access Panel · damagedELONGATED HOLE ACCESS PANEL 661BB, RT WING. REPAIRED THE ACCESS PANEL 661BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025122348654Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 661CB RT WING T/E. REPAIRED THE ACCESS PANEL 661CB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025122342975Angle · crackedCRACK ON ANGLE LOCATED AL LEVEL ORSS 271 DEFLECTION CONTROL RIB AREA AT LT WING. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, AND DWG 115A2930, SHEET 7, REV -.SDR SWAA2025122342976Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL ORSS 271 DEFLECTION CONTROL RIB AREA AT RT WING. REPLACED THE ANGLE IAW SRM 51-40-02, AND SRM 51-10-02, ITEM 9.SDR SWAA2025122342977Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL ORSS 272 DEFLECTION CONTROL RIB AREA RT WING T/E. REPLACED THE ANGLE IAW SRM 51-40-02, AND SRM 51-10-02, ITEM 9.SDR SWAA2025122342980Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL ORSS 272 DEFLECTION CONTROL RIB AREA LT WING T/E. REPLACED THE ANGLE IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9.SDR SWI2025F01868Flap Track · wornRIGHT WING FLAP TRACK 1A HAS THICKNESS REDUCTION WEAR OF .87MM MAX ALONG FWD SIDE. REMOVED AND REPLACED RT WING FLAP TRACK 1A IAW AMM 57-54-25.SDR SWIA2025122300004Flap Track · wornLEFT WING FLAP TRACK 1A HAS THICKNESS REDUCTION WEAR OF .25MM MAX ALONG FWD SIDE. REMOVED AND REPLACED LH WING FLAP TRACK 1A REF AMM 57-54-25.SDR SWAA2025122342979Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 661AB TRAILING EDGE ON RT WING.SDR SWAA2025122342981Access Panel · damagedELONGATED HOLE ACCESS PANEL 661BB ON RT WING.SDR SWAA2025122342989Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 661CB TRAILING EDGE ON RT WING.SDR SWAA2025122342970Support Angle · crackedCRACKED SUPPORT ANGLE, LOCATED BS 807, RBL 21, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02, AND DWG 146A0081, SHEET 25, REV A.SDR SWIA2025122204Frame · corrodedFRAME 88 HAS CORROSION ON FWD FACE AT STGR 27R-28R. (C-CHECK RO 12/19/2025)REMOVED AND REPLACED FR 88 LWR SECTION AT STGR 26R-26L REF EMB 175 SRM 51-40-08.THIS REPAIR DOESN'T EFFECT THE WEIGHT AND BALANCE. NO FURTHER ACTION REQUIRED.SDR AALA202512224013Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: RIGHT WING #2 SPOILER ATTACH FITTING CENTER HINGE PIN FOUND TO BE DEFECTIVE AND REPLACED IT PER AMM 27-64-42.SDR AALA202512226275Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: RIGHT WING #4 SPOILER ATTACH FITTING CENTER HINGE PIN FOUND TO BE DEFECTIVE AND REPLACED IT PER AMM 27-64-42.SDR AALA202512223746Hinge Pin · defectiveAIRCRAFT IN BASE MAINTENANCE: RIGHT WING #3 SPOILER ATTACH FITTING CENTER HINGE PIN FOUND TO BE DEFECTIVE AND REPLACED IT PER AMM 27-64-42.SDR AALA202512227945Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SIILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR SWAA2025121948046Scuff Plate · crackedCRACK ON CENTER SCUFF PLATE IN THE FWD CARGO CUT OUT. REPAIRED THE CENTER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1.SDR SWAA2025121842917Seat Track · crackedCAPTAIN'S FWD INBD SEAT TRACK FOUND CRACKED. REMOVED AND REPLACED THE SEAT TRACK IAW AMM 25-11-11-400-801.SDR SWAA2025121842919Scuff Plate · crackedWORN AND CRACKED CENTER SCUFF PLATE IN THE FWD CARGO DOOR CUT OUT.SDR SWAA2025121742709Battery Pack · inoperativeRH OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED ONE BATTERY PACK M1695 AND OPS CHECK GOOD IAW AMM 33-51-06-960-805..SDR AALA202512173584Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL AT FR 67 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001.