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 C2XA09SH181Beam · corrodedSHV - DURING C-CK, CARGO DOOR LOWER CUTOUT HAS CORROSION. REMOVED AND REPLACED CARGO DOOR LOWER CUTOUT IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UALA2009062901832Window Frame · damagedFUSELAGE EXTERNAL, WINDOW FRAME STATIC DISCHARGE AT BS 654+80, BETWEEN STR 14L-15L. INSTALLED NEW WINDOW FRAME, P/N 140T2401-4.SDR 2009FA0000585Crease Beam · corrodedOUT OF LIMITS CORROSION L2 ENTRY CREASE BEAM INNER CHORD BS 967- 1006 LBL 60 WL 208.1.SDR SWAA094138Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR FWD CUTOUT. REMOVED AND REPLACED FRAME ASSY PER SRM & ACO.SDR FDEA200906252298Window Frame · corrodedFOUND CORRODED ATTACHMENT HOLES IN LT AND RT WINDSHIELD FRAMES. REPAIR PERFORMED BY OVERSIZING SOME HOLES, NDT FOR CRACK FREE CONDITION AND BUSHING INSTALLATION IAW RAS 70520006/039/2009 ISS.A, APPROVED BY EA 6-5310-131202SDR FDEA200906242278Web · crackedCRACK INDICATION FOUND ON SECOND LAYER WEB AT 2 O'CLOCK POSITION DURING HFEC OPEN HOLE INSP ON 0.520 INCH HOLES AT MAIN CARGO DOOR LWR JAMB NR 7 SUPPORT FITTING AT HOLE NR B. MAIN CARGO DOOR LOWER JAMB NO.7 SUPPORT FITTING AT HOLE NO. B SECOND LAYER WEB RSDR FDEA200906242277Web · crackedCRACK INDICATION FOUND ON FIRST LAYER WEB AT 5 O'CLOCK POSITION DURING HFEC OPEN HOLE INSP ON 0.520 INCH HOLES AT MAIN CARGO DOOR LWR JAMB NR 7 SUPPORT FITTING AT HOLE NR B. REAMED TO DIAMETER 0.540 INCH IAW SRM 51-31-01 VOLUME II, REVISION 40. REPAIR CARRIEDSDR FDEA200906242276Web · crackedCRACK INDICATION FOUND ON FIRST LAYER WEB AT 7 O'CLOCK POSITION DURING HFEC OPEN HOLE INSP AT MAIN CARGO DOOR LWR JAMB NR 7 SUPPORT FITTING AT HOLE C. REPAIR CARRIED OUT ON WEB AS PER E.A. 1-5310-132111, REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100, REVISIONSDR DU4R2009375Track · corrodedDURING SCHEDULED INSPECTION, FOUND LT FWD TRANSITION TRACK HAD CORROSION FROM FS 1007 TO FS 1212 (AROUND NUT PLATE HOLES, AND AT ATTACH POINTS).SDR FDEA200906232251Door Frame · corrodedAFT ACCY COMPARTMENT DOOR CUTOUT FWD FRAME CORRODED BETWEEN LBL 10 TO RBL 10, STA 1883. EVALUATE AND RECTIFY. AFT ACCY COMPARTMENT DOOR CUTOUT FWD FRAME BETWEEN LBL 10 TO RBL 10, CORRODED FRAME REMOVED IAW SRM 51-40-02 REV. 97. NEW CHORD PN 148N3615-4 INSDR EE4Y090174Stringer · damagedLOWER FUSELAGE E&E COMPARTMENT,BETWEEN BS 355 AND BS 365,STR 19R WITH DOUBLE HOLE.SDR SWAA094023Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED, BS 492. REMOVED AND REPLACED FRAME PER ACO.SDR 2009FA0000540Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727D STRINGER 9R.SDR 2009FA0000538Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 360 STRINGER 9R.SDR FDEA200906202331Window Frame · corrodedCORROSION ON WINDOW FRAME RT FUSELAGE STA 650. REMOVED CORROSION FROM WINDOW FRAME AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS, FABRICATED REPAIR DOUBLER AND INSTALLED IAW SRM 51-10-6, 56-20-1, 56-20-3 AND 51-30-2.SDR EE4Y090160Beam · corrodedUPPER FUSELAGE CARGO CABIN FROM BS 540 TO BS 663, BL 0 TRANSVERSAL BEAM UPPER FLANGE CORRODED.SDR FDEA200906182155Crease Beam · corrodedAT STA 1370 LT CREASE BEAM CORRODED REMOVED CORROSION IAW SRM 51-10-06, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13 FIG 101 DETAIL 3, REMOVED INBD LT CREASE BEAM FROM STA 1370-1390 IAW SRM 51-40-02. FABRICATED REPAIR ANGLE AND BEAM IAW SRM 51-70-11 FIG. 1 AND SDR SWAA093956Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED AT R1 DOORWAY, BETWEEN BS 294.5 TO BS 332.5. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA093955Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 867, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR FDEA200906162513Track · misrepairedPREVIOUS REPAIR FOUND LOCATED AT ROLLER TRACK LT, ON FWD CARGO COMPT BTW FR38- 38.1 AT STA Y140. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. REPAIR WAS EVALUATED AND FOUND NOT TO CONFORSDR SWAA093929Door Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR CUTOUT FWD LOWER FRAME CRACKED. REMOVED AND REPLACED DOOR FRAME PER SRM.SDR WX0A070325Structure · corrodedCORROSION ON SUB FLOOR AT STATION 190 JUST INBOARD OF FORWARD ENTRY DOOR ADDRESSED AS REQUIREDSDR FDEA200906152117Crease Beam · misrepairedUNDOCUMENTED EXISTING REPAIR WAS FOUND ON CABIN RT CREASE BEAM FROM BS 780 TO BS 800, WL 208.10. FOUND NOT IAW STRUCTURAL REPAIR MANUAL. EA F-5300-128608, & EA F-5300-126218,SDR SWAA093865Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CRACKED AT BS 520, LBL 60. REPAIRED BEAM PER SRM.SDR SWAA093869Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND RIGHT I/B CREASE BEAM CORRODED FROM BS 954 TO BS 992, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR USAA2009072091889Door Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK AT AFT CARGO DOOR CUTOUT AFT FRAME AT BS 847, S19R. REPAIRED AFT CARGO DOOR CUTOUT AFT FRAME AT BS 847, S19R IAW US AIRWAYS EA 101231.SDR DU4R2009374Track · corrodedDURING SCHEDULED INSPECTION, FOUND RT FWD TRANSITION TRACK HAD CORROSION FROM FS 1079 TO FS 1155 (AROUND NUT PLATE HOLES, INSIDE TRACK AND STEP DOWN ANGLE ATTACHED TO AFT END OF TRACK).SDR IPXA09556502Door Frame · damagedINSPECTION TYPE:C2 MAIN CARGO DOOR BS 606 STUB FRAME HAS TOOLING DAMAGE 2.6 - 8.2 INCHES BELOW STR 15L I/B FLANGES. REMOVED DAMAGE & REPAIRED PER 09-3152 DATED 19JUNE09.SDR C2XA09SH173Beam · corrodedSHV. DURING C-CK. CARGO DOOR LOWER CUTOUT BEAM HAS CORROSION. REMOVED AND REPLACED CARGO DOOR LOWER CUTOUT BEAM IAW EMB 145 SRM 51-40-02. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA093838Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 960 TO BS 984, LBL 54. REMOVED AND REPLACED BEAM PER SRM.SDR ASAA0946085Door Frame · corrodedL2 DOOR CUTOUT FRAME STA 994 CORRODED I/B AND FWD SIDES JUST ABOVE FLOOR LEVEL LBL 47 LBL 49 WL 208.5 210.5. REMOVED DAMAGED AREA, FABBED DOUBLER AND FILLER AND INSTALLED REPAIR IAW B737 400 SRM 51 70 11.SDR SWAA093823Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT O/B LOWER CORNER OF LOWER DOOR STOP FITTING. REPAIRED FRAME PER AAR EA.SDR CALA2009061200306Door Frame · crackedB757-53-3-0357, FWD ACCY ACCESS DOOR FRAME FWD FRAME HAS DAMAGE ON FRAME FROM DOOR PIN APPROX STA 224. CUT OUT DAMAGED AREA AND REPAIRED DOOR FRAME WEB REF ECRA 5313- 01036. ACCOMPLISH A PERMANENT REPAIR WITHIN 12 MONTHS. PLANNING TO CONTACT ENGINEERING AFTSDR FDEA200906091988Window Frame · corrodedFOUND CORROSION ON RT SLIDING WINDOW FRAME AT STATIC DISCHARGERS REPAIR PERFORMED BY BLEND OUT THE CORROSION AND NDT FOR CORROSION FREE CONDITION IAW RAS 70521635/005/2009 ISS.A, APPROVED BY EA 6-5310-131221.SDR FDEA200906091987Beam · corrodedFOUND CORROSION ON LT LOWER EDGE BEAM C 88-90, P28LT REPAIR PERFORMED BY BLEND OUT THE CORROSION AND NDT FOR CORROSION FREE CONDITION IAW RAS/EFW/9000204/2009 ISS.A , APPROVED BY EA 6-5310-131209.SDR SWAA093743Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CRACKED AT BS 616, RBL 63.5. REPAIRED BEAM PER SRM.SDR SWAA093734Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REPAIRED WEB PER SRM.SDR MALA090083Door Frame · corrodedDURING N4K & 2Y CHECKS IN CWA, CORROSION NOTED ON DOOR FRAME AT STA 258. REPAIRED IAW S53108.SDR SIMA200916202Beam · corrodedDURING IMBV, THE GALLEY FLOOR CENTER BEAM WAS FOUND CORRODED. REMOVED DAMAGED BEAM. PREPPED, CLEANED, ALODINED, PRIMED AND INSTALLED NEW BEAM IAW EMB SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR A6WA200940371Structure · corrodedCORROSION FOUND BTW FS 412.0+128 TO FS 559.0, RBL 46.084. CORROSION BTW FS 412+128 TO 559.0, RBL 46.084 REMOVED IAW REO 601R-53-41-666. (K)SDR ZZDA2009194Door Frame · corrodedFWD CARGO DOOR JAMB SECTION CORRODED BEYOND LIMITS. CUT OUT LOWER PAN SECTION FROM FS 370 TO FS 427, INSTALLED NEW LOWER PAN SECTION AND SPLICES REPAIR PER REF SRM 53-20-15 REPAIR 6 FIG 201.SDR WX0A070322Frame · cracked1510 CANT FRAME CRACKED RIGHT OF SLIDE PACK.SDR SWAA093626Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 777, LBL 60. REMOVED AND REPLACED WEB PER SRM.SDR FDEA200906041923Doubler · corrodedFOUND CORROSION ON CORNER DOUBLER ON PAX DOOR FRAME SHELL C75A-76, P 26-27 LT. REPAIR PERFORMED BY REWORK ON THE CORROSION, NDT FOR CRACK FREE AND CORROSION FREE CONDITION IAW RAS/EFW/9000184/2009 ISS. A, APPROVED BY EA 6-5310-131204.SDR FDEA200906041920Beam · corrodedFOUND CORROSION IN LONGITUDINAL BEAM BETWEEN C 73A-75A, P 26RH REPAIR PERFORMED BY BLEND OUT THE CORROSION AND NDT FOR CRACK FREE CONDITION IAW. RAS/EFW/9000184/2009 ISS.A , APPROVED BY EA 6-5310-131205.SDR FDEA200906041919Failsafe · damagedFOUND TOOLING MARKS ON LT AFT PAX DOOR FAIL SAFE RING AT C 73A, P26 REPAIR PERFORMED BY REWORK TO SMOOTH CONTOUR, PERFORM NDT FOR CRACK FREE CONDITION IAW RAS/EFW/9000185/2009 ISS A, APPROVED BY EA 6-5310-129192.SDR FDEA200906041917Doubler · crackedFOUND CRACK IN REINFORCEMENT DOUBLER ON LOWER SIDE OF DIAPHRAGM BETWEEN GANTRY4-5 AT C 49. REPAIR PERFORMED BY CUT-OUT OF DIAPHRAGM REINFORCING AND INSTALLING A SPLICE WITH FILLER IAW RAS 70520358/012/2009 ISS.A , APPROVED BY EA 6-5310-129200.SDR FDEA200906041915Beam · corrodedFOUND DEEP CORROSION SPOT AT A HOLE IN AFT CARGO DOOR SILL BEAM C 62A-63 REPAIR PERFORMED BY REMOVAL OF CORROSION AND INSTALLING A BUSHING IN THE HOLE IAW RAS/EFW/9000205/23009 ISS.A , APPPROVED BY EA 6-5310-129177SDR SWAA093614Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED AT BS 790, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR CWQR200901ADoubler · crackedDURING REPLACEMENT OF PILOT'S WINDSHIELD AND SIDE WINDOW A .6 INCH CRACK WAS FOUND THROUGH A NR 40 RIVET HOLE, WHICH ATTACHES THE SIDE WINDOW RETAINER TO THE WINDSHIELD DOUBLER. THE CRACK AT THE NR 40 RIVET HOLE HAD PROPER EDGE DISTANCE AND NO APPARENT DAMAGE
Back to JASC 5310