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 TSAA20140722005Unknown · cracked1.5 INCH CRACK AT BS 767 STRINGER 19L. REPAIRED IAW ENGINEERING.SDR SWAA2014072330236Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED AT BS 318 LBL 58. REPAIRED CHORD IAW SRM.SDR DALA2014072204190Door Frame · crackedCRACKED OVERWING FRAME, BS 886 LT. FRAME REPLACED IAW EM 5310-01414, SEC.0301.SDR DALA2014072304272Structure · damagedDURING CHECK, DAMAGE WAS FOUND AT BS 390 S3L. REMOVED DAMAGE AND INSTALLED REPAIR IAW SRM 53-00-03, REPAIR 1.SDR SWAA2014073030475Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW ACO.SDR SWAA2014080430558Window Frame · crackedFLIGHT DECK LT FIXED NR 1 WINDOW FRAME TOP OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014111334142Window Frame · crackedRIGHT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME CRACKED IAW ACO.SDR ASOA20140718221Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR WX0A2014071872030Beam · corrodedAFT CARGO DOOR JAMB IS CORRODED. REMOVED DAMAGE BEAM & INSTALLED NEW BEAM IAW SRM 51-30-5. WORK ORDER 224279 M301 203 & 1010979 8000-0008.SDR SWIA201438988Structure · crackedBS 193, FWD EQUIPMENT BAY CRACKED LT SIDE. C-CHECK, REPAIRED IAW REO.SDR SWIA201438987Structure · crackedBS 193, FWD EQUIPTMENT BAY CRACKED RT SIDE. C-CHECK, REPAIRED IAW EA.SDR C77A20140717001Window Frame · gougedDURING BASIC 2 CHECK, MAINTENANCE FOUND GOUGE DAMAGE TO THE WINDOW FRAMES AT 6L PN 170-67477-403 BETWEEN FRAME 31 - 32, 7L PN 170-67477-403 BETWEEN FRAME 33 - 34, 15R PN 190-27007-401 BETWEEN FRAME 60 - 73 & 16R PN 170-66790-403 BETWEEN FRAME 74 - 75. THE DAMSDR ASAA2014071608725Seat Track · crackedMAIN CABIN SEAT TRACK BS 727B, LBL 45.50 CRACKED. ACFT GROUNDED. REPAIRED SEAT TRAC IAW EA B737-53-1296-NG-119, REV NEW AND REO-G18082, REV B.SDR ASAA2014071608724Seat Track · crackedMAIN CABIN SEAT TRACK BS 727B, LBL 24.75, INBD FLANGE CRACKED. ACFT GROUNDED. REPAIRED SEAT TRACK IAW EA SB737-53-1296-NG-119, REV NEW AND REO-G18082, REV B.SDR DALA1612189581Fastener · damagedFUSELAGE, DAMAGED FASTENER AT BS 1152, LONGERON-2L AND 3L /527412-14.SDR SWAA2014072430292Crease Beam · corrodedLEFT CREASE BEAM INBD CHORD CORRODED AT BS 639 WL 208. R & R CHORD IAW SRM & DWG.SDR R61A201407150895Support · crackedDURING HEAVY CHECK, UPPER AND LOWER WEATHER RADAR ANTENNA SUPPORTS ARE CRACKED. MX R & R SUPPORTS IAW SRM 51-40-02,51-41-01. MAJOR REPAIRSDR R61A201407150891Stop Fitting · corrodedDURING HEAVY CHECK, AFT L2 DOOR CUTOUT DOOR STOPS FITTINGS HAVE SUSPECTED CORROSION. MAINTENANCE R & R AFT PAX DOOR, L2, CUTOUT DOOR STOPS FITTINGS HARDWARE IAW AMM 53-23-21.SDR USAA2014071700006Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM BETWEEN BS 297.7 TO 377.7 RBL 58.22. REPLACED CREASE BEAM BETWEEN BS 297.7 TO 377.7 RBL 58.22 IAW SRM 51-40-02, 51-40-02-0G FIG 8 & AMM 51-21-00.SDR SWIA201438886Pressure Deck · crackedFS 460 BETWEEN LBL 9 & RBL 9 PRESSURE FLOOR HAS A CRACK. C-CHECK, REPAIRED CRACK AT FS 460 IAW REO.SDR R61A201407140896Bracket · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUTOUT ON BOTTOM HAVE SEVERAL NUTPLATE BRACKETS WITH LIGHT CORROSION. MAINTENANCE R & R FWD CARGO DOOR CUT OUT ON BOTTOM HAVE SEVERAL NUTPLATE BRACKETS IAW SRM 51-41-01, PN 170-67032-401, SUPPORT.SDR R61A201407140880Panel · corrodedDURING HEAVY CHECK WASTE SERVICE DOOR HINGE MOUNT INSIDE OF BOX IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR HINGE MOUNT INSIDE OF BOX IAW AMM 20-10-01, SRM 51-40-02. PN 170-86668-403, PANEL.
SDR USAA2014071500017Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM INNER CHORD BETWEEN BS 395 TO 460, LBL 58.22. REPAIRED CREASE BEAM INNER CHORD BETWEEN BS 395 TO 460, LBL 58.22 IAW SRM 53-00-51-1A-1, 51-40-02, 51-70-12 & AMM 51-20-00.SDR SWAA2014081330831Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED BETWEEN BS 305 TO 344, BETWEEN LBL 54 TO LBL 60. R & R CHORD IAW SRM & DWG.SDR DALA2014071504131Beam · corrodedMID CARGO BAY DOOR FRAME BEAM IS CORRODED AT LOWER TANG AND PREVIOUS BLEND OUT. REMOVED CORROSION. FABRICATED AND INSTALLED NEW MID CARGO DOOR FRAME BEAM IAW SRM 51-30-01, 51-10-05 AND DWG 5930481.SDR SIMA20140713001Roller · lack of lubeFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR HAS TO BE LIFTED IN ORDER TO OPEN, NOT OPENING NORMALLY. PERFORMED LUBE TO MAIN DOOR FRAME ROLLERS IAW AMM 53-21-03. OPERATIONS CHECKED GOOD.SDR USAA2014080400018Crease Beam · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON CREASE BEAM BETWEEN BS 450 TO 660, LBL58. REPLACED CREASE BEAM IAW SRM 51-40-02 & SRM 51-40-05.SDR SWAA2014071830078Crease Beam · crackedLEFT FLOOR CREASE BEAM CRACKED AT BS 348 WL 208. R & R BEAM IAW DWG & SRM.SDR SWIA201438876Structure · chafedCHAFING FOUND AT BS 967, STRINGER 27. REPAIRED IAW REO.SDR DALA2014071204097Beam · corrodedAFT CARGO DOOR FRAME BEAM HAS CORROSION AT LOWER TANG AND FORWARD FACE BY PREVIOUS BLENDOUTS. REMOVED AND INSTALLED NEW DOOR FRAME BEAM IAW DWG 5930481.SDR DALA2016112509227Structure · corrodedCORROSION WAS NOTED ON THE WING CENTER BOX TOP SKIN EXTERNAL SURFACE BETWEEN FR42/STIFF16 AND Y1468/RIB1. REPAIR IAW ERA.SDR ASOA201400710215Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201400710211Door Frame · corrodedDURING C-CHECK, THE SERVICE DOOR LOWER FRAME WAS FOUND TO BE CORRODED. MAINTENANCE R & R THE FRAME IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2014092232191Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 971 TO 986. R & R WEB IAW SRM & DWG.SDR FDEA201407091677Crease Beam · corrodedCORROSION AT CABIN CREASE BEAM INNER CHORD STATION 730, BY DOOR L2. ORIGINAL CREASE BEAM FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15, FIG 101, DETAIL IV. R & R CREASE BEAM SECTION IAW SRM 51-40-02, PG 1, SRM 51-40-05 & DWG 143N8322, BS 686 - 760, LBL 58. MAJSDR SWAA2014082031050Door Frame · crackedEXTERNAL POWER RECEPTACLE DOOR 114AR CUT OUT AFT FRAME CRACKED AT BS 235 CTR LATCH. REPAIRED DOUBLER IAW SRM.SDR SWIA201438914Structure · damagedMULTIPLE DENTS FOUND ON FUSELAGE SKIN AT BS 654.5 - 682 BETWEEN STRINGERS 16 -18L. ACFT OUT OF SERVICE, REPAIRED FRAME, INSTALLED DOUBLER AND REPAIRED STRINGERS 17L AND 18L IAW REO.SDR SWAA2014072330224Window Frame · crackedRIGHT BS 400+10 WINDOW FRAME CRACKED AT HOLES 5 & 6. R & R FRAME IAW DWG.SDR AALA20140708003Stop Fitting · crackedMID CARGO DOOR STOP PAD FITTING FROM STATIONS 1220 TO 1222 CRACKED. REPLACED STOP PAD FITTING IAW AARD 51-00-05-1.SDR AALA20140708002Stop Fitting · crackedMID CARGO DOOR STOP PAD FITTING FROM STATIONS 1520 TO 1522 CRACKED. REPLACED STOP PAD FITTING IAW AARD 51-00-05-1.SDR SWAA2014072130118Window Frame · crackedRIGHT NR 1 WINDOW FRAME OTBD UPPER CORNER CRACKED. REPAIRED FRAME IAW ACO.SDR DALA2014070904026Door Frame · corrodedFORWARD CARGO, LOWER DOOR FRAME CORRODED ON LOWER BEAM. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW ANGLE IAW SRM 53-60-02.SDR SWAA2014070829720Window Frame · crackedLEFT NR 3 WINDOW FRAME E - F POST CRACK INDICATION AT NR 2 FASTENER HOLE, COUNTING UP. REPAIRED FRAME IAW SI.SDR SWAA2014071530004Window Frame · crackedRIGHT NR 3 WINDOW FRAME E - F POST SECOND FROM BOTTOM FASTENER HOLE CRACKED. REPAIRED FRAME IAW SI & ACO.SDR SWAA2014071429992Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME E - F POST 2ND HOLE FROM TOP CRACKED. REPAIRED FRAME IAW ACO.SDR USAA2014070700039Crease Beam · corrodedC4 CHECK CREASE BEAM CHORD CORRODED AT BS 1320 & BLB 63. R & R CHORD IAW SRM 51-40-02 & 51-40-05.SDR SWAA2014091832098Door Frame · crackedAFT OF L1 DOOR CUT OUT FRAME INNER CHORD CRACKED AT BS 348.2. R & R CHORD IAW EA.SDR SWAA2014092432272Crease Beam · corrodedR2 DOOR CUT OUT CREASE BEAM INNER CHORD CORRODED ON UPPER SURFACE BETWEEN BS 957 TO 995 BETWEEN RBL 46 TO 56. R & R CHORD IAW SRM & DWG.SDR SWAA2014092432271Door Frame · corrodedR2 DOOR CUT OUT FRAME CORRODED AT BS 993 STRINGER 17R. R & R FRAME IAW EA.SDR SWAA2014091832097Crease Beam · corrodedCREASE BEAM INNER CHORD UPPER SURFACE CORRODED BETWEEN BS 964 TO 980 LBL 52. R & R CHORD IAW SRM & DWG.
Back to JASC 5310