JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 UALA2012022000991Frame · corrodedFRAME 58 CORRODED AT STRINGER 43L. MAJOR REPAIR ACCOMPLISHED LNSTALLED REPAIR PER SRM 53-00-12 FIG 201 ON NR #'S V1974J, V1464I BY 395820 AND INSPECTED. MUST BE RE-INSPECTED AT 60000C FROM REPAIR EMBODIMENT CURRENT PTC IS 22107.SDR ASOA20120223011Frame · corrodedFRAME 80, CORRODED UNDER APU SHUNT CONNECTOR PLATE. BLENDED OUT DAMAGED AREA AND PERFORMED NDT FOR CRACKS. PROTECTED WITH ALODINE, APPLIED HIGH SOLIDS EPOXY TO THE REWORKED AREAS.SDR MASA2012022034457Frame · corrodedFS 409 FRAME HAS MINOR CORROSION ON AFT SIDE OF FRAME AT S27 APPROXIMATELY .5" DIAMETER VISIBLE AT THIS TIME. COMPLIED WITH PERMANENT REPAIR FOR CORROSION TO FRAME IAW REO 690-53-21-326.SDR DALA1217720919Frame · damagedDURING HMV LIGHTNING STRIKE WAS FOUND ON RT WINDOW BELT FRAME AT FWD UPPER CORNER BETWEEN STA Y=845 TO Y=864. LIGHTNING STRIKE RT WINDOW BELT FRAME. REPAIR PERFORMED IAW ERA 501072-14 REV ORIG.SDR SWAA2012031902404Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR DALA1212390697Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1520 BETWEEN STR 25 AND 26L. DENT WAS FOUND TO BE OUT OF LIMITS DUE TO LOCATION, REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW B757 SRM 53-00-07 DURING HMV. REPAIR TO BE ACCOMPLISHED ON NRC 202055.SDR DALA1212450697Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1500 ABOVE STR 25L. FOUND TO BE OUT OF LIMITS PER SRM 53-00-07 ALLOWABLE DAMAGE 1 PG 101 FIG 101. REPAIR TO BE ACCOMPLISHED ON NRC 202054.SDR DALA1212440697Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1480 ABOVE STR 25-27L. FOUND OUT OF LIMITS PER SRM 53-00-07 ALLOWABLE DAMAGE 1 PG 101 FIG 101. REPAIR TO BE ACCOMPLISHED ON NRC 202041.SDR USAA2012022700029Frame · crackedFPBH/CDFI VISIT - CRACK ON FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2012022700028Frame · crackedFPBH/CDFI VISIT - CRACK ON FUSELAGE FRAME AT BS 500F, S20R. REPAIRED FUSELAGE FRAME AT BS 500F, S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2012022900013Frame · crackedFPBH/CDFI VISIT - CRACK ON FUSELAGE FRAME AT BS 500B, S20L. REPAIRED FUSELAGE FRAME AT BS 500B, S20L IAW SRM 53-00-07-2R-13.SDR USAA2012022900012Frame · crackedFPBH/CDFI VISIT - CRACK ON FUSELAGE FRAME AT BS 500G, S20R. REPAIRED FUSELAGE FRAME AT BS 500G, S20R IAW SRM 53-00-07-2R-13.SDR UALA2012022000981Frame · damagedPRE-EXISTING FRAME REPAIR TO FR 76 BETWEEN STR 32L TO 32R. REMOVED EXISTING REPAIR PER SRM. PERFORMED ROCKWELL INSPECTION TEST AND VERIFIED 3 EACH REPAIR ANGLES ARE 2024-T4, REF: GN-MM 1-0-7-003. REINSTALLED SAME REPAIR PARTS PER SRM 53-00-12, FIG 203 ON NONSDR DALA1209360674Frame · damagedMAIN CABIN FRAME AT BS 1300 STRINGER 1L HAS MISDRILLED HOLES. REPAIRED IAW SRM 53-00-07 REPAIR 1.SDR SWAA2012031902403Frame · crackedSTUB FRAME CRACKED AT BS 294, BETWEEN STR 8R AND STR 7R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012031902401Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EO.SDR DALA1212380697Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1580 BETWEEN STR 25 AND 26R. FRAME OUT OF LIMTS DUE TO LOCATION OF DENT, FABRICATED AND INSTALLED REPAR SPLICE IAW B 757 SRM 53-00-07 DURING HMV. SRM REPAIR TO BE ACCOMPLISHED ON SAA NRC 201777(TO 201777)SDR DALA1215480697Frame · dentedAFT CARGO FRAME DENTED STA 1540 BETWEEN STR 25 & 26L. FRAME FOUND TO BE OUT OF LIMITS, REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR SPLICE IAW 757 SRM 53-00-07 DURING HMV AT ST AEROSPACE SAN ANTONIO.SDR SWAA2012031302149Support Angle · crackedFRAME SUPPORT ANGLE CRACKED AT BS 325, STR 20L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA2012030902035Frame · crackedFRAME CRACKED AT BS 303.9, BETWEEN STR 16L TO STR 17L. REPLACED FRAME IAW SRM AND DWG.SDR DALA1317569208Frame · crackedCANTED FRAME AT BS 1542 WAS FOUND WITH A CRACK APPROX .5". THE CRACK RUNS FROM THE CORNER INBD NEAR ZR=-30. REPAIR IAW ERA 500264-14.SDR SWAA2012031202091Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW EO AND EA.SDR AALA20120216TUL07Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL STATION 400 LEFT. ACCOMPLISHED DOUBLER REPAIR PER ECO J1159AD-0006.SDR SWAA2012030501888Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR UALA2012021600939Frame · corrodedSTA 1680 BETWEEN STR S30 AND S29 FRAME IS CORRODED. MAJOR REPAIR ACCOMPLISHED. RPLC'D FRAME SECTION STA 1680 STR 25L-25R DRWG 146N1025.SDR ASOA20120217019Frame · corrodedFRAME 61 CORRODED AT RT OTBD SILL. R & R DOUBLER.SDR FDEA201202150582Frame · gougedMAIN CABIN AREA. RT SIDE AT BS 1280 FRAME WITH GOUGE BETWEEN STR 6 TO 14R. REPAIRED FRAME IAW SRM 53-00-07 FIG 201, REPAIR 3. CATEGORY "A" MAJOR REPAIR.SDR FDEA201202150581Frame · gougedFUSELAGE FRAME AT BS 1280 FROM STRINGER S6 TO 14L, GOUGED ON SEVERAL AREAS. REPAIRED FRAME IAW SRM 53-00-07 FIG 201, REPAIR 3. CATEGORY "B' MAJOR REPAIR.SDR HNAA2012021500580Frame Splice · crackedCRACK FOUND ON PILOT'S SIDE FRAME SPLICE ANGLE ABOVE NOSE WHEEL STEERING HAND CONTROL. REMOVED LT TOP CONTROL PANEL FOR ACCESS. LT FUSELAGE FRAME STA X136 AT STR 15AM, REPLACED ANGLE SPLICE AND 2 STRAPS. INSTALLED WITH SOLID RIVETS IAW SRM 51-42-05.SDR K11A2012060816005Frame · damagedSTA 69 RIGHT SIDE HAS DAMAGE AREA ON FRAME (1 INCH).SDR SWAA2012031202092Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, BETWEEN STR 15R AND 18R. REPAIRED FRAME IAW EA.SDR SWAA2012031202089Frame · crackedFRAME INNER CHORD CRACKED AT BS 616 AND WEB, STR 17R. REPAIRED FRAME IAW EA.SDR DALA1214550171Strap · crackedDURING ULTRASONIC INSPECTION FOUND CRACK INDICATION AT STA RT 955 FAILSAFE STRAP LOWER HOLE. CRACK AREA AT STA 955 RT. REPAIRED AS PER ERA 500195-14AD REV O.SDR DALA1214540171Strap · crackedDURING ULTRASONIC INSPECTION FOUND CRACK INDICATION AT STA LT 955 FAILSAFE STRAP LOWER HOLE. CRACK AREA AT STA 955 LT. REPAIRED AS PER ERA 500194-14AD REV O.SDR SWAA2012030501928Frame · crackedFRAME CRACKED AT BS 420, STR 26R. REPAIRED FRAME IAW EA AND EO.SDR SWAA2012022001589Strap · crackedAFT CARGO DOOR CUTOUT FWD FRAME STRAP CRACKED AT BS 794, WL 165. REMOVED AND REPLACED STRAP IAW SRM & DWG.SDR SWAA2012022001579Frame · crackedFWD GALLEY DOORWAY FWD FRAME CRACKED AT FASTENER HOLE ABOVE RT CREASE BEAM WEB. REPAIRED FRAME IAW SRM.SDR CALA2012021500100Frame · crackedSUPPORT TASK - REF EA 5310-04716 REV C CRACK INDICATION FOUND AT FRAME 440 L MID FREQ ONLY INBD FASTENER NOT EXTENDING INTO RADIUS CABIN FRAME 440 L. REPAIRED IAW EA 5310-04716 REV C.SDR FDEA201202140578Frame · corrodedCORROSION ON BOTTOM INBD OF FRAME BS 1681, LBL 56, W/L 209 L4 DOOR AFT LWR SIDE. REPAIR CLASSIFIED AS A MINOR.SDR ZZDA2012183Strap · corrodedAFT CARGO UPPER FRAME STRAP, STA 1002, RBL 10, CORROSION. ACCOMPLISHED UPPER FRAME STRAP REPLACEMENT PER B717 SRM 51-41-02. SEE NR 24546.SDR SWAA2012022401696Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME PER SRM.SDR CALA2012021500099Frame · crackedREF EA 5310-04716 REV C CRACK INDICATION FOUND FRAME 747L BOTH MID AND HIGH FREQ-NOT EXTENDING INTO RADIUS. REPAIRED PER EA 5310-04716 REV C.SDR IPXA2571680Frame · dentedINSPECTION TYPE:C-CK, FWD PIT STA 760 STR 24L VERTICAL FLANGE OF FRAME IS DENTED. REPAIRED FRAME IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 2 WITH .063" X 7075-T6 MATERIAL.SDR SWAA2012021501478Frame · crackedFRAME CRACKED AT 500C, STR 21R. REPAIRED FRAME PER SRM.SDR CALA2012021300098Frame · crackedSUPPORT TASK - REF EA 5310-04716REV C CRACK FOUND FRAME STA 727D R MID FREQ AND HIGH FREQ I/B FASTENER NOT INTO RADIUS. REPAIRED IAW EA 5310-04716 SEE ATTACHED 44.0008FOR ADDITIONAL WORK ACCOMPLISHED.SDR DALA1208760668Frame · dentedAFT CARGO FRAME DENTED STA 1520 ABOVE STR 26L. FABBED AND INSTALLED REPAIR DOUBLER AT STA 1520 S26L PER SRM 53-00-07 REPAIR 5. THIS IS A CAT B W/THRESHOLD REP. INSP TO START AT 50,000 FLT CYC.S ZONE 1 HFEC INTERVAL EVERY 12,000 FLT CYCS PER NDT PART 6 51-00SDR SWAA2012021601500Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20L AND 21L. REPAIRED FRAME IAW SRM.SDR SWAA2012021501481Frame · crackedFRAME CRACKED AT BS 500C ON I/B RIGHT SIDE. REPAIRED FRAME PER SRM.SDR CALA2012021300097Frame · crackedREF EA 5310-04716 REV C CRACK INDICATION FOUND FRAME 827L MID FREQUENCY INBD FASTENER NOT EXTENDING INTO RADIUS. REPAIRED FRAME AT STA 827L IN ACCORDANCE WITH EA 5310-04716 REV C.SDR CALA2012021300095Frame · crackedSUPPORT TASK - REF EA 5310-04716 REV C OP1 CRACK INDICATION FOUND FRAME 747R BOTH MID AND HIGH FREQ INBD FASTENER NOT EXTENDING INTO THE RADIUS. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND INSTALLED PARTS AS PER EA 5310-04716 REV C.
Back to JASC 5311