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 COMA0160961Post · crackedTHE OUTBOARD LOWER POST AT RBL 18.0, FS 409 + 128 IS CRACKED (LOWER AFT CORNER).REMOVED DAMAGED AREA AND REPAIRED I/A/W WVAC E.O. 601R-53-2874.SDR GTIA020175Door Frame · corrodedFTW - MID LOWER CARGO COMPARTMENT CORRODED AT LOWER DOOR JAMB CUTOUT FROM STATION 693 TO 636. AREA FOUND TO BE OUT OF LIMITS. FABRICATED DOOR JAMB STRAP. REMOVED OLD DOOR JAMB STRAP. INSTALLED STRAP IAW SRM MD80 51-30-5. (M)SDR GTIA020170Structure · corrodedFTW - MID LOWER CARGO COMPARTMENT CORRODED AT STATION 693 TO STATION 674 AT 655. REMOVED CORROSION. TEE ANGLE IAW MD80 SRM 51-30-2 AND 51-30-1. (M)SDR USAA011385Latch · corrodedCLT - FOUND DOOR LATCH BRACKET CORRODED 3 INCHES BY 3 INCHES, BS 600, FORWARD CARGO DOOR SILL. REPLACED PER SRM 51-10-00. (M)SDR EISA20010145Angle · corrodedANGLE IN R/H W/W CORRODED, BS 870 RBL 48.0FOUND DURING CPCP C53-100-01 PAGE 1, N/R CARD 411 WRITTENCORRECTIVE ACTION:REMOVED ANGLE, FABRICATED NEW ANGLE FROM 7075-T6-063 AND INSTALLED IAW B727 SRM 51-30-2.SDR EISA20010144Stiffener · corrodedVERTICAL STIFFENER CORRODED BS 336 RBL 14.6 BELOW FLOOR PAN.FOUND ON CPCP C53-111-03 PAGE 4, N/R CARD 405 WRITTENCORRECTIVE ACTION:REMOVED AND REPLACED STIFFENER IAW B727 SRM 51-30-2.SDR EISA20010140Panel · corrodedNOSE W/W PANEL BS 330 TO 350 STR L27 CORRODEDFOUND ON CPCP C53-100-01 PAGE 1, N/R CARD 444 WRITTENCORRECTIVE ACTION:REMOVED CORROSION IAW B727 SRM 51-10-6 FABRICATED REPAIR IAW 51-40-2 AND INSTALLED REPAIR IAW B727 SRM 51-40-2 & 51-30-2.SDR EISA20010139Skin · crackedFUSELAGE SKIN BS 211, STR 25R GOUGED AND CRACKED AT FWD E/E DOOR CUTOUT.FOUND ON SERVICE CHECK--N/R CARD 431 WRITTENCORRECTIVE ACTION: STOP DRILLED CRACK IAW B727 SRM 51-10-1. DYE PEN. IAW BOEING S.O.P. 20-50-2. FABRICATED REPAIR DOUBLER AND INSTALLED IAW B7SDR EISA20010138Skin · corrodedFUSELAGE SKIN CORRODED AT BS 336, STR 25R.WRITTEN FROM NON-ROUTINE CARD 405 FROM CPC C53-111-03 PAGE 4--N/R CARD 435 WRITTENCORRECTIVE ACTION:REMOVED DAMAGED SKIN, HFEC AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW EA. 53-01630-1, BOEING MESSAGE EOI-DAL-1-00SDR SIMA200201704Door Frame · corrodedLEVEL 2 CORROSION ON BEAM BENEATH LOWER BAGGAGE DOOR CUT OUT PLATE. REPLACED LOWER BAGGAGE DOOR CUTOUT FRAME IAW EMB 145 SRM 51-40-02. (M)SDR QXEA0102117Shear Tie · crackedPDX - FUSELAGE FRAME 16060 TIE-IN CLIP TO SKIN IS CRACKED THROUGH RIVET HOLE AT STRINGER 31. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2 AND SRM 51-31-01.SDR QXEA0102116Shear Tie · crackedPDX - FUSELAGE FRAME 16660 TIE-IN CLIP TO SKIN IS CRACKED THROUGH RIVET HOLE AT STRINGER 32. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2 AND SRM 51-31-01.SDR QXEA0102115Shear Tie · crackedPDX - FUSELAGE FRAME 16660 TIE-IN CLIP TO SKIN IS CRACKED THROUGH RIVET HOLE AT STRINGER 29. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 4, FIGURE 2 AND SRM 51/31/01.SDR QXEA0102075Shear Tie · crackedPDX - FRAME TO SKIN CONNECTION ANGLE BRACKET CRACKED AT FRAME 17565 AND STRINGER 15. REPAIRED IAW FOKKER SRM 53-02-13, PAGE 5 AND SRM 51-31-01, PAGE 13.SDR GTIA012268Door Frame · corrodedFTW - AFT PIT DOOR CUT OUT PANEL HAS CRACK CORROSION AND DIRTY. FABRICATED LOCATED AND DRILLED UP DOUBLER. INSTALLED REPAIR DOUBLER PER MD80 SRM SRM 51-30-2. (M)SDR ASAA0110656Shear Tie · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 520, STRINGER 4R-5R CRACKED. REPAIRED SHEAR TIE PER SRM. (M)SDR 01FDEA01041Bulkhead · corrodedSNRM 539 RMLG W/W FWD BULKHEAD & CTR TANK UPR AFT CHORD WITH PANEL CORRODED. ** S/D ** COMINGSDR QXEA0102067Window Post · scratchedPDX - LT NR 2 WINDOW POST HAS SCRATCH ON INSIDE SURFACE, 2.3 INCHES FROM BOTTOM OF AFT EDGE. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 5, PARAGRAPH 3E (1) AND SRM 51-10-04.SDR QXEA0102061Window Post · gougedPDX - LT NR 2 WINDOW POST HAS SEVERAL GOUGES AND SCRATCHES ON BOTTOM INSIDE SURFACE. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 5, PARAGRAPH 3E (1) AND SRM 51-10-4.SDR SWAA013282Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR CUTOUT AFT FRAME WEB CRACKED AT UPPER DOOR STOP FITTING. REPAIRED FRAME PER SWARA.SDR SWAA013277Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND WEB CRACKED AT BS 178, LBL 17.1 AND WL 183. REPAIRED WEB PER SRM.SDR SWAA013276Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 663.5, STR 4R. REMOVED AND REPLACED STR TIE CLIP PER SRM.SDR MWEA011478Frame · crackedCANTED FRAME 1485, AFT ACCESSORY COMPARTMENT HAS A 5/8 INCH CRACK AROUND A FASTENER LOCATED APPROXIMATELY 6 INCHES OUTBOARD OF EMERGENCY LIGHT CLUSTER -- STOP DRILLED CRACK, FABRICATED, LOCATED AND DRILLED UP DOUBLER. INSTALLED REPAIR.SDR MWEA011477Pan · corrodedFORWARD CARGO COMPARTMENT AIRCRAFT DOOR JAMB BOTTOM HAS 3 AREAS OF CORROSION-BOTH DOOR STOP FITTINGS AND ONE SPOT IN BETWEEN -- REMOVED EXTERNAL SCUFF PLATE AND FLOOR BOARD SUPPORTS TO FACILITATE OTHER MAINTENANCE. REMOVED LOWER PAN SECTION. INSTALLED SCUFF SDR GTIA020208Door Frame · crackedFTW - FOUND OVERWING EMERGENCY EXIT RIGHT AFT LOWER DOOR FRAME CRACKED. REMOVED FITTING. INSTALLED FITTING IAW MD80 SRM 51-30-2. (M)SDR ASAA0110649Stop Fitting · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND AFT GALLEY DOOR STOP P/D FITTINGS (P/N'S 69402882, 651823928) CORRODED. REMOVED AND REPLACED AFT GALLEY DOORSTOP P/D FITTINGS PER SRM. (M)SDR 0104879864Bracket · crackedDuring Mck in ATL, a .25" crack was found to the RHS bracket 9957860-6. Material 7075-t6 AL. Repaired per EA 98-185364SDR 0104859864Pressure Panel · crackedDuring M ck in ATL, cracks were found in the flight compartment horizontal pressure panel at sta 105. Located at x=25 .5"long and x=35 .5"long. Repaired per EA 98-185344. Material .040" 2024-t3 AL.SDR 2001UALA02366Shear Tie · damagedSTATION 1006 SHEAR TIE BETWEEN STRINGER 11L AND 12L NICKED OUTSIDE RADIUS. MAJOR REPAIR ACCOMPLISHED, FABRICATED NEW SHEAR TIE AND REPAIRED.SDR SWAA013251Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME SHEAR TIES CRACKED (2 EA) AT BS 360 BETWEEN STRS 13L AND 15L. REPAIRED SHEAR TIES PER SRM.SDR AALA20012128Door Frame · corrodedTUL - FOUND CORROSION ON SEVERAL AREAS OF AFT CARGO DOOR BEAM. REMOVED AND REPLACED AFT CARGO DOOR BEAM PER SRM 51-01. (M)SDR 2002F00333Structure · corrodedDURING C-CHECK, THE FORWARD LT AIR CONDITIONING BAY CAP ANGLE AT STATION 595 BETWEEN LONGERON 47L AND 48L WAS CORRODED PAST SRM LIMITS. A REPAIR DOUBLER WAS INSTALLED ON THE EXTERIOR OF THE SKIN TO REINFORCE THE BLEND AREA. THE AIRCRAFT WAS RETURNED TO REVENSDR 2002F00331Structure · corrodedDURING C-CHECK, THE LEFT NOSE WHEEL WELL CHORD VERTICAL LEG WAS FOUND CORRODED AND BLENDED JUST PAST SRM REPAIRABLE LIMITS. A REPAIR ANGLE WAS INSTALLED IAW TIMCO REO-G08344 REV IR AND REO G8336 REV IR. THE AIRCRAFT WAS RETURNED TO REVENUE SERVICE. (M)SDR 2001UALA02350Door Frame · crackedFORWARD GALLEY DOOR CUTOUT FORWARD LOWER STUB FRAME HAS 2 EACH CRACKS JUST ABOVE FLOOR LEVEL AT STATION 294 RBL 55. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE. FILLER AND FORMED SECTION REPAIR INSTALLED.SDR SWAA013224Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234 AND LBL 10. REPAIRED WEB PER SRM.SDR SWAA013226Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 767, STR 11R. REMOVED AND REPLACED TIE CLIP PER SRM.SDR MWEA011463Skin · crackedEXTERIOR SKIN IS CRACKED AT STATION 818, LONGERON 19 RIGHT, BETWEEN EXISTING DOUBLER AND SKIN BUTT SPLICE -- REMOVED, STOP DRILLED AND INSTALLED REPAIR.SDR MWEA011464Skin · crackedEXTERIOR SKIN IS CRACKED AT STATION 815 LONGERON 17 RIGHT -- CUT OUT DAMAGED AREA. FABRICATED AND INSTALLED REPAIR.SDR 0104799967Pressure Panel · crackedDuring Hck in ATL, a .25" crack was found in the flight compartment horizontal pressure panel at station 105. The crack is located at x=-25. This EA authorizes accomplishment of repair. Material .040" 2024-t3 AL. Repaired per EA 99-185345.SDR SWAA013206Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 827 TO BS 847. REPAIRED CREASE BEAM WEB SECTION PER SRM.SDR SWAA013216Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, WL 226 AND RBL 17.1. REMOVED AND REPLACED WEB PER SRM.SDR SWAA013215Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND HORIZONTAL WEBS CRACKED (2 EA) AT BS 179, WL 207, LBL 27.0 AND RBL 27.0. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA013213Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, STR 26R. REPAIRED FRAME PER SRM.SDR ASAA0110646Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BODY STATION 328, STRINGER 26R CORRODED. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0140162Attach Fitting · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON GIRT BAR ATTACHMENT AT BS 312, LBL 53, WL 209. REPLACED PER SRM. (M)SDR DHL2001365041Structure · corrodedCORROSION ON CONNECTING SECTION AT FR 26L AT STR 50L. REMOVED SECTION PER SRM 51-30-29. INSTALLED NEW SECTION PER SRM 51-30-29.SDR DHL2001365042Structure · corrodedCORROSION ON CONNECTING SECTION AT FR 26R AT STR 48R. REMOVED CONNECTING SECTION PER SRM 51-30-29. NEW SECTION INSTALLED PER SRM 51-30-29.SDR AWXA200100635Web · crackedPHX - MAJOR REPAIR - "C" - 1.5" CRACK FOUND ON RADIUS OF INTERCOASTAL AND STRAP AT FWD LAV ATTACH POINT BS 305, STR 5L. MAINTENANCE REMOVED CRACKED INTERCOASTAL AT BS 305 AND STRAP AT STR 5L: FABRICATED NEW INTERCOASTAL AND STRAP, AND INSTALLED REPAIR PARTS IASDR SWAA013204Web · corrodedDURING SCHEDULED D CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 616 TO BS 639. REPAIRED WEB SECTION PER SRM.SDR SWAA013200Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL 201, LBL 5 AND RBL 5. REPAIRED WEB PER SRM.
Back to JASC 5310