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 MWEA010958Frame · damagedFUSELAGE FRAME STATION 408 HAS OPEN FASTENER HOLES AT LONGERON 4 RIGHT. -- FABRICATED, LOCATED AND DRILLED ANGLE REPAIR, INSTALLED NOMINAL FASTENERS.SDR MWEA010957Frame · misdrilledFUSELAGE FRAME STATIO N408 HAS MISDRILLED/OPEN HOLES (2 EA) A LONGERON 4 LEFT. -- FABRICATED, LOCATED AND DRILLED REPAIR ANGLE, INSTALLED REPAIR.SDR MWEA010956Frame · misdrilledFUSELAGE FRAME STATION 332 AT LONGERON 6 RIGHT HAS A MISDRILLED HOLE. -- PLUGGED HOLES AND FABRICATED REPAIR DOUBLER, FABRICATED REPAIR, INTALLED REPAIR.SDR MWEA010955Frame · damagedFUSELAGE FRAME STATION 294 AT LONGERON 6 RIGHT HAS NUMEROUS OPEN HOLES. -- PLUGGED HOLES IN FRAME, FABRICATED REPAIR PARTS, INSTALLED REPAIR.SDR MWEA010954Frame · elongatedFUSELAGE FRAME STATION 256 AT LONGERON 6 RIGHT HAS ONE ELONGATED HOLE. -- REMOVED INTERCOSTAL CLIP AND FORMER SPLICE, FARICATED REPAIR DOUBLER, INSTALLED REPAIR, CLIP AND FORMER.SDR MWEA010953Frame · damagedSTATION 579 BETWEEN LONGERON 5 AND 6 LEFT SIDE HAS SEVERAL OPEN DRILL HOLES. -- FABRICATED REPAIR DOUBLER, PLUGGED HOLES, INSTALLED REPAIR.SDR MWEA010952Intercostal · damagedFORWARD ENTRY INTERCOSTAL HAS 3 OPEN FASTENER HOLES INNER LEG HAS MATERIAL TRIMMED OUT SATION 228 ABOVE LONGERON 15 LEFT. -- FABRICATED AND INSTALLED REPAIRS.SDR MWEA010951Clip · crackedSTATION 965 AT LONGERON 17 LEFT HAS A CRACKED CLIP ON THE AFT SIDE OF THE ENGINE FORWARD PYLON BULKHEAD. -- REMOVED ANGLE, FABRICATED AND INSTALLED NEW ANGLE.SDR RRXA11352Skin · corrodedDURING A MAINTENANCE VISIT FOUND EMPINNAGE EXT SKIM, FS 1793, R STR 26, HAS HEAVY CORR EXFOLIATION AROUND A FASTNER, *** CORRECTIVE ACTION *** CUT OUT DAMAGE AREA, FABRICATED REPAIR DOUBLER PER SRM 53-5-0 FIG 46A18, FILLER PER SRM 53-2-0 FIG 1D AND INSTALLED SDR RRXA11284Angle · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO VERTICAL STAB R/H ATTACH ANGLE 10" FWD OF FWD SPAR, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DSDR 01FDEA00509Shear Tie · corrodedCORROSION (C53-113-01, 2) ON SHEAR TIE AT BS 1010, RBL 2, WL 138.5. *S/D* REMOVED AND REPLACED SHEAR TIE PER FEDEX SRM 53-10-4.SDR RRXA11281Intercostal · gougedDURING A MAINTENANCE VISIT FOUND GOUGED DAMAGE TO B-PIT DOOR FWD JAMB INTERCOSTAL AT STA.515-520 AND L31R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAWSDR USAA010664Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, BS 867, BETWEEN STRINGERS 8R AND 9R. INSTALLED REPAIR DOUBLER PER TR 53-10-14. (M)SDR USAA010665Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, BS 727D. INSTALLED REPAIR DOUBLER PER TR 53-10-14. (M)SDR USAA010667Door Frame · crackedCLT - FOUND FRAME REVEAL CRACKED 1 INCH, FORWARD SERVICE DOOR, TOP SURROUND FRAME. REMOVED AND REPLACED FRAME REVEAL. (M)SDR UPS01236180Window Post · crackedINSPECTION TYPE:C CRACK FOUND IN F+N WINDOW POST ON SKIN DOUBLER ATL/H WINDOW POST AT WINDOW CUTOUT RADIUS POINT E REPAIRED IAW UPS EO B727-5310-0012SDR MWEA010938Shear Tie · crackedRIGHT LAVATORY SHEAR TIE CRACKED ON FRAME 980 JUST BELOW LONGERON 14 RIGHT. LOCATED, DRILLED AND INSTALLED NEW SHEAR TIE.SDR 2001F00419Door Frame · corrodedDURING C-CHECK, FOUND CORROSION ON THE LOWER FORWARD END OF THE FORWARD CARGO DOOR JAMB FRAME AT STATION 886. CORROSION WAS REMOVED AND REPAIRED IAW EA NR 10-5316-24-A0861. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 2001UALA01016Shear Tie · corrodedSHEARTIE CORR. AT STA.588, STR. 39L-39R.SDR 2001UALA01015Shear Tie · corrodedSHEARTIE CORR. STA.588, AND STR. 38L-39L.SDR 2001UALA00997Shear Tie · corrodedSHEARTIE CORRODED AT STA.588, STR.39L-39R.SDR 2001UALA00988Crease Beam · corrodedCREASE BEAM WEB CORRODED STA 635, LBL 69, WL 208. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR SWAA011719Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8-9 LH.SDR MWEA010902Shear Tie · corrodedCORROSION ON SHEAR TIE AND ANGLE BRACKET FOR LEFT FLOOR SUPPORT AT STATION 897 BETWEEN LONGERONS 28 AND 27 LEFT. REMOVED CORROSION, FABRICATED, LOCATED, DRILLED AND INSTALLED SHEAR TIE AND ANGLE.SDR MWEA010888Shear Tie · damagedOVERSIZED HOLE ON STATION 917 SHEAR TIE ABOVE LONGERON 30. FABRICATED AND INSTALLED STRAP.SDR AWXA0001846Crease Beam · corrodedRT crease beam (wet area) BS 947-990 has APPROX 10 sq inch surface corrosion and 1 drilled off fastener. removed surface corrosion on RT crease beam - corrosion within limits IAW SRM 53-60-15 fig 101.SDR RRXA11251Angle · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO FLOOR BEAM SUPPORT ANGLE STA.70 AND LBL30, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-3-SDR RRXA11248Frame · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO FRAME AT STA.1395 AND L28R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21, 53-2-0 FIG.SDR 2001UALA01113Shear Tie · corrodedBS 654 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-207 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01111Shear Tie · corrodedBS 434 STR 36L-37L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01110Shear Tie · corrodedBS 566 STR 38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-232 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA00973Door Frame · crackedFWD GALLEY DOOR AFT CUTOUT FRAME CRACKED. INSTALLED REPAIR ANGLE DOUBLER. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00971Door Frame · crackedFWD GALLEY DOOR AFT CUTOUT FRAME CRACKED. INSTALLED REPAIR ANGLE DOUBLER. MAJOR REPAIR ACCOMPLISHED.SDR 0105069971Stiffener · crackedDuring HCK in ATL., two .75" cracks were found in the 756 bulkhead. The cracks are located in the upper ends of the verticle stiffeners at sta X=-11. EA 99-181222.SDR 0104359971Stiffener · crackedDuring H ck in ATL, two .75" long cracks were found in the Sta 756 bulkhead. The cracks are located in the upper ends of the verticle stiffeners at x=-11 and x=-22. Repaired per EA 99-181222. Material 2014-t6511 AL.SDR ASAA0110330Structure · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND LT MLG WW CUTOUT AT BS 663-727, WATERLINE 150 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110332Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 924, STRINGER 19L CORRODED. REPAIRED PER SRM. (M)SDR USAA010640Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, BS 500A, STRINGER 8R. INSTALLED REPAIR DOUBLER PER TR 53-10-14. (M)SDR USAA010638Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, BS 400, STRINGER 8L. INSTALLED REPAIR DOUBLER PER TR 53-10-14. (M)SDR USAA010639Frame · crackedCLT - FOUND FRAME CRACKED.5 INCH, BS 500C, STRINGER 8R. INSTALLED REPAIR DOUBLER PER TR 53-10-14. (M)SDR USAA010626Tie Clip · crackedCLT - FOUND TIE CLIP CRACKED .25 INCH, BS 578, STRINGER 10R. REMOVED AND REPLACED TIE CLIP PER SRM 51-10-2. (M)SDR 2001UALA01001Shear Tie · corrodedSHEARTIE CORRODED BS 368 STR 38R-39R.SDR ABXA010311Shear Tie · corrodedAFT LOWER CARGO SHEAR TIE CORRODED AT STATION FS 1020 BETWEEN LONGERON 35 RIGHT - LONGERON 36.SDR ABXA010309Shear Tie · corrodedAFT LOWER CARGO, FUSELAGE 1040, LONGERON 35 RIGHT - 36, SHEAR TIE CORRODED.SDR 0105089971Pressure Panel · crackedDuring Hck in ATL, Two cracks were found in the horizontal pressure panel at station 105 at X=25 2.4" and X=27 .5"long. Repaired per EA 99-181213.SDR 0104929909Stiffener · crackedDuring H-CK in ATL, one 1/2"crack was found in the station 756 bulkhead. The crack is located in the upper end of the verticle stiffener at X=-22. Repaired per EA 99-181259.SDR 0104349909Bulkhead · crackedDuring H ck in ATL, one crack 1/2" long was found in the station 756 bulkhead. The crack is located in the upper end of the verticle stiffener at x=-22. Material 2014-t6511 AL. Repaired per EA 99-181259.SDR 0104339971Pressure Panel · crackedDuring H ck in ATL, two cracks were found in the horizontal pressure panel at station 105 at x=25 and x=27. The crack at x=25 is typical of the cracks repaired in the dc-9 trm, 53-10-02 except this crack is 2.4" long. The crack at station x=27 is 1/2" long. MaSDR CALA0100536Door Frame · corrodedINSPECTION FOUND FORWARD CARGO DOOR FORWARD JAMB UPPER WEB CORRODED. THE WEB WAS REMOVED AND A NEW WEB WAS INSTALLED IAW SRM 51-30-2, 51-10-4, AND 51-30-5.SDR AALA20000991ADoor Frame · crackedTUL - FOUND FORWARD DOORWAY WEB IS CRACKED AT LOWER LIGHTING HOLE STATION 1152 BETWEEN LONGERON 27R AND 28R, AFT CARGO. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-24. (M)
Back to JASC 5310