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 SWAA040386Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 638, LBL 64, WL 208. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA040379Door Frame · crackedDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR CUTOUT FWD LOWER CORNER CRACKED. REPAIRED PER EA.SDR ASAA0410049Shear Tie · crackedOKC - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 440, STRINGER 17L CRACKED. REPAIRED PER SRM. (M)SDR ASAA0410050Shear Tie · crackedOKC - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 400, STRINGER 17L CRACKED. REPAIRED PER SRM. (M)SDR UPS04541895Web · corrodedINSPECTION TYPE: C, CORROSION ON FLOOR SHEAR WEB IN SEVERAL AREAS BETWEEN BS 334 TO BS 365 LBL 46 TO LBL 62 WL 208 (CP53-221-02.05-1I). BS 351 LBL 46, BS 339 LBL 46 OUT OF LIMITS PER SRM 53-00-51 FIG 101. FABRICATED DOUBLERS, FILLERS AND INSTALLED REPAIR PASDR SWAA040372Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 948 TO BS 990 RBL 55, WL 208 CORRODED. REPAIRED CREASE BEAM PER SRM.SDR LR7A04025Window Post · crackedDURING SCHEDULED B3 INSPECTION PER JOB CARD HB5301 FOUND RT AFT DV WINDOW POST CRACKED. REPAIR CARRIED OUT IAW SMP583 CH 53-30-25, FS 116 WL 255 RBL 40.SDR TSAA0452026Door Frame · corrodedFOUND CORROSION ON FORWARD CARGO DOOR FRAME. TRIMMED OUT DAMAGED AREA. HFEC VERIFIED CRACK REMOVED. FABRICATED REPAIR DOUBLERS AND TRIPLER. ALODINED AND PRIMED ALL BARE SURFACES. INSTALLED REPAIR PARTS MAKING A FAYING SEAL AROUND REPAIR. REPAIR COMPLETEDSDR SWAA040362Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR FRAME CUTOUT CRACKED AT DOOR STOP. REPAIRED R1 DOOR FRAME CUTOUT PER SRM.SDR 373PA0037Torque Box · crackedLITE CORROSION AND CRACKS AROUND NUT PLATES ON LOWER SURFACE OF TORQUE BOX LEFT SIDE OF APU AT APPROX BS 1100. REPAIRED AREA PER SRM 51-70-13.SDR USAA040012Door Frame · crackedPIT - FOUND FRAME CRACKED .5 INCH, LOWER AFT CORNER UNDER DOOR STOP FITTING. SPLICED IN NEW FRAME SECTION, REPLACED CORNER ANGLE AND DOUBLER PER SRM 51-70-11. (M)SDR QXEA200400110Structure · nickedPDX - AREA OF NICKS, SMALL DENTS AFT OF RIGHT NOSE GEAR, 6 INCHES TO 40 INCHES AFT OF NOSE WHEEL WELL. REPAIRED IAW DHC-8-200 SRM 51-80-26.SDR 04FDEA00287Structure · corrodedMAIN CARGO DECK RT STA 1821 TO STA 1831 FLANGE AREA HAS CORROSION IN TWO PLACES. MAIN CARGO DECK RT STA 1821 TO STA 1831 FLANGE AREA, CORRODED AREA CARRIED OUT REPAIR IAW SRM 53-70-00, FIG. 5, VOL.I.SDR UPS04841927Support · crackedINSPECTION TYPE:C3 A/C BAY CEILING SUPPORT ANGLE IS CRACKED AT STATION 55 LBL 30. REMOVED, FABRICATED AND REPLACED ANGLE FITTING IAW DWG 4774654 AND SRM 51-1-20D.SDR C2XA04SH036Crossbeam · corrodedDURING C-CHECK THE CROSSBEAM BETWEEN FRAMES 23 AND 24 AT STRINGER 15R WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PART IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AUS20040048Door Frame · cracked(AUS) AFT CARGO DOOR CUTOUT FRAME LOCATED AT BS 1090 RIB BL28 CRACKED. CRACK LENGTH 8.255MM (0.325IN).SDR DL73S040097Beam · damagedDAMAGE INCURRED TO THE VERTICAL FLANGE OF THE LOWER CHORD AT RBL 63, IN THE BS 639 STUB BEAM. DAMAGE WAS REMOVED AND REPAIRED PER ERA 386099-14.SDR 04FDEA00241Beam · corrodedLEFT A/C BAY, DELTA BEAM LWR PLATE HAS CORROSION AT STA 800 LBL 6 WL 140. REMOVED CORROSION ON DELTA BEAM LWR PLATE AT BS 800, LBL 6, WL 140 IN A 2.500X1.00X.029 DEEP. FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AREA 2.00X.500X.090. FABRICATED FILLER SDR C2XA04SH031Beam · corrodedSHV-DURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AN REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS04441912Shear Tie · crackedINSPECTION TYPE: C, AFT OF BULK CARGO COMPT- RT STA 2220 IN BETWEEN STR 40 AND STR 44 SHEAR TIE ATTACH ANGLE FOUND CORROSION CRACKED. CORROSION BLEND OUT 0.071 X 1 X 3 INCH EXCEED SRM 53-10-01 FIG 1 LIMIT. ANGLE REPAIRED PER SRM 51-40-03 FIG 2. CIC APPLIEDSDR UPS04441808Shear Tie · crackedINSPECTION TYPE: C, AFT CARGO COMPT - LT STA 1680 IN BETWEEN STR 45 AND STR 46 SHEAR TIE FOUND CRACKED. AFT CARGO COMPT BS 1680 BETWEEN STR 45L AND STR 46L SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 3.SDR ASAA0480042Beam · corrodedDURING INSPECTION, FOUND AFT PIT LOWER FLANGE ON BEAM AT CARGO DOOR IS CORRODED AT STATION 1182. REPAIRED BY REMOVED DAMAGED BEAM, INSTALLED NEW BEAM IAW MD80 SRM 51-30-2, 51-30-5, 51-10-3. (M)SDR ASAA0480041Shear Tie · corrodedOKC - DURING INSPECTION, FOUND AFT PIT STATION 1193 BETWEEN STRINGER 20 AND 29L SHEAR TIE CORRODED. REPAIRED BY REMOVED DAMAGE, FABRICATED REPAIR SHEAR TIE AND SPLICE IAW MD80 SRM 53-03. (M)SDR DL73S040083Beam · crackedA CRACK INDICATION WAS NOTED IN THE BS 616 STUB BEAM WEB. CRACK INDICATION WAS REMOVED THE REWORKED/REPAIRED PER ERA 386098-14.SDR UPS04441841Shear Tie · corrodedINSPECTION TYPE: C, AFT CARGO BILGE AREA - FX 1820, STR 44R - 46R SHEAR TIES CORRODED. BS 1820 TO 1820, STR R44-R46 CORROSION REMOVED IAW SRM 51-10-01, CORROSION BLEND OUT 0.040 INCH X 0.5 INCH X 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS. FLANGE REPAIRED REFESDR UPS04441809Shear Tie · crackedINSPECTION TYPE:C AFT CARGO BILGE AREA - FS 1700, STR 49L - 50L SHEAR TIE CRACKED. AFT CARGO COMPT BS 1700 BETWEEN STR 49L AND STR 50L SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 3.SDR UPS04441806Shear Tie · crackedINSPECTION TYPE: C, AFT CARGO BILGE AREA - FS 1680, STR S47L - 48L SHEAR TIE CRACKED. AFT CARGO COMPT BS 1680 BETWEEN STR 47L AND STR 48L SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 3.SDR UPS04441802Shear Tie · crackedINSPECTION TYPE:C AFT CARGO BILGE AREA - FS 1720, STR 49R - 51R SHEAR TIES CRACKED. AFT CARGO COMPT BS 1720 STR 49R - STR 51R SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 3.SDR UPS04441800Shear Tie · crackedINSPECTION TYPE:C BS 960 LT BETWEEN STR 7L AND 6L SHEAR TIE FOUND CRACK. BS 960 LT FRAME BETWEEN S6L AND 7L SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 4.SDR UPS04841835Beam · corrodedINSPECTION TYPE: C1, FWD PIT C1 DOOR JAMB CORNER TORQUE BOX BEAM IS CORRODED BEHIND T-BOLT LATCHES. REMOVED CORROSION IAW DC8 SRM 51-1-8. CORROSION FOUND WITHIN LIMITS IAW DAC DWG 9754007, REO G09673. MAT ID FOR SHIM 4340 STEEL BAR PO 371199.1 IAW REO G0967SDR SWAA040252Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 617, LBL 65, WL 208. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR UPS04441807Attach Angle · crackedINSPECTION TYPE:C FWD CARGO COMPT - LT STA 900 IN BETWEEN STR 43 AND STR 44 SHEAR TIE ATTACH ANGLE FOUND CRACKED. FWD CARGO COMPT BS 900 BETWEEN STR 43L AND STR 44L SHEAR TIE REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 3.SDR UPS04441793Frame · crackedINSPECTION TYPE: C, FWD CARGO COMPT - RT STA 980 IN BETWEEN STR 41 AND STR 42 FRAME FOUND CRACKED. FRAME REPAIRED AS PER SRM 53-10-04 FIG 52 AT FWD CARGO COMPT RT STA 980 BETWEEN STR 41 AND STR 42.SDR UPS04441842Forging · corrodedINSPECTION TYPE:C M/D- BS 1560-1580 LT WINDOW FORGING AFT EDGE ATT SKIN FOUND CORROSION REVEALED. BS 1560-1580, STR L19-L22 CORROSION REMOVED IAW SRM 51-10-01. CORROSION BLEND OUT 0.030 INCH X 1 INCH X 1 INCH EXCEED SRM 53-30-01 FIG 1 LIMIT. WINDOW FORGING SDR SWAA040241Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO BAY SHEAR TIES CORRODED AT BS 767, STRINGER 27R, AND AT BS 747, STRINGER 27R. REPAIRED SHEAR TIES PER SRM.SDR 04FDEA00212Shear Tie · corrodedCORROSION (C53-113-01, 2) AFT CARGO BAY, CORROSION ON FRAME SHEAR TIE BS 950F BETWEEN STR 29 LT AND 30 LT. CORROSION ON FRAME SHEAR TIE AT BS 950F BETWEEN STR 29 AND 30L IS OUT OF LIMITS PER SRM 51-10-1. FABRICATED A NEW SHEAR TIE AND REPLACED IT PER SRMSDR 04FDEA00210Shear Tie · corrodedCORROSION ON SHEAR TIE AT BS 500 STR 27 LT WL 148. BLENDED CORROSION ON SHEAR TIE AT BS 500 STR 27 LT WL 148 PER SRM 51-10-1. BLEND AREA WAS 2X1INCHES, ORIGINAL THICKNESS WAS .063. 100 PERCENT MATERIAL WAS REMOVED. REMOVED DAMAGED SHEAR TIE, BS 500, STSDR 04FDEA00207Shear Tie · corrodedCORROSION IN AFT CARGO BAY, CORROSION ON FRAME SHEAR TIE BS 950D BETWEEN STRINGER 29 LT AND 28 LT. REMOVED CORROSION ON SHEAR TIE AT BS 900D BETWEEN STR 29L AND 28L. FABRICATED SHEAR TIE. ALODINE, PRIMED AND INSTALLED SHEAR TIE AT BS 350D BETWEEN STR 29L SDR ASAA0580009Door Frame · bentOKC - FOUND HV-CHECK, MID CARGO BAY DOOR FRAME LIP SEAL WAS FOUND BENT AND DENTED. REMOVED DAMAGED SECTION. INSTALLED REPAIR SPLICE AND DOUBLER. (M)SDR 2004FA0000171Rib · corrodedREPORTED OCCASIONAL GEAR CYCLING PROBLEM. INSPECTED LANDING GEAR AND FOUND RIBS (WHICH ARE IN THE LT AND RT MAIN GEAR WHEEL WELLS) TO BE SEVERELY CORRODED. MOUNTED ON THIS RIBS IS THE BRACKET FOR THE UPLOCK LATCH SWITCH. THERE WAS ENOUGH MOVEMENT IN THE RISDR SWAA040229Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON SHEAR TIE AT BS 500, LBL 1 TO LBL 3, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA040226Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR LOWER FRAME HINGE CUTOUT RADIUS CRACKED. REPAIRED FRAME PER EA.SDR SWAA040218Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 637, RBL 65, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA040213Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 967, ABOVE L2 DOOR. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040211Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 767, LBL 2. REPAIRED SHEAR TIE PER SRM.SDR MALA040134Plate · dirtyDURING FLIGHT NR 3027, MAIN DOOR HANDLE LIGHT ON INDEX MARK DO NOT MATCH. AIR RETURN TO MSP. MAINTENANCE FOUND DOOR TO BE CLOSED AND HANDLE AFT END JUST SLIGHTLY FROM FULLY DOWN. DOOR INDEXES ARE VISABLE INSPECTED DOOR SWITCH. NO FAULTS FOUND. CLEANED AND LSDR TSAA0453023Door Frame · crackedFOUND CRACK ON LOWER INBOARD CORNER OF FORWARD CARGO DOOR FRAME. TRIMMED OUT DAMAGED AREA. VERIFIED CRACK REMOVED USING HFEC INSPECTION. FABRICATED A REPAIR ANGLE, ALODINED, AND PRIMED. INSTLALED REPAIR PARTS. REPAIR COMPLETED IAW ECO 1763. AIRCRAFT RETUSDR AWXA200400142Crease Beam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON AFT MAIN CABIN CREASE BEAM BETWEEN BS 947 AND BS 1006, RBL 65. MAINTENANCE REMOVED CORRODED CREASE BEAM FROM BS 920 TO BS 1006, RBL 65; FABRICATED A NEW REPLACEMENT CREASE BEAM; INSTASDR AWXA200400162Crease Beam · crackedLCQ - MAJOR REPAIR - DURING C-15 CHECK A .75 INCH CRACK WAS FOUND IN CREASE BEAM AT BS 662, RBL 74. MAINTENANCE REMOVED CRACKED CREASE BEAM AT BS 662, RBL 74; FABRICATED A NEW REPLACEMENT CREASE BEAM; INSTALLED REPAIR PART IAW B737-200 SRM 51-30-02, PARA 4.SDR 2004UALA00040Shear Tie · crackedBS 620 AT STR 18L-19L, SHEAR TIE CRACKED ON BOTH ENDS. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.
Back to JASC 5310