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 SWAA102656Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 500B TO BS 500C. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA102643Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME ANGLE CRACKED AT R1 DOOR LOWER FWD CORNER CUTOUT. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA102638Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, LBL 67. REMOVED AND REPLACED WEB PER SRM.SDR SWAA102637Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, RBL 67. REMOVED AND REPLACED WEB PER SRM.SDR SWAA102636Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 400 TO BS 420, RBL 67. REMOVED AND REPLACED WEB PER SRM.SDR SWAA102624Crease Beam · crackedDURING SCHEDULED 12Y CHECK, FOUND L1 CREASE BEAM CRACKED AT BS 303.9. REMOVED AND REPLACED BEAM PER SRM.SDR AALA20100505TUL06Beam · corrodedLIGHT CORROSION AROUND RIVNUT HOLES ON DOOR BEAM STATIONS 636 TO 655. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-10-00-3.SDR ASOA201000688Support Beam · crackedFOUND CARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IS CRACKED APPROX .3" IN LENGTH. R & R CARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IAW SRM 51-42-21.SDR AALA20100504TUL09Beam · corrodedCORROSION ON DOOR CUTOUT BEAM STATIONS 1174 TO 1193. INSTALLED BEAM DOUBLER PER AARD 53-10-00-03.SDR DALA1012490998Door Frame · corrodedCORROSION ON FWD DOOR JAMB PAN, PREVIOUS REPAIR STA Y=370 BTW LONGS 28RT AND 26 RT REPAIR IAW 53-05D, FIG 804D.SDR DALA1011960998Door Frame · corrodedCORROSION LWR DOOR JAMB BEAM PREVIOUS REPAIR STA1155-1212. REPAIR WAS ACCOMPLISHED IAW SRM 53-05, FIG 123. (DLM88101399)SDR IPXA10659817Failsafe · crackedINSPECTION TYPE:C, CRACKS WERE FOUND AT BS 955 BULKHEAD RT SIDE LOWER BOLT HOLE AT FAIL SAFE STRAP RUNNING 4 AND 9 O'CLOCK POSITION WITH THROUGH THICKNESS INDICATION. FUSELAGE STA 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP REPAIRED IAW UPS EO B767-53SDR IPXA10659816Failsafe · crackedINSP TYPE:C, CRACKS WERE FOUND AT BS 955 BULKHEAD LT SIDE AT LOWER BOLT HOLE OF FAIL SAFE STRAP CRACK RUNNING FWD & AFT WITH THROUGH THICKNESS INDICATION. FUSELAGE STA 955 REAR SPAR BULKHEAD SIDE FITTING FAIL SAFE STRAP REPAIRED IAWUPS EO B767-5350-17922 APPESDR SWAA102586Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 335 TO BS 341, STR 17L. REPAIRED BEAM PER SRM.SDR GUUA94153050410BShim · corrodedDURING SCHEDULED ROUTINE INSP DISCOVERED CORROSION FS 363 FWD AND AFT OF ANGLE BETWEEN STRINGERS 15L AND STRINGER 16. REMOVED AREA OF CORROSION AND REPLACED SECTION OF DAMAGED SHIM.SDR GUUA94153050410AStringer · corrodedDURING SCHEDULED ROUTINE INSP DISCOVERED INTERIOR CORROSION APPROX FS 258, STRINGER 14L, FWD OF ANGLE AT SPLICE AREA OF STR 14L. REMOVED DAMAGED SECTION OF STRINGER AND SPLICED IN NEW STRINGER AND INSTALLED EXTERNAL DOUBLER REPAIRS.SDR IPXA10659815Failsafe · crackedINSPECTION TYPE:C, BS 955 WL 200 SUSPECTED CRACK INDICATIONS WERE FOUND AT BOTH LT AND RT OF BS 955 FAILSAFE STRAP. FUSELAGE BS 955 REAR SPAR BULKHEAD SIDE FITTINGS FAILSAFE STRAPS REPAIRED IAW UPS EO B767-5350-17922 APPENDIX C & D.SDR IPXA10559801Door Frame · gougedINSPECTION TYPE:C2, MAIN CARGO DOOR FRAME GOUGED AT BS 530 WL 213. REPAIRED IAW ER 10-2663.SDR ASOA201000679Doubler · corrodedFS 280 REINFORCEMENT DOUBLERS, 2EA ON LT SIDE AT LBL9.0 AND 1EA ON RT SIDE AT RBL9.0 ARE CORRODED AND REQUIRE REPLACEMENT. (EC) (RESOLVED ON W/O: 155620 TASKCARD: N/R-00417 ) FABRICATED NEW BA670-30069-7 DOUBLER, USING S6144-33 SALVAGE ANGLE P/O T000002550 IAWSDR SWAA102554Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 400 TO BS 420, LBL 67. REPAIRED BEAM PER SRM.SDR SWAA102552Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 767 TO BS 787, WL 208. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA102548Web · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM FLOOR WEB CORRODED BETWEEN BS 440 TO BS 460, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR FDEA201005031430Crease Beam · corrodedL-3 DOOR INBD CREASEBEAM CORRODED AT STA 1348 LBL 60. REMOVED CORROSION FROM LT SIDE IB CREASE BEAM CHORD AT STA 1290-1370 IAW SRM 51- 10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-15 FIG 101 DETAIL VII. ORIG MATERIAL .100 AFTER REWORK .083 L=1.0 W=1.0. SDR V0XR201005030023Bolt · corroded(V0XR) NR 1 RUDDER ACTUATOR CTR ATTACHMENT BOLTS ARE CORRODED BEYOND LIMITS. R & R ACTUATOR BOLTS.SDR V0XR201005030018Guide · broken(V0XR) LEFT NR 2 CABLE GUIDE BROKEN. R & R CABLE GUIDE. W/C 1118.SDR V0XR201005030011Structure · cracked(V0XR) RT SIDE BOTTOM PART OF VERTICAL AT FR 77 STG 01L IS CRACKED BEYOND LIMITS. R & R SHAPE L, W/C 3058.SDR SWAA102541Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 807 TO BS 827, STR 17L. REPAIRED BEAM PER SRM.SDR IPXA10559651Panel · corrodedINSPECTION TYPE:C2, PANEL 198KR HAS CORROSION ON INTERNAL SURFACE. FABRICATED REPLACEMENT PANEL IAW SRM 51-40-05.SDR SWAA102470Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT GALLEY RT CREASE BEAM CORRODED BETWEEN BS 955 TO BS 986, RBL 51. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA102383Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FWD FRAME CRACKED AT BS 440, AT NR 5 STOP PAD FITTING. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA102367Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 827 TO BS 847, STR 17L. REMOVED AND REPLACED BEAM PER SRM.SDR AALA20100427TUL02Pan · crackedNUMBER 39 RIGHT WINDOW PAN CRACKED UPPER FORWARD CORNER AT STATION 946. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR DALA1012460998Window Frame · damagedLIGHTNING STRIKE ON WINDOW BELT FRAME FWD AND AFT UPPER EDGE STA Y=636 TO 655 REPAIR IAW ERA 481744-14.SDR DALA1012380998Window Frame · damagedLIGHTNING STRIKE ON WINDOW BELT FRAME FWD AND AFT EDGE STA Y=617 TO 636. REPAIR IAW ERA 481744-14, REV ORG. (DLM88101405)SDR DALA1012360998Window Frame · damagedLIGHTNING STRIKE ON WINDOW BELT FRAME LOWER EDGE STA Y=522 TO 541 REPAIR IAW ERA 481744-14, REV ORG. (DLM88101403)SDR ASOA201000649Beam · corrodedBS 280 BEAM LT & RT SIDES BADLY CORRODED. ALL WORK DONE IAW SRM 51-42-06 AND SRM 51-42-21.SDR V0XR201004270006Structure · corroded(V0XR) LT DIGITAL AT LY-479.0 FR 18-23 IS CORRODED BEYOND LIMITS. R & R LT DIGITAL. W/C 1061.SDR ECPR466DAASupport Angle · cracked(ECPR) THE LT AND RT BATTERY BOX SUPPORT ANGLE ASSEMBLIES, PNS 35846-02 & 35846-03, WERE FOUND CRACKED JUST INBD, TOWARDS THE BATTERY BOX, OF THE BOTTOM FIREWALL ATTACH HOLES. THE CRACKS WERE BETWEEN THE ACTUAL HOLE AND THE START OF THE CURVED PORTION OF THE ASDR ASOA201000641Beam · corrodedCORROSION FOUND ON BEAM BULKHEAD AT RBL 9 FS 693.00. CORROSION ON RBL9 BULKHEAD BEAM IS OUT OF LIMITS, NO DAMAGE ALLOWED IAW SRM 53-41-10-101-001-AO1. FWD LOCATION DRILLOUT DAMAGE HOLE TO 5/32 & SPOTFACE LOWER AFT LOCATION DILLOUT DAMAGE HOLE TO 5/32 & SPOTSDR QMLR MB270Door Frame · crackedAPPROX 2 INCH CRACK ON UPPER EXTERIOR LT DOOR BOXFRAME STRUCTURE WITH LOCALIZED DISTORTION OF SKIN. RT UPPER EXTERIOR DOOR BOX FRAME HAS LOCALIZED DISTORTION.SDR AALA20100425TUL02Beam · corrodedDOOR BEAM HAS CORROSION STATIONS 1155 TO 1211. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-3.SDR DLM88100989Beam · corrodedEXFOLIATING CORROSION ON DOORJAMB LOWER BEAM BTW STA Y=370 TO Y=427 AT FWD CARGO COMPT REPAIRED IAW SRM 53-05.SDR DLM88100987Beam · corrodedEXFOLIATING CORROSION ON AFT CARGO COMPT LOWER DOOR JAMB BEAM FORM STA 1155 - 1212. REPAIRED IAW SRM 53-05.SDR DLM88100986Door Frame · damagedINADEQUATE DRILL HOLES ON C-1 DOOR LOWER DOOR JAMB AFT EDGE THRU WEB DOOR JAMB PAN AND BEAM AREA REPAIRED IAW ERA 481732-14, REV ORG.SDR EVCA00003Support · crackedDURING A ROUTINE INSP, MECHANIC FOUND RT (PILOT) SUPPORT ASSY CRACKED. SUPPORT ASSY R & R.SDR DL757100974Door Frame · unknownDUE ADF FS SECT 46 DOOR NR 4 AFT FRAME BODY STA 1681 EA 06-465922-03 ADME 02 EA 06-465922-03AD C/W DURING HMV AT SAA IN SAT ON RTN CARDS E114-116.SDR CALA2010042600162Door Frame · crackedSUPPORT TASK FWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT DOOR STOP ATTACHMENT HOLE AT S-22R REFERENCE EA 5310-0444E REV C. REMOVED AND REPLACED CRACKED FRAME PER SRM 51-40-02.SDR DLM88100981Window Frame · damagedDURING ACCOMPLISHMENT OF PERM REPAIR TO LIGHTNING STRIKE DAMAGE AT STA 292 FOUND ADDITIONAL LIGHTNING DAMAGE TO WINDOW BELTS BTWN 522-544 AND 541-560SDR FDEA201004231342Web · crackedLT STAIRWELL BS 1279 LOWER VERT TORQUE BOX WEB IS CRACKED AT LIGHTENING HOLE. REMOVED DAMAGED AREA IAW SRM 51-10-1, REV 102. FABRICATED NEW DOUBLER USING MATERIAL 7075 T-6 .032", PO NR. 9009134, DIM 1" X 4" IAW SRM 53-10-2 FIG 6 AND 51-40-1 FIG 1. INSTASDR FDEA201004231341Web · crackedLT STAIRWELL BS 1266 VERT TORQUE BOX WEB IS CRACKED ON LIGHTENING HOLE. ROUTED OUT DAMAGED AREA .3" X .3750" IAW SRM 51-10-1, REV 102. FABRICATED REPAIR DOUBLER USING 7075 T-6 .032", DIM 1" X 4" IAW SRM 53-10-2, FIG 6 AND 51-40-2 FIG 1. INSTALLED REPAIR DOUBL
Back to JASC 5310