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 SWAA2025122235365Support Angle · crackedCRACKED SUPPORT ANGLE BTW BS 291.5 - 294.5, S17R IN THE FWD GALLEY AREA. REPLACED THE ANGLE SUPPORT AND FASTENERS IAW SRM 51-40-02, SRM 51-20-01, ITEM 9, AND DWG 141A8310, SHEET 25, REV -.SDR SWAA2025122235362Support Angle · corrodedCORROSION ON SUPPORT ANGLE BTW BS 294.5 - 328, RBL 55, WL 208.1 IN THE FWD GALLEY AREA. REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02 ITEM 9, AND DWG 141A8310, SHEET 23, REV-.SDR SWAA2025122235275Web · crackedCRACKED WEB, BTW BS 312 - 328, RBL 31, WL 208.1 IN FWD GALLEY AREA. REPLACED THE WEB IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DWG 141A5400, SHEET 39, REV-. SSDR AALA202512229783Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN SEAT TRACK AT FR 61 AND -Y1292. REPAIRED SEAT TRACK PER EO 370189.SDR AALA202512227677Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN SEAT TRACK AT FR 62 AND +Y1292. REPAIRED SEAT TRACK PER EA 370189.SDR SWAA2025121935276Intercostal · crackedCRACK ON WEB INTERCOSTAL, BTW BS 344 - 360, RBL 33, WL 208.1. REPLACED WEB INTERCOSTAL BTW BS 344 - 360, RBL 33, WL 208.1 IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, & DWG 141A5400, SHEET 33, REV-.SDR SWAA2025121935277Web · crackedCRACKED WEB LOCATED BTW BS 328 - 344, LBL 47.5, WL 208.1 IN THE FWD GALLEY AREA. REPLACED THE WEB IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DWG 141A5400, SHEET 44, REV-.SDR SWAA2025121935279Angle · crackedCRACK ANGLE, BS 663.75, RBL 13 IN THE AIR CONDITIONING BAY. REPLACED ANGLE LOCATED BS 663.75, BETWEEN RBL 5 & RBL 65 IAW SRM 51-10-02 Ï¿½TEM 9; SRM 51-40-02, AND DWG 111A1000, SHEET 259, REV A.SDR SWAA2025121935333Tie Clip · crackedCRACK ON TIE CLIP LOCATED BS 277 AT LEVEL STR 10R AT FWD GALLEY AREA. REPLACED THE TIE CLIP IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, DWG 141A1110, SHEET 17, REV -, AND DWG 141A8380, SHEET 20, REV -.SDR SWAA2025121935354Access Panel · delaminatedDELAMINATED ACCESS PANEL 193AR AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 193AR AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-2, REPAIR 2.SDR SWAA2025121935047Floorbeam · crackedAAI INSPECTION: CRACKED FLOORBEAM LOCATED IN FLOOR STRUCTURE BS 540 BETWEEN BL 0 - RBL 24.75. REPLACED THE FLOORBEAM IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A0060, SHEET 51, REV-.SDR SWAA2025121935274Web · crackedCRACK ON WEB LOCATED BTW BS 277 - 294 .5, RBL 1, WL 208.1 IN THE FWD GALLEY AREA. REPLACED WEB IAW SRM 51-40-02, DWG 141A5400, SHEET 20, REV -.SDR SWAA2025121947449Web · crackedCRACK ON WEB LOCATED BTW BS 312 - 328, RBL 31, WL 208.1 AT FWD GALLEY AREA. REPLACED WEB IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DWG 141A5400, SHEET 39, REV-.SDR SWAA2025121947454Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 986.5, RBL 44, WL 208.1 AT AFT GALLEY AREA (3 POINTS). PERFORMED REPAIR ON THE FLOORBEAM IAW EA 25-153-03179-WIP1, EA 25-153-03179-WIP2, EA 25-153-03179-WIP3, AND EA 25-153-03179.SDR SWAA2025121935266Plate · corrodedCORROSION ON PLATE LOCATED BS 1016 PLUS 14 INCHES RBL 3 WL 208.1 AT AFT GALLEY AREA. REPLACED PLATE (STRAP) LOCATED BETWEEN BS 1006 TO BS 1030 RBL 3 WL 208.1 AT AFT GALLEY AREA IAW SRM 51-10-02-0G-0 PARAGRAPH 9; SRM 51-40-02-0G-0 AND DWG 147A5600 SHEET: 46 RESDR SWAA2025121835009Shield · corrodedCORROSION ON AFT CARGO DOOR CUTOUT AFT SHIELD AT BS 847+5 - 847+14, WL 163, RBL 21. REMOVED AND INSTALLED THE SHIELD BS 847 - 867 IAW SRM 51-40-02, AND DWG 146A0081 REV A.SDR SWAA2025121834991Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT AT BS 480+16 - 480+18, WL 156, RBL 24. TASK CARD COMPLETED ON CUSTOMER CARD TTG8Q018V3LA.SDR SWAA2025121847461Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB AT RT WING. REPAIRED ACCESS PANEL 661AB AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121835360Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661CB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661CB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121835361Access Panel · elongatedELONGATED HOLES ACCESS PANEL 661BB AT RT WING. REPAIRED ACCESS PANEL 661BB AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10 .SDR SWAA2025121835359Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661AB AT RT WING. REPAIRED ACCESS PANEL 661AB AT RT WING IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121734988Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 500A - 500B, WL 156, RBL 24. REMOVED AND REPLACED THE FWD CARGO FLOOR TO SIDEWALL SUPPORT BTWN BS 500A - 500D IAW SRM 51-40-02-0G-0, AND DWG 143A7500, REV -.SDR SWAA2025121734989Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 400+6, 400+10, 400+15, & 400+19, WL 156, RBL 24. REMOVED AND REPLACED THE SIDEWALL SUPPORT BTWN BS 400 - 420, RBL 24, WL 156 IAW SRM 51-40-02-0G-0, AND DWG 143A7500, REV -.SDR SWAA2025121734990Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 420+3, & 420+6, WL 156, RBL 24. REMOVED AND REPLACED SIDEWALL SUPPORT BTWN BS 420 - 440, RBL 24, WL 156 IAW SRM 51-40-02-0G-0, & DWG 143A0080, REV-.SDR SWAA2025121734992Shield · corrodedCORROSION ON FWD CARGO BAY SHIELD BS 500+11, 500+15, WL156, RBL 24. REMOVED AND REPLACED THE AFT SHIELD BTWN BS 500 - 500A, RBL 24, WL 156 IAW SRM 51-40-02-0G-0, & DWG 143A0080 REV -.SDR SWAA2025121734993Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 500+9, 500+14, 500+18, WL 156, LBL 24. SIDEWALL SUPPORT REPLACED BS 400 - 500D, WL 156, LBL 24 ON FAULT TTG8Q018V2JX.SDR SWAA2025121734994Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 500A+2, 500A+7, 500A+10, 500A+12, 500A+14, WL 156, LBL 24. THE SIDEWALL SUPPORT REPLACED BETWEEN BS 400 - 500D, WL 156, LBL 24 ON FAULT TTG8Q018V2JX.SDR SWAA2025121734996Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 420+9, WL 156, LBL 24. THE SIDEWALL SUPPORT BETWENN BS 400 - 500D. REPLACED ON FAULT TTG8Q018V2JX.SDR SWAA2025121734998Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 460+6, 460+10, 460+14, 460+18, WL 156, LBL 24. SIDEWALL SUPPORT REPLACED ON FAULT TTG8Q018V2JX.SDR SWAA2025121734999Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 480+6, WL 156, LBL 24. THE SIDEWALL SUPPORT REPLACED ON FAULT TTG8Q018V2JX.SDR SWAA2025121735000Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 500B+2, 500B+2.5, 500B+7, 500B+18, WL 156, LBL 24. SIDEWALL SUPPORT REPLACED ON FAULT TTG8Q018V2JX.SDR SWAA2025121735001Sidewall Support · corrodedCORROSION ON FWD CARGO FLOOR TO SIDEWALL SUPPORT, BS 500C+7, 500C+10, 500C+13, 500C+14, WL 156, LBL 24. THE SIDEWALL SUPPORT REPLACED ON FAULT TTG8Q018V2JX.SDR SWAA2025121735003Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT, BS 727+4 - 767, WL 156, RBL 21. REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 146A7500, REV A.SDR SWAA2025121735006Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT, BS 867+17, 887+9, 887+12, 887+20, 907+10, 907+14, WL 169, RBL 21. REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02, DWG 147A7500, REV -.SDR SWAA2025121735007Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT, BS 727B+9, 727B+19, 727C, 727D, 727D+4, 727D+6, 727D+9, 727D+11, WL 156, LBL 21. ] REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 146A7500, REV-.SDR SWAA2025121735008Sidewall Support · corrodedCORROSION ON AFT CARGO FLOOR TO SIDEWALL SUPPORT AT BS 727E+11, 747+10, 767, 767+3, 767+6, 767+15, 767+18, 787+12, WL 156, LBL 21. REPLACED ON CUSTOMER CARD TTG8Q018V88U.SDR SWAA2025121735005Shield · corrodedCORROSION ON AFT CARGO DOOR CUTOUT FWD SHIELD AT BS 767 - 787, WL 156, RBL 21. R & R THE SHIELD IAW SRM 51-40-02-0G-0, AND DWG 146A0081, REV A.SDR SWAA2025121735011Support · corrodedCORROSION ON AFT CARGO AFT BULKHEAD SUPPORT, BS 947.5, WL 179, RBL 1, RBL 12, LBL 3, & LBL 5. R & R THE SUPPORT IAW SRM 51-40-02-0G-0, & DWG 147A7500, REV C.SDR AALA202512173993Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR SEAT TRACK AT FR 21 AND -Y1292. REPLACED SEAT TRACK PER SRM 51-72-11,SDR SWAA2025121135222Fastener · crackedRIGHT INLET COWL OUTER LIP SKIN FASTENER AT 6 O'CLOCK, HEAD CRACKED. REMOVED AND OVERSIZED TO 1ST OVER RT INLET COWL OUTER LIP SKIN FASTENER AT 6 O'CLOCK POSITION IAW SRM 54-10-01-1A-2. PERFORMED NDT OF FASTENER HOLE PER NDT MANUAL PART6 51-00-00 PROCEDURESDR SIMA20251114001Seat Track · corrodedSSI 53-23-005-0001CORROSION ON LH AFT SEAT TRACK AT FR 84, Y= -10.748. (MAJOR REPAIR)) (LEVEL 2 CORROSION). BLENDED CORROSION FROM AFT R/H SEAT TRACK PER EMB-175 SRM 51-10-03. CORROSION WAS NOTED ON THE CROWN TEETH SECTION AND THE UPPER FLANGE, BOTH SECTIONS WSDR ASAA2025111462748Bracket · corrodedAFT CARGO DOOR CUTOUT, FORWARD LOWER MAIN SILL, BRACKET ASSY HAS CORRODED IN RIGHT SIDE BS 787 - 794.37, S25R. GROUNDED - YES. EVALUATED AFT CARGO FWD LOWER MAIN SILL BRACKET ASSY. FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS GIVEN. REMOVED FWD LOWER MAIN SILL SDR SWIA2025120300114Seat Track · corrodedFORWARD CABIN FLOOR STRUCTURE TRACK, LT UPPER SURFACE HAS CORROSION BETWEEN FR 19 AND 20. REPAIRED FORWARD CABIN FLOOR STRUCTURE TRACK, LT UPPER SURFACE IAW ETD2025-170-932399.SDR CALA2025120311717Web · crackedLWW UPPER VERT PRESSURE WEB CRACKED LBL 47 STA 663. REMOVED DAMAGED WEB AND INSTALLED NEW VERTICAL PRESSURE WEB AT STA 66 FROM LBL-47 TO LBL-60 REF B737-800 SRM 51-40-02-0G-0 AND DWG 111A1000.SDR ASAA2025111462728Transition Panel · corrodedAFT CARGO COMPARTMENT LT LOWER TRANSITION FROM BS 727E+10 TO 807 HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. REMOVED & EVALUATED DAMAGE FROM AFT PIT LT TRANSITION PANEL FROM BS 727E+10 TO 807 IAW SRM 53-00-53-1A-2. 100% MAT LOSS AND FOUND TO BE OUT OF LIMSDR ASAA2025111462727Transition Panel · corrodedAFT CARGO COMPARTMENT RT LOWER TRANSITION FROM BS 727C+10 TO 767 HAS MULTIPLE AREAS OF CORROSION. GROUNDED - YES. REMOVED AND EVALUATED DAMAGE FROM AFT PIT R/H TRANSITION PANEL FROM BS 727C+10 TO BS 767 IAW SRM 53-00-53-1A-2. 100% MAT LOSS AND FOUND TO BE OUT SDR AALA202512028481Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING AT FR 66 AND S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR AALA202511253993Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR SEAT TRACK AT FR 21 AND -Y1292. REPLACED SEAT TRACK PER SRM 51-72-11,SDR AALA202511257117Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #2 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202511254559Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ON ELEVATOR HINGE ARM END FITTING NO 3 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE-ARM END-FITTING #3 ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.