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 QXEA2011050500311Frame · corrodedCOE - C4 - INTERNAL FUSELAGE UNDERFLOOR AT STA X341.000 AND BETWEEN STR 31 TO 32 LT FRAME ANGLE HAS SURFACE CORROSION. BLENDED OUT CORROSION, FOUND TO BE WITHIN LIMITS AND COMPLETED REPAIR IAW RD 8/4-53-2344.SDR QXEA2011050500309Frame · corrodedCOE - C4 - INTERNAL FUSELAGE UNDERFLOOR AT STA X196.000 FRAME ANGLE BETWEEN STRINGERS 31 TO 32 LT HAS SURFACE CORROSION. BLENDED OUT CORROSION, FOUND TO BE WITHIN LIMITS AND COMPLETED REPAIR IAW RD 8/4-53-2344.SDR IPXA11566907Frame · chafedINSPECTION TYPE:C3, CHAFE IN FRAME FLANGE AT BS 377, BETWEEN STR 22R AND 23R REPAIRED IAW ATS ER 11-02743.SDR DALA1134119863Frame · crackedAFT ACCESSORY STA 1209 RIGHT LONG 10 FRAME WEB CRACKED 3 EA PLACES. GAINED ACCESS, REMOVED DAMAGED WEB, RECEIVED MATERIAL FOR REPAIR .040 7075T6 FORMED, LOCATED, DRILLED, DEBURRED, ALODINED AND PRIMED NEW WEB PER DC9 51-70-4 FIG 2 AND ERA491736-14, INSTALLED SDR GLBA20110503FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND A CRACK IN CARGO DOOR FUSELAGE FWD FRAME AT F.S. 456, AT THE UPPER IB NUTPLATE AREA AT THE LONG GAS STRUT MOUNT, 1" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUISDR CALA2011050400336Frame · crackedSUPPORT TASK - FRAME CRACKED STA 867 RT BETWEEN S-8 S-9 AT BRACKET. REPAIRED FRAME IAW EA 5310-04716 REV B STEP 9.0 AND FIG 3.SDR CALA2011050300335Frame · crackedSUPPORT TASK: RT BODY STA 380 R SHOW CRACK BOTH FASTENER FOR SUPPORT BRACKET EA 5310-04716. (MFEC) REPAIRED FRAME RT STA 380 R AT BRACKET IN REF TO EA 5310-04716 REV C.SDR GLBA20110502JFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND TWO CRACKS, FRAME AT F.S. 273.25 AND STRINGER 10L AND IN T-FRAME AT SAME LOCATION, .7" AND .9" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS ISDR DALA1133340623Frame · chafedMAIN CABIN FRAME AFT LIP CHAFED ST 377.7 BETWEEN STR 5/6 LT COMPLIED WITH AT SAA IN SAT ON W/O 87238570001 N/R 176359. PER ER/A 491562-14 REV ORIGINAL.SDR GLBA201120110502HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND FUSELAGE FRAME AT F.S. 456 AND STRINGER 10R CRACKED AT STRINGER CUTOUT, .3" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53SDR CALA2011050200330Frame · crackedSUPPORT TASK RT BODY STA 500C SHOW CRACK AT I/B FASTENER FOR SUPPORT BRACKET (MFEC) EA 5310-04716 REV C. INSTALLED REPAIR ON RT BODY STA 500C FOR SUPPORT BRACKET IAW EA 5310-04716 REV C.SDR DALA1133350623Frame · dentedFWD CARGO FRAME DENTED TWO PLACES STA 560 ABOVE STR 24L REJ SRM 53-00-07 REPAIR 5 IS NOT APPLICABLE AT STA 560 4/3/11. COMPLIED WITH AT SAA IN SAT ON W/O 87238280001 N/R 173334. ER/A 491547-14 REV ORIGINAL.SDR SWAA113326Frame · crackedDURING SCHEDULED 24Y CHECK FOUND CRACK ON ELECTRICAL COMPARTMENT, FRAME, AT BS 328 BETWEEN STR 20R AND STR 21R. REPAIRED PER DOC.SDR CALA2011050200329Frame · crackedCABIN PSU RAIL RT SIDE AT STA 1580, ATTACH BRACKET HAS CRACK MIGRATING FROM RIVET ON FRAME CUT DAMAGED SECTION , ASSEMBLED AND DRILLED REPAIR PARTS, TREATED, PRIMED, AND INSTALLED REPAIR PARTS REF SRM 53-00-07 REPAIR 1 AND SRM 51-40-02.SDR TAMF201104300090Frame · crackedDURING SC4 CK WAS FOUND 2 CRACKS ON FRAME WEB BS 1285, STR 33-35 LT. REPAIR WAS PERFORMED WITH EWO 767-53-137.SDR USAA2011051891892Frame · crackedCLT - Q2 - CRACK ON FRAME WEB DOUBLER AT BS 303.9, S16L. REPAIRED FRAME WEB DOUBLER AT BS 303.9, S16L IAW BOEING DRAWING 65-17684.SDR USAA2011051791871Frame · crackedCLT - Q2 - CRACK IN FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA113300Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND CRACK LT STA 727 FRAME, AFT SIDE OF WEB. REPAIRED PER SRM.SDR PCSA2011082515Frame · dentedFUSELAGE FRAME BS 380 S5R-S7R DENTED. REPLACED FRAME SECTION.SDR PCSA2011082513Frame · dentedFUSELAGE FRAME BS 440 S15L-S17L DENTED. REPLACED DENTED FRAME SECTION.SDR PCSA2011082512Frame · dentedFUSELAGE FRAME BS 420 S15L-S17L DENTED. REPLACED DENTED FRAME SECTIONSDR PCSA2011082511Frame · dentedFUSELAGE FRAME BS 360 S15L-S17L DENTED. REPLACED DENTED FRAME SECTION.SDR PCSA2011082510Frame · damagedFUSELAGE FRAME BS 360 S3L-S9L DAMAGED. REPLACED DAMAGED FRAME SECTION.SDR PCSA2011082507Frame · corrodedFRAME ST BS 1110 S24L-S28L CORRODED. REPLACED FRAME SECTION.SDR PCSA2011082506Frame · dentedFRAME REPAIR AT BS 580 S20L-S26L DENTED. REPLACED FRAME SECTION.SDR PCSA2011082505Frame · dentedFRAME REPAIR AT BS 560 S20L-S26L DENTED. REPLACED FRAME SECTION.SDR PCSA2011082504Frame · dentedFRAME REPAIR AT BS 520 S20L-S26L DENTED. REPLACED FRAME SECTION.SDR PCSA2011082501Angle · damagedFRAME REINFORCEMENT ANGLE BS 1130 S27L-S27R DAMAGED. REPLACED DAMAGED SECTION.SDR DALA1133240623Frame · corrodedAFT CARGO FRAME CORRODED ON FWT AND AFT SIDE AND BELOW FAIL SAFE CHORD STR 29R TO 28L STA 1460. C/W AT SAT ON W/O 87240130001 N/R 202787.SDR AALA20110429TUL02Frame · corrodedCORROSION ON LOWER FRAME FLANGE AT STATION 1309 BETWEEN LONGERONS 29 RIGHT AND 29 LEFT. REMOVED DAMAGED SECTION AND INSTALLED J-ANGLE REPAIR PER AARD 53-10-00-17 AND EA MD80-53-016655.SDR AALA20110429TUL01Frame · corrodedCORROSION ON FRAME LOWER FLANGE STATION 1309 BETWEEN LONGERONS 29 LEFT AND 29 RIGHT. INSTALLED J-ANGLE REPAIR DOUBLER PER AARD 53-10-00-17 AND EA MD80-53-016655 DATED 4-27-2011.SDR USAA2011051791880Frame Splice · crackedCLT - Q2 - CRACK IN FUSELAGE FRAME SPLICE AT BS 500 BETWEEN S13R TO S14R. REPAIRED FUSELAGE FRAME SPLICE AT BS 500 BETWEEN S13R TO S14R IAW EA 102918.SDR IPXA1566645Frame · dentedINSPECTION TYPE:C1, AFT CARGO COMPARTMENT STA 1240 BETWEEN STR 23L AND 24L FRAME IS DENTED ON INBD FLANGE. CUT OUT DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLE AND STRINGER CLIP IAW SRM 53-00-07-2R 5, DETAIL III, EA 11044 IR.SDR SWAA113289Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACK ON RT SIDE OF FLIGHT CREW COMPARTMENT FRAME, BS 188, STR 17R. REPAIRED PER SRM.SDR SWAA113288Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CRACK, BS 986.5, STR 25L. REPLACED STR PER SRM.SDR SWAA113283Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACK, RT SIDE OF PASSENGER CABIN, BS 639. REPAIRED PER DOC.SDR AALA20110430TUL02Frame · crackedAFT ACCESSORY 1418 FRAME CRACKED LONGERON 2 LEFT. INSTALLED DOUBLER ON FORWARD SIDE OF STATION 1418 LONGERON 2 LEFT PER SRM 53-03-00. INSTALLED DOUBLER ON AFT SIDE OF 1418 FRAME AT LONGERON 2 LEFT PER AARD 53-10-00-15, SRM 53-01-00 AND SRM 53-03-00.SDR AALA20110428TUL02Frame · crackedCRACK AT STATION 1400 STRINGER 26 LEFT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-07-2R 5.SDR AALA20110428TUL01Frame · corrodedCORROSION ON FRAME LOWER FLANGE STATION 1271 LONGERON 30 RIGHT. INSTALLED J-ANGLE REPAIR DOUBLER PER AARD 53-10-00-14.SDR ASOA201100850Frame · corrodedAVIONICS COMPARTMENT AT FS 310.00 BETWEEN STR 26L AND STR 27 HAS A SMALL AREA OF CORROSION. COMPLIED WITH REO 670-53-21-693 STEPS 1-5SDR SWAA113186Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA113165Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME STUB BEAM CHORD CRACKED AT BS 616, LBL 65. REPAIRED CHORD PER EA.SDR USAA2011051791881Frame · crackedCLT - Q2 - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA113302Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, CORROSION AFT CARGO COMPARTMENT ON FRAME STA 787 AND BETWEEN STR 25L TO STR 26L. REPAIRED PER SRM.SDR SWAA113243Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND CRACK ON BODY FRAME, CENTER SECTION PAX COMPARTMENT BS 597, STR 17L. REPAIRED PER DOC.SDR DALA1129579871Frame · crackedMAIN CABIN RT STA 734 MAIN FRAME CRACKED APPROX 2.5 INCHES. R & R MAIN FRAME, MAIN CABIN RT STA 734 L0R-L18R IAW SRM 51-10-4, 51-30-2, 51-30-5 & 51-30-8. NEW FRAME PN 9923406-502N 26 APR11 P-138 REQUIRED INSP.SDR DALA1139080915Frame · crackedCRACK ON FRAME AT STA 1322 AND LONG 17 RT. REMOVED AND INSTALLED FRABRICATED REPAIR DOUBLER.SDR DALA1139060915Frame · crackedCRACK ON FRAME STA 1322. REMOVED DAMAGE FROM FRAME STA 1322 AND INSTALLED FABRICATED REPAIR DOUBLER.SDR DALA1128899871Frame · chafedAFT ACCESSORY STA 1209, LT LONG 4 VALVE CHAFING INTO PREVIOUS REPAIR ON WEB. REMOVED EXISTING REPAIR IAW SRM51-30-2. FABRICATED NEW DOUBLER .032 7075-T6 IAW SRM 53-01, FIG 4. TREATED AND PRIMED IAW SRM 51-10-3. INSTALLED DOUBLER IAW SRM 53-01, FIG 4, 51-30-SDR SWAA113140Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20 TO STR 21R. REPAIRED FRAME PER EA.
Back to JASC 5311