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 VNAA20251015064Slat Track · chafedRIGHT SLAT TRACK 2-1 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF RH SLAT TRACK 2-1 BY COMPLYING WITH MHIRJ REO 670-57-42-1939 REV--.SDR VNAA20251015063Slat Track · chafedRIGHT SLAT TRACK 1-3 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF RH SLAT TRACK 1-3 BY COMPLYING WITH MHIRJ REO 670-57-42-1940 REV-- DATED 2025-01-29. CC670-12030-1SDR VNAA20251015062Slat Track · chafedRIGHT SLAT TRACK 1-2 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF RH SLAT TRACK 1-2 BY COMPLYING WITH MHIRJ REO 670-57-42-1935 REV--.SDR VNAA20251015061Slat Track · chafedRIGHT SLAT TRACK 1-1 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF RH SLAT TRACK 1-1 BY COMPLYING WITH MHIRJ REO 670-57-42-2008 REV--.SDR FDEA202510162035Skin · damagedBULGE ON PREVIOUS REPAIR, LOWER SURFACE OF OUTBOARD FLAP, AT 20" TO OUTBOARD EDGE AND 4" TO LEADING EDGE. RH WING LOWER SURFACE OF OUTBOARD FLAP AT 20" TO OUTBOARD EDGE AND 4" TO LEADING EDGE WAS REPAIRED I.A.W. SRM 57-53-01-2R FIGURE 201 SHEET 6 TABLE II SDR FDEA202510162033Skin · dentedRH WING OB FLAP LWR SURFACE FOUND DENT AT 99.5 INCHES TO IB EDGE AND 11.5 INCHES TO AFT EDGE. REPAIRED RT WING OTBD FLAP LWR SURFACE DENT AT OTEF STA 99.5 IAW SRM 57-53-01-2R-2, & SRM 51-70-04-2R-1, REV 51.0 AND EA:G-5750-T0385311 P1. MAJOR REPAIR PER GMM 6SDR FDEA202510162032Floor Panel · delaminatedCABIN LEFT HAND FLOOR PANEL 231CF AT BS 495 TO 595 BETWEEN X=27.5 TO X=47.25 ACCESS CUT OUT FOUND DELAMINATED. REMOVED AND REPLACED AS PER AMM 53-25-04-4. FLOOR PANEL 231CF FABRICATED IAW DRAWING SRZ-25-005 REVISION R. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-SDR FDEA202510162031Seat Track · wornCABIN-SEAT TRACK AT STAION 1275 X= -8.5 FOUND CROWN WORN. SEAT TRACK BS 1275 X= -8.5 CROWN EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT AT CABIN FROM BS 1264 TO BS 1313SDR FDEA202510162030Seat Track · wornSEAT TRACK BS 1275 X= 8.5, FOUND THE CROWN WORN. THE SEAT TRACK CROWN WAS EVALUATED & FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R, FIGURE 201, REPAIR 1.SDR FDEA202510162029Seat Track · wornSEAT TRACK AT STATION 1541 X= -8.5 FOUND CROWN WORN. SEAT TRACK STATION 1541 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 SECTIONAL REPLACEMENT AT CABINSDR FDEA202510162028Seat Track · wornSEAT TRACK AT STATION 1661 X= -8.5 FOUND CROWN WORN. SEAT TRACK STATION 1661 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 SECTIONAL REPLACEMENT AT CABINSDR FDEA202510162027Seat Track · wornSEAT TRACK AT BS 1801 X= -8.5 FOUND CROWN WORN. SEAT TRACK BS 1801, X= -8.5 WORN CROWN EVALUATED & FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT AT CABIN FROM EXISTING SPLICESDR FDEA202510162026Seat Track · wornSEAT TRACK AT STATION 1661 X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1661 X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT IAW SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT AT CABIN FRSDR FDEA202510162025Seat Track · wornSEAT TRACK AT STATION 1661 X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1661 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 SECTIONAL REPLACEMENT ATSDR FDEA202510162024Seat Track · wornSEAT TRACK AT STATION 1541 X= 8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1541 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 SECTIONAL SEAT TRACK REPSDR FDEA202510162023Seat Track · wornSEAT TRACK AT STATION 5-10 X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 5-10 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 SECTIONAL SEAT TRACK RSDR FDEA202510162022Seat Track · wornSEAT TRACK AT BS 1421 X= -47.5 FOUND CROWN WORN. SEAT TRACK CROWN EVALUATED & FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R, FIGURE 201, REPAIR 1. REPAIR SDR FDEA202510162021Seat Track · wornSEAT TRACK AT STAION 1275 X= -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1275 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 SECTIONAL SEAT TRACK SDR FDEA202510162020Seat Track · wornSEAT TRACK AT BS 1275 X= 27.5, FOUND THE CROWN WORN. THE SEAT TRACK CROWN WAS EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT FROM BS 1247 TO BS 1331IAW SRM 53-00-5SDR FDEA202510162019Seat Track · wornCABIN-SEAT TRACK AT STAION 1421 X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1421, 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 SECTIONAL SEAT TSDR FDEA202510162018Seat Track · wornSEAT TRACK AT STATION 1401 X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1401, 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 SECTIONAL SEAT TRACKSDR FDEA202510162017Seat Track · wornSEAT TRACK AT STATION 879 X= 47.5 FOUND CROWN WORN. SEAT TRACK STATION 879, 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 SECTIONAL REPLACEMENT AT CABIN SDR FDEA202510162016Seat Track · wornSEAT TRACK AT STATION 879 X= -8.5 FOUND CROWN WORN. SEAT TRACK STATION 879 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 SECTIONAL REPLACEMENT AT CABIN STSDR FDEA202510162015Seat Track · wornSEAT TRACK AT STATION 879 X= -27.5 FOUND CROWN WORN. SEAT TRACK STATION 879 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 SECTIONAL REPLACEMENT AT CABINSDR FDEA202510162014Longeron Splice · corrodedLOWER CENTER CARGO BAY BILGE AREA LONGERON 52 EXISTING REPAIR SPLICE FITTING FOUND WITH CORROSION AT BS 1691. CORROSION ON LONGERON 52, BS 1701 AND EXISTING REPAIR SPLICE FITTING AT BS 1691, LONGERON-52 AT LOWER CENTER CARGO COMPARTMENT BILGE AREA EVALUATED SDR VNAA20251015060Skin · chafedDISCREPANCY:R/H AILERON LOWER SKIN CHAFED WS 348.00 TO WS 353.00 CORRECTIVE ACTION: SERVICEABLE PART P/N CC670-13054-2 DRILLED UP AND INSTALLED IAW CRJ 700 SRM TASK 51-42-06-001-001-A01, AND SRM TASK 51-42-21-001-001-A01 CC670-13054-2SDR VNAA20251015059Vane · gougedRIGHT OUTBOARD FLAP VANE LEADING EDGE HAS AN APPROXIMATELY 4" LONG GOUGE FROM CONTACT WITH BUCKTAIL ON TRAILING EDGE OF WING AT WS 231.23. COMPLIED WITH REO 670-57-53-395 REV --.SDR VNAA20251015058Slat Track · chafedLEFT SLAT TRACK 3-3 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LH SLAT TRACK 3-3 BY COMPLYING WITH MHIRJ REO 670-57-42-1964 REV--.SDR VNAA20251015057Slat Track · chafedLH SLAT TRACK 2-3 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LH SLAT TRACK 2-3 BY COMPLYING WITH MHIRJ REO 670-57-42-1953 REV -.SDR VNAA20251015056Slat Track · chafedLEFT SLAT TRACK 2-3 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LT SLAT TRACK 2-3 BY COMPLYING WITH MHIRJ REO 670-57-42-1953 REV -.SDR VNAA20251015055Slat Track · chafedLEFT SLAT TRACK 2-2 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LT SLAT TRACK 2-2 BY COMPLYING WITH MHIRJ REO 670-57-42-1943 REV -.SDR DALA2025101607577Shear Tie · damagedTOOLING DAMAGE FOUND ON FWD SIDE OF SHEAR TIE AT FR29 BETWEEN P' 6 AND P'7. REPAIRED PER ERA 628177-14 REV ORIG. (1254516)SDR DALA2025101607576Seat Track · miscompareEXISTING FASTENER HOLES COUNTERSINKING DOES NOT MATCH. REPAIRED PER ERA 629699-14AD REV ORIGINAL. (1254830)SDR DALA2025101607575Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y659 BETWEEN FR 73 AND FR 74. REPLACED SEAT TRACK AT FR72 TO FR74 Y659 PER DWG: 10N00242 SH02 REV.A AND A330 SRM 51-72-11. (1254512)SDR DALA2025101607574Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1552.5 BETWEEN FR 37 AND FR 37.1. REPLACED SEAT TRACK PER ERA 629412-14 REV ORIGINAL. (1254491)SDR VNAA20251015054Slat Track · chafedLEFT SLAT TRACK 2-1 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LT SLAT TRACK 2-1 BY COMPLYING WITH MHIRJ REO 670-57-42-1941 REV -.SDR VNAA20251015053Slat Track · chafedLEFT SLAT TRACK 1-3 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LT SLAT TRACK 1-3 BY COMPLYING WITH MHIRJ REO 670-57-42-1938 REV -.SDR VNAA20251015052Slat Track · chafedLEFT SLAT TRACK 1-2 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LH SLAT TRACK 1-2 BY COMPLYING WITH MHIRJ REO 670-57-42-1936 REV -.SDR VNAA20251015051Slat Track · chafedDISCREPANCY: LH SLAT TRACK 1-1 HAS MULTIPLE CHAFES ALONG THE LENGTH OF THE TRACK. PERFORMED MAJOR REPAIR OF LH SLAT TRACK 1-1 BY COMPLYING WITH MHIRJ REO 670-57-42-2009 REV -.SDR KCSA202510161214Shear Web · corrodedMAIN DECK SHEAR WEB PANEL # 152W1209-21, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSIONSDR KCSA202510161213Shear Web · corrodedMAIN DECK SHEAR WEB PANEL # 152W1209-20, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSIONSDR QR9R2025101600001Display · warning lightON START RUN-UP, RIGHT MASTER CAUTION LIGHT CAME ON WITH NO CAD INDICATION AND WOULD NOT RESET. REMOVED AND REPLACED CAD V2006; T/P MOC SUCCESSFULLY COMPLETED.SDR YENA2025101601041Valve · faultedFLT#1178, LAS-BOS. (ETOPS) CR 2 ALERT (APPROVAL REQUIRED FOR RESOLUTION) ENG 2 TURB COOL FAULT AFTER LANDING ( TCC/TACC VALVE ); REMOVED AND REPLACED ENG 2 TURBINE CASE COOLING AIR VALVE IAW AMM 75-24-01. OPS CK GOOD. PLACARD REMOVED, MX-4 UPDATED, MCC NOTIFISDR N6WA2025101601Seat Track · corrodedCORROSION ON SEAT TRACK AT LBL27 BETWEEN FS364.00 AND FS485.00. REMOVE AND REPLACED SEAT TRACKS ON LBL27 BETWEEN FS364.00-FS485.00 IAW CRJ AMM 53-00-49SDR DALA2025101607572Apu · odorMUSTY ODOR ON FLIGHT DECK AS WE DESCENDED TO 4000' MIL. SEEMED TO GO AWAY BUT RETURNED AFTER LANDING. REPLACED APU. (LP 7781910, 1252891)SDR DALA2025101607571Fitting · corrodedCORROSION CENTER FITTING LOCATED BTW FR66 TO FR68 AT LEVEL STR23L AFT GALLEY AREA. REPLACED CENTER FITTING LOC. ON BTW FR66 TO FR68 STR23L AFT GALLEY AREA AS PER A321 SRM 51-42-11, A321 SRM 51-72-11 AND DWG D53480505. (LP 1254855)SDR DALA2025101607570Lens · brokenBROKEN LENS EXIT SIGN IN DOOR FRAME DOOR L3 AND DOOR FRAME DOOR L4 AT PASSENGER CABIN. REPLACED LENS EXIT SIGN IN DOOR FRAME DOOR L3 AND DOOR FRAME DOOR L4 AT PASSENGER CABIN AS PER A320 FAM AMM 33-51-13-000-001-A STEP 4.A(1)(A) AND AS PER A320 FAM AMM 33-51SDR KCSA202510161212Shear Web · corrodedMAIN DECK SHEAR WEB PANEL 152W1209-23, HAS SEVERAL AREAS WITH EVIDENCE OF CORROSIONSDR KCSA202510161211Support · crackedR/H A/C BAY DOOR ( PANEL # 196ER) AFT LATCH SUPPORT STRUCTURE CHAFFINGSDR VNAA20251015050Drag Angle · crackedVERTICAL STAB RH DRAG ANGLE IS CRACKED (PREVIOUSLY REPAIRED AREA) CORRECTIVE ACTION: REPAIRED RH DRAG ANGLE IAW MHIRJ REO 670-55-31-188 REV -- DATED: 2025-03-04 AND BOMBARDIER REO 670-55-31-018 REV -A DATED: 2016-11-10.