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 2025F00229Engine · failedFLT NUMBER: DVR023, ENGINE FAILURE AND EMERGENCY LANDING. SHORTLY AFTER DEPARTURE FROM BON, THE CREW EXPERIENCED A LOSS OF FUEL PRESSURE AND OBSERVED A DECREASING OIL PRESSURE ON THE LEFT-HAND (LH) ENGINE. DUE TO THESE CRITICAL INDICATIONS, A PRECAUTIONARY SHSDR SWAA2025092304900Tee Angle · corrodedCORROSION ON FLOOR STRUCTURE TEE ANGLE BETWEEN BS 270 TO BS 277 AND LBL 10 WL 208. REPLACED TEE ANGLE BS 270 TO BS 277, LBL 10, WL 208 IAW SRM 51-40-02 AND DWG 141A5600 SHEET 1 AND 2; REV N.SDR SWAA2025092304700Battery Pack · inoperativeBATTERY PACK INOPERATIVE FOR EMERGENCY LIGHT BTW BS 597 - 616 RT PASSENGER CABIN. REPLACED POWER SUPPLY BATTERY PACK EMERGENCY LIGHT BTW STA 597 TO STA 616 RH SIDE AT PASSENGER CABIN IAW AMM 33-51-06-960-805 AND TESTED OK.SDR SWAA2025092304699Battery Pack · inoperativeBATTERY PACK INOPERATIVE FOR EMERGENCY LIGHT BTW BS 597 - 616, LT PASSENGER CABIN. REPLACED POWER SUPPLY BATTERY PACK IAW AMM 33-51-06-960-805 AND OPS TESTED OK.SDR SWAA2025092304898Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 277 TO BS 294.5, BL 0 IN THE FWD GALLEY. REPLACED FLOOR SUPPORT IAW SRM 51-40-02-0G-0 AND DWG 141A5400, SHEET 39, REV -.SDR SWAA2025092304904Intercostal · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 - 328, LBL 46 IN THE FWD GALLEY AND LAV. REPLACED FLOOR SUPPORT IAW SRM 51-10-02-0G-0, SRM 51-40-02-0G-0, AND DWG 141A5400, SHEET 26, REV -.SDR SWAA2025092204901Floor Panel · brokenBROKEN FLOOR PANEL 241AEF AT AFT GALLEY AREA. REPAIRED FLOOR PANEL 241AEF AT AFT GALLEY AREA IAW SRM 53-00-50-2R-1 REPAIR 1 .SDR SWAA2025092204905Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE BETWEEN BS 312 TO BS 328 AND RBL 31 FWD GALLEY AND LAV. REPLACED WEB-INTERCOSTAL FLOOR STRUCTURE LOCATED BTW BS 312 TO BS 328 AND RBL 31 FWD GALLEY AND LAV IAW SRM 51-40-02-0G-0 AND DWG 141A5400, SHEET 39 REV -.SDR SWAA2025091504953Support · corrodedAFT CARGO, RT SIDEPLATE SUPPORT BS 727 TO 767, RBL 21 HAS SEVERAL SPOTS OF CORROSION. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT BS 727 TO 767, RBL 21 IAW SRM 51-40-02-0G-0, AND DWG 146A7500.SDR SWAA2025091504954Strap · corrodedAFT CARGO, CORROSION TO FLOOR SUPPORT STRAP BS 887, RBL 17 TO LBL 17. REMOVED AND REPLACED ACB FLOOR SUPPORT STRAP BS 887 FROM RBL17 TO LBL17 IAW SRM 51-40-02, AND DWG 149A8104 0113, REV -.SDR SWAA2025091506642Shield · corrodedACB; CORROSION TO FWD SHIELD, BS 767 TO 787+5, RBL 21. REMOVED AND REPLACED NEW ON ACB FWD SHIELD FROM BS 767 TO 794, RBL 21 IAW SRM 51-40-02 AND DWG 146A0081 0028, REV A.SDR SWAA2025091504932Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 17 INCH AFT BS 500, RBL 23, WL 156.5. REMOVED AND REPLACED FCB SUPPORT BETWEEN BS 492.4 TO 500A, RBL 23, WL156.5 IAW SRM 51-40-02 AND DWG 143A0080 REV-.SDR SWAA2025091504938Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 9 INCH AFT BS 500, RBL 23, WL 156.5. THIS DISCREPANCY WILL BE ACCOMPLISHED ON CARD TTG8Q014L2U0.SDR SWAA2025091504939Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 13 INCH AFT BS 500, RBL 23, WL156.5. THIS DISCREPANCY WILL BE ACCOMPLISHED ON CARD TTG8Q014L2U0.SDR SWAA2025091504933Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 6 INCH AFT BS 480, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504940Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 10 INCH AFT BS 480, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504934Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 10 INCH AFT BS 500, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504935Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 14 INCH AFT BS 500, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504936Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 18 INCH AFT BS 500, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504941Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 2 INCH AFT BS 500A, LBL 23, WL 156.5. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT FROM BS 396 TO BS 500D, LBL 23 IAW SRM 51-40-02 AND DWG 143A7500 REV -.SDR SWAA2025091504937Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 6 INCH AFT BS 500A, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504942Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 6 INCH AFT BS 500A, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504943Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 14 INCH AFT BS 500A, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504944Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 6 INCH AFT BS 500B, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504949Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 10 INCH AFT BS 500B, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504945Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 2 INCH AFT BS 500C, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504946Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 7 INCH AFT BS 500C, LBL 23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504950Support · corrodedFLOOR TO SIDEWALL SUPPORT ATTACH FRAME CORRODED 13'AFT STA.500C, LBL23, WL 156.5. THIS CARD WILL BE ACCOMPLISHED AT CARD TTG8Q014L3L6.SDR SWAA2025091504952Support · corrodedAAFT CARGO BAY, LT SIDEPLATE SUPPORT BS 727 TO 847, LBL 21 HAS SEVERAL SPOTS OF CORROSION. REMOVED AND REPLACED ACB LT SIDEPLATE SUPPORT BS 727 TO 847 LBL 21 IAW SRM 51-40-02-0G-0 AND DWG 146A7500.SDR SWAA2025091504721Bear Strap · crackedCRACK AT FSD BS 297.5 BELOW STR 6R. THIS JOBCARD WAS ATTENDED WITH THE FOLLOWING WO TTG8Q014JYV0.SDR REXA2025091500858Fitting · wornWEAR ON FLAP FITTING OF FLAP STUB FAIRING 171DL AT LH WING TRAILING EDGE (ROOT WING). FLAP FITTING OF FLAP STUB FAIRING 171DL AT LH WING TRAILING EDGE (ROOT WING). WERE REPLACED PER CRJ900 SRM 51-41-02-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2025091500857Support · wornWEAR ON PLATE SUPPORT OF FLAP STUB FAIRING 171DL AT LH WING TRAILING EDGE (ROOT WING). PLATE SUPPORT OF FLAP STUB FAIRING 171DL AT LH WING TRAILING EDGE (ROOT WING). WERE REPLACED PER CRJ900 SRM 51-41-02-001-001-A01 AND SRM 51-42-21-001-001-A01SDR SWIA2025091000815Floorbeam · corrodedRH CENTER FLOORBEAM CORRODED AT FR 86. REMOVED AND REPLACED CF III RH CENTER FLOORBEAM AT FR 86, REF SRM 51-40-08.SDR SIMA20250815003Shear Tie · corrodedCORROSION FOUND AT CLIP SHEAR ZONE 152 FR 88 STGR 29R (INTERNAL FWD WASTE WATER PANEL) (LEVEL 2 CORROSION) (MAJOR REPAIR) LOCATED AND DRILLED NEW SHEAR CLIP PN# 170-66531-001 IAW EMBRAER 175 SRM 51-40-02. INSTALLED NEW SHEAR CLIP LOCATED AT FR88 AND STR29R IAWSDR SIMA20250815004Seat Track · corrodedCORROSION FOUND ON R/H SIDE IB SEAT TRACK BETWEEN FR 81 AND 82 Y= +276 (LEVEL 2 CORROSION) (MAJOR REPAIR) CORROSION ON INBOARD SEAT TRACK MEASURED .025", FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-23-10 AD01. REMOVED RT SIDE IB SEAT TRACK BETWEEN FR 73 TOSDR IPXA2025090884241Pawl · damagedTHE PAWL BEHIND THE CREW ENTRY DOOR HANDLE HAS WEAR DAMAGE. REMOVED THE PAWL IAW AMM 52-11-26-004-001, REV 145. INSTALLED A NEW PAWL IAW AMM 52-11-26-404-003, REV 145.SDR ASAA2025081560626Frame · corrodedAFT CARGO FRAME BS 747 CORRODED AT INNER CHORD RBL 26. GROUNDED - YES. UPON FURTHER EVALUATION FOUND TO HAVE NO ALLOWABLE SRM LIMITS, REPAIRED FRAME BS 747 RBL 26 IAW SRM 53-60-07-2R-2W =1" O= .000 R= .000 L= 2" D= .000.SDR SWAA2025090804964Angle · crackedCRACK ANGLE TRAILING EDGE ORSS 276 AT RT WING. REPLACED ANGLE AND FASTENERS LOCATED TRAILING EDGE ORSS 276 AT RT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 115A6200 SHEET: 11 REV: B; MEASURES OF CRACK IS: L= 0.464.SDR SWAA2025090804965Plate · crackedCRACKED CORRUGATED PLATE TRAILING EDGE ORSS 261 AT RT WING. REPLACED CORRUGATED PLATE TRAILING EDGE ORSS 261 AT RT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 115A2714 SHEET 6 REV. -.SDR SWAA2025090804963Support Bracket · crackedCRACKED SUPPORT BRACKET TRAILING EDGE ORSS 271 RT WING 2025-505207<[01] REPLACED SUPPORT BRACKET TRAILING EDGE ORSS 271 RT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9. AND DRAWING #115A2930 SHEET 6 REV -.SDR SWAA2025090804969Skin · crackedCRACK ON INLET COWL ENGINE 1 AROUND 9 O CLOCK. FAULT RESOLVED ON OTHER FAULT SEE TTG8Q00S712K;[02] FAULT RESOLVED ON OTHER FAULT SEE TTG8Q00S712KSDR SCNA20250903350Floor Support · crackedAFTER REMOVAL INTERCOSTAL BTW STA 294/ STA 312 & RBL-31 ON FLOOR STRUCTURE OF W1 WAS FOUND CRACK ON INTERCOSTAL. INTERCOSTAL BTW STA 294/STA 312 & RBL-31 ON FLOOR STRUCTURE OF W1 WAS REPAIRED PER B737-800 SRM 53-10-51-2R-6 REPAIR 6SDR IPXA2025083196619Floorbeam · corrodedMDC BETWEEN STA 1100 AND LBL 62 CROSSBEAN WITH CORROSION. ACCOMPLISHED REPAIR PER EO-94866-REQ1 AND VT-MAE 757-5340-27-A4101, REV-.SDR AALA202509023033Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AND S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-72-11.SDR 2025FA0000595Bushing · looseLEFT MAIN GEAR ATTACH BUSHING P/N 0541202-4 LINER BECAME DISBONDED CREATING PLAY IN THE GEAR LEG. THIS AIRCRAFT IS OUTSIDE THE S.N. RANGE OF SEL-32-08 YET HAS THE SAME PROBLEM.SDR 2025FA0000594Bushing · looseLEFT AND RIGHT MAIN GEAR ATTACH BUSHINGS P/N 0541202-4 LINER BECAME DISBONDED CREATING PLAY IN THE GEAR LEG. THIS AIRCRAFT IS OUTSIDE THE S.N. RANGE OF SEL-32-08 YET HAS THE SAME PROBLEM.SDR ASAA2025081560416Angle · corrodedAFT CARGO CORROSION ON ANGLE AT STA 767 TO 787 RBL 28. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW B737-900 SRM 51-10-02. REMOVED AND REPLACED ANGLE ASSY IAW B737-900 SRM 51-40-02-0G-0.W= 1.00 O= .080 R= .038 L= 22.0 D= .042.SDR IPXA2025082981252Support Bracket · crackedCRACK-CLIP, NO.1 ENG IDG/OIL COOLER SENING TUBE SUPPORT CLIP.I.A.W. AMM 20-11-00-910-802 REV.145 REPLACED THE CLIPSDR AALA202508285674Pump · faultyAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER PUMP LOW PRESSURE LIGHT REMAINS ON WHEN PUMP TURNED ON. ACCOMPLISHED UFI FAULT ISOLATION PROCEDURE PER FIM TASK 28-22-00-810-822. REMOVE AND REPLACED (UFI)-UNIVERSAL FAULT INTERRUPTER (AALA202508209524) AND RAM MODULESDR AALA202508289524Interrupter · faultedAIRCRAFT WAS NOT GROUNDED: RIGHT CENTER PUMP LOW PRESSURE LIGHT REMAINS ON WHEN PUMP TURNED ON. ACCOMPLISHED UFI FAULT ISOLATION PROCEDURE PER FIM TASK 28-22-00-810-822. REMOVE AND REPLACED (UFI)-UNIVERSAL FAULT INTERRUPTER (AALA202508209524) AND RAM MODULE