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 ASOA201101304Post · crackedFOUND FS 409.0+128 VERTICAL POST LBL18.0 INBD AND OTBD SIDES HAVE INDICATIONS NOTED APPROX .2" IN LENGTH 50 PERCENT FSH AT AFT FLANGE RADIUS WL69.0 FAILED NDT INSPECTION. REMOVED POST, LOCATED, DRILLED AND INSTALLED NEW VERTICAL POST IAW SRM 51-42-06 & 51-42-SDR SWAA114888Crease Beam · crackedDURING SCHEDULED 12Y CHECK, FOUND R1 DOOR CREASE BEAM ANGLE CRACKED. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR CHQA201100270Beam · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LOWER CARGO DOOR THRESHOLD BEAM BETWEEN FRAMES 65 & 68 AND STRINGERS 14R AND 15R. MAINTENANCE REPLACED THE LOWER CARGO DOOR THRESHOLD BEAM WITH NO FURTHER DEFECTS NOTED.SDR JR2R2011070700274Strap · corrodedTIE STRAP CORRODED AT FS 333. FROM STRINGER 25R TO 26R.SDR UIEA2011070600347Structure · damagedDURING LOADING OPERATIONS, THROUGH THE NOSE CARGO DOOR, LOADER DROPPED CAUSING DAMAGE TO BS 260, LBL10.75 & RBL 10.75, WL 195.8 - CANTED BULKHEAD STIFFENERS (2 EA.), CONSISTING IN EDGE CRACKS MEASURING 1.5 AND 2.5 INCHES LONG (REF FIG 1). DAMAGE TO THE STIFFENSDR FDEA201107052849Failsafe · corrodedFWD CARGO BS 620 BETWEEN STRINGER 3L - 26L FRAME FAILSAFE HAS DOUBLE DRILLED HOLES AND LIGHT CORROSION. REMOVED DAMAGED FAILSAFE, FABRICATED & INSTALLED NEW FAILSAFE IAW SRM 51-30-2, SRM 53-10-2 FIG 3, SRM 51-30-5, SRM 51-10-2 & FAS ER 2-37153-801 REV A, AND SDR AALA20110705TUL05Door Frame · corrodedAFT CARGO DOOR JAMB LOWER BEAM UPPER FRAME WEB CORRODED. INSTALLED WEB SPLICE PER AARD 53-10-00-24.SDR AALA20110705TUL03Pan · crackedLEFT HAND, STATION 1022 LOWER AFT WINDOW PAN EAR IS CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110705TUL02Pan · crackedRIGHT STATION 826 UPPER AFT WINDOW PAN EAR IS CRACKED. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR SWAA114843Window Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND LT FUSELAGE WINDOW FRAME STRUCTURE CRACKED ON POST, APPROX STR 19L. REPAIRED FRAME PER SRM.SDR SWAA114803Window Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT LOWER AFT WINDOW FRAME CRACKED AT BS 480+10. REPAIRED FRAME IAW TC.SDR DALA1147599016Window Frame · damagedLIGHTNING STRIKE ON LT WINDOW FRAME LOWER FORWARD CORNER STA Y=788-807 AT FUSE SKIN. DOUBLER REPAIR INSTALLED IAW 494589-14 REV ORIG.SDR N6WA20110702Structure · damaged"MAJOR REPAIR" BIRD STRIKE LT SIDE OF NOSE, JUST BELOW NOSE COWL. REPAIRED BIRD STRIKE ON LT SIDE OF NOSE JUST BELOW NOSE COWL IAW REO 670-51-00-071. PERFORMED NDT ON SKIN CUT OUTS AND FABRICATED PARTS IAW REO 670-51-00-071.SDR UIEA2011063000348Failsafe · damagedDAMAGE AT FUSELAGE, BS2200, S38L TO 40L FRAME FAIL SAFE (BS2200, S38L TO S40L FRAME FAIL SAFE CHORD REPAIR ACCOMPLISHED IAW RS 53-60-37121, REV A)SDR IPXA11567885Structure · corrodedINSPECTION TYPE:C-CK, UPPER CHORD OTBD FLANGE AT BS 900-1040, RBL 24, WL 208 HAS MULTIPLE AREAS OF OUT OF LIMITS CORROSION. R & R ENTIRE UPPER CHORD SECTION FROM BS 900-1040, RBL 24, WL 208 AND INSTALL IAW DRW 111N5207.SDR FDEA201106292500Doubler · corrodedCCORROSION AT LBL 25 SEAT TRACK, STA 1135 DOUBLER. REMOVED DOUBLER IAW SRM 51-10-3, FABRICATED DOUBLER IAW DWG 53FX939 AND TREATED AND PRIMED IAW SRM 51-10-2. INSTALLED DOUBLER IAW SRM 51-30-2.SDR AALA20110629TUL04Door Frame · bentWEB AFT OF FORWARD SERVICE DOOR FROM STATIONS 200 TO 207 BENT AT STRINGER 17 RIGHT. INSTALLED FORWARD SERVICE DOOR JAMB INNER WEBBING STATIONS 200 TO 208 PER SRM 51-70-04.SDR DALA1142010911Door Frame · corrodedCORROSION ON MID CARGO COMPT LOWER DOOR JAMB LOWER SURFACE AND OUTBOARD EDGE Y=631-645. REPAIRED PER ERA 493703-14 REV ORG.SDR SWAA114669Door Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND R1 DOOR FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME PER SRM AND EA.SDR SWAA114660Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR CREASE BEAM INNER CHORD CORRODED AT BS 325. REPAIRED CHORD PER SRM.SDR SIMA201117907Door Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 23 HAS A .5 INCH CRACK JUST ABOVE SERVICE THE DOOR SILL. REPAIRED FRAME 23 IAW EO EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1145460922Door Frame · corrodedCORROSION ON DOOR JAMB LOWER BEAM OF MID CARGO COMPARTMENT BETWEEN STA Y=636-693 AT C2 COMPARTMENT. REPAIR ACCOMPLISHED IAW MD88 SRM 53-05 FIG 123.SDR UALA2011062403110Door Frame · crackedDOOR 4R CUT-OUT FWD FRAME LOWER CORNER CRACKED. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR DOUBLER. ACCOMPLISHED ON GFS 0246890 & 0246930.SDR SWAA114642Crease Beam · crackedDURING SCHEDULED 26Y CHECK, FOUND RT CREASE BEAM LOWER FLANGE CRACKED AT BS 639, STR 17R. REPAIRED BEAM IAW EA.SDR ASAA11410093Failsafe · corrodedFRAME 827 CORRODED AT STR 22L AFT SIDE. REMOVED CORROSION AND REPAIRED FAIL SAFE CHORD IAW ASA EA 40053EA 05872.SDR ASOA201101220Post · crackedFOUND FS 409+128 VERTICAL POST BL 0.0 LT AND RT SIDES HAS INDICATIONS NOTED AT WL 69.0 AFT FLANGE RADIUS APPROX .3" IN LENGTH 80 PERCENT FSH. BOTH FAILED NDT INSPECTION. REMOVED POST ASSY IAW SRM 51-42-06. INSTALLED POST ASSY IAW SRM 51-42-06 AND REO 601R-SDR CA110623009Door Frame · crackedDURING 3000 CYCLE AIRFRAME INSPECTION, MX CREWS FOUND CRACKS ON AFT PASSENGER DOOR FRAME, PN 50-430043-865 FROM LOWER AFT LOCKING PIN TO THE PIN MOUNTING SCREWS. DOOR WAS REMOVED AND DISASSEMBLED. CRACKS WERE ALSO FOUND AT THE LOWER HINGE ATTACH CHANNEL PN 50SDR ASAA1149994Doubler · corrodedAFT CARGO DOOR CUTOUT FWD FRAME DOUBLER AND STRAP ARE CORRODED. REMOVED AND REPLACED DOUBLER AND STRAP IAW BAC DWG 65 47959 REV B.SDR CHQA201100257Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CARGO DOOR CUT OUT STRUCTURE FORWARD L-SHAPE. MAINTENANCE REPAIRED THE CARGO DOOR CUT OUT STRUCTURE FORWARD L-SHAPE IN ACCORDANCE WITH ETD 2011-145-101333. THE CRACKED SECTION OF SHEAR CLIP WAS REMOVED AND A NEW SDR UALA2011062303081Crease Beam · corrodedCORROSION ON CREASE BEAM INNER CHORD AROUND FASTENERS AT STA 1020 - 1040, MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION & FOUND OUT OF LIMITS PER SRM. ACCOMPLISHED NDT OF DAMAGE CUTOUT & HFEC SCAN OF HOLES COMMON TO REPAIR REF EA PD57-53-141. FABRICATED & INSDR AALA20110622TUL10Pan · crackedWINDOW PAN IS CRACKED AT STATION 1193 RIGHT LOWER FORWARD. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20110622TUL09Pan · crackedWINDOW PAN IS CRACKED AT STATION 1060 RIGHT LOWER FORWARD. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20110622TUL08Pan · crackedWINDOW PAN CRACKED AT UPPER AFT CORNER AT STATION 1022 LEFT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR ASOA201101262Panel · bentGROUND AIR CONDITIONING PANEL 172BR FWD & AFT LANDINGS ARE BENT. REMOVED SEALANT FROM REWORK AREAS IAW SRM 51-23-00. REF LINE ITEM 5 FOR APPLICATION OF SEALANT. C/W STEP 1 OF REO 601R-53-61-4105. STEP 2 OF REO 601R-53-61-4105 NEED C/W. C/W STEP 2 OF REO 601SDR EIAA2011064Door Frame · damagedBS 1800 LT MAIN CARGO DOOR FRAME HAS DOUBLE DRILLED HOLE BY WINDOW. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER B747 SRM 51-40-02 FIG 1 AND ENGINEERING DISPOSITION 003.SDR UALA2011062203061Crease Beam · corrodedCORROSION ON CREASE BEAM AT STA 997, RBL 64, WL 209. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION, BLENDED AREA, ACCOMPLISHED HFEC, NO CRACKS DETECTED IAW PEMCO EA PD57-53-145 ON PEMCO NR 2673N00384.SDR USAA2011071200007Door Frame · crackedQ4 CHECK - CRACK IN FORWARD LEFT ENTRY DOOR FRAME WEB DOUBLER AT LOWER DOOR STOP FITTING AT BS 303.9, S16L. REPLACED FORWARD LEFT ENTRY DOOR FRAME WEB IAW EO 5311-01025.SDR DALA1141270948Stop Fitting · corrodedDURING PSV IN MSP CORROSION WAS FOUND ON FWD DOOR STOP FITTING OF THE AFT CARGO DOOR L28R. CORROSION REMOVED AND DOUBLER INSTALLED PER SRM 53-05 FIGURE 123.SDR AALA20110619TUL01Crease Beam · corrodedCORROSION ON CREASE ANGLE WEB IN CABIN LEFT SIDE BETWEEN STATIONS 1020 AND 1040. REPLACED WEB PER AARD 51-10-05-1.SDR DALA1140193708Crease Beam · corrodedCREASE BEAM CORRODED 962-980 STR 17R WL 208. BLENDED PER ERA 492954-14 REV ORIG.SDR DALA1140173708Crease Beam · corrodedSTA 320 - 328 RBL 55 CREASE BEAM CORRODED. REMOVED AND REPLACED CREASE BEAM AND STRAP STA 259-360.SDR IPXA1M67717Door Frame · crackedINSPECTION TYPE:4C, R3 DOOR FWD JAMB LOWER LIGHTENING HOLE AFT LOWER CORNER STA 1256 IS CRACKED AS VEIWED FROM BACKSIDE WITH MIRROR. REPAIRED R-3 DOOR FORWARD JAMB LIGHTENING HOLE BY CRACK TERMINATION, FABRICATION AND INSTALLATION OF REPAIR DOUBLER REF SRM 53SDR GUUA94253061711ADoor Frame · crackedDURING SCHEDULED STRUCTURAL INSP, DISCOVERED AIRSTAIR DOOR FRAME CRACKED AT LOWER COUNTER BALANCE MOUNT. REMOVED DAMAGED PORTION OF ANGLE AND INSTALLED FRAME REPAIR SECTION.SDR HEEA131435Pan · crackedLT ENGINE PAN SKIN WAS FOUND TO BE CRACKED. OPENSDR SWAA114364Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 882 TO BS 887, WL 208. REMOVED AND REPLACED BEAM PER SRM.SDR ASOA201101191Beam · corrodedOP 115 AVIONICS BAY BEAM AT FS 349 BTWN STG 26L AND 26R IS CORRODED ON THE FWD SIDE. COMPLIED WITH EC/TC REO 601R-53-21-1299.SDR GLBA20110614FDoor Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, MX FOUND A CRACK IN THE CARGO DOOR FUSELAGE FRAME AT FS 509.5 BETWEEN STRINGERS 3L AND 4L INNER FACE OF FRAME AT 2 FASTNER HOLES, 2" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSSDR ASOA201101185Beam · corrodedAVIONICS BAY FUSELAGE BEAM AT FS 333.00 BETWEEN STR 26L- STR 26R IS CORRODED ON FWD AND AFT SIDE. COMPLIED WITH REO 601R-53-21-1299.SDR SWAA114342Window Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT WINDOW FRAME CRACKED AT BS 420+10. REPAIRED FRAME PER TC.SDR SWAA114343Window Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT WINDOW FRAME CRACKED AT BS 500+10. REPAIRED FRAME PER TC.
Back to JASC 5310