JASC 5730
Service difficulty reports · 27,279
Reports filed under 5730 · Wing, Plate/Skin, newest first.
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' WHERE jasc_code = '5730' 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' WHERE jasc_code = '5730' 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 DHL2001727521Fairing · looseLEFT O/B FLAP O/B JACKSCREW FAIRING LOOSE. TIGHTENED FAIRING MOUNTING BOLTS PER M/M 57-30-2.SDR EIA2001242Skin · damagedMZJ - FOUND SCREW HOLE WAS FOUND TO HAVE METAL TORN OUT AND EDGE OF METAL BENT ON LEFT WING INBOARD LEADING EDGE 19TH HOLE FROM OUTBOARD END. TRIMMED DAMAGE, HFEC AREA, FABRICATED FILLER AND DOUBLER. INSTALLED PER ECRA 915-57-057-2. (M)SDR AALA20011664Skin · corrodedTUL - FOUND LOWER WING LEADING EDGE SKIN CORRODED AFT OF INBOARD FUEL CAP. INSTALLED DOUBLER PER ESO NR 11697 DATED 8-13-2001. (M)SDR UPS01836748Panel · crackedINSPECTION TYPE:C2 LT UPPER DINEDRAL CRACKED. REMOVED FILLET ATTACH ANGLE IAW DC8 SRM 51-1-20D & 51-1-21. REMOVED DAMAGED AREA. FABBED REPAIR FILLER IAW REO G08337. FABBED REPAIR DOUBLERS IAW TIMCO REO G08337. CUT OUT AREA IAW DC8 SRM 51-1-8. INSTALLED ALL REPSDR AALA20011611Skin · corrodedTUL - FOUND CORROSION IN THE FORM OF A HOLE THROUGH SKIN ON LEFT WING LOWER SKIN L/E JUST INBOARD OF RIB 20. REMOVED CORROSION AND INSTALLED DOUBLER PER ESO30595 DATED 10 AUG 01. (M)SDR MWEA011119Skin · crackedSKIN CRACKED RIGHT WING FORWARD OF INBOARD BUTE DOOR. REMOVED DAMAGED SKIN, FABRICATED, LOCATED AND INSTALLED NEW SKIN.SDR UPS01836701Skin · crackedINSPECTION TYPE:C2,3 LEFT WING L/E SKIN IS CRACKED AT XW 485. REPAIRED SKIN IAW SRM 57-2-1 FIG 2H.SDR UPS01836654Doubler · crackedINSPECTION TYPE:C2,3 LEFT WING L/E INTERNAL DOUBLER IS CRACKED AT XW 257. REMOVED, FABRICATED, AND REPLACED DOUBLER IAW DWG 5769589, AND SRM 51-1-21, 51-1-20D.SDR UPS01836649Doubler · corrodedINSPECTION TYPE:C2,3 RIGHT WING L/E INTERNAL DOUBLER IS CORRODED BEYOND LIMITS AT XFS 366.5. REMOVED, FABRICATED, AND REPLACED DOUBLER IAW DWG 5769589, AND SRM 51-1-21.SDR DHL2001804521Skin · crackedLT WING UPPER SKIN SURFACE SHOWS A 1 INCH CRACK AT STA XLS 421 STL. CUT DAMAGED AREA, FABRICATED AND INSTALLED FILLER AND DOUBLER PER SRM 57-2-1.SDR UPS01836706Skin · damagedINSPECTION TYPE:C2,3 LEFT IB SLOT VANE HAS SCREWS PULLING THRU SKIN AT XILD 7095. REPAIRED SKIN IAW SRM 57-2-1 FIG 2H.SDR RRXA11454Skin · crackedDURING A MAINTENANCE VISIT FOUND RT WING L/E SKIN CRACKED AT STA XFS300. REPAIRED SKIN IAW 8110-3 APPROVED DHSK 873-883SDR UPS01836648Skin · crackedINSPECTION TYPE:C2,3 LEFT WING L/E UPPER SKIN IS CRACKED AT XFS 316.5 AND HAS A ELONGATED HOLE AT XFS 329. REPAIRED SKIN IAW 8110-3 APPROVED DH SK 866-235.SDR UPS01836640Skin · crackedINSPECTION TYPE:C2,3 LEFT WING L/E UPPER SKIN IS CRACKED AT XFS 666.25. REPAIRED SKIN IAW SRM 57-2-1 FIG 38.SDR QXEA0101327Skin · tool damagePDX-TOOL MARKS AROUND FASTENER HOLE ON TRAILING EDGE OF PANEL 624AT 14 INCHES FROM INBOARD AFT CORNER. REPAIRED IAW DHC-8 SRM 51-20-16, SRM 51-20-36, SRM 51-20-26, AND HORIZON AIR EA 2-57-129.SDR UPS01836774Doubler · crackedINSPECTION TYPE:C1,3 LT WING FUEL PANEL 505F INTERNAL DOUBLER IS CRACKED AT XRS 12 AT STRINGER 5-6 AREA ON WING. REPAIRED DOUBLER IAW SRM 57-2-1 FIG 36.SDR UPS01836722Pan · corrodedINSPECTION TYPE:C1,3 RT WING IB SLOT PAN HAS INTERGRANULAR CORROSION AT XS 250. REMOVED AND REPLACED PAN IAW DWG 5769859, AND SRM 51-1-21, 51-3-0.SDR UPS01836531Skin · crackedINSPECTION TYPE:IN LEADING EDGE CRACKED O/B OF NR 3 ENGINE. CRACK LOWER RT LEADING EDGE JUST OUTBD NR 3 ENG, BELOW INBD FIRE BOTTLE ACCESS DOOR. COMING FROM SCREW HOLE APPROX 1/2 INCH LONG. VIS AND PAGE PEN INSP CONFIRMS CRACK APPROX 1/2 INCH AS NOTED. HFEC COSDR UPS01836638Doubler · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E NR 3 STUBWING LOWER DOUBLER IS CRACKED AT OPENING ABOVE PYLON CUTOUT. REMOVED, FABRICATED, AND REPLACED REPAIR DOUBLER IAW SRM 57-2-1A.SDR UPS01836600Skin · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E UPPER SKIN IS CRACKED AT XFS 710. REPAIRED SKIN IAW DC8-5720-7767-A.SDR UPS01836593Skin · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E SKIN IS CRACKED AT XFS 878. REPAIRED SKIN IAW SRM 57-2-1 FIG 2B.SDR UPS01836587Skin · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E LOWER SKIN IS CRACKED AT XFS 597.5. REPAIRED SKIN IAW DC8-5720-7767-A.SDR UPS01836586Skin · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E SKIN IS CRACKED 2 PLACES AT XW 485. REPAIRED SKIN IAW DC8-5720-7767-A, AND SRM 57-2-1 FIG 2H.SDR UPS01836583Skin · crackedINSPECTION TYPE:C1,3 RIGHT WING L/E. LOWER SKIN IS CRACKED AT XFS 841.25. REPAIRED SKIN IAW DC8-5720-7767-A.SDR LR7A01055Panel · corrodedDURING SCHEDULED C2 INSPECTION SCHEDULED REPAIR FOR TIME LIMITED LMAS ENGINEERING DISPOSITON FOR RH CENTER WING LOWER SURFACE, AFT PANEL CORROSION BLENDOUT AT CWS 202-207, FS 575-590.ACCOMPLISHED REPAIR IAW LAC MEA 382-57-01-032. NR 2001.SDR UPS01836598Doubler · crackedINSPECTION TYPE:C1,3 LEFT WING L/E INTERNAL DOUBLER IS CRACKED AT XW 485. REMOVED, FABRICATED, AND REPLACED DOUBLER IAW DWG 5769600, AND SRM 51-1-21,51-1-21A.SDR QXEA0101322Flange · scratchedPDX - SCRATCHES ON TOP SURFACE OF RIGHT WING LEADING EDGE FLANGE AT YW230. REPAIRED IAW DHC-8 SRM 51-20-16, SRM 51-20-26 AND RD 8-57-1675.SDR UPS01836602Skin · crackedINSPECTION TYPE:C1,3 LEFT WING L/E LOWER SKIN IS CRACKED AT XFS 635. REPAIRED SKIN IAW DC8-5720-4087-B.SDR UPS01836594Skin · damagedINSPECTION TYPE:C1,3 LEFT WING L/E UPPER SKIN HAS SCREWS PULLING THRU SKIN AT XFS 883. REPAIRED SKIN IAW SRM 57-2-1 FIG 2H.SDR UPS01836585Skin · crackedINSPECTION TYPE:C1,3 LEFT WING L/E. LOWER SKIN IS CRACKED AT XFS 572.5. REPAIRED SKIN IAW DC8-5720-4087-B.SDR UPS02839252Skin · crackedINSPECTION TYPE:C2 LEFT WING UPPER SKIN IS CRACKED AT XRS 74 AT STRINGERS 9,10,12. REMOVED EXISTING DOUBLER, CUTOUT DAMAGE AT XRS 74 STRINGERS 9,10,12, NDT VERIFIED NO CRACKS AT CUTOUT, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW UPS ENGINEERING FILE NUMBSDR AALA20011584Skin · corrodedTUL - FOUND CORROSION AROUND FASTENER HEAD LOWER SKIN OF WING CENTER SECTION LBL 24 STRINGER 6. REPAIRED PER ESO 11697 DATED 7/31/2001 EXTERNAL DOUBLER. (M)SDR AALA20011583Skin · corrodedTUL - FOUND CORROSION ON LOWER WING SKIN IN AREA OF PREVIOUS REPAIR ABOVE LEFT PRIMARY HEAT EXCHANGER. REPAIRED PER ESO 11697 DATED 7/31/2001 EXTERNAL DOUBLER. (M)SDR ZIAA04001Doubler · crackedFOUND WS 249 LOWER SURFACE, LEAP DOUBLER AT FORWARD EDGE IS CRACKED AT RIGHT WING. ROUTED OUT DEFECTIVE AREA OF LEAP DOUBLER. DYE PEN OF WING PLANK REVEALED NO DISCREPANCIES. REPAIRED IAW L188 SRM 57-2-1 AND SEALED INTERNALLY. (M)SDR ZIAA04003Doubler · crackedFOUND LOWER SURFACE AT WS 265 RIGHT WING LEAP DOUBLER ON PLANK NR 4 IS CRACKED. LEAK CHECK DUE. ROUTED OUT CRACKED LEAP DOUBLER MATERIAL. INSPECTED WING PLANK SURFACE WITH DYE PEN. NO DEFECTS FOUND. REPAIRED PER L-188 SRM 57-2-1, FIG 3, SHEET 30, TYPE 2. SDR ZIAA04002Doubler · crackedYIP - FOUND LWER SURFACE AT WS 253, FORWARD EDGE OF LEAP DOUBLER IS CRACKED, RIGHT WING. CRACK STOP DRILLED, ROUTED OUT DEFECTIVE AREA OF LEAP DOUBELR. DYE PEN OF WING PLANK REVEALED NO DISCREPANCIES. REPAIRED IAW L-188 SRM 57-2-1 AND SEALED INTERNALLY. (MSDR AALA20011466Skin · corrodedTUL - FOUND UPPER WING SKIN CORRODED IN BLACK PAINTED AREA AT EMERGENCY EXIT PATH. BLENDED AREA. FLAPPER PEEN, REINSTALLED FASTENERS. (M)SDR UIEA01084Skin · corrodedDURING INSPECTION, FOUND CORROSION INSIDE THE LEFT WING BOOST PUMP HOUSING AT WS 677 ON THE UPPER WING SKIN SURFACE LIP EXPOSED WITHIN THE HOUSING. CORROSION REMOVED, POLISHED, SHOT PEENED, TREATED AND MEASURED. AREA FILLED IN WITH EPOCAST. ROTART DOOR LATCSDR ZW0A0105805Doubler · crackedDURING CHECK-C MAINT ON LT WING L/E FOUND CRACK AT DOUBLER, INSIDE LOWER L/E OF WING, 3.5 INCHES INBD OF NUMBER 6 TRACK. REPAIRED CRACKED DOUBLER BY INSTALLING REPAIR DOUBLER PER SSRM 57-40-103, FIG 201.SDR QXEA0101229Access Panel · corrodedPDX-ACCESS PANEL 523AT COUNTERSINK HOLES HAVE PITTING CORROSION. REPAIRED IAW DHC-8 RD8-57-1715.SDR QXEA0101200Panel · corrodedPDX - NUMEROUS COUNTER SUNK HOLES ON PANEL 623AT HAVE PITTING CORROSION. REPAIRED IAW RD-8-57-1715.SDR DHL2001747542Skin · corrodedDURING LINE INSPECTION FOUND CORROSION AT LEFT WING FWD LOWER SKIN AT APPROXIMATELY WS 190. REMOVED CORROSION PER B727 SRM 57-10-6 FROM LEFT WING AT APPROXIMATELY WS 190 MATERIAL LOSS .103 INCHES WITHIN LIMITS PER BOEING TELEX DHL-CVG-01-00004H. HFEC INSP ACCOSDR QXEA0101201Skin · chafedPDX - RIGHT-HAND WING UPPER SURFACE HAS LIGHT CHAFING AROUND SCREW HOLES IN AFT ROW OF PANEL 422ET. REPAIRED IAW MM 20-32-02, 20-34-11, PAGES 201-203SDR 2001FA0000218Skin · corrodedON INSPECTION OF RIGHT WING ASSEMBLY, MECH NOTICED THAT A LOT OF RIVETS HAD POPPED FROM CORROSION UNDER THE LEADING EDGE SKIN AT THE FORWARD SPAR. THE WING WAS REMOVED FROM THE AIRCRAFT, BROUGHT TO THIS FACILITY FOR REPAIR. WING WAS DISASSEMBLED FOR REPAIR ASDR MWEA011052Skin · dentedLEFT WING LEADING EDGE HAS EIGHT DENTS BETWEEN XRS 214-267. REMOVED DAMAGED AREAS, FABRICATED AND LOCATED EXTERNAL DOUBLER, FABRICATED INTERNAL FILLER AND DOUBLER, LOCATED AND DRILLED INTERNAL FILLERS AND DOUBLER, INSTALLED EXTERNAL DOUBLER.SDR AUS20010857Skin · corroded(AUS) LT WING LOWER SKIN CORRODED IN AREA BETWEEN RIB 13 AND RIB 15.CORROSION WAS BEYOND ALLOWIABLE LIMITS.SDR RRXA11333Skin · dentedDURING A MAINTENANCE VISIT FOUND DENT DAMAGE TO L/H WING AUX TANK UPPER SKIN AT STA. XFS157-163, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DHSK 60SDR 2001UALA01360Skin · wornLH WING LE SKIN WORN AT NUMBER 2 SLAT CENTER STOP. MAJOR REPAIR ACCOMPLISHED.INSTALLED DOUBLER.SDR ZW0A0105008Skin · puncturedDURING CHECK-C MAINT FOUND PUNCTURE HOLE IN LT WING L/E APPROX 8 INCHES FWD OF FRONT SPAR, 13 INCHES AFT AND OTBD OF NUMBER 1 SLAT ANTI-ICE TUBE ON LT WING L/E. REMOVED ALL DAMAGE AND INSTALLED TYPICAL REPAIR PER SRM 57-06A, PAGE 11, AND SRM 51-01 PARAGRAPH 3SDR DHL2001803561Skin · crackedLT WING L/E LOWER SKIN SURFACE SHOWS 1.500 INCH CRACK AT STA XFS 597.500.
Back to JASC 5730