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 DL73K010366Door Frame · crackedC2 CARGO DOOR OPENING FORWARD FRAME WAS FOUND TO HAVE CRACKS IN THE UPPER FRAME BETWEEN STR 24R AND 26R. ADDITIONALLY, THE REINFORCEMENT STRAP WAS FOUDN CORRODED BETWEEN STR 24R AND 25R. THE FRAME WAS REPAIRED PER SRM 51-40-3 AND THE DAMAGED SECTION OF SDR SWAA010649Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CORRODED AT BS 967, LBL 3. REPAIRED SHEAR TIE PER SRM.SDR AALA20010389Shear Tie · corrodedTUL - FOUND SHEAR TIE CORRODED STRINGER 26R, STATION 1148. REMOVED CORRODED SHEAR TIE AND REPLACED WITH NEW PART 51-10-3. (M)SDR AALA20010462Beam · corrodedTUL - FOUND 1 INCH BY 20 INCHES OF CORROSION ON AFT CARGO DOOR JAMB BEAM ACROSS BOTTOM OF OPENING, FS 1155-1212. REMOVED AND REPLACED DOOR JAMB BEAM PER 51-01. (M)SDR CALA0100198Door Frame · corrodedINSPECTION FOUND FORWARD CARGO DOOR JAMB PAN CORRODED AROUND RIVNUTS. THE CORRODED AREA OF DOOR PAN WAS CUT OUT AND A REPAIR ANGLE AND SPLICE ANGLES WERE INSTALLED IAW SRM 53-05, FIGURE 44, 51-10-3, 51-30-2, AND 51-30-5.SDR CALA0100197Door Frame · dentedINSPECTION FOUND FORWARD CARGO DOOR JAMB DENTED AT STA 492, FLOOR LINE. THE DENTED AREA WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 51-70-13.SDR SWAA010642Crease Beam · crackedDURING SCHEDULED C3 CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 639, STR 17L. REPAIRED CREASE BEAM WEB PER SRM.SDR CALA0100189Door Frame · dentedINSPECTION FOUND FORWARD CARGO DOOR JAMB DENTED AT STA 440 AT FLOOR LINE. THE DENTED AREA WAS REMOVED AND A REPAIR WAS INSTALLED IAW DRAWING 69-15224 AND SRM 51-70-13.SDR UPS01235619Door Frame · corrodedINSPECTION TYPE:C&SI ON REMOVAL OF MCD UPPER BEAM ON DOOR FOUND CORRODED. CORROSION FOUND TO BE OUTSIDE LIMITS IAW SRM 51-10-6 MCD UPPER BEAM REPLACED IAW SRM 51-80-2 WITH REF TO BOEING DRG 65- 25337 & 65-36524 & SMRO EO 2001-010-015 UPS ENGINEERING FILE NO. SDR AALA20010391Torque Box · puncturedTUL - FOUND HOLE PUNCTURED IN LEFT DOOR FRAME UPPER TORQUE BOX STATION 440, FOR E/E DOOR. ROUTED OUT HOLE, DYE CHECKED FOR CRACKS AND INSTALLED DOUBLER PER SRM 51-40-2. (M)SDR AWXA0001430Door Frame · crackedCRACK IN L2 DOOR JAMB FWD UPPER WEB AT BS 947. REMOVED DAMAGED AREA AND INSTALLED A REPAIR DOUBLER AND FILLER IAW SRM 51-40-03.SDR USAA010258Shear Tie · corrodedBOS - FOUND SHEAR TIE CORRODED .75 INCH BY 2 INCH, STATION 1287 BETWEEN LONGERON 28L TO 28R. CORROSION LEVEL 1. BURNISHED, TREATED AND PRIMED CORROSION. CUT OUT SECTION OF SHEAR TIE AND REPLACED PER OM-26. (M)SDR AALA20010418Door Frame · wornTUL - FOUND FORWARD DOOR STOP HOLE IN DOOR BEAM IS WORN, BS 655. INSTALLED DOUBLER AND HI-LOCKS PER AARD 53-10-00-16. (M)SDR AALA20010416Door Frame · gougedTUL - FOUND GOUGE IN LIGHTENING HOLE AROUND DOOR CUTOUT, STATION 629-636 STRINGER 24R. REPAIRED GOUGE PER SRM 51-70-4 (WEB). (M)SDR AALA20010451Door Frame · crackedTUL - FOUND FORWARD PAX DOOR JAMB AFT INNER WEB TONGUE CRACKED AT LONGERON 15. TRIMMED OFF TONGUE AND INSTALLED REPAIR STRAP PER AARD 53-10-00-11. (M)SDR 2001UALA00168Plate · corrodedAFT DECK PLATE STA. 1681 BLENDED EXCESSIVELY RBL 39, 40, 46.5-47.5, 50-52. CORROSION STILL EXISTS AROUND REVET HOLES AT RBL 47. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REPAIRED DECK PLATE.SDR AALA20010359Beam · corrodedTUL - FOUND DOOR SILL BEAM CORRODED ON UPPER LIP AT FRAME 61. REMOVED CORROSION PER SRM 51-74-10 AND REPAIRED PER ESO 30595, DATED 28 FEB 2001. (M)SDR 2001FAT007Structure · corrodedDURING THE 7C CHECK, A VISUAL INSPECTION WAS PERFORMED AT AFT ACCESSORY COMPARTMENT. CORROSION AND WATER ENTRAPMENT WAS DISCOVERED SCATTERED IN THIS AREA.FAT (FAR EASTERN AIR TRANSPORT CORP.) PERFORMED ONE TIME INSPECTION ON THIS AREA FOR CURRENT MD FLEET, 9 MSDR USAA010202Crease Beam · corrodedPIT - FOUND WEB CORRODED 4 INCHES BY 6 INCHES, LEFT SIDE STRINGER 17 CREASE BEAM STATION 727D-727E. REPLACED CREASE BEAM WEB, FABRICATED NEW PER SRM 53-60-13 AND 51-40-02 AND 51-70-13. (M)SDR SWIA972411Structure · vibratesHIGH FREQUENCY VIBRATION AND A LOWER FREQUENCY RUMBLING NOISE INFLIGHT. CHECKED PROP SYNC, FLAPS AND GEAR INFLIGHT. ALL INDICATIONS NORMAL. PHENOMENON WENT AWAY WITH GEAR DOWN. INSPECTED AIRCRAFT FOR ABNORMALITIES IN AIRSTREAM GEAR AND GEAR DOOR OPERATIONSSDR MWEA010195Shear Tie · corrodedFORWARD BAG PIT, SHEAR TIE BETWEEN LONGERON 29 LEFT AND 29 RIGHT, STATION 362 HAS AREAS OF LIGHT CORROSION. REMOVED, FABRICATED AND INSTALLED SHEAR CLIP.SDR AALA20010360Angle · corrodedTUL - FOUND CORROSION ON J-ANGLE AT STATION 879 AND STRINGER 52 AND CORROSION AT STATION 52 AND STRINGER 868-824. REPLACES SECTION OF J-ANGLE AND SECTION OF STRINGER PER SRM 53-00-01 VOL I AND SRM 53-10-00. (M)SDR ASAA0140033Shear Tie · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON SHEAR TIE AT STATION 767 TO WATERLINE 150 AND BUTT LINE 19. REMOVED AND REPLACED SHEAR TIE IAW SRM. (M)SDR F3LA200100038Door Frame · corrodedDURING C-4 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT DOOR FRAME CORRODED AT STA 867. MAINTENANCE REMOVED SUPPORT ANGLE, INTERCOSTAL AND TRANSITION WEB AT STR 25R, STA 847 TO 867, AND CUT OUT DAMAGED PORTION OF FRAME. FABRICATED AND INSTALLED FRAME DOUSDR USAA010173Pressure Panel · crackedCLT - FOUND PRESSURE DECK 1 INCH, BS 664, LBL 32, WL 202. INSTALLED DOUBLER PER TR 53-60-04. (M)SDR 0100956744Window Frame · corrodedON CLIMBOUT AT 9000 FT LOUD HISSING NOISE FROM AROUND FLIGHT COMPARTMENT WINDOW 3R. FLIGHT CONTINUED UNEVENTFULLY TO DESTINATION. MAINTENANCE PERFORMED INSPECTION OF 3R WINDOW AND FOUND INTERGRANNULAR CORROSION ON BOTTOM CORNER SILL. MAINTENANCE PERFORMED RSDR 2001UALA00154Shear Tie · corrodedAFT PIT BS 1153 BETWEEN STRINGERS 38R - 39R SHEAR TIE CORRODED. REPLACED SHEAR TIE REF: BAC DWG 140T2102, SRM 53-00-07, 51-40-02.SDR UPS01835182Shear Tie · crackedINSPECTION TYPE:C2,3, STA 360 SHEAR TIE IS CRACKED BETWEEN LONG 31L TO 32L. REPAIRED SHEAR TIE IAW SRM 53-2-0 FIG 2A.SDR SROM200100008Shear Tie · corrodedDURING C CHECK, FOUND CORROSION ON SHEAR TIE.SDR 2001UALA00155Shear Tie · corrodedAFT PIT BS 1263 BETWEEN STRINGERS 37L - 38L SHEAR TIE CORRODED. REPLACED SHEAR TIE REF: BAC DWG 140T2101, SRM 51-10-00, AND 51-40-02.SDR COMA0110037Shear Tie · crackedDURING A 400 FLIGHT CYCLE CHECK, A CRACKED RIVET HEAD WAS DISCOVERED ON THE RIGHT SIDE OF AIRCRAFT FUSELAGE ALONG FRAME 9. UPON FURTHER INVESTIGATION, THE SKIN SUPPORT BRACKET IN WHICH SAID RIVET PASSES THROUGH WAS FOUND TO BE CRACKED. THE SUPPORT BRACKET WASDR COMA0110036Shear Tie · crackedDURING A 400 FLIGHT CYCLE CHECK, A CRACKED RIVET HEAD WAS DISCOVERED ON THE RIGHT SIDE OF AIRCRAFT FUSELAGE ALONG FRAME 9. UPON FURTHER INVESTIGATION, THE SKIN SUPPORT BRACKET IN WHICH SAID RIVET PASSES THROUGH WAS FOUND TO BE CRACKED. THE SUPPORT BRACKET WASDR UPS01235230Pressure Panel · crackedINSPECTION TYPE:C+SI, NOSE WHEEL WALKWAY AREA PRESSURE PANEL CRACKED AT UPPER SIDE BS 309 LBL 4. CARRIED OUT REPAIR IAW SRM 51-20-1.SDR MWEA010194Angle · crackedFOUND CRACK ON LEFT FRONT SPAR PYLON BULKHEAD ANGLE AT FS 965, 2.75 LONG BETWEEN LONGERON 15-16 LEFT. REMOVED, FABRICATED, LOCATED AND INSTALLED NEW ANGLE.SDR DL72W010313Door Frame · misdrilledTHE RT AFT ENTRY DOOR FRAME SPLICE INSTALLED PER S/B 727-53-0210 WAS FOUND TO HAVE SHORT EDGE DISTANCE. THE AREA WAS MODIFIED PER S/B AT HMV.SDR AALA20010433Structure · corrodedTUL - FOUND CORROSION AROUND FASTENER AT BS 950D STRINGER 29R. INSTALLED STRAP PER ESO 11697 2-21-2001. (M)SDR P5CA0100469Stop Fitting · crackedCRACK ON LT DOOR STOP AFT SIDE ON WEB DOOR FRAME. REPAIRED PER SRM 53-10-04.SDR AALA20010303Structure · corrodedTUL - FOUND CORROSION IN THE HOLES AND ON THE SURFACE OF THE RIGHT AFT MATING SURFACE OUTBOARD OF AFT HOLE. REMOVED CORROSION PER ESO 41000 S/N 48553 DATED 2/21/2001. (M)SDR DL72L010309Web · crackedA 1 INCH CRACK IN LT TORQUE BOX VERT WEB AT UPPER RIVET ROW STA 1210 AND TWO CRACKS IN LT TORQUE BOX VERT WEB AT UPPER RIVET ROW STA 1235. REPAIR PER M/M 53-11-000-8.SDR CALA0100150Torque Box · puncturedINSPECTION FOUND TORQUE BOX WEB PUNCTURED AROUND NUT PLATES UPON REMOVAL OF AFT CARGO TIEDOWN TRACK. THE WEB SECTION WAS REMOVED AND REPLACED IAW ECRA 5310-04106 AND EA 9-5310-2-A0853.SDR CALA0100146Door Frame · corrodedINSPECTION FOUND FORWARD CARGO DOOR JAMB PAN CORRODED AROUND RIVET NUTS. THE LOWER DOOR JAMB PAN WAS REMOVED AND A NEW SECTION WAS INSTALLED USING SPLICES IAW SRM 53-05, FIGURE 44 AND 51-30-01.SDR RRXA10863Door Frame · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO ACCESS HOLE 60 DOOR FRAME AT STA. 1793-1766 AND L34L-L34R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21 & 51SDR AALA20010326Shear Tie · corrodedTUL - FOUND CORROSION BETWEEN BELL FRAME AND SHEART TIE STATION 720A STRINGER 28L-27R. CUT OFF SHEAR TIE FLANGE INSTALLED SHEAR TIE FLANGE PER SRM 53-10-04. (M)SDR ABXA010061Door Frame · crackedUPPER LEFT CORNER VENTRAL DOOR JAMB WAS CRACKED AND WAS PROPAGATING FROM STOP DRILL. MAINTENANCE INSPECTED AND REPAIRED THE CRACKED AREA IAW ABX REA D953-39998-MR.SDR AWXA0001381Shear Tie · crackedAFT CARGO COMPARTMENT STA 1300 LEFT SIDE BETWEEN STR 20L AND 21L SHEAR TIE ANGLE CRACKED. REMOVED CRACKED ANGLE, FABED REPAIR ANGLE AND INSTALLED REPAIR ANGLE IAW SRM 51-40-02, 51-30-02 AND 51-30-01.SDR UPS01235203Pressure Panel · crackedINSPECTION TYPE:C, NOSE WHEEL WELL BS 227.8 FWD WALL BL 0 CRACK INDICATION AROUND ROW OF FASTENER HEADS. CUT OUT DAMAGE AREA AS PER B727 SRM 51-40-2 & 51-10-1, INSTALLED DOUBLER REPAIR AS PER B727 51-40-2.SDR UPS01235202Pressure Panel · crackedINSPECTION TYPE:C, NOSE WHEEL WELL RT SIDEWALL BS 248 LWR OF FWD ACCESS DOOR CRACK INDICATION AROUND FASTENER HEAD. CUT OUT DAMAGE AREA AS PER B727 SRM 51-40-2 & 51-10-1. INSTALLED DOUBLER REPAIR AS PER B727 SRM 51-40-2.SDR UPS01235201Pressure Panel · crackedINSPECTION TYPE:C, NOSE WHEEL WELL RT SIDEWALL BS 264.3 WL 154 LWR OF AFT ACCESS DOOR CRACK INDICATION ALONG ROW OF RIVET HEADS. CUT OUT DAMAGE AREA AS PER B727 SRM 51-40-2 & 51-10-1. INSTALLED DOUBLER REPAIR AS PER B727 SRM 51-40-2 MAT USED 2024-T3.050 30, SDR UPS01235199Pressure Panel · crackedINSPECTION TYPE:C, NOSE WHEEL WELL RT SIDE WALL BS 259.5 FWD OF AFT ACCESS DOOR CRACK INDICATION ALONG ROW OF RIVET HEADS. CUT OUT DAMAGE AREA AS PER B727 SRM 51-40-2, INSTALLED DOUBLER. REPAIR PER SRM 51-40-20.SDR SWAA010504Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L & 14L.
Back to JASC 5310