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 2001UALA02277Crease Beam · corrodedMID CABIN CREASE BEAM INNER CHORD BODY STATION 745 TO 756 CORRODED AT LBL 60. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM INNER CHORD.SDR SWAA013098Web · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB CORRODED FROM BS 727B TO BS 857, WL 208 LBL 68. REPAIRED WEB PER SRM.SDR SWAA013097Web · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 17.1 & WL 238. REPAIRED WEB PER SWA RA.SDR SWAA013096Web · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17.0, WL 225 TO 230. REPAIRED WEB PER SWA RA.SDR ABXA010612Support · crackedVERTICAL FLOOR SUPPORT FITTING CRACKED F.S. 541 AT LONGERON 24 RIGHT. REPAIRED FITTING IAW DC-9 SSRM DWG K05159, DC-9 SRM 51-30-2 AND 51-30-5.SDR ABXA010611Support · crackedVERTICAL SUPPORT FITTING AT STATION 256, LONGERON 24 LEFT CRACKED. REPAIRED FITTING IAW DC-9 SSRM.SDR ABXA010610Support · crackedVERTICAL SUPPORT FITTING AT STATION 237, LONGERON 24 RIGHT WAS CRACKED. REPLACED FITTING IAW DC-9 SSRM DWG K05159.SDR ABXA010609Support · crackedVERTICAL SUPPORT FITTING AT STATION 256, LONGERON 24 RIGHT WAS CRACKED. REPLACED FITTING IAW DC-9 SSRM DWG K05159.SDR ABXA010608Support · crackedVERTICAL SUPPORT FITTING AT STATION 332, LONGERON 24 RIGHT CRACKED. REPAIRED AREA IAW DC-9 SSRM DWG K05159.SDR SWAA013118Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14L & 15L. REPAIRED SHEAR TIE PER SRM.SDR P5CA0100611Web · cracked1-1/2" CRACK BETWEEN STA 280 & 300 LH OB INTERCOSTAL ON NOSE WHEEL WELL ROOF RUNNING ACROSS UPPER FLANGE & DOWN THE WEB OF THE "Z" SECTION. NO ADJACENT FASTENERS ARE MISSING, LOOSE OR SHEARED. REPAIRED AS PER SRM 51-40-04, FIG 2, DETAIL 2.SDR P5CA0100612Web · cracked6" CRACK AT STA 300 RH NOSE WHEEL WELL BEAM RUNNING ACROSS WEB, EMINATING FROM INSULATION BLANKET STANDOFF HOLE. NO ADJACENT FASTENERS LOOSE, SHEARED OR MISSING. REPAIR CARRIED OUT IAW SRM 51-40-02, FIG 1, SHT 5, DETAIL 3. PARTS TREATED W/ ALODINE 1200 & REPAISDR GTIA012194Shear Tie · crackedFTW - FOUND FUSELAGE FRAME AT STATION Y 980 CRACKED AT LONGERON 16R. AFTER FURTHER EVALUATION. FOUND THE FRAME SHEAR TIE TO BE THE ONE WITH CRACKS TWO EACH BETWEEN LONGERON 16R-17R. REMOVED DAMAGE SHEAR TIE AT STATION 980. FABRICATED NEW SHEAR TIE IAW DC9 SDR GTIA012190Shear Tie · crackedFTW - FOUND FUSELAGE FRAME STATION Y-980 CRACKED AT LONGERON 16L. AFTER FURTHER EVALUATION FOUND THE FRAME SHEAR TIE TO BE ONE WITH CRACKS. REMOVED DAMAGED SHEAR TIE AT STATION 980. FABRICATED NEW SHEAR TIE IAW DC9 SRM 51-10-2. INSTALLED NEW SHEAR TIE IAW SDR GTIA012181Shear Tie · crackedFTW - FOUND FRAME TO SKIN CLIP CRACKED AT FUSELAGE FRAME STA Y-980 ADJACENT TO LONGERON 14L. REMOVED EXISTING REPAIR CLIP. FORMED NEW CLIP. INSTALLED IAW DC9 RM 51-30-2. (M)SDR QXEA0101950Stop Fitting · wornPDX - LT AFT OVERWING EMERGENCY EXIT APERTURE STOP PLATES TWO EACH ARE STEP WORN. REPAIRED IAW FOKKER SRM 51-31-01.SDR 0104299949Longeron · corrodedDuring HCK in ATL, The 5911415-113 Longeron #11 left was found to have corrosion on the lower horizontal flange at the fwd end (sta 756). Material 0.050 7075-t6 extrusion. Repaired per EA 99-185303.SDR DL72S011790Door Frame · crackedTHE FWD FRAME OF THE C1 DOOR OPENING AT FS 560 WAS FOUND WITH TWO WEB CRACKS AT EXISTING FASTENER LOCATIONS BELOW THE UPPER DOOR SILL. THE CRACKS ARE TYPICAL OF BAC S/B 727-53-0219 AND AD 99-23-13. THE CRACKS WERE CUT OUT OF THE WEB AND REPAIRED WITH A TITANSDR SWAA013055Stiffener · crackedDURING SCHEDULED D CHECK, FOUND CRACKED STIFFENER AT BS 328, RBL 32 & WL 201. REPAIRED STIFFENER PER SRM.SDR GTIA012155Door Frame · corrodedFTW - FORWARD CARGO COMPARTMENT LOWER DOOR JAMB AREA CORRODED BETWEEN STA Y 330 AND STA Y 427. LOWER DOOR JAMB PAN OUT OF LIMITS. FABRICATED PAN PER DC9 SRM 53-05. INSTALLED DOOR JAMB DOOR PAN FORWARD AND PAN DOUBLERS AND WEB IAW SRM DC9. (M)SDR 2001UALA02246Shear Tie · buckledAFT PIT FRAME STATION 807 SHEAR TIES BETWEEN STRINGER 27L AND 27R ARE BUCKLED. MAJOR REPAIR ACCOMPLISHED. SHEAR TIE MANUFACTURED AND INSTALLED.SDR 0104129994Pressure Panel · crackedDuring Hck in ATL, a crack was found in the flight compartment horizontal pressure panel at station 105. The 1.5" crack is located at X=35. Material 0.040" thick 2024-t3 aluminum clad sheet. EA 99-185277SDR SWAA013047Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME SHEAR TIE CRACKED AT BS 360, ABOVE STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA013043Tie Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND TIE CLIP CRACKED AT BS 420, STR 14R. R&R TIE CLIP PER SRM.SDR SWAA013038Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REPAIRED FRAME PER SRM.SDR 01FDEA00975Shear Tie · crackedWHILE WORKING N296 FOUND CRACK IN SHEAR TIE BS 720, RBL 11, WL 150. REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4, 51-10-3.SDR UPS01437274Web · crackedINSPECTION TYPE:C R/H SIDE NWW ON BS 300 VERTICAL BEAM WEB FOUND CRACKED AT #5 CLIP ( COUNTED FROM TOP ) ATTACHED FASTENER HOLE, THE MOST I/B FASTENER HOLE, APPROX 3/16" IN LENGHT AS MARKED. WEB REPLACED AS PER SRM 51-10-01.SDR P5CA0100610Web · crackedNOSE WHEEL WELL - BS 300, RIGHT VERTICAL BEAM WEB, 1" LONG CRACK AT 3RD INSULATION HOLE FROM FLOOR BEAM CHORD. REPAIRED BY REMOVING EXISTING FASTENERS & BRACKETS, CUTTING OUT DAMAGED SECTION, INSTALLING DOUBLERS & (2) EA. "T" SECTIONS IAW BOEING TELEX PAO-LGBSDR P5CA0100609Web · crackedNOSE WHEEL WELL - BS320, RIGHT VERTICAL BEAM WEB, 2" LONG CRACK AT 2ND INSULATION HOLE FROM FLOOR BEAM CHORD. REPAIRED BY REMOVING EXISTING FASTENERS, CUTTING OUT DAMAGE, INSTALLING DOUBLER, SPLICE FILLER, SHIM & (2) EA. "T" SECTIONS IAW BOEING TELEX PAO-LGB-SDR P5CA0100608Web · crackedNOSE WHEEL WELL - BS300, LEFT VERTICAL BEAM WEB, 1/8" LONG CRACK AT 3RD INSULATION HOLE FROM FLOOR BEAM CHORD. OPENED HOLE TO 9/16". H.F.E.C. NO INDICATIONS. INSTALLED REPAIR DOUBLERS AS PER BOEING TELEX PAO-LGB-01-00155H & MA #A5310-33-10.SDR P5CA0100607Web · crackedNOSE WHEEL WELL - BS320, LEFT VERTICAL BEAM WEB - (3) CRACKS 1/8" LONG EA. LOCATED AT 2ND, 3RD & 5TH INSULATION HOLES FROM FLOOR BEAM CHORD. OPENED HOLE TO 9/16". H.F.E.C. NO INDICATIONS. INSTALLED REPAIR DOUBLERS AS PER BOEING TELEX PAO-LGB-01-00155H & MA SDR SWAA013046Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER SRM.SDR SWAA013013Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED ( 2 EA ) AT BS 328, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA013020Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND ( 2 EA ) VERTICAL BEAM WEBS CRACKED AT BS 178, WL 227 & WL 232, LBL 17.1 & RBL 17.1. R&R WEBS PER SRM.SDR CA011105010Beam · cracked(CAN) DURING ACCOMPLISHEMENT OF TASK 5310/27D , CRACK 1.8 INCH FOUND IN TRANSVERSE BEAM & DOUBLER ASSY. CRACK TO BE REPAIRED AS PER RD8-53-2376 PRIOR TO DISPATCH.SDR UPS01437307Fitting · crackedINSPECTION TYPE:C AFT CARGO COMPT - LH BS 1480 B/H NO.9 HOLE FOUND CRACK AT EXTENSION FITTING AND OUTER CHORD SPLICE FITTING ( REFER ATT SKETCHES FOR DETAILS ). LH BS 1480 B/H EXTENSION FTG AND OUTER CHORD SPLICE FTG HOLE NO.9 CRACKS REMOVED AND BUSHINGS ISDR UPS01437306Fitting · crackedINSPECTION TYPE:C RH BS 1480 BULKHEAD ONE EA BOLT HOLE NO.25 FOUND TWO CRACKS AT OUTER CHORD SPLICE FITTING FWD SURFACE APPROX 0.030" AT 4 O'CLOCK POSITION ( LOOKING FWD ) AND 0.030" APPROX THROUGH THICKNESS AT 10 O'CLOCK POSITON. RH BS 1480 B/H SPLICE FTGSDR UPS01437305Fitting · crackedINSPECTION TYPE:C R/H SIDE BS 1480 B/H FASTENER HOLE #9 FOUND CRACKED AT B/H LONGERON EXTENSION FITTING, FUSELAGE SKIN B/H CHORD AND OUTER CHROD SPLICE FITTING, PLS REFER TO ATT SKETCH FOR DETAIL. RH BS 1480 B/H LONGERON EXTENSION FTG FX SKIN, B/H CHORD & SDR UPS01437303Fitting · crackedINSPECTION TYPE:C R/H SIDE BS 1480 B/H FASTENER HOLE #11 FOUND CRACKED AT B/H LONGERON EXTENSION FITTING, FUSELAGE SKIN AND B/H CHORD, PLS REFER TO ATT SKETCH FOR DETAILS. RH BS1480 B/H HOL #11 AT LONGERON EXTERSION FTG, FX SKIN & B/H CHORD CRACKS REMOVED.SDR UPS01437301Bushing · crackedINSPECTION TYPE:C L/H SIDE BS 1480 B/H FASTENER HOLE #18 FOUND CRACKED AT OUTER CHORD SPLICE FITTING, PLS REFER TO ATT SKETCH FOR DETAILS. LH BS 1480 B/H OUTER CHORD SPLICE FTG HOLE #18 CRACK REMOVED AND OUTER CHORD SPLICE FTG, B/H CHORD, SKIN & LONGERON ESDR UPS01437300Bushing · crackedINSPECTION TYPE:C AFT CARGO COMPT - LH BS 1480 B/H NO.11 HOLE FOUND CRACK AT FX SKIN AND OUTER CHORD SPLICE FITTING (REFER ATT SKETCHES FOR DETAILS). LH BS 1480 B/H SKIN & OUTER SPLICE FTG HOLE NO.11 CRACKS REMOVED AND EXTENSION FTG, SKIN AND OUTER CHORD SSDR UPS01437298Stiffener · crackedINSPECTION TYPE:C NOSE WHEEL WELL BOX (TUNNEL AREA) STA 360 SIDE WALL PNL ATT HORI NO. 5 STIFFENER FOUND CRACKED AND MARKED (COUNT FROM TOP). (LHS) STA 360 TO 380 NO.5 HORI-STIFFENER REPLACED PER SRM 51-10-01.SDR UPS01437296Bushing · crackedINSPECTION TYPE:C R/H SIDE BS 1480 B/H FASTENER HOLE #1 FOUND CRACKED AT FUSELAGE SKIN, B/H CHORD AND OUTER CHORD SPLICE FITTING, PLS REFER TO ATT SKETCH FOR DETAILS. RH BS 1480 B/H HOLE #1 AT FUS SKIN, B/H CHORD AND OUTER CHORD SPLICE FTG CRACKS REMOVED BSDR 2001UALA02197Crease Beam · crackedCREASE BEAM CRACKED AT STATION 178 WL 207 RIGHT HAND SIDE. MAJOR REPAIR ACCOMPLISHED. REPAIRED CREASE BEAM.SDR SWAA013014Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED ( 14 EA ) AT BS 520, STR 7R, 6R, 7L & 8L, BS 578, STR 8L & 8R, BS 597, STR 8L, BS 616, STR 4R, BS 727B, STR 3L & 3R, BS 727C, STR 3L, BS 727E, STR 3L, 3R & 2R. R&R STR CLIPS PERSDR EISA20010130Frame · crackedAT 'D' CHECK, FOUND FRAME CRACKED AT BS 460, STR 3L.CORRECTIVE ACTION: REMOVE DAMAGE, FABRICATED DOUBLER FROM 7075-T6 .063 IAW SRM 53-10-4, INSTALL REPAIR IAW SRM 53-10-4 FIG. 2.SDR UPS01437309Web · crackedINSPECTION TYPE:C L/H SIDE BS 1480 BULKHEAD ONE EACH BOLT NO.26 FOUND CRACK AT BULKHEAD WEB FWD SURFACE 0.080" APPROX AT 8 O'CLOCK POSITION REFER TO ATTCHED DRAWING FOR DETAILS. LH BS 1480 B/H WEB AT HOLE #26 CRACK REMOVED AND BUSHING INSTALLED AT WEB AS PSDR UPS01437308Splice Plate · crackedINSPECTION TYPE:C LH SIDE BS 1480 BULKHEAD ONE EACH BOLT HOLE NO.23 FOUND CRACK AT SPLICE PLATE FWD SURFACE 1/8" APPROX AT 8 O'CLOCK POSITION REFER TO ATTTACHED DRAWING FOR DETAILS. LH BS 1480 B/H SPLICE PLATE AT HOLE #23 CRACK REMOVED AND BUSHING INSTALLESDR UPS01437285Web · crackedINSPECTION TYPE:C L/H SIDE NWW AT BS 300 VERTICAL BEAM WEB FOUND ONE EACH STANDOFF HOLE CRACKED JUST BETWEEN #1 AND #2 STIFFENER ( COUNTED FROM TOP ) AS MARKED. NEW VERTICAL WEB INSTALLED AS PER SRM 51-30-02SDR UPS01437278Web · crackedINSPECTION TYPE:C L/H SIDE NWW AT BS 320 VERTICAL BEAM WEB FOUND ONE EACH STAND OFF HOLE CRACKED, JUST BETWEEN 31 AND #2 STIFFENER ( COUNTED FROM TOP ) AS MAKRED. REF NRC GJ58782 VERTICAL WEB REPLACED AS PER SRM 51-30-02.
Back to JASC 5310