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 FDEA201310272624Crease Beam · corrodedBS 1180 - 1200, RT CREASE BEAM WEB FOUND CORRODED. REMOVED AND REPLACED IAW DWG 146N5590 SHT.1 REV.F. MAJOR REPAIR.SDR A6WA201310274332Rib · crackedLEFT W/W BATT RIB CRACKED AT AFT CORNER. INSTALL DOUBLER REPAIR IAW REO 601R-57-51-046, REV B.SDR SWAA2013103021682Window Frame · crackedNR 3 RT WINDOW FRAME CRACKED AT 9 O'CLOCK POSITION, NR 2 HOLE FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2013103021681Window Frame · crackedNR 3 LT WINDOW FRAME CRACKED AT 3 O'CLOCK POSITION, NR 2 HOLE FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2013102821573Window Frame · crackedRT UPPER CORNER WINDOW POST C-D FRAME CRACKED .700 INCHES IN LENGTH. REPAIRED FRAME IAW EA.SDR DALA13055560955Door Frame · corrodedCORROSION ON FWD & AFT CARGO BAY DOOR FRAME BEAM. CORROSION REMOVED IAW SRM 51-10-3, PAR 26A. FOUND OUT OF LIMITS IAW SRM 53-05, FIG 123A. REPAIRED IAW ER/A 519124-14, REV ORIGINAL. REPAIR INSPECTED IAW ER/A 5109124-14 RE, ORIG AND SRM 53-05, FIG 123A.SDR ASOA2013111909420Support Beam · crackedFOUND CARGO DOOR SUPPORT BEAM AFT LOWER ANGLE IS CRACKED APPROX .5 IN LENGTH. REMOVED SUPPORT BEAM AFT LOWER ANGLE IAW SRM 51-42-21. LOCATED FASTENER HOLES IN NEW SERVICEABLE SUPPORT BEAM AFT LOWER ANGLE AND INSTALLED IAW SRM 51-40-11 & 51-42-21.SDR SWAA2013110722029Window Frame · crackedLT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013110421775Window Frame · crackedLT NR 3 WINDOW FRAME E-F FASTENER HOLE NR 8 CRACKED AT 10:00 & 4:00 O'CLOCK LOCATION. REPAIRED HOLE IAW EA.SDR SWAA2013102821572Window Frame · crackedFLIGHT DECK NR 1 WINDOW FRAME RT SIDE CRACKED AT UPPER OTBD CORNER, LOCATED JUST ABOVE PREVIOUS CRACK. REPAIRED FRAME IAW EA.SDR FDEA201310252613Crease Beam · corrodedCREASE BEAM BS 690-725 CORRODED. R & R CREASE BEAM IAW SRM 51-40-02.SDR SWAA2013111122177Window Frame · crackedLT NR 1 WINDOW FRAME OTBD UPPER CORNER AFT UPPER FASTENER HOLE CRACKED. R & R FRAME IAW ACO.SDR SWAA2013111122176Window Frame · crackedLT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. R & R FRAME IAW ACO.SDR CHQA20131025389Structure · corrodedDURING INSPECTION, CORROSION WAS FOUND AROUND THE LAVATORY DUMP CHUTE ON THE EXTERNAL SIDE. THE LAVATORY DUMP CHUTE CUP AND ZEE PROFILE WERE REPLACED IAW SRM 51-20-01.SDR FDEA201310242607Crease Beam · corrodedBS 990 - 1040 LT CREASE BEAM INNER ANGLE FOUND CORRODED. REMOVED AND REPLACED WITH NEW ANGLE FABRICATED IAW DWG 144N5152 SHT 1 REV AND INSTALLED IAW DWG 144N5140 SHT 2 REV C AND DWG 144N5140 SHT 5 REV A WITH E.A F-5100-T0303903 PART 1. MAJOR REPAIR.SDR ASAA2013102396876Frame · dentedFRAME AT BS 727F, FREE FLANGE DENTED BETWEEN S24-25L. ACFT GROUNDED. REPAIRED FRAME IAW, EA 400-53 EA11637 AND SRM 53-00-07, REPAIR 14.SDR SWAA2013111422382Window Frame · crackedNR 1 RT WINDOW FRAME FOUND CRACKED AT AFT HOLE COMMON TO THE C-D POST APPROXIMATELY 21.5 INCHES FROM THE UPPER EDGE OF FRAME. REPAIRED FRAME IAW SRM.SDR A6WA201310234334Drag Angle · crackedRIGHT W/W DRAG ANGLE CRACKED AT FWD & AFT CORNERS. R & R DRAG ANGLE WITH SERVICEABLE IAW SRM 51-40-11 & SRM 51-42-21.SDR A6WA201310234331Drag Angle · crackedLEFT WW DRAG ANGLE COMMON TO BATTERY RIB CRACKED. R & R WITH SERVICEABLE PART IAW SRM 51-42-21.SDR SWAA2013110521902Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR C77A20131022006Beam · corrodedFWD CARGO THRESHOLD BEAM HAS CORROSION AROUND THE AFT 2 LATCHES. R & R THRESHOLD BEAM IAW SRM 51-41-01 AND 51-43-01SDR FDEA201310212566Crease Beam · corrodedFOUND CREASE BEAM OTBD ANGLE CORRODED. REPAIRED IAW EA F-5310-T0303892 PART 1. REPAIR IS MAJOR.SDR SWAA2013111122173Window Frame · crackedRT NR 3 WINDOW FRAME E-F POST 1ST, 2ND, & 3RD HOLES FROM BOTTOM CRACKED. R & R FRAME IAW SWA EA.SDR SWAA2013111122172Window Frame · crackedLT NR 3 WINDOW FRAME E-F POST 4TH HOLE FROM BOTTOM CRACKED. R & R FRAME IAW SWA EA.SDR UHLA2013102100551Doubler · corrodedCORROSION FOUND ON DOUBLER. R & R DOUBLER.SDR UHLA2013102100543Beam · corrodedCORROSION FOUND ON RT BEAM BETWEEN FRAMES 86-89. R & R RT AFT BEAM.SDR A6WA201310214262Post · crackedVERTICAL POST IS CRACKED AT 409+128 AND LBL 27 AT THE BOTTOM OF THE POST. REPAIRED IAW REO 601R-53-41-1734.SDR CWQR20131016047Door Frame · crackedDURING AN INSPECTION, FOUND THE OUTER DOOR FRAME CRACKED UNDER THE TELECOPING ROD ATTACH POINT ON THE AFT OUTER CABIN DOOR FRAME. VERFIED CRACK WITH EDDY CURRENT INSPECTION. REPLACED CABIN DOOR FRAME.SDR DALA13054249000Pan · crackedDURING SCHEDULED CHECK, A CRACK WAS FOUND AT THE LT AFT OVERWING EXIT DOOR FRAME UPPER PAN, AFT OF THE UPPER LATCH CUTOUT. REPAIRED IAW SRM 53-05, FIG 32.SDR DALA13063805639Fitting · corrodedCORROSION ON WRAP AROUND FITTING AT FWD CARGO DOOR CUTOUT, BS 600, AROUND LOWER BOLT. REMOVED TWO ANGLES AT FWD CARGO DOOR CUTOUT AND REMOVED CORROSION LOWER BOLT. FOUND TO BE WITHIN LIMITS IAW SRM 51-40-02.SDR ASAA2013102096217Striker · wornHIGH PRESSURE DOOR 192. FWD RT OTBD LATCH STRIKE PLATE WORN THRU, ACFT GROUNDED. BLENDED OUT DAMAGE ON TOP SURFACE OF LOWER CHORD. MATERIAL REMOVED .025, AREA .060 LENGTH, .050 WIDTH, BLENDED OUT DAMAGE FROM EDGE OF LOWER CHORD, MATERIAL REMOVED .030, AREA .SDR DALA13054421505Failsafe · crackedSPAR BULKHEAD FITTING AREA THE LOWEST FASTENER FOUND CRACK AT FAILSAFE STRAP AT 5"0 CLOCK POSITION. REPAIRED IAW ERA 515823-14AD.SDR FDEA201310182545Door Frame · crackedBS 1259, LONGERON 26R, R3 DOOR FORWARD FRAME LOWER WEB FOUND CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 118.SDR DALA13054441506Failsafe · crackedLEFT BS 955 REAR SPAR BULKHEAD FITTING HAS TWO CRACKS FOUND AT FAILSAFE STRAP. REPAIRED IAW ERA 515822-14AD.SDR DALA13054313761Door Frame · corrodedAFT CARGO DOOR CUT OUT LOWER WEB CORRODED. MAINTENANCE R & R WEB IAW SRM 51-40-02 AND DWG 146A8123.SDR RAIA201310180004Beam · corrodedMAINTENANCE INSPECTED AND FOUND CARGO DOOR ZEE BEAM CORRODED. MAINTENANCE REPLACED CARGO DOOR ZEE BEAM.SDR FDEA201310172527Strap · corrodedAPU AIR INLET DOOR CUTOUT, FWD STRAP HAS CORROSION AT BS 1787, S3-6R. CORROSION REMOVED IAW SRM 51-10-02 REV 109 FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DETAIL II REV 110. STRAP REMOVED IAW SRM 51-40-02 REV 110. NEW STRAP INSTALLED IAW DWG 148N3105 SH SDR SWAA2013110521855Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW OTBD SIDE FRAME CRACKED AT UPPER CORNER. REPAIRED FRAME IAW SWA EA.SDR FDEA201310172537Crease Beam · corrodedCREASE BEAM INNER CHORD BS 1320-1360 S17L UPPER SURFACE HAS CORROSION AROUND SCREW HOLES. REMOVED & REPLACED CREASE BEAM FROM BS 1290-1360 LBL 58, IAW SRM 51-40-02 & DWG 146N8326. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, DETAIL VIII, FIG. 101, SDR CALA2013101792137Beam · crackedNR 1 LT MED UPPER BEAM, FOUR ATTACH HOLES CRACKED. INSTALLED NEW BEAM IAW SRM 51-40-02 & DRAWING 65B01836.SDR UHLA2013101600539Beam · damagedFWD CARGO DOOR BEAM, DAMAGED. R & R FORWARD CARGO DOOR BEAM BETWEEN FRAMES 24-27R.SDR CWQR20131016046Door Frame · crackedDURING INSPECTION, FOUND THE OUTER DOOR FRAME CRACKED UNDER THE TELECOPING ROD ATTACH POINT ON THE FWD OUTER CABIN DOOR FRAME. VERFIED CRACK WITH EDDY CURRENT INSPECTION. REPLACED CABIN DOOR FRAME.SDR CWQR20131016045Door Frame · crackedDURING AN INSPECTION, FOUND OUTER DOOR FRAME CRACKED UNDER THE TELECOPING ROD ATTACH POINT ON THE AFT OUTER CABIN DOOR FRAME. VERFIED CRACK WITH EDDY CURRENT INSPECTION. REPLACED CABIN DOOR FRAME.SDR YENA20131016215Crossbeam · corrodedDURING HEAVY CHECK, FOUND FWD CABIN CROSSBEAM FRAME 14 RT CORRODED, REMOVED CORROSION IAW EAMS NR H4029/1546, CUTTING OUT AREAS WITH OVER 40 PERCENT CORROSION. HFEC INSPECTION AND INSTALLED A (LT) ANGLE AND FILLER AS PERMANENT REPAIR IAW EA E13-647-01.SDR CA131213005Door Frame · cracked(CAN) DURING ROUTINE MAINTENANCE, CRACKS WERE DISCOVERED IN THE AFT BAGGAGE DOOR UPPER MAIN SILL. 1 CRACK WAS FOUND IN EACH OF THE SILL STIFFENERS AT X744.145 AND X467.645, BEHIND THE BALANCE SYS SUPPORT FITTINGS, PN 85237815. TEMPORARY RD 8/4-53-5776 WAS ISSDR ASAA2013101596700Finger Doubler · damagedAFT CARGO DOOR CUTOUT AFT LOWER WRAP AROUND FINGER DOUBLER DAMAGED. ACFT GROUNDED. R & R COVER ON AFT CARGO DOOR CUTOUT AFT SIDE IAW SRM 51-10-02-0G, ITEM 4B, PAGE 2.SDR SWAA2013102821509Fitting · crackedAFT BULKHEAD LT DOOR FRAME FITTING CRACKED AT STATION 1076, LONGERON 13L. R & R FITTING IAW SRM & DRAWING.SDR DALA13053653761Door Frame · corrodedDURING INSPECTION, FOUND FORWARD CARGO DOOR SURROUND LOWER WEB CORRODED. MAINTENANCE REMOVED WEB AND REPLACED AS REQUIRED, SRM 51-40-02, FIG 11, PG 40, SRM 51-40-05, FIG 5, PG 11, PS 900-2, NO 04, PG 1.SDR DALA13053623761Crease Beam · corrodedDURING INSPECTION, FOUND CABIN FORWARD WET AREA RT CREASE BEAM ANGLE HAS CORROSION AROUND FASTENER HOLES BS 300-328, RBL 56-63. MAINTENANCE R & R CREASE BEAM ANGLE IAW SRM 51-40-02, PG 1-10 AND DWG 141A8310.SDR SWAA2013110421829Crease Beam · corrodedCEASE BEAM WEB LOWER SURFACE CORRODED AT BS 710, LBL 65. REPAIRED WEB IAW ER & EA.
Back to JASC 5310