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 AALA202508291014Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER IN SPAR RIB, AT FIRST STIFFENER AFT OF FORWARD SPAR, LOCATED AT STABILIZER STA 129.50. ACCOMPLISHED REINFORCEMENT REPAIR PER EA 366674 AND SRM 55-10-09-2R-4.SDR SWAA2025082794285Web · crackedCRACK ON WEB LOCATED BTW BS 277 TO BS 294.5 RBL 1 WL 208.1. REPLACED WEB IAW SRM 51-40-02-0G, AND DWG 141A5400, SHEET 20, REV-.SDR SWAA2025082794282Structure · crackedCRACK INNER CHORD LOCATED BS 303.9 AT LEVEL STR 17L. REPLACED INNER CHORD LOCATED BTW BS 270 TO BS 360 AT LEVEL STR 17L IAW SRM 51-10-02, DWG 141A8110, SHEET 9, REV A, AND DWG 140A9810 SHEET 53, REV-.SDR SWAA2025082794278Intercostal · crackedCRACK ON INTERCOSTAL LOCATED BTW BS 344 TO BS 360 LBL 11 WL 208.1. REPLACED INTERCOSTAL WEB AND FASTENERS IAW SRM 51-40-02 ; SRM 51-10-02 Ï¿½TEM 9 AND DWG 141A5400 SHEET 46 REV:A.SDR SWAA2025082794281Shield · corrodedCORROSION SHIELD WEB ON FLOOR STRUCTURE LOCATED BETWEEN BS 492.4 TO 500A, RBL 22, WL 156 AT FWD CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS ON FLOOR STRUCTURE LOCATED BETWEEN BS 492.4 - 500A, RBL 22, WL 156, IAW SRM 51-40-02-0G-0 PARAGRAPH 9 & DWG SDR SWAA2025082794002Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500H TO 500I RBL 22 WL 156.1 AT FWD CARGO COMPARTMENT. FAULT RESOLVED ON OTHER FAULT SEE TTG8Q0145EUZ.SDR SWAA2025082794003Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500C TO 500E RBL 22 WL 156.1 AT FWD CARGO COMPARTMENT THE DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 (REPAIR 5), AND EA M-22-153-01550'.SDR SWAA2025082794005Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN STA500B TO STA500C AND LBL22 WL156 AT FWD CARGO COMPARTMENT. FAULT RESOLVED ON OTHER FAULT SEE TTG8Q0145EW0.SDR SWAA2025082794273Floorbeam · corrodedCORROSION ANGLE ON FLOOR STRUCTURE LOCATED STA500I AND BETWEEN LBL21 TO RBL21 WL156 AT FWD CARGO COMPARTMENT. REPLACED ANGLE FLOOR STRUCTURE LOCATED STA500I AND BETWEEN LBL21 TO RBL21 WL156 AT FWD CARGO COMPARTMENT IAW SRM 51-40-02-0G, AND DWG 143A9481, SHEETSDR SWAA2025082794294Battery Pack · inoperativeDOES NOT WORK CORRECTLY BATTERY PACK LOCATED ON SIDEWALL AREA BETWEEN STA 559 AND 579 1 EA RH SIDE IN PASSENGER CABIN. REPLACED BATTERY PACK IAW 33-51-06-960-805, PERFORMED OPERATIONAL TEST, TESTED OK.SDR SWAA2025082794293Battery Pack · inoperativeDOES NOT WORK CORRECTLY BATTERY PACK LOCATED ON SIDEWALL AREA BETWEEN BS 559 AND 579 1EA ; BETWEEN 727 C AND 727 D 1EA LT SIDE IN PASSENGER CABIN. REPLACED BATTERY PACK IAW 33-51-06-960-805 PERFORMED OPERATIONAL TEST, TESTED OK.SDR SWAA2025082794284Light · deterioratedDETERIORATED PHOTOLUMINESCENT STRIP ALONG PAX CABIN . REPLACED PHOTOLUMINESCENT STRIP ALONG PAX CABIN IAW DWG 417A5775-302 REV C.SDR SWAA2025082794275Support · corrodedCORROSION SUPPORT ZEE LOCATED BETWEEN STA500D TO STA500F AND LBL22 WL156 AT FWD CARGO COMPARTMENT. THE DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 (REPAIR 5) AND EA M-22-153-01550.SDR SWAA2025082794271Angle · crackedCRACK ON CLIP- ANGLE LOCATED AFT FACE BS 500H AT LEVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED CLIP- ANGLE LOCATED AFT FACE BS 500H AT LEVEL STR 26R AT FWD CARGO COMPARTMENT AND FASTENERS. IAW SRM 51-40-02-0G-0, AND DWG 143A7505 SHEET 123, REV-.SDR SWAA2025082794283Tie Clip · crackedCRACK TIE CLIP LOCATED BILGE AREA STA500I AND STR26R AT FWD CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED BILGE AREA STA500I AND STR26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02, PARAGRAPH 9, AND DWG 143A1234, SHEET 14, REV A.SDR SWAA2025082693633Plate · crackedLEFT WING REAR SPAR, WAFFLE PLATE INBD OF NR 3 FLAP TRACK WAS CRACKED AT FASTNERS. REMOVED AND REPLACED LT WING REAR SPAR WAFFLE PLATE IAW SRM 51-40-02.SDR SIMA20250722008Shear Tie · corrodedSSI 53-23-003 SHEAR CLIP IS CORRODED AT FR89 AND BTW STR 25L-26L. (LEVEL 2 CORROSION) REMOVED AND REPLACED SHEAR CLIP AT FR89 BTW STR 25L-26L IAW ERJ 170 SRM 51-40-08SDR SIMA20250722004Doubler · corrodedSSI 53-21-009 FLOOR STRUCTURE FOR FWD CARGO DOOR CUTOUT AT FR27 IS CORRODED. (MAJOR REPAIR) (LEVEL 2 CORROSION) REMOVED CORRODED AND INSTALLED FLOOR STRUCTURE FOR FWD CARGO DOOR CUTOUT IN AREA OF FR27 IAW ERJ 170 SRM 51-40-08..SDR SIMA20250722006Shear Tie · corrodedSSI 53-10-016: SHEAR CLIP AT FR17, STR27L-STR28L IS CORRODED. (LEVEL 2 CORROSION) REMOVED AND INSTALLED SERVICEABLE SHEAR CLIP AT FR17, STR27L-STR28L IAW ERJ 170 SRM 51-40-08SDR SIMA20250722007Shear Tie · corrodedSSI 53-10-016 SHEAR CLIP AT FR 17 STR 26R-27R IS CORRODED. (LEVEL 2 CORROSION) REMOVED AND INSTALLED SERVICEABLE SHEAR CLIP AT FR17, STR26R-STR27R IAW ERJ 170 SRM 51-40-08SDR SIMA20250722005Doubler · corrodedSSI 53-21-009 FWD CARGO DOOR CUTOUT LWR TRIM ATTACHMENT BRACKETS ARE CORRODED. (LEVEL 2 CORROSION) REMOVED AND REPLACED 5EA BRACKETS ON FWD CARGO DOOR CUTOUT LWR TRIM ATTACHMENT IAW ERJ 170 SRM 51-40-08.SDR AALA202508253191Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508255964Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED AT BS 312, RBL 31. REPLACED INTERCOSTAL PER AARD 51.00-05-1.SDR SWAA2025082294205Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801. TESTED OK.SDR SWAA2025082206939Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801<BR>TESTED OK.SDR SWAA2025082294201Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801. TESTED OK.SDR SWAA2025082206940Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT FWD GALLEY AREA IAW AMM 25-66-02-000-801 AND AMM 25-66-02-400-801. TESTED OK.SDR SWAA2025082294202Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT AFT GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT AFT GALLEY AREA IAW AMM 25-66-02-400-801. TESTED OK.SDR SWAA2025082206941Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT AFT GALLEY AREA. REPLACED GIRT BAR HARDWARE AND PLATE SERVICE DOOR AT AFT GALLEY AREA IAW AMM 25-66-02-400-801. TESTED OK.SDR SWAA2025082294203Girt Bar · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT AFT GALLEY ARE A 2025-448212<[01] REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT AFT GALLEY AREA IAW B737-700 AMM 25-66-02-400-801.<BR>TEST IS OK.;[02] JOB COMPLETEDSDR SWAA2025082206942Plate · deterioratedDETERIORATED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT AFT GALLEY ARE A 2025-448212<[01] REPLACED GIRT BAR HARDWARE AND PLATE ENTRY DOOR AT AFT GALLEY AREA IAW B737-700 AMM 25-66-02-400-801.<BR>TEST IS OK.;[02] JOB COMPLETEDSDR SWAA2025082293965Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE CRACKED ON INBOARD SIDE OF FLEX JOINT @ RBL 9 AND SUSPECTED CRACK AT RBL 34<[01] ACCOMPLISHED HFEC SURFACE INSPECTION OF RBL 34' VERIFIED AREA IS CRACKED. PER NDT PART 6 51-00-00 PROC. 23;[02] REMOVED RIVETS @ R/H 663 ATTACH ASDR REXA2025082000824Bushing · damagedFOUND RT WING AILERON LUGS LABELED E & F TO BE PREVIOUSLY OVERSIZED. COMPLIED WITH STEPS NR 1, 4, 5, & 7 OF REO 690-57-51-456 REV. FABRICATED O/S RT AILERON BUSHING. HFEC PERFORMED IAW REO 690-57-51-456 REV -, NO INDICATIONS NOTED. C/W STEP 2 OF REO 690-5SDR SWAA2025081993998Attach Angle · crackedCRACK FOUND BS 663 VAPOR BARRIER ATTACH ANGLE AT APPROXIMATELY LBL 9. REMOVED DAMAGED SECTION OF VAPOR BARRIER ATTACH ANGLE IAW SRM 57-10-10-2R-5. ACCOMPLISHED HFEC HOLE PROBE OF FASTENER HOLES COMMON TO FUEL TANK AND HFEC SURFACE INSP OF ATTACH ANGLE CUT LISDR SWAA2025081993999Attach Angle · crackedCRACK FOUND BS 663 VAPOR BARRIER ATTACH ANGLE AT APPROX RBL 9. REMOVED DAMAGED SECTION OF ATTACH ANGLE IAW SRM 57-10-10-2R-5. ACCOMPLISHED HFEC HOLE PROBE OF FASTENER HOLES COMMON TO FUEL TANK & HFEC SURFACE INSP OF ATTACH ANGLE CUT LINE. NO DEFECTS NOTED IASDR SWAA2025081994261Attach Angle · crackedCRACK ON FCB BAFFLE ASSEMBLY ATTACH ANGLE AT BS500C RBL26 WL156. REMOVED AND REPLACED FCB BAFFLE ASSEMBLY ATTACH ANGLE AT BS500C RBL26 WL156 IAW SRM 51-40-02-0G-0.AND DWG 143A7505.SDR REXA2025081900823Lug · damaged"FOUND R/H AILERON SIDE BEARING LUGS LABELED ""D"" AND ""E"" TO BE PREVIOUSLY OVERSIZED. COMPLIED WITH MHIRJ REO 690-57-61-412 REV -- DATED 2025-08-15."SDR SWAA2025081594246Floorbeam · crackedCRACKED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; LBL 2; WL 208; REMOVED AND REPLACED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; LBL 2; WL 208 IAW SRM 51-40-02-0G-0 AND DWG 143A5240.;[02] CORRECTIVE ACTION COMPLETED.SDR SWAA2025081594247Floorbeam · crackedCRACKED PANEL BREAK AT PASSENGER COMPARTMENT BS 540; RBL 2; WL 208; REMOVED AND REPLACED NEW PANEL BREAK AT PASSENGER COMPARTMENT BS 540; RBL 2; WL 208 I.A.W SRM 51-40-02-0G-0 AND DWG 143A5240.;[02] VERIFIED CORRECTIVE ACTION 1 AND MEASUREMENT TABLE.SDR SWAA2025081594249Floorbeam · crackedCRACKED FLOOR BEAM ATTACH ANGLE AT PASSENGER COMPARTMENT BS 695; LBL 1; WL 208; REMOVED AND REPLACED ANGLE AT BS 695 LBL 1; WL 208 IAW SRM 51-40-02 AND DWG 273A9110 ID:005 REV: A.SDR SWAA2025081595592Intercostal · crackedINTERCOSTAL FROM BS294.5-BS303.9 STR 16L WL216 IS CRACED. REMOVED AND REPLACED INTERCOSTAL FROM BS 294.5 TO BS 303.9 STR 16L IAW SRM 51-40-02 AND DWG 141A8180 ID: 0027 REV:C.SDR 3EJA202508150006Lever · out of adjustABORTED TAKE OFF DUE TO A NO TAKE OFF LIGHT, VERIFY FLAP HANDLE IN THE TAKE OFF POSITION AND TRIM, AND NO TAKE OFF LIGHT CAME ON ON TAKE OFF ROLL, ADJUSTED FLAP POSITION INDICATOR POINTER LEVER.SDR SWAA2025081494257Strap · corrodedCORROSION ON STRAP ACB STA-847 RBL-19 FLOOR AREA. REMOVED AND REPLACED STRAP ON ACB BS847 RBL19 IAW SRM 51-40-02 AND DWG 146A8340 REV -.SDR SWAA2025081494258Sidewall Support · corrodedCORROSION ON ACB RH FLOOR TO SIDEWALL SUPPORT, RBL 21, BS 727A TO 767. REMOVED AND REPLACED ACB RH FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 146A7500.SDR SWAA2025081494259Sidewall Support · corrodedCORROSION ON ACB LH FLOOR TO SIDEWALL SUPPORT, LBL 21, BS 727A TO 847. REMOVED AND REPLACED ACB LT FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 146A7500.SDR SWAA2025081494268Sidewall Support · corrodedMULTIPLE SPOTS WITH CORROSION ON FCB SIDEWALL TO FLOOR SUPPORT NUTPLATE HOLES AT BS 460+2 TO 500B+2, LBL 22, WL156. REMOVED AND REPLACED FCB AT FLOOR SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0, AND DWG 143A7500, REV-.SDR SWAA2025081494806Shield · corrodedCORROSION ON FCB AFT SHIELD FROM BS492 TO 500+7, RBL 22, WL156. REMOVED AND REPLACED FCB AFT SHIELD IAW SRM 51-40-02, AND DWG 143A0080, REV-.SDR SWAA2025081494262Angle · crackedCRACK ON ANGLE ACB STA-867 LBL-13'' FLOOR AREA. REMOVED AND REPLACED ANGLE ACB STA 867 LBL 13<BR>IAW SRM 51-40-02-0G-0; IAW SRM 51-40-05 AND DWG#149A8102 REV:-.SDR SWAA2025081494263Support Fitting · crackedCRACK ON ACB WATER TANK SUPPORT FITTING STA-947 LBL-10''. REMOVED AND REPLACED SUPPORT FITTING STA-947 LBL-10 IAW SRM 51-40-02 AND DWG 149A8103 ID:0007 REV: A.SDR SWAA2025081494267Attach Angle · crackedCRACK ON FCB BAFFLE ASSEMBLY ATTACH ANGLE AT BS400 LBL26 WL156. REMOVED AND REPLACED ATTACH ANGLE AT FCB BS400 LBL26 WL156 IAW SRM 51-40-02 AND DWG 143A7505 ID:0002 REV: B.