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 JR2R20250911719Angle · crackedANGLE CLIP ON THE FWD SIDE OF FLOOR BEAM 12, AT BL 0, IN THE FLIGHT DECK IS CRACKED. REPLACEDSDR CALA2025091108755Slide · looseR2 DOOR SLIDE LOWER Z FOLD HITTING DOOR THRESHOLD. REMOVED AND REPLACED R2 DOOR SLIDE REF AMM 25-66-01-000-803 AND REF AMM 25-66-01-400-803.SDR COEA2026012001816Stringer · damagedSTRINGER 1L BETWEEN FRAMES 38 - 39 HAD TOOLING DAMAGE. REPAIRED IAW SRM 53-00-00--300-824-A01, REV 120.SDR SWI2025F01896Drag Angle · crackedRIGHT AFT VERTICAL STAB DRAG ANGLE HAS POSSIBLE CRACK (MARKED). (C-CHECK RO 12/24/2025)EVALUATED, REMOVED AND INSTALLED NEW RH AFT VERTICAL STAB DRAG ANGLE REF CRJ900 SRM 51-42-13-001-001-A01 , CRJ900 SRM 51-42-21-001-001-A01 , CRJ900 SRM 51-42-22-001-001-A01 SDR SWI2025F01895Strap · corrodedCORROSION ON JOINT STRAP COMON TO INBD CORNER OF FWD CARGO DOOR SURROUND AND BS 519.64. REMOVED CORROSION ON JOINT STRAP COMMON TO INBD CORNER OF FWD CARGO DOOR SURROUND AND FS 519.64 REF SRM 51-21-06-001-001-A01. NOT ALLOWABLE DAMAGE ON AREA. REF SRM 53-31-2SDR SWI2025F01894Stringer · corrodedCORROSION FOUND ON STGR 24L BETWEEN FS501.00 AND FS517.00. REMOVED AND REPLACED STGR 24L SECTION AT FS 447.21 -FS 517, REF. DWG SH690-333207, REV. A, SRM 51-42-06-001-001-A01, REV. 38 AND SRM 51-42-21-001-001-A01, REV. 38. COMPLIED WITH TASK CARD 51-900-10SDR SWI2025F01893Cleat · corrodedCLEAT COMMON TO FS 927.00 INTERCOSTAL AT STGR 22LT HAS CORROSION. REMOVED DISCREPANT AND WET INSTALLED NEW REPLACEMENT CLEAT AT STGR 22L & FS.927 FRAME PER CRJ900 SRM TASK 51-42-06-001-001-A01 REF. BOMBARDIER DWG. SH690-37060 REV. AC.COMPLIED WITH SKYCARD 51-SDR SWIA202512260910Drag Angle · crackedLEFT AFT VERTICAL STAB DRAG ANGLE HAS POSSIBLE CRACK. PERFORMED REPAIR ON LH AFT VERTICAL STAB DRAG ANGLE IAW SRM 55-31-00-201-001-A01. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-1002-SKY.SDR SWI2025F01740Intercostal · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL DD7. REMOVED AND INSTALLED A NEW PAX DOOR FWD INTERCOSTAL DD7 IAW SRM 51-42-06-001-001-A01, AND DWG 601R31702, REV N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TASK CSDR SWI2025F01739Intercostal · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL CLIP DD7. REMOVED AND REPLACED PAX DOOR FWD INTERCOSTAL CLIP DD7 IAW SRM 51-42-06-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH 51-900-1002-SKY.SDR SWI2025F01738Intercostal · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL CLIP DD4. REMOVED PAX DOOR FWD INTERCOSTAL CLIP DD4 IAW SRM 51-42-06-001-001-A01 AND INSTALLED IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV N.COMPLIED WITH 51-900-1002-SKY, PRESSURE LEAK CHECK WAS GOOD.SDR SWI2025F01737Intercostal · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL CLIP DD2. REMOVED AND INSTALLED PAX DOOR FWD INTERCOSTAL CLIP DD2. IAW SRM 51-42-06-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01736Intercostal · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL CLIP DD6. REMOVED AND INSTALLED NEW PAX DOOR FWD INTERCOSTAL CLIP DD6. IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WISDR SWI2025F01735Intercostal · corrodedCORROSION FOUND ON FWD INTERCOSTAL DD1. REMOVED AND INSTALLED NEW PAX DOOR FWD INTERCOSTAL DD1. IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TASK CARD 51-900-SDR SWI2025F01734Bracket · gougedPAX DOOR FWD INTERCOSTAL BRACKET DD6 FOUND TO BE GOUGED. REMOVED AND INSTALLED NEW PAX DOOR FWD INTERCOSTAL BRACKET DD6. IAW. SRM 51-42-06-001-001-A01. AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKED GOOD. COSDR SWIA2025120800910Bracket · corrodedCORROSION FOUND ON PAX DOOR FWD INTERCOSTAL BRACKET DD4. REMOVED AND INSTALLED NEW PAX DOOR FWD INTERCOSTAL BRACKET DD4. IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLSDR AALA202511289554Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT BETWEEN FR 56 AND FR 57 AT S42L. REPAIRED STRINGER PER SRM 53-00-13-300-001.SDR AALA202511186370Hinge Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON DOOR MLG KEEL BEAM HINGE FITTING RH SIDE AFT LUG, WEB LOWER RADIUS. CRACK LENGTH IS 0.150 INCH APPROX, AT MAIN WHEEL WELL.SDR AALA202511172092Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 57 AT S43L. REPAIRED STRINGER PER SRM 53-00-13-300-001.SDR JJBA20251111046Strap · corrodedLEFT WING LOWER SPAR STRAP CORRODED FROM RIB 19 TO RIB 25. REMOVED CORROSION ON LH WING LOWER SPAR STRAP FROM RIB 19 TO RIB 25 BY BLENDINGSDR JJBA20251111045Strap · corrodedLH WING UPPER SPAR STRAP CORRODED FROM RIB 19 TO RIB 25. REMOVED CORROSION ON LH WING UPPER SPAR STRAP FROM RIB 19 TO RIB 25 BY BLENDINGSDR AALA202511033958Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM -Y765 LOC. AT LEVEL FR66 AT AFT GALLEY AREA MEASURES ARE: L= 0.574 INCH, W= 0.468 INCH, D:0.010 INCH. MAINTENANCE REPLACED FLOOR BEAM-Y765 LOC. BTW 64 TO FR66 AFT GALLEY AREA IAW A319 SRM 51-42-11-801, A319 SRSDR FDEA202510292105Battery · inoperativeON POSTFLIGHT INSPECTION FOUND EMERGENCY LIGHTING TEST INOP. REMOVED AND INSTALLED NEW POWER SUPPLY UNIT AS REQUIRED. OPS CHECKED GOOD.SDR AALA202510282854Keelbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON DOOR MLG KEEL BEAM HINGE FITTING LH SIDE FWD LUG, WEB LOWER RADIUS. CRACK LENGTH IS 0.130 IN, AT MAIN WHEEL WELL. ACCOMPLISHED PERMANENT REPAIR INSTRUCTION (REPLACED DOOR HINGE FITTING) LOC. BTW FR42 AND FR43,SDR JJBA20251024068Support · crackedLH ELEVATOR RVDT SUPPORT CRACKED AND CORRODED. REMOVED AND REPLACED LH ELEVATOR RVDT SUPPORT.SDR JJBA20251024064Floor Support · corrodedCORROSION ON RH FLOOR BEAM BETWEEN FRAMES 17 AND 18. INSTALLED NEW RH FLOOR BEAM BETWEEN FR 17-20 AND FLOOR SUPPORT AT FR 20.SDR AALA202510211547Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK FLOOR STRUCTURE FITTING BETWEEN FR 11 AND FR 12 AT -Y1292. REPLACED FITTING PER SRM 51-72-11.SDR 2025FA0000705Bearing · brinelledFOUND BOTH SPINDLE BEARING SETS P/N A159-3, TSN: 221.3, BRINELLEDSDR HNAA2025100900689Floor Support · cracked53-2087 CTR OMEGA BEAM #3 CRACKED AT FR31 IB VERT FLANGE. REPAIRED IAW ETD2025-145-928527 AND EO1-53-25-0238SDR HNAA202510090001Floor Support · cracked53-2087 CTR OMEGA BEAM #3 CRACKED AT FR31 IB VERT FLANGE. REPAIRED IAW ETD2025-145-928527 AND EO1-53-25-0238SDR HNAA2025100800685Channel · corrodedCF1 SERVICE DOOR CHANNEL CORRODED. R & R CHANNEL IAW SRM 51-40-02SDR 3EJA202510070001Shimmy Dampener · failedAGGRESSIVE NOSE SHIMMY ON TAKE OFFSDR HNAA2025100700680Floor Support · crackedLEFT OMEGA BEAM IB VERT FLANGE CRACKED AT FR28. REPAIRED IAW ETD2025-145-928525 AND EO1-53-25-0337SDR SWAA2025100613337Plate · crackedLEFT WING OTBD OF ACCESS PANEL 551DB HAS CRACKED WIGGLE PLATE. REMOVED AND REPLACED WIGGLE PLATE OTBD OF PANEL 551DB IAW SRM 51-40-02-0G-0 AND DWG.115A2001, REV-.SDR SWAA2025100613339Plate · crackedRIGHT WING OTBD OF ACCESS PANEL 651DB HAS CRACKED WIGGLE PLATE. REMOVED AND REPLACED WIGGLE PLATE OTBD OF PANEL 651DB IAW SRM 51-40-02-0G-0 AND DWG 115A2001, REV-.SDR SWAA2025100213378Angle · crackedCRACK ON ANGLE LOCATED ON ACCESS PANEL 651FB TRAILING EDGE AT RT WING. REPLACED ANGLE IAW SRM 51-10-02 ITEM 9, SRM 51-40-05, AND DWG#115A2710 SHEET 6 REV B DUE TO NOT FINDING ALLOWABLE DAMAGE IN SRM 57-51-02-1A-1. MEASUREMET OF CRACK IS L= 1.336.SDR SWAA2025100113558Stringer Clip · crackedCRACKED STRINGER CLIP BS 706, S3L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 144A1107, REV B.SDR SWAA2025100113559Stringer Clip · crackedCRACKED STRINGER CLIP BS 706, S4L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02, AND DWG 144A1107 0001, REV B.SDR SWAA2025100113562Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727A, S8L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1101, REV E.SDR SWAA2025100113563Stringer Clip · crackedCRACKED STRINGER CLIP BS 727A, S9L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1101, REV E.SDR SWAA2025100113560Stringer Clip · crackedCRACKED STRINGER CLIP BS 727B S8L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 146A1102, REV D.SDR SWAA2025100113564Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727C, S8L. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-05-0G-0, AND DWG 146A1103, REV D.SDR SWAA2025100113561Stringer Clip · crackedCRACKED STRINGER CLIP, BS 727E STRINGER 5R. REMOVED AND REPLACED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, AND DWG 144A1107, REV B.SDR SWIA202509290010Seal Depressor · gougedGOUGES ON FWD PASSENGER DOOR SEAL REST IN 6 LOCATIONS AS MARKED. (C-CHECK RO 09/28/2025) REMOVED AND REPLACED FWD PAX DOOR AFT SEAL DEPRESSOR. REF. SRM 51-40--08. SEE CONTINUE CARD FOR ADDITIONAL WORK PERFORMED.SDR HNAA2025092600646Gusset · corrodedLEFT GUSSET NR 3 CORRODED. R & R GUSSET IAW SRM 51-40-02.SDR HNAA2025092600644Repair · noneTEMP REPAIR INSTALLED ON AFT FUSELAGE PER EO1-53-25-0319. R & R REPAIR IAW EO 1-53-25-0325SDR ASAA2025091061086Landing · gougedPANEL 193B RT SIDE OTBD, PANEL LANDING GOUGED. GROUNDED - YES. REMOVED & REPLACED PANEL 193 RT SIDE OTBD PANEL LANDING IAW SRM 51-40-02-0G-0.SDR SWAA2025092513374Slide · out of adjustFED SLIDE SAGGING AND NEEDS TO BE RIG CHECKED. ADJUSTMENT ON FED WAS VERIFIED IAW AMM 52-11-00-820-801 STEP 2.I THROUGH 2.T AND PERFORMED STEP 2.N AND 2.U. PERFORMED FED SYSTEM AND WARNING TEST IAW AMM 52-11-00-700-804 AND AMM 52-71-11-820-801. SATISFACTORY SDR AALA202509254225Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR DUMMY RAIL AT FR 16 AND +Y503.2. REPLACED DUMMY RAIL PER SRM 51-72-11.SDR SWI2025F01321Bushing · damagedWHILE REMOVING LH MLG ASSY DAMAGED OCCURRED ON THE LH AFT MLG PIVOT BUSHING. (FILED CLOSED)COMPLIED WITH REO 601R-57-21-3972 DATED: 2025-09-11 TEMPORARY DISPOSITION FOR BLENDING GOUGE DAMAGE ON FACE OF FWD AND AFT MLG TRUNNION BUSHINGS, LHS. ALL NDT'S COMPLIE