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 ZZDA2007299Structure · damagedWHILE DOWNJACKING A/C AFT JACK FAILED AND DAMAGED A/C. INSTALLED REPAIR DOUBLER, TRIPLER, FILLER AND FINGER DOULBER.SDR 2007UALA03730Door Frame · damagedL2 UPPER HINGE ARM BEARING BLOCK AREA DOOR FRAME HAS A VERY DEEP PUNCTURE GOUGE IN RADIUS. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FORMED & INSTALLED NEW INTERCOSTAL.SDR QXEA200701430Frame · corrodedC5 PDX - FORWARD CENTER UNDERFLOOR VERTICAL FRAME STRUCTURE AT STATION 201, STRINGER 31L. SUSPECT CORROSION UP FRONT SKIN ON AFT INBOARD CORNER OF FLOOR RISER FRAME. REPAIRED IAW SRM 51-20-36, 51-20-11, 51-20-26, AND 51-2016.SDR 07FDEA03780Beam · corrodedSEVERAL CORRODED AREAS ON SILLBEAM OF AFT CARGO COMPARTMENT CUT OUT. REPAIR PERFORMED BY REPLACEMENT BY INSTALLING AIRFRAME AND HARDWARE KIT: SR5317-99A00500 AND SR5317-99H01200 IAW SRM 53-17-18/FIG 207 / TB. 203. DEVIATIONS FROM SRM 53-17-18/FIG 207. INSTASDR 07FDEA03724Beam · corrodedFOUND CORROSION ON AFT CARGO DOOR SILL BEAM BETWEEN FRAME 59-59A. SILL BEAM REPAIR PERFORMED BY CUT OUT AND INSTALLING A FILLER IAW SRM 53-17-18/FIG 202, APPROVED BY EA 6-5317-92153 AND RAS/DATLS/0002685/2005 ISSUE A.SDR UPS07850884Doubler · crackedINSPECTION TYPE:C1 FUSELAGE NOSE EXTERIOR, NOSE PNEUMATIC HOOK UP DOOR DOUBLER IS CRACKED. REMOVED, FABRICATED, AND INSTALLED REPAIR DOUBLER AT NOSE PNEUMATIC HOOKUP DOOR IAW SRM 53-03-03-00 FIG 023 AND SRM 51-1-20D.SDR 07FDEA03678Profile · chafedFOUND AN OLD REPAIR (CUT OUT) FLANGE WITH CHAFING MARKS AT FRAME 16 LT, OUT OF LIMIT. REPLACEMENT OF FLANGE IAW SRM 51-72-10.SDR 07FDEA03646Beam · crackedFOUND CRACK ON LONGITUDINBAL BEAM C 74-76, P 11 LT/RT, (LT: 8MM, RT 15MM). REPAIR PERFORMED BY INSTALLING REPAIR ANGLES IAW SRM 53-181-18 FIG 204.SDR SWAA074594Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 1006 AND BS 1016, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR 07FDEA03691Crossbeam · corrodedCORRODED AND OLD REPAIRED CROSSBEAM AT FRAME 58 IN BULK CARGO COMPARTMENT. REPLACEMENT OF CROSSBEAM IAW SRM 51-72-10.SDR 07FDEA03654Beam · corrodedCORROSION FOUND ON LOWER SILL BEAM OF AFT CARGO DOOR AT C59A. REPAIR PREFORMED BY TRIM OUT THE AFFECTED AREA AND FABRICATE A STRAP IAW EA 6-5310-79580 AND RAS/DATLS/0001970/2004 ISS A.SDR GLBA20060998Angle · crackedLT HEAVY ANGLE CRACKED APPROXIMATELY 1.6 INCHES AT F.S. 288.0 TO 289.6. MAINTENANCE REPAIRED LT HEAVY ANGLE IAW SRM 53-90. REPAIR LENGTH 13.5 INCHES. PN 114-430002-7179. AT FS 288 TO FS 301.5. RII INSPECTION COMPLIED WITH IAW TASKCARD 8.2.1.SDR 2007UALA03668Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT INBOARD RADIUS ABOVE LOWER STOP FITTING AND IN WEB INBOARD OF FITTING AT UPPER BOLT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED EXTERNAL NESTED ANGLE & FILLER REPAIR.SDR 2007UALA03663Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT INBOARD RADIUS ABOVE LOWER STOP FITTING AND IN WEB INBOARD OF FITTING AT UPPER BOLT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED & INSTALLED EXTERNAL NESTED ANGLE & FILLER.SDR USAA920070829Door Frame · crackedCLT - MAJOR REPAIR - NR 6007659, CRACKED WEB, BS 294.5, S12L, FORWARD ENTRY DOOR CUTOUT FORWARD FRAME. REPAIRED WEB, BS 294.5, S12L, FORWARD ENTRY DOOR CUTOUT FORWARD FRAME IAW B737-300 SRM 51-10-02.SDR USAA920070828Door Frame · crackedCLT - MAJOR REPAIR - NR 6007658, CRACKED WEB, BS 294.5, S15L, FORWARD ENTRY DOOR CUTOUT FORWARD FRAME. REPAIRED WEB, BS 294.5, S15L, FORWARD ENTRY DOOR CUTOUT FORWARD FRAME IAW B737-300 SRM 51-10-02.SDR KCSA071356Door Frame · crackedL-5 DOOR LOWER HINGE CUTOUT LOWER WEB CRACKED .25 INCH AT STA-2242 WL-230.SDR 07FDEA03945Crossbeam · crackedCROSS-BEAM CRACKED AT FRAME 54.3 BETWEEN Y-1450 AND Y-1950. THE CROSS-BEAM WAS REPAIRED IAW FEDEX EA 6-5310-113718.SDR SWAA074511Crease Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 188 AND BS 196.5, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR 07FDEA03489Structure · corrodedHEAVY CORROSION ON LOWER T-SECTION AT FRAME 92 BETWEEN STRG 21 LT TO STRG 21 RT. REPAIR PERFORMED CUT OUT T-SECTION AND INSTALLING NEW PORTION OF T-SECTION AND A REPAIR ANGLE IAW EA 6-5319-95861 AND RAS/DAHAM/4020299/2005 ISSUE A.SDR DLM88071204Beam · corrodedCORROSION ON LWR BEAM AT FWD COMPARTMENT JAMB STA 370-427, REPLACED BEAM PER SRM 53-05D FIG 804D.SDR DLM88071195Door Frame · corrodedCORROSION ON AFT CARGO BIN DOOR JAMB WEB. BEAM OF LOWER DOOR JAMB WAS REPLACED IAW DOUGLAS REF INST DWG 5930483 REV AL.SDR S2YA07006Angle · crackedDURING STRUCTURAL INSPECTION OF THE AIRCRAFT, A CRACK WAS FOUND IN THE LT FUSELAGE TO WING ANGLE. THE ANGLE IS LOCATED NEAR FS 288 IN THE AREA OF STRINGER 10L AND 10R. THE ANGLE WAS CRACKED IN THE RADIUS AT THE FORWARD END: THE CRACK WAS NO GREATER THEN 1.80 SDR WGEA200700004Beam · damagedREPAIR OF FORWARD UPPER RIGHT WINDSHIELD BEAM PART NUMBER 53-111681-2005. REPAIRED IAW ECLIPSE AVIATION SERVICE ENGINEERING MEMO, MEMO SEM 500-0076 REV A.SDR ABXA070319Beam · crackedFORWARD LOWER CARGO DOOR BEAM END CRACKED NR 4 BEAM FORWARD END STEEL CAP. REPLACED FITTING IAW DC9 SRM 51-30-5.SDR 07FDEA04103Door Frame · corrodedAFT CARGO COMPARTMENT DOOR FRAME, CORROSION AT FRAME 59A BETWEEN STRG29-30 RT. REPAIRED IAW SRM 53-17-13 FIG 210A.SDR 07FDEA03458Door Frame · corrodedCORROSION FOUND BELOW LOWER DOOR STOP FITTING ON LT FWD DOOR, FRAME 14 LT, T1. REPAIR WAS PERFORMED BY SMOOTH BLEND OUT OF CORROSION IAW EA 6-5312-95915 AND RAS/043491/005/2006 ISSUE A.SDR 07FDEA03440Beam · misrepairedOLD REPAIR ON AFT CARGO COMPARTMENT DOOR SILL BEAM BETWEEN FRAME 62-63, PLATE MATERIAL IS NOT CONFORM TO SRM 53-17-18/FIG 201. REPAIR RENEWED BY INSTALLING A CORRECT PLATE IAW SRM 53-17-18/FIG 201.SDR 07FDEA03435Shear Plate · damagedCRACKED SHEAR PLATES IN ZONE 170, FRAME 79, STRG 26 LHS AND RHS. REPAIR PERFORMED BY REPLACEMENT OF PARTS IAW SRM 51-72-10.SDR 2007UALA03601Door Frame · crackedFWD PIT DOORWAY AFT SIDE FRAME IS CRACKED AT LOWER DOOR STOP FITTING.SDR SWAA074457Crease Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 188 AND BS 196.5, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR 07FDEA03428Window Frame · corrodedFOUND CORROSION AT WINDSHIELD FRAMEWORK BETWEEN FRAME 7-10, LT/RT. REPAIR WAS PERFORMED BY BLEND OUT THE CORROSION IAW EA 6-5311-95933 AND RAS 042711/019/2006 ISSUE A.SDR 07FDEA03426Coupling · corrodedFOUND CORROSION ON COUPLING AT FRAME 26/32, STRG 44 LHS. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03424Frame · corrodedFOUND CORROSION ON SHEAR PLATE FRAME 68-69, STRG 47-48 LHS. REPAIR WAS PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03421Frame · damagedFOUND TWO OLD MISDRILLED HOLES IN SHEAT WEB FRAME 75A-76, STRG 26 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR UIEA200700345Door Frame · crackedM/D R4 MED FWD UPPER CORNER FRAME CRACKED AT STA 1670 S-16R TO S-17R AREA. CARRY OUT REPAIR AS PER SRM 52-10-02, FIG 10.SDR 200725405Plate · corrodedDURING MBV INSPECTION FOUND INTERSECTING PLATE BETWEEN RIGHT HAT BEAM AND FLOORBEAM 22 IS CORRODED. REMOVED AND REPLACED PLATE IAW EMB SRM 51-40-02. AIRCRAFT WAS RETURNED TO SERVICE.SDR LR7A07081Manifold · crackedDURING SCHEDULED C-8 CHECK PER JOB CARD HC5323 FOUND HEAT MANIFOLD CRACKED AT LT MLG WELL FS567 WL146. MANIFOLD REPLACED IAW SMP583 CHAPTER 51-60 AND 51-70.SDR LR7A07076Gusset · crackedDURING SCHEDULED C-8 CHECK PER JOB CARD HC5313, FOUND AFT FUSELAGE INTERIOR UPPER BHD TO RT SIDE BHD GUSSET PLATE CRACKED AT FS 990 WL280. GUSSET PLATE FABRICATED USING 7075T6 BY 0.160" AND REPLACED IAW SMP583 CHAPTER 51-60 AND 51-70.SDR LR7A07075Web · crackedDURING SCHEDULED C-8 CHECK FOUND PER JOB CARD HC5313, FOUND AFT FUSELAGE INTERIOR LT BHD WEB CRACKED AT FS 880 WL200 BL65L. REPAIR CARRIED OUT IAW SMP583 FIG 51-140-17.SDR LR7A07074Rib · crackedDURING SCHEDULED C-8 CHECK FOUND PER JOB CARD HC5313, FOUND RT FORMER INBD CAP BROKEN AT AFT FUSELAGE INTERIOR FS 792 WL160 RBL75. REPAIR CARRIED OUT IAW SMP583 FIG 53-50-14.SDR LR7A07073Rib · crackedDURING SCHEDULED C-8 CHECK PER JOB CARD HC5312, FOUND UNDERDECK INTERCOSTAL RIB CRACKED AT FS 204 AND 237 WL204 BL56L. REPAIR CARRIED OUT IAW SMP583 FIG 51-140-19.SDR SWAA074406Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 492, STR 17R. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA074404Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 747 AND BS 767, STR 17L. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR 07FDEA03375Beam · corrodedCORROSION ON BEAM NR 10, FRAME 67-69, STRG 45-47 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 07FDEA03363Door Frame · corrodedUPPER MAIN CARGO DOOR FOUND DEEP INTERGRANULAR CORROSION ON TOP OF LOWER DOOR JAMB, UNDER SPOOL FITTING NR 6. ACCOMPLISHED EA NR 8-5310-111456.SDR 07FDEA03358Door Frame · crackedCRACKED FRAME SEGMENT ON BEAM 8 OF AFT CREW DOOR RT. REPAIR PERFORMED BY REPLACEMENT OF FRAME SEGMENT IAW SRM 51-72-10.SDR 07FDEA03356Beam · corrodedFOUND CORROSION SPOTS ON AFT CARGO DOOR SILL BEAM BETWEEN FRAME 59A-60A AND FRAME 63-63A. REPAIR PERFORMED BY SMOOTH BLEND OUT, NDT INSPECTION FOR CRACK FREE AND FLAP PEENING IAW EA 6-5317-92211 AND RAS/DAHAM/4020122/2005 ISSUE A.SDR EIA2007156Tension Tie · damagedSTA 800 RT TENSION TIE HAS ONE DEFECTIVE FASTENER HOLE AFTER MAX ALLOWABLE REAM TO .309" PER SB 747-53-2502 VERIFIED WITH OPEN HOLE HFEC INSPECTION. REMOVED TENTION TIE (DAMAGED). FABRICATED TENSION TIE BEAM AND SPLICE PER B747 SRM 53-10-11 FIG 2 AND INSTALLSDR 07FDEA03324Beam · crackedAFTER HFEC INSPECTION FOUND 18MM LONG CRACKS IN GANTRY BEAM 3 LT AND RT AT FRAME 49 LOWER INBOARD FLANGE. CRACK REPAIR PERFORMED ON FRAME 49 GANTRY 3 LT AND 3 RT PER DRW R538-10426 WITH ENLARGED DIAPHRAGM WORK AREA WHILE MAINTAINING AN EDGE DISTANCE OF 1.5 RI
Back to JASC 5310