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 ASAA0944627Frame · damagedFWD CARGO COMPARTMENT DRILL START ON FRAME. REPAIRED PER ER 09-1870 & EA 400-53EA-00989.SDR ASAA0944623Frame · corrodedCORROSION ON AFT CARGO BAY LOWER AFT FLANGE OF FRAME ANGLE. REMOVED AND REPLACED FRAME ANGLE.SDR CALA2009030600126Frame · damagedFBB RT WS 500D AT STRINGER 25R HAS DAMAGE. COMPLIED WITH EC/RA 5310-04909 ON FRAME REPAIR AT STA 500D AT STR 24RT TO STR 25RT.SDR FDEA200903050849Frame · crackedDEFECT TRANSFERED FROM NRC N00340, DURING REMOVAL RAIL CHANNEL ON CENTER CARGO COMPT FOUND CRACK AND CORROSION OUT OF LIMIT ON CTR DOOR JAMB. REPAIRED AREA IAW EA 8-5310-128537.SDR USAA2009041390869Frame · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON FUSELAGE FRAME LOWER FLANGE AT BS 847 BETWEEN S28R TO S28L. REPAIRED FUSELAGE FRAME LOWER FLANGE AT BS 847 BETWEEN S28R TO S28L IAW US AIRWAYS EA 132324.SDR USAA2009032590686Frame · crackedCLT - MAJOR REPAIR - Q4 CHECK - CRACKED FRAME AT BS 500C, S20R - S21R. REPAIRED FRAME AT BS 500C, S20R - S21R IAW US AIRWAYS EA 100962.SDR USAA2009032590682Frame · crackedCLT - MAJOR REPAIR - Q4 CHECK - CRACKED FRAME AT BS 500F, S20L - S21L. REPAIRED FRAME AT BS 500F, S20L - S21L IAW US AIRWAYS EA 100961.SDR USAA2009032090637Frame · crackedCLT - Q4 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW US AIRWAYS EA 100965.SDR ASAA0944609Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE FOR A/C BRACKET. REPAIRED CRACKED FRAME.SDR AALA20090317TUL07Frame · crackedSTATION 1474 CANTED FRAME CRACKED AT LONGERON 18L. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-15.SDR AALA20090317TUL02Frame · crackedSTATION 1510 CANTED FRAME CRACKED LEFT SIDE BETWEEN UPPER AND LOWER TAIL CONE LATCHES. INSTALLED DOUBLER PER EA MD80-53-005621.SDR EIAA20090047SUPFrame · damagedUPPER DECK FRAME BS 660 HAS 15 MISDRILLED HOLES. REAMED 13 TO ALLOWABLE LIMITS PER B747 SRM 53-10-01 FIG 1. REMOVED, FABBED AND INSTALLED REPLACEMENT CHORD LWR STA 660 RBL 80 PER B747 SRM 51-40-01 FIG 1.SDR EIAA20090047Frame · damagedUPPER DECK FRAME BS 660 HAS 15 MISDRILLED HOLES. REAMED 13 TO ALLOWABLE LIMITS PER B747 SRM 53-10-01 FIG 1. REMOVED, FABBED AND INSTALLED REPLACEMENT CHORD LWR STA 660 RBL 80 PER B747 SRM 51-40-01 FIG 1.SDR DLM88090357Frame · crackedCRACKED FRAME AT STA1174 AND LONG 6 LEFT. REPAIRED PER ERA 473063-14 ON ATS CARD 00538.SDR SWAA091370Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091369Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091368Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091367Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091366Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091365Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA20090304TUL13Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2R. DOUBLER INSTALLED PER SRM 53-01 FIGURE 2 AND EA MD80-53-005611.SDR AALA20090304TUL09Frame · crackedCANT FRAME AT STATION 1510 CRACKED ABOVE MAINTENANCE LIGHT. INSTALLED DOUBLER PER EA MD80-53-00-5606.SDR ASAA0944790Frame · corrodedFRAME STA 727D DENTED AND CORRODED ABOVE STR 25R. REMOVED DAMAGED AREA, FABRICATED, TREATED AND INSTALLED REPAIR ANGLE AND FILLER IAW B737 400 SRM 51 70 11.SDR ASAA0944593Frame · damagedFWD CARGO COMPARTMENT DRILL START IN FRAME. REPAIRED PER SRM 51-70-11.SDR ASAA0944571Frame · chafedFRAME AT BS 601, 3 INCHES ABOVE STR 5 IS CHAFED. REPAIRED FRAME PER SRM.SDR SWAA091348Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR FDEA200903020782Frame · dentedFOUND TOOLING MARKS AT FRAME C 74, NEAR STRINGER P 26 LT. REPAIR PERFORMED BY CUTTING OUT THE DAMAGED AREA, REWORK TO SMOOTH CONTOUR AND NDT FOR CRACKS IAW RAS/EFW/9000138/2008 ISS A, APPROVED BY EA 6-5310-120169.SDR COMA2009030250088Frame · crackedRIGHT 640.00 FRAME CRACKED BETWEEN STR 9 AND STR 12 ON THE AFT DOUBLER. REPAIRED IAW REO 601R-53-61-506, REO 601R-53-61-569, AND REO 601R-53-61-557.SDR AALA20090304TUL11Frame · crackedCANTED FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH AT STATION 1510. INSTALLED DOUBLER PER EA MD80-53-00-5606.SDR UALA2009031000677Frame · corrodedAFT CARGO COMPARTMENT BILGE FRAME CAP AT STA 1197+88 CORRODED AT NUT PLATE AT RBL 44. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW T-CAP (P/N 146T1060-1) CHORD.SDR UALA2009031000676Frame · corrodedAFT BULK CARGO FRAME AT STA 1562 FWD SIDE OF FRAME, BETWEEN STRINGER 39 LEFT AND 39 RIGHT SHEAR TIE WITH DRAIN HOLE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR USAA2009030490509Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK AT FUSELAGE FRAME AT BS 500A, BETWEEN S8R TP S9R. REPAIRED FUSELAGE FRAME AT BS 500A, BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR UALA2009030200677Frame · corrodedAFT CARGO COMPARTMENT BILGE FRAME CAP AT STA 1197+88 CORRODED AT NUT PLATE AT RBL 44. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW 'T' CAP, P/N 146T1060-1 CHORD.SDR UALA2009030200676Frame · corrodedAFT BULK CARGO FRAME AT STA 1562 FWD SIDE OF FRAME, BETWEEN STRINGER 39 LEFT AND 39 RIGHT SHEAR TIE WITH DRAIN HOLE CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA0944527Frame · corrodedCORROSION AFT CARGO BAY LOWER AFT FLANGE OF FRAME AT BODY STA 767 RBL 11.5. REPLACED FRAME FLANGE (ANGLE) PER SRM 53-60-08, 51-40-02 AND 51-40-05.SDR USAA2009031290572Frame · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON SUPPORT FRAME WEB BETWEEN FR69 TO FR70, S23R. REPLACED SUPPORT FRAME WEB BETWEEN FR69 TO FR70, S23R IAW A320 SRM 51-72-11.SDR USAA2009031290571Frame · corrodedSAL - C2 - MAJOR REPAIR - GALVANIC CORROSION ON SUPPORT FRAME WEB BETWEEN FR69 TO FR70, S23L. REPLACED SUPPORT FRAME WEB BETWEEN FR69 TO FR70, S23L IAW A320 SRM 51-72-11.SDR ASAA0944658Frame · dentedFRAME DENTED STA 727G BETWEEN 26R 25R. CUT OUT DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR CHANNEL IAW B737 400 SRM 51 70 11 FIG 1.SDR USAA2009030690522Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 400, S8L. REPAIRED FUSELAGE FRAME AT BS 400, S8L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009030690521Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 440 BETWEEN S8L TO S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR ASAA0944531Frame · crackedBS 986 STR 76 FRAME IS CRACKED AT STRINGER CUTOUT. REPAIRED PER EA 400-53EA-00968.SDR FDEA200902270761Frame · corrodedFRAME BS 1701, S-5/6 LT, SPLICE AREA IS CORRODED. REMOVED CORROSION AT FRAME BS 1701, S-5/6 LT, IAW SRM 53-00-07. FOUND CORROSION REWORK TO BE OUT OF LIMITS PER SRM 53-00-07, FIG 101, DETAIL 2 L=3", W=2", D=.010", MATERIAL REMAINING .070". FABRICATED REPLACSDR FDEA200902270758Frame · puncturedFORWARD CARGO AREA BS 540 STR 22L HAS PUNCTURED FRAME. CUT OUT DAMAGED AREA IAW SRM 51-40-3 FIG. 1. FABRICATED DOUBLER AND FILLER IAW SRM 51-40-3 FIG 1. TREATED AND PRIMED PARTS IAW SRM 51-10-2. INSTALLED DOUBLER AND FILLER IAW SRM 51-40-3 FIG 1.SDR CA090312005Frame · cracked(CAN) WHILE CARRYING OUT A ROUTINE INSP OF THE ACFT, A CRACK WAS NOTICED IN THE AFT FRAME MEMBER OF THE RT FWD EMERGENCY EXIT SURROUND AT THE LWR CORNER (STN X264.1 RHS). THE FRAME MEMBER (P/N 85320534-103) WAS CRACKED FROM THE LIGHTENING HOLE TO THE INNER SURSDR USAA2009040890841Frame · crackedMCN - C1 - MAJOR REPAIR - FRAME CHORD CRACKED AT FORWARD END OF PANEL 195BL, BS 1147 INSIDE LEFT MAIN LANDING GEAR WHEEL WELL. REPLACED FRAME CHORD AT FORWARD END OF PANEL 195BL, BS 1147 INSIDE LEFT MAIN LANDING GEAR WHEEL WELL IAW B757 SRM 51-40-02 & BOEING SDR ASAA0944788Frame · corrodedFRAME UPPER SURFACE CORRODED STA 727G LT. REMOVED CORRODED AREA, FABRICATED, TREATED AND INSTALLED REPAIR ANGLE IAW B737 400 SRM 51 70 11.SDR USAA2009022790465Frame · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON STUB FRAME AT BS 294, WL 208, S17R. REPAIRED STUB FRAME AT BS 294, WL 208, S17R IAW B737 SRM 51-70-11.SDR DU4R2009306Frame · corrodedS/O 312003 N/R 37998 DURING SCHEDULED INSPECTION, FOUND CORROSION ON LEFT A/C BAY DOOR FRAME I/B JUST AFT OF FWD ATTACH POINT.SDR SWAA091322Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR EIAA20090044SUPFrame · damagedUPPER DECK FRAME BS 680 RT SIDE HAS MISDRILLED HOLES. REMOVED, FABBED AND INSTALLED LWR CHORD FRAME PLATES AND STIFFENERS AT UPPER DECK FRAME PER SRM 51-40-04 FIG 1.
Back to JASC 5311