JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 SWAA114449Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CHORD CRACKED AT BS 616 WL 201. REPAIRED CHORD PER EA.SDR SWAA114463Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA114465Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA114464Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA114412Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER EA AND EO.SDR SWAA114413Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 460, STR 25L. REPAIRED FRAME PER EA AND EO.SDR SWAA114414Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 420, STR 25L. REPAIRED FRAME PER EA AND EO.SDR SWAA114415Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 26R. REPAIRED FRAME PER EA.SDR U2RA486DHN033Frame · dentedDENT IN TOP OF FRAME AT STA 720, STR 23L.SDR FDEA201106172321Frame · misrepairedFRAME SPLICE REPAIR AT STATION 1320, STR 23L-26L REQUIRES REPLACEMENT DUE TO NOT COMPLYING WITH APPROVED DATA. R & R FRAME, AT STA 1320, STR. 24L TO STR 24R, IAW SRM-51-40-02. NEW FRAME FABRICATED AND INSTALLED. NEW SPLICE IAW-SRM-51-40-02, SPLICE FABRICATESDR USAA2011071100008Frame · crackedQ4 CHECK - CRACK ON FRAME AT BS 500E, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME AT BS 500E, BETWEEN STR 20R TO STR 21R IAW B737 SRM 53-00-07 REPAIR 13.SDR FDEA201106162283Frame · corrodedFRAME CORRODED AT BS 1130 AT STR 17R. REMOVED CORROSION IAW SRM 51-10-6. FABRICATED REPAIR PLATE IAW SRM 51-40-3 FIG 1. INSTALLED REPAIR PLATE IAW SRM 51-30-2.SDR FDEA201106162282Frame · dentedRT SIDE OF FUSELAGE, FRAME HAS A DENT AT BS 1130 BETWEEN STRINGER 25R AND 26R. CUTOUT DAMAGED AREA, FABRICATED REPAIR ANGLE, AND INSTALLED REPAIR IAW SRM 51-40-3 FIG 1.SDR UIEA2011061600353Frame · crackedU/D LT BS 500 SILL FRAME ATTACH DOUBLER CRACKED (BS 500, S10L TO S12L FRAME ATT DOUBLER REPAIR ACCOMPLISHED IAW RS53-22-37133, REV A).SDR USAA2011070100031Frame · crackedCLT - Q6 - 3/16 INCH CRACK ON FRAME AT WIRE PENETRATION HOLE, BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME AT WIRE PENETRATION HOLE, BS 500B, BETWEEN STR 20L TO STR 21L IAW EA 103096, B737-300 SRM 53-00-07, REP 13.SDR FDEA201106162281Frame · corrodedCORROSION ON UPPER FLANGE OF FRAME AT BS 970, BETWEEN STRINGER 28L AND 27L. CUT OUT DAMAGED AREA IAW SRM 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER AND FILLER IAW SRM 51-40-3 FIG 1. INSTALLED DOUBLER AND FILLER IAW SRM 51-40-3 FIG 1 REV 103SDR IPXA11567317Frame · wornINSPECTION TYPE:C, CK MAIN CARGO FRAME AT BS 1540 INBD FLANGE HAS WEAR BETWEEN STR 15-16R. REPAIRED FRAME DAMAGE IAW EA 110577.SDR SWAA114362Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME IAW EA.SDR SWAA114361Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 616, STR 17R. REPAIRED FRAME IAW EA.SDR SWAA114359Angle · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME ANGLE CORRODED AT BS 727D, BETWEEN STR 26L TO STR 25L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA114358Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME ANGLE CORRODED AT BS 787, BETWEEN STR 26L TO STR 25L. REPAIRED FRAME PER SRM.SDR SWAA114357Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 500, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA114356Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR K11A2012070516001Frame · corrodedFORWARD PIT CORROSION AT STRINGER 29R AND 29L ON FRAME (NR 21784).SDR USAA2011071100011Frame · crackedQ3 CHECK - CRACKS ON FRAME AT BS 500B, STR 20L. REPAIRED FRAME AT BS 500B, STR 20L IAW B737 SRM 53-00-07R13.SDR USAA2011062900015Frame · crackedCLT - Q6 CHECK - CRACK ON FRAME WEB AT BS 303.9, STR 16L. REPLACED FRAME WEB AT BS 303.9, STR 16L IAW EO 5311-01025.SDR SWAA114402Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR FDEA201106142285Frame · dentedZEE FRAME DENTED AT STA 660 JUST OTBD OF STR 25R. CUTOUT DAMAGE AREA IAW SRM 51-40-3 FIG 1, FABRICATED REPAIR IAW SRM 51-40-3 FIG FIG1, HEAT TREATED REPAIR TO T6 IAW FASI REPORT 2-37153-801 REV A, TREATED & PRIMED REPAIR IAW SRM 51-10-2, INSTALLED REPAIR ISDR FDEA201106142225Frame · unknownEXISTING REPAIR AT BS 1520 BETWEEN STR 22R AND 26R THERE IS DOUBLER REPAIR ON THE INTERIOR FRAME AT THE SPLICE JOINT. REMOVED AND REPLACED IAW SRM 51-40-02.SDR USAA2011062900014Frame · crackedCLT - Q6 CHECK - CRACK ON FRAME AT BS 360 BETWEEN STR 13R TO S14R. REPAIRED FRAME AT BS 360 BETWEEN STR 13R TO S14R IAW TYPICAL REPAIR 737-5310-10-0327.SDR DALA1140580627Frame · corrodedAFT CARGO FRAME CORRODED ON FWD SIDE ABOVE SHEAR TIES AND AFT SIDE UNDER FAIL SAFE STRAP CHORD STA 1420 STR 29L TO DOOR FRAME 27R. COMPLIED WITH AT SAA/SAT ON NON ROUTINE 187544 W/O 87878550001.SDR DALA1140530627Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STR N25&26 REPAIR ANGLE HAS INCORRECT NUMBER OF FASTENERS ON LOWER FLANGE. COMPLIED WITH AT SAA/SAT ON NON ROUTINE 187563 W/O 87878730001.SDR FOTR2110410149Frame · crackedLEFT FS 642 MAIN FRAME IS CRACKED PT E TO PT D AND PT D TO PT C, ALSO CRACK EXTENDS 2" OTBD FROM POINT D/E AND 1" BELOW PT E AND 2" ABOVE PT D.SDR SWAA114333Angle · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME WEB ANGLE CRACKED AT BS 500B, STR 26L. REMOVED AND REPLACED FRAME CLIP PER SRM.SDR SWAA114334Angle · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME WEB ANGLE CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED FRAME CLIP PER SRM.SDR SWAA114335Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO.SDR SWAA114337Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA114311Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114308Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114310Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA114312Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114319Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 26R. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA114320Failsafe · corrodedDURING SCHEDULED 18Y CHECK, FOUND FAIL SAFE CHORD CORRODED AT BS 767, BETWEEN STR 27L TO STR 26R. REMOVED AND REPLACED CHORD PER CHORD.SDR SWAA114309Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR FDEA201106142242Frame · crackedRIGHT MAIN GEAR WELL AFT WALL MAIN FRAME, JUST FWD OF AFT PRESSURE BULKHEAD HAS A CRACK IN FRAME PREVIOUSLY STOP DRILLED, REPAIRED DAMAGED AREA AS REQ REF EA 8-5310-151258SDR CHQA201100245Frame · crackedDURING INSPECTION, RIGHT FRAME 10 WAS FOUND CRACKED A THE INTERSECTION OF THE DIRECT VISION WINDOW'S LOWER BEAM IN FORWARD FUSELAGE II. MAINTENANCE REPLACED THE CRACKED RIGHT FRAME 10 AT THE INTERSECTION OF THE DIRECT VISION WINDOW WITH NO FURTHER DEFECTS NOTSDR CHQA201100244Frame · crackedDURING INSPECTION, LEFT FRAME 10 WAS FOUND CRACKED AT THE INTERSECTION OF THE DIRECT VISION WINDOW'S LOWER BEAM IN FORWARD FUESLAGE II. MAINTENANCE REPLACED THE CRACKED LEFT FRAME 10 AT THE INTERSECTION OF THE DIRECT VISION WINDOW WITH NO FURTHER DEFECTS NOTESDR FDEA201106132215Frame · wornFRAME, STA 984, STR 1 TO 3L HAS HOLES THAT ARE OUT OF LIMITS. REMOVED DAMAGED FRAME AREA FROM STR 1 TO STR 7L STA 984 LT IAW SRM 53-00-07. LOCATED AND DRILLED 2 EA ANGLES AND NEW FRAME IAW SRM 51-40-05. TREATED AND PRIMED REPAIR PARTS IAW SRM 51-20-01. INSDR DJFA2011022Frame · crackedDURING SCHEDULED INSPECTION, MAINTENANCE TECHNICIANS FOUND THE BLEED AIR TUBE SUPPORT BRACKET ATTACHED TO FRAME 329.9 PULLED AWAY AND DAMAGED THE FRAME. THE FASTENERS WERE PULLED THROUGH THE FRAME AND THE FRAME CRACKED AT THE FASTENER HOLES. THE FRAME WAS RSDR CHQA201100253Frame · crackedDURING INSPECTION, THE FORWARD FUSELAGE II LEFT AND RIGHT FRAME 10 WAS FOUND TO BE CRACKED AT THE INTERSECTION OF THE DIRECT VISION WINDOW LOWER BEAM. MAINTENANCE REPLACED THE FORWARD FUSELAGE II LEFT AND RIGHT FRAME 10 AT THE INTERSECTION OF THE DIRECT VISIO
Back to JASC 5311