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 DALA2025112108524Battery Pack · inoperativeDURING SERVICE CHECK AMDS CARD 5014-2001, FOUND BATTERY EMERGENCY LIGHT PACK INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK ON ROW 27-28. IAW AMM 33 -51. OPS CHECKED GOOD. (6515193)SDR DALA2025112108521Seat Track · corrodedCORROSION OUT OF LIMITS IAW NRC 00444, CORROSION ON SEAT TRACK IS OUT OF LIMITS IAW SRM 53-00-52-1A-1, PROCEDURE 1, ALLOWABLE DAMAGE 1, FIGURE 101. CORROSION LEVEL 2, SEAT TRACK ON RBL.45 BTW BS 365 - 418 WAS REPLACED PER SRM 51-40-02-0G. PAR. 7. D. (131425SDR IPXA2025112183093Sensor · inoperativeATB, TEMP ZONE L EICAS MESSAGE DISPLAYED DURING CRUISE. FOLLOWED QRH AND WAS UNABLE TO RESET SYSTEM. RESULTED IN ATB CMC MAINTENANCE MESSAGE 21098, FIM TASK 21-61-00-810-852, REV. 2025/07/15 ACCOMPLISHED, FLIGHT DECK DUCT TEMPERATURE SENSOR T1647 REPLACED, AMSDR DALA2025112108508Stringer · corrodedCORROSION STRINGER 43L AT LEVEL FR55 IN AFT CARGO COMPARTMENT (SSI 53 4107). CORRECTIVE ACTION: REPAIRED PER ERA 630525-14 REV ORIGINAL. (1314257)SDR CALA2025112111400Bulb · burned outMID LAV FWD EMERGENCY FLOOR PROXIMITY LIGHT INOP. REPLACED LAV T FWD PROX LIGHT ASSY, TEST GOOD REF AMM 33-51-14-960-802.SDR SWIA2025112076511Attach Angle · corrodedATTACH ANGLE AT STR 26L BETWEEN FS349 -FS364 HAS CORROSION. INSTALLED NEW MAIN AVIONICS ATTACH ANGLE STR 26L BETWEEN BS 333 - 364 IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG SH670-32050, REV J. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKSDR SWIA2025112076487Stringer · corrodedSTR 26L BETWEEN FS333 - FS364 HAS CORROSION. INSTALLED NEW MAIN AVIONICS STR 26L BETWEEN FS333 - FS364 REF CRJ-900 SRM 51-42-06-001-001-A01 AND DWG SH690-31350 REV M. LEAK CHECK GOOD, COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWIA2025112076469Web · crackedPOSSIBLE CRACK IN LT TRU BAY ON WEB FLOOR. PERFORMED REPAIR IN LT TRU BAY ON WEB FLOOR IAW REO 670-53-11-509, REV-E. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112076454Doubler · crackedPOSSIBLE CRACK IN RT TRU BAY ON ADG PUMP DOUBLER. REPIARED RT TRU BAY ADG PUMP DOUBLER IAW REO 690-53-11-2118, REV-. COMPLIED WITH ALL STEPS OF REO 690-53-11-2118 REV-. COMPLIED WITH TASK CARD 51-900-1002-SKY. SEE CONTINUE CARD FOR WORK PERFORMED.SDR REXA2026052800808Hinge · damagedMANUFACTURE HINGE PN:CC670-39109-1 OF AFT LAVATORY WASTE SERVICE ACCESS PANEL 196ER NEW BRACKET HINGE P/N: CC670-39109-1 WAS FABRICATED PER EA CRJ952-20941 REV: IR.SDR REXA2026052800805Hinge Fitting · corrodedCORROSION AT INNER LUG BORES OF LH AILERON, OUTBOARD HINGE FITTING AILS 364.016, 2 LUG BORES. LOWER BORE WAS CLEANED NOT WAS FOUND CORROSION PER CRJ 900 SRM 51-26-00-001-001-A01 UPPER LUG WAS REPAIRED PER REO 690-57-61-469 REV - -SDR REXA2026052800804Hinge Fitting · corrodedAFTER HARDWARE REMOVAL, CORROSION AT INNER LUG BORES OF LH AILERON, CENTER HINGE FITTING AILS L1,L2,L3,L4,L5 AND L6, 6 LUG BORES. INNER LUG BORES L3 & L4 WERE REPAIRED PER REO 690-57-61-469 REV - - AND INNER LUG BORES L2 & L5 WERE REPAIRED PER REO 670-57-61-46SDR SWIA2026031875535Lug · damagedEVALUATE RT AILERON NR 1 OTBD HINGE LUG FOR DAMAGE. REPAIRED THE RT AILERON NR 1 HINGE OTBD HINGE LUG BY BLENDING OUT DAMAGE IAW REO 601R-57-51-1092, REV-.SDR SWIA2025112075423Skin · chafedAFT CARGO DOOR, EXTERNAL SKIN UPPER SIDE HAS CHAFING/GOUGE REMOVED THE EXISTENT DOUBLER AND REPLACED FOR NEW DOUBLER ON EXTERNAL SKIN UPPER SIDE AFT CARGO DOOR IAW REO: 601R-52-31-440 IAW CRJ200 SRM 51-42-21,51-23-00,51-40-11,51-42-22,51-24-36,51-24-16,51-2SDR SWIA2026021375273Attach Angle · corrodedCORROSION ON ATTACHMENT ANGLE BTWN BS 349 - 364, S26R. REMOVED AND REPLACED WITH NEW ATTACH ANGLE AT STGR 26R BETWEEN BS 349 - 364 IAW SRM 51-42-21-001-001-A01, AND DWG SH670-32050, REV J, COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026021375272Stiffener · damagedRIGHT UPPER TRANSCOWL ZEE STIFFENER RIVETS ARE SHEARED. CRACKS FOUND IN INNER SKIN UNDER ZEE STIFFENER, REPAIRED INNER SKIN ON RT UPPER TRANSCOWL IAW REO 670-54-21-1787, REV -. COMPLIED WITH SKY CARD 51-900-1002-SKY.SDR SWIA2025112075271Stand Off · crackedRIGHT LOWER TRANSCOWL INBD -A- BRACKET STANDOFF IS CRACKED. INSTALLED A NEW RT STAND OFF IAW REO 670-54-21-971, REV B. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026021375270Stiffener · damagedLEFT UPPER TRANSCOWL ZEE STIFFENER RIVETS ARE SHEARED. LT UPPER TRANSCOWL ZEE STIFFENER REPAIRED IAW REO 670-54-21-1789, REV -. REFER TO CONTINUATION SHEET FOR DETAILS. COMPLIED FULLY W/SKYCARD 51-900-1002-SKY.SDR SWIA2026020975233Roller · damagedTHE LEFT SLAT TRACK 3-2 ALL 4 SIDE ROLLERS HAVE FLAT SPOT WIDTH GREATER THAN 0.060 IN OR MULTIPLE FLAP SPOTS. REPLACEMENT IS REQUIRED. REPLACED THE LT SLAT TRACK 3-2 OB SIDE ROLLERS 2EA , IB AFT SIDE ROLLER IAW AMM 27-81-44-400-803-A01. REPLACED LT SLAT TRACSDR VNAA202601180015Hinge Fitting · corrodedCORROSION WAS FOUND AT CENTER HINGE FITTING ASSY LUGS #L1, #L2, #L3, #L4, #L5 AND #L6 (6 EA´S). ALSO ON AILERON HINGE FITTING #1 (1EA). FITTING #1 (1EA) AND L3, L4 OF CENTER HINGE FITTING (2EAS) AT LH AILERON WERE CLEANED PER CRJ 900 SRM 51-26-00-001-001-A0. SDR AALA202601144742Shear Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SHEAR PLATE AT FR 69 AND S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR SWAA2025123038180Support · corrodedCORROSION FWD CARGO BAY AFT LOWER BULKHEAD SUPPORT HAS MULTIPLE AREAS AROUND FASTENER HOLES BS 500D, LBL 21 TO RBL 21. REMOVED AND REPLACED BULKHEAD SUPPORT IAW SRM 51-40-02, DWG 143A7902, REV-, AND DWG:143A9481, REV-.SDR SWAA2025123038181Shield · corrodedCORROSION ON THE FWD CARGO BAY AFT SHIELD, BS 500+1- 500+19, RBL 22, WL 156, MULTIPLE AREAS AROUND NUT PLATE HOLES. REMOVED AND REPLACED FWD CARGO BAY AFT SHIELD IAW SRM 51-40-02-0G-0, DWG 143A0080.SDR SWAA2025123038179Support · corrodedCORROSION FWD CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES BS 480 - 500B, LBL 22, WL156. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02, DWG 143A7500 REV-.SDR SWAA2025123038127Web · crackedCRACK ON WEB BTW BS 500F - 500G, STR 26L IN THE FWD CARGO BAY. REMOVED AND REPAIRED THE WEB IAW SRM 53-30-53-2R-1, REPAIR 1, SRM 51-40-02, AND DWG 143A7505, SHEET 138, REV- .SDR SWAA2025123047378Handle · incorrectL1 DOOR ASSIST HANDLE LOOSE. CORRECTLY INSTALLED THE L1 DOOR ASSIST HANDLE IAW AMM 52-11-31-400-802.SDR SWAA2025123038188Threshold Web · corrodedCORROSION AFT CARGO BAY SUB THRESHOLD WEB MULTIPLE AREAS AROUND NUT PLATE HOLES BS 794 TO 847, RBL 26, WL156. REMOVED AND REPLACED SUB THRESHOLD WEB IAW SRM 51-40-02-0G-0, AND DWG 146A8340 REV -.SDR SWAA2025123038122Angle · crackedCRACK GUSSET ANGLE, BS 500I, STR 21R IN THE FWD CARGO BAY. REPLACED THE GUSSET ANGLE AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2025123038129Angle · crackedCRACKED ANGLE BS 400, STR 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02-OG-0, PARAGRAPH 9, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025123038149Access Panel · crackedCRACK ON ANGLE BLADE ACCESS PANEL 333AB AT LT HORIZONTAL STAB. REPLACED ON ANGLE BLADE ACCESS PANEL 333AB AT LT HORIZONTAL STAB IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 186A3101, SHEET 25, REV -. MEASUREMENT OF CRACK IS: L= 0.24.SDR SWAA2025122936991Handle · looseL1 DOOR LINER ASSIST HANDLE IS LOOSE. INSTALLED CORRECTLY L1 DOOR LINER ASSIST HANDLE IAW AMM 52-11-31-400-802.SDR SWAA2025122946796Web · crackedCRACK ON WEB LOCATED BTW BS 500F TO BS 500G AT LEVEL STR 26L AT FWD CARGO COMPARTMENTREPLACED AND REPAIRED WEB LOCATED BTW BS 500F TO BS 500G AT LEVEL STR 26L AT FWD CARGO COMPARTMENT I.A.W B737-800 SRM 53-30-53-2R-1 REPAIR 1; SRM 51-40-02 AND DWG 143A7505 SHESDR SWAA2025122938134Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS 500A TO BS 500B AT LEVEL STR 26R FWD CARGO COMPARTMENT. REPLACED WEB-INTERCOSTAL LOCATED BTW BS 500A TO BS 500B; AT LEVEL STR 26R ON FWD CARGO COMPARTMENT IAW B737-800 SRM 51-40-02-0G-0 AND DWG 143A7505 SHEET: 137 REV: -SDR SWAA2025122938132Angle · crackedCRACKED ANGLE, BS 440, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025122938133Angle · crackedCRACKED ANGLE, BS 500A, STRINGER 26R IN THE FWD CARGO BAY. REPLACED ANGLE IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025122946797Angle · crackedCRACK ON ANGLE, BS 400, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02-OG-0, PARAGRAPH 9, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025122938123Gusset · crackedCRACK GUSSET ANGLE BS 500I, STRINGER 19R IN THE FWD CARGO BAY. REPLACED GUSSET AND FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2025122946794Angle · crackedCRACK GUSSET ANGLE LOCATED BS 500I, STRINGER 21R IN FWD CARGO BAY. REPLACED THE GUSSET ANGLE AND FASTENERS IAW SRM 51-40-02, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2025122938124Gusset · crackedCRACK GUSSET ANGLE LOCATED BS 500I, STR 21L IN FWD CARGO BAY. REPLACED THE GUSSET AND FASTENERS IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 143A7902, SHEET 256, REV B.SDR SWAA2025122946803Angle · crackedCRACK ON ANGLE BLADE ACCESS PANEL 333AB AT LT HORIZONTAL STAB. REPLACED ON ANGLE BLADE(BLADE ASSY) ACCESS PANEL 333AB AT LT HORIZONTAL STAB IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 186A3101, SHEET 25, REV - MEASUREMENT OF CRACK IS: L= 0.246".SDR SWAA2025122238192Floor Panel · damagedELONGATED HOLES ON FLOOR PANEL 140DF AT AFT CARGO COMPARTMENT.SDR ASAA2025112063262Floorbeam · corrodedBS 520 RBL-24 PIVOT LINK FWD FLOORBEAM SUPPORT BRACKET CORRODED. GROUNDED - YES. REMOVED, FABRICATED AND REPLACED FWD SUPPOR BRACKET, REPLACED PIVOT LINK ON BS 520 RBL-24 IAW SRM 51-40-05-0G-0, 51-40-02-0G-0W: 1 O: .125 R: 0 L: .500 D: .125.SDR ASAA2025112063261Floorbeam · corrodedSTA 520 RBL-24 PIVOT LINK FWD FLOORBEAM SUPPORT BRACKET CORRODED. GROUNDED - YES. REMOVED, FABRICATED AND REPLACED FWD SUPPORT BRACKET, REPLACED PIVOT LINK ON STA 520 AND RBL-24 IAW B737-700 SRM 51-40-05-0G-0, 51-40-02-0G-0W: 1 O: .125 R: 0 L: .500 D: .125.SDR SWAA2025122238199Shear Web · elongatedMAIN CABIN; AFT WET AREA; FLOOR SHEAR WEB DAMAGED AND ELONGATED FASTENER HOLES BTW BS 1006 - 1016, LBL 39. REPLACED THE SHEAR WEB BTW BS 986.5 - 1016, LBL 39, WL 208.1 IAW SRM 51-40-02-0G-0 AND DWG 147A0004, SHEET 64, REV-, DWG 147A5600, SHEET 45, REV C.SDR SWAA2025122238200Floorbeam · crackedMAIN CABIN FLOORBEAM CRACKED AT BS 540; BL0 - RBL 24.75. FAULT RESOLVED ON OTHER FAULT, SEE TTG8Q018V1LJ.SDR SWAA2025121947497Floor Panel · damagedELONGATED HOLES ON FLOOR PANEL 140DF IN THE AFT CARGO BAY. REPLACED THE FLOOR PANEL 140DF IAW SRM 51-10-02-0G-0, ITEM 9, & DWG 453A2610, SHEET 13, REV B.SDR SWAA2025121938198Floorbeam · crackedMAIN CABIN FLOORBEAM HAS A CRACK AT BS 540, BL 0 - LBL 24.75. REPLACED MAIN CABIN FLOORBEAM IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 143A0060, SHEET 51, REV-, AND DWG 143A5240 SHEET 32 REV-; MEASUREMENT OF CRACK IS: 0.915 INCH.SDR SWIA2025121900120Frame · corrodedFRAME AT BS 863 IS CORRODED BETWEEN S26L AND S26R. REMOVED DAMAGED SECTION OF FRAME AND PERFORMED CUTTING TRIMMING OF EDGES IAW SRM 51-42-06-001-001-A01, AND SRM 51-24-36-001-001-A01. PERFORMED REPAIRS IAW REO 670-53-51-368, REV -. ALL STEPS OF REO COMPLIED WSDR AALA202512176019Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE AT FR 69 AND S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWAA2025121636999Rib · crackedCENTER TANK RIB CRACKED AT BS 540, LBL 25, WL 202. REPLACED VERTICAL STIFFENER RIB & FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, DWG 111A2001, SHEET 77, REV-, & DWG 111A6000, SHEET 301, REV-.