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 2004UALA00159Shear Tie · crackedSTA 706 STR 11 LT SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR SROM200400003Shear Tie · damagedDURING D CHECK INSPECTION FOUND SHEAR TIE AT STA 380 BETWEEN STR 20R AND 21R HAS HOLES THAT ARE LARGER THEN SRM LIMITS. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE IAW B737 SRM 51-40-3.SDR DHL2004750009Door Frame · dentedDURING -C- CHECK AT FLIGHTSTAR AIRCRAFT SERVICES IN JACKSONVILLE FLORIDA, DISCREPANCY AS FOLLOWS; C1 DOOR EXTERNAL HAS DENT IN BOTTOM CENTER OF DOOR U-CHANNEL. REMOVED DAMAGED ANGLE IAW B727 SRM 51-30-2, FABRICATED NEW ANGLE FROM BAC1496-383 PO 206631 DIM 44 SDR AWXA200400245Crease Beam · corrodedMCN - MAJOR REPAIR - DURING C-20 CHECK GALVANIC CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF R-1 DOOR ENTRY WAY CREASE BEAM UPPER CHORD, UPPER LEG, FROM BS 305 TO BS 320, RBL 47, WL 209. MAINTENANCE REMOVED CORRODED UPPER ANGLE OF CREASE BEAM FROM BS 305SDR SWAA040554Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR FRAME CUTOUT CRACKED AT FORWARD WEB. REMOVED AND REPLACED WEB PER SRM.SDR GTIA040206Shear Tie · crackedFTW - FOUND AFT PIT SHEAR TIE CRACKED AT FS 1136 LONGERON 27R. REMOVED CRACKED SHEAR TIE. INSTALLED NEW SHEAR TIE. (M)SDR UPS04542015Shear Web · corrodedINSPECTION TYPE: C3, CORROSION BS 1681 LBL 50 WL 208, CORROSION UPPER SURFACE OF SHEAR WEB. REMOVED DAMAGE, INSTALLED FILLER AND DOUBLER, ALL WORK DONE IAW SRM 51-70-13, 51-40-02 AND SRM 53-00-91 FIG 101.SDR AWXA200400246Shear Tie · crackedMCN - MAJOR REPAIR - DURING C-20 CHECK A .5 INCH CRACK WAS FOUND ON SHEAR TIE IN AFT CARGO COMPARTMENT BS 807, BL -0-. MAINTENANCE REMOVED DAMAGED SHEAR TIE IN AFT CARGO COMPARTMENT BS 807, BL -0-; FABRICATED A NEW REPLACEMENT SHEAR TIE; INSTALLED REPAIR PARTSDR SWAA040532Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIES CRACKED AT BS 360, BETWEEN STRINGERS 13L, 14L AND 15L. REPAIRED SHEAR TIES PER SRM.SDR 04FDEA00494Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE AT BS 700 LBL 5 TO RBL 5. CUT AND REMOVED DAMAGE AREA OF SHEAR TIE BS 700 LBL 5 TO RBL 5. FABRICATED AND INSTALLED REPAIR IAW SRM 53-10-4 FIG 11.SDR 04FDEA00470Structure · corrodedAFT CARGO WASTE TANK COMPARTMENT LT STA 1961, LONGERON 37 HAS CORROSION.SDR 04FDEA00467Structure · corrodedCABIN - BASE SECTION OF CHILLER COMPARTMENT AT GALLEY ASSEMBLY BULGING, CORROSION UNDERNEATH.SDR SROM200400002Shear Tie · damagedDURING D CHECK INSPECTION FOUND ELONGATED HOLE IN SHEAR TIE AT STA 500 BETWEEN STR 16R AND 17R, FORWARD UPPER HOLE. REMOVED DAMAGED SHEAR TIE. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE IAW B737 SRM 53-10-4.SDR B30R20040226Door Frame · crackedDURING 100 HOUR INSPECTION DISCOVERED CO-PILOT DOOR POST CRACKED 14 INCHES LONG STARTING 8 INCHES ABOVE CABIN FLOOR, EXCEEDING THE LIMITS IN REPAIR MANUAL. REPAIRED CRACK IAW MM. REQUESTED FROM MFG.SDR ABXA040084Structure · crackedRIVET ROW FOUND CRACKED AT STA 76.550 UNDER CO-PILOT'S WINDSHIELD WIPER BETWEEN APPROXIMATELY LONGERON 3 AND 4 RIGHT. REPAIRED AREA IAW EA 53100075-003-2.SDR SWAA040505Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STRINGERS 14R AND 15R. REPAIRED SHEAR TIE PER SRM.SDR JGV2004F00002Doubler · crackedDURING C CHECK INSPECTION FOUND CABIN WINDOWS CRACKED. INSPECTED CABIN WINDOW FRAME DOUBLER. DISCOVERED CRACKS IN THE NUT PLATE HOLE. RT NR 3, NR 4, AND NR 5 AND LEFT NR 3 WINDOW POSITIONS. CAUSED FROM MINIMUM EDGE DISTANCE AND NUT PLATE HOLE ENLARGEMENT. SDR 0324Fitting · corrodedEXTERNAL FUSELAGE SKIN HAS A BULGE AT FS 324 LONGERON 33R FOUND DURING C-CHECK. FOUND FORWARD LOWER BELLY CARGO (A-PIT) DOOR STRUCTURE FITTING CORRODED.SDR 020104Fitting · corrodedEXTERNAL FUSELAGE SKIN HAS A BULGE AT FS 315 LONGERON 33R FOUND DURING C-CHECK. FOUND FORWARD LOWER BELLY CARGO (A PIT) DOOR STRUCTURE FITTING CORRODED-TASK CARD #0323.SDR ASAA0410085Shear Tie · corrodedOKC - DURING MAINTENANCE CHECK, FOUND SHEAR TIE AT STATION 787 CORRODED. REPAIR IAW EA. (M)SDR ASAA0410087Shear Tie · corrodedOKC - DURING MAINTENANCE, FOUND SHEAR TIE CORRODED AT STATION 747. REPAIR IAW SRM. (M)SDR ASAA0410082Structure · corrodedOKC - DURING MAINTENANCE CHECK, FOUND CORROSION ON NOSE WHEEL WELL TUNNEL AREA AT FS 277. REPAIR IAW SRM. (M)SDR GTIA040226Beam · corrodedFTW - FOUND MID PIT DOOR JAMB IS CORRODED STATION 636 TO 623 ON EDGE AND AROUND FASTENERS. REMOVED JAMB BEAM. DRILLED AND LOCATED NEW JAMB BEAM. INSTALLED JAMB BEAM. (M)SDR SWAA040492Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 947 AND BS 987. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR ASAA0410074Tear Strap · corrodedOKC - DURING MAINTENANCE CHECK, FOUND TEAR STRAP AT STATION 360 AND STRINGER 28L CORRODED. REPAIR IAW SRM. (M)SDR ASOA04127Support Beam · crackedDURING A C-CHECK IN MCN, THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 ON THE LEFT SIDE WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 ON THE LEFT SIDE IAW ASA EO 600-53-0072SDR 2004UALA00130Shear Tie · crackedSHEAR TIES ARE CRACKED AT STA 616 STR 4L AND STA 344 STR 15R. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIES.SDR SWAA040476Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED IN AFT CARGO COMPARTMENT AT BS 767, RBL 8. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040469Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 500D, BETWEEN STRINGER 26L AND STRINGER 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040467Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT FLIGHT COMPARTMENT WINDOW POST CRACKED. REPAIRED WINDOW POST PER SRM.SDR GTIA040270Door Frame · corrodedFTW - FOUND CORROSION AFT CARGO DOOR LOWER DOOR JAMB FS 1155-1211. REMOVED JAMB BEAR. DRILLED AND LOCATED NEW JAMB BEAM. INSTALLED AFT CARGO PIT JAMB. (M)SDR 2004UALA00216Shear Tie · crackedAFT PIT SHEAR TIE CRACKED AT BS 907 STR 19L. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED & INSTALLED SHEAR TIE AND FILLER MATERIAL.SDR SWAA040461Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L2 DOOR FRAME CUTOUT LOWER FORWARD CORNER CRACKED. REPAIRED FRAME SECTION PER SRM.SDR CALA0400112Hinge · crackedINSPECTION FOUND A 1 INCH CRACK IN R-2 DOOR HINGE HOUSING AT LOWER SURFACE, STA 954, RBL 55, WL 230. THE HOUSING WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR IXXA0400035SDoor Frame · crackedDURING ROUTINE C-CHECK FOUND FUSELAGE NOSE FWD PASSENGER DOOR UPPER FWD CORNER HAS INTERIM REPAIR STATION 25.0001-9L. REPAIR ACCOMPLISHED IAW DC8 SRM 53-2-0, PAGE 2-5. TR 53-182. REMOVED INTERIM REPAIR IAW SRM 51-1-21 PG 1. MEASURED CRACK 5.250 INCH, FOUND SDR SWIA200412980Window Frame · crackedCOCKPIT LEFT SIDE FRAME 12 SUPPORT AFT/MIDDLE OF DV WINDOW FRAME. DISCOVERED DURING C-CHECK INSPECTION. REMOVED AND REPLACED COCKPIT LEFT SIDE FRAME 12 SUPPORT AFT/MIDDLE OF DV WINDOW FRAME WITH A SERVICEABLE UNIT IAW SRM 51-10-02, 51-40-00.SDR LR7A04028Window Frame · crackedDURING SCHEDULED B2 INSPECTION PER JOB CARD HB5301 FOUND COPILOT SIDE WINDOW AFT LOWER FRAME CRACKED. REPAIRED IAW SMP583 FIG 53-30-32, FS 156 WL 231 RBL 45.SDR LR7A04027Window Frame · crackedDURING SCHEDULED B2 INSPECTION PER JOB CARD HB5301 FOUND PILOTS SIDE WINDOW FRAME CRACKED. REPAIRED IAW SMP583 FIG 53-30-25, FS 126 WL 251 LBL 40.SDR SWAA040452Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 DOOR CUTOUT FRAME CRACKED AT LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR C2XA04SH062Buttstrap · corrodedSHV-DURING C-CHECK THE CENTER BUTTSTRAP AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH061Buttstrap · corrodedSHV-DURING C-CHECK THE CENTER BUTTSTRAP AT FRAME 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200400226Crease Beam · corrodedLCQ - MAJOR REPAIR - DURING C-5 CHECK EXFOLIATION CORROSION WAS FOUND ON RT CREASE BEAM BETWEEN BS 944 AND BS 998, RBL 54. MAINTENANCE REMOVED CORRODED SECTION OF RT CREASE BEAM BETWEEN BS 944 AND BS 998, RBL 54; FABRICATED A NEW REPLACEMENT SECTION OF CREASESDR ASAA0410063Shear Tie · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE SHEAR TIE AT BS 907, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR 04041656Structure · crackedDURING INSPECTION A CRACK WAS FOUND AT STATION 621 WATER LINE 73 UNDER FLOOR PANEL 282. THE CRACK WAS REPAIRED AND AIRCRAFT WAS RETURNED TO SERVICE UPON COMPLETION OF INSPECTION.SDR UPS04441982Door Frame · crackedINSPECTION TYPE: C, M/D - LEFT NR 4 DOOR FWD CUTOUT FWD FRAME APPROX S16L AREA, FRAME I/B FWD FACE FOUND CRACK AS MARKED. FWD FRAME CRACKED PORTION TRIMMED OFF, REPAIRED AS PER HX RS 53-62-35110. SURROUNDING STRUCTURE IS CORROSION AND DAMAGE FREE AFTER INSPSDR SWAA040433Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT BELT FRAME SHEAR TIES CORRODED AT BS 727E, BETWEEN STRINGER 26R AND STRINGER 27R. REMOVED AND REPLACED SHEAR TIES PER EA.SDR 2004UALA00116Door Frame · crackedLEFT NR 5 MED, FWD FRAME INBOARD WEB IS CRACKED AT LOWER DOOR HINGE AREA. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED DOUBLER REPAIR.SDR 2004UALA00115Door Frame · crackedRIGHT NR 5 MED, FWD FRAME INBOARD WEB CRACKED AT LOWER DOOR HINGE AREA. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR SWAA040417Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIES CORRODED AT AFT CARGO COMPT BS 767, BL 0, BS 807, LBL 17. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR 04FDEA00374Beam · corrodedCORROSION, STA 760 BL 0 WL 148, DELTA BEAM LWR L-ANGLE HAS CORROSION. ACCESSED DELTA BEAM WEB. REMOVED L-ANGLE AND FOUND L-ANGLE OUT OF LIMITS. FABRICATED NEW L-ANGLE, INSTALLED ANGLE AND REINSTALLED ACCESSED DELTA BEAM WEB FASTENERS AND DME NR 2 ANTENNA CL
Back to JASC 5310