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 USAA030095Door Frame · crackedFOUND FRAME CRACKED .25 INCH, BS 144 AFT CARGO DOOR FRAME NR 6 STOP HOLE. WEB REPLACEMENT/SPLICED IN PER EA 87279. (M)SDR 03FDEA00861Angle · corrodedWHILE WORKING CARD 00357 (DOOR 6030) DISCOVERED A CORROSION ON LOWER BEAM ANGLE WEB 45 INCHES AFT OF FWD EDGE 1.5 INCHES UP FROM BOTTOM EDGE ON NR 1 CARGO DOOR. REMOVED CORROSION ON LOWER BEAM ANGLE WEB 45 INCHES AFT OF FWD EDGE, FOUND TO BE OUT OF LIMITS. SDR ARWA20030605Door Frame · crackedDURING MAINTENANCE INSPECTION THE FOLLOWING WAS FOUND, FORWARD ENTRY DOOR FRAME, BOTTOM AFT CORNER HFEC INSPECTION REVEALED .1250 INCH CRACK. ACCOMPLISHED REPAIRS AT FORWARD ENTRY DOOR AFT LOWER CORNER IAW SB 53-075 AND DRAWING NR SR08530021.SDR 2003UALA00480Shear Tie · corrodedBS 1335, BETWEEN STRINGERS 33R AND 34R, SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR DHL2003604682Door Frame · damagedMAIN CARGO COMPT AFT PASSENGER DOOR JAMB AFT UPPER CORNER HAS INTERIM REPAIR. REMOVED INTERIM REPAIR IAW SRM 51-1-21 PG 1, SRM 51-1-20D PG 1. TRIMMED OUT DAMAGED AREA IAW SRM 53-2-0 FIG 18 SHEET 3 TR 53-135, DWG SR 08530021, DWG 5750776. FABRICATED FILLER (SDR AUS20030595Beam · cracked(AUS) BEAM WEB CRACKED. CRACK LENGTH APPROXIMATELY 25.4MM (1IN).SDR AUS20030552Web · cracked(AUS) BEAM WEB CRACKED. CRACK LENGTH APPROXIMATELY 25.4MM (1IN).SDR SWIA200312105Door Frame · corrodedPAX DOOR CABLE MOUNT ON DOOR FRAME HAS CORROSION. DISCOVERED DURING AVIONICS MODIFICATION. REMOVED CORRODED CABLE MOUNT AND INSTALLED NEW IAW CRJ SRM 51-40-11, 51-42-20. P/N OFF: 444-2439-1.SDR SWAA031235Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 27R AND STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR MALA030306Structure · dentedDURING 4K INSPECTION IN CWA, LT FUSELAGE HAS DENTS UNDER ICE SHIELD AT STA 341 ABOVE FUSELAGE REINFORCEMENT. MAINTENANCE COMPLETED TRIPLER/DOUBLER REPAIR IAW EO 53009. REF 409 NR 179480 FOR DETAIL. A/C RELEASE DATE 6/6/03.SDR DHL2003746505Shear Tie · crackedDURING C-CHECK DISCREPANCY AS FOLLOWS, N/R 54183 RT SHEAR WEB CRACKED AND CORRODED AT BS 1169 RBL 17 MARKED IN RED. CUT OUT DAMAGED AREA AND FABBED FILLER FROM 7075 T-6 .050 PO 9912380 DIM 5 X 7.5 AND DOUBLER FROM 7075 T-6 .063 PO 9912495 DIM 7.5 X 7.5 IAW 72SDR 03FDEA00849Shear Tie · corrodedCORROSION (C53-113-01(17) SHEAR TIE BS 560 BETWEEN STR 26-27L. CORROSION ON SHEAR TIE IN A .75 X .75 INCH AREA FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SHEAR TIE IAW SRM 53-10-1, 51-30-2, 51-10-2.SDR 03FDEA00851Shear Tie · corrodedCORROSION (C53-113-01,2) ON SHEAR TIE BS 950B, LBL 8-10, WL 140. REMOVED CORROSION ON SHEAR TIE BS 950B LBL 8-10 WL 140 AREA .65 X 5.00 X .013 INCH DEEP FROM ORIGINAL .071 FOUND OUT OF LIMITS PER SRM 53-10-1. REPAIRED SHEAR TIE PER SRM 53-10-4.SDR SWAA031218Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIES CORRODED (2 EA) AT BS 747, WL 148, RBL 10 AND BS 847, WL 148, BL 0. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA031229Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR AFT EDGE FRAME CRACKED NEAR STOP FITTING CUTOUT. REPAIRED FRAME PER SRM.SDR DHL2003604685Door Frame · damagedINTERIM REPAIR ON FWD UPPER CORNER OF FWD PASSENGER DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 15 SHEET 4, TR 53-129, DWG 5750776, DWG SR08530021. CUT OUT DAMAGED AREA AND FABRICATED FILLER (7075-T6 AL0.050) AND (2) DOUBLERS (7075-T6 AL0.063) (7075SDR DHL2003604702Door Frame · damagedINTERIM REPAIR ON AFT LWR CORNER OF FWD SERVICE DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 14, SHEET 2, TR 53-127, DWG 5750776, DWG SR08530021. REMOVED INTERIM REPAIR IAW SRM 51-1-21 PG 1. CUT OUT DAMAGED AREA AND FABRICATED FILLER AND 2 DOUBLERS SDR C2XA03TY077Door Frame · corrodedDURING A SCHEDULED 2C CHECK CORROSION WAS FOUND ON THE SERVICE DOOR SILL, JUST BELOW THE SILL PLATE. MAINT CLEANED CORROSION, FILLED AREA WITH EPOXY RESIN, FABRICATED, ALODINED, PAINTED AND INSTALL REPAIR DOUBLER IAW 135/145 SRM 51-40-02, 51-10-02, CPM 51-21-SDR AUS20030675Structure · animal strike(AUS) AIRCRAFT HIT A KANGAROO DURING LANDING ROLL. INITIAL IMPACT APPEARS TO BE ON THE LT PROPELLER CAUSING SUBSTANTIAL DAMAGE TO THE PROPELLER. ANIMAL REMAINS WERE ALSO INGESTED INTO THE LT ENGINE. FOLLOWING THE IMPACT, THE KANGAROO WAS EJECTED FORWARD AND OVSDR DHL2003604687Door Frame · damagedINTERIM REPAIR ON FWD LWR CORNER OF AFT PASSENGER DOOR JAMB. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 18, SHEET 2, TR 53-135, DWG 5750776, DWG SR08530021. REMOVED INTERIM REPAIR AND EXISTING DOUBLER IAW SRM 51-1-21 PG 1. FABRICATED (2) DOUBLERS IAW SRM 53-SDR AMTA200300888Shear Tie · crackedC1 BILGE SHEAR TIE CRACKED. REPAIRED SHEAR TIE IAW SRM 53-12-00. (M)SDR USAA030061Door Frame · crackedDOOR STOP CUTOUTS CRACKED .0180 INCHES IN LENGTH, WL 240 AND WL 250 OF DOOR STOPS, FORWARD GALLEY DOOR AFT FRAME. TEMP REPAIR, TRIM TO REMOVE CRACKS, DEBURR AND BREAK SHARP EDGES PER EA 74896. (M)SDR AUS20030672Structure · cracked(AUS) REAR BULKHEAD BEAM EXTENSION CLEATS LOCATED AT STRINGER 5,STRINGER 7, STRINGER 8 AND STRINGER 11 CRACKED. CLEATS ARE INSTALLED DUE TO WIDENING OF THE REAR FUSELAGE FOR STC SA2192CE. FOUND DURING INSPECTION IAW AD/BEECH200/55 AMDT1 AND AD/BEECH200/21 AMDSDR DHL2003604760Clip · crackedAFT ACCESSORY COMPT. CLIP ATTACHING FRAME TO SKIN AT STA. 660.000 L-22L WITH 1.500 CRACK IN IT. REMOVED CRACKED CLIP IAW SRM 51-1-20D PG.21. FABRICATED NEW CLIP (STEEL 0.500 H0.050) IAW SRM 53-1-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALSDR DHL2003604759Stringer Clip · crackedAFT ACCESSORY COMPT. CLIP ATTACHING FRAME TO SKIN AT STA.660.000 L-22R WITH 2.000 CRACK IN IT. REMOVED CRACKED CLIP IAW SRM 51-1-20D PG.21. FABRICATED NEW CLIP (STEEL 301 0.500 H0.050) IAW SRM 53-1-0 PG.1. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTSDR 03FDEA00817Channel · corrodedCORROSION LT WHEEL WELL BS 927-932 LBL 65 WL 188 STR 18A SHELF. REMOVED AND REPLACE SILL CHANNEL BS 870-936, WL 188, LBL 65 AT STR 18A PER SRM 51- 30-2, 51-30-5.SDR SWAA031191Beam · crackedDURING SCHEDULED D CHECK, FOUND RT OUTBD LOWER VERTICAL BEAM CRACKED AT BS 188, WL 203 TO WL 214 AT RBL 30. REPAIRED VERTICAL BEAM PER SRM.SDR 03FDEA00815Door Frame · damagedCOMPLY WITH E.A. 6-5313-70393 "FUSELAGE-MAIN FRAME-LWR FWD CARGO DOOR FRAME/FUSELAGE SKIN REPAIR AT FRAME 20A FACT 27MAY03 11:35 BFM U COMPLIED WITH E.A. 6-5313-70393 FUSELAGE-MAIN FRAME- LWR FWDCARGO DOOR FRAME/FUSELAGE SKIN REPAIR AT FR20A.SDR MWEA030232Pan · corrodedAFT CARGO DOOR FORWARD END HAS MODERATE CORROSION ON INNER PAN BETWEEN NR 2 AND 3 BEAMS. -- BLENDED CORROSION AND INSTALLED TWO EACH RIVETS.SDR CA030527015Splice · cracked(CAN) CRACK ORIGINATING AT TOOLING HOLE AND PROGRESSING HORIZONTALY ACROSS LOWER FLANGE.SDR C2XA03SH156Buttstrap · corrodedDURING C-CHECK THE FORWARD DIGITAL BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGE AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 203. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH152Crossbeam · corrodedDURING C-CHECK THE LOWER CROSSBEAM ANGLE FROM THE CENTER BEAM TO THE RIGHT HAND BEAM AT FRAME 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH150Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 18 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH149Buttstrap · corrodedDURING C-CHECK THE AFT DIGITAL BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH147Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH145Threshold · corrodedDURING C-CHECK THE BAGGAGE DOOR THRESHOLD LOWER 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 C2XA03SH144Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH143Buttstrap · corrodedDURING C-CHECK THE RIGHT HAND BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH142Butt Strap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP AT FRAME 24 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH140Doubler · corrodedSHV-DURING C-CHECK THE DOUBLER AT FRAME 17 STRINGER 17R WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR TSAA0353150Crease Beam · corrodedFOUND CORROSION DISCOVERED ON LEFT CREASE BEAM BETWEEN BS 307 AND 310. REMOVED AND REPLACED SECTION BETWEEN BS 307 AND BS 310. ALODINE, PRIMED, AND INSTALLED REPAIR PARTS WET WITH FASTENERS MAKING A FAYING SURFACE SEAL. REPAIR COMPLETED IAW SRM 51-30-2 AND SDR DHL2003366518Door Frame · corrodedCORROSION ON AFT CARGO FWD DOOR FRAME, FR 59A STRINGER 44R (MARKED). REMOVED WEB AND ANGLE PERFORMED ACID TEST IAW ASTM 1A76-97 MAT ID 2024T3 .050 AND ANGLE 2024T3 .083. FAB WEB AND ANGLE IAW A300 SRM 51-10-40, ALODINED AND PRIMED IAW A300 SRM 51-40-12. SENSDR USAA030060Beltframe · crackedPIT - FOUND BELTFRAME CRACKED .1875 INCH, BELTFRAME CRACKED AT STATION 303.9 STRINGER 13L. DOUBLER INSTALLED PER EA 76233. (M)SDR UPS03840844Shear Tie · crackedINSPECTION TYPE: C1, C-PIT STA. 1120 BELOW LONG. 21R SHEARTIE IS CRACKED REMOVED, FABRICATED AND REPLACED SHEARTIE I.A.W. UPS ENGINEERING FILE NUMBER ,SAA SK 705-061 AND SRM. 51-1-20D.SDR CALA0300264Door Frame · crackedMAINTENANCE DISCOVERED DAMAGE IN THE FORM OF A DENT AND 1.1 INCH LONG CRACK IN THE AFT CARGO DOOR UPPER BEAM ASSEMBLY WEB WHILE AIRCRAFT WAS ON RON AT IAH. AN INTERIM REPAIR WAS PERFORMED IAW ECRA 5230-01723 AND A DIP WAS ISSUED TO ACCOMPLISH A PERMANENT REPASDR USAA030074Crease Beam · crackedCLT - FOUND CREASE BEAM WEB CRACKED 1 INCH, BS 1368 STRINGER 17L. REPLACED WEB PER SRM 51-10-02. (M)SDR GTIA030401Fitting · corrodedFOUND MID PIT STATION 636 FRAME END FITTING CORRODED. LOCATED AND DRILLED HOLES NEW FITTING. (M)SDR UPS03440786Shear Tie · corrodedINSPECTION TYPE: C, AFT CARGO STA 1840 STR 45R TO 46R SHEAR TIE CORROSION REVEALED. CORROSION BLEND OUT 0.040 X 1 X 2 INCH. SHEAR TIE BRACKET REPLACED AS PER SRM 51-10-01 PG 8.SDR UPS03440776Reveal · crackedINSPECTION TYPE: C, M/D - R5 DOOR FWD CUTOUT REVEAL CRACK AT S-16 AS MARKED. REPAIRED AS PER SRM 53-10-04 FIG 91 AT M/D R5 DOOR FWD CUT REVEAL AT S-16.SDR UPS03440773Shear Tie · crackedINSPECTION TYPE: C, M/D - BS 1020 FRAME SHEAR TIE FOUND CRACKED BETWEEN S-8R AND S-9R. M/D BS 1020 FRAME SHEAR TIE 1 EA REPLACE AS PER SRM 51-10-01 BETWEEN S-8R AND S-9R.
Back to JASC 5310