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 SWAA086798Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086797Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086783Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR FDEA200812035060Failsafe · corrodedAFT CARGO COMP BS 950 AT STR 29R OTBD SIDE HAS LEVELING COMPOUND CRACKED, BELOW FAILSAFE. CORROSION ON FAILSAFE BS 950 STR 29R TO STR 28R. REMOVED LEVELING COMPOUND AND FOUND CORROSION OUT OF LIMITS IAW SRM 53-10-1 FIG 1. CUT OUT DAMAGE AREA IAW SRM 51-10-1SDR FDEA200812035052Frame · chafedCABIN LEFT FRAME STATION 535 BETWEEN LONGERON 23 AND 24 FOUND WITH CHAFING MARKS. REPAIR CARRIED OUT AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200812035051Frame · chafedCABIN LEFT FRAME STATION 535 BETWEEN LONGERON 19 AND 20 FOUND WITH CHAFING MARKS. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100.SDR UALA2008120306733Frame · dentedFWD PIT FRAME DENTED AT BS 620 AND STR 24L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FLANGE AND FABRICATED A REPAIR ANGLE AND INSTALLED.SDR UALA2008120306732Frame · dentedDENT IN FUSELAGE FRAME AT STA 1420, STR 26L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FLANGE AND FABRICATED A J-ANGLE REPAIR.SDR UALA2008120306731Frame · dentedAFT PIT AT STA 1480, STR 26L FRAME DENTED AT INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FLANGE AND FABRICATED A J-ANGLE REPAIR AND INSTALLED.SDR SWAA086762Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086761Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086760Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086759Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA2008120301118Frame · dentedAFT CARGO BAY FRAME DENTED AT STA 767, S-25R. REPAIRED FRAME AT STA 767 RT STRINGER 25R IAW B737 SRM 51-70-11.SDR SWAA086703Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086702Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086701Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086700Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086699Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 8L TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086698Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR. 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086697Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086696Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086695Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR. 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086694Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086693Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086692Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086691Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086690Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086689Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086688Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 8R TO STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086687Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086684Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR. 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086683Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086682Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086681Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086680Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086671Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA2008120992204Doubler · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FRAME REPAIR DOUBLER AT BS 400 BETWEEN S8R & S9R. REPLACED FRAME REPAIR DOUBLER AT BS 400 BETWEEN S8R & S9R IAW US AIRWAYS EA 100748.SDR USAA2008120292174Frame · crackedCLT - Q2 - MAJOR REPAIR - FRAME CHORD CRACKED AT BS 639, S18L. REPAIRED FRAME CHORD AT BS 639, S18L IAW TYPICAL REPAIR NR 53-62-01.SDR SWAA086674Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR COMA2008120150019Frame · crackedLEFT FS 640.00 FRAME AND BONDED SKIN DOUBLER ARE CRACKED BETWEEN STR 9 AND 13. COMPLIED WITH MODIFICATION K601R36009-3 ON LT FS 640.00 FRAME AND DOUBLER PER S/B601R-53-061 KIT DRWG K601R36009 REV B, 601R-53-61-506 REV C AND 601R53-61-569.SDR SWAA086641Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, RBL 28. REPAIRED FRAME PER SRM.SDR DHLA2009743552Frame · damagedBS 825 MAIN FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 3L AND 5L. ACCOMPLISHED FRAME REPAIR IAW SRM 53-10-4 FIG 1.SDR DHLA2009743554Frame · damagedBS 700 MAIN FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 13L AND 17L. ACCOMPLISHED FRAME REPAIR IAW B727 SRM 51-40-3 FIG 1 AND 53-10-4 FIG 1 BETWEEN STR 11L AND 17L.SDR DHLA2009743553Frame · damagedBS 783 MAIN FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 7L AND 8L. ACCOMPLISHED FRAME REPAIR IAW SRM 53-10-4 FIG 1.SDR USAA2008122992330Frame · crackedSAL - MAJOR REPAIR - C19 CHECK - NR 6136281, CRACKED FRAME AT BS 907, S8R - S9R. REPAIRED FRAME AT BS 907, S8R - S9R IAW TASK CARD M1C53002.SDR DHLA2009743546Frame · damagedBS 1110 FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 4L AND 5L. ACCOMPLISHED FRAME REPAIR AS REQUIRED PER B727 SRM 51-40-3 FIG 1.SDR DHLA2009743540Frame · damagedBS 720 FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 16L AND 17L. ACCOMPLISHED FRAME REPAIR AS REQ PER SRM 51-40-3 FIG 1.SDR DHLA2009743538Frame · damagedFUSELAGE FRAME AT BS 600 HAS DOUBLE DRILLED HOLES BETWEEN STR 13R AND 17R. REMOVED FRAME SECTION BETWEEN STR 13R AND 18R. FABRICATED FRAME SECTION, AND INSTALLED PER B727 SRM 53-10-2 FIG 2, AND 51-10-1. ALSO, ACCOMPLISHED FRAME REPAIR BETWEEN STR 11R AND 14SDR USAA2008122292296Frame · corrodedSAL - C19 - MAJOR REPAIR - NR 6130873 - CORROSION ON FRAME AT BS 847, BETWEEN S24R TO S26R. REPLACED FRAME AT BS 847, BETWEEN S24R TO S26R IAW B737 SRM 51-40-02-0G.
Back to JASC 5311