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 ASOA2013060703785Beam · corrodedFS 645.00 BEAM CORRODED BETWEEN STR26L AND 25R. REMOVED LIGHT SURFACE CORROSION BY HAND, NO PITTING FOUND IAW SRM 51-21-06-001-001-A01. BLENDED AREA OUT OF LIMIT IAW SRM 53-31-06-101-003-A02.SDR SIMA20130521001Beam · corrodedDURING MX INSPECTION FOUND THE CARGO DOOR SILL CORRODED. THE ACFT WAS REMOVED FROM SERVICE. R & R CARGO DOOR SILL IAW SRM 51-40-02, LEVEL 2 CORROSION. THE ACFT WAS RETURNED TO SERVICE.SDR KPVA201305200003Beam · crackedCABIN DOOR WOULD NOT CLOSE. FURTHER TROUBLESHOOTING LEAD TO DISCOVERY OF CRACK ON COUNTERBALANCE MECHANICAL MOUNT BEAM.SDR FDEA201305191026Crossbeam · misrepairedMAIN DECK CARGO COMPARTMENT CROSSBEAM 28 BETWEEN-Y450 AND-Y953 MISREPAIRED. CARRIED OUT REPAIR IAW EA NR 6-5310-167620.SDR ASAA2013051995007Structure · corrodedRIGHT MLG WHEEL WELL MANIFOLD ASSY LOWER AFT STRUCTURE CORRODED AT 4 O`CLOCK POSITION CORRODED DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-60-71, FIG 101. R & R DAMAGED SECTION OF STRUCTURE IAW SRM 51-40-02.SDR DALA13025290126Structure · damagedAFT CARGO BAY BS 1241 RBL 8, ANCHOR NUT HOLE ELONGATED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 4.SDR DALA13025270126Structure · damagedFWD CARGO COMPT BS 654+22, RBL 35 ANCHOR NUT HOLE FOUND ELONGATED. MX REPAIRED IAW SRM 53-00-07, REPAIR 4, FIG 201.SDR DALA13024263133Window Frame · crackedCRACK INDICATION FOUND IN FASTENER HOLE LOCATED AT THE WINDSHIELD UPPER AREA OF THE SIDE POST AT FRAME 4, VERTICAL MEMBER LT SIDE. PERFORMED REPAIR AT THE WINDSHIELD UPPER AREA OF THE SIDE POST AT FRAME 4 VERTICAL MEMBER LT SIDE IAW ER/A N 513509-14AD (REV. OSDR DALA1313333702Door Frame · damagedAFT CARGO DOOR FRAME DAMAGED. MX REFORMED AND BURNISHED 508496. HFEC INSPECTION IAW NDT6-51-00-00, FIG 23, NO CRACKS. REPAIRED IAW SRM 53-00-01, REPAIR 25.SDR DALA1315970683Crease Beam · corrodedCORROSION ON AND AROUND RIVET HEADS OF CREASE BEAM WEB RT BETWEEN BS 1420-1440. REPLACED CREASE BEAM WEB IAW SRM 51-40-02 PG2-3, 7 AND DWG 146N5590.SDR DALA1315760683Crease Beam · corrodedCREASE BEAM WEB HAS CORROSION ON UPPER AND LOWER SURFACE RT BETWEEN BS 1360-1380 MAIN CABIN. R & R PART IAW SRM 51-40-02.SDR DALA1315750683Crease Beam · corrodedCREASE BEAM WEB HAS CORROSION AT BS 1380-1400 MAIN CABIN. R & R PART IAW SRM 51-40-02.SDR DALA13025410126Structure · corrodedAFT CARGO BELOW FLOOR SHEAR TIE FOUND CORROSION AT BS 1197+66, S38-39R. MX REPLACED AS SRM 51-10-02, 51-40-05, 51-40-02.SDR FDEA201305181017Crease Beam · misrepairedFUSELAGE BS 1583-1594, LT SIDE CREASE BEAM INBD ANGLE MISREPAIRED. REMOVED CREASE BEAM AT BS 1370 -1630 IAW SRM 51-40-02, FABRICATED, LOCATED AND DRILLED CREASE BEAM IAW SRM 51-40-05. INSTALLED CREASE BEAM IAW SRM 51-40-02 & DWG 146N5590. MAJOR REPAIR.SDR DALA13023310948Door Frame · corrodedAFT CARGO DOOR FRAME HAS CORROSION AROUND RIVETS & FACE OF DOOR FRAME BS 1155-1212 BETWEEN L28-29. NO DAMAGE NOTED UNDER STRAP, FABRICATED AND INSTALLED STRAP IAW SRM 53-05, FIG 123, OPTION 1, 51-30-05 & 51-10-3.SDR DALA13023290948Door Frame · corrodedCENTER CARGO BAY LOWER DOOR FRAME BS 674 IS CORRODED. FABRICATED AND INSTALLED NEW SPACER AT BS 674 IAW SRM 51-30-05, 53-01, FIG 1-53-05, FIG 123 (OPTION 1), 51-10-3.SDR SIMA20130517015Skin · corrodedSKIN CORRODED BETWEEN FRAMES 13 AND FR 14 BETWEEN S21L AND 20R. REPAIRED IAW EO EM-53MR-2137R1 AND NRTC E311748.SDR SIMA20130517008Support Beam · corrodedDURING B INSPECTION, FOUND THE RT LAVATORY BEAM GUSSET CORRODED. THE ACFT WAS REMOVED FROM SERVICE. R & R THE RT LAVATORY BEAM GUSSET IAW SRM 51-40-02. THE ACFT WAS RETURNED TO SERVICE.SDR SIMA20130517007Support Beam · corrodedDURING B INSPECTION FOUND THE CENTER LAVATORY CORRODED. THE ACFT WAS REMOVED FROM SERVICE. R & R THE CENTER LAVATORY BEAM GUSSET IAW SRM 51-40-02. THE ACFT WAS RETURNED TO SERVICE.SDR SIMA20130517006Support Beam · corrodedDURING B INSP, FOUND THE LT LAVATORY BEAM GUSSET CORRODED. THE ACFT WAS REMOVED FROM SERVICE. R & R THE LT LAVATORY BEAM GUSSET IAW SRM 51-40-02. THE ACFT WAS RETURNED TO SERVICE.SDR ASOA2013061903846Beam · corrodedRT SILL AT BS 280 BEAM CORRODED. R & R RT SILL IAW SRM 51-42-10, 51-45-00, 51-42-06, 51-42-21, 51-40-11, 51-21-11, 51-25-06.SDR DALA13024323133Window Frame · crackedDURING M-CHECK, THE INSPECTION IAW DAL CARD 5310-3917, RELATED TO ALI 531135-01-1 (AD 2011-14-06) REVEALED A CRACK FOUND ON THE UPPER ATTACHMENT OF THE LT SLIDING WINDOW FRAME. THE CRACK WAS ORIGNATED FROM NR 3 HOLE. ER/A 513509-14 SECT I ACCOMPLISHED DURINGSDR DALA13023240956Web · crackedBELT FRAME WEB CRACKED AT CANTED BS 1485 NEAR 8:00 POSITION, AT INTERIOR TAIL CONE JETTISON HANDLE SUPPORT STRUCTURE. REMOVED ATTACH CLIPS AND MADE NEW ONES IAW DWG 9911867. REINSTALLED SWITCH CONNETOR, 2 CLAMPS, AND CONE JETTISON HANDLE ASSY. C/W PRI 515158SDR UHLA2013051600166Gusset · corrodedCORROSION ONE FR 90 RT SPLICE GUSSET. R & R RT SPLICE GUSSET AT FRAME 90.SDR SWAA2013053116650Window Frame · crackedLT NR 1 FLIGHT DECK FIXED WINDOW FRAME UPPER OTBD CORNER CRACKED ON INNER EDGE OF FRAME. REPAIRED DOUBLER IAW EA.SDR DALA13025460126Structure · corrodedBULK CARGO, BELOW FLOOR SHEAR TIE FOUND CORROSION AT STA 1417, S37-38R. REPLACED IAW SRM 51-40-05, 51-10-02, 51-40-02.SDR DALA13025450126Structure · corrodedBULK CARGO, BELOW FLOOR SHEAR TIE FOUND CORROSION AT BS 1439, S37-38R, REPLACED IAW SRM 51-40-02.SDR FDEA201305161012Crease Beam · corrodedS-17R, BS 1405 - 1630, CREASE BEAM INBD ANGLE CORRODED. BLENDED IAW SRM 51-10-02, CHECKED AND FOUND TO BE OUT OF LIMITS IAW SRM 51-6-13 PG 105 DET VIII. REMOVED AND REPLACED INBD ANGLE IAW SRM 51-40-02 AND DWG 146N5590. MAJOR REPAIRSDR SWIA201333467Crossbeam · corrodedCROSSBEAM AT FS 1031 OTBD OF RBL 27 IS CORRODED. REPLACED CROSSBEAM IAW SRM.SDR SWAA2014100332594Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER ON INBD SURFACE. REPAIRED FRAME IAW ER & EA.SDR DALA13025440126Structure · corrodedAFT CARGO, BELOW FLOOR SHEAR TIE FWD ATT PLATE FOUND CORROSION AT BS 1197+100, S39L-39R. REPLACED IAW SRM 51-10-02, 51-40-02.SDR DALA13025430126Structure · corrodedAFT CARGO BELOW FLOOR SHEAR TIE FOUND CORROSION AT BS 1285, S39L-39R. REPLACED IAW SRM 51-10-02, 51-40-02.SDR UALA2013051603399Tee Fitting · corrodedBS 1640 TEE CORRODED. CUTOUT DAMAGED TO UPPER TEE AND INSTALLED REPAIR IAW ECRA 5310-05536.SDR FDEA201305150992Crossbeam · corrodedFWD CARGO FR 38.1 -Y140 CROSSBEAM CORRODED. REPAIRED CROSSBEAM IAW SRM 53-10-15, FIG 207.SDR IPXA13578624Failsafe · damagedINSPECTION TYPE:C15, FAILSAFE AT BS 540, STR 24R HAS A DRILL START. REPLACED FAILSAFE.SDR FDEA201305130977Crease Beam · misrepairedCREASE BEAM MISREPAIRED. REMOVED AND REPLACED CREASE BEAM LOCATED BS 1040 TO 1180 IAW SRM 51-40-02 & PG 30.SDR UIEA2013051400276Door Frame · crackedCRACK IN R5 DOOR FRAME REVEAL BETWEEN S-21R AND S-22R. REPAIRED DAMAGE IAW SRM 53-60-15-2R, REPAIR 3.SDR UIEA2013051400274Structure · damagedCORROSION AND TEAR AT NOSE WHEEL WELL. LT SIDE STA 323 AND WL 180. REMOVED DAMAGE AND REPAIRED IAW SRM 53-10-14, REPAIR 4 AND SR 1-2439001753.SDR CALA2013051500304Floorbeam · corrodedSTA 986.5, LBL 43, GRIT BAR NUTPLATE HOLE CORRODED, PREVIOUSLY BLENDED REPAIRED AREA. COMPLETED REPAIR AT STA.986.5, LBL 43 GIRT BAR NUTPLATE HOLE IAW EC/RA 5321-01429. REPAIR B.SDR ASOA20130423155VBeam · corrodedDURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 65-68 AND STRINGERS 15-16L. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR UHLA2013051100476Door Frame · corrodedFWD CARGO DOOR CUTOUT LWR BEAM CORRODED. R & R CARGO DOOR CUTOUT BEAM. MAJOR REPAIRSDR UHLA2013051100204Plate · corrodedCORROSION ON RT SHEAR PLATE AT FR87. R & R SHEAR PLATE.SDR UHLA2013051100202Beam · corrodedFWD CARGO DOOR CUT OUT LOWER BEAM CORRODED. R & R FWD CARGO DOOR CUT OUT BEAM. MAJOR REPAIRSDR SWAA2013052016221Window Frame · crackedCAPTAINS NR 1 WINDOW FRAME OTBD POST UPPER END CRACKED. REPAIRED FRAME IAW ER AND EA.SDR ASOA20130423152Door Frame · corrodedDURING A-CHECK, PAX DOOR CUTOUT WAS FOUND CORRODED AT FRAME 18 BETWEEN STRINGERS 15-16L. MX REMOVED THE CORRODED SECTION AND PERFORMED A SPLICE REPAIR IAW EC5310-01690. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130510046Window Frame · crackedDURING POST FLIGHT WALKAROUND, CREW REPORTED FINDING A FUSELAGE SKIN CRACK ON THE LT DV WINDOW UPPER FRAME AREA. MX PERFORMED REPAIR ON UPPER BEAM ATTACHED TO DV WINDOW AND WINDSHIELD POST ON LT SIDE IAW SRM 51-40-02. SHV MX ALSO PERFORMED REPAIR ON LT DV SDR ASOA2013052403670Door Frame · crackedCREW ESCAPE HATCH SURROUND FRAME AT FS 276.00 HAS .02 INCH CRACK. REPAIRED IAW EO CL600-2B19-53-I00276/P1.SDR IPXA13M78456Door Frame · corrodedINSPECTION TYPE:2C, AFT/BULK CARGO DOOR FRAME CORRODED, BS 1954, L33L - L44L. R & R AFT CARGO DOOR FRAME IAW SRM 51-31- 01, 51-33-01, 51-35-01. (MINOR)SDR HNAA2013051000262Structure · damagedACFT STRUCK BY LIGHTNING, ENROUTE.SDR CA130513016Vapor Barrier · burned(CAN) DURING ROUTINE C-CHECK, THE LT VAPOR BARRIER MEMBRANE, WAS FOUND TO HAVE SAG AND BURN/OVERHEAT MARK. THE DISCREPANT AREA IS LOCATED DIRECTLY ABOVE THE LT HEAT EXCHANGER PLENUM. THE VAPOR BARRIER MEMBRANE WAS REPLACED.
Back to JASC 5310