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 WRLA2007071Door Frame · corrodedDURING B-CHECK INSPECTION, RIGHT HAND OVERWING DOOR R-3, AFT LOWER CORNER (AT FLOOR LEVEL) STA 1305 EVIDENCE OF CORROSION UNDER DOOR SILL PLATE. [08-07-07] SILL PLATE SUPPORT CHANNEL FOUND CORRODED BEYOND LIMITS. REMOVED CHANNEL, FABRICATED NEW SUPPORT CHANSDR ZZDA070523165Door Frame · corrodedCORROSION AT FWD CARGO COMPARTMENT LOWER JAMB. INSTALLED NEW LOWER JAMB PAN BETWEEN STA 370-00 AND 427.00 PER B717 SRM 53-20-15 FIG 201.SDR ZZDA070523164Door Frame · corrodedCORROSION ON AFT CARGO COMPARTMENT LOWER JAMB AREA. CUT OUT DAMAGED SECTION OF LOWER JAMB AREA, AND INSTALLED NEW SECTION P/N J060228-9 WITH 2EA SPLICES, INSTALLED ON FWD AND AFT SECTION, MATERIAL USED .040 T075-0, HEAT TREATED TO T-6 AND INSTALLED IAW B 717 SDR 2007UALA01623Crease Beam · corrodedSTR 17R CREASE BEAM WEB AT BS 1022 HAS SURFACE CORROSION ON UPPER SURFACE. [SUP 06-01-07] MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. REMOVED WEB. FABRICATED & INSTALLED NEW WEB.SDR 2007UALA01619Door Frame · crackedFORWARD CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER DOOR STOP AT LOWER OUTBOARD CORNER AND IN RADIUS ABOVE LOWER DOOR STOP ON AFT SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKS & INSTALLED DOUBLER/FILLER REPAIR.SDR C2XA07SH030Door Frame · corrodedSHV - DURING C-CHECK CARGO DOOR CUTOUT LOWER FRAME HAS CORROSION. MX REMOVED AND REPLACED LOWER FRAME OF CARGO DOOR IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR 07FDEA01941Fitting · corrodedMAIN CARGO DOOR-LOWER JAMB FITTING NR 5 SHOWS CORROSION AT LOWER FORWARD HOLE. REPAIRED NR 5 LOWER JAMB AND REPLACED SUPPORT FITTING IAW FEDEX EA 8-5230-110663 REV A " FUSELAGE-MAIN CARGO DOOR-LOWER JAMB SUPPORT FITTING INSPECTION AND DOOR RIG".SDR 07FDEA01940Fitting · corrodedMAIN CARGO DOOR LOWER JAMB FITTING NR 2 SHOWS CORROSION AT LOWER FORWARD HOLE. REPAIRED LOWER JAMB AND REPLACED SUPPORT FITTING NR 2 IAW FEDEX EA. 8-5230-110663 REV A. " FUSELAGE- MAIN CARGO DOOR-LOWER JAMB SUPPORT FITTING INSPECTION AND DOOR RIG." LOWER SSDR 07FDEA01939Fitting · corrodedMAIN CARGO DOOR-LOWER JAMB FITTING NR 1 SHOWS CORROSION AT LOWER FORWARD HOLE. REPAIRED LOWER JAMB AND REPLACED SUPPORT FITTING NR 1 IAW FEDEX EA 8-5230-110663. "FUSELAGE- MAIN CARGO DOOR - LOWER JAMB FITTING INSPECTION AND DOOR RIG."SDR 07FDEA01938Fitting · corrodedMAIN CARGO DOOR-LOWER JAMB FITTING NR 3 SHOWS CORROSION AT AFT LOWER HOLE. REPAIRED NR 3 LOWER JAMB WEB IAW FEDEX EA 8-5230-110663 REV. A. " FUSELAGE, MAIN CARGO DOOR LOWER JAMB SUPPORT FITTING INSPECTION AND DOOR RIIG." FITTING(LOWER SUPPORT) REPLACED ON SDR 07FDEA01937Fitting · corrodedMAIN CARGO DOOR LOWER JAMB FITTING NR 3 SHOWS CORROSION AT FORWARD LOWER HOLE. REPAIRED NR 3 LOWER JAMB AND REPLACED SUPPORT FITTING IAW FEDEX EA 8-5230-110663 REV A "FUSELAGE-MAIN CARGO DOOR LOWER JAMB SUPPORT FITTING INSPECTION AND DOOR RIG."SDR TRAX200700712Beam · corrodedTRANSVERSE BEAM CORRODED AT FS 349 AND RBL 45.SDR SWAA072608Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD CARGO DOOR AFT FRAME LOWER STOP FITTING LOWER CHORD CRACKED. REMOVED AND REPLACED CHORD PER SRM.SDR USAA070394Door Frame · crackedBS 492.4 & S-24R HAS CRACK. INSTALLED DOUBLERS PER EA 98675, DEFECT SIZE: .75 INCH.SDR USAA070395Door Frame · crackedBS 440 & S-24R HAS CRACK. INSTALLED DOUBLERS PER EA 98676, DEFECT SIZE: 1 INCH.SDR SWAA072526Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CHORD CORRODED BETWEEN BS 312 AND BS 344, STR 17L. REPAIRED CHORD PER SRM.SDR SWIA200718441Buttstrap · corrodedCORROSION AT RIGHT BUTT STRAP BETWEEN FRAMES 38 AND 40, DISCOVERED AT C-CHECK. REPLACED RIGHT BUTT STRAP IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR SWIA200718440Buttstrap · corrodedCORROSION AT CENTER BUTT STRAP BETWEEN FRAMES 37 AND 38, DISCOVERED AT C-CHECK. REPLACED CENTER BUTT STRAP IAW EMB SRM 51-10-02 PG 3 SECT 3A.SDR 2007UALA01586Frame · damagedACFT HAS DENTS AT FRAMES 26 & 27 BETWEEN STR 37 AND 42 LT. THERE IS ALSO A SCRATCH APPROX .010 DEEP AT FRAME 28 APPROX 10 INCHES LONG BETWEEN STR 39 AND 42 LT.SDR 2007UALA01551Door Frame · crackedFWD CARGO DOOR CUTOUT, AFT FRAME CRACKED IN TWO PLACES AT INBOARD UPPER CORNER OF LOWER STOP FITTING. ONE CRACK IS ON AFT SIDE OF FRAME IN RADIUS AND THE OTHER ON FWD SIDE OF FRAME. MAJOR REPAIR ACCOMPLISHED: INSTALLED FILLER AND ANGLE REPAIR.SDR DHL2007785002Web · crackedWHILE IN "A" CHECK, CRACK ON AFT AIRSTAIR AREA TORQUE BOX WEB AT LIGHTENING HOLE BS 1303. STOP DRILLED CRACK IAW B727 SRM 51-10-1 PARA 10. FAB REPAIR DOUBLER FROM 7075T6 .040 PO NR 9004940 APPROX DIM 4" BY 2" IAW B727 SRM 51-40-2 FIG 1 AND 53-10-2 FIG 6. ISDR USA2007F00000Structure · corrodedCORRODED RIVET TAILS WERE FOUND IN FUSELAGE CARGO COMPARTMENT BETWEEN FRAME 35.1 TO 35.7, STRINGER 39L TO 39R. APPROXIMATELY 1,000 RIVETS WERE REPLACED. A RESIDUE OF SODIUM CHLORIDE ATTACKED THE RIVETS. NUMEROUS OTHER RIVETS HAD THE PAINT FLAKING OFF THE RISDR 07FDEA01845Seal Depressor · gougedFUSE LWR LOBE AFT CARGO DR FRAME INTERIOR SURFACE IS GOUGED AT LOWER AFT CORNER, BS 989, STR 26R. REMOVED AND INSTALLED NEW LOWER AFT CORNER, OF AFT CARGO PIT DOOR REF SRM 51-30-2 PG 1-12 (SEAL DEPRESSOR).SDR 07FDEA01836Frame · corrodedFUSELAGE LOWER LOBE NH NOSE TUNNEL TORQUE BOX INTERIOR HORIZ WEB IB CHORD IS CORRODED/EXFOILATION, BS 295-301, LBL 15, WL168 BLENDED AND REMOVED CORROSION .018 MATERIAL LOSS, WITHIN LIMITS, APPLIED ALODINE AND PRIMER REF SRM 51-10-1 AND SRM 51-10-2, SRM 53-10SDR CA070516001Tube · broken(CAN) WHILE PREFLIGHTING THE AC, THE PILOT NOTED WRINKLED FABRIC AT THE LOWER AFT END OF THE FUSELAGE. OPENING THE FABRIC REVEALED THAT THE VERTICAL TUBE THAT FORMS THE FIN SPAR AND IS THE ATTACH POINT FOR THE RUDDER HINGES AND TAILWHEEL SPRING AFT ATTACH WAS SDR UPS07849889Door Frame · crackedINSPECTION TYPE:C2 HFEC AND VISUAL INSPECTION DETECTED A .125 INCH CRACK ON THE C-2 DOOR LWR FWD DOOR JAMB CORNER. REPAIRED C-2 DOOR LWR FWD DOOR JAMB CORNER IAW SRM 53-02-00-0 FIG 22, AND SRM TR 53-187.SDR 2007UALA01514Door Frame · crackedFWD CARGO DOOR CUTOUT FWD FRAME IS CRACKED AT O/B LOWER CORNER OF LOWER STOP FITTING. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED EXTERNAL NESTED ANGLES AND FILLER REPAIR. REFERENCE MM 53-30-75.SDR F3LA200700109Shear Plate · corrodedDURING C-3 CHECK, INSPECTION REPORTED AFT RT SHEAR PLATE HAD SMALL AMOUNT OF CORROSION BETWEEN FR 69 AND FR 70. REPLACED AFT RT SHEAR PLATE IAW SRM 51-42-11 AND 51-72-11.SDR 07FDEA01811Crossbeam · corrodedCROSSBEAM C58 CORRODED REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA01804Window Frame · chafed1ST OFFICER SLIDING WINDOW ASSY FRAME HAS CHAFED AREA FWD END 2 PLACES COMPLIED WITH FEDEX EA6-5610-110455 PART 1.SDR 07FDEA01784Crossbeam · corrodedAFT CARGO COMPARTMENT RT SIDE FRAME 58 CROSSBEAM COMMON TO FLOOR PANELS 152CF, 152DF HAVE 2 EACH AREAS OF CORROSION TOTAL 10 SQUARE INCHES REWORKED CORROSION IAW A310 SRM 51-74-10 REMOVED AND REPLACED CROSS BEAM AND SPLICE IAW A310 SRM 51-40-21, 51-23-00, 51-7SDR 2007UALA01503Door Frame · crackedFWD CARGO DOOR CUTOUT FRAME, AFT FRAME IS CRACKED IN TWO PLACES AT LOWER BOTTOM STOP FITTING ONE CRACK IS IN RADIOUS ON AFT SIDE OF FRAME AND THE OTHER ON FWD SIDE OF FRAME, BOTH CRACKS ARE LOCATED AT I/B UPPER CORNER OF STOP FITTING VERIFIED BY HFEC. MAJOR RSDR 07FDEA01771Door Frame · crackedMAIN CABIN CRACK LONG .25" ON WEB. REPAIRED JAMB WEB IAW SRM 53-50-00 VOL 1 FIG 19 SHT 2.SDR A6WA200740246Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED. (K) [07-17-07] MAINTENANCE REMOVED DAMAGED SECTION OF DRAG ANGLE AND INSTALLED REPAIR PARTS IAW REO 601R-52-11-513 REV A. (M)SDR QXEA200700804Door Frame · chafedC4 PDX - FORWARD MAIN CABIN DOOR FRAME IS CHAFED BY A FLOOR PANEL AT STATION X1.0. REPAIRED IAW SRM 51-14-00 AND RD8/4-53-1912.SDR QXEA200700805Door Frame · chafedC4 PDX - AFT SERVICE DOOR FRAME IS CHAFED BY A FLOOR BOARD AT STATION X696. REPAIRED IAW RD8/4-53-1914.SDR AWXA200700616Door Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME CRACKED, BS 492.50 S24R AT THE LOWER STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME, BS 492.50 S24R AT THE LOWER STOP FITTING IAW AWA ER 03-5332-07122-ES1.SDR QXEA200700793Threshold · corrodedC4 PDX - MAIN CABIN DOOR THRESHOLD ENTRY FLOOR FLANGE IS CORRODED ON THE TOP AND BOTTOM SURFACES. REPAIRED IAW SRM 51-21-00, 51-40-07, AND RD8/4-53-1660.SDR 2007UALA01452Door Frame · crackedFWD CARGO PIT, FWD FRAME IS CRACKED AT LWR STOP FITTING. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, FABRICATED & INSTALLED EXTERNAL NESTED ANGLES.SDR 2007UALA01451Door Frame · crackedFWD CARGO PIT DOOR CUTOUT AFT FRAME IS CRACKED AT THE LOWER STOP FITTING. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED CRACKED FRAME.SDR AWXA200700615Door Frame · crackedMCN - CRACKED L1 DOOR FRAME AFT SIDE, BS 347, S13L - S14L, AT NR 5, 6, 7 FROM TOP STOP PIN CUTOUTS. REPAIRED L1 DOOR FRAME AFT SIDE, BS 347, S13L - S14L IAW AWA ER 03-5210-07128-SS3.SDR UPS07M50073Web · crackedINSPECTION TYPE:C COCKPIT, 1ST OBSERVER SEAT SUPPORT WEB FOUND CRACKED. COCKPIT 1ST OBS SEAT SUPPORT WEB CRACKED AREA TRIMMED OFF PER SRM 53-00-01 VOLI REV 39. HFEC INSP C/OUT ON TRIMMED OFF AREA, NO CRACK REINFORCED DOUBLER FAB PER SRM 53-00-01 VOLI FIG 6 RSDR 2007UALA01442Structure · damagedSTA 360.0 STR 2L IS DAMAGED. [SUP 06-01-07] MAJOR REPAIR ACCOMPLISHED DUE TO LIGHTNING STRIKE DAMAGE ON UPPER FUSE STA 360 STR 2L. REPAIR ACCOMPLISHED AND INSPECTED. A/C OK FOR RETURN TO SERVICE.SDR 2007UALA01441Structure · damagedSTA 285.5 STR 2L IS DAMAGED. [SUP 06-01-07] MAJOR REPAIR ACCOMPLISHED DUE TO LIGHTNING STRIKE DAMAGE ON UPPER FUSE STA 285.5 STR 2L. REPAIR ACCOMPLISHED AND INSPECTED. A/C OK FOR RETURN TO SERVICE.SDR 2007UALA01440Structure · damagedSTA 256 LBL 10 IS DAMAGED. [SUP 06-01-07] MAJOR REPAIR ACCOMPLISHED DUE TO LIGHTNING STRIKE DAMAGE ON UPPER FUSE BS 256 LBL 10. REPAIR ACCOMPLISHED AND INSPECTED. A/C OK FOR RETURN TO SERVICE.SDR 2007UALA01417Door Frame · puncturedAFT PIT DOOR CUTOUT FRAME AFT SIDE JUST UNDER THE APU BATTERY DOOR FRAME WEB PUNCTURED. MAJOR REPAIR ACCOMPLISHED: CUTOUT FRAME WEB DAMAGE. FABRICATED & INSTALLED DOUBLER, SHIMS & FILLER REPAIR.SDR SWIA200718446Frame · corrodedFRAME 23 BETWEEN STRINGERS 20L AND 20R IS CORRODING OUTBOARD OF STRINGER 21L, DISCOVERED AT C-CHECK. COMPLIED WITH REPAIR OF FUSELAGE SKIN AT FRAME 23 BETWEEN STRINGERS 20L AND 20R PER EMBRAER APPROVED REPAIR #1C2007-120/03354.SDR SIMA200714029Drag Angle · crackedLEFT LOWER FORWARD FUSELAGE DRAG ANGLE AT RIGHT SPAR 67.5 DATUM HAD A 0.6 INCH CRACKED. PERFORMED REPAIR IAW AMERICAN EAGLE ENGINEERING ORDER CR-55MR-026. AIRCRAFT RETURNED TO SERVICE.SDR SWAA072269Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 390, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA072270Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 415 AND BS 430, RBL 65. REMOVED AND REPLACED WEB PER SRM.
Back to JASC 5310