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 GAIA00758Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00757Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B7S7 SRM 53-10-4. (M)SDR GAIA00756Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00755Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00749Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00748Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00747Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW SRM 53-10-4. (M)SDR GAIA00746Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00744Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00743Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWER FORWARD CARGO COMPARTMENT. REPLACED SHEAR TIE IAW B727 SRM 53-10-4. (M)SDR GAIA00742Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE CORRODED IN LOWR FORWARD CARGO COMPARTMENT RIGHT SIDE. REPLACED SHEAR TIE IAW B727 SRM 53-10-4, 51-10-1. (M)SDR QXEA0003241Beam · corrodedPDX- CORROSION ON BEAM CAP AT BL600LH FROM STATION 4075 TO STATION 4700. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9.SDR QXEA0003239Beam · corrodedPDX- BEAM CAP HAS CORROSION AROUND TWO FASTENER RECEPTICALS AT STATION 4500 AND BL600RH. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9.SDR QXEA0003237Beam · corrodedPDX- BEAM CAP HAS CORROSION AROUND TWO FASTENER RECEPTICALS AT STATION 4050 AND BL600RH. R EPAIRED IAW FOKKER SRM 51-10-4 PAGE 9.SDR QXEA0003310Structure · dentedPDX- THERE IS A SHARP DENT LEFT HAND AIR CYCLE MACHINE BAY SIDEWALL APPROXIMETLY MID SPAR FROM MOUNTS FOR AIR CYCLE MACHINE. REPAIRED IAW FOKKER SRM 51-31-05, 53-01-01 AND HORIZON AIR EA 4-53-1406.SDR QXEA0003311Beam · crackedPDX- CRACK DAMAGE TO FLANGE OF BEAM 1. REPAIRED IAW FOKKER SRM 51-31-01, 53-02-18 AND HORIZON AIR EA 4-53-1276A.SDR QXEA0003235Beam · corrodedPDX- CORROSION AROUND TWO NUT PLATES IN SMALL BEAM AT BL120RH AND STATIONS 3600 AND 3750. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9, AND 53-01-01 PAGE 6.SDR QXEA0003233Beam · corrodedPDX- CORROSION AROUND NUT PLATE ON UPPER BEAM FLANGE AT STATION 3820 AND BL1127RH. REPAIRED IAW FOKKER SRM 51-10-4 AND 53-01-01.SDR QXEA0003194Door Frame · gougedPDX- CARGO DOOR APERTURE DENTED AND HAS A 2 INCH SHARP CREASE/GOUGE LOCATED ON FORWARD SIDE, 9 INCHES UP FROM FORWARD BOTTOM CORNER. REPAIRED IAW FOKKER SRM 51-31-01 AND 51-31-05.SDR QXEA0003309Structure · gougedPDX- THERE ARE TWO GOUGES ON LEFT HAND AIR CYCLE MACHINE BAY SIDE WALL CLOSER TO FORWARD AIR CYCLE MACHINE MOUNTS. REPAIRED IAW FOKKER SRM 51-31-01 AND 53-02-01.SDR QXEA0003308Structure · dentedPDX- THERE IS ONE DENT DIRECTLY BELOW TOP AIR CYCLE MACHINE MOUNT. REPAIRED IAW FOKKER SRM 51-31-01 AND 53-01-01.SDR EISA20000221Door Frame · crackedCRACK FOUND ON NR 1 CARGO DOOR CUTOUT FRAME WEB AT BS 620R ADJACENT TO NR 6 DOOR STOP. CORRECTIVE ACTION: FABRICATED, ALODINED, PRIMED AND INSTALLED DOUBLER, FILLER, AND PLATE AT BS 620R NR 1 CARGO DOOR, IAW SRM 51-40-2, 51-10-2, 51-30-2, AND 51-20-4, AND SSDR QXEA0003203Structure · crackedPDX- CRACK IN LEFT HAND AFT EMERGENCY EXIT LOWER TORSION BOX AT STATION 12931. REPAIRED IAW HORIZON AIR EA 4-53-1399, FOKKER SRM 51-31-02, 51-31-02 AND 51-31-05.SDR AWXA0000915Frame · gougedWINDOW CUTOUT ON LEFT SIDE OF STA 777 IS GOUGED IN LOWER FWD CORNER. BLENDED GOUGE (MAT LOSS .002 WITHIN LIMITS) IAW SRM 56-20-02. FLAP PEENED AND TREATED AREA IAW 56-20-02, 51-20-06.SDR AWXA0000923Door Frame · crackedFWD CABIN FWD SVC DOOR FRAME CRACKED FS 294 STR 17R. CUT OUT DAMAGED AREA IAW SRM 51-70-11; NDT CHECK FOR CRACKS HFEC IAW B737 NDTM PT.6 51-00-00 FIG 23. NO CRACKS NOTED. FABBED REPAIR ANGLE AND FILLER IAW 51-20-01. TREAT AND PRIMED IAW 51-20-01. INSTALLESDR DL73K002260Door Frame · corrodedTHE FORWARD FRAME OF THE C2 DOOR OPENING WAS FOUND CORRODED ON THE AFT SURFACE UNDERNEATH THE DOOR LATCH FITTING. THE CORROSION WAS CUT OUT AND REPAIRED PER ERA 396463-14AD AT HMV.SDR 20001120SH016Door Frame · crackedFORWARD CARGO DOOR CUT-OUT CRACKED, 0.50 INCH, LOWER AFT CORNER BETWEEN S25R AND S26R, BS 620.00. SERVICE ORDER NR 109003 OPS NR 21137. TIMCO RED NR S00328. FOUND DURING C-CHECK. TIMCO OSCODA NR T50R383Y. (X)SDR 20001120SH012Angle · corrodedFOUND DURING C-CHECK, NOSE LANDING GEAR PRESSURE DECK CHORD ANGLE CORRODED, STA 342 RBL 13, VERTICAL LEG WL 180. REF: TIMCO OSCODA NR T50R383Y. SERVICE ORDER NR 109003. OPS NR 20645, RED-S00324. TIMCO OSCODA NR T50R383Y. (X)SDR CALA0001804Frame · crackedINSPECTION FOUND A 3 INCH CRACK IN FRAME FOR LEFT VENTRAL STAIRS SIDEWALL PANEL. THE SIDEWALL SUPPORT WAS REMOVED AND THE CRACK WAS STOP DRILLED IAW SRM 51-30-1, 51-30-2, AND 53-01. REPAIR ANGLES WERE INSTALLED IAW SRM 51-30-2. INSTALLED SIDEWALL SUPPORT IASDR USAA001967Fastener · crackedFASTENER CRACKED. CORRECTIVE ACTION:DEFECTIVE PART REPLACED WITH IDENT PART.SDR CALA0001799Doubler · corrodedINSPECTION FOUND NR 1 RAD ALT ANTENNA DOUBLER CORRODED. THE ANTENNA DOUBLER WAS REMOVED AND REPLACED IAW SRM 51-30-02 AND 51-30-05.SDR AWXA0000886Door Frame · crackedFWD CABIN, FWD SERVICE DOOR FS 294 STR 17R DOOR FRAME CRACKED. CUTOUT DAMAGED AREA, PERFORMED HFEC IN AREA AND FOUND CRACK TERMINATED. FABED FILLER AND REPAIR ANGLE, TREATED, PRIMED AND INSTALLED PARTS IAW SRM 51-20-01, 51-70-11, 51-40-02 & B737 NDTM PT 6, 5SDR ASAA0010170Sill · crackedYXD - DURING HEAVY MODIFICATION, FOUND LOWER CARGO DOOR SILL CRACKED. REPAIRED PER EA 5310-01882. (M)SDR DL72S002237Door Frame · crackedA .625 INCH CRACK AT L-2 DOOR CUTOUT FWD FRAME AT UPPER STOP PAD. REPAIRED PER MM 53-13-0 PG 808.SDR MWEA001162Shear Tie · crackedSHEAR TIE CRACKED AT STATION 1019 BELOW LONGERON 14 LEFT. FABRICATED AND INSTALLED NEW SHEAR TIE SPLICE.SDR CALA0001779Door Frame · corrodedINSPECTION FOUND FORWARD CARGO DOOR JAMB CORRODED AROUND RIVET NUTS. THE DOOR JAMB WAS REMOVED AND A NEW DOOR JAMB WAS INSTALLED IAW SRM 51-30-2 AND 53-05, FIGURE 4.SDR DL72W002242Door Frame · corrodedTHE INNER CHORD OF THE C2 DOOR CUTOUT AFT FRAME WAS FOUND WITH CORROSION BETWEEN STRINGERS 26R AND 27R. THE CORROSION WAS REMOVED BY TRIMMING OUT A 2 INCH SECTION OF THE CHORD ANGLE. THE CUTOUT IS LOCATED 6 INCHES INBOARD OF THE NR 6 DOOR STOP AND WAS REPAIRSDR P2EA00459Angle · corrodedDURING Q CHECK, FOUND APU TORQUE BOX RT SIDE ANGLE FROM BS 1118 TO 1138 WITH CORROSION, OUT OF LIMITS L/12.00 W/1.250 D/0.50. REPLACED THE APU TORQUE BOX RT SIDE ANGLE.SDR SWAA002334Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 663 BELT FRAME SHEAR TIE CRACKED AT STR 10L. REPAIRED FRAME PER SRM.SDR SWAA002332Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 1156 O/B CHORD CRACKED AT LBL 24, WL 260. REMOVED AND REPLACED CHORD DOUBLER PER DWG 69-77737.SDR L1GA200000528Shear Tie · crackedCRACKED SHEAR TIE STATION 946 BETWEEN LONGERON 15 AND 16 RT. FABBED NEW SHEAR TIE AND INSTALLED.SDR L1GA200000519Shear Tie · gougedA 1 BY .024 INCH GOUGE FS 579 BETWEEN LONG 27 AND 28 RT FWD CARGO FORMER. DOUBLER REPAIR.SDR L1GA200000517Door Frame · crackedTWO CRACKS AFT ENTRY DOOR JAMB UPPER LT CORNER. SPLICED IN NEW SECTION.SDR L1GA200000511Shear Tie · crackedCRACKED SHEAR TIE (FORMER) FS 427 LONG 3 RT. FABBED AND REPLACED FORMER.SDR L1GA200000471Structure · misrepairedINPROPER REPAIR FS 294 BETWEEN LONGERON 25 AND 25 LEFT. INSTALLED SRM REPAIR.SDR L1GA200000435Beam · gougedFS 200 LBL 22 BEAM GOUGED. EXTRUSION REPAIR.SDR SWAA002315Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR FRAME CRACKED AT STOP FITTING ABOVE AND BELOW DOOR CENTERLINE. REPAIRED DOOR PER TI-152-003.SDR P2EA00436Door Frame · crackedDURING Q CHECK, FOUND L1 DOOR LOWER FORWARD CORNER OF FRAME, CRACKED. L/0.250W/0.005. REPLACED THE L1 DOOR LOWER FORWARD CORNER OF FRAME.SDR P2EA00363Door Frame · crackedSJO - DURING Q-CHECK, FOUND THE L-1 DOOR LOWER FORWARD CORNER OF FRAME CRACKED. (M)SDR AALA20001874Stringer · corrodedTUL - FOUND STATION 682-688 OUTBOARD SIDE STRINGER 26R SKIN CAP CORROSION. INSTALLED FUSELAGE SKIN DOUBLER PER SRM 53-30-3. (M)
Back to JASC 5310