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 GAIA03099Beam · crackedDURING B-2 CHECK, FOUND BS 1183 VERTICAL BEAM CRACKED LBL 36 INCHES WL 250. REF FASI N/R 53249, INSTALLED REPAIR PER S/B 727-53-0192 REV 2. (M)SDR IXXA060541SMount · corrodedDURING ROUTINE C CHECK, FOUND ANTENNA MOUNT CORRODED AT STATION FS410, LONGERON 36. ANTENNA NOT IN USE, REMOVED MOUNT IAW TIMCO REPAIR ENGINEERING ORDER REO-G09474.SDR ABXA030374Shear Tie · crackedSHEAR TIE CRACKED, FS 1021 AT LONGERON 14 RIGHT. REPLACED SECTION OF SHEAR TIE IAW DC-9 SRM.SDR 03FDEA01468Door Frame · crackedMAIN CARGO DOOR STUB FRAME IS CRACKED AT O/B FLANGE THRU FASTENER HOLE, 69 INCHES AFT OF FWD FRAME 3 INCHES BELOW UPR FRAME. REPLACED PER SRM 51-30-2.SDR 03FDEA01469Structure · corrodedCORROSION ON STRUCTURE IN NLG BAY AT BS 284 RBL 18 INSIDE TORQUE BOX O/B OF STRUT DOOR FWD HINGE. REMOVED AND REPLACED PER SRM 51-30-2.SDR 03FDEA01470Door Frame · crackedMAIN CARGO DOOR STUB FRAME IS CRACKED AT O/B FLANGE THRU FASTENER HOLE 49 INCHES AFT OF FWD FRAME, 3 INCHES BELOW UPPER FRAME. REMOVED AND REPLACED PER SRM 51-30-2.SDR AUS20030912Structure · corroded(AUS) LT TAILBOOM LOWER STRUCTURE CORRODED IN AREA OF ATTACHMENT TO WING STRUCTURE. CORROSION IS BOTH INTERNAL AND EXTERNAL. RT TAILBOOM CONTAINED INTERNAL CORROSION ONLY.SDR A6WA200360037Door Frame · gougedAFT CARGO DOOR OUTSIDE DOOR SURROUND GOUGED AT TOP AFT RADIUS MAINTENANCE REQUESTED REPAIR FROM BAE REF AVMAX FAX NR 1655-6060004. (M)SDR UPS03441261Door Frame · crackedINSPECTION TYPE: C, L4 DOOR FWD CUT-OUT REVEAL UPPER CRACKED.BS1664 S-17 & S-18 M/D- L4 DOOR FWD CUT-OUT REVEAL REPAIRED AS PER RS R-53-62-35069 AND UPS ENGINEERING FILE NO 747-53-20153SDR UPS03441258Shear Tie · crackedINSPECTION TYPE:C AFT CARGO COMPT- BELOW FLOOR SUPPORT FRAME LOWER SHEAR TIE PLATE FOUND CRACKED AT STA 1880 LT SIDE STRG 45L. SHEAR TIE REPAIRED IAW SRM 53-10-04 FIG 41 AT AFT CARGO COMPT STA 1880 BETWEEN S45L.SDR UPS03441257Shear Tie · crackedINSPECTION TYPE: C, AFT CARGO COMPT- BELOW FLOOR SUPPORT FRAME LOWER SHEAR TIE PLATE FOUND CRACKED AT STA 1880 LT SIDE STR 44 LT. SHEAR TIE REPAIRED IAW SRM 53-10-04, FIG 41 AT AFT CARGO COMPT STA 1880, BETWEEN S44L.SDR UPS03441256Shear Tie · crackedINSPECTION TYPE:C AFT CARGO COMPT - BELOW FLOOR SUPPORT FRAME LOWER SHEAR TIE PLATE FOUND CRACKED AT STA 1880 LT SIDE STR 43 LT. DEFECT SHEAR TIE TRIMMED OUT IAW SRM 51-10-01 AND PERFORMED SHEAR TIE REPAIRED IAW SRM 53-10-04 FIG 41 AN AREA PAINT TOUCHED UP.SDR GTIA030808Beam · corrodedFOUND AFT PIT DOOR BEAM CORRODED ENTIRE LENGTH. REMOVED AFT PIT DOOR BEAM. LOCATED AND DRILLED NEW BEAM. INSTALLED NEW AFT PIT DOOR BEAM. (M)SDR A6WA200360035Structure · crackedFOUND CRACK AT RIVET LOCATION JUST AFT OF FRAME 29 STRINGER 13 LT. MAINTENANCE REQUESTED REPAIR FROM BAE REF AVMAX FAX NR 1655-6060002. (M)SDR UPS03441253Door Frame · crackedINSPECTION TYPE: C, M/D, RT NR 4 DOOR FORWARD FRAME MOST UPPER DOOR FITTING AREA FOUND CRACK. FORWARD FRAME CRACKED AREA REPAIRED IAW RS NR R52-11-35065 AND UPS AUTH NR 747-52-20006.SDR GTIA030695Door Frame · crackedFTW - FOUND L1 DOOR AT DOOR CUTOUT AFT WEB CRACKED TWO PLACES. CUT OUT DAMAGED AREA. FABRICATED DOUBLER. INSTALLED DOUBLER. (M)SDR AWXA200301128Shear Tie · crackedLCQ - MAJOR REPAIR - DURING C-16 CHECK A .6250 INCH CRACK WAS FOUND ON STRINGER TIE CLIP (SHEAR TIE) AT BS 632, STR 1 RT. MAINTENANCE REMOVED CRACKED SHEAR TIE AT BS 632, STR 1 RT; FABRICATED A NEW REPLACEMENT SHEAR TIE; INSTALLED REPAIR PART IAW B737-300 SDR UPS03441268Door Frame · crackedINSPECTION TYPE: C, M/D- R1 DOOR AFT UPPER STOP FITTING AREA DOOR FRAME FOUND CRACK. M/D - R1 DOOR AFT UPPER STOP FITTING AREA DOOR FRAME REPAIRED AS PER RS R52-11-35073 AND UPS ENGINEERING FILE 747-52-20007.SDR SWIA200312490Window Frame · crackedLEFT DV WINDOW AFT BRACKET CRACK FRAME 12/13 DAMAGE OUT OF LIMITS. DISCOVERED DURING C-CHECK. REPLACED BRACKET AT FRAME 12/13 CENTER OF LEFT DV WINDOW PER SRM 51-40-00.SDR AWXA200301135Shear Tie · corrodedLCQ - MAJOR REPAIR - DURING C-16 CHECK EXFOLIATION CORROSION WAS FOUND FLOOR SUPPORT SHEAR TIE AT BS 500, LBL 1. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGE FROM BS 500 FROM BL 0 TO LBL 5; FABRICATED A REPAIR ANSDR SWAA031977Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 727D + 10 AND BS 887 + 4, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR UPS03441316Shear Tie · corrodedINSPECTION TYPE: C, FX - BS 2300 FRAME BELOW FLOOR SHEAR TIE FOUND CORRODED AS MARKED AT BL 0. CORROSION BLEND OUT 0.050 X 1 X 2 INCH. M/D BS 2300 BL SHEAR TIE REPAIRED PER SRM 53-10-04 FIG 3.SDR UPS03441313Panel · bulgedINSPECTION TYPE: C, M/D BS 1241-1244, RBL 8 - 11 BELOW FLOOR CANTED BULKHEAD APU FUEL LINE CLOSEOUT PANEL FWD RT CORNER BULGE UP AND RIVET SHEARED. CORROSION BLEND OUT 0.035 X 1.5 X 4 INCH. EXISTING DOUBLER REMOVED AND NEW EXTENDED DOUBLER REPAIR AS PER RS SDR C2XA03SH314Door Frame · corrodedSHV-DURING C CHECK THE CARGO DOOR CUT OUT LOWER BEAM WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2003UALA00659Door Frame · crackedFWD RT DOOR CUT OUT FRAME IS CRACKED BELOW THE UPR STOP FITTING. MAJOR REPAIR ACCOMPLISHED, INSTALLED FRAME.SDR CALA0300506Shear Tie · corrodedINSPECTION FOUND FORWARD BAGGAGE BIN SKIN SHEAR TIE CORRODED AT STA 460, S28R. THE CORRODED AREA WAS CUT OUT AND A REPAIR DOUBLER AND SHEAR TIE WERE INSTALLED IAW SRM 53-00-07.SDR C2XA03TY143Door Frame · corrodedTYS DURING A SCHEDULED 2C INSPECTION THE AREA UNDER THE BAGGAGE DOOR LOWER TRIM WAS CORRODED. MAINT R&R THE CARGO DOORWAY LOWER BEAM IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE REL. UPON COMPLETION OF ALL WORK.SDR EIA2003112Shear Tie · corrodedSHEAR TIE L-ANGLE AT BS 2220 HAS HEAVY CORROSION ON BOTTOM LOWER FLANGE STR. 37L TO 41L. REMOVED DAMAGED, FABRICATED AND INSTALLED REPAIR IAW B747 SRM 51-40-03 FIG 1, 51-10-01, 51-10-02, 51-30-02 AND BSOPM 20-41-2.SDR CALA0300504Door Frame · crackedINSPECTION FOUND A 7.5 INCH CRACK IN FORWARD BAGGAGE BIN WEB AT FORWARD LOWER DOOR JAMB, STA 440. A NEW SECTION OF WEB WAS INSTALLED IAW SRM 51-70-13.SDR SWAA031935Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 639 RT SIDE. REPAIRED WEB PER SRM.SDR SWAA031934Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND BS 480, FUSELAGE SHEAR TIE CORRODED AT STR 27L. REPAIRED SHEAR TIE PER SRM.SDR UPS03841187Angle · crackedINSPECTION TYPE: C1, MIDSHIP ACCESSORY COMPARTMENT RT SIDE AT STA 670 L28R IS CRACKED. REMOVED DAMAGE IAW DC8 SRM 53-2-0. FOUND OUT OF LIMITS IAW DC8 SRM 53-2 -0(ORIG-.062 AND REMAINING-.017). FABRICATED REPAIR ANGLE IAW DC8 SRM T R53-122. ALODINED AND PRISDR SWAA031921Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 13R AND 15R. REPAIRED SHEAR TIE PER SRM.SDR C2XA03SH295Door Frame · corrodedSHV-DURING C CHECK THE CARGO DOOR 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 AMTA200301102Shear Tie · crackedFRAME, SHEAR TIE CRACKED AND CORRODED OUT OF LIMITS AT FS 1800 FROM STRINGER 33 TO STRINGER 36. REMOVED CRACKED AND CORRODED SECTION OF SHEAR TIE AND REPLACED WITH NEW SECTION IAW SRM 51-40-01. (M)SDR SIMA200324603Beam · corrodedABI - DURING AN IMBV INSPECTION, THE GALLEY CENTER BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. PERFORMED CUT OUT OF THE DAMAGED AREA. FABRICATED REPAIR DOUBLER. REPAIR DONE IAW EMB 145 SRM, SRM EMB 145/1142 REV 22, CHAPTERS 53-21-10 PARA 5 FSDR GTIA030812Door Frame · corrodedFOUND AFT PIT LOWER DOOR JAMB BEAM CORRODED. (M)SDR MWEA030325Door Frame · corrodedFORWARD PIT LIGHT CORROSION ON LOWER DOOR JAMB AROUND FORWARD DOOR STOP. FABRICATED AND INSTALLED REPAIR AND SPLICE.SDR ARWA20030807Door Frame · crackedDURING ROUTINE INSPECTION THE FOLLOWING WAS FOUND; AFT SERVICE DOOR JAMB, AFT TOP CORNER WITH CRACK OF 1.125 INCH. REPAIRED THE AFT SERVICE DOOR JAMB AFT TOP CORNER IAW SRM 53-2-0 FIG 16, SHEETS 4, 5, 6, 7 & 8 TEMPORARY REVISION 53-156, DATED 12/20/02. (EA 10SDR ARWA20030806Door Frame · crackedDURING ROUTINE INSPECTION THE FOLLOWING WAS FOUND; AFT ENTRANCE DOOR JAMB AFT BOTTOM CORNER WITH CRACKS OF 0.625 & 0.437 INCH. REPAIRED THE AFT ENTRANCE DOOR JAMB AFT BOTTOM CORNER IAW SRM 53-2-0 FIG 18, SHEETS 1, 5, 6, 7 & 8, TEMPORARY REVISION 53-134 & TEMPSDR 2003UALA00645Crease Beam · corrodedMAIN CABIN AT BS 987 TO 995 AT RBL 48 CREASE BEAM WEB CORRODED. MAJOR REPAIR ACCOMPLISHED, INSTALLED SILL.SDR ANCF200300022Structure · vibrationDURING INITIAL CLIMB THERE WAS HARD NOISE AND LOW VIBRATIONS IN THE FRONT WINDOW (CENTER WINDSHIELD). CENTER WINDSHIELD WAS CHECKED FOR CONDITION. THIS AREA WAS SEALED AND IT WAS INSTALLED TAPE IAW AMM 56-10-01 PAG 201 - 213 (ITEM 12).SDR ASOA03388Beam · crackedDUIRNG A C-CHECK IN MCN, THE SECOND FROM AFT CARGO WALL BULKHEAD TRANSFER BEAM UNDER THE SEAL PLATE WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SECOND FROM AFT CARGO WALL BULKHEAD TRANSFER BEAM UNDER THE SEAL PLATE IAW SRM 51-4SDR AWXA200300987Beam · crackedDURING C-16 CHECK A 1/8 INCH CRACK WAS FOUND ON BEAM WEB AT INSULATION MOUNT HOLE BS 184, RBL 17.1, WL 178. MAINTENANCE CUTOUT DAMAGED AREA OF VERTICAL BEAM WEB AT BS 184, RBL 17.1, WL 178, AND PERFORMED A HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACK EXISTS; FSDR 03FDEA01323Frame · corrodedCORROSION ON FRAME AT STA 1010, STR 29R TO 29L, WL 138. BLENDED OUT CORROSION ON FRAME AT STA 1010, STR 29R TO 29L, WL 138. FOUND OUT OF LIMITS I.A.W. BOEING 727 SRM 53-10-1. REPAIRED BLEND OUTS PER BOEING 727 SRM 53-10-4, FIG 15, BOEING 727 SRM 51-10-SDR UPS03241155Structure · crackedINSPECTION TYPE:C, CRACK INDICATION FOUND AT BS 910 AFT SIDE OF REINFORCING BEAD RBL 52. REPAIRED IAW EO B727-5310-0088 APPDX C.SDR 2003UALA00621Shear Tie · corrodedAFT CARGO PIT AT BS 1197+22 BETWEEN STR 39L-39R SHEAR TIE IS CORRODED.SDR 2003UALA00620Shear Tie · corrodedAFT CARGO PIT AT BS 1197+44 BETWEEN STR 39L-39R SHEAR TIE IS CORRODED.SDR 2003UALA00619Shear Tie · corrodedAFT CARGO PIT AT BS 1197+66 BETWEEN STR 39L TO STR 39R, SHEAR TIE IS CORRODED.SDR 03FDEA01256Door Frame · crackedWHILE WORKING CARD N00281 2C FOUND CRACK ON 2FH LWR CORNER WEB OF ENTRY DOOR.
Back to JASC 5310