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 SWAA072593Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 994.5, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA072621Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 13L. REPAIRED FRAME PER ER.SDR SWAA072607Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT LEFT BS 639, WL 208. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072590Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072591Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072592Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072602Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, LBL 33, WL 208. REMOVED AND REPLACED CHORD PER SRM.SDR CALA0700257Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 312, RBL 2, S27R-28R. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-00-07, FIGURE 201, REPAIR 1.SDR CALA0700255Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 312, S28L. A REPAIR DOUBLER WAS INSTALLED IAW SRM 51-40-02 AND 53-00-07.SDR DHL2007740510Frame · corrodedCORROSION ON FRAME SHEAR TIE BS 580 BETWEEN STR 28R-28L. FOUND CRACK IN SHEAR TIE IAW B727 SRM 51-10-1. FAB`D NEW SHEAR TIE FROM 7075-0 .071" PO NR 9004690. DIM 2 1/4" BY 5" IAW B727 SRM 53-10-4 FIG 15 AN B727 SRM 53-10-2 FIG 3. HEAT TREAT PART FROM 7075-0SDR 07FDEA01920Frame · damagedMAIN DECK CARGO COMPARTMENT, RIGHT MAIN FRAME STA 1661 EXISTING REPAIR DOUBLER AT LONGERON 12R FOUND DAMAGED. MAIN DECK CARGO COMPARTMENT, RIGHT FUSELAGE MAIN FRAME AT STA 1661. DAMAGED EXISTING REPAIR DOUBLER AT LONGERON 12R REMOVED AND REPLACED. REPAIR SDR 07FDEA01919Frame · damagedMAIN DECK CARGO COMPARTMENT, LEFT MAIN FRAME STA 1661 EXISTING REPAIR DOUBLER AT LONGERON 12L FOUND DAMAGED. MAIN DECK CARGO COMPARTMENT, LEFT FUSELAGE MAIN FRAME STA 1661 DAMAGED EXISTING REPAIR DOUBLER AT LONGERON 12L REMOVED AND REPLACED. REPAIR CARRIEDSDR SWAA072553Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA072560Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072552Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072564Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R AND 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072566Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072563Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072567Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072568Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072556Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072565Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072570Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER ACO.SDR SWAA072554Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072562Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R AND 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072561Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072528Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072527Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072513Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA01855Frame · dentedAFT PIT STA 1130, LBL 25, STR. 26, FRAME IS DENTED CUT OUT DAMAGE, FABRICATED REPAIR ANGLE FROM 7075-0 .063 AND HEAT TREATED TO 7075-T-6 INSTALLED REPAIR ANGLE REF SRM 51-40-03.SDR 07FDEA01849Frame · dentedAFT CARGO PIT RT SIDE STA 1050 STR 25R FRAME IS DENTED DETERMINED DENT TO BE OUT OF LIMITS, PER SRM 53-10-01. FABRICATED REPAIR PARTS, TREATED AND PRIMED AND INSTALLED REF SRM 51-40-3 FIG 1, SRM 51-30-02.SDR CALA0700253Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN LEFT MAIN FRAME AT STA 616, S17L, BELOW MAIN DECK FLOOR. THE FRAME WAS REPAIRED IAW ECRA 5311-01158.SDR SIMA200720005Frame · damagedTHREE FASTENER HOLES MISDRILLED ON FRAME 64AT STRINGER 11R. REAMED HOLES AND INSTALLED OVERSIZE FASTENERS IAW EMB. RETURNED AIRCRAFT TO SERVICE.SDR NWAA071996739Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME AT BS 2000 FROM S11R TO S12R. REPAIRED PER EA 67-209715.SDR SWAA072500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072501Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072499Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072502Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072498Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072497Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA01829Latch · corrodedNR 4 MAIN CARGO DOOR LATCH SPOOL BOLT HOLES HAVE CORROSION. REAMED ALL 4 BOLT HOLES AT NR 4 LATCH SPOOL LOCATION TO .460 IAW DC10 SRM 53-50-00 FIG 17 VOLI. NO FURTHER EVIDENCE OF CORROSION REMAINS.SDR 07FDEA01828Frame · dentedFWD PIT FRAME, STA 720 DENTED BETWEEN STRINGER 23-24R REMOVED DAMAGE SECTION OF FRAME REF SRM 53-10-4 FIG 1. FABRICATED REPAIR PARTS REF SRM 53-10-4 FIG 1. DRILLED REPAIR PARTS REF 51-10-4, AND INSTALLED NEW REPAIR PARTS REF SRM 53-10-4 FIG 1.SDR 2007UALA01545Frame · dentedFWD CARGO STA 600 LEFT SIDE FRAME DENTED STR 24L. [06-14-07] MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE SKIN, REPLACED PRODUCTION SLICE AND REPAIRED DAMAGED AREA PER UA ENGINEERING SPECIFICATIONS.SDR 2007UALA01544Frame · dentedAFT CARGO STA 1420 LEFT SIDE FRAME HAS A DENT STR 27L. [06-14-07] MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE SKIN AND INSTALLED REPAIR ANGLE PER UA ENGINEERING SPECIFICATIONS.SDR ABXA070160Frame · crackedFOUND FRAME CRACKED DURING WINDOW FRAME MOD EA 53300036, REF AD 2002-21-09. REPAIRED FRAME IAW DC9 SRM 53-03 FIG 34.SDR ABXA070158Frame · crackedFOUND CRACKED FRAME DURING WINDOW FRAME MOD EA 53300036, REF AD 2002-21-09. INSTALLED REPAIR IAW DC9 SRM 53-03 FIG 34.SDR ABXA070161Frame · crackedFOUND CRACKED FRAME DURING WINDOW FRAME MOD EA 53300036, REF AD 2002-21-09. REMOVED AND REPLACED FRAME IAW DC9 SRM 51-30-02.SDR CALA0700252Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN FORWARD CARGO DOOR CUTOUT FORWARD FRAME AT LOWER STOP PAD, STA 400, S17R TO S28R. A NEW FRAME WAS INSTALLED IAW SRM 51-10-02 AND 51-40-00.SDR 2007UALA01516Frame · dentedAFT CARGO STA 1440 LEFT SIDE FRAME HAS DENT STR 25L. [SUP 06-06-07] MAJOR REPAIR ACCOMPLISHED. SPLICED IN DOUBLER REPAIR, THIS IS A TIME LIMITED REPAIR FOR 12 MONTHS FROM 08 MAY07 UNLESS A NEW FAA 8100-9 IS ISSUED PRIOR TO THAT TIME IN COMPLIANCE WITH 14 CSDR 07FDEA01814Frame · corrodedLT AIR CONDITION COMPT SEVERE CORROSION WITH EXFOLIATION ON FRAME AT STA 495 X=28, REPAIR IAW SRM 53-00-01 FIG 8 VOL 1.
Back to JASC 5311