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 SWAA063972Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 14R AND STR 14L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063971Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 14R. REPAIRED FRAME SECTION PER SWA EA.SDR MWEA060239Support · chafedFOUND CORROSION ON DOOR CUT OUT THRESHOLD SUPPORT VERTICAL WEB, LONGERON 28 RIGHT, Y 640-690 X-15 CENTER.SDR 06FDEA03632Frame · crackedFRAME AT BS 1352 INNER STRUCTURE CRACKED AT 8:00 POSITION FOUND UPON REMOVAL OF OUTER CHORD. REPAIRED INNER STRUCTURE ON FRAME STA 1352 IAW SRM 51-40-3.SDR TRAX200600853Frame · crackedLT SIDE FRAME 640 BRACKET HAS EVIDENCE OF CRACKED UPPER SECTION. FABRICATED AND INSTALLED NEW FRAME ANGLE AND 640 DOUBLER ON RT. SIDE IAW SB 601R-53-61. JOB COMPLETE (SUPPLEMENTAL - SDR CLOSED)SDR TRAX200600852Frame · crackedRT SIDE FRAME 640 BRACKET HAS EVIDENCE OF CRACKED UPPER SECTION. FABRICATED AND INSTALLED NEW FRAME ANGLE AND 640 DOUBLER ON RT. SIDE IAW SB 601R-53-61. JOB COMPLETE (SUPPLEMENTAL - SDR CLOSED)SDR SWAA063958Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063957Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063956Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063955Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063954Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R AND STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063953Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063952Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063951Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063950Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063934Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED FRAME SECTION PER ER.SDR SWAA063933Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 13L. REMOVED AND REPLACED FRAME SECTION PER ER.SDR SWAA063932Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 2L. REMOVED AND REPLACED FRAME SECTION PER ER.SDR SWAA063931Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REMOVED AND REPLACED FRAME SECTION PER SWA EA.SDR 1287101206Frame · crackedDURING SCHEDULED INSPECTION FOUND FUSELAGE STATION 793 CAP ANGLE CRACKED.SDR DLM88070762Frame · crackedFRAME AT STA 1174 BETWEEN LONGERON 4 AND 5 LT HAS A CRACK. FABRICATED AND INSTALLED REPAIR IAW MD-88 SRM 53-03 FIG 4.SDR 06FDEA03621Frame · gougedNR 1 A/C COMPT FRAME AT STA 590 HAS DEEP GOUGES DOT K2963 REPAIRED FRAME AT STA 590 OF NR 1 A/C COMPARTMENT IAW DC10 SRM 53-30-00 VOL 1 FIG 4 PG 13.SDR KCSA061417Frame · crackedAFT BILGE FUSELAGE FRAME IS CRACKED AT FLOOR LEVEL STA. 1680, LBL 62.SDR 06FDEA03617Frame · dentedFOUND AFT CARGO BAY DENT ON FRAME AT BS 1070 BETWEEN STR 25R. REMOVED DAMAGE ON FRAME BS 1070 AT STR 25R AND REPAIRED IAW SRM 51-40-3SDR 06FDEA03616Frame · dentedFOUND AFT CARGO BAY DENT ON FRAME AT BS 1110 BETWEEN STR 25L AND STR 26L. REPAIRED FRAME AT BS 1110 BETWEEN STR 25L AND STR 26L PER SRM 51-40-3.SDR 06FDEA03615Frame · dentedAFT CARGO BAY DENT ON FRAME AT BS 1050 BETWEEN STR 25L AND STR 26L. REMOVED DAMAGE ON FRAME AFT CARGO BAY BS 1050 BETWEEN STR 25L AND 26L AND REPAIRED IAW SRM 51-30-5, 51-40-3.SDR 06FDEA03614Frame · dentedAFT CARGO BAY DENT ON FRAME AT BS 990 BETWEEN STR 25L AND STR 26L. REPAIRED FRAME BS 990 BETWEEN STR 25L - 26L PER SRM 51-40-3.SDR 06FDEA03613Frame · dentedFOUND AFT CARGO BAY DENT ON FRAME AT BS 1030 BETWEEN STR 25R AND STR 26R. REMOVED DAMAGE, FABRICATED DOUBLER AND INSTALLED PER SRM 51-40-3.SDR 06FDEA03612Frame · dentedFOUND DENT AFT CARGO BAY ON FRAME AT BS 1050 STR 23R. REMOVED DAMAGE REPAIREDWITH FASTENER PER SRM 53-10-1, SRM 51-30-2.SDR 06FDEA03611Frame · dentedFOUND AFT CARGO BAY DENT ON FRAME AT BS 950D STR 25L. REMOVED DAMAGE ON FRAME BS 950F STR 26L AND REPAIRED IAW SRM 53-10-1, 51-40-3.SDR 06FDEA03610Frame · dentedFOUND AFT CARGO BAY DENT ON FRAME AT BS 950B STR 26R. REPARIED FRAME AT BS 950B, STR 26R PER SRM 51-40-3.SDR UPS06448666Frame · crackedINSPECTION TYPE:C RIGHT BS 820 FRAME TENSION TIE ATTACH AREA TWO EA FASTENER HOLE FOUND CRACK AT FRAME LAYER FOR DETAIL. CRACK LENGTH 0.040" CRACK LENGTH 0.040". M/D BS 820 RIGHT FRAME CRACKED TWO HOLES OVERSIZED BY 1/64" INCREMENT UP TO 0.309" DIA AS PER EOSDR BAQA200600002Frame · brokenDURING A 600 HOUR AIRFRAME INSPECTION, FOUND THE PILOT'S 25 DEGREE FRAME BROKEN. THIS FRAME WAS REPAIRED ABOVE THE AREA WHERE IT IS BROKEN NOW DURING THE LAST 500 HOUR AIRFRAME INSPECTION. AT AIRCRAFT TOTAL TIME: 3463.7 CYCLES: 18234 ON JUNE 6, 2005.SDR BAQA200600003Frame · brokenDURING A 600 HOUR AIRFRAME INSPECTION, FOUND THE PILOT'S 25 DEGREE FRAME BROKEN. THIS FRAME WAS REPAIRED ABOVE THE AREA WHERE IT IS BROKEN NOW DURING THE LAST 500 HOUR AIRFRAME INSPECTION. AT AIRCRAFT TOTAL TIME: 3463.7 CYCLES: 18234 ON JUNE 6, 2005.SDR AWXA200601729Frame · crackedMCN - FRAME CRACKED FROM DOOR STOP FITTING AT STA 440 STR 24R. REPAIRED FRAME STA 440 STR 24R IAW AWA ER#03-5332-06277-SS1.SDR SWAA063900Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 908, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063899Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 578, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063898Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 420, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063897Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063896Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063895Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 13L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063894Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 13L. REPAIRED FRAME SECTION PER SWA EA.SDR 2006FA0001155Frame · cracked(REF NR: 06DA063) DURING C-CHECK, MAINTENANCE TASK 53-02-1000 INSP FS 983 FRAME. A CRACK, 3 INCHES) FOUND AT LT, BY A CLOSE VISUAL INSP AND CONFIRMED BY NDT. NRC NR 546 RAISED FOR CORRECTIVE ACTION. (K)SDR SWAA063876Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 14R. REPAIRED FRAME SECTION PER SRM.SDR CALA0600378Frame · corrodedCORRODED FRAME ATTACH ANGLE IN AFT EQUIPMENT BAY BILGE AT STA 967M, S24L-S26L. REPLACED FRAME IAW DRAWING 65-46563 AND SRM 51-40-02.SDR SWAA063852Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063851Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063850Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063849Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063848Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.
Back to JASC 5311