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 SWIA2026032775577Stringer · crackedSTRINGER 3L IS CRACKED AT AFT SIDE OF BS 280. PERFORMED A MAJOR REPAIR BY REMOVING AND REPLACING 2 EA 3L SPLICE ANGLES AT AFT SIDE OF FS 280 IAW SRM 51-42-06 AND 51-40-11 REV.399. MAJOR REPAIR.SDR IPXA2026022662670Cylinder · failedDURING OPERATIONAL CHECK OF CREW DOOR ESCAPE SLIDE, EMERGENCY CYLINDER DOOR ASSIST. FAILED TO DEPLOY. IN REFERENCE TO STEP 11: VERIFIED INSTALLED DOOR DAMPER EMERGENCY CYLINDER ACTUATOR. PENDING A300-600 AMM 52-10-14/401.STEP 2(D)(Q): CHECK DOOR DAMPER SDR 3EJA20260318001Elec Connector · dirtyNOSE GEAR WOULD NOT RETRACT, COMPLIED WITH ABNORMAL PROCEDURES CHECKLIST. CLEANED NLG UP-LOCK CONNECTOR PLUG ON UP-LOCKSDR SWIA2026030975462Hinge · scratchedPAX DOOR HINGE, DOOR SIDE, HAS MINOR SCRATCHES ON ALL LUGS AND THE SPRING PIN HAS MIGRATED OUT, APPEARS BENT (MARKED) (C-CHECK RO 03/07/2026)REMOVED DAMAGE AND REPAIRED PASSENGER DOOR HINGE, DOOR SIDE, REF. CRJ-550, SRM 52-11-01-201-007-A01, TYPE 1.REVISION SDR SWIA2026090975440Floor Support · crackedRH FLOOR SUPPORT ANGLE AT RBL 9 BETWEEN FS 250.00 - FS 280.00 HAS CRACK TRANS 31561581 (C-CHECK RO 03/07/2026)INSTALLED NEW RH FLOOR SUPPORT ANGLE AT RBL9 BETWEEN FS 250.00 - FS 280.00 REF CRJ550 SRM 51-42-06-001-001-A01 AND DWG CC670-34010 REV -K. COMPLIED SDR VNAA20260303012Floor Support · crackedCRACKED FLOOR SUPPORT, RBL 12, BS 221.73 - 229. THE FLOOR SUPPORT WAS REPAIRED IAW REO 690-53-11-2129, REV-.SDR AALA202602279211Inlet · corrodedAIRCRAFT IN BASE MAINTENANCE: APU AIR INLET DOOR OUTER SKIN HAS AREAS OF CORROSION. REMOVED OLD APU AIR INLET ASSEMBLY AND INSTALLED SERVICEABLE APU AIR INLET DOOR ASSEMBLY. PER 49-15-22. OPS CHECKS GOODSDR AALA202602271647Inlet · corrodedAIRCRAFT IN BASE MAINTENANCE: APU AIR INLET DOOR ASSEMBLY HAS AREAS OF MISSING PAINT AND SURFACE CORROSION ON THE INSIDE OF THE DUCT. REMOVED OLD APU AIR INLET ASSEMBLY AND INSTALLED SERVICEABLE APU AIR INLET DOOR ASSEMBLY. PER 49-15-22 OPS CHECKS GOOD.SDR CALA2026021813895Warning Light · false activationAFTER TOUCHDOWN, MASTER CAUTION LIGHTS ILLUMINATED WITH NO CHIME OR ECAM DISPLAYED. ACCOMPLISHED AN OPS TEST OF MASTER CAUTION, WARNING LIGHT IAW AMM 31-50-00-710-011-A. NO FAULTS NOTED.SDR SWAA2026021862493Web · crackedCRACKED WEB, BS 328 - 344, LBL 46. PERFORMED GENERAL VISUAL INSPECTION ON THE WEB - INTERCOSTAL & NO DAMAGE FOUND IAW SRM 51-00-06-0G-0. REMOVED & RE INSTALLED THE WEB - INTERCOSTAL IAW SRM 51-40-02,& DWG 141A5400, SHEET 28, REV -.SDR SWAA2026021862491Web · crackedCRACKED WEB, BS 312 - 328, RBL 31. REPLACED THE WEB - INTERCOSTAL IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 141A5400, SHEET 39, REV -.SDR SWAA2026021862492Web · crackedCRACKED WEB, BS 277 - 294.5, BL 0. REPLACED THE WEB INTERCOSTAL & FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DWG 141A5400, SHEET 20, REV-.SDR SWAA2026021862648Frame · crackedCRACKED FRAME, BS 312, S5L - S6L. PERFORMED A REPAIR ON THE FRAME IAW EA M 22-153-01244.SDR SWAA2026021862655Nut Plate · corrodedCORRODED RAIL NUT PLATE, SS 604, LT WING. REPLACED THE NUT PLATE IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02, DWG 112A4402, SHEET 41, REV A, & PERFORMED A VISUAL INSPECTION OF AFFECTED AREA AND NO DAMAGE FOUND.SDR SWAA2026021862659Nut Plate · corrodedCORRODED RAIL NUT PLATE, SS527, LT WING. REPLACED THE NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02.SDR SWAA2026021862668Nut Plate · corrodedCORRODED RAIL NUT PLATE SS 706, LT WING LE. REPLACED THE RAIL NUT PLATE IAW SRM 51-40-02, AND DWG 112A4402, REV A, SHEET 41.SDR SWAA2026021862653Nut Plate · corrodedCORRODED RAIL NUT-PLATE, OFSS 290, LT WING LE. REPLACED THE RAIL NUT-PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 112A4402, SHEET 40, REV A.SDR SWAA2026021862665Nut Plate · corrodedCORRODED RAIL NUT PLATE LOCATED INTERNAL CAVITY LEADING EDGE OFSS 308, LT WING. REPLACED RAIL NUT PLATE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 112A4402, SHEET 40, REV A.SDR SWAA2026021862657Plate · corrodedCORRODED RAIL PLATE, INTERNAL CAVITY OFSS 549, LT WING LE. REPLACED RAIL PLATE IAW SRM 51-10-02, ITEM 9, & SRM 51-40-02.SDR SWAA2026021862494Web · crackedCRACKED WEB, BS 344 - 360, LBL 11 IN THE FWD GALLEY AND LAVATORY. REPLACED THE WEB INTERCOSTAL, & FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 141A5400, SHEET, 46, REV A.SDR SWAA2026021862660Plate · corrodedCORROSION RAIL PLATE ON INTERNAL CAVITY OFSS 426, LT WING LE. REPLACED RAIL PLATE IAW SRM 51-10-02, ITEM 9, & SRM 51-40-02.SDR SWAA2026021862663Tie Clip · crackedCRACKED TIE CLIP, BS 277, S10R IN THE PAX CABIN. REPLACED THE TIE CLIP IAW SRM 51-10-02-0G-0, ITEM 9, DWG 141A1110, SHEET 18, REV -, & DWG 141A8380, SHEET 33, REV -.SDR SWAA2026021862658Plate · corrodedCORROSION RAIL PLATE LOC ON INTERNAL CAVITY OFSS 540, LT WING LE. REPLACED THE RAIL PLATE IAW SRW 51-40-02, SRM 51-10-02-0G-0, ITEM 9, & DWG 112A4402, SHEET 40, REV A. PERFORMED VISUAL INSPECTION ON AFFECTED AREA AND NO FOUND DAMAGE.SDR SWAA2026021862661Plate · corrodedCORROSION RAIL PLATE ON INTERNAL CAVITY OFSS 421, LT WING LE. REPLACED THE RAIL PLATE IAW SRM 51-10-02, ITEM 9 DUE TO NO FOUND ALLOWABLE DAMAGE IAW SRM AND INSTALLED FASTENERS IAW SRM 51-40-02.SDR SWAA2026021862662Plate · corrodedCORROSION RAIL PLATE ON INTERNAL CAVITY OFSS 409, LT WING LE. REPLACED RAIL PLATE IAW SRM 51-40-02, & SRM 51-10-02, ITEM 9.SDR SWAA2026021862656Plate · corrodedCORROSION RAIL PLATE, ON INTERNAL CAVITY LEADING EDGE OFSS 573, LT WING. REPLACED THE RAIL PLATE IAW SRM 51-10-02, ITEM 9, & SRM 51-40-02.SDR SWAA2026021862667Nut Plate · corrodedCORROSION RAIL NUT PLATE LOCATED ON INTERNAL CAVITY LEADING EDGE OFSS334 AT LT WING. REPLACED RAIL PLATE LOC INTERNAL CAVITY LEADING EDGE OFSS334 AT LT WING IAW SRM 51-10-02, ITEM 9, DUE TO NOT FOUND ALLOWABLE DAMAGE ON SRM AND INSTALLED FASTENERS IAW SRM 51-SDR SWAA2026021762512Scuff Plate · crackedCRACK ON FWD CORNER SCUFF PLATE AT FWD CARGO BAY DOOR CUT OUT. REPAIRED THE FWD CORNER SCUFF PLATE IAW SRM-53-30-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2026021762514Floorbeam · crackedCRACKED SUPPORT ANGLE FLOORBEAM BS 695, RBL 1. REMOVED AND RE-INSTALLED THE SUPPORT ANGLE AND PERFORMED DETAIL VISUAL INSPECTION ON BRACKET AND FOUND GOOD CONDITION IAW SRM 51-00-06-0G-0, & SRM 51-40-02-0G-0.SDR SWAA2026021762685Access Panel · damagedELONGATED HOLES ACCESS PANEL 661BB AT RT WING. REPAIRED ACCESS PANEL 661BB AT RT WING IAW SRM 51-70-04-2R-10 REPAIR 10. TASK COMPLETE.SDR SIMA2026021718010Floor Support · corrodedRIGHT CENTER FLOOR SUPPORT BETWEEN FR 90 & 91 CORRODED. REMOVED AND REPLACED RT FLOOR SUPPORT IAW SRM 51-40-08.SDR SIMA20260118012Seat Track · corrodedRIGHT CENTER SEAT TRACK CORRODED AT FR 84. REMOVED AND REPLACED THE DOUBLER ON THE SEAT TRACK IAW SRM 53-23-10/04P.SDR SIMA2026021718008Floor Support · corrodedRIGHT OTBD FLOOR SUPPORT CORRODED, FR 84. REMOVED AND REPLACED THE FLOOR SUPPORT AT FR 84 IAW SRM 51-40-08.SDR SIMA20260118009Floor Support · corrodedRIGHT FLOOR SUPPORT BETWEEN FR 84 & 85 CORRODED. R & R THE FLOOR SUPPORT IAW SRM 51-40-08.SDR SIMA2026021718007Shear Panel · corrodedCENTER SHEAR PANEL BETWEEN FR 87 AND 88 IS CORRODED. REMOVED AND REPLACED THE CENTER SHEAR PANEL IAW SRM 51-40-08.SDR SIMA2026021718011Floorbeam Splice · corrodedRIGHT FLOORBEAM SPLICE AT FR 90 IS CORRODED. REMOVED AND REPLACED THE FLOORBEAM SPLICE IAW SRM 51-40-08.SDR HNAA2026021600132Web · chafedPASSENGER DOOR CUT-OUT WEBBING IS CHAFED AT FRAME 18. FURTHER INVESTIGATION FOUND THAT THE PASSENGER DOOR CUT-OUT WEBBING AT FRAME 18 WAS CRACKED. REMOVED CRACK ON INNER SKIN WEB AT FR 18 BY BLEND-OUT IAW ETD2026-145-001177 AND EO1-53-26-0049.SDR SWIA2026011875244Backboard · crackedAFT SERVICE DOOR EVACUATION SLIDE COMPOSITE BACK HAS A HAIRLINE CRACK. REMOVED AND REPLACED THE AFT SERVICE DOOR EVACUATION SLIDE IAW AMM 25-65-01. SEE CP 31491850 FOR GIRTBAR ADJUSTMENT VERIFICATION.SDR SWIA2026011875237Doubler · corrodedCENTER FUSELAGE III WASTE SERVICE DOOR CUTOUT INTERNAL DOUBLER CORRODED INBD CORNER. REMOVED AND REPLACED CENTER FUSELAGE III WASTE SERVICE DOOR CUTOUT INTERNAL DOUBLER IAW SRM 51-40-08, RESTORED SURFACE PROTECTION IAW SRM 51-23-04, SRM 51-23-05, SRM 51-23-0SDR SWAA2026021362500Support Angle · crackedCRACKED SUPPORT ANGLE LOCATED BS360 BTW STR27R TO STR28R AT EQUIPMENT ELECTRONIC COMP. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, AND SRM 51-40-02. MEASUREMENT OF CRACK 0.210 INCH.SDR SWAA2026021362674Rib · crackedCRACK LEADING EDGE RIB LOCATED LE HSS 105.26, RT HORIZONTAL STAB. REPLACED THE LEADING EDGE RIB AND FASTENERS IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, & DWG 186A1001, SHEET 10, REV A.SDR SIMA20260118003Splice · corrodedRIGHT SPLICE AT FR90 IS CORRODED. R & R RT SPLICE IAW SRM 51-40-08.SDR SIMA20260118006Floorbeam · corrodedRIGHT FLOORBEAM SPLICE AT FR 90 IS CORRODED. REMOVED AND REPLACED FLOOR BEAM SPLICE AT FR 90 IAW SRM 51-40-08SDR SIMA20260118001Floor Support · corrodedRIGHT CENTER FLOOR SUPPORT BETWEEN FR 89 AND 90 CORRODED (LEVEL 2 CORROSION). R & R THE FLOOR SUPPORT IAW SRM 51-40-08.SDR SIMA20260118002Splice · corrodedRIGHT CENTER BEAM SPLICE AT FR89 IS CORRODED (LEVEL 2 CORROSION). R & R RT CENTER BEAM SPLICE AT FR 89 IAW SRM 51-40-08SDR SIMA20260118004Floorbeam · corrodedLH FLOORBEAM SPLICE AT FR 89 IS CORRODED (LEVEL 2 CORROSION). R & R LT FLOORBEAM SPLICE AT FR 89 IAW SRM 51-40-08.SDR SIMA20260118005Floor Support · corrodedRIGHT FLOOR SUPPORT IS CORRODED IN AFT GALLEY (LEVEL 2 CORROSION). R & R RT FLOOR SUPPORT IN AFT GALLEY IAW SRM 51-40-08.SDR CALA2026021113701Wheel · detachedRIGHT NLG WHEEL DEPARTING ACFT AT LANDING . REPLACED THE NLG LEG ASSY IAW AMM 32-21-11-400-003-A.SDR AALA202602098090Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 300 AND BS 310, AT LBL 10. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR SWAA2026020662523Floor Support · corrodedCORROSION ON FWD CARBO BAY AFT BULKHEAD TO FLOOR SUPPORT BS 500D, LBL 24 - RBL 24, WL 156. REMOVED AND REPLACED AFT BULKHEAD TO FLOOR SUPPORT IAW SRM 51-40-02-0G-0, AND AIPC 53-11-01-43.