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 2008UALA05503Frame · damagedBS 1420 STR 26L FRAME HAS DAMAGE. *S/D* MAJOR REPAIR ACCOMPLISHED. REMOVED PREVIOUS REPAIR INCLUDING STRINGER CLIPS AND PRODUCTION SPLICE. FABRICATED & INSTALLED A REPAIR ANGLE.SDR 2008UALA05506Frame · dentedAFT PIT FRAME DENTED AT STA 1400 AND STR 26L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED A REPAIR ANGLE.SDR SWAA084771Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 7L. REPAIRED FRAME PER SWA EA.SDR SWAA084770Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084769Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084768Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084767Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084766Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084765Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084763Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 294, STR 15R. REPAIRED FRAME PER SRM.SDR SWAA084753Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800838Frame · crackedRIGHT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 380 BETWEEN STRINGERS 8 AND 9. REPAIRED FRAME AT STATION 380 RIGHT BETWEEN STRINGERS 8 AND 9 RIGHT PER EA 5310-04498.SDR CALA0800837Frame · crackedRIGHT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 400 BETWEEN STRINGERS 8 AND 9. REMOVED DAMAGED AREA, AND INSTALLED REPAIR DOUBLERS A AND B PER EA 5310-04498 OPS-2.SDR CALA0800836Frame · crackedRIGHT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 440 BETWEEN STRINGERS 8 AND 9. REPAIRED FRAME AT STATION 440 RIGHT BETWEEN STRINGERS 8 AND 9 RIGHT PER EA 5310-04498.SDR CALA0800835Frame · crackedRIGHT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 827 BETWEEN STRINGERS 8 AND 9. REPAIRED RIGHT FRAME AT FASTENERS FOR AIR GRILL SUPPORT RAIL MOUNT AT STATION 827 BETWEEN S-9R AND S-9R PER EC/RA 5310-04827.SDR CALA0800834Frame · crackedLEFT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STA 907 BETWEEN STRINGERS 8 AND 9. TRIMMED OUT CRACKED AREA AND INSTALLED REPAIR DOUBLERS PER EA 5310-04498 OP 2.SDR CALA0800833Frame · crackedLEFT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 867 BETWEEN STRINGERS 8 AND 9. ACCOMPLISHED LEFT FRAME REPAIR AT STATION 867 BETWEEN STRINGER 8 AND 9 PER EA5310-04498 OP 2.SDR SWAA084740Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084734Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084733Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084732Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084724Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA03599Frame · corrodedFRAME P/N AEA 0273-3 REQUIRES FABRICATION DUE TO EXISTING FRAME BEING CORRODED BEYOND LIMITS AT STA 1501. FABRICATED A NEW FRAME SECTION AND SHEAR TIE IAW DAC DWG AEA 0273; REV "G". LOCATED AND DRILLED AEA 0273-3 FRAME AND AEA 0273-5 SHEAR TIE. ALODINED ANDSDR 08FDEA03592Frame · dentedMAIN DECK FRAME AT LEFT STA 1741 APPROXIMATELY LONGERON 11 TO LONGERON 12 FOUND WITH DENT. CARRIED OUT REPAIR AS PER SRM 53-30-00, FIGURE 1 VOLUME I. DUE TO CATEGORY B REPAIR, INITIAL INSPECTION TO BE CARRIED OUT AT 14,000 CYCLES AND THEREAFTER REPETITIVE ISDR USAA920081758Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 727D, S9L. REPAIRED FRAME, BS 727D, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081759Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 380, S9R. REPAIRED FRAME, BS 380, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081760Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081761Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 520, S9R. REPAIRED FRAME, BS 520, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081765Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME, BS 480, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081766Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 500A, S9L AND S9R. REPAIRED FRAME, BS 500A, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081767Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 867, S9L AND S9R. REPAIRED FRAME, BS 867, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081764Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 907, S9R. REPLACED FRAME, BS 907, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081762Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 787, S9R. REPLACED FRAME, BS 787, S9R IAW B737 US AIRWAYS TASK CARD M1C53002.SDR USAA920081763Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081779Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 400, S9L. REPAIRED FRAME BS400, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081780Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS440, S9L. REPAIRED FRAME BS440, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR U2R2008F00006Frame · corrodedDURING C-CHECK INSP, FOUND FWD CARGO COMPARTMENT F3 8.00 BTW L-24R FRAME WITH CORROSION. (K)SDR CALA0800832Frame · crackedLEFT FRAME IS CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 827 BETWEEN STRINGERS 8 AND 9. ACCOMPLISHED AIR CONDITIONING (A/C) FUSELAGE CRACK INTERIM REPAIR AT STATION 827 PASSENGER SERVICE UNIT ATTACH BRACKETS BETWEEN S-8 TO S-9 PERSDR SWAA084709Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084708Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084707Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084706Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084697Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907,STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084696Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400,STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084695Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907,STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084694Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867,STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084693Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800831Frame · crackedLEFT FUSELAGE FRAME STATION 787 IS CRACKED BETWEEN STRINGERS 8L AND 9L. REPAIRED FRAME PER EA 5310-04498 OP 2.SDR CALA0800829Frame · crackedLEFT FRAME CRACKED AT FASTENER FOR AIR GRILL SUPPORT RAIL MOUNT LOCATED AT STATION 440 BETWEEN STRINGERS 8 AND 9. REPAIRED FRAME PER EA 5310-04498, OP 02.SDR ASAA0843459Frame · crackedBODY STA 616 FRAME LT SIDE INNER CHORD IS CRACKED BELOW FLOOR WL 202. REMOVED DAMAGED AREA, FABBED FILLER AND STIFFENING ANGLES AND INSTALLED REPAIR PARTS IAW ASA EO 5310 02528.
Back to JASC 5311