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 IPXA2M74172Door Frame · crackedINSPECTION TYPE:4C, R-3 DOOR JAMB FWD LOWER LIGHTENING HOLE AFT LOWER CORNER IS CRACKED. REPAIRED R-3 DOOR JAMB FWD LOWER LIGHTENING HOLE AFT LOWER CORNER REF SRM 53-40-15, FIG 201, REPAIR 3.SDR IPXA2M74171Door Frame · crackedINSPECTION TYPE:4C, L-3 DOOR JAMB FWD LOWER LIGHTENING HOLE LOWER AFT CORNER IS CRACKED. REPAIRED L-3 DOOR JAMB FWD LOWER LIGHTENING HOLE LOWER AFT CORNER SRM 53-40-15, FIG 201, REPAIR 3.SDR FDEA201206212288Crease Beam · corrodedBS 680, CREASE BEAM HAS CORROSION, RBL 64. R & R IAW SRM 51-40-02, REV 106 AND DWG 143N8322 SHT 3, REV-. REPAIR IS CLASSIFIED AS MAJOR.SDR SPUY20120620009Beam · corrodedMAIN CARGO BAY BEAM FWD LOWER FLANGE SHOWS POINTS OF CORROSION AT STA 890, RBL 35".SDR SPUY20120620008Beam · corrodedMAIN CARGO BAY BEAM FWD LOWER FLANGE SHOWS CORROSION AT STA 900 RBL 45"SDR SWAA2012070205507Crease Beam · corrodedR2 DOOR CREASE BEAM CORRODED BETWEEN BS 947 TO BS 993. REMOVED AND REPLACED BEAM IAW SRM.SDR SWAA2012070205506Crease Beam · corrodedL2 DOOR CREASE BEAM CORRODED BETWEEN BS 986 TO 967. REMOVED AND REPLACED BEAM IAW SRM AND DWG.SDR QXEA2012061600490Beam · corrodedCORROSION FOUND ON THE AFT CARGO EDGE BEAM. REMOVED CORROSION IAW SRM 51-21-00-00-02. PERFORMED HFEC OF BLENDS FOR CRACKS IAW NTM 51-00-06-910-801 PT 1, NO CRACKS NOTED. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801 PT 1. MATERIAL LOSS FOUND TSDR DALA1237679256Beam · corrodedFOUND AFT CARGO BAY BS 1212-1269 L28R LOWER DOOR FRAME HEADER BEAM IS CORRODED. REMOVED AND REPLACED HEADER BEAM IAW SRM 51-30-05 VOL II AND DWG 5936038-501.SDR DALA1237669256Beam · corrodedFOUND MID CARGO BAY BS 693-750 L28R LOWER DOOR FRAME HEADER BEAM IS CORRODED. REMOVED DAMAGED JAMB HEADER BEAM, LOCATED, DRILLED AND INSTALLED NEW HEADER BEAM IAW SRM 51-10-05, 51-30-02, 51-30-01, 51-30-05 VOL II AND DWG 5930481.SDR USAA2012070900049Crease Beam · corrodedQ1 CHECK - LEVEL 2 EXFOLIATION CORROSION ON R1 DOOR CREASE BEAM CHORD BETWEEN BS 300 TO BS 325, WL 208, RBL 60. REPLACED R1 DOOR CREASE BEAM IAW B737 SRM 51-40-02-0G FIG 12.SDR QXEA2012061500505Structure · corrodedFOUND INTERNAL FUSELAGE AREA OF CORROSION FROM FRAME X94.800 TO FRAME X136.000 BETWEEN STRINGERS 31P AND 32P. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED BLENDED AREA CRACK FREE REF NTM 51-00-02-250-801, PTSDR FDEA201206132226Door Frame · crackedCENTER CARGO DOOR FWD FRAME ADJACENT TO RUB PLATE, FOUND CRACKED. REPAIR ACCOMPLISHED IAW EA 1-5230-160969. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 115.SDR USAA2012070200013Crease Beam · corrodedQ1 CHECK - CORROSION ON LEFT AFT ENTRY DOORWAY (CREASE BEAM) INNER CHORD BETWEEN BS 967 TO BS 986.5, WL 208, LBL 55. REPLACED LEFT AFT ENTRY DOORWAY CREASE BEAM IAW B737-400 SRM 51-40-02-0G, FIG 12.SDR U2RA201206160001Tension Tie · crackedUPPERDECK STA 1180, RT TENSION TIE AT FRAME WEB FOUND 1 EA HOLE CRACKED. REF AD 2007-23-18 SB 747-53A2507. CRACK HOLE CRACK LENGTH .035"SDR U2RA201206150005Tension Tie · crackedUPPERDECK BS 1140 TENSION TIE AT FRAME WEB FOUND 1 EACH HOLE CRACK AND 2ND HOLE CRACK AT FAILSAFE.SDR U2RA201206150003Tension Tie · crackedUPPERDECK BS 1180 LT TENSION TIE FORWARD CHANNEL FOUND 1 EA CRACK. REF AD 2007-23-18, SB 747-53A2507. CRACK LENGTH .035"SDR U2RA201206150001Structure · crackedBS 2598, FOUND CRACKED.SDR DALA1242770635Crease Beam · corrodedCREASEBEAM WEB EXFOLIATED AT STA 960-984 RBL71.5. DAMAGE BEYOND LIMITS. REPLACED CREASEBEAM WEB AT IAW SRM 51-40-2.SDR A6WA201240662Door Frame · crackedPAX DOOR FRAME CRACKED UNDER PANEL 832BR. R & R DOOR FRAME.SDR ASOA2012061501801Door Frame · crackedFOUND CRACK ON SERVICE DOOR FRAME. ON FWD DOOR SEAL STRIKER. REMOVED AND INSTALLED NEW SEAL STRIKER, IAW SRM 51-42-06, 51-23-00.SDR QXEA2012061100448Beam · corrodedFOUND CORROSION ON FWD RT EMERGENCY EXIT THRESHOLD BEAM. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-20-21-00-01. REMOVED EDGE BEAM IAW SRM 51-42-05-02-01 AND 51-42-45-02-01. MATCH DRILLED AND INSTALLED NEW EDGE BEAM IAW SRM 51-40-07-02-01, 51-42-05-02-0SDR MASA2012061334882Beam · corrodedTRANSVERSE BEAM AND J-CHANNEL ARE CORRODED. REPAIRED FS 280 TRANSVERSE BEAM IAW BOMBARDIER REO 670-53-11-579.SDR DALA1236620985Beam · corrodedDURING PSV, FOUND CORROSION ON AFT CARGO DOOR SILL BEAM. REMOVED AND REPLACED BEAM PER SRM 51-01.SDR UALA2012061103231Structure · damagedLIGHTNING STRIKE DAMAGE LOCATED AT FASTENER STRINGER 11R STA 157. REPAIRED PER SRM 53-00-01.SDR UALA2012061103230Structure · damagedLIGHTNING STRIKE DAMAGE AT FASTENER LOCATED AT STRINGER 11R STA 154. REPAIRED PER SRM 51-00-01.SDR HNAA2012061100819Structure · corrodedAREA OF CORROSION AT STA X510 AND STR 31S. R & R 3 RIVETS, CLEANED AREA AND REPAIRED IAW SRM 51-20-11 AND 51-20-36. INSTALLED NEW RIVETS.SDR USAA2012062100006Door Frame · crackedSA CHECK - CRACK ON FORWARD CARGO DOOR FRAME CUTOUT AT BS 440, S23R. REPLACED FORWARD CARGO DOOR FRAME CUTOUT AT BS 440, S23R IAW B737-300 SRM 51-40-02, DRAWING 65-20722.SDR FDEA201206102176Yoke · damagedLEFT BS 535 UPPER SUPPORT YOKE FOUND DAMAGED. R & R IAW SRM 53-20-07, FIG 202, REPAIR 1, REV 49. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201206102175Yoke · damagedLEFT BS 535 LOWER SUPPORT YOKE FOUND DAMAGED. R & R IAW SRM 53-20-07, FIG 201, REPAIR 1, REV 49. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR SIMA20120609008Crossbeam · corrodedDURING B INSPECTION, FOUND THE GALLEY CROSSBEAM CORRODED BETWEEN FRAMES 24-25. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND INSTALLED NEW SERVICEABLE GALLEY CROSSBEAM BETWEEN FRAMES 24-25 IAW SRM. 51-40-02,51-40-09,51-20-03,51-20-01. AIRCRAFT RETURNED TO SERVICESDR AALA20120609008Door Frame · damagedE AND E DOOR CUTOUT LEFT FRAME AND WEB WORN AT LATCH FITTING. INSTALLED NEW WEB PER SRM 53-10-15-01 3.SDR UALA2012061103178Paint · peelingPEELING AND LOOSE PAINT FOUND IN THE FORWARD LEFT STBY STATIC RVSM AREA. ACCOMPLISHED REPAIR OF PAINT REF MM.SDR FDEA201206082167Crease Beam · corrodedCREASE BEAM S17R, BS 297-428 CORRODED. REMOVED CORROSION BY BLENDING IAW SRM 51-40-02. CHECKED LIMITS AFTER REWORK FOUND INBD CREASE BEAM OUT OF LIMITS IAW SRM 53-30-13 DETAIL III. FABRICATED NEW INBD CREASE BEAM, LOCATED AND DRILLED IAW SRM 51-40-05. INSTALSDR GLBA201206082Spar · gougedDURING A SCHEDULED ROUTINE INSPECTION, FOUND 0.3" LONG BY 0.040" DEEP GOUGE ON THE LT FWD BOTTOM SPAR INBD OF THE ACM EXHAUST. REPAIRED IAW EO 12-1900-55-018. MAJOR REPAIR.SDR SWAA2012061104834Crease Beam · crackedCREASE BEAM CHORD CRACKED BS 639, LBL 60. REMOVED AND REPLACED CHORD IAW SRM.SDR DALA1235870940Door Frame · crackedDURING HMV A CRACK WAS FOUND ON FORWARD UPPER CORNER OF FWD SERVICE DOOR JAMB AT STA Y=175 BTW LONGERON 11 AND 12R. DAMAGE WAS CUT OUT AND DOUBLER INSTALLED IAW SR09530172 REV G.SDR FDEA201206062113Failsafe · gougedR1 DOOR UPPER SILL, FAILSAFE STRAP GOUGED. REPAIRED IAW EA F-5310-160568. MAJOR REPAIR.SDR UALA2012060503107Tension Tie · crackedBS 1120 LT TENSION TIE FWD CHANNEL CRACKED. REPAIRED TENSION TIE IAW NR-53-033 AND NR-53-021.SDR UALA2012060503105Doubler · crackedSTA 1200 RT TENSION TIE DOUBLER CRACKED. INSTALLED NEW DOUBLER IAW SRM 51-40-02.SDR UALA2012060503104Tension Tie · crackedBS 1180 RT TENSION TIE DOUBLER CRACKED. INSTALLED NEW DOUBLER IAW SRM 51-40-02.SDR UALA2012060503102Tension Tie · crackedBS 1200 RT TENSION TIE FWD CHANNEL CRACKED. REPAIRED TENSION TIE IAW NR-53-032 AND NR-53-013.SDR UALA2012060503101Tension Tie · crackedBS 1180 RT TENSION TIE FWD CHANNEL CRACKED. REPAIRED TENSION TIE IAW NR-53-030 AND NR-53-015.SDR UALA2012060503100Tension Tie · crackedBS 1180 LT TENSION TIE FWD AND AFT CHANNEL CRACKED. REPAIRED TENSION TIE IAW NR-53-031 AND NR-53-016.SDR UALA2012060503099Tension Tie · crackedBS 1160 RT TENSION TIE FWD AND AFT CHANNEL CRACKED. REPAIRED TENSION TIE IAW NR-53-029 AND NR-53-017.SDR UALA2012060503096Tension Tie · crackedBS 1140 LT TENSION TIE FWD AND AFT CHANNEL CRACKED. REPAIRED TENSION TIE PER NR-53-037 AND NR-53-019.SDR UALA2012060503095Tension Tie · crackedBS 1120 RT TENSION TIE DOUBLER CRACKED. INSTALLED NEW DOUBLER IAW SRM 51-40-02.SDR UALA2012060503093Failsafe · crackedBS 1140 RT TENSION TIE FAILSAFE CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR IAW SRM 51-70-12.SDR UALA2012060503092Failsafe · crackedBS 1140 LT TENSION TIE FAIL SAFE CRACKED. REMOVED DAMAGE AND INSTALL REPAIR IAW SRM 51-70-12.SDR UALA2012060503091Failsafe · crackedBS 1120 RT TENSION TIE FAIL SAFE CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR IAW SRM 51-70-11.
Back to JASC 5310