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 R61A201402160283Rivet · corrodedDURING HEAVY CHECK, RIVET BUCKTAILS FROM FRAME 80-81, S27-28R, FRAME 76-77, S29L/R ARE CORRODED. MX R & R RIVETS IAW SRM 51-41-02.SDR SIMA20140214015Stop Fitting · out of limitsPAX DOOR FRAME STOP NR 2 IS OUT OF LIMITS. R & R PAX DOOR FRAME STOP NR 2 IAW AMM 53-21-03.SDR R61A201402270353Beam · corrodedDURING HEAVY CHECK FOUND A SPLIT BEAM ON BACK SIDE OF AFT GALLEY ALONG COUNTER HAS CORROSION. R & R ALL CORRODED TRIM PIECES ON BOTH SECTIONS OF AFT GALLEY WHERE THE 2 HALVES MEET IAW AMM 25-0023,20-10-01,25-00-05. PN CDSP2200-11 SPLIT JOINT.SDR ASOA2014030610091Window Frame · crackedFLIGHT DECK RT WINDSHELD SIDE POST. SUPPORT CRACKED. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. REMOVED RT WINDSHIELD SIDE POST SUPPORT ANGLE IAW SRM 51-42-06. INSTALLED SERVICABLE RT SIDE POST LOWER SUPPORT ANGLE AND RESTORED FINISH IAW EO SDR SWAA2014030525777Doubler · crackedFWD EXIT DOOR ACCESS LOWER FWD FRAME DOUBLER CRACKED. REPAIRED DOUBLER IAW EA.SDR SWAA2014021925291Doubler · crackedFWD EXIT DOOR ACCESS LOWER FWD FRAME DOUBLER CRACKED. REPAIRED DOUBLER IAW EA.SDR DALA14010179210Spacer · corrodedCORROSION FOUND ON AFT CARGO DOOR FRAME. REMOVED CORROSION. FABRICATED AND INSTALLED NEW SPACER IAW 53-60-02 AND 51-10-03.SDR COEA2014040133908Bushing · damagedDURING HEAVY CHECK, LT FWD WING TO FUSELAGE FRAME FITTING BUSHING HAS DAMAGE. REPAIR IAW SRAS S535R00411555 DATED 3/27/2014.SDR FDEA201402120301Strap · corrodedEMPENNAGE, APU AIR INLET DOOR CUT OUT INNER STRAP FOUND CORRODED AT BS 1825, STRINGER 3 - 6R. AFTER APU AIR INLET DOOR HOUSING REMOVED. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-80-15 TABLE 101 AD 1 REV 111 & REPAIRED IAW SRM 53-80-15 REPAIR 1 DETSDR ASOA2014022710030Support Beam · crackedFOUND CARGO DOOR SUPPORT BEAM LOWER AFT ANGLE CRACKED . REMOVED AND INSTALLED IAW SRM 51-42-21-00.SDR UHLA2014021200093Shear Plate · corrodedCORROSION FOUND ON AFT WET AREA SHEAR PLATE ON LT SIDE. R & R LT CF SHEAR WEB.SDR SWAA2014022025363Window Frame · crackedRT NR 1 WINDOW FRAME OTBD AFT UPPER FASTENER HOLE CRACKED. R & R FRAME IAW ACO.SDR SWAA2014021925323Crease Beam · corrodedCREASE BEAM OUTER CHORD CORRODED BETWEEN BS 772 TO BS 776, STRINGER 17L. REPAIRED CHORD IAW SRM.SDR SWAA2014021925292Stop Fitting · crackedFWD ENTRY DOOR UPPER AFT STOP POST CRACKED IN UPPER RADIUS. R & R POST IAW SRM.SDR DALA14009940993Door Frame · corrodedCORROSION NOTED ALONG CENTER LOWER CARGO DOOR FRAME BETWEEN BS 636-693. REPAIRED IAW SRM 51-30-1 & 53-05, FIG 123.SDR DALA14009886308Door Frame · crackedDURING H CHECK, A CRACK WAS DETECTED ABOVE THE R4 DOOR FRAME UPPER SILL WEB, BS 1718, S16R. ER/A 522139-14AD, SECTION I WAS ACCOMPLISHED.SDR DALA14009785656Crease Beam · corrodedRIGHT INNER CREASEBEAM ANGLE CORRODED AT BS 758. REMOVED CORROSION IAW SRM 53-30-13. R & R CREASE BEAM ANGLE BS 758 - 900 IAW SRM 51-40-02 & SRM 53-30-13.SDR QXEA2014021200110Beam · corrodedAFT SERVICE DOOR EDGE BEAM, FOUND CORRODED. REMOVED EDGE BEAM IAW SRM 51-42-15. INSTALLED EDGE BEAM IAW SRM 51-42-15 PARA 1-5F.SDR ASAA2014021006964Gusset · crackedL1 DOOR FWD SIDE BS 312 AT STRINGER 14L GUSSET CRACKED. ACFT GROUNDED. R & R GUSSET IAW SRM 51-40-02-0G-0.SDR DALA14009970993Door Frame · corrodedDURING C-CHECK, NOTED CORROSION ON LOWER AFT CARGO DOOR FRAME BETWEEN BS 1154-1211. REPAIRED IAW SRM 51-30-03, 53-05, FIG 123 OPTION 1, 51-30-05.SDR DALA14009950993Door Frame · corrodedDURING C-CHECK, NOTED CORROSION ON LOWER AFT CARGO DOOR FRAME BETWEEN BS 1154-1211. REPAIRED IAW SRM 51-30-03, 53-05, FIG 123, OPTION 1, 51-30-05.SDR SWAA2014021225089Window Frame · crackedCAPTAIN`S SIDE UPPER WINDOW POST FRAME CRACKED. R & R FRAME IAW EA.SDR VNAA2014020900006Structure · damagedDURING SCHEDULED MAINTENANCE THE FS 559+64 STRINGER 13L HAD LIGHTNING STRIKE DAMAGE. THE AREA WAS INSPECTED AND REPAIRED USING AMM. ACFT WAS RELEASED FOR SERVICE.SDR GLBA2014021000377Door Frame · crackedDURING A SCHEDULED INSPECTION MX FOUND A CRACK IN THE CARGO DOOR AFT LOWER FRAME AT FS 509.50 AT THE INTERSECTION OF THE LOWER SILL, 1" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 14-1900-53-006.SDR UHLA2014020800126Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM FRAME 84 TO RT FUSELAGE. REPAIRED CROSSBEAM IAW ETD2014-170-010420. MAJOR REPAIRSDR SWAA2014022425458Window Frame · crackedRT HAND NR 1 WINDOW FRAME UPPER OTBD CORNER CUT OUT CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2014022125384Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME AT EF POST FASTENER HOLE, SECOND FROM BOTTOM, CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2014022025362Window Frame · crackedFLIGHT DECK LT NR 3 WINDOW FRAME AT EF POST CRACKED AT FASTENER HOLE FOURTH FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014022025361Window Frame · crackedFLIGHT DECK RT NR 3 WINDOW FRAME EF POST CRACKED AT FASTENER HOLE SECOND FROM BOTTOM. REPAIRED FRAME IAW ACO.SDR SWAA2014022025358Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED. R & R FRAME IAW ACO.SDR SWAA2014021225087Crease Beam · corrodedRT CREASE BEAM ANGLE CORRODED AT BS 639. REPAIRED BEAM IAW ER & EA.SDR DALA14009529211Former · corrodedCORROSION ON FORMER, BS 1307, BETWEEN L28-29R. CUT OUT DAMAGE. FABRICATED AND INSTALLED FORMER SECTION IAW SRM 53-10-02, FIG 3.SDR QXEA2014021200109Beam · corrodedAFT PAX DOOR LT EDGE BEAM FOUND CORRODED. DRILLED AND FITTED NEW EDGE BEAM IAW SRM 51-40-07. INSTALLED NEW EDGE BEAM IAW SRM 51-42-05, STEP 4, D, 1 THRU 7 AND 51-42-45.SDR DALA14008330650Pan · corrodedAFT CARGO BAY, AFT OF AFT BULKHEAD PANEL, EVIDENCE OF LAVATORY DUMP TUBE LEAKING AT CONNECTION TO SERVICE PANEL, BLUE WATER STAINED AND CORROSION ON LAVATORY PAN. CORROSION FOUND TO BE 100 PERCENT MATERIAL LOSS IAW SRM 51-10-02. DOUBLER FABRICATED IAW DWG 14SDR DALA14008231612Structure · crackedCABIN LT BELOW DOOR FRAME BS 903.5 LOWER CORNER FOUND CRACKED, REPAIRED.SDR SWAA2014022125412Window Frame · crackedLT NR 1 WINDOW FRAME ASSEMBLY CRACKED. R & R FRAME ASSEMBLY IAW ACO.SDR QXEA2014021200107Beam · corrodedCORROSION ON EDGE BEAM OF EMERGENCY EXIT DOOR HAD EXCESSIVE CORROSION. REMOVED EDGE BEAM IAW SRM 51-42-05. INSTALLED NEW EDGE BEAM IAW SRM 51-42-05.SDR K11A2014022472609Window Frame · corrodedCORROSION ON WINDOW FRAME BS 720C.SDR K11A2014022472608Window Frame · corrodedCORROSION ON WINDOW FRAME LT BS 720A.SDR K11A2014022472607Window Frame · corrodedCORROSION ON WINDOW FRAME, BS 720F.SDR K11A2014022472606Window Frame · corrodedCORROSION ON WINDOW FRAME RT BS 950E.SDR SWIA201436409Door Frame · corrodedMAIN AVIONICS COMPARTMENT DOOR CUTOUT, DOOR SEAL CONTACT SURFACE, FWD RT HAND CORNER HAS LIGHT CORROSION. C-CHECK REMOVED CORROSION FROM MAIN AVIONICS COMPARTMENT DOOR CUTOUT, FWD RT CORNER INNER SIDE & REPAIRED IAW REO.SDR SWAA2014021225091Window Frame · crackedLT NR 1 WINDOW FRAME OTBD END FWD & AFT FASTENER ROWS UPPER FASTENER HOLE IN EACH ROW CRACKED. R & R FRAME IAW ACO.SDR ASAA2014020507057Door Frame · crackedFWD CARGO BAY DOOR CUT OUT AFT FRAME CRACKED AT LWR AND UPPER STOP FITTINGS. ACFT GROUNDED. R & R CRACKED FRAME IAW SRM 51-40-02-0G-0.SDR IPXA2014021481926Web · crackedDURING INSPECTION T4C, TORQUE BOX WEB CRACKED AT R3 DOOR FWD FRAME INTERIOR LIGHTNING HOLE. REPAIRED WEB AT R3 DOOR FWD JAMB IAW SRM 53-40-15, REPAIR 3, FIG. 201.SDR UHLA2014020500069Structure · corrodedCORROSION FOUND ON AFT GALLEY RT SIDE SILL HAS TOW PLACES AROUND FASTENER HOLES. R & R RT SIDE SEAL.SDR UHLA2014020400131Crossbeam · corrodedCORROSION FOUND ON CROSSBEAM AT FRAME 17 TO RT SIDE OF FUSELAGE. REPAIRED CROSSBEAM IAW ETD2014-170-010223.SDR UHLA2014020400110Splice · corrodedCORROSION FOUND ON LT SPLICE FRAME 90. R & R LT SPLICE.SDR UHLA2014020400102Beam · corrodedCORROSION FOUND ON LEFT BEAM Y=-10.748, FRAMES 86-89. R & R AFT LT BEAM.SDR UHLA2014020400101Beam · corrodedCORROSION FOUND ON RT BEAM Y=+10.748, FRAMES 86-89. R & R RT BEAM.
Back to JASC 5310