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 CALA2025092909349Charger · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK, FOUND SEAT ROW 8ABC TO 14ABC FLOOR PROXIMITY LIGHT INOPS. FOUND BAD POWER SUPPLY M02503. NEED POWER SUPPLY AND BATTERY.. REPLACED BATTERY CHARGER AND BATTERY PACK AT M02503, PER AMM 33-51-06-960-805, OPS OK.SDR CALA2025092909346Power Supply · faultedEPSU UNIT EMERGENCY RIGHT FAULT. REMOVED & REPLACED RT EPSU (12WL) IAW AMM 33-51-38, OPS CHECK GOOD.SDR 2025FA0000668Skin Panel · corrodedDURING BASE CHECKLIST FOUND CORROSION ON RT LWR WING TO WINGLET AREA. BLENDED AND REMOVED ALL VISIBLE SIGNS OF CORROSION FOUND ON RT LWR WING TO WINGLET AREA. AFTER CORROSION REMOVAL REMAINING THICKNESS OF WING SKIN WAS BEYOND ALLOWABLE LIMITS AND A REPAIR WASSDR SWAA2025093018940Fan · odorFA SMELLED SOMETHING IN THE CABIN, OK TO CONTINUE PER MEL 21-31-02 SP 1 AND 2. AFTER INSPECTION OF CABIN ROWS 7-9 ABC AND DEF AREA AND PSU. FOUND RECIRCULATING FAN GRINDING AND NOISY. REMOVED AND REPLACED THE RECIRCULATION FAN IAW AMM 21-25-02. OPS CHECK GOSDR SWIA2026227873969Stringer · corrodedSTRINGER 21L IS CORRODED BETWEEN FS437.00 & FS453.00. (C-CHECK RO 02/25/2026)COMPLIED WITH REO 670-53-21-2698 DATED: 2025-10-07 REV: A, REPAIR FOR CORROSION DAMAGE TO STRINGER STR21L BETWEEN FS 437.00 - FS 453.00. COMPLIED WITH TASK CARD 51-900-1002-SKY. COSDR SWIA202512020928Stringer · chafedCHAFING FOUND UNDER FUSELAGE SKIN ON STRIGER 27, BS 977 - 989. CHAFE BLEND-OUT & FOUND WITHIN LIMITS IAW SRM 53-00-01-101-001-A01, L:3" W:2" D:0.016",SURFACE REPROTECTED IAW SRM 51-25-01-001-A01.SDR IPXA2025102887933Floorbeam · corrodedMAJOR REPAIR - MDC, BS 1680, FLOOR STR HAS EVIDENCE OF CORROSION AROUND 3EA SCREW HOLES, BTW BL0 AND LBL 24.75. PERMANENT REPAIR ACCOMPLISHED IAW UPS EO: EO-95421-REQ 1 AND VT MAE EA 757-5360-27-A4175 REV-.SDR AALA202511132368Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FORWARD CARGO COMPARTMENT SHEAR TIE AT FR35.3 BETWEEN S40R AND S41R. REPLACED SHEAR TIE PER SRM 51-42-11.SDR JJBA20251111049Floor Support · corrodedLH FLOOR SUPPORT AT FR17, STR 1L HAS CORROSION. REPAIRED LH FLOOR AT FRAME 17SDR SWAA2025110518968Intercostal · crackedCRACK ON INTERCOSTAL WEB LOCATED BTW BS 344 TO BS 360 LBL 12 WL 208.1 AT FWD GALLEY AREA. REPLACED THE INTERCOSTAL WEB IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG: 141A5400 SHEET: 46 REV A.SDR SWAA2025110518969Intercostal · crackedCRACK ON INTERCOSTAL WEB LOCATED BTW BS 344 TO BS 360 BL 0 WL 208.1 IN FWD GALLEY AREA. REPLACED INTERCOSTAL WEB AND FASTENERS IAW SRM 51-40-02 AND DWG 141A5400; SHEET 32; REV-.SDR SWAA2025110519061Support Angle · crackedCRACKED SUPPORT ANGLE, AFT FACE, BS 440, STRINGER 26L. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, AND DWG 143A7505, SHEET 123, REV -.SDR SWAA2025110519059Angle · crackedCRACKED AFT FACE OF ANGLE, BS 500H, STRINGER 26L. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, & DWG 143A7505, SHEET 123, REV -.SDR SWAA2025110519060Angle · crackedCRACKED AFT FACE OF ANGLE, BS 500G, STRINGER 26L. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, & DWG 143A7505, SHEET 123, REV -.SDR SWAA2025110518972Tie Down · corrodedCORROSION ON TIE DOWN LOCATED BS 312 LBL 51 WL 208.1 AT FWD GALLEY AREA. REMOVED AND REPLACED THE TIE DOWN AT BS 312 AND LBL 51; WL 208.1 AT FWD GALLEY. IAW SRM 51-40-02. MEASUREMENT OF CORRODED PART: L= 0.575. W= 0.395.SDR SWAA2025110518967Web · crackedCRACK ON WEB LOCATED BTW 312 TO BS 328 LBL 47 WL 208.1 AT FWD GALLEY AREA. REPLACED WEB AND FASTENERS LOCATED BTW BS 312 TO BS 328 LBL 47 WL 208.1 AT FWD GALLEY AREA IAW SRM 51-40-02 AND SRM 51-10-02 PARAGRAPH 9 AND DWG 141A5400 SHEET 26 REV-.SDR SWAA2025110419100Nut Plate · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 469 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT PLATE LOCATED OFSS 469 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 112A4402, SHEET 13, REV -. CRACK MEASUREMENT ISDR SWAA2025110419095Nut Plate · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 369 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 369 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-10-02 ITEM 9 AND DWG 112A4402 SHEET:13 REV-.SDR SWAA2025110418986Angle · crackedCRACK ON ANGLE AUXILIARY TRACK SLAT 8 AT RT WING. REPLACED ANGLE AUXILIARY TRACK SLAT 8 AT RT WING IAW SRM 51-10-02 ITEM 9 & INSTALLED FASTENERS IAW SRM 51-40-02 AND DWG 114A5010; SHEET 16; REV A . AND MEASURE OF CRACK IS 0.750.SDR SWAA2025110418985Angle · crackedCRACK ON ANGLE AUXILIARY TRACK SLAT 7 AT RT WING (TWO EACH). REPLACED ANGLE AUXILIARY TRACK LOCATED ON SLAT 7 AT RT WING IAW SRM 51-40-02 AND SRM 51-10-02 ITEM 9. LENGTH OF CRACK 0.250 INCH.SDR SWAA2025110319070Fastener · crackedEVIDENCE OF CRACK ON FASTENER ITEM A IDENTIFIED ON FIGURE 1 MT 5340-I-1520-NG COMMON TO BS 727B LBL 24.75. REFER TO FAULT TTG8Q015EFW5 WHERE 25-153-02708 WAS ADDED AS A SUBTASK.SDR SWAA2025110319073Fastener · crackedEVIDENCE OF A CRACK ON FASTENER, ITEMS A & B IDENTIFIED ON FIGURE 1 MT 5340-I-1520-NG COMMON TO BS 727B, RBL 24.75. REPLACED FASTENERS IAW EA 25-153-02708. REFER TO FAULT TTG8Q015NQJQ.SDR SWAA2025110318984Angle · crackedCRACKED ANGLE AUXILIARY TRACK SLAT 6, RT WING. REPLACED THE ANGLE IAW SRM 51-10-02 ITEM 9, AND SRM 51-40-02. DUE TO EVALUATED CRACK ON ANGLE AND NOT FOUND ALLOWABLE DAMAGE IAW SRM-57-42-02-1A-1, ALLOWABLE DAMAGE 1. MEASUREMENT OF CRACK IS L= 2.057.SDR SWAA2025110319098Nut Plate · crackedCRACK ON RAIL NUT-PLATE, OFSS 509 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 509 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-10-02 ITEM 9 SRM 51-40-02, AND DWG 112A4402, REV -, SHEET 13. MEASUREMENT OF CRACK IS L: 0SDR SWAA2025103119101Battery Pack · inoperativeINOPERATIVE BATTERY PACK BS 603 RT SIDE AT PASSENGER CABIN. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06-960-805, OPS CHECKED OK.SDR VNAA202510310010Floor Support · crackedAFTER ANGLE REMOVAL IN REFERENCE NRC00115 BTW FS 265 TO FS280 CRACK WAS FOUND ON ANGLE. FLOOR ANGLE BS 265 TO FS280 WAS REPLACED PER CRJ/900 SRM 51-42-06-001-001-A01SDR VNAA202510310007Seat Track · corrodedCORROSION ON SIDE SEAT RAIL STRUCTURE, (02 SEGMENTS) STGR 15RH. (01 SEGMENT) BTW FS671.40 TO FS722.85. (02 SEGMENT) BTW FS783.15 TO FS846.00. SEAT RAIL (02 SEGMENTS) STGR 15RH. (01 SEGMENT) BTW FS671.40 TO FS722.85. (02 SEGMENT) BTW FS783.15 TO FS846.00 WERE SDR VNAA202510310006Seat Track · corrodedCORROSION ON SIDE SEAT RAIL STRUCTURE, (02 SEGMENTS) STGR 15LH. (01 SEGMENT) BTW FS671.40 TO FS722.85. (02 SEGMENT) BTW FS 783.15 TO FS846.00. SEAT RAIL STRUCTURE, (02 SEGMENTS) STGR 15LH. (01 SEGMENT) BTW FS671.40 TO FS722.85. (02 SEGMENT) BTW FS 783.15 TO FSDR VNAA202510310004Seat Track · corrodedCORROSION ON SEAT RAIL RBL 9 BTW FS 482 TO 581, FS 581 TO 661+32 AND 661+32 TO 677 AT CABIN. SECTIONS SEAT RAIL RBL 9 BTW FS 482 TO 581, FS 581 TO 661+32 AND 661+32 TO 677 WERE REPLACED PER CRJ900 SRM 53-31-49-101-001-A02 AND CRJ900 AMM 53-00-49 CONFIG A12SDR SWAA2025103019099Stub Frame · crackedCRACK INDICATION ON STUB FRAME BETWEEN BS 294.5 - 296.5, S-8 & 9R AT FWD GALLEY DOOR AREA. CRACK LENGTH 1.375 IN. REPLACED STUB FRAME IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 141A8370, SHEET 9, REV -, SHEET 10, REV D.SDR SWAA2025103019097Nut Plate · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 591 INTERNAL CAVITY LEADING EDGE AT RT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 591 INTERNAL CAVITY LEADING EDGE AT RT WING IAW SRM 51-10-02 ITEM 9 AND DWG: 112A4402 SHEET: 14 REV: -.SDR SWAA2025103019094Nut Plate · crackedCRACK ON RAIL NUT-PLATE LOCATED OFSS 484 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 484 INTERNAL CAVITY LEADING EDGE AT LT WING IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 112A4402, SHEET 13, AND SHEET 14 REV-. MEASURE OSDR AALA202510303729Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND OVERWING AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202510306369Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND OVERWING FORWARD EMERGENCY LIGHTS INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202510302586Light · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING AFT EMERGENCY LIGHTS INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202510303159Light · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING FORWARD EMERGENCY LIGHTS INOPERATIVE. REPLACED LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR 3EJA202510240005Switch · failedON CLIMB OUT GOT AT KGPI HAD A DOOR SEAL STEADY YELLOW CASS MESSAGE. REMOVED AND REPLACED DOOR SEAL DIFFERENTIAL PRESSURE SWITCH P/N P18M-30 S/N 5313. INSTALLED "INSPECTED" PRESSURE SWITCH
P/N 18M-30 S/N 2527.SDR SWAA2025102219054Web · crackedNUMBER 1 ENGINE INBOARD FAN COWL WEB AFT OF THE OIL SERVICE DOOR CRACKED. REMOVED AND REPLACED WITH TTG8Q00S5H1F.SDR ASAA2025092861731Baffle · corrodedFWD PIT RT BAFFLE BETWEEN STATIONS 500F TO 500G CRACKED AND CORRODED. GROUNDED - YES. BLENDED FWD PIT RH BAFFLE BETWEEN STATIONS 500F TO 500G. AFTER FURTHER EVALUATION NO CRACKS PERMITTED. REPLACED BAFFLE P/N 143A7510-20 PO#1134617.1 IAW BAC DWG #143A7505 REV.SDR ASAA2025092861727Baffle · corrodedFWD PIT R/H BAFFLE BETWEEN STATIONS 500G TO 500H BENT AND CORRODED. GROUNDED - YES. REMOVED CORROSION IN FWD PIT R/H BAFFLE BETWEEN STATIONS 500G TO 500 H. ORIGINAL THICKNESS .020 MATERIAL LOSS 0.011 MATERIAL REMANINING 0.009. FOUND TO BE OUT OF LIMITS IAW B73SDR SWAA2025102019084Skin · pulledLEFT INLET COWL OUTER LIP SKIN HAS 3 PULLED THROUGH RIVETS AT 10 O'CLOCK. REMOVED AND REPLACED FASTENERS ON LEFT INLET COWL OUTER LIP SKIN PER REF SRM 54-10-01-1A-2.SDR AALA202510204114Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500 AND BS 500I AT LBL 24. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR R612025F00004Plate · chafed#2 ENGINE OUTBOARD T/R CENTER THERMAL BLANKET CHAFE PLATE CHAFED.REMOVED DAMAGED CHAFE PLATE, FABRICATE REPAIR PATCH REF.NO. REPUBLIC AIRWAYS 170EA--78-31-0004MR_1 REV 2.SDR R61A2025101900471Plate · chafed#1 ENGINE INBOARD T/R CENTER THERMAL BLANKET CHAFE PLATE CHAFED.REMOVED DAMAGED CHAFE PLATE, FABRICATE REPAIR PATCH.REF.NO.REPUBLIC AIRWAYS 170EA-78-31-0004MR_1 REV 2.SDR R61A2025101900469Plate · chafed#1 ENGINE INBOARD T/R CENTER THERMAL BLANKET CHAFE PLATE CHAFED. REPAIRED PER REPUBLIC AIRWAYS 170EA-78-31-0004MR_1REV2SDR SWIA2025F01432Seat Track · corrodedRIGHT SEAT TRACK HAS CORRODED TEETH FR 20-21. REMOVED AND REPLACED R/H FLOOR BEAM SEAT TRACK BETWEEN FR 12-21. REF SRM 51-40-08. SEE CONTINUATION FOR WORK PERFORMED.REPLACED WITH FACTORY PART, NO CHANGE TO WEIGHT AND BALANCE.SDR SWIA2025F01431Seat Track · corrodedLT INBD SEAT TRACK CORRODED AT FR 84-85. BLENDED AND EVALUATED LH I/B SEAT TRACK AT FR 84-85, FOUND TO BE WITHIN ALLOWABLE LIMITS. REF ETD2025-170-929331FABRICATED AND INSTALLED REPAIR DOUBLER REF SRM 53-23-10, REPAIR 04P.SEE CONTINUE CARD FOR WORK PERFORMED.SDR SWIA2025101700928Seat Track · corrodedRT INBD SEAT TRACK CORRODED AT FR 84-85SDR IPXA2025100383584Fairing · damagedR/H WING, KRUEGER MOVABLE VANE, EXTERNAL LOWER O/B SKIN WITH GOUGE. REMOVED GAUGE ON EXTERNAL SKIN R/H KRUEGER IAW SRM 51-73-10, ORIGINAL THICKNESS .090", REMAINING THICKNESS .065", MAX MATERIAL LOSS .025" FOUND OUT OF LIMITS IAW A300-600 SRM 51-73-11. REMOVESDR IPXA2025100979085Skin · delaminatedTAIL CONE STA1963-1992 BOTTOM SKIN INTERNAL BELOW THE APU EXHAUST MANIFOLD CORRODED/DELAMINATED. REMOVED SKIN BELOW APU EXHAUST MANIFOLD IAW SRM 51-40-02. INSTALLED NEW BOND ASSY (SKIN PANEL) IAW SRM 51-40-02-0G-0 AND DWG 148N3770. INSTALLED APU EXHAUST DUC