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 UALA2008120106687Frame · damagedTWENTY ONE (21) STRINGERS CUT FOR REMOVAL ACCESS TO REAR PRESSURE BULKHEAD LOWER FRAME 70 SECTION 5.25 INCHES AFT OF FRAME 70 BETWEEN STRINGERS 24L AND STRINGER 24R. MAJOR REPAIR ACP'D: ALL STRINGERS REINSTALLED.SDR UALA2008120106686Frame · damagedAFT PRESSURE BULKHEAD FRAME (LWR) IS CREASED AT FR70 BETWEEN STR 42L AND STR 43R. MAJOR REPAIR ACCOMPLISHED: REPLACED FRAME.SDR USAA2008120292164Frame · crackedCLT - Q2 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 380, BETWEEN S8L AND S9L. REPAIRED FUSELAGE FRAME AT BS 380, BETWEEN S8L AND S9L IAW EA NR 100749.SDR DHLA2009743555Frame · damagedBS 460 MAIN FRAME INBD FLANGE HAS ELONGATED HOLES BETWEEN STR 6R AND 7R. ACCOMPLISHED FRAME REPAIR IAW SRM 53-10-4 FIG 1.SDR DHLA2009743551Frame · dentedBS 680 MAIN FRAME DENTED/DOUBLE DRILLED HOLES BETWEEN STR 13L AND 17L. ACCOMPLISHED FRAME REPAIR IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743549Frame · damagedBS 848 FRAME HAS DOUBLE DRILLED AND ELONGATED HOLES BETWEEN STR 2L AND 5L. ACCOMPLISHED FRAME REPAIR AS REQUIRED PER B727 SRM 53-10-4 FIG 1.SDR DHLA2009743547Frame · damagedBS 400 FRAME HAS DOUBLE DRILLED HOLES BETWEEN STR 2L AND 3L. ACCOMPLISHED FRAME REPAIR AS REQUIRED PER B727 SRM 53-10-4 FIG 1.SDR DHLA2009743539Frame · dentedFUSELAGE FRAME AT BS 1070 DENTED BETWEEN STR 25R AND 27R. ACCOMPLISHED FRAME REPAIR IAW B727 SRM 51-40-3 FIG 1.SDR DHLA2009743537Frame · dentedFUSELAGE FRAME AT BS 1050 DENTED AT STR 26L. REPAIRED FRAME SECTION IAW SRM 51-40-3 FIG 1.SDR AALA200810374Frame · crackedLEFT OVERWING FUSELAGE FRAME CRACKED STATION 864. REMOVED AND REPLACED LEFT STATION 864 FRAME PER SRM 51-01-00.SDR SWAA086619Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME STUB BEAM CRACKED AT BS 685, RBL 45. REPAIRED FRAME PER ER.SDR SWAA086603Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086602Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086601Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086620Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME STUB BEAM CRACKED AT BS 706, RBL 45. REPAIRED FRAME PER ER.SDR CALA2008112501101Frame · gougedTOP OF FRAME HAS DEEP GOUGE STA 1300 STR 25R (APPROX). REPAIRED FRAME STA 1300 STR 25R REF ECRA 5311-01436.SDR CALA2008112501100Frame · crackedAIR CONDITIONING SUPPORT BRACKET ATTACHED TO THE FRAME BETWEEN STRINGER 8 AND 9 CRACKED AROUND HOLE STA 360 L. REPAIRED CRACK AROUND HOLE AT STA 360 L, REMOVED DAMAGED AREA (CUT OUT IN ITEM 1, 2, 3) AND MADE REPAIR ANGLES "A" & AMP; "B" AND INSTALLED AS REF ESDR CALA2008112501099Frame · crackedAIR CONDITIONING SUPPORT BRACKET ATTACHED TO THE FRAME BETWEEN STRINGER 8 AND 9 CRACKED AROUND RIVET HOLE STA 827L. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED ALL REPAIR PARTS PER ECRA 5311-01435.SDR USAA2008122292298Frame · corrodedSAL - C19 - MAJOR REPAIR - NR 6130869 - CORROSION ON FRAME AT AFT CARGO DOOR CUTOUT AT BS 794, BETWEEN S23R TO S27R. REPLACED FRAME AT AFT CARGO DOOR CUTOUT AT BS 794, BETWEEN S23R TO S27R IAW B737 SRM 51-40-02-0G.SDR UALA2008112406650Frame · corrodedFWD CARGO PIT FRAME TEE CAP CORRODED AT BS 654 +121 LBL 40 WL 125. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED TEE CAP SECTION, FAB NEW TEE CAP AND INSTALLED.SDR SWAA086578Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, STR 17R. REPAIRED FRAME PER SWA EA.SDR CALA2008112401098Frame · crackedAIR CONDITIONING SUPPORT BRACKET ATTACHED TO THE FRAME BETWEEN STRINGERS 8 & AMP; 9 CRACKED AROUND RIVET STA 747L. FABRICATED AND INSTALLED REPAIR DOUBLERS PER ECRA 5310-04498.SDR DHLA2009743550Frame · damagedBS 1170 FRAME HAS DOUBLE DRILLED HOLES ON INBD FLANGE BETWEEN STR 16L AND 17L. ACCOMPLISHED FRAME REPAIR AS REQUIRED PER B727 SRM 51-40-3 FIG 1.SDR SWAA086533Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS. 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086531Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS. 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR AALA200810302Frame · corrodedAFT CARGO, CORROSION ON STATION 1309 FRAME. INSTALLED FRAME SPLICE PER SRM 53-03-00SDR CALA2008112401092Frame · crackedAIR CONDITIONING SUPPORT BRACKET ATTACHED TO THE FRAME BETWEEN STRINGER 8 & AMP; 9 CRACKED AROUND RIVET HOLE STA 867L. REPAIRED FRAME AT STA 867L STRINGER 8 & AMP; 9 PER EA 5310-04498.SDR ASAA0843958Frame · crackedBS 616 LT SIDE FRAME CRACKED BELOW WL 208 ACCOMPLISHMENT OF EC 5310-0258-5 REQUIRED. REPAIRED LT SIDE FRAME AT STA 616 IAW EC 5310-0258-5.SDR UALA2008112406618Frame · dentedAFT PIT AT STA 1560, STR 26R, FRAME DENTED AT INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR 08FDEA04953Frame · corrodedC-2 PIT FLOOR FRAME SHEAR TIE AT FS 970, RBL9 TO RBL15, WL 139 HAS CORROSION ON AFT TO BOTTOM SIDE. INSTALLED NEW SHEARTIE REF SRM 53-10-4. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR SWAA086528Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086527Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086526Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086525Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086493Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086492Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086491Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086489Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086488Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086487Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086486Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086485Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086484Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086478Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086477Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086476Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086475Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086474Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086469Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 277, BETWEEN STR 9R TO STR 10R. REPAIRED FRAME PER SRM.SDR SWAA086460Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, NR 1 STOP PAD FITTING. REPAIRED FRAME PER SRM.
Back to JASC 5311