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 2001UALA00809Crease Beam · corrodedUPPER SURFACE OF LT CREASE BEAM WEB CORRODED AT BS 696, LBL 65. REPLACED CREASE BEAM WEB. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00805Door Frame · damagedCARGO DOOR LOWER CUTOUT VERTICAL WEB HAS EXCESSIVE MATERIAL LOSS AT BS 794 TO BS 847. REPLACED VERTICAL WEB. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00819Shear Tie · corrodedAFT PIT APPROX BS 1279 SHEAR TIE BETWEEN 33R AND 34R CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE PER BAC DRAWING 146T8561 AND SRM 51-40-2.SDR 2001UALA00762Beam · corrodedCREASE BEAM WEB CORRODED STA 1160-1180 LEFT SIDE. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR MWEA010820Shear Tie · damagedSHEAR TIE AT BS 945 LONGERON 10 TO 12 LEFT HAS ELONGATED HOLE. CUT OUT DAMAGED SECTION, FABRICATED NEW SECTION, DRILLED AND TRIMMED NEW SECTION, INSTALLED SHEAR TIE.SDR MWEA010816Shear Tie · crackedCRACK ON SHEAR TIE AT STATION 945 BETWEEN LONGERON 16 AND 15 LEFT. REMOVED SHEAR TIE, FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA010796Shear Tie · damagedSHEAR TIE AT STATION 945 LEFT SIDE FROM LONGERON 10-14 HAS MISDRILLED AND ELONGATED HOLES. REMOVED, FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA00764Crease Beam · corrodedCREASE BEAM WEB CORRODED STA 1160-1180 RIGHT SIDE. MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR 2001UALA00763Crease Beam · corrodedCREASE BEAM CORRODED STA 965 LEFT SIDE. MAJOR REPAIR ACCOMPLISHED. REPLACED CREASE BEAM WEB.SDR SWAA011865Web · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND CREASE BEAM WEB CRACKED 4 EA PLACES, BETWEEN BS 428 & BS 520. REPAIRED WEB PER SRM.SDR USAA010557Web · crackedCLT - FOUND WEB CRACKED 1 INCH, BS 712, LBL 24. INSTALLED REPAIR DOUBLER, REPLACEMENT WEB AND 4 VERTICAL STIFFENERS PER EA 69504. (M)SDR SWAA011474Window Post · crackedDURING SPECIAL VISIT CHECK, FOUND F/O'S C-D UPPER WINDOW POST CRACKED. REPAIRED POST PER SRM.SDR SWAA011485Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, RBL 70, WL 225.5. REPAIRED SHEAR TIE PER SRM.SDR USAA010710Bulkhead · crackedPIT - FOUND BULKHEAD CRACKED .125 INCH, STATION 178 BETWEEN LBL 5.7 AND 17. REPAIRED DOUBLER, FILLER PER SRM 53-10-08 PAGES 265-269. (M)SDR USAA010714Web · crackedPIT - FOUND WEB CRACKED .5 INCH, STATION 178 BULKHEAD LBL 5.7 WL 200, LOWER ANTENNA MOUNT. REPAIRED FILLER, DOUBLER AND SHIMS PER SRM 53-10-08 FIG 211. (M)SDR USAA010718Frame · crackedPIT - FOUND FRAME CRACKED 1 INCH, BS 787 BETWEEN 58L AND 59L. INSTALLED DOUBLER PER T/R 53-10-14. (M)SDR AUS20010510Panel · loose(AUS) NO1 MAIN FUEL TANK INTERNAL RIB ACCESS/BAFFLE PANEL LOOSE. THEPANEL WAS FOUND UNSECURED ON THE FLOOR WITH THE MOUNTING SCREWS CONTAINED IN A CANVAS SCREW BAG ATTACHED TO THE PANEL. THE AREA HAD RECENTLY BEEN ACCESSED DURING D4 INSPECTION.PERSONNEL/MAINTESDR 2001F00070Door Frame · crackedDURING ROUTINE INSPECTION FORWARD DOOR JAMB WAS FOUND CRACKS THE WIDTH OF THE DOOR JAMB IN LINE WITH THE HINGE SEAM. FURTHER DISASSEMBLY FOUND ADDITIONAL CRACKS ON THE FORMED STEP RISER, DIRECTLY BELOW THE DOOR JAMB BETWEEN THE JAMB AND THE DOOR SKIN.SDR 2001UALA00746Door Frame · crackedFWD GALLEY DOOR CUTOUT FWD FRAME CRACKED AT UPPER STOP FITTING. REMOVED DAMAGED AREA. ACCOMPLISHED REINFORCEMENT REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR CALA0100465Shear Tie · corrodedINSPECTION FOUND SHEAR CLEAT IN CENTER CARGO BILGE CORRODED AT STA 1801 BETWEEN LONGERON 49L AND 49R. THE SHEAR CLEAT WAS REMOVED AND A NEW SHEAR CLEAT WAS INSTALLED IAW SRM 51-30-01 AND GMM 10-900-01.SDR CALA0100464Shear Tie · corrodedINSPECTION FOUND SHEAR CLEAT CORRODED AT STA 1841 BETWEEN LONGERON 48R AND 47R. THE SHEAR CLEAT WAS REMOVED AND A NEW SHEAR CLEAT WAS INSTALLED IAW SRM 51-30-01 AND GMM 10-900-01.SDR CALA0100463Shear Tie · corrodedINSPECTION FOUND SHEAR CLEAT CORRODED AT STA 1902 BETWEEN LONGERONS 51R AND 50R AND BETWEEN LONGERONS 48L AND 47L. THE SHEAR CLEATS WERE REMOVED AND NEW SHEAR CLEATS WERE INSTALLED IAW SRM 51-30-01 AND GMM 10-900-01.SDR 2001UALA00728Casting · crackedFWD GALLEY DOOR FUSE FRAME CUTOUT, UPPER FWD CORNER CASTING IS CRACKED. REPLACED UPPER FWD SURROUND CASTING. MAJOR REPAIR ACCOMPLISHED.SDR DL72S010778Beam · crackedTHE RT TORQUE BOX FOR THE AFT VENTRAL STAIRWAY OPENING WAS FOUND WITH A TYPICAL CRACK IN THE UPPER HORIZONTAL BEAM AT FS 1263. THE CRACK IS TYPICAL OF BAC S/B 727-53-0129. THE CRACKED PART WAS REMOVED AND REPLACED WITH A NEW PART PER THE REQUIREMENTS OF THESDR MWEA010759Doubler · crackedFORWARD PAX DOOR JAMB INTERNAL TITANIUM DOUBLER IS CRACKED AT UPPER FORWARD CORNER. REMOVED DOUBLER, LOCATED, DRILLED AND INSTALLED DOUBLER.SDR MWEA010753Shear Tie · crackedCRACK IN RADIUS OF SHEAR TIE AT STATION 951 BETWEEN LONGERON 16 AND 15 RIGHT. REMOVED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR MWEA010752Shear Tie · crackedCRACK ON SHEAR TIE AT STATION 945 BETWEEN LONGERON 16 AND 15 RIGHT. REMOVED CRACKED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR MWEA010750Door Frame · crackedLEFT LAV AREA AFT PRESSURE BULKHEAD DOOR JAMB HAS A CRACK ON WEB ATTACHED TO TEE 4L INBOARD SIDE. STOP DRILLED CRACK, FABRICATED, LOCATED, DRILLED AND INSTALLED ANGLES.SDR PCAA0105041Pressure Panel · crackedBGM- DURING ROUTINE MAINTENANCE VISIT, 4 CRACKS WERE FOUND IN LEFT AND RIGHT NOSE LANDING GEAR WELL AREA AT STATIONS X96.19 AND X97.0. MAINTENANCE REPAIRED CRACKS IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWINGS RD 8-53-675, RD 8-53-5873, AND RD 8-53-5869. AIRSDR SWAA011445Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 1121, BETWEEN STR 2R AND 3R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR AWXA0001754Pressure Panel · crackedA .75 INCH LONG CRACK COMING OUT OF FASTENER HEAD AT NLG BEAM WEB ADJACENT TO NLG WARNING HORN BRACKET MOUNT BS 225. REPAIRED IAW AWA ER 03-5310-01119-SS2.SDR AWXA0001740Crease Beam · corrodedLT CREASE BEAM CORRODED STA 967-1006. REMOVED AND REPLACED IAW SRM 53-40-02.SDR AWXA0001730Shear Tie · corrodedFS 727E BETWEEN STR 28L & 238R CORROSION ON FRAME SHEAR TIE. REPAIRED IAW AWA ER 03-5300-01130-JS1.SDR AWXA0001729Shear Tie · corrodedFS 727D BETWEEN STR 27L AND 27R CORROSION ON FRAME SHEAR TIE. REPAIRED IAW AWA ER 03-5300-01131-JS1.SDR RRXA11157Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.560 AND L34L-L35L, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53SDR RRXA11156Fitting · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO BATHTUB FITTING AT STA.520-560 AND L35L, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-SDR AT0100195Door Frame · damagedINSTALLED PERMANENT REPAIR AT AFT CARGO DOOR JAMB UPPER CORNER. FABRICATED REPAIR DOUBLERS AND INSTALLED IAW REO-L00444.SDR AALA20011070Door Frame · crackedTUL - FOUND DOOR JAMB WEB CRACKED STATION 208 LONGERON 15L. INSTALLED DOUBLER PER AARD 53-10-00-11. (M)SDR 2001UALA00852Shear Tie · corrodedBS 456 STR 39L-38L SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2102-307.SDR 2001UALA00851Shear Tie · corrodedBS 1153 STR 37R-38R SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2103-446 AND SRM51-40-02.SDR 2001UALA00850Shear Tie · corrodedBS 434 STR 35R-34R SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA00848Shear Tie · corrodedBS 347 STR 38R-39R SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 141T1221 AND SRM 51-40-02.SDR 2001UALA00843Shear Tie · corrodedBS 610 STR 39L-39R SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DRAWING 140T2102 AND SRM 51-40-02SDR 2001UALA00841Shear Tie · corrodedBS 325 RBL 4 SHEAR TIE CORRODED.SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED SHEARTIE IN ACCORDANCE WITH SRM 51-40-02.SDR 2001UALA00839Shear Tie · corrodedBS 368 STR 38R TO 37R SHEAR TIE CORRODED.SDR UPS01435906Door Frame · crackedVINSPECTION TYPE:C-2 M/D - LT BS 1265 FRAME NR 2 DOOR STOP FTG AREA FOUND TWO FASTENER HOLES CRACKED. ONE CRACK AT FRAME INNER CHORD. ANOTHER CRACK AT FRAME WEB. CHORD AND WEB REPLACED IAW UPS EO B747-5310-12070-F APPENDIX E.SDR DL757010765Door Frame · corrodedTHE C1 DOOR OPENING LOWER SILL WAS FOUND BADLY CORRODED AND REQUIRES REPLACEMENT BETWEEN STRINGERS 25R & 26R. THE LOWER SECTIONS WERE TEMPORARILY REMOVED TO ALLOW INSTALLATION OF A NEW SILL CHORD. THE CHORD WAS SPLICED BACK WITH TWO ALUMINUM ANGLES ANDSDR RRXA11155Longeron · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FWD CARGO PIT L28L AT STA.510-560, DAMAGE EXCEEDED LIMITATION IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-2 FISDR AALA20011075Door Frame · gougedTUL - FOUND FORWARD SERVICE DOOR JAMB FRAME GOUGED LOWER AFT CORNER. REMOVED AND REPLACED FORWARD SERVICE DOOR JAMB ASSEMBLY 4002982 PER SRM 51-01. (M)SDR CALA0100454Crease Beam · crackedINSPECTION FOUND A 1 INCH CRACK IN LT CREASE BEAM AT STA 360 - 390. THE CREASE BEAM WAS REMOVED AND REPLACED IAW SRM 51-40-00.
Back to JASC 5310