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 SWAA093832Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 13R. REPAIRED FRAME PER AAR EA.SDR FDEA200906102016Frame · damagedFRAME AT BS 1120, BETWEEN S3L/3R, HAS NUMEROUS MISDRILLED HOLES. CUTOUT AND REMOVED FRAME SECTION IAW SRM 53-00-07, FIG 201, REPAIR 1. REMOVED 2 CLIPS IAW SRM 51-40-02. FABRICATED FRAME SECTION , FABRICATED CHANNEL NR 1, FABRICATED CHANNEL NR 2 AND FABRICATESDR ASAA0946122Frame · crackedFRAME CRACKED AT STA 440 BETWEEN STR 8L AND 9L. REPAIRED FRAME AT 440 LT IAW EA.SDR ASAA0946121Frame · crackedFRAME CRACKED AT STA 727F BETWEEN STR 8L AND 9L. REPAIRED FRAME AT 727F IAW EA.SDR ASAA0946119Frame · crackedFRAME CRACKED AT STA 440 BETWEEN STR 8R & 9R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0946118Frame · crackedFRAME CRACKED AT STA 867 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED.SDR SWAA093749Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 291, WL 233, RT SIDE. REPAIRED FRAME PER SRM.SDR FDEA200906091992Frame · corrodedFOUND CORROSION ON REAR SLANTING FRAME AT C53, P 41-42. REPAIR PERFORMED BY REWORK OF CORROSION AND NDT FOR CORROSION FREE CONDITION IAW. RAS 70521674/009/2009 ISS. A, APPROVED BY EA 6-5310-120193.SDR C8GA20090169Frame · damagedWHILE IN HEAVY MX PERFORMING INSP, IT WAS NOTED THAT THE FRAME LOCATED AT BS 380 BETWEEN STRINGER 5L AND 6L HAS A HOLE DRILLED IN THE RADIUS. DAMAGED AREA WAS REMOVED DIM .375 INCH X .375 INCH. FABRICATED ANGLE REPAIR FROM 7075 T6 .063 INCH DIM 7.5 INCH X 3.SDR C8GA20090164Frame · bentWHILE IN HEAVY MX PERFORMING INSP IT WAS NOTED THAT THE FRAME AT BS 970 ABOVE 26L IS BENT. DAMAGED AREA WAS REMOVED DIM 1 INCH X .625 INCH. FABRICATED REPAIR DOUBLER FROM 7075-0 .071 INCH DIM 5.25 INCH X 12 INCH AND HEAT TREATED TO T6. INSTALLED REPAIR, NO OSDR C8GA20090163Frame · bentWHILE IN HEAVY MX PERFORMING INSPECTIONS, IT WAS NOTED THAT THE FRAME AT BS 990 ABOVE 26 L IS BENT. DAMAGED AREA WAS REMOVED DIM 1 INCH X .5 INCH. FABRICATED REPAIR DOUBLER FROM 7075-0 .063 INCH DIM 12 INCH X 4.5 INCH AND HEAT TREATED TO T6. INSTALLED REPAISDR C8GA20090162Frame · bentWHILE IN HEAVY MX PERFORMING INSP IT WAS NOTED THAT FRAME AT BS 1050 ABOVE 26 R IS BENT. DAMAGED AREA WAS REMOVED DIM 1 INCH X .75 INCH. FABRICATED REPAIR DOUBLER FROM 7075-0 .063 INCH DIM 12 INCH X 12 INCH AND HEAT TREATED TO T6. INSTALLED REPAIR, NO OTHER SDR CA090622004Tube Frame · cracked(CAN) SYR INSP REQUREMENT - FOUND LARGE CRACK IN BIRD CAGE TUBULAR STRUCTURE.SDR ASAA0946132Frame · crackedFRAME CRACKED AT STA 480 BETWEEN STR 8 AND 9 LT. REMOVED DAMAGED AREA FABBED REPAIR PARTS AND FILLER AND INSTALLED REPAIR IAW EA.SDR ASAA0946112Frame · crackedFUSELAGE FRAME AT STA 480 BETWEEN STR 8R AND 9R IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED REPAIR PARTS.SDR ASAA0946109Frame · corrodedAFT PIT FRAME AT STA 847 IS CORRODED ON UNDERSIDE OF LOWER BETWEEN STR 26R AND INTERCOSTAL OB OF STR 26. REMOVED DAMAGED AREA FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0945999Frame · dentedAFT PIT FRAME, STA 747, DENTED UPPER FLANGE BETWEEN STR 22R 23R. REMOVED DAMAGED FLANGE FABRICATED LOCATED AND DRILLED TREATED PRIMED TOP COATED AND INSTALLED REPAIR IAW SRM.SDR AALA20090609TUL50Frame · crackedFRAME CRACKED. REPAIRED PER EA MD80-53-006456.SDR SWAA093739Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 13L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA093728Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA093726Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093717Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093716Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093715Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR MALA090082Frame · corrodedDURING N4K & 2Y CHECKS IN CWA, CORROSION NOTED ON GALLEY FRAME AT STA 272. REPAIRED IAW S53108.SDR FDEA200906081953Frame · damagedFRAME AT BS 1100, BETWEEN S3L/ S3R, HAS NUMEROUS MIS-DRILLED HOLES. CUTOUT AND REMOVED FRAME SECTION AT BS 1100, BETWEEN S5L-S5R, REMOVED 2EA. H- CLIPS IAW ARM 53-00-07, FIG. 201, REPAIR NR1 AND 51-40-02. FABRICATED FRAME SECTION ON MAE TRAVELER NR T9/79411SDR ZZDA2009188Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR ZZDA2009187Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2976.SDR DL757091169Frame · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE FRAME AT STA 1400 HAS CORROSION S26L TO S26R / REPLACED FRAME AT SAA SAT DURING HMV ON N/R CARD 118452SDR SWAA093694Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 400, STR 14L. REPAIRED FRAME PER ER.SDR SWAA093695Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 767, STR 14L. REPAIRED FRAME PER ER.SDR SWAA093697Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR SWAA093696Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR UALA2009060801631Frame · damagedFWD PIT STA 540 MAIN FRAME BETWEEN STR 24L AND 25L HAS 1 DENT. OK - GSO 63998: 41 21013 9833-04-1. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR.SDR USAA2009062691608Frame · corrodedSAL - MAJOR REPAIR - Q3 CHECK - LEVEL 2 CORROSION ON FRAME AT BS 727G, S26L - S27L. REPAIRED FRAME AT BS 727G, S26L - S27L IAW B737 SRM 53-00-07 REPAIR 5.SDR EIAA20090063Frame · crackedMAIN DECK LT SIDE WALL BS 2180 S 25L FRAME CRACKED. REPAIRED AS PER SRM 53-30-029 AND 53-10-04.SDR SWAA093670Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER ER.SDR USAA2009060891434Frame · crackedSAL - MAJOR REPAIR - C19 CHECK - CRACKED FRAME AT BS 303.9, S16L. REPAIRED FRAME AT BS 303.9, S16L IAW US AIRWAYS TASK CARD M1C53001.SDR ZZDA2009185Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR ZZDA2009184Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2985.SDR WX0A070323Frame · cracked1474 CANT FRAME CRACKED AFT OF STA L18LSDR ZZDA2009181Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR ZZDA2009180Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR ASAA0995824Frame · corrodedBS 500L LBL 21-24 FRAME IS CORRODED AT FASTENER. REPAIRED FRAME AT BS 500L LBL 21 24 IAW SRM.SDR SWAA093645Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA093646Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SRM.SDR FDEA200906041922Frame · gougedFOUND A GOUGE IN OUTER FLANGE OF FRAME 47 NEAR P26 LT. REPAIR PERFORMED BY REWORK OUTER FLANGE AT RUN OUT TO ELIMINATE THE GOUGE AND NDT FOR CRACK FREE CONDITION IAW. RAS/EFW/9000182/2009 ISS. A, APPROVED BY EA 6-5310-131203.SDR FDEA200906041918Frame · damagedHOLES "K" AND "I" HAVE INDICATIONS IN THE SECOND LAYER. CLOCK POSITIONS ARE 7 FOR HOLE "I" AND 4 FOR HOLE "K" RT SIDE. CLEANED AND REMOVED SEALANT FRM HOLE "K" RT SIDE BY POLISHING IAW SRM 51-73-10 PERFORMED BHEC INSP. OF HOLE "K" RT SIDE IAW NTM 51-10-01. NO SDR FDEA200906041913Frame · damagedHOLE "C" ON FR 47 RT CORNER FITTING HAS 2 EA CRACK INDICATIONS IN THE SECOND AND THIRD LAYERS. THIRD LAYER HAS THROUGH HOLE INDICATIONS AT 7 AND 11 O'CLOCK POSITIONS. SECOND LAYER CLOCK POSITION IS 12. ACCOMPLISHED EA NR 6-5710-127960 BASIC WING STRUCTURE - ASDR FDEA200906031907Frame · out of alignmentEXISTING FASTENER HOLES AT STA 980, BETWEEN STR 4L AND 4R WILL INTERFERE WITH THE CABLE SHROUD MOD. REPAIRED FRAME IAW SRM 53-00-07, FIG 201. FABRICATED REPAIR PARTS ON MAE TRAV NR T9/793030, T9/793031, T9/793063, AT STA 980, BETWEEN STR 4L- 4R. CATEGORY "
Back to JASC 5311