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 FDEA201103010808Crossbeam · damagedFORWARD CARGO COMPARTMENT AT FRAME 32 CROSS BEAM BETWEEN LONGERON 3 AND 4 FOUND 04 FASTENERS MISSING. FASTENERS INSTALLED AS PER E.A. 6-5310-92946, PART 2. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 111.SDR FDEA201103010805Frame · crackedAVIONICS COMPARTMENT FORWARD DOOR INT SIDE, AFT FRAME IS CRACKED IN 2 PLACES AT LIGHTENING HOLES. CRACKED DOOR FRAME WAS REMOVED PER SRM 51-40-21, PARA 6. NEW FRAME WAS FABRICATED PER DWG A52110744, ISSUE "F". FRAME WAS ALODINED PER SRM 51-21-10, PAGE 2. PSDR SWAA111312Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM Z-ANGLE CORRODED BETWEEN BS 947.5 TO BS 986.5. REMOVED AND REPLACED BEAM PER SRM AND BAC DWG.SDR FDEA201103010799Beam · damagedAFT CARGO COMPT NR 2 DOOR CENTER LOWER EDGE BEAM FOUND WITH GOUGE AND DENTS. DAMAGED BEAM ON AFT CARGO DOOR REMOVED AND REPLACED IAW SRM 51-40-02 REV. 102. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201103010797Beam · crackedFWD CARGO NR 1 DOOR AFT LOWER EDGE BEAM FOUND WITH DENT AND CRACK. CRACKED BEAM ON FWD CARGO DOOR REMOVED AND REPLACED IAW SRM 51-40-02 REV 101. REPAIR IS CLASSIFIED AS MAJOR.SDR DALA1115390944Structure · damagedON WALKAROUND FOUND DAMAGE AT FS 235, 3 INCHES ABOVE THE CUSP ANGLE ON THE FWD LT SIDE OF ACFT. THE DAMAGE IS SUSPECTED TO BE CAUSED BY A JETWAY. DAMAGE IS TO AN EXISTING REPAIR DOUBLER WHICH WAS PREVIOUSLY INSTALLED.SDR ASOA201100404Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. BLENDED CORROSION ON FS 280 BEAM FOUND TO BE OUT OF LIMITS SRM 51-12-00-001-001-A01 AND SRM 53-00-00-001-001-A01. R & R FS 280 CROSSBEAM IAW SRM 51-42-06-001-001 AND 51-42-21-001-001 AND 51-42-13-001-001.SDR SWAA111190Door Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR LOWER HINGE CUTOUT IN DOOR FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA111189Door Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR CUTOUT FWD LOWER FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR C2XA11SH048Door Frame · corrodedSHV - DURING C-CHECK SERVICE DOOR LOWER AFT CUTOUT HAS CORROSION AT STR 12R. REPAIRED SERVICE DOOR LOWER AFT CUTOUT IAW EC5310-01373. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA1149336Door Frame · corrodedL2 DOOR CUTOUT FORWARD FRAME CORRODED AT LOWER INBOARD EDGE. REPAIRED FRAME IAW ASA EA 400 53EA 05127.SDR AALA20110305TUL03Crease Beam · damagedCREASE BEAM WEB STATIONS 860 TO 880 DAMAGED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM 51-10-02-0G.SDR AALA20110227TUL03Pan · crackedSTATION 1041 LEFT SIDE WINDOW PAN LOWER FORWARD LUG CRACKED. REMOVED DAMAGE BY CUTTING OUT AREA AND INSTALLED DOUBLER ALL PER AARD 53-10-00-25.SDR AALA20110227TUL02Pan · crackedSTATION 946 LEFT WINDOW PAN FORWARD LUG CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110227TUL01Pan · crackedSTATION 845 LEFT WINDOW PAN CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL08Tab · crackedUPPER AFT WINDOW PAN TAB CRACKED STATION 1040 LEFT. INSTALL DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL07Pan · crackedUPPER AFT WINDOW TAB CRACKED STATION 1060 LEFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL06Door Frame · corrodedMID CARGO - CORROSION ON DOOR BEAM AROUND NUTS AND FASTENER HEADS AT DOOR OPENING. CORROSION REMOVED PER SRM 51-10-03. INSTALLED BEAM DOUBLER PER AARD 53-10-00-3 AND EA MD80-53-015410.SDR AALA20110226TUL05Pan · crackedSTATION 1022 RIGHT UPPER AFT WINDOW PAN CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL04Pan · crackedSTATION 1061 RIGHT FORWARD LOWER WINDOW PAN CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL03Pan · crackedSTATION 1137 RIGHT FORWARD LOWER WINDOW PAN CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110226TUL02Pan · crackedCRACK IN RIGHT AFT UPPER WINDOW PAN STATION 1135. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR DALA1123069870Door Frame · crackedFWD CARGO DOOR JAMB FWD UPPER CORNER HAS CRACK AT FASTENER. CUT OUT DAMAGE IAW DWG SR09530117. HFEC IAW NDT SPM 06-10-01.001 NO CRACKS NOTED ZETEC. FABRICATED DOUBLER FROM 2024-T3 .071 AND TRIPLER FROM 2024-T3 .090 IAW DWG SR 09530117. INSTALLED REPAIR PARSDR V0XR20110224003Seat Track · corrodedB-ROW NR 4 SEAT TRACK CORRODED AROUND SCREW HOLES, FR 36-45. INSTALLED NEW SEAT TRACK B NR 4 FROM FR 36-45 IAW EMB145 AMM 53-01-06. W/C 2126SDR V0XR20110224001Seat Track · corrodedB-ROW NR 6 SEAT TRACK CORRODED AROUND SCREW HOLES, FR 54-59. REMOVED AND REPLACED SEAT TRACK B-6 AT FR 54-59 IAW EMB145 AMM 53-01-06. W/C 2124SDR AALA20110305TUL04Crease Beam · corrodedINNER CHORD OF CREASE BEAM CORRODED STATION 760 RIGHT SIDE. REMOVED AND REPLACED CREASE BEAM PER SRM 52-10-02-0G.SDR FDEA201102240717Crease Beam · corrodedCABIN, STN 680, RBL 64 CREASE BEAM HAS SURFACE CORROSION. CORRODED CREASE BEAM INNER CHORD REMOVED AND REPLACED IAW SRM 51-40-02 REV. 101. REPAIR IS CLASSIFIED AS MAJOR.SDR UALA2011022400939Hinge · brokenRT OVERWING SLIDE PANEL HAS BROKEN (3) HINGES (3) AND LATCH PINS (4). DURING RT OVERWING SLIDE REPLACEMENT, FOUND SLIDE DOOR CRACKED AND 3 CTR HINGES BROKEN. REPLACED RH OVERWING HINGED SLIDE PANEL.SDR DALA1113500667Support Angle · damagedAFT CABIN AT STA 1420 RBL 64 CREASE BEAM SUPPORT ANGLE MOUNT HOLE ELONGATED. REPAIRED IAW ER/A 488608-14 REV ORIG.SDR DALA1113480667Door Frame · gougedMID CABIN AT FRAME STA 1020 RT SIDE AFT LOWER CORNER OF AFT EMERGENCY EXIT DOOR CUTOUT HAVE 2 GOUGE. REPAIRED IAW ER/A 488607-14.SDR SIMA201105602Structure · dentedWHILE ON THE RAMP THE AIRCRAFT WAS STRUCK BY A DEICE TRUCK NEAR THE SERVICE DOOR. SKIN HAS SEVERAL DENTS ON FRAME 22 BETWEEN STRINGERS 20 AND 18. THE SHEAR CLIP FROM 18 TO 19 CRACKED. SHEAR CLIP FROM 19 TO 20 WAS DENTED. THE AIRCRAFT WAS REMOVED FROM SERVISDR CA110223007Structure · cracked(CAN) RT REAR FUSELAGE TUBE TOP LONGERON FOUND CRACKED WHERE THE LONGERON AND TOPCROSS TUBE ARE JOINED.SDR GUUA93353022311ADoor Frame · crackedDURING SCHEDULED ROUTINE INSPECTION DISCOVERED 7.0 INCH CRACK ALLTHE WAY THROUGH THE CARGO FRAME FROM ONE END TO THE OTHER AT FS 509.5 STRINGER 15L. REMOVED DAMAGED SECTION OF CRACKED FRAME AND INSTALLED ANGLE REINFORCEMENT STRAIGHT "L" ANGLE REPAIR.SDR QXEA2011022300192Support Angle · corrodedRFD - 6 YR - FOUND CORROSION ON AFT ATTACH FLANGE ON RH NOSE JACKING SUPPORT ANGLE. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REPAIRED IN COMPLIANCE WITH T/C REO 670-53-11-581.SDR QXEA2011022300191Support Angle · corrodedRFD - 6 YR - FOUND CORROSION ON FWD SECTION OF THE LT NOSE JACKING SUPPORT ANGLE ATTACH FLANGE. BLENDED CORROSION IAW CRJ 700 SRM 51-21-06-001-001-A01. REPAIRED IN COMPLIANCE WITH QX T/C REO 670-53-11-581.SDR QXEA2011022300190Support Angle · corrodedRFD - 6 YR - FOUND CORROSION ON AFT SECTION OF THE LT NOSE JACKING SUPPORT ANGLE ATTACH FLANGE. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. REPAIRED IN COMPLIANCE WITH T/C REO 670-53-11-581.SDR ZZDA2011193Door Frame · crackedAFT OF FWD ENTRY DOOR CUTOUT FRAME UPPER FUSELAGE, STA 208, LONG 15L, CRACKED. ACCOMPLISHED UPPER FUSELAGE DOUBLER REPAIR PER B717 SRM 51-70-10.SDR 2011F00049Floorbeam · corrodedFS 280, FWD FLOOR SUPPORT FOUND CORRODED.SDR IPXA11B65599Tension Tie · crackedINSPECTION TYPE:C, STA860 LT TENSION TIE FASTENER HOLE FOUND 2EA FASTENER HOLES CRACKED AT FWD CHANNEL LAYER AS MARKED. M/D BS860 LT TENSION TIE FWD CHANNEL REPAIRED IAW RS R53-25-36963 EO B747-5310-41901-A. REFER NRC FGV512991 FOR WORKING DETAILSDR ZZDA2011191Panel · crackedLEFT AFT INBOARD WHEEL WELL, CRACKED. ACCOMPLISHED WHEEL WELL DOUBLER REPAIR PER SRM 71-70-10 AND SRM 51-41-02.SDR ZZDA2011197Door Frame · corrodedR1 LOWER FWD AND AFT DOOR JAMB, CORROSION. ACCOMPLISHED DOOR JAMB REPLACEMENT PER B717 SRM 51-41-01.SDR V0XR201102210001Beam · corrodedRT HAT CHANNEL BEAM AT FR 18 - 25 IS CORRODED BEYOND LIMITS. R & R BEAM.SDR IPXA11B65600Tension Tie · misinstalledINSPECTION TYPE:C, STA860 LT TENSION TIE FOUND FASTENER NR INCORRECT IAW EO B747-5310-41035, FIG 3. BS860 LT TENSION TIE & ATT FRAME REPAIRED, FRAME DOUBLER, TRIPLER STEEL PLATE REPLACED IAW RS R53-25-36963 & B747-5310-41901. FINAL CUTOUT FRAME LENGTH 51.375"SDR IPXA11B65598Tension Tie · inaccurateINSPECTION TYPE:C, M/D BS 860 RT TENSION TIE FOUND FASTENER NR INCORRECT IAW EO B747-5310-41035, FIG 3. M/D BS 860 RT TENSION TIE & ATT FRAME REPAIRED, FRAME DOUBLER, TRIPLER STEEL PLATE REPLACED IAW RS R53-25-36963 & B747-5310-41901. FINAL CUTOUT FRAME LENGTSDR FDEA201102200638Beam · crackedMAIN DECK CABIN, RT 3 DOOR NR 2 BEAM FWD STOP SUPPORT FOUND CRACKED. BEAM REMOVED AS PER SRM 51-31-01 REVISION 45. NEW BEAM FABRICATED AND INSTALLED AS PER EA 1-5210-143528. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 111.SDR NOCA01311Door Frame · damagedFUSELAGE DAMAGED BY GROUND EQUIPMENT APPROXIMANT 3FT AFT OF L4 DOOR FRAME OUT OF SRM LIMITS. REMOVED DAMAGE AREA AS PER SRM 53-00-01. ACCOMPLISHED HFEC TO ENSURE ALL DAMAGED REMOVED, ACCOMPLISHED REPAIR AS PER SRM 53-00-01, EO 767-53-036, MAJOR REPAIR FORM 3SDR SWAA111152Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM WEB BETWEEN BS 787 TO BS 807 CORRODED. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111120Door Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND AFT ENTRY DOOR LOWER HINGE CUTOUT IN DOOR FRAME CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA111118Door Frame · crackedDURING SCHEDULED MV1 CHECK, FOUND FWD GALLEY DOOR CUTOUT, FWD LOWER FRAME CRACKED. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA111070Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR FWD SIDE UPPER STUB FRAME CRACKED. REMOVED AND REPLACED SUBFRAME PER SRM AND BAC DWG.
Back to JASC 5310