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 2001UALA01147Shear Tie · corrodedBS 434 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-317 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01145Shear Tie · corrodedBS 566 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T1202-331 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01144Shear Tie · corrodedBS 1439 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-539 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01141Shear Tie · corrodedBS 654 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-221 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR UO22001F00001Shock Mount · chafedA REPAIR WAS GENERATED TO CORRECT FOR A POSSIBLE METAL TO METAL CHAFING PROBLEM. AN INSPECTION REVEALED THAT THE UPPER AFT EDGE OF THE FORWARD FUEL TANK INTERFERES WITH THE FORWARD LOWER CORNERS OF THE FLAP DRIVE MOTOR SHOCK MOUNT SUPPORTS. PROBABLE CAUSE: SDR 01FDEA00486Shear Tie · crackedCRACKED FRAME SHEAR TIE BS 1263 BETWEEN STR 11R-12R. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-1, 51-30-2, 51-20-1, 51-10-2.SDR 01FDEA00485Shear Tie · crackedCRACKED SHEAR TIE BS 1263 BETWEEN STR 11R-12R. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-1, 51-30-2, 51-20-1, 51-10-2.SDR 01FDEA00484Shear Tie · crackedSHEAR TIE CRACKED AT FRAME BS 1263 BETWEEN STRINGER 11L - 12L. *S/D* REMOVED AND REPLACED PER SRM 51-10-1, 51-30-2, 51-20-1, 51-10-2 & EA 7-5310-57285.SDR 01FDEA00483Shear Tie · crackedFRAME SHEAR TIE CRACKED BS 1263 BETWEEN STR 11L - 12L. *S/D* REMOVED AND REPLACED SHEAR TIE PER SRM 53-10-4, 53-10-1.SDR RRXA11363Fitting · crackedDURING A MAINTENANCE VISIT FOUND C PIT FITTING FWD SIDE FRAME 1160 L35R IS CRACKED. *** CORRECTIVE ACTION *** REMOVED AND REPLACED PN 3758496-2N PER 51-1-20DSDR RRXA11362Fitting · crackedDURING A MAINTENANCE VISIT FOUND C PIT FITTING FWD SIDE OF FRAME 1172 L35L CRACKED AT TOP FLANGE. *** CORRECTIVE ACTION *** REMOVED AND REPLACED FITTING IAW DWG 3758570, AND DC8 SRM 53-1-0 AND 51-1-20 D.SDR AALA20011294Bulkhead · crackedTUL - FOUND CRACK IN WEB BELOW APU LOAD CONTROL VALVE, STATION 870 BULKHEAD 4 INCHES LONG. CRACK IN FS 870 BULKHEAD FORWARD SIDE AT APU CONTROL VALVE BOTTOM OUTBOARD SIDE OF CUTOUT. REPAIRED PER SRM 53-10-2 WITH DOUBLER. (M)SDR 2001UALA01120Shear Tie · corrodedBS 654-676 STR 39L-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-267 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01119Shear Tie · corrodedBS 355 STR 37R-38R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1221-68 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01118Shear Tie · damagedFABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-232 AND SRM 51-40-02. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102-232 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01117Shear Tie · corrodedBS 434 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01116Shear Tie · corrodedBS 566 STR 36L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01115Shear Tie · corrodedBS 412 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1224 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01114Structure · corrodedBS 676 STR 39R-37L CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01112Structure · corrodedBS 437 STR 37L CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SRM 53-30-03 AND 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01109Shear Tie · corrodedBS 368-390 STR 38R-39R SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 141T1222-18 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01108Shear Tie · corrodedBS 610 STR 37L-38L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T202 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01106Shear Tie · corrodedBS 676 STR 38L-39L SHEAR TIE CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 140T2102 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR UPS01236260Bulkhead · crackedINSPECTION TYPE:C RIGHT WHEEL WELL STA 870 BULKHEAD CRACK AT APU VALVE CUT OUT RBL4.5 STOP DRILL CRACK ON RH W/W STA 870 AT APU VALVE CUT OUT RBL45 STOP DRILL 1/4" SIVE AND NDT INSPECTION ACCOMPISHED HFEC AS PER PART6-51- 00-00 FIG4 INSTALL 3 DOUBLER REPASDR UPS01236258Web · crackedINSPECTION TYPE:C NOSE LANDING GEAR BAY RH SIDE WALL AT BS 266 HAS A CRACK INDICATION. REMOVED ACCESS PANEL #3125 AS PER SRMB727-51-30-2 CUT OUT DAMAGE AREA AS PER B727-51-40-2 APPROX 3.5"X1" ACCOMLPISHED NDT INSPECTION AND INSTALLED DOUBLER REPAIR AS PER SDR UPS01236256Web · crackedINSPECTION TYPE:C NOSE LANDING GEAR BAY LH SIDE AT BS 259 SIDE WALL HAS A CRACK INICATION. REMOVED ACCESS PANEL #3124 AND LOWER WEB TO GAIN ACCESS TO DAMAGE AREA, CUT OUT DAMAGE AREA APPROX 5"X1" AT NOSE LANDING GEAR BS259 AS PER B727 SRM51-40-2 ACCOMPLISHSDR AWXA0001886Web · corrodedD: Aft galley shear web corroded F$ 1715 at RBL 14 to LBL 51C Removed corrosion, fabricated and installed repair doublers at F5 1715 LBL 17-34 and RBL 14-23 Per SRM 53-60-51 fig 203 and SRM 51-40-02SDR UPS01236817Shear Tie · corrodedINSPECTION TYPE:C WHILE WORKING FUSELAGE, DISCOVERED SHEAR TIE CORRODED BS 970, RBL 8 OUTBOARD OF STR 29R. CORROSION FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-10-4.SDR RRXA11357Angle · crackedDURING A MAINTENANCE VISIT FOUND R/H CABIN CUSP FWD END CUSP ANGLE CRACKED. *** CORRECTIVE ACTION *** REPAIRED CUSPANGLE IAW DC8 SRM 53-2-0 FIG 1B, LOWER SIDE STA 825 LONG 21R.SDR UO22001F00002Shock Mount · chafedA REPAIR WAS GENERATED TO CORRECT FOR A POSSIBLE METAL TO METAL CHAFING PROBLEM. AN INSPECTION REVEALED THAT THE UPPER AFT EDGE OF THE FORWARD FUEL TANK INTERFERES WITH THE FORWARD LOWER CORNERS OF THE FLAP DRIVE MOTOR SHOCK MOUNT SUPPORTS HAT SECTIONS. PROBSDR 2001UALA01102Shear Tie · corrodedBS 544 STR 37L - 38L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-221 AND SRM 51-40-02.SDR 2001UALA01101Shear Tie · corrodedBS 610 STR 36L - 37L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102 AND SRM 51-40-02.SDR 2001UALA01100Shear Tie · corrodedBS 434 STR 33L - 34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-1917 AND SRM 51-40-02.SDR 2001UALA01099Shear Tie · corrodedBS 346 STR 33L - 34L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 141T1221-16 AND SRM 51-40-02.SDR 2001UALA01098Shear Tie · corrodedBS 588 STR 37R - 38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-221 AND SRM 51-40-02.SDR 2001UALA01095Shear Tie · corrodedBS 355 STR 39R - 38R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 141T1221-68 AND SRM 51-40-02.SDR 2001UALA01094Shear Tie · corrodedBS 698 STR 38L - 39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-259 AND SRM 51-40-02.SDR 2001UALA01093Shear Tie · corrodedBS 610 STR 38L - 39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-232 AND SRM 51-40-02.SDR 2001UALA01092Shear Tie · corrodedBS 544 STR 38L - 39L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC 140T2102-232 AND SRM 51-40-02.SDR 2001UALA01091Shear Tie · corrodedBS 346 STR 35L - 36L SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T1220-14 AND SRM 51-40-02.SDR 2001UALA01090Shear Tie · corrodedBS 742 STR 39L - 39R SHEAR TIE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102 - 1505 AND SRM 51-40-02.SDR 2001UALA01087Structure · corrodedBS 610 STR 39R - 39L CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-331 AND SRM 51-40-02.SDR 2001UALA01086Structure · corrodedBS 698 STR 38L - 39L CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102-257 AND SRM 51-40-02.SDR 2001UALA01085Structure · corrodedBS 544 STR 39L AND 39R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED IAW BAC DRAWING 140T2102 AND SRM 51-40-02.SDR 2001UALA01084Structure · corrodedBS 440 STR 38R CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW SRM 53-30-03.SDR 2001UALA01075Shear Tie · corrodedBS 434 STR 32L - 33L SHEAR TIE CORRODED. FABRICATED AND INSTALLED REPAIR IAW BAC DRAWING 140T2102 AND 140T1917 AND SRM 51-40-02.SDR SWAA011792Bear Strap · corrodedDURING SCHEDULED D CHECK, FOUND BEAR STRAP CORRODED AT BS 844, RBL 15 TO RBL 18, WL157. REPAIRED BEAR STRAP PER BFG ER.SDR SWAA011774Window Post · crackedDURING SCHEDULED RON CHECK, FOUND WINDOW POST CRACKED AT CAPT'S #1 WINDOW, UPPER LH CORNER. REPAIRED WINDOW POST PER SRM.SDR 01FDEA00474Web · crackedNR 272 CRACKED VERTICAL TORQUE BOX WEB BS 1225, LBL 20.5, WL 193. ** S/D ** R&R & FAB PER IAW FEDEX SRM 51-10-11, 51-40-2 FIG 1.SDR UPS01236153Shear Tie · corrodedINSPECTION TYPE:C, WHILE WORKING FUSELAGE DISCOVERED SHEAR TIE CORRODED BS 970, RBL 8 OUTBOARD OF STR 29R. CORROSION FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED SHEAR TIE, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-10-4.
Back to JASC 5310