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 03FDEA0043Beam · corrodedTEE CAP AEA 7097-1, STA.1521 WAS FOUND CORRODED AT RT STA.-80.125 WHERE VERTICLE BEAM A0024-2 ATTACHES. THE BEAM ATTCHMENT TO THE TEE CAP CREATES A (V) WHERE WATER CAN PUDDLE. AWAITING APPROVED REPAIR FROM BOEINGSDR CA030115005Door Frame · cracked(CAN) DOOR POST SKIN EXTERIOR FOUND 0.5 INCH CRACK AT THE CENTRE OF THE CURVE CUTOUT AT THE FORWARD UPPER DOOR ON THE FUSELAGE.SDR VNAA0301015Structure · vibrationDURING TAKEOFF, THE CREW FELT A STRONG VIBRATION AT APPROXIMATELY 60 KNOTS AND THE CREW ABORTED TAKEOFF. MAINTENANCE INSPECTED AND FOUND NO DISCREPANCIES. MAINTENANCE THEN PERFORMED HIGH SPEED TAXI RUNS WITH THE CREW AND COULD NOT DUPLICATE THE PROBLEM AND FSDR HEEA083700Support · crackedAFT ENGINE OIL TANK SUPPORT CRACKED.SDR HEEA083699Support · crackedFWD ENGINE OIL TANK SUPPORT CRACKED AT FWD RT MOUNT BOLT.SDR UPS03240114Stringer · crackedINSPECTION TYPE:C&SI CRACK IN AIRSTAIR CENTRE STRINGER AT LWR END OF 2ND BAY FROM TOP OF STAIR REPAIR CARRIED OUT AS REQUIRED IAW SRM 53-10-3SDR UPS03840074Frame · corrodedINSPECTION TYPE: C-2, FWD CARGO PIT FUSELAGE FRAME LOWER FLANGE CORRODED STA 500 L34L-L35R. REMOVED CORROSION, FOUND OUT OF LIMITS IAW DC8 SRM 53-2-0 AND 53-4-1. FABRICATED -5 & -7 REPAIR PARTS IAW DC8 SRM 53-2-0. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. FSDR F3LA200300003Strap · corrodedDURING C-4 CHECK, INSPECTION REPORTED AFT CARGO COMPARTMENT FWD DOOR FRAME RADIUS STRAP, STA 794.3, CORRODED AT STR 25R. FOUND RADIUS STRAP OUT OF LIMITS PER SRM 53-16-15, FIG 101. REMOVED AND INSTALLED REPLACEMENT STRAP PER SRM 51-10-02 AND 51-40-02.SDR ASAA0380082Torque Box · corrodedOKC - FOUND DURING C-CHECK, TORQUE BOX WEB UPPER SURFACE CORRODED AT FS 1212. REPLACED WEB SECTION PER SRM 51-70-4. (M)SDR ASAA0380077Access Panel · crackedOKC - FOUND DURING C-CHECK, ACCESS PANEL BENEATH SEAT IN COCKPIT IS BENT AND TORN. INSTALLED DOUBLER PER SRM 53-01. (M)SDR ASAA0380076Hinge · crackedOKC - FOUND DURING C-CHECK, MID CARGO BAY BARRIER DOOR HINGE IS CRACKED. REPLACED HINGE PER SRM 51-10-3, 51-10-4, AND 51-30-1. (M)SDR BJG2003F00000Doubler · crackedFOUND DURING ANNUAL INSPECTION. THIS DOUBLER IS AFT OF MAIN GEAR LEG AS STA68.33. PART OF LANDING GEAR SUPPORT STRUCTURE.SDR UPS03240126Support · corrodedINSPECTION TYPE: C+SI, CORROSION ON TOILET SUPPORT BEAM BETWEEN BS 328 AND 344. INSTALLED NEW SUPPORT BEAM AT ABOVE LOCATION IAW SRM 51-30-2.SDR UPS03240120Flange · corrodedINSPECTION TYPE:C&SI R/H W/W BS 930 HORIZ. INTERCOSTAL COMMON TO BS 930 FRAME EVIDENCE OF CORROSION ON HORIZ. AND VERTICAL FLANGE REPAIR CARRIED OUT IAW SMRO EO 2003-003-013 UPS ENGINEERING FILE NO. 727-53-20093SDR 2003UALA00052Crease Beam · corrodedBS 294 THROUGH 342, RBL 52, RIGHT CREASE BEAM ANGLE CORRODED. MAJOR REPAIR ACCOMPLISHED. TRANSFERED HOLES ONTO NEW CREASE BEAM. INSTALLED NEW CREASE BEAM.SDR ASAA0380069Shear Tie · corrodedOKC - FOUND DURING C-CHECK, SHEAR TIE CORRODED AT FS 1250. REPLACED SHEAR TIE PER SRM 51-10-2, 51-10-3, AND 53-14-3. (M)SDR ASAA0380072Gusset · corrodedOKC - FOUND DURING C-CHECK, GUSSET CORRODED IN AFT CARGO BAY. REPLACED GUSSET PER SRM 51-10-2 AND 51-10-4. (M)SDR ASAA0380068Shear Tie · corrodedOKC - FOUND DURING C-CHECK, SHEAR TIE IS CORRODED AT FS 1287. REMOVED CORROSION AND INSTALLED DOUBLER PER SRM 53-01, 53-03, AND 51-10-3. (M)SDR UPS03240113Channel · crackedINSPECTION TYPE:C&SI BS1263 R/H, VENTRAL STAIR TORQUE BOX HORIZ. BEAM IS CRACKED AT I/B U PPER RADIUS CHANNEL REPLACED IAW DRAWING 65C13874& SRM 51-30-02SDR UPS03240110Stiffener · corrodedINSPECTION TYPE:C&SI CORROSION AT FLOOR LEVEL I/B STIFFENER BS 233 APPROX RBL 16 APPROX U NDERNEATH 1ST OFFICERS SEAT SUPPORTS CORROSION REMOVED AND FOUND OUTSIDE LIMITS OF SRM 51-10-6 & 51-10-1 STIFFENER CHANNEL REPLACED IAW SRM 51-30-2SDR UPS03240100Bracket · crackedINSPECTION TYPE:C&SI BRACKET CRACKED AT MAIN CARGO DOOR SUPPORT BEAM BS 580 STR. 2 L/H REPAIR CARRIED OUT IAW SMRO EO 2003-003-008 UPS ENGINEERING FILE NO. 727-55-20034SDR UPS03240095Support · corrodedINSPECTION TYPE:C&SI CORROSION ON SEAT TRACK SUPPORT BS 850 - 870 RBL 62.5 SUPPORT REPLACED IAW SRM 51-30-02SDR ZW0A0300807Door Frame · crackedDURING CHECK-C MAINT FOUND CRACK IN LOWER DOOR BEAM AT LOWER HINGE CUTOUT. FWD SERVICE DOOR. REPLACED FRAME PER SRM SPM 6-70-01.SDR MWEA030028Doubler · corrodedRIGHT CUSP MEMBRANE HAS CORROSION BETWEEN STATION 522-541. -- CLEANED CORROSION, FABRICATED AND INSTALLED DOUBLER.SDR MWEA030026Doubler · corrodedCUSP MEMBRANE CORRODED RIGHT SIDE AT STATION 475 AT LIGHTING HOLE. -- REMOVED CORROSION, FABRICATED AND INSTALLED DOUBLER AND SUPPORT GRILL.SDR MWEA030020Doubler · corrodedRIGHT CUSP MEMBRANE HAS CORROSION BETWEEN STATION 826-845. -- FABRICATED AND INSTALLED DOUBLER.REMOVED AND REPLACED GRILL AND INSTALLED SIDE WALL PANEL.SDR MWEA030022Doubler · corrodedCUSP MEMBRANE CORRODED RIGHT SIDE STATION 984-1003. -- REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED DOUBLER AND FILLERS AND REPAIR PARTS.SDR MWEA030021Doubler · corrodedRIGHT CUSP MEMBRANE HAS CORROSION BETWEEN STATION 389 TO 408. -- REMOVED CORROSION, FABRICATED AND INSTALLED DOUBLER.SDR MWEA030019Doubler · corrodedCUSP MEMBRANE CORREDED LEFT SIDE STATION 560 AREA. -- REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR DOULBER.SDR MWEA030017Doubler · corrodedCUSP MEMBRANE CORRODED RIGHT SIDE STATION 1155-1174. -- FABRICATED AND INSTALLED NEW DOUBLER AND NEW FILLERS.SDR AALA20030033Shear Tie · crackedTUL - FOUND TWO .125 INCH CRACKS EXTENDING OUT FROM LOWER FASTENER IN SHEAR TIE STATION 1380, LONGERON 12L TO 13L, ABOVE LEFT PYLON. STOP DRILLED CRACKS. INSTALLED DOUBLER PER SRM 53-01-00. (M)SDR UPS03240104Shear Tie · crackedINSPECTION TYPE:C&SI FLOOR BEAM SHEAR TIE CRACKED AT BS 322 APPROX AND BL0 FLOOR BEAM SHEAR TIE AT BS 322 AND BL 0 REPAIRED IAW SRM 53-10-8 FIG 6SDR UPS03240103Shear Tie · crackedINSPECTION TYPE:C&SI FLOOR BEAM SHEAR TIE CRACKED AT BS 320 APPROX AND BL 20 R/H FLOOR BEAM SHEAR TIE REPAIRED AT BS 320 AND BL 20 R/H IAW SRM 53-10- 3 FIGURE 6SDR UPS03240101Window Frame · crackedINSPECTION TYPE:C&SI CRACK ON WINDOW FRAME BS 1100 L/H STR. 12 CRACK STOP DRILLED IAW SRM 51-10-1 SEE SMRO EO 2003-003-009 FOR REPAIR INSTRUCTION. UPS ENG. FILE NO. 727-53-20092SDR UPS03240049Bracket · brokenINSPECTION TYPE:C FLAT BRACKET BROKEN ON FUSELAGE SKIN AT BS 740 AT INTERSECTION WITH STR. 17R NEW PLATE FABRICATED IAW SRM 51-20-01 FIG 7 INSTALLED IAW SRM 51-30-02SDR UPS03440040Clip · crackedINSPECTION TYPE:C M/D - BS 2200 STRINGER S25R TIE CLIP FOUND CRACK. BS 2200 STRINGER 25R TIE CLIP REPLACED AS PER SRM 51-10-01 P.8.SDR 2003UALA00033Crease Beam · corrodedCORROSION ON RIGHT CREASE BEAM INBOARD CHORD FROM BS 294 TO BS 334. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM.SDR AWXA200300035Crease Beam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON THE LOWER SURFACE OF RT CREASE BEAM (SHEAR PLATE) FROM BS 69 TO BS 70. MAINTENANCE REMOVED DAMAGED CREASE BEAM; FABRICATED A REPLACEMENT CREASE BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-SDR UPS04841698Shear Tie · crackedINSPECTION TYPE: C3, STA 1766 AFT SIDE SHEAR TIE IS CRACKED AT LOWER END BETWEEN LONGERON 9L AND 10L. STOPDRILLED CRACK, NDT VERIFIED STOPDRILL TERMINATES CRACK, FABRICATED AND INSTALLED REPAIR ANGLE IAW SRM 53-2-0 FIG 1B.SDR UPS03240096Bracket · corrodedINSPECTION TYPE:C&SI BODY FAIRING SUPPORT ANGLE BRAKCET CORRODED UNDER ANCHOR NUT AT BS 6 10 S28 L/H BRAKCET REMOVED IAW SRM 51-30-02. BRACKET FABRICATED IAW SRM 51-20-1 FIG. 7 & SRM 53-50-1 FIG 1. INSTALLED IAW SRM 51-30-02SDR UPS03240065Fitting · crackedINSPECTION TYPE:C CRACK INDICATION IN 2 HOLES BS 950 L/H HOLES LOCATED ON ROWS 2ND FRO M FWD EDGE OF FITTING AND 2ND HOLES FROM BOTTOM OF SPLICE PLATE JUST BELOW STR. 6 L/H BS 950 BULKHEAD FITTING REPLACED IAW EO B727-5310-3012 & DRAWING 65C18332 AND 2MISDR 2003UALA00026Crease Beam · corrodedCREASE BEAM WEB BELOW FORWARD GALLEY DOOR STA 297 - STA 327 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR.SDR ABXA030025Shear Tie · corrodedFORWARD CARGO LOWER LOBE, CORRODED SHEAR TIE AT STA 412, BETWEEN STRINGERS 39 LEFT - 39 RIGHT. CORRODED SHEAR TIE REMOVED AND INSTALLED NEW SHEAR TIE IAW SRM.SDR ABXA030024Shear Tie · corrodedFORWARD CARGO LOWER LOBE, CORRODED SHEAR TIE AT STA 742, BETWEEN STRINGERS 36 - 37 LEFT. CORRODED SHEAR TIE REMOVED, NEW SHEAR TIE INSTALLED IAW SRM.SDR ABXA030023Shear Tie · corrodedFORWARD CARGO LOWER LOBE, STA. 742, CORRODED SHEAR TIE, BETWEEN STR 38 - 39 LEFT. CORRODED SHEAR TIE REMOVED, NEW SHEAR TIE INSTALLED IAW SRM.SDR ABXA030020Shear Tie · corrodedFORWARD CARGO LOWER LOBE CORRODED SHEAR TIES AT STA 434, BETWEEN LONG 36-37 LEFT AND RIGHT. CORRODED SHEAR TIE REPLACED WITH NEW SHEAR TIE IAW SRM.SDR ABXA030018Shear Tie · corrodedFORWARD CARGO LOWER LOBE STA 742, CORRODED SHEAR TIE, BETWEEN STRINGER 39 LEFT - 39 RIGHT. CORRODED SHEAR TIE REMOVED, NEW SHEAR TIE INSTALLED IAW SRM.SDR ASAA0380036Channel · crackedOKC - FOUND DURING 30K CHECK, DOOR FRAME CHANNEL CRACKED IN FORWARD CABIN AREA. REPAIRED CHANNEL PER SRM 51-70-5. (M)SDR ASAA0280032AShear Tie · corrodedOKC - FOUND DURING 30K CHECK, SHEAR TIE CORRODED AT FS 1174. REPLACED SHEAR TIE PER SRM 51-10-2. (M)SDR AALA20030094Window Frame · crackedTUL - FOUND LOWER WINDOW FRAME TAB CRACKED, BOTTOM FORWARD CORNER. INSTALLED REPAIR ANGLE ON BOTTOM FORWARD CORNER OF WINDOW FRAME AT STATION 1155 LEFT PER AARD 53-10-00-25. (M)
Back to JASC 5310