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 C2XA03SH042Shear Tie · corrodedDURING C-CHECK SHEAR CLIPS WHERE FOUND TO HAVE CORROSION BETWEEN FRAMES 56 TO 60 AND STRINGERS 21 LEFT AND 20 RIGHT. MAINTENANCE REMOVED AND REPLACED AFFECTED SHEAR CLIPS IAW EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR UPS03440335Door Frame · crackedINSPECTION TYPE: C L4, DOOR FWD LOWER CORNER CRACK FOUND AT VERTICAL RADIUS AS MARKED. LWR CORNER REPAIRED AS PER SRM 52-10-02 FIG 10.SDR UPS03440334Door Frame · crackedINSPECTION TYPE: C, R5 DOOR FWD LOWER CORNER CRACK FOUND AT VERTICAL RADIUS AS MARKED. LWR CORNER REPAIRED AS PER SRM 52-10-02 FIG 10.SDR 2003F00447Beam · crackedAT C-CHECK, FOUND CRACK AT AFT PRESSURE BULKHEAD VERTICAL BEAM, BS 1183, LBL 26.9, WL 260. STOP DRILLED CRACKS ON AFT PRESSURE BULKHEAD BS 1183, LBL 26.9 VERTICAL BEAM WL 260. LOCATED/DRILLED -UP KIT NR 65C33556-41 REPAIR ANGLE. TREATED AND PRIMED REPAIR ANSDR 2003F00434Beam · crackedAT C-CHECK, FOUND CRACK AT AFT PRESSURE BULKHEAD VERTICAL BEAM, BS 1183, RBL 26.9 WL 260. REPAIRED VERTICAL BEAM AFT PRESSURE BULKHEAD, BS 1183, RBL 26.9, WL 260. (M)SDR ASAA0380227Shear Tie · corrodedOKC - DURING 30K CHECK, FOUND SHEAR TIE CORRODED. REMOVED CORROSION. FABRICATED AND INSTALLED REPAIR SPLICE PER SRM. (M)SDR ASAA0380241Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO AREA HAS CORRODED SHEAR TIE. REPLACED SECTION OF DAMAGED SHEAR TIE PER SRM. (M)SDR ASAA0380235Angle · corrodedOKC - DURING 30K CHECK, FOUND CORROSION ON FORWARD ENTRY DOOR ESCAPE SLIDE GIRT BAR FITTING FORWARD MOUTN ATTACH ANGLE. REPLACED ATTACH ANGLE PER SRM. (M)SDR SIMA200309004Gusset · corrodedABI - THIS IS A LEVEL TWO FINDING FOUND DURING AN IMBV INSPECTION AFT DIAMOND GUSSET CORRODED. REMOVED AND INSTALLED SERVICEABLE AFT DIAMOND GUSSET IAW EMB 135 51-40-02. (M)SDR SIMA200389005Crossbeam · corrodedTHIS IS A LEVEL TWO FINDING, FOUND DURING AN IMBV INSPECTION CROSSBEAM CORRODED AT FRAME 22. REMOVED AND INSTALLED NEW CROSSBEAM SUPPORT IAW EMB 135/145 SRM 51-40-02, 51-20-03, 51-40-04, 51-40-06. (M)SDR UPS03440343Failsafe · crackedINSPECTION TYPE: C, RIGHT BS 2231 2 EA FASTENER HOLE CRACK REVEALED ON STRAP BELOW STR 25R REFER FIGURE ATTACHED. M/D - RIGHT BS 2231 STR 25 REVEAL PANEL STRAP REPAIRED AS PER SRM 53-10-04 FIG 115.SDR C2XA03SH37Butt Strap · corrodedDURING C-CHECK CORROSION WAS FOUND ON CENTER BUTT STRAP BETWEEN FRAMES 59 AND 61. MAINTENANCE REMOVED AND REPLACED AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR ASAA0310104Shear Tie · corrodedOKC - DURING D-CHECK, FOUND SHEAR TIE AT BS 986, STRINGER 23R CORRODED. REMOVED AND REPLACED SHEAF TIE PER SRM. (M)SDR ASAA0310106Shear Tie · corrodedOKC - DURING D-CHECK, FOUND SHEAR TIE AT BS 1006, STRINGER 24R-25R CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR GTIA030249Beam · corrodedFTW - FOUND AFT LOWER CARGO, LOWER JAMB DOOR CUTOUT OUTBOARD BEAM CORRODED STATION 1155 TO STATION 1211. FABRICATED 1 DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA030235Beam · corrodedFTW - FOUND MID LOWER CARGO LOWER DOOR JAMB CUTOUT OUTBOARD BEAM CORRODED STATION 693-636. REMOVED CARGO DOOR JAMB BEAM. DRILLED AND LOCATED HOLES IN NEW DOOR JAMB BEAM. INSTALLED NEW DOOR JAMB BEAM. (M)SDR ASAA0340117Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT SHEAR TIE AT BS 787 RBL 18 AND WL 156. REPAIRED IAW SRM. (M)SDR UPS03840347Fitting · corrodedINSPECTION TYPE: C2, LONGERON 24L HAS A FITTING CORRODED BEYOND LIMITS AT STA 920. REMOVED AND REPLACED FITTING, FABRICATED AND INSTALLED SPLICES, DOUBLERS AND FILLERS IAW SRM 53-2-0 FIG 8 AND DWG 5753113.SDR UPS03440337Longeron · corrodedINSPECTION TYPE:C FWD CARGO COMP - STA 740 S47R STINGER SPLICE HEAVY CORROSION REVEALE D STRINGER SPLICE REPLACED AS PER SRM 51-10-01 P.8. (DEPTH 0.040", WIDTH 1", LENGTH 2")SDR UPS03440336Fitting · crackedINSPECTION TYPE:C LH BS 1480 B/H - CRACKS REVEALED ON THE OUTER CHORD SPLICE FITTING HOLE #23 RUNNING I/B & O/B & ALL GREATER THAN 0.100" LONG. PLS REFER FIGURE ATTACH. OUTER CHORD SPLICE FITTING HOLE #23 CRACK OUT OF SB 747-53A2390 LIMIT FITTING REPLACED SDR UPS03240320Bracket · crackedINSPECTION TYPE:C FWD.CARGO DOOR FUSELAGE CUTOUT AFT LWR.DOOR STOP FITTING CRACKED. FABRICATED NEW BRACKET IAW.SRM.51-20-1 REPLACED BRACKET IAW SRM 51-30-2.SDR UPS03M40261Door Frame · corrodedINSPECTION TYPE: 1C, COMPLY WITH D 234863: FWD LOWER CARGO DOOR FRAME CORRODED STA 895 AT LONGERON 41R AND 43R PERM REPAIR AT C-CHECK (REF ATTACHED EO MD11-53 20-17569-A). GAINED ACCESS TO REPAIR AREA CUT OUT DAMAGED AREA AT FS 895 IAW SRM 53-30-00, FABRICATSDR ASAA0380200Fitting · corrodedOKC - DURING 30K CHECK, LEFT FORWARD PASSENGER L-1 DOOR EMERGENCY SLIDE GIRT BAR AFT FLOOR FITTING IS CORRODED AT FS 180. REPLACED FITTING PER SRM 53-01. (M)SDR ASAA0310082Hinge Fitting · corrodedOKC - DURING D-CHECK, FOUND RT MLG STRUT DOOR HINGE FITTING AT BS 685, WING STATION 114R CORRODED. REMOVED AND REPLACED FITTING PER SRM. (M)SDR ASAA0310076Shear Tie · crackedOKC - DURING D-CHECK, FOUND SHEAR TIE CLIP AT BS 827, STRINGER 13L CRACKED. REMOVED AND REPLACED SHEAR TIE CLP PER SRM. (M)SDR ASAA0310078Shear Tie · corrodedOKC - DURING D-CHECK, FOUND SHEAR TIE AT BS 1016, STRINGER 24L CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR UPS03440342Strap · crackedINSPECTION TYPE: C, CRACKS FOUND AT BS 2231 RT INBOARD ATTACHED STRAP, THE CRACKS RUNNING FWD AND AFT DIRECTION OF ONE EACH FASTENER HOLE AND CRACKED THROUGH THICKNESS. M/D - RIGHT BS 2231 STR 24-25 REVEAL PANEL STRAP REPAIRED AS PER SRM 53-10-04 FIG 115.SDR UPS03440333Bracket · crackedINSPECTION TYPE:C FWD CRACKS WITH THROUGH THICKNESS FOUND AT ONE EACH FASTENER HOLE AT TIE CLIP AT THE I/B CHORD AT STR 25L OF BS 2231. TIE CLIP REPLACED AT BS 2231 STR 25L AREA AS PER SRM 51-10-01 PG.8.SDR ASAA0380198Door Frame · gougedOKC - FOUND DURING 30K CHECK, AFT PASSENGER DOOR LOWER FRAME HAS GOUGES. REPLACED FRAME PER SRM 52-01. (M)SDR ASAA0380196Bracket · corrodedOKC - DURING 30K CHECK, FOUND AFT SERVICE (L-2) DOOR EMERGENCY SLIDE AFT GIRT BAR FLOOR BRACKET IS CORRODED. REPLACED BRACKET PER SRM 53-01. (M)SDR 03FDEA00195Shear Tie · corrodedCORROSION ON SHEAR TIE, BS 720 NEXT TO STR 26R. REMOVED CORROSION ON SHEAR TIE, BS 720 BETWEEN STR 26-27 RIGHT, FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGE, FABRICATED, ALODINED AND PRIMED REPAIR PARTS. INSTALLED REPAIR, ALL WORK ACCOMPLISHED IAW SRM 51-10-3,SDR 03FDEA00194Crease Beam · corrodedCORROSION (C55-224-01) ON TOP OF FCD CREASE BEAM BS 325-40 LBL 60. REMOVED CORROSION ON TOP OF CREASE BEAM BS 325-340, OUT OF LIMITS PER SRM 53-10-1. REMOVED AND REPLACED CREASE BEAM PER SRM 51-30-2, 51-10-2, 51-30-5.SDR ASAA0340102Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727F RBL 10 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340101Shear Tie · corrodedDURING C-CHECK, FOUND CORROSON ON SHEAR TIE BS 727F LBL 4 AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA0340103Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 767 RBL 13 AND WL 160. REPAIRED IAW SRM. (M)SDR ASAA0340100Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE BS 727E RBL 11 AND EL 159. REPAIRED IAW SRM. (M)SDR ASAA0340099Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 727D RBL 1 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0310060Stringer Clip · crackedOKC - DUIRNG D-CHECK, FOUND STRINGER TIE AT BS 1156, STRINGER 12L CRACKED. REMOVED AND REPLACED STRINGER TIE PER SRM. (M)SDR ASAA0310057Mount · corrodedOKC - DURING D-CHECK, FOUND CARGO DOOR HINGE MOUNT PLATES AT BS 456, STRINGER 18R CORRODED. REMOVED AND REPLACED MOUNT PLATES PER SRM. (M)SDR C2XA03SH033Stop · crackedSHV- DURING C-CHECK THE FOWARD EXTERNAL FRAME ON CARGO DOOR WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FRAME IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR ASAA0340091Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727D RBL 8 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340092Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 827 LBL 2 AND WL 158. REPAIRED IAW SRM. (M)SDR ASAA0340094Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727B RBL 1 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340097Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 727B RBL 11 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340096Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE AT BS 727D LBL 2 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340095Shear Tie · corrodedPAE - DURING C-CHECK, FOUND CORROSION AT BASE OF SHEAR TIE BS 727C RBL 9 AND WL 159. REPAIRED IAW SRM. (M)SDR ASAA0340093Shear Tie · corrodedDURING C-CHECK, FOUND CORROSION AT BASE OF THE SHEAR TIE AT BS 727B LBL 2 AND WL 159. REPAIRED IAW SRM. (M)SDR AALA20030343Shear Tie · crackedTUL - FOUND STATION 1437 FRAME, AFT SHEAR TIE CRACKED AT FASTENER. REMOVED AND REPLACED SHEAR TIE AT STATION 1473 PER SRM 51-10-01. (M)SDR GTIA030204Door Frame · crackedFTW - FOUND L-1 DOOR UPPER FRAME AFT OUTER RADIUS CRACKED. STOP DRILL CRACK. (M)SDR GTIA030205Door Frame · crackedFTW - L1 DOOR UPPER FRAME FORWARD OUTER RADIUS CRACKED. STOP DRILLED CRACK. (M)
Back to JASC 5310