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 07FDEA04208Beam · corrodedFOUND CORROSION ON AFT CARGO DOOR SILL BEAM BETWEEN FRAME 59-60. AREA IS UNDER FRAME 59A. REPAIR PERFORMED BY CUT OUT SILL BEAM WEB AND INSTALLING REPAIR ANGLE AND FILLER IAW EA 6-5317-82915 AND RAS/DAHAM/4019686/2005 ISSUE A.SDR DHL2007749006Torque Box · crackedDURING "A" CHECK, REF N/R 099779 , DISCREPANCY, RT AIRSTAIR TORQUE BOX CRACKED AT LIGHTING HOLE BS 1228. STOP DRILLED AT THE END OF CRACK WITH .250" IAW B727 SRM 51-10-01. C/W HFEC IAW B727 NDTM, PT 6 51-00-00, FIG 23, CRACK TERMINATE IN STOP DRILL HOLE. FSDR UPS07851018Door Frame · damagedINSPECTION TYPE:C1 TWO LARGE HOLES DRILLED THROUGH L-2 DOOR FRAME JAMB WEB LOWER AFT CORNER. TOP HOLE DOUBLE DRILLED, BOTTOM HAS CUT THROUGH INNER WEB. REPAIRED L-2 DOOR FRAME AND WEB AT LOWER AFT CORNER IAW DWG 9751052, DWG 9751060, SRM 51-1-8, SRM 51-1-20DSDR 2007UALA03839Door Frame · crackedFWD PIT DOOR CUTOUT AFT FRAME AT BS 492.5 AND STRINGER 24R END FITTING DAMAGED. UPPER EDGE CRACKED. REMOVED DAMAGE. FABRICATED AND INSTALLED REPLACEMENT STRINGER END FITTING.SDR CALA0700533Door Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT LOWER STOP PAD HOLES OF FORWARD BAG BIN DOOR CUTOUT AFT FRAME. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND BOEING DRAWING 65-20723.SDR 2007UALA03835Door Frame · crackedFWD GALLEY DOOR AFT FRAME CRACKED AT OUTBOARD LWR HOLE FOR LOWER STOP FITTING. STOP DRILLED CRACK.SDR 2007UALA03833Door Frame · crackedFWD GALLEY DOOR S/N 1247 AFT FRAME IS CRACKED AT 4TH STOP FITTING. FABRICATED & INSTALLED DOUBLER REPAIR.SDR 2007UALA03832Door Frame · crackedAFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER OUTBOARD CORNER OF LOWER STOP. REMOVED & REPLACED AFT PIT DOOR CUTOUT FWD FRAME.SDR UPS07850772Fitting · corrodedINSPECTION TYPE:C1 MAIN CABIN INTERCOSTAL TO FRAME ATTACH FITTING HEAVY CORROSION AT STA 1380 L19R. REMOVED, FABRICATED, AND INSTALLED REPAIR ATTACH FITTING AT STA 1380 L19R IAW DWG 2702605, AND SRM 51-01-20D.SDR C2XA07SH079Panel · damagedSHV - DURING C-CHECK MAINTENANCE FOUND PANEL 191 FR WITH COMPOSITE DAMAGE AND TORN EROSION TAPE. MAINTENANCE REPAIRED PNL 191 FR IAW EC 5750-01315 REV D. AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR GLBA20061004Angle · crackedLT HEAVY ANGLE CRACKED AT FS STA 288.0 FORWARD END IN BEND RADIUS. 09-26-07 CRACK APPROXIMATELY 1.75" IN LENGTH. MAINTENANCE INSTALLED REPAIR ANGLE I.A.W. BEECH SRM 53-90-23. REPAIR LENGTH 13.8 INCHES. .080 2024-0.SDR 07FDEA04184Crossbeam · corrodedCORROSION ON CROSS STRUT AT FRAME 84, STRG 15 RT FRONT SIDE. REPLACEMENT OF CROSS STRUT IAW SRM 51-72-10.SDR 07FDEA04183Crossbeam · corrodedFOUND CORROSION ON CROSS STRUT AT FRAME 87, STRG 15 RT AFT SIDE. REPLACEMENT OF CROSS STRUT IAW SRM 51-72-10.SDR 07FDEA04182Crossbeam · corrodedCORROSION ON CROSS STRUT AT FRAME 86, STRG 15 RT FRONT SIDE. REPLACEMENT OF CROSS STRUT IAW SRM 51-72-10.SDR 07FDEA04181Failsafe · damagedFOUND MISDRILLED FASTENER HOLES AT FRAME-FAIL-SAFE-RING, FUSELAGE SKIN BETWEEN FRAME 73-76, STRG 26-27 RHS. REPAIR PERFORMED BY OVERSIZING HOLES AND INSTALLATION HL13VF8 (DAN8-8) FASTENERS IAW EA 6-5318-82891 AND RAS/DAHAM/4019615/2005 ISSUE A.SDR 07FDEA04163Beam · corrodedHEAVY CORROSION ON BEAM NR 5 AT EMERGENCY EXIT DOOR RT, ZONE 844. REPLACEMENT OF BEAM NR 5 IAW SRM 51-72-10.SDR 07FDEA04151Coupling · damagedDAMAGED COUPLING AT STRG 4 LT BETWEEN FRAME 87-88. REPLACEMENT OF COUPLING IAW SRM 51-72-10.SDR UPS07850771Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 1220 L18R FWD SIDE. REMOVED, FABRICATED, AND INSTALLED REPAIR FITTING AT STA 1220 L18R IAW DWG 4750418, AND SRM 51-01-24.SDR UPS07850770Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 1220 L19R AFT SIDE. REMOVED, FABRICATED, AND INSTALLED REPAIR FITTING AT STA 1220 L19R IAW DWG 4750419, AND SRM 51-01-20D-0.SDR UPS07850769Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 905 L19R. REMOVED, FABRICATED AND INSTALLED REPAIR FITTING AT STA 905 L19R IAW DWG 3779498, AND SRM 51-03-02.SDR UPS07850767Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 1260 L20R FWD SIDE. REMOVED, FABRICATED, AND INSTALLED REPAIR FITTING AT STA 1260 L20R IAW DWG 4750419, AND SRM 51-01-20D-0.SDR UPS07850766Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 902 L18R. REMOVED, FABRICATED AND INSTALLED REPAIR FITTING AT STA 902 L18R IAW DWG 479496, AND SRM 51-01-20D.SDR UPS07850762Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 1260 L19R FWD SIDE. REMOVED, FABRICATED AND INSTALLED REPAIR FITTING AT STA 1260 L19R IAW DWG 4750419, AND SRM 51-01-20D.SDR 07FDEA04125Splice · corrodedFOUND CORROSION OUT OF LIMIT AT SPLICE C19, P 54 LT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04116Door Frame · corrodedFOUND CORROSION AT RT EMERGENCY EXIT DOOR FRAME SEGMENT 3.1. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04106Crossbeam · corrodedFOUND CORROSION AT CROSSBEAM C 63 OUT OF LIMIT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04088Box Beam · crackedTWO CRACKS IN HOLE (EACH 10MM) FOUND IN THE UPPER TORSION BOX IN BEAM AT FRAME 75, STRG 11 LT. REPAIR PERFORMED BY CUT OUT OF DAMAGED AREA, INSTALLATION OF FILLER AND REPAIR ANGLE IAW EA 6-5318-82894 AND RAS/DAHAM/4019625/2005 ISSUE A.SDR UPS07850775Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 700 L13R. REMOVED, FABRICATED, AND INSTALLED REPAIR FITTING AT STA 700 L13R IAW DWG 3779978, AND SRM 51-01-20D-0.SDR UPS07850773Fitting · crackedINSPECTION TYPE:C1 FITTING CRACKED AT STA 900 L19R. REMOVED, FABRICATED, AND INSTALLED REPAIR FITTING AT STA 900 L19R IAW DWG 3779498, AND SRM 51-01-24.SDR 2007UALA03792Door Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME IS CRACKED IN RADIUS ON AFT SIDE OF FRAME AT UPPER INBOARD CORNER OF LOWER STOP FITTING. MAJOR REPAIR ACCOMPLISHED: INSTALLED FRAME ANGLE DOUBLER REPAIR.SDR SIMA200726403Beam · corrodedDURING A MBV INSPECTION, THE BAGGAGE DOOR CUT OUT LOWER CENTER BEAM WAS FOUND CORRODED. REPLACED BEAM WITH NEW BEAM PN 145-25480-006 IAW EMB SRM CHAPTERS 51-40--02, 51-20-03, AND 51-40-06. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA04053Beam · corrodedFOUND CORROSION AT RT EMERGENCY EXIT DOOR, BEAM NR 5. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04052Door Frame · corrodedFOUND CORROSION AT EMERGENCY EXIT DOOR, FRAME SEGMENT 3.1. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04051Beam · corrodedFOUND CORROSION AT EMERGENCY EXIT DOOR, BEAM NR 5 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA04037Door Frame · damagedDURING LT FWD PAX DOOR FRAMING AFT PANEL REPLACEMENT, A DOUBLE HOLE WAS PERFORMED AT FRAME 18, STRG 26 IN LOWER BEAM WEB AT ITS REAR END AND IN STRG 26 COUPLING. REPAIR PERFORMED BY CUT OUT OF LOWER BEAM WEB IAW EA 6-5312-81117 AND RAS/AS/0017/2005 ISSUE A.SDR 07FDEA04036Door Frame · damagedDURING LT FWD PAX DOOR FRAMING AFT PANEL REPLACEMENT, A DOUBLE HOLE WAS PERFORMED AT FRAME 18, STRG 26 IN LOWER BEAM WEB AT ITS REAR END AND IN STRG 26 COUPLING. REPLACEMENT OF STRINGER 26 COUPLING BY NEW ONE IAW EA 6-5312-81117 AND RAS/AS/0017/2005 ISSUE ASDR 07FDEA04025Box Beam · corrodedCORROSION AND CRACKS FOUND ON RT AFT PAX DOOR UPPER TORSION BOX BEAM, C 73-75A, P 9-11. REPAIR PERFORMED BY CUT OUT THE DAMAGED PARTS, INSTALLING REPAIR PART AND FILLER IAW EA 6-5318-81066 AND RAS/DAHAM/4018653/2004 ISS A.SDR 07FDEA04011Beam · corrodedCORROSION ON TOP SURFACE OF AFT CARGO COMP SILL BEAM FLANGE BETWEEN FRAME 59-59A AROUND A RIVET NUT. REMAINING THICKNESS AFTER REWORK IS 0,8MM, NOMINAL: 2,0MM. REPAIR PERFORMED BY CUT OUT AFFECTED AREA AND INSTALLING FILLER AND REPAIR ANGLE IAW ENG-STATEMENTSDR 07FDEA03994Crossbeam · corrodedFOUND CORROSION AT CROSS BEAM C 63 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10SDR 07FDEA03989Fitting · corrodedFOUND CORROSION ON RUN OUT FITTING AT STRINGER P 44, C 16A-17. REPAIR PERFORMED BY REPLACEMENT OF PART IAW DRAWING R536-10440SDR QXEA200701460Door Frame · chafedC5 PDX - CHAF ON FRAME AT STATION 222 - 2100, LEFT SIDE, MAIN CABIN DOOR FORWARD SIDE. REPAIRED IAW RD8-53-9791.SDR 2007UALA03768Crease Beam · corrodedCABIN FLOOR Z-ANGLE (CREASE BEAM) CORRODED AT BS 989-994, RBL 46, WL 208. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPLACEMENT FLOOR Z-ANGLE.SDR 07FDEA03927Plate · corrodedFOUND CORROSION AT MANHOLE INTEGRAL PLATE C 38.1-39, P 49RH-54 LT AND OLD POCKET REPAIRS, NOT CONFORM TO SRM 53-14-12. REPAIR PERFORMED BY REPLACEMENT OF PART IAW DRAWING R537-06164-000 AND SRM 51-72-10 AND INSTALLING OF ALTERNATE FASTENER, APPROVED BY EA 6-5SDR 07FDEA03925Beam · corrodedCORROSION FOUND ON AFT CARGO DOOR SILL BEAM OUT OF LIMIT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03903Strut · corrodedFOUND CORROSION ON CROSS STRUT C 87 RT AND LT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03902Strut · corrodedFOUND CORROSION ON CROSS STRUT C 84 RT AND LT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03890Beam · corrodedCORROSION FOUND AT EDGE BEAM, C89-90, RT REPAIR PERFORMED BY CORROSION REWORK IAW EA 6-5319-114902 AND RAS /DAHAM/4022775/2007 ISS A.SDR 07FDEA03882Beam · corrodedHEAVY CORROSION ON BEAM 10 BETWEEN FRAME 67-69, STRG 45-47 RT, BULK CARGO COMPARTMENT DOOR. REPLACEMENT OF BEAM IAW SRM 51-72-10.SDR LR7A07092Rib · crackedDURING SCHEDULED B-2 CHECK, PER JOBCARD HB5303, FOUND COCKPIT RIGHT SIDE RIB CRACKED AT FS 132 WL 204 TO 216 RBL 55. RIB REPLACED IAW SMP583 CHAPTER 51-60 & 51-70.SDR 07FDEA03818Structure · crackedFWD CARGO COMPT BILGE AREA HAS CRACK ON CAP TEE OF BULKHEAD. REPAIRED AREA IAW EA 8-5310-99388.
Back to JASC 5310