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 SWAA080761Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080762Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080746Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080769Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080768Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080770Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080774Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA080776Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 7L. REPAIRED FRAME PER SRM.SDR ZZDA2008078Frame · crackedCRACK NOTICED AFT FUSELAGE INT LEFT CANTED FRAME AREA STA 1178.225 BELOW L16L AFT OF HYD S/O VALVE. INSTALLED ANGLE REPAIR AT LEFT CANTED FRAME STA 1178.225 BELOW L161L, AFT OF HYD S/O VALVE IAW B717 SRM 51-70-11 FIG 201 REPAIR 1. MATERIAL USED 7075-0 .080 SSDR DHL2008752506Frame · dentedAFT PIT STA1130 HAS DENT IN RADIUS OF FRAME AT S-26L. CUTOUT DAMAGED AREA AT AFT CARGO COMP STA 1130 STR 26L DIMENSION 3/4 INCH BY 1/2 INCH IAW B727SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR MATERIAL USED 7075-O .071 PO NR 9006377 DIMENSION 9" BY 4" IAW B727SDR DHL2008752505Frame · dentedAFT PIT STA1130 HAS DENT IN RADIUS OF FRAME AT S-26L. CUTOUT DAMAGED AREA AT AFT CARGO COMP STA 1130 STR 26L DIMENSION 3/4 INCH BY 1/2 INCH IAW B727SRM 51-40-3 FIG1. FABRICATED FRAME REPAIR MATERIAL USED 7075-O .071 PO NR 9006377 DIMENSION 9 INCH BY 4 INCH ISDR USAA920080549Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 907, S9L AND S9R. REPAIRED FRAME BS 907, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080546Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S9L AND S9R. REPAIRED FRAME BS 827, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080545Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 440, S9L AND S9R. REPAIRED FRAME BS 440, S9L AND S9R IAW USAIRWAYS EA 100286.
SDR USAA920080543Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 380, S9R. REPAIRED FRAME BS, 380, S9R IAW USAIRWAYS EA 100286.SDR USAA920080542Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 360, S9L. REPAIRED FRAME BS, 360, S9L IAW USAIRWAYS EA 100286.SDR DHL2008752603Frame · dentedAFT PIT STA1130 HAS DENT IN RADIUS OF FRAME AT S-26L. CUTOUT DAMAGED AREA AT AFT CARGO COMP STA 1130 STR 26L DIMENSION 3/4" BY 1/2" IAW B727 SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR MATERIAL USED 7075-O .071 PO NR 9006377 DIMENSION 9 INCH BY 4 INCHES IAW BSDR USAA920080528Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663.75, S3L - S3R. REPAIRED FRAME, BS 663.75, S3L - S3R IAW B737 SRM 53-00-07-2R9.SDR AALA200800336Frame · corrodedAFW - CARGO FLOOR FRAME J INNER CHORD AT STATION 610 RIGHT BUTT LINE 7 TO 10 IN FORWARD CARGO HAS CORROSION ON BOTTOM SIDE AT NUTPLATE. REMOVED CORROSION FORM AFFECTED AREA PER SRM 59 00 07 1A AND APPLIED ALODINE AND PRIMER. REINSTALLED HARDWARE. SYSTEM GROSDR ZZDA2008072Frame · crackedCRACK NOTICED AT AFT FUSELAGE INT LEFT CANTED BLKD STA 1178.225 L16L AFT OF HYD S/O VALVE. INSTALLED DOUBLE REPAIR AT AFT FUSELAGE INTERNAL LT CANTED BLKD STA 1178.225 L16L IAW B717 SRM 51-70-11 FIG 201 REPAIR 1, MEASURE 12" X 3".SDR DHL2008752604Frame · dentedAFT PIT STA1130 HAS DENT IN RADIUS OF FRAME AT S-26L. CUTOUT DAMAGED AREA AT AFT CARGO COMP STA 1130 STR 26L DIMENSION 3/4" BY 1/2" IAW B727 SRM 51-40-3 FIG 1. FABRICATED FRAME REPAIR MATERIAL USED 7075-O .071 PO NR 9006377 DIMENSION 9" BY 4" IAW B727 SRM 51SDR USAA920080420Frame · crackedCLT - MAJOR REPAIR - Q5 CHECK - AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME CRACKED, BS 800. REPLACED AFT CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME, BS 800 IAW B737 SRM 51-10-02.SDR ABXR080074Frame · crackedFRAME AT STA 1168 AT APPROX 3 O'CLOCK POSITION WAS CRACKED. REPAIRED AREA IAW DC9 SRM 53-01, FIG 2.SDR G60A200800004Frame · corrodedFOUND CORROSION ON FRAME.SDR SWAA080722Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 6R. REPAIRED FRAME PER SRM.SDR SWAA080723Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080713Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080712Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR ABXR080072Frame · crackedFRAME CRACKED STA 1076, LONGERON 14 RIGHT. REPAIRED FRAME IAW DC9 SRM 53-03, FIG 32, SHEET 4.SDR SWAA080702Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA080692Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080691Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080693Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080694Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWIA200819557Frame · crackedSTN 280 AT RBL 9.0 ON LOWER FRAME IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIR PER REO601R 53-11-171 REV D.
SDR SWIA200819556Frame · crackedSTN 682.00 AT LBL 4.0 AND WL47.5 FRAME IS CRACKED, FOUND AT C-CHECK. INSTALLED NEW FRAME ANGLE PER CRJ200 SRM 51-42-06 P 11 AND 51-42-21 P 17.
SDR ABXR080067Frame · corrodedFRAME CORRODED ON AFT SIDE AT STA 350, LONGERON 30. REPAIRED CRACKED FRAME IAW DC9 SRM 53-03.SDR 2008UALA00669Frame · damagedAIRCRAFT RECEIVED DAMAGE TO THE BS 1681 FRAME AT WL 210, NEAR THE THRESHOLD AT DOOR 4R. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR C2XA08TY028Frame · crackedTYS MOD - DURING ROUTINE MX FOUND FRAME 81 CRACKED AT THE 6 O'CLOCK POSITION. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND A/C WAS RELEASED FOR SERVICE.SDR SWAA080680Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 2R AND STR 3R. REPAIRED FRAME PER SRM.SDR SWAA080679Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 13L. REPAIRED FRAME PER SRM.SDR SWAA080660Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080659Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080658Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080657Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR MWEA080024Frame · crackedUPPER BUCKET Z-FRAME LEFT END AT STATION 35.669 IS CRACKED. FABRICATED AND INSTALLED Z-FRAME.SDR MWEA080023Frame · crackedUPPER BUCKET Z-FRAME LEFT END AT STATION 26.666 IS CRACKED. FABRICATED AND INSTALLED Z-FRAME.SDR SWAA080648Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080653Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA080638Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311