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 AALA20040700Beam · crackedTUL - NUMBER THREE GANTRY BEAM AT FRAME 49 1 IS CRACKED APPROXIMATELY THREE EIGHTS OF AN INCH LONG. AREA WAS MODIFIED PER ECO 1273AD TO ACCOMPLISH NDT INSPECTION. STOP DRILLED CRACK AND HIGH FREQUENCY EDDY CURRENT CONFIRMED CRACK TERMINATED IN STOP DRILL HOLSDR AALA20040699Beam · crackedTUL - NUMBER THREE GANTRY BEAM AT FRAME 49 IS CRACKED APPROXIMATELY .50 INCH LONG. AREA WAS MODIFIED PER ECO 1273AD TO ACCOMPLISH NDT INSPECTION. STOP DRILLED CRACK. HIGH FREQUENCY EDDY CURRENT CONFIRMED CRACK TERMINATION IN HOLE. INSTALLED DOUBLER REPAIR SDR AALA20040697Beam · crackedTUL - NUMBER THREE GANGRY BEAM AT FRAME 52 IS CRACKED APPROXIMATELY .25 INCH LONG. AREA WAS MODIFIED PER ECO 1273AD TO ACCOMODATE NDT INSPECTION. ACCOMPLISHED ESO 30595 DATED JUNE 25, 2004 REPAIR NUMBER 40 531500 3477. CRACK STOP DRILLED AND HIGH FREQUENCY SDR AALA20040698Beam · crackedTUL - NUMBER FOUR GANTRY BEAM AT FRAME 52 IS CRACKED APPROXIMATELY .50 INCH LONG. AREA WAS MODIFIED PER ECO E1273AD TO ACCOMPLISH NDT INSPECTION. STOP DRILLED CRACK. HIGH FREQUENCY EDDY CURRENT CONFIRMED CRACK TERMINATED IN STOP DRILL HOLE AREA. INSTALLED SDR AWXA200400792Crease Beam · corrodedLCQ - MAJOR REPAIR - DURING C-12 CHECK INTERGRANULAR CORROSION WAS FOUND ON R-2 DOOR CREASE BEAM (INNER CHORD) BETWEEN BS 950 TO BS 986. MAINTENANCE REMOVED CORRODED CREASE BEAM FROM BS 950 TO BS 986; FABRICATED A NEW REPLACEMENT CREASE BEAM; INSTALLED REPAIRSDR AWXA200400791Crease Beam · corrodedLCQ - MAJOR REPAIR - DURING C-12 CHECK INTERGRANULAR CORROSION WAS FOUND ON L-2 DOOR CREASE BEAM (INNER CHORD) AT BS 986. MAINTENANCE REMOVED CORRODED CREASE BEAM AT BS 986; FABRICATED A NEW REPLACEMENT CREASE BEAM PER DWG 65-5287697; INSTALLED REPAIR PART IASDR SWAA041775Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 787, BETWEEN STRINGER 26R AND STRINGER 27R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041765Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAMS AT BS 360 TO BS 380, RBL 70.5, BS 500 TO BS 500A, RBL 70.5, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTIONS PER SRM.SDR AWXA200400796Shear Tie · crackedLCQ - MAJOR REPAIR - DURING C-12 CHECK A .375 INCH CRACK WAS FOUND IN STRINGER SHEAR TIE AT BS 500A, STR 16 LT. MAINTENANCE REMOVED CRACKED STRINGER SHEAR TIE AT BS 500A, STR 16 LT; FABRICATED A NEW REPLACEMENT SHEAR TIE PER DWG 69-35350; INSTALLED REPAIR PARSDR AWXA200400795Shear Tie · crackedLCQ - MAJOR REPAIR - DURING C-12 CHECK A .375 INCH CRACK WAS FOUND IN STRINGER SHEAR TIE AT BS 275, STR 15 RT. MAINTENANCE REMOVED CRACKED STRINGER SHEAR TIE AT BS 275, STR 15 RT; FABRICATED A NEW REPLACEMENT SHEAR TIE PER DWG 69-35352; INSTALLED REPAIR PART SDR C2XA04SH387Crossbeam · corrodedSHV - DURING C-CHECK THE CROSSMEMBER BETWEEN THE LEFT HAND SILL AND THE LEFT HAND BUTTSTRAP BETWEEN FRAMES 59 AND 60 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CROSSMEMBER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RSDR C2XA04TY094Gusset · corrodedDURING A SCHEDULED 3C INSPECTION FR 22 GUSSET CAP WAS FOUND CORRODED AROUND THE RIVETS. REMOVED FR 22 GUSSET CAP, FAB A NEW CAP, ALODINED, PRIMED AND PAINTED. THEN INSTALL FAB PART IAW EMB 135/145 SRM 51-30-03; SRM 51-40-02; 03; 04. ALL WORK WAS ACCOMPLISHESDR C2XA04SH445Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 19 TO 23. MAINTENANCE REMOVED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. MAINTENANCE WILL REPLACE THE AFFECTED BUTTSTRAP WHEN PART BECOMES AVAILABLE. THE AIRCRAFT WILL BE APSDR 2004UALA00599Structure · damagedFUSELAGE DAMAGE IN NOSE AREA AFT OF THE E&E DOOR. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER & SUPPLATE REPAIRS.SDR SWAA041753Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 967 TO BS 986.5, RBL 49, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR ASAA0410296Shear Tie · corrodedPAE - FOUND CORROSION ON SHEAR TIE. REMOVED, FABRICATED, AND INSTALLED SHEAR TIE REPAIR. (M)SDR SWAA041743Door Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR FRAME UPPER HINGE CUTOUT LOWER RADIUS, CRACKED. REPAIRED FRAME HINGE CUTOUT PER EA.SDR SWAA041737Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 872, RBL 60 TO RBL 67, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA041734Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND DOOR FRAME AT BS 303, STRINGER 16L, CRACKED. REPAIRED DOOR FRAME SECTION PER SB.SDR ABXA040237Shear Tie · crackedCRACKED SHEAR TIE AT FS 945 LONGERON 15 RT. REPLACED SHEAR TIE ON EA 53110008-202.SDR ABXA040236Shear Tie · crackedCRACKED SHEAR TIE AT FS 945 LONGERON 14 RIGHT. REPLACED SHEAR TIE ON EA 53110008-202. REPLACED SHEAR TIE ON E.A. 53110008-202.SDR AALA20040665Butt Joint · corrodedCIRCUMFERENTIAL JOINT SPLICE STRAP CORRODED AT FRAME 65 BETWEEN STRINGERS 54 AND 55L. AREA IS 2 INCHES BY 5 INCHES IN THE AFT CARGO AREA. INSTALLED NEW BUTTSTRAP AND BUTTSTRAP EXTERNAL DOUBLER PER ESO 30595 DATED 6/16/04.SDR C2XA04SH370Beam · corrodedSHV - DURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MASA200400344Structure · bird strikeRETURNED TO FIELD DUE TO A BIRD STRIKE DURING TAKEOFF ROLL. DAMAGE AT FWD FUSELAGE 1 CLOSE TO FRAME 5 AND STRINGER 6R INFORMATION WAS FORWARDED TO EMB. INITIALLY A/C WAS GOING TO FERRY TO BNA FOR REPAIR BUT EMBRAER STRUCTURAL ENGINEERING GRANTED A 500 FLT CYSDR IXXA060340SBeam · crackedDURING ROUTINE C CHECK, FOUND UPPER TRANSVERSAL BEAM CRACKED AT STATION Y260 -X45. REPAIRED PER ALL APPLICABLE DATA.SDR IXXA060339SBeam · crackedDURING ROUTINE C CHECK, FOUND UPPER TRANSVERSAL BEAM CRACKED AT STATION Y260 +X45. REPAIRED PER ALL APPLICABLE DATA.SDR SWAA041694Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 14L. REPAIRED SHEAR TIE PER SRM.SDR ABXA040227Stiffener · crackedP-DOME STIFFENER OUTBOARD END CLIP CRACKED AT LONGERON 14 RIGHT. REMOVED AND REPLACED CLIP IAW DC-9 DWG 9915558.SDR SWAA041678Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM ZEE CHORD AT BS 270, RBL 10, CORRODED. REMOVED AND REPLACED CREASE BEAM Z CHORD PER SRM.SDR C2XA04SH364Crossbeam · corrodedSHV - DURING C-CHECK THE CROSSBEAM AT FRAME 22 FROM THE RIGHT SILL TO THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CROSSBEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041670Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500, BL 0, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR AWXA200400694Beam · corrodedDURING C-04 CHECK CORROSION (PITTING) WAS FOUND ON THE Y-1292 BEAM AT FR66. MAINTENANCE REMOVED AND REPLACED Y-1292 BEAM SECTION FR 64-67 IAW A320 SRM 51-42-11 PG 5,6,7.SDR ABXA040226Shear Tie · corrodedSPOT OF EXFOLIATION ON SHEAR TIE, AFT SIDE OF FS 1123 CANTED AT LONGERON 3 LEFT. INSTALLED NEW CLIP, AFT SIDE FS 1123, LONGERON 3 LEFT IAW DC-9 SRM 51-30-2 AND 51-30-5.SDR UPS04842603Fitting · crackedINSPECTION TYPE:C2, C-PIT DOOR FRAME LOWER FWD LATCH BACKUP FITTING AT STATION 1168 LONG 34R APPROX IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3754930, AND SRM 51-1-20D.SDR 04FDEA01704Shear Tie · corrodedFWD CARGO COMPT BILGE AREA HAS A CORRODED SHEAR TIE FS 520, STR 26L - 27L. INSTALLED NEW SHEAR TIE IAW SRM 51-30-2.SDR C2XA04SH361Buttstrap · gougedSHV - DURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 22 AND 23 WAS FOUND TO BE GOUGED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH359Beam · corrodedSHV - DURING C-CHECK THE CARGO DOOR LOWER CUTOUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IXXA060216SDoor Frame · crackedDURING ROUTINE C CHECK FOUND FORWARD CARGO COMPARTMENT DOOR FRAME CRACKED AT THE UPPER AFT CORNER. REPAIRED DOOR FRAME PER ALL APPLICABLE DATA.SDR 05FDEA00044Rail · corrodedBULK CARGO DOOR JAMB RAIL P/N AFA3249-1 CORRODED APPROX AT STA 1755-1764. FILLER, CAP AND REPAIR ANGLE INSTALLED AFTER CORROSION REMOVAL IAW FEDEX EA 8-5310- 79980.SDR AALA20040796Failsafe · corrodedFAILSAFE FWD CARGO DOOR CUTOUT ANGLE HAS CORROSION REMOVAL BLENDOUTS ON LOWER SURFACE 2 LOCATIONS AT FASTENERS. DEPTH IS 0.030 INCH BY 0.021 INCH STA 591 & 527.65 SECTION 43 FWD CARGO. PERFORMED HIGH FREQUENCY EDDY CURRENT TO INSURE CRACK FREE. ROTOPEEN BLESDR DL73S040521Door Frame · unknownFASTENER INSTALLATION REQUIRED RADIUS BLOCKS AND OVERSIZED FASTENER WHILE PERFORMING EO 03-055852-03AD AT THE FWD SERVICE DOOR CUTOUT AFT FRAME. VA 72553AD ISSUED AND 8110-3 RECEIVED PROVIDING APPROVAL.SDR SWAA041656Strap · crackedL1 DOOR FRAME LOWER HINGE STRAP UPPER CORNER, CRACKED. REPAIRED L1 DOOR FRAME HINGE STRAP PER EA.SDR C2XA04SH348Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER FORWARD FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 203. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041633Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND RIGHT CREASE BEAM WEB AT BS 467, STRINGER 17R, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA041628Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 1040, STRINGER 23R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041658Fitting · crackedDURING SCHEDULED C3 CHECK, FOUND FWD ENTRY DOOR UPPER AND LOWER HINGE BOX FITTINGS CRACKED. REMOVED AND REPLACED UPPER AND LOWER HINGE BOX FITTINGS PER SRM.SDR MWEA040086Window Frame · lightning strikeLIGHTNING STRIKE ON LEFT SIDE CABIN WINDOW FRAME NR 34 ON AFT UPPER SIDE. BLENDED OUT DAMAGE, ACCEPTABLE FOR STRENGTH AS IS.SDR MWEA040085Window Frame · lightning strikeLIGHTNING STRIKE ON CABIN WINDOW FRAME 29 AFT LOWER SIDE. BLENDED OUT DAMAGE, ACCEPTABLE AS TEMPORARY REPAIR TO BE PERMANENTLY REPAIRED ON OR BEFORE 7,000 CYCLES.SDR MWEA040084Window Frame · lightning strikeLIGHTNING STRIKE ON LEFT SIDE CABIN WINDOW NR 29 FRAME ON LOWER FORWARD CORNER. BLENDED OUT DAMAGE, ACCEPTABLE AS TEMPORARY REPAIR TO BE PERMANENTLY REPAIRED ON OR BEFORE 7,000 CYCLES.SDR GTIA040600Doubler · crackedFTW - FOUND LEFT MLG INBOARD DOOR AFT DOOR JAMB HAS CRACK AR PREVIOUS REPAIR CRACK BEYOND STOP DRILL STATION 1003. REMOVED PREVIOUS REPAIR DOUBLER. STOPPED DRILL AT THE END OF CRACK. FABRICATED NEW REPAIR DOUBLER. INSTALLED DOUBLER. (M)
Back to JASC 5310