JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 ASAA0080622Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT SHEAR-TIE AT STA 1231, LONGERON 30 TO LONGERON 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080623Longeron · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT LONGERON 30 WAS FOUND CORRODED ON THE LOWER SURFACE OF THE FLANGE AT STA 1200. REPAIRED PER EA 5310-01861. (X)SDR AALA20001590Shear Tie · damagedTUL - SKIN BULGED ON THE BELL FRAME FORWARD END OF INTERCOSTAL MARKED STA 1050, STR 27L. INSTALLED NEW SHEAR TIE PER SRM 51-30-2. (X)SDR 20001106SH017Doubler · misdrilledDURING C-CHECK, FOUND CORROSION AND MISLOCATED HOLES IN CARGO DOOR JAMB, AFT. (X)SDR 20001106SH016Door Frame · misdrilledDURING C-CHECK, FOUND CORROSION AND MISLOCATED HOLES IN CARGO DOOR JAMB, AFT. (X)SDR ASAA0080597Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE SHEAR TIE AT STA 1287, LONGERON 27L TO LONGERON 27R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080599Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE SHEAR TIE AT STA 1307, LONGERON 26L TO LONGERON 30 WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080601Shear Tie · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT SHEAR TIE AT STA 1218 BETWEEN LONGERONS 29L AND 29R WAS FOUND CORRODED. REPAIRED PER SRM. (X)SDR ASAA0080608Structure · corrodedPHX - DURING SCHEDULED C-CHECK, THE AFT CARGO COMPARTMENT STA 1075, LONGERON 28R, BOTTOM SIDE WAS FOUND CORRODED. REPAIRED PER EA 5310-01856. (X)SDR QXEA0002702Fastener · damagedPDX- STRINGER 25 BETWEEN FRAMES 16060 AND 16660 HAS FIFTEEN RIVETS TOENAILED OR PANCAKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002701Fastener · damagedPDX- STRINGER 26 BETWEEN FRAMES 16060 AND 16660 HAS TEN RIVETS TOENAILED OR PANCAKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002700Fastener · damagedPDX- BETWEEN STRINGER 26 AND 27, AND BETWEEN FRAMES 16060 AND 16660, SIX RIVETS PANCAKED AND ONE RIVET UNDERSHOT. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002699Fastener · damagedPDX- STRINGER 27 BETWEEN FRAME 16060 AND 16660, ONE RIVET HAS INSUFFICIENT BUCKTAIL AND ONE RIVET PANCAKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002698Fastener · damagedPDX- STRINGER 58 BETWEEN FRAME 16060 AND 16660 HAS FIVE TOENAILED BUCKTAILS. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002697Fastener · damagedPDX- STRINGER 29 BETWEEN FRAMES 16060 AND 16660 HAS 1 RIVIT PANCAKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002696Fastener · damagedPDX- STRINGER 30 BETWEEN FRAMES 16060 AND 16660 HAS RIVETS PANCAKED. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0002695Fastener · damagedPDX- STRINGER 31 BETWEEN FRAMES 16060 AND 16660 HAS RIVETS PANCAKED AND 1 RIVET TOENAILED. REPAIRED IAW FOKKER SRM 51-31-01.SDR SWAA001749Shear Tie · crackedDURING SCHEDULED D-CHECK AT DALFORT, FOUND SHEAR TIE CRACKED AT BS 847, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA001753Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STUB FRAME AT FWD ENTRY LOWER DOOR OPENING, BS 294.5. REPAIRED STUB FRAME PER SRM.SDR SIMA27316Beam · corrodedSBP - INTERCOSTAL BELOW LEFT GALLEY CORRODED. MAINTENANCE REMOVED AND REPLACED INTERCOSTAL IAW SAAB SRM. (X)SDR UPS00434219Window Post · corrodedINSPECTION TYPE:C, (P/N 65B807077-07) WINDOW FRAME BETWEEN STA 620 - 640, STR 9 - 10 LT SIDE CORROSION WAS FOUND ON THE EXTERNAL SURFACE. TIME LIMITED REPAIR ACCOMPLISHED PER B747 SRM 56-20-07 FIG 7 IAW 1A1 EO MF-MAN-B47-56-00-89340 AS APPROVED FAA FORM 8110-SDR QXEA0002817Clip · crackedPDX- AFT CARGO PIT AT FRAME 13815B AT STRINGER NR 2 FRAME CLIP CRACKED. REPAIRED IAW FOKKER SRM 51-31-01 PAGE 13.SDR QXEA0002597Flange · crackedPDX- FLANGE ON AUXILIARY STRUCTURE/BEAM IS CRACKED AT AFT FLANGE LOCATED AT FRAME 5305 AND STRINGER 18. REPAIRED IAW FOKKER SRM 51-31-01 AND 51-11-04.SDR ABXA000485Door Frame · corrodedCORROSION ON INNER CHORD OF NR THREE AFT CARGO BEAM. REPAIRED CORROSION IAW ABX REA 652-37474MR. (X)SDR QXEA0002600Clip · crackedPDX- CRACKED CLIP AT FRAME 5805 AND STRINGER 39. REPAIRED IAW FOKKER SRM 51-10-04, 51-31-01 AND 53-02-13 PAGE 4.SDR PCAA0009061Structure · crackedMDT- DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED OVER A PREVIOUS REPAIR AT FRAME 4 IN APU AREA. CRACK WAS REPAIRED IN ACCORDANCE WITH REPAIR DRAWING RD8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR AALA20001540Structure · damagedTUL - FOUND FS 1148 DAMAGED .5 INCH BY .5 INCH, AFT CARGO. FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-10-3 FIG 1. (M)SDR USAA001516Door Frame · crackedCLT - FOUND FRAME CRACKED .25 INCH, FORWARD SERVICE DOOR FORWARD FRAME AT OUTBOARD LOWER CORNER. REPLACED FRAME PER SRM 51-40-00 AND 51-10-2. (M)SDR UPS00833761Beam · corrodedINSPECTION TYPE:C123 A PITT CROSSLIDE DOOR FRAME/BEAM IS CORRODED BEYOND LIMITS AT STA. 330 LONG. 22R ON DOOR REPAIRED FRAME I.A.W. SRM. 52-2-0 FIG. 2SDR GAIA00587Angle · corrodedDISCREPANCY: DURING HEAVY CHECK FOUND: HORIZONTAL ANGLE CORRODED ON 950 BULKHEAD CLOSURE LBL70 WL165. CORRECTIVE ACTION: REMOVED & REPLACED HORIZONTAL ANGLE IAW B727 SRM 51-30-5 & 51-30-2SDR AWXA0000633Door Frame · crackedC-CHECK, CRACK INSIDE R-1 DOOR FRAME AT NR 4 DOOR STOP FROM TOP, EXTENDS PAST STOP DRILL. STOP DRILLED CRACK, FABRICATED DOUBLER AND FILLER, INSTALLED REPAIR PARTS IAW 737 SRM 52-40-3 AND 51-10-1.SDR F3LA00235Structure · crackedDURING C-2 CHECK, INSPECTION REPORTED CRACK IN FORWARD PRESSURE BULKHEAD FLOOR STRUCTURE NEXT TO INTERCOSTAL WL 207, RBL 27. MAINTENANCE INSTALLED NEW WEB PER SRM 51-30-2. (M)SDR F3LA00234Structure · crackedDEN - DURING C-2 CHECK, INSPECTION REPORTED CRACK IN FORWARD PRESSURE BULKHEAD FLOOR STRUCTURE NEXT TO INTERCOSTAL, WL 207, LBL 27. MAINTENANCE INSTALLED NEW WEB PER SRM 51-30-2. (M)SDR QXEA0002512Structure · crackedYXX- CRACKS FOUND ON LEFT HAND NOSE LANDING GEAR BOX STATION X97.0, Y12.5 AND Z110.0. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5, 51-30-21, AND DHC-8 RD 8-53-1676.SDR PCAA0009060Structure · crackedMDT- DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 IN APU AREA. CRACK WAS REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR GAIA00612Shear Tie · damagedDISCREPANCY: DURING HEAVY CHECK FOUND: REMOVE 2 EACH SHEAR TIE STA 1110 BETWEEN STR 17L & 19L AND 2 EACH SHEAR TIE STA 1130 BETWEEN STR 17L & 19L. CORRECTIVE ACTION: REPLACED SHEAR TIES IAW B727 SRM 51-20-1 & 51-30-2SDR GAIA00594Verical Web · drill/holesDISCREPANCY: During heavy check found: Vertical web from Sta 1090R to 1142R at C-3 door cut out has drill starts & open holes in webCORRECTIVE ACTION: Vertical web found to be out of limits IAW B727 SRM 53-10-1. Removed web IAW B727 SRM 51-30-2. Fabricated newSDR GAIA00592Floor Support · corrodedDISCREPANCY: DURING HEAVY CHECK FOUND: FLOOR SUPPORT CORRODED ON TOP FLANG STA 298 & LBL13 CONTINGUING AFT PILLOWING FLOOR SKIN STA 304. CORRECTIVE ACTION: REMOVE, FABRICATED & INSTALLED ANGLE & FLOOR SUPPORT STA 298 LBL13 51-20-1, 51-30-2, 51-30-5SDR GAIA00588Angle · gougedDISCREPANCY: DURING HEAVY CHECK FOUND: FRAME TO INTERCOASTAL CLIP AT STA 1090 STR 25R HOLES DAMAGED & SEVERLY GOUGED. CORRECTIVE ACTION: REMOVED & FABRICATED NEW CLIP IAW 51-30-2 & 51-20-1 INSTALLED CLIP IAW B727 51-30-2SDR MWEA00775Shear Tie · crackedMKE - FOUND SHEAR TIE CRACKED AT FRAME FS 977, LONGERON R14. REMOVED AND FABRICATED NEW SHEAR TIE. LOCATED, DRILLED, AND INSTALLED. (M)SDR MWEA00777Shear Tie · misinstalledMKE - FOUND SHEAR TIE AT FS 908 HAD TWO EACH INSTALLED RIVETS WITH NO EDGE DISTANCE AT LONGERON R8. REMOVED, FABRICATED NEW SHEAR TIE SECTION AND SPLICE, LOCATED, DRILLED, AND INSTALLED. (M)SDR AALA20001516Frame · crackedTUL - FOUND CRACK IN TOP AFT CORNER OF WINDOW FRAME RIGHT SIDE STATION 1060. INSTALLED REPAIR PE AARD 53-10-00-25. (M)SDR AALA20001515Frame · crackedTUL - FOUND CRACK IN BOTTOM FORWARD CORNER OF WINDOW FRAME RIGHT SIDE STATINO 1060. INSTALLED REPAIR PER AARD 53-10-00-25. (M)SDR AALA20001514Frame · crackedTUL - FOUND CRACK IN BOTTOM FORWARD CORNER OF WINDOW FRAME RIGHT SIDE STATION 1022. INSTALLED REPAIR PER AARD 53-10-00-25. (M)SDR AALA20001513Frame · crackedTUL - FOUND CRACK IN TOP AFT CORNER OF WINDOW FRAME RIGHT SIDE STATION 1022. INSTALLED REPAIR PER AARD 53-10-00-25. (M)SDR AALA20001512Frame · crackedTUL - FOUND WINDOW FRAME CRACKED AT FASTENER FORWARD TOP CORNER LEFT SIDE AT STAITON 946. CUT OUT CRACKED AREA AND INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR AALA20001511Frame · crackedTUL - FOUND CRACK IN TOP AFT CORNER OF WINDOW FRAME RIGHT SIDE STATION 1098. CUT OUT CRACKED AREA AND INSTALLED DOUBLER PER AARD 53-10-00-25. (M)SDR QXEA0002537Door Frame · corrodedYXX- LEFT HAND EMERGENCY EXIT LOWER SILL STRUCTURE AT STATION X366.0 HAS CORROSION ON INTERNAL FRAMES. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-10, AND SRM 51-20-00, PAGE 5.SDR QXEA0002536Door Frame · corrodedYXX- RIGHT HAND EMERGENCY EXIT LOWER SILL STRUCTURE AT STAION X370 HAS CORROSION ON INTERNAL FRAME. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-10, AND SRM 51-20-00, PAGE 5.SDR 00FDEA00624Shear Tie · corrodedBS 700, LBL 10, WL 149 SHEAR TIE ON THE AFT SIDE HAS CORROSION ON IT. *S/D* REMOVED AND REPLACED SHEAR TIE IAW BOEING DWG 65-15938, FEDEX SRM 51-20-1 AND 51-30-2.
Back to JASC 5310