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 FDEA202507181246Seat Track · wornCABIN - LEFT HAND STATION 1169 X= 8.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 1169, X= 8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTSDR FDEA202507181245Seat Track · wornCABIN - LEFT HAND STATION 1289 X= 47.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 1189, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SESDR FDEA202507181244Seat Track · wornCABIN - LEFT HAND STATION 1169 X= 47.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 1169, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SESDR FDEA202507181243Seat Track · wornCABIN - RIGHT HAND STATION 1169 X= -27.5 SEAT TRACK CROWN WORN. CABIN-RIGHT HAND AT SEAT TRACK STATION 1169, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BSDR FDEA202507181242Seat Track · wornRIGHT STATION 1169 X= -8.5 SEAT TRACK CROWN WORN. SEAT TRACK EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R, REPAIR 1, FIGURE 201. REPAIR CLASSIFIED ASDR FDEA202507181241Seat Track · wornCABIN - LEFT HAND STATION 1431 X= 27.5 SEAT TRACK CROWN WORN. CABIN Ï¿½ LEFT HAND AT SEAT TRACK STATION 1431 X = 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BSDR FDEA202507181240Seat Track · wornLEFT STATION 1169 X= 27.5 SEAT TRACK CROWN WORN. SEAT TRACK EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R, REPAIR 1, FIGURE 201. REPAIR CLASSIFIED AS SDR FDEA202507181239Seat Track · wornLEFT STATION 5-6 X= 27.5 SEAT TRACK CROWN WORN. SEAT TRACK EVALUATED AND FOUND EXCEEDED LIMIT IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R REPAIR 1, FIGURE 201. REPAIR CLASSIFIED AS MSDR FDEA202507181238Seat Track · wornLEFT STATION 810 X= 27.5 SEAT TRACK CROWN WORN. WORN CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT FROM EXISTING SPLICES IAW SRM 53-00-52-2R, REPAIR 1, FIGURE 201. SDR FDEA202507181237Seat Track · wornCABIN, LEFT BS 6-2 X=27.5 SEAT TRACK CROWN WORN. WORN CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT EXISTING SPLICE BS 6-0, X= 27.5 IAW SRM 53-00-52-2R, REPAIR 1,SDR FDEA202507181236Seat Track · wornCABIN - LEFT HAND STATION 6-10 X= 47.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 6-10, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SESDR FDEA202507181235Seat Track · wornCABIN - LEFT HAND STATION 1079 X= 27.5 SEAT TRACK CROWN WORN. CABIN-LEFT HAND AT SEAT TRACK STATION 1079, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SESDR FDEA202507181234Doubler · corrodedRIGHT HAND WING: UPPER WING SURFACE MAIN LANDING GEAR SUPPORT UPPER DOUBLER BETWEEN INNER REAR SPAR AND YW 467, AND STRINGER 1 FOUND WITH CORROSION. RIGHT HAND WING: UPPER WING SURFACE MAIN LANDING GEAR SUPPORT UPPER DOUBLER BETWEEN INNER REAR SPAR AND YW SDR FDEA202507181233Doubler · corrodedLEFT HAND WING: UPPER WING SURFACE MAIN LANDING GEAR SUPPORT UPPER DOUBLER BETWEEN INNER REAR SPAR AND STRINGER-1 FOUND WITH CORROSION. LEFT HAND WING: UPPER WING SURFACE MAIN LANDING GEAR SUPPORT UPPER DOUBLER BETWEEN INNER REAR SPAR AND STRINGER-1 REPAISDR REXA2026072901300Diaphragm · crackedCRACKED LT AFT FAIRING SUPPORT DIAPHRAGM LOCATED IN BS 849 LT AFT FAIRING SUPPORT DIAPHRAGM LOCATED IN BS 849 WAS REPAIRED IAW EA CRJ953-19802, REV A.SDR SWIA2025120900717Intercostal · corrodedFOUND CORROSION ON INTERCOSTAL AT STRINGER 20R BETWEEN BS 349-364. UPON FURTHER INVESTIGATION FOUND INSTERCOSTAL AT STGR 20R BETWEEN FS349-FS364 TO HAVE DAMAGE IN MORE THAN ONE ELEMENT AT A GIVEN CROSSSECTION INSTERCOSTAL IS OUT OF LIMITS 100% MATERIAL LOSSSDR SWIA2025111000717Skin · corrodedCENTRAL FUSELAGE HAS AREAS OF POSSIBLE CORROSION EXTERNAL, AT STGR 27 F.S.942.00 TO F.S.954. EVALUATED AND BLEND OUT AREAS ON CENTRAL FUSELAGE AT STGR 27 BS 942 TO 954, FOUND TO BE WITHIN LIMITS IAW REO 690-53-51-491, SRM 53-51-01, SRM 51-12-00. PERFORMED NDSDR VNAA20251015013Support · corrodedCORROSION ON SILL AFT BAGGAGE-BAY DOOR, CORROSION ON ANGLE KICKPLATE BETWEEN FS1000/FS1047 AND STGR17L. CORROSION ON SILL AFT BAGGAGE-BAY DOOR, CORROSION ON ANGLE KICKPLATE BETWEEN FS1000/FS1047 AND STGR17L WAS EVALUATED EXCESSIVE DAMAGE PER CRJ900 SRM 53-00-SDR VNA2025F00029Skin · corrodedCORROSION ON UPPER SKIN BTW WS178.00 TO WS220.00 AT RH WING. CORROSION ON UPPER SKIN BTW WS178.00 TO WS220.00 AT RH WING WAS REMOVED AND REPAIRED PER REO 690-57-21-535 REV. - -SDR VNA2025F00024Support · corrodedCORROSION IN WHEEL BIN SUPPORTS LH/RH FS 813.70, RBL43 AND LBL43 AT LH/RH MLG WHEEL WELL. CORROSION IN WHEEL BIN SUPPORTS LH/RH FS 813.70, RBL43 AND LBL43 AT LH/RH MLG WHEEL WELL WAS EVALUATED OUT LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER SDR VNAA2025F00023Channel · corrodedCORROSION IN LH CHANNEL ON STA FS 797.00 AND LBL 34 AT LH MLG WHEEL WELL. CORROSION IN LH CHANNEL ON STA FS 797.00 AND LBL 34 AT LH MLG WHEEL WELL WAS EVALUATED DUE EXCESIVE DAMAGE PER CRJ 900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-900 SRM 51-42-21-001SDR VNAA20251014005Support · corrodedCORROSION ON RH/LH MLG HYDRAULIC LINES SUPPORT PLATE (IN BK, LG EXT, LG RET) ON WHEEL WELL AREA, RBL 45/LBL 45. CORROSION ON RH/LH MLG HYDRAULIC LINES SUPPORT PLATE (IN BK, LG EXT, LG RET) ON WHEEL WELL AREA, RBL 45/LBL 45 WAS EVALUATED EXCESIVE DAMAGE PER CSDR VNAA2025F00021Fan Cowl · dentedDENT TO LH LOWER FAN COWL DOOR OUTER SKIN BETWEEN PSS140.660 AND PSS145.540. DENT TO LH LOWER FAN COWL DOOR OUTER SKIN BETWEEN PSS140.660 AND PSS145.540 WAS REPAIRED PER REO 670-51-00-085 REV. - -, REO 690-54-14-777 REV - - AND REO 670-54-14-1012 REV. B.SDR VNAA2025F00019Angle · corrodedCORROSION ON ANGLE INNER SIDE OF RH LANDING GEAR PRESSURE SWITCH AND SETTLEMENT AREA ANGLE OF ACCESS PANEL 642AZ. CORROSION ON ANGLE INNER SIDE OF RH LANDING GEAR PRESSURE SWITCH AND SETTLEMENT AREA ANGLE OF ACCESS PANEL 642AZ WAS REMOVED PER SRM 51-21-06-00SDR VNAA2025F00016Static Wick · corrodedCORROSION ON SETTLEMENT BASE OF STATIC DISCHARGE WS353.00 AT RH WING. BASE OF STATIC DISCHARGE WS353.00 AT RH WING WAS EVALUATED PER CRJ-900 SRM 53-21-43-101-001-A03 AND REPLACED PER CRJ-900 AMM 23-61-01-400-802-A02.SDR AALA202510108547Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE LOCATED AT PRESSURE DECK MEMBRANE, ON FR36 AND -Y1292 PLUS 7 INCHES TO OUTBOARD, RH SIDE CRACK DEPTH IS: 0.133 INCHES. MAINTENANCE PERFORMED TIME LIMITED REPAIR ON FRAME 36 PRESSURE DECK MEMSDR AALA202510107846Pressure Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND AT FASTENER HOLE LOCATED AT PRESSURE DECK MEMBRANE AT FR36 AND Y1292 PLUS 5 INCHES TO OUTBOARD, LH SIDE CRACK DIRECTION IS 11 OCLOCK. CRACK DEPTH IS 0.147 INCHES . MAINTENANCE PERFORMED TIME LIMITED REPAIR LSDR SWIA2025F01393Fastener · corrodedMULTIPLE CORRODED FASTENERS UNDER PANEL 196AL, 192BB AND 191BB. (C-CHECK RO 09/24/2025)REPAIRED COROSION ON SKIN AND FASTENERS UNDER PANEL LANDINGS 196AL, 192BB, AND 191BB REF CRJ200 SRM 51-21-06. COMPLIED WITH STEPS 1-4 OF REO 601R-53-00-916 REV -- DATED 202SDR SWIA202509250717Stop Fitting · gougedPASSENGER DOOR UPPER PIN STOP FITTING IS GOUGED, FS310.00. (C-CHECK RO 09/24/2025)REPAIRED PAX DOOR UPPER PIN STOP FITTING IAW REO 601R-53-21-3762, REV. --, DATE: 2025-07-25 AND COMPLIED WITH TASK CARD 51-900-1003-SKYSDR IPXA2025091682895Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 6 FROM LOWER APPEAR TO HAVE GOUGES . 89-830 CLEANED AREA AT FWD CREW DOOR STOPS (FROM FWD FACE OF THE DOOR) # 6, AFTHER FURTHER EVALUATION AND REMOVED DAMAGE, ORIGINAL THICKNESS 0.135", REMOVED THICKNESS 0.003SDR IPXA2025091682988Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 7 FROM LOWER APPEAR TO HAVE GOUGES . 89-831 REMOVED AND REPLACED FWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 7 FROM LOWER IAW A300/600 AMM 52-10-31/401.SDR IPXA2025091682897Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 5 FROM LOWER APPEAR TO HAVE GOUGES . 89-829 REMOVED AND REPLACED FWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 5 FROM LOWER IAW A300/600 AMM 52-10-31/401.SDR IPXA2025091683055Stop Fitting · gougedFWD CREW DOOR STOP ( FROM FWD FACE OF THE DOOR ) # 8 FROM LOWER APPEAR TO HAVE GOUGES . 89-832 REMOVED AND REPLACED ADJUSTABLE BOLT FOR DOOR FITTING IAW A300 AMM 52-10-31/401 STEP 2B(2) AND 2D(2). ADJUSTED FWD PASSENGER/CREW DOORS STOP FITTINGS IAW A300 AMM 52SDR IPXA2025090881604Adapter · corrodedCLS ADAPTER AT FR43 Y0 LH HAS CORROSION. COMPLIED WITH EO-94969-REQ1 AND VT-MAE EA 300-5315-27-A4057 REV.-.SDR IPXA2025090881678Adapter · corrodedCLS ADAPTER AT FR40 Y0 RH HAS CORROSION. .COMPLIED WITH EO-94969-REQ1 AND VT-MAE EA 300-5315-27-A4057 REV.-. CASS FEEDBACK REPORT COMPLETED AND FORWARDED TO CASS@UPS.COM. JOB COMPLETESDR AALA202509094530Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE STR 23 R BTW FR69 AND FR70 AT AFT GALLEY AREA MEASURE CRACK IS L=0.500 INCH. MAINTENANCE REPLACED SHEAR PLATE LOC AT STR 23R BTW FR69 AND FR70 AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND DWG D53474180.SDR AALA202509090454Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SHEAR PLATE AT STR23L BETWEEN FR69-FR70 AFT GALLEY AREA. CRACK L= 1.031 IN. MAINTENANCE REPLACED SHEAR PLAET AT STR 23L BETWEEN FR 69 AND FR 70 AFT GALLEY AREA IAW A319 SRM 51-42-11-801 AND D53474180.SDR IPXA2025081681730Adapter · corrodedCLS ADAPTER AT FR38.1 RT OTBD IS BROKEN. COMPLIED WITH REMOVED AND REPLACED CLS ADAPTER IAW PRODUCTION DWR REQUIREMENTS AND SRM CHAPTER 51 REQUIREMENTSSDR IPXA2025090172198Adapter · corrodedCLS ADAPTER AT FR71 IB OF Y1580 HAS CORROSION. REMOVED AND REPLACED CLS ADAPTER IAW PRODUCTION DRAWING REQUIREMENTS AND SRM CHAPTER 51 REQUIREMENTS.SDR SIMA20250717007Floorbeam · corrodedCABIN FLOOR STRUCTURE FR 84 CROSSBEAM IS CORRODED AT NUMEROUS AREAS ALONG ITS ENTIRE LENGTH. (MARKED) SSI 53-23-005. (MAJOR REPAIR) (LEVEL 2 CORROSION). PERFORMED PERMANENT REPAIR TO CABIN FLOOR STRUCTURE FR 84 CROSSBEAM IAW ERS-EJ-53MR-5249.SDR AALA202508292046Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK STIFFENER LOCATED ON FR1 (Z-169 ) FWD FACE FWD PRESSURE BULKHEAD MEASURE OF DAMAGE L: 0.900 INCH. MAINTENANCE REPLACED STIFFENER LOCATED ON FR1 (Z-169) FWD FACE FWD PRESSURE BULKHEAD IAW A319 SRM 51-42-11-801, SRM 51-72-11-9SDR IPXA2025081681753Adapter · brokenCLS ADAPTER AT FR38 LH OB IS BROKEN. COMPLIED WITH REMOVE AND REPLACED 1(EA) CLS ADAPTER P/N B53774136204 PER PRODUCTION DRAWING REQUIREMENTS AND SRM CHAPTER 51 REQIREMENTS.SDR AALA202508261026Bottle · no testAIRCRAFT IN BASE MAINTENANCE: DONT PASS OPERATIONAL TEST OF THE DOOR DAMPING OF DOOR DAMPER ON PASS ENGER CREW DOOR 832 AT AFT GALLEY AREA. MAINTENANCE REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER ON PASSENGER CREW DOOR 832 AT AFT GALLEY AREA IAW AMSDR AALA202508256023Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER 23L CHORD LOCATED FROM BS 334 TO BS 351 AT LBL 42. REPLACED CHORD PER EA 366749.SDR AALA202508255980Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 950, FROM LBL 27 TO LBL 50. REPLACED SUPPORT PER AARD 51-00-05-1.SDR SWAA2025082292523Plate · corrodedCORROSION PLATE AT LEVEL OF STR 25R; BS 794.5 AND WL 156.4 AFT CARGO COMPARTMENT 2025-448168<[01] REPLACED PLATE AT LEVEL OF STR 25R; BS 794.5 AND WL 156.4 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 146A8340 SHEET:24 REV: A<BRSDR SWAA2025082292520Support Channel · corrodedCORROSION CHANNEL SUPPORT AT LEVEL OF STR 25R AND WL 156.4 BTW BS 767 TO BS 794.5 AFT CARGO COMPARTMENT 2025-448166<[01] REPLACED CHANNEL SUPPORT AND FASTENERS AT LEVEL OF STR 25R AND WL 156.4 BTW BS 767 TO BS 794.5 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40SDR SWAA2025082292526Plate · corrodedCORROSION PLATE AT LEVEL OF STR 25R;BS 847 AND WL 156.4 AFT CARGO COMPARTMENT 2025-448171<[01] REPLACED STRAP (PLATE) LOCATED AT LEVEL OF STR 25R;BS BS 827 TO BS 847 AND WL 156.4 AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G-0 ;SRM 51-10-02-0G-0 PARAGRAPHSDR IPXA2025082275437Adapter · wornCLS ADAPTER AT FR57.1 Y0 LH HAS CORROSION. COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94652-REQ1 AND VT-MAE EA 300-5316-27-A4065 REV. - .SDR IPXA2025082275244Adapter · wornCLS ADAPTER AT FR57.1 Y0 RH HAS CORROSION. COMPLIED WITH ACCOMPLISH PERMANENT REPAIR IN ACCORDANCE WITH EO-94652-REQ1 AND VT-MAE EA 300-5316-27-A4065 REV. - .