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 MALA010660Seat Track · corrodedDuring 4K-check in CWA, LH Center Aisle Seat Track LBL18.3 has corrosion that is out of limits from approximatelyu Sta 680 to 649 IAW Saab SR 53-70-60. Maintenance replaced Seat Track Section in Aft end of Left Center Aisle IAW S53060. Seat Track PN 7253799-SDR SWAA012376Web · crackedDURING SCHEDULED 1/4D CHECK AT DALFORT, FOUND VERTICAL BEAM WEBS CRACKED ( 3 EA ) AT BS 178, LBL 17.1, WL 227, WL 232, WL 233. REPAIRED WEBS PER SRM.SDR SWAA012347Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND ( 2 EA ) VERTICAL WEBS CRACKED AT BS 180, RBL 17.1, WL 227 AND BS 184, RBL 17.1, WL 232. R&R VERTICAL WEBS PER SRM.SDR QXEA0101368Threshold · corrodedPDX-MAIN CABIN DOOR THRESHOLD HAS CORROSION BETWEEN NUTPLATES AND STRUCTURE. REPAIRED IAW DHC-8 SRM 51-00-06, SRM 51-20-11 AND SRM 53-00-16.SDR QXEA0101367Threshold · corrodedPDX-MAIN CABIN DOOR THRESHOLD HAS CORROSION AROUND NUTPLATES.REPAIRED IAW DHC-8 SRM 51-40-11.SDR SWAA012363Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 7 EA ) AT BS 727A, STR'S 7R & 7L, BS 727B, STR'S 7R, 7L, 6R, 6L, BS 887, STR 4L. R&R STR CLIPS PER SRM.SDR TSAA0152111Door Frame · crackedDURING HEAVY CHECK INSPECTION FOUND A CRACK ON THE AFT LOWER CARGO DOORWAY FRAME. THE CRACK EXTENDS FROM A FASTENER HOLE DOWN INTO A FRAME FLANGE. THE REPAIR INVOLVED TRIMMING OUT THE DAMAGE, PERFORMING A HFEC INSPECTION TO ENSURE THE CRACK AND ANY CORROSIONSDR SWAA012408Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 3 EA ) AT BS 420, STR 10L, BS 747, STR 16L, BS 520, STR 19L. R&R STR CLIPS PER SRM.SDR SWAA012324Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND ( 2 EA ) WEB CRACKS AT BS 178, LBL 5.1, WL 201 & WL 199. REPAIRED WEB PER SRM.SDR SWAA012314Stiffener · crackedDURING SCHEDULED 1/4D CHECK, FOUND VERTICAL STIFFENER CRACKED AT MLG W/W, BS 663 & LBL 6.15. REPAIRED STIFFENER PER SWA RA.SDR MWEA011129Shear Tie · crackedSHEAR TIE AT STATION 945 LEFT SIDE BETWEEN LONGERON 16 AND 14 CRACKED IN RADIUS 2 PLACES. -- FABRICATED AND INSTALLED SHEAR TIE.SDR MWEA011128Frame · misdrilledTWO MISDRILLED HOLES AT STATION 945 LONGERON 14 LEFT ON FRAME. -- FABRICATED AND INSTALLED REPAIR ANGLES.SDR MWEA011127Stop · crackedREMOVE FORWARD CARGO JAMB, LOWER TWO CARGO DOOR STOPS TO FOM. -- MAINTENANCE FOUND FORWARD STOP TO BE CRACKED. REMOVED AND REPLACED NEW STOP.SDR ABXA010512Fitting · crackedLEFT WHEEL WELL LONGERON 24, FUSALAGE STATION 960, SUPPORT FITTING WAS CRACKED AND CORRODED AT UPPER FORWARD AND AFT HORIZONTAL FLANGES. MAINTENANCE REPLACED THE FITTING AT STATION 960 IAW REA D853-41938MR.SDR 01FDEA00720Shear Tie · corrodedCORROSION ON FRAME SHEAR TIE BS 1130, WL 148, RBL 24. REMOVED AND REPLACED SHEAR TIE PER SRM 51-10-3, 51-20-1, 51-10-2.SDR SWAA012365Angle · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND MAIN FRAME 'Z' ANGLE CRACKED AT BS 380, STR 8R. REPAIRED 'Z' ANGLE PER SRM.SDR SWAA012344Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIP CRACKED AT BS 482, STR 19L. R&R CLIP PER SRM.SDR SWAA012339Stringer · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND STR CRACKED AT BS 907, STR 4R. REPAIRED STR PER SRM.SDR 01FDEA00726Shear Tie · corrodedCORROSION (C53-111-02, 2) FWD CARGO BAY BS 700, RBL 9, WL 148 SHEAR TIE FWD & AFT SIDE OF FRAME. REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4 FIG 15.SDR SWAA012288Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED .125 LONG ST BS 178, LBL 90 & WL 234. REPAIRED WEB PER SRM.SDR SWAA012287Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD BULKHEAD WEB CRACKED AT BS 1016, STR 2R. REPAIRED WEB PER SRM.SDR 2001UALA01709Shear Tie · damagedBS 297 STR 2L-3L NEED TO FAB SHEAR TIE TO ACCOMODATE TEAR STRAP. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE.SDR 2001UALA01707Shear Tie · damagedBS 301 STR 5L-6L NEED TO FAB SHEAR TIE TO ACCOMODATE TEAR STRAP REPAIR. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEARTIE.SDR 2001UALA01705Shear Tie · corrodedBS 500 STR 35L-36L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01704Shear Tie · corrodedBS 1351 STR 36L-37L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01701Shear Tie · corrodedBS 1417 STR 38L-39L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01700Shear Tie · corrodedBS 588 STR 37L-38L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01699Shear Tie · corrodedBS 1351 STR 38L-39L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01698Shear Tie · corrodedBS 1307 STR 38R-39R SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01697Shear Tie · corrodedBS 588 STR 36L-37L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 01FDEA00704Shear Tie · corrodedN 701 CORROSION ON FRAME BS 580, RBL 10, WL 148. ** S/D ** R&R SHEAR TIE PER SRM 53-10-4 FIG 14.SDR 01FEA00704Frame · corrodedN 701 CORROSION ON FRAME BS 580, RBL 10, WL 148. ** S/D ** COMINGSDR 2002F00848Fitting · crackedFOUND CRACK AROUND C2 DOOR FORWARD UPPER HINGE ATTACH POINT AT BS 1070 STRINGER 20R AND 19R. ACCOMPLISHED C2 DOOR FORWARD FRAME REPAIR AT BS 1070 STRINGER 20R AND 19R IAW B727 SRM 53-10-2, FIGURE 5. (M)SDR 0103889614Door Frame · crackedAT LCK VISIT A .125 INCH CRACK WAS DETECTED EMANATING FROM NR 6 AFT DOOR STOP IN FWD DIRECTION. A PREVIOUSLY EXISTING REPAIR DOUBLER WAS DISCOVERED STARTING FORWARD OF THE UPPER TANGENT POINT OF THE UPPER AFT CORNER OF THE L1 DOOR. THE DOUBLE EXTENDS AROUND SDR AALA20011643Door Frame · damagedTUL - FOUND DOUBLER IN FORWARD CARGO DOOR CUTOUT AT LOWER FORWARD CORNER NOT PER SRM. REMOVED OLD DOUBLER. INSTALLED DOUBLER PER ESO 80559 DATED 8-13-01. (M)SDR UPS01236689Stiffener · corrodedINSPECTION TYPE:C WING CENTRE SECTION UPPER SKIN STIFFENER LWR CHORD IS CORRODED AT BS 870 RBL0. ***CPCP*** DAMAGED SECTION REMOVED AND NEW SECTION SPLICED IAW SRMSDR UPS01236686Intercostal · crackedINSPECTION TYPE:C SUSPECT CRACK AT R/H BS 1183 WL 230 OUTBD LWR CORNER OF INTERCOSTAL AT RBL 62.5 INTERCOSTAL REPLACED IAW DWG 65-16350SDR 2001UALA01693Shear Tie · corrodedBS 434 STR 36L-37L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01692Shear Tie · corrodedBS 1241-1263 STR 37L-38L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01691Shear Tie · corrodedBS 1241-1263 STR 38L-39L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01690Shear Tie · corrodedBS 1417 STR 39R-39L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01688Shear Tie · corrodedBS 566 STR 38R-39R SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01687Shear Tie · corrodedBS 654-655 STR 39L-39R SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 2001UALA01686Shear Tie · corrodedBS 676-677 STR 39L SHEAR TIE CORRODED. *S/D* MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR 01FDEA00697Web · crackedN 795 R/H STUB BEAM FWD AND AFT WEB CRACKED BS 848, RBL 60, WL 202. ** S/D ** COMINGSDR 01FDEA00696Frame · corrodedN 669 UPR FLANGE OF BS 1130 FRAME HAS 2 EA OPEN HOLES WITH CORROSION UNDER L/H FLOOR TO SIDEWALL SUPPORT C53-111-01(3). ** S/D ** COMINGSDR 01FDEA00691Shear Tie · corrodedCORROSION (C53-113-01-1) ON SHEAR TIE BS 660 BETWEEN STR 25R & 26R. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 51-30-5.SDR QXEA0101349Structure · dentedPDX-TWO INCH DENT AT STATION 700.409 LEFT HAND SIDE, TAIL. FABRICATED AND INSTALLED DOUBLER REPAIR IAW THE DASH 8 STRUCTURAL REPAIR MANUAL 53-30-24, FIGURE 1, SHEET 2.SDR 01FDEA00687Shear Tie · corrodedCORROSION (C53-111-02, 2) FWD CARGO BAY BS 720D, RBL 16, WL 150 SHEAR TIE. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4 FIG 15.SDR 01FDEA00709Shear Tie · corrodedCORROSION FWD CARGO BAY BS 640, RBL 3, WL 147 SHEAR TIE. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4.
Back to JASC 5310