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 COEA0702901Frame · crackedIN HEAVY CHECK IN COE PERFORMED PERMENANT REPAIR TO CRACK ON RT HYDRAULIC LINE CUTOUT AT FRAME 25. COMPLIED WITH PERMENANT REPAIR IAW SB ATR42-53-0121. WO 69645 NR 903003 (K)SDR 2007UALA02922Frame · dentedAFT PIT FRAME DENTED AT STA 1480 AND STR 25L. MAJOR REPAIR ACCOMPLISHED: ROUTED OUT DAMAGED AREA. FABRICATED AND INSTALLED REPAIR ANGLE.SDR CALA0700381Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 1006 FROM S25R TO 26L. THE CORRODED SECTION OF FRAME WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-07, FIGURE 201, REPAIR 1.SDR 07FDEA02647Frame · crackedFRAME FITTING C36 (STA 1976) IS CRACKED AT RBL 60 (-Y 15200) FWD PIT FLOOR LEVEL. [08-09-07] REMOVED AND REPLACED FRAME FITTING IAW A310-200 SRM 51-40-21 PAR 6.SDR 07FDEA02646Frame · crackedFRAME FITTING C38 (STA 2082) IS CRACKED AT RBL 69 (-Y1520) FWD PIT, FLOOR LEVEL. [08-06-07] REMOVED AND REPLACED FRAME FITTING AT C38 IAW A310-200 SRM 51-40-20.SDR KCSA071264Frame · crackedLEFT FUSELAGE FRAME WEB AT FLOOR INTERCOSTAL IS CRACKED AT STA 1265, BETWEEN STR 23L AND 27L.SDR USAA920070794Frame · crackedPIT - C4 CHECK, CRACKED FRAME, BS 1070, BL 65. REPLACED FRAME, BS 1070, BL 65 IAW B757-200 SRM 51-40-02.SDR COEA0703912Frame · damagedIN HEAVY CHECK AT COE, FOUND TOOLING DAMAGE ON FUSELAGE FRAME 42 AFT PRESSURE BULKHEAD RT LWR DOUBLER. DAMAGE DOUBLER CUT AWAY AND SPLICE PERFORMED IAW ATR SRAS DO/TS-2637/07 4169. (K)SDR KCSA071261Frame · crackedFUSELAGE FRAME FLANGE IS CRACKED AT STA 460, BETWEEN STR 26R AND 30R.SDR K11A2008121272013Frame · corrodedCORROSION ON FRAME WEB AFT SIDE.SDR DHL2007741553Frame · dentedAFT PIT, BS 990 AT STR 26L, FRAME DENTED. CUT OUT DAMAGED AREA, DIMENSIONS 1.0 BY .625; FABRICATED REPAIR DOUBLER FROM 7075-T0, .071 BY 10 BY 4.25, PO NR 9004690, PER B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. HEAT TREATED DOUBLER TO T-6 CONDITION PER FASI SDR DHL2007741551Frame · dentedAFT PIT, BS 950C AT STR 26R, FRAME DENTED AT UPPER CAP. CUT OUT DAMAGED AREA, DIMENSIONS 2.125 BY 1.187; FABRICATED REPAIR DOUBLER FROM 7075-T0, .071 BY 25 BY 4.0, PO NR 9004690, PER B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. HEAT TREATED DOUBLER TO T-6 CONDSDR DHL2007741540Frame · dentedAFT PIT, BS 1030 FRAME DENTED BETWEEN STR 25L AND 26L. CUT OUT DENTED AREA, 1.5" BY .875", FABRICATED REPAIR DOUBLER FROM 7075-T0, .071" BY 11" BY 4", PO NR 9004690, PER B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. HEAT TREATED TO T-6 CONDITION PER FASI ER NR 2SDR DHL2007741538Frame · corrodedBS 420, CORROSION NOTED SURROUNDING THE AFT E-BAY DOOR LOCKING PIN FITTING ON FRAME. REMOVED FRAME SECTION, FABRICATED FRAME FROM 7075-T0, .063" BY 7" BY 24", PO NR 9005314, PER B727 SRM 53-10-2 FIG 5 AND 51-20-1 FIG 3. HEAT TREATED MAT TO T6 CONDITION PER FSDR TRAX200701062Frame · corrodedFS 333 FRAME CORRODED AT BL 0.0. WET INSTALLED FRAME AT STA 333, INSTALLED FASTENERS THROUGH OUTER SKIN. SUPPLEMENTAL - SDR CLOSED 08/06/07.SDR DHL2007741517Support · corrodedSTRINGER 26R TO BS 720C FRAME SUPPORT CLIP CORRODED. REMOVED CLIP, FABRICATED NEW CLIP FROM 2024-T3, .040" BY 4" BY 3.25", PO NR 9005138, PER B727 SRM 53-10-2 FIG 3, 51-10-3, AND 51-20-1. TREATED, PRIMED, AND INSTALLED STRINGER CLIP PER B727 SRM 51-10-2 AND SDR SWAA073683Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073711Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073695Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073681Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073698Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073693Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073701Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073684Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073685Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073710Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073713Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073704Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073692Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073712Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073691Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073703Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073702Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073697Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073682Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073696Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073680Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073694Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073700Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073699Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR TRAX200701061Frame · corrodedFS 349 FRAME IS CORRODED AT BL 0.0. [08-06-07] WORK COMPLETED IN ACCORDANCE WITH: SRM 51-42-21, 51-42-06, 51-41-02, 51-21-06, 51-40-11, 51-42-02, 51-21-11, 51-23-00, AND 12-21-00.SDR 07FDEA02635Frame · crackedFRAME FITTING C33 IS CRACKED AT RBL 60 FWD PIT FLOOR LEVEL. 08-30-07 REMOVED SLANTE PANEL 132JW, XY GUIDE, RAILS, TRANSITION PANEL TO FOM. REMOVED FITTING, RECEIVED NEW FITTING A5377364420100 PO 582198.2. LOCATED AND DRILLED FITTING IAW A310 SRM 51-40-4SDR 07FDEA02632Frame · corrodedT-CAP IS CORRODED ON END AT FRAME 38.2 RBL60. [08-17-07] FABBED AND REMOVED AND REPLACED T-CAP, A310-22-00 SRM 53-10-00, 53-10-15, 51-74-10.SDR CALA0700376Frame · corrodedINSPECTION FOUND FRAME CORRODED AT STA 847, S25R TO S26R. THE FRAME WAS REPLACED IAW SRM 51-40-02.SDR KCSA071256Bulkhead · corrodedSTA-1475 CENTER BULKHEAD AFT CORNER HAS CORROSION.SDR 2007UALA02827Frame · damagedFRAME DAMAGE AT STA 420, ACROSS STRINGER BAYS 28L-28R, AND 27R-28R. [08-21-07] MAJOR REPAIR: REMOVED DAMAGE. REPAIR ACCOMPLISHED.SDR AMWA06032EFrame · chafedFUSELAGE FRAME DAMAGED BY FRICTION CHAFING. REPAIRED IAW AIRCRAFT ENGINEERING REPORT 6799-1 REV 1R.SDR AMWA06032DFrame · chafedFUSELAGE FRAME DAMAGED BY FRICTION CHAFING. REPAIRED IAW AIRCRAFT ENGINEERING REPORT 6799-1 REV 1R.SDR AMWA06032CFrame · chafedFUSELAGE FRAME DAMAGED BY FRICTION CHAFING. REPAIRED IAW AIRCRAFT ENGINEERING REPORT 6799-1 REV 1R.SDR AMWA06032UFrame · chafedFUSELAGE FRAME DAMAGED BY FRICTION CHAFING. REPAIRED IAW AIRCRAFT ENGINEERING REPORT 6799-1 REV 1R.
Back to JASC 5311