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 USAA2012040900003Door Frame · crackedBC7 CHECK - 12 CRACKS IN AFT FRAME SEGMENT ON LEFT AFT EMERGENCY EXIT DOOR 834. REPLACED FRAME SEGMENT ON LEFT AFT EMERGENCY EXIT DOOR 834 IAW EO 5210Y228.SDR USAA2012040900002Door Frame · crackedBC7 CHECK - 12 CRACKS IN AFT FRAME SEGMENT ON RIGHT AFT EMERGENCY EXIT DOOR 844. REPLACED FRAME SEGMENT ON RIGHT AFT EMERGENCY EXIT DOOR 844 IAW EO 5210Y228.SDR USAA2012040900005Door Frame · crackedBC7 CHECK - 11 CRACKS IN FORWARD FRAME SEGMENT ON RIGHT AFT EMERGENCY EXIT DOOR 844. REPLACED FRAME SEGMENT ON RIGHT AFT EMERGENCY EXIT DOOR 844 IAW EO 5210Y228.SDR USAA2012040400005Door Frame · crackedBC7 CHECK - 1 CRACK IN FORWARD FRAME SEGMENT ON LEFT AFT EMERGENCY EXIT DOOR 834. REPLACED FRAME SEGMENT ON LEFT AFT EMERGENCY EXIT DOOR 834 IAW EO 5210Y228.SDR AALA20120404023Door Frame · corrodedAFT CARGO FORWARD DOOR FRAME AT BS 1380 WAS CORRODED. INSTALLED DOUBLER PER 53-00-07 2R2.SDR AALA20120404010Door Frame · damagedTHE E & E DOOR CUTOUT LEFT LATCH RECEPTICAL HAS HOLE PUNCHED THROUGH METAL WEB. REMOVED AND REPLACED THE WEB PER AARD 51010-05-R1.SDR AALA20120404007Frame · crackedFORWARD GALLEY DOOR SURROUND STRUCTURE, LOWER FORWARD STUB FRAME CRACKED. INSTALLED REPAIR ANGLE PER SRM 51-70-11-2R.SDR AALA20120404005Door Frame · corrodedCORROSION ON FORWARD SIDE OF AFT CARGO DOOR FRAME WEB. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-07-2R 2.SDR SWAA2012042703489Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 86.7. REMOVED & REPLACED WEB IAW BAC DWG, SRM, & AMM.SDR SWAA2012042603432Crease Beam · corrodedLT CABIN CREASE BEAM WEB CORRODED AT BS 370. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012042403352Crease Beam · corrodedLT CREASE BEAM CORRODED AT BS 867 TO BS 887. REPAIRED BEAM PER SRM AND BAC DRAWING.SDR USAA2012040400004Door Frame · crackedBC7 CHECK - 8 CRACKS IN AFT FRAME SEGMENT ON LEFT FORWARD EMERGENCY EXIT DOOR 833. REPLACED FRAME SEGMENT ON LEFT FORWARD EMERGENCY EXIT DOOR 833 IAW EO 5210Y228.SDR ASOA201201160Structure · corrodedFS 319 CORRODED BETWEEN LBL 26 AND RBL 26 FRONT SIDE. FOUND CORROSION ON FRAME TO BE OUT OF LIMITS. R & R FRAME IAW SRM 51-42-06-00 AND 51-42-21-00.SDR ASOA201201156Structure · corrodedFS 349 CORRODED BETWEEN LBL 26 AND RBL26 BOTH SIDES. CORROSION IS OUT OF LIMITS IAW SRM 53-00-00. R & R FRAME IAW SRM 51-42-06.SDR ASOA201201148Frame · corrodedFRAME 310 CORRODED BETWEEN LBL 26 AND RBL 26 BOTH SIDES. FRAME SECTION CORRODED BEYOND LIMITS IAW SRM 53-00-00. REMOVED FRAME IAW SRM 51-42-21 AND SRM 51-42-21. INSTALLED FRAME SECTION IAW SRM 51-42-06 AND 51-42-21.SDR 2012FA0000174Rib · corrodedDURING ANNUAL INSPECTION, HEADLINER WAS REMOVED FOR REPLACEMENT. FOUND CORROSION THAT WAS HIDDEN BY INSULATION MATERIAL. CORROSION WAS ON BOTH LT AND RT FUSELAGE ROOT RIB AND CORROSION ON RT DOOR OUTER JAMB (PN 1711030-4). CORROSION CONCENTRATED IN AREA WHESDR CHQA20120402120Door Frame · corrodedDURING INSPECTION, THE CARGO DOOR FORWARD FRAME 65 WAS FOUND TO BE CORRODED. THE CARGO DOOR FORWARD FRAME 65 WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-004743.SDR CHQA20120405117Door Frame · crackedDURING INSPECTION, FRAME 23 AFT OF THE SERVICE DOOR WAS FOUND TO BE CRACKED. FRAME 23 AFT OF THE SERVICE DOOR WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-004737.SDR FDEA201204021252Crease Beam · corrodedLEFT INBD CREASE BEAM CORRODED BS 1315-1320. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-10 FIG 101 SHEETS DETAIL 8. R & R CREASE BEAM IAW SRM 51-40-02 AND DWG 146N8326.SDR USAA2012040900016Beam · crackedC1 CHECK - 6 INCH LONG CRACK IN BEAM ASSEMBLY BETWEEN FR62 TO FR63, -Y1727. REPLACED BEAM ASSEMBLY IAW A330 SRM 51-42-11.SDR DALA1234850926Door Frame · corrodedAFT CARGO BAY LOWER DOOR FRAME AT APPROXIMATELY FS 1183 HAS 2 RIVNUTS WITH ELONGATED HOLES. REMOVED RIVNUTS AND REPAIR DOUBLER, FOUND THE CORROSION AT RIVNUT HOLES OUT OF LIMITS. FABRICATE NEW DOUBLER AND INSTALLED IAW SRM 53-05.SDR USAA2012041600003Door Frame · crackedDROP-IN - APPROX .375 INCH CRACK AT FORWARD CARGO DOOR OPENING AFT FRAME ASSEMBLY AT LOWER STOP FITTING AT BS 492.4, S24R. REPAIRED FORWARD CARGO DOOR OPENING AFT FRAME ASSEMBLY IAW EA 202177.SDR R61A201203310213Structure · corrodedDURING HEAVY CHECK, MAINTENANCE FOUND THE WASTE DUMP BOX CORRODED. MAINTENANCE REMOVED AND REPLACED DOUBLER AT THE WASTE DUMP BOX IAW EMB 175 51-40-02, 51-40-02, AND 51-43-02.SDR ABXR2012033100040Failsafe · corrodedFAILSAFE AREA CORRODED AT BS 955 S23-26L. REPAIRED IAW AMES REA 46938REA05.SDR SWIA201230342Beam · crackedC-CHECK, FS 280 BEAM CRACKED AT LBL 11.0 AND RBL 11.0. REPAIRED FS 280 BEAM CRACKED AT LBL 11.0 AND RBL 11.0.SDR SWAA2012040902855Crease Beam · crackedLT CREASE BEAM CHORD CRACKED AT BS 639. REPAIRED CHORD IAW EA.SDR FDEA201203291187Crease Beam · damagedLEFT CREASE BEAM INNER CHORD APPROX STA 1330 WITH FASTENER HOLE CORRODED AFTER REMOVAL. R & R IAW SRM 51-40-02, REV 105 AND DWG 146N8322, SHT 1, REV A. REPAIR IS CLASSIFIED AS MAJOR.SDR USAA2012033000013Frame · corrodedC1 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FRAME LOWER CHORD (BELLY FAIRING) AT FR40 BETWEEN -Y432 TO Y=0. REPAIRED FRAME LOWER CHORD (BELLY FAIRING) AT FR40 BETWEEN -Y432 TO Y=0. IAW A330 SRM 53-35-14 FIG 104 & 51-42-11.SDR FDEA201203271129Crease Beam · damagedLEFT CREASE BEAM WEB BETWEEN BS 1300 TO 1320 WITH FASTENER HOLES ELONGATED AT SOME PLACES AFTER REMOVAL. R & R IAW SRM 51-40-02 REV 105 AND DWG 146N8322 SHT 1, REV F. REPAIR IS CLASSIFIED AS MAJOR.SDR DALA1235020926Door Frame · corrodedE/E DOOR FRAME HAS CORROSION UNDER LIP AT APPROX LT OTBD SIDE UNDER DOOR FWD ATTACH POINT. REMOVED DAMAGE, FABRICATED REPAIR DOUBLER AND ANGLES AND INSTALLED PER ERA 503022-14 REV2, RECEIVED NEW PANEL, LOCATED AND INSTALLED PER SRM 51-10. FABRICATED NEW DOORSDR DALA1219126302Door Frame · crackedDURING HFEC OPEN HOLE INSP ON AFT CARGO DOOR CUTOUT UPPER AFT CORNER, HOLE NR 2 FOUND WITH CRACK INDICATION. AFT CARGO DOOR CUTOUT UPPER AFT CORNER WORK CARRIED OUT AS PER PRI 500187-14AD REV 1 DATED 02MAR12. AFT CARGO DOOR CUTOUT UPPER AFT CORNER PRI 50018SDR DALA1219116302Door Frame · crackedDURING HFEC OPEN HOLE INSP ON AFT CARGO DOOR CUTOUT UPPER FORWARD CORNER, HOLES NR 2 AND NR 4 FOUND WITH CRACK INDICATION. AFT CARGO DOOR CUTOUT UPPER FORWARD CORNER WORK CARRIED OUT AS PER PRI 500187-14D REV 0, 1, 2 AND 3 DATED 12 MAR12 TIME 1100HRS. COMPLISDR DALA1219106302Door Frame · crackedDURING HFEC SURFACE INSP ON AFT CARGO DOOR CUTOUT UPPER FORWARD CORNER CRACK FOUND PROPAGATE FROM HOLE NR 2 TO THE EDGE APPROXIMATELY 3/4" AS MARKED. AFT CARGO DOOR CUTOUT UPPER FORWARD CORNER WORK CARRIED OUT AS PER PRI 500187-14AD REV 0, 1, 2 AND 3. REFERSDR USAA2012040900015Spar · corrodedC2 CHECK - MULTIPLE AREAS OF CORROSION ON CENTER SECTION REAR SPAR WEB AT BS 955 BETWEEN LBL 78 TO LBL 97. REMOVED CORROSION, RESTORED AREA IAW EA 130840.SDR QXEA2012032600253Mount Bracket · corrodedFRETTING DAMAGE ON CENTER WING T/E MOUNTING BRACKET FOR PANEL 262HT. REMOVED FRETTING DAMAGE IAW RD 8/4-53-457 ISSUE 2. MATERIAL LOSS IS OUTSIDE OF LIMITS AFTER REWORK. FILLED BLENDED AREA WITH EPOXY TO BRING UP TO ACCEPTABLE LIMITS IAW RD 8/4-53-4411. ALODINSDR FDEA201203261102Splice Plate · corrodedAPU DOOR CUT OUT AREA, RT SIDE. NUTPLATES ALONG THE FWD EDGE ARE CORRODED JUST AFT OF BS 1787 BULKHEAD FRAME. CORRODED SPLICE PLATE R & R IAW SRM 51-40-02, REV 105 AND DWG 148N3105, SH 1REV C. REPAIR CLASSIFIED AS MAJOR.SDR USAA2012032900015Door Frame · crackedSHEAR SKIN /CDFI VISIT - 5/8 INCH CRACK AFT FRAME OF FORWARD CARGO DOOR CUTOUT ABOVE TOP INBOARD MOUNT HOLE OF BOTTOM STOP. REPAIRED AFT FRAME OF FORWARD CARGO DOOR CUTOUT IAW EA 202103.SDR SWAA2012032702595Door Frame · crackedR1 DOOR CUTOUT FRAME CRACKED AT BS 296.5, ABOVE CABIN FLOOR LEVEL ON I/B FLANGE. REPAIRED FRAME PER EA.SDR DALA1231169255Door Frame · corrodedCORROSION FOUND ON AFT CARGO DOOR JAMB BETWEEN 1211-1268. REPAIRED IAW SRM 53-60-02, 51-10-03, 51-10-04, AND 51-30-02.SDR FDEA201203211204Crease Beam · corrodedRT INBD CREASE BEAM CORRODED STA 1180-1290 REMOVED CORROSION ON CREASE BEAM IAW SRM 51-10-02. CHECKED LIMITS, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DETAIL VIII. FABRICATED NEW CREASE BEAM IAW SRM 51-40-05 AND SRM 53-60-13, DETAIL II. TREASDR DALA1217769263Door Frame · corrodedDURING HMV/MOD FOUND FWD PIT DOOR JAMB BEAM STA 370-427 IS CORRODED. CUTOUT DAMAGE SECTION OF LWR JAMB. LOCATED AND DRILLED NEW JAMB SECTION, REPAIR SPLICES AND INSTALLED IAW SRM 53-60-02 FIG 11.SDR FDEA201203211083Crease Beam · corrodedRT INBD CREASE BEAM ANGLE CORRODED AT BS 1630. REMOVED CORROSION IAW SRM 51-10-02. CHECKED LIMITS, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DETAIL VIII. FABRICATED, ALODINED, PRIMED IAW SRM 51-20-01 AND INSTALLED IAW SRM 51-40-02, AND DWG 146NSDR AALA20120320006Door Frame · corrodedCORROSION IN AFT CARGO DOOR JAMB LOWER ENTRY WEB. REPLACED WEB PER AARD 51-10-05 AND BOEING DWG 146A8123.SDR IPXA12672770Failsafe · crackedINSPECTION TYPE: 8C, FUSELAGE RT BS 955, REAR SPAR BULKHEAD FITTING AREA 1 EA FASTENER HOLE FOUND CRACK AT FAIL - SAFE STRAP ON 4 O/C AND 10 O/C POSITION THROUGH THICKNESS AND .0625" IN LENGTH. REPAIRED IAW EO B767-5350-17922-J APPX 'D', ORIGINAL MATERIAL IS SDR IPXA12672766Failsafe · crackedINSPECTION TYPE: 8C, FUSELAGE BS 955 REAR SPAR BULKHEAD FITTING AREA HAS ONE FASTENER HOLE CRACKED AT FAIL SAFE STRAP ON 3 O/C AND 9 O/C POSITION THROUGH THICKNESS AND .0625" IN LENGTH. REPAIRED IAW EO B767-5350-17922-J APPX 'C', ORIGINAL MATERIAL IS 2024T351SDR CHQA20120319102Door Frame · crackedDURING INSPECTION, FRAME 67 WAS FOUND TO BE CRACKED AT THE CARGO DOOR ENTRANCE. FRAME 67 AT THE CARGO DOOR ENTRANCE WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-003946B.SDR CHQA20120319101Door Frame · crackedDURING INSPECTION, FRAME 66 WAS FOUND TO BE CRACKED AT THE CARGO DOOR ENTRANCE. FRAME 66 AT THE CARGO DOOR ENTRANCE WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-003942.SDR ALGA201203230002Casting · crackedDURING A 300 HR INSPECTION, FOUND VIBRATION CASTING CRACKED RT SIDE UNDER FLOOR.SDR GLBA2012031901Doubler · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE RT DOUBLER, FWD END, FS 288, 1.2" IN LENGTH. REPAIRED IAW EO 12-1900-53-017.SDR SWAA2012032602582Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, LBL 60. REPAIRED WEB PER SRM AND DWG.
Back to JASC 5310