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 ASAA0782260Frame · crackedAFT ACCESSORY COMPT FRAME STA 1418 CRACKED IN RADIUS AT LONG 2R AND LONG 2L. TWO EACH CRACKS PREPARED DAMAGED AREA, STOP DRILLED CRACKS, VERIFIED CRACK TERMINATION IAW MD80 SRM 51-01 PG 9. RECEIVED REPLACEMENT REPAIR PARTS LOCATED, DRILLED AND INSTALLED IAW SDR DHL2007742064Frame · dentedDENTED FRAME AFT PIT BS 1110 ABOVE STRINGER 25R. REMOVED PREVIOUS REPAIR IAW B-727 SRM 51-30-2. CUT OUT DAMAGE (DIMENSION 1" BY 1") AND FABRICATED REPAIR ANGLE FROM 7075-0 0.071" PO NR 7247111 (DIMENSION 16" NR 4.25") IAW B-727 SRM 51-40-3 FIGURE 1 AND 53-10SDR 07FDEA04825Frame · crackedFWD PIT BODY FRAME, UPPER CHORD ANGLE, DOUBLER IS CRACKED, BS 720B, STR 26L-27L. REMOVED DAMAGE, FORMED REPAIR ANGLE AND FILLER, HEAT TREATED TO T-6 CONDITION, DRILLED AND TRIMMED REPAIR PARTS, ALODINED AND PRIMED. INSTALLED REPAIR REF SRM 51-40-3, 51-20-02SDR DHL2007742022Strap · gougedFRAME INNER CHORD, UPPER STRAP HAS GOUGES FROM STRINGER 27R TO STRINGER 23R BS 560 AFT EDGE C-1 DOOR AREA. CUT OUT DAMAGED AREA APPROXIMATE DIMENSION 13" BY 5" IAW B-727 SRM 51-40-2 FIGURE 1. FABRICATED REPAIR DOUBLER FROM 2024-T3 0.050" PO NR 9005773 APPROXSDR NWAA073836304Frame · damagedDURING "L" CHECK FRAME WEB AT BS 400 S11R WAS DAMAGED DURING SKIN REPAIR/INSPECTION. REPAIRED PER EA 63-210887.SDR IXXA07SMN256SFrame · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT HAS A IMPROPER REPAIR AND DENT ON FRAME AT STATION 1580.000 LONGERON-20 RIGHT REMOVED FASTENER AS NEEDED TO PERFORM REPAIR. REMOVED FRAME SEGMENT WITH EXISTING REPAIR. FABRICATED FRAME SEGMENT, SDR IXXA070063SFrame · dentedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT HAS A IMPROPER REPAIR AND DENT ON FRAME AT STATION 1580.000 LONGERON-21RIGHT REMOVED FASTENER AS NEEDED TO PERFORM REPAIR. REMOVED FRAME SEGMENT WITH EXISTING REPAIR. FABRICATED FRAME SEGMENT, ASDR IXXA070061SFrame · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT HAS A IMPROPER REPAIR AND DENT ON FRAME AT STATION 240.000 LONGERON-21 RIGHT. REMOVED FASTNER AS NEEDED TO PERFORM REPAIR.REMOVED EXISTING REPAIR.FABRICATED FRAME SEGMENT, SPLICE AND ANGLE.PERFORMSDR IXXA07SMN255SFrame · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT HAS A IMPROPER REPAIR AND DENT ON FRAME AT STATION 240.000 LONGERON 20 RIGHT. REMOVED FASTENER AS NEEDED TO PERFORM REPAIR. REMOVED EXISTING REPAIR. FABRICATED FRAME SEGMENT, SPLICE AND ANGLE. SDR IXXA07SMN253SFrame · dentedDURING ROUTINE C CHECK INSPECTION, FOUND FORWARD CARGO COMPARTMENT FRAME WITH DENT AND MISDRILLED AT STATION 200.000 LONGERON31 LEFT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED FRAME SEGMENT. FABRICATED FRAME SEGMENT ANGLE AND SPLICE. PSDR NWAA073919864Frame · crackedDURING "H" CHECK, FOUND CRACK IN FRAME INNER CHORD AT BS 1209 L8L. REPAIRED PER EA 98-211041.SDR SWAA075729Frame · crackedDURING SCHEDULED SPV CHECK, FOUND BELTFRAME CRACKED AT BS 492, STR 17R. REPAIRED FRAME PER SRM.SDR DHL2007801535Frame · crackedMAIN CARGO COMPT FRAME SEGMENT CRACKED 5" STA 240.000 L20R TO L21R. PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG. 2 SHEET 2.6. REMOVED DAMAGED FRAME SEGMENT, SPLICES AND EXISTING ANGLES IAW SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT P/N S2537716 IAW SRM 53-2-0SDR SWAA075713Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075712Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 16R. REPAIRED FRAME PER SWA EA.SDR KCSA071521Frame · damagedFUSELAGE FRAME I/B FLANGE DAMAGED AT BS 1900, STR-12R.SDR SWAA075775Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 13L. REPAIRED CHORD PER BFG ER.SDR SWAA075686Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075690Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075687Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR 2007UALA04670Frame · crackedDOORWAY 5L FWD FRAME TORQUE TUBE COVER FRAME CRACKED AT STR 23L-25L. MAJOR REPAIR ACCOMPLISHED: REPLACED FRAME SECTION.SDR DL76G071493Frame · crackedBS 1809 OUTER FRAME FOUND CRACKED AT FRAME RADIUS BETWEEN STRINGER 7R AND 8 R APPROX 3/4 INCH. REPAIRED PER SRM 53-80-08 FIGURE 201 REPAIR 9 ON APP 502887 ON HMV 3/ PSV17.SDR SWAA075667Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 21L. REPAIRED FRAME PER SWA EA.SDR CALA0700677Skin · crackedINSPECTION FOUND A .5 INCH CRACK IN RT HORIZONTAL STABILIZER SKIN FROM STAB STA 97-126. A PERMANENT REPAIR WAS PERFORMED BY INSTALLING A DOUBLER IAW ECRA 5510-01724, REV A.SDR CALA0700676Frame · corrodedINSPECTION FOUND FRAME AND SUPPORTS CORRODED AT STA 227.8, LBL 5.7 TO RBL 5.7, S28L. THE AREA WAS REPAIRED IAW ECRA 5311-01373.SDR 07FDEA04770Frame · damagedFWD E/E BAY FRAME 14 RT VERTICAL LEG HOLE LABELED "A" DAMAGED FABRICATED AND INSTALLED 2. REPAIR BUSHINGS IAW FED EX EA 6-5310-109224 "FUSELAGE-MAINFRAME-O.S. HOLES IN NLG WHEEL WELL CROSSMEMBER-REPAIR" BY TIMCO EMP NR 110294/QC254.SDR CALA0700674Frame · corrodedINSPECTION FOUND FRAME AND SUPPORT CORRODED AT STA 203.8, S28L TO S28R, RBL 5.7 TO LBL 5.7. THE FRAME CHORD AND SUPPORT WERE REMOVED AND REPLACED IAW SRM 51-40-02.SDR SWAA075656Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR IXXA07SMN236SFrame · damagedDURING ROUTINE C CHECK INSPECTION, AT F/S STATION 240 LEFT FRAME HAS DOUBLE DRILLED HOLE BETWEEN LONGERON 29 LEFT AND LONGERON 30 LEFT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. PLUGGED MISDRILLED HOLE WITH RIVET. PERFORMED NDT INSPECTION. NO CRACK, NSDR DLM90071504Frame · corrodedAFT PIT FRAME AT STA 1363 CORRODED ON AFT SIDE LONGERON 28L-28R. REPAIRED FRAME IAW MD-90 SRM 53-10-02 FIG 2 ON N/R 1600-0201 AT HMV-2 IN OKC.SDR 07FDEA04763Frame · corrodedUPPER FUSELAGE STATION 720D FRAME, AFT EDGE IS CORRODED AT STRINGER 4 RIGHT AREA REMOVED CORROSION AT UPPER FUSELAGE STA 720D FRAME AFT EDGE AT STR 4 RIGHT AREA REF SRM 51-10-6 ORIGINAL MATERIAL .064", MATERIAL REMAINING .048" MATERIAL LOSS .016". FOUND TO SDR KCSA071512Frame · crackedFUSELAGE FRAME HAS A CRACK (.5 INCH) AT STA 434, BETWEEN STR 26L & 27L.SDR 07FDEA04759Frame · gougedMAIN CABIN FR55 AT APPROX L15L HAS A PUNCTURE IN FLANGE OF FRAME. CUTOUT DAMAGE AND REPAIRED WITH REINFORCING PLATE/REPAIR DOUBLER IAW A310 SRM 53-10-13 PAGE 206-209 FIGURE 202.SDR USAA920071189Frame · crackedCLT - MAJOR REPAIR - C6 CHECK, FORWARD CARGO DOOR CUTOUT AFT FRAME CRACKED, BS 492.4, S24R. REPAIRED FORWARD CARGO DOOR CUTOUT AFT FRAME, BS 492.4, S24R IAW USAIRWAYS EA 100014.SDR SWAA075637Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075635Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR NWAA074196307Frame · crackedDURING "M" CHECK, FOUND 3 HOLES WITH CRACK INDICATIONS ON FRAME AND CRACKED FRAME WEB DOUBLER AT BS 1140 S10R TENSION TIE AREA. REPAIRED PER EA 63-211005.SDR 07FDEA04749Frame · dentedCABIN, LEFT STA 1721 L-12 FRAME FOUND DENTED. CARRIED OUT REPAIR AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR 07FDEA04748Frame · dentedCABIN, LEFT STA 1701 L-12 FRAME FOUND DENTED. CARRIED OUT REPAIR AS PER SRM 53- 30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SWAA075624Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA075612Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075603Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075618Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 12L. REPAIRED FRAME PER SRM.SDR SWAA075623Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075596Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482B, STR 10L. REPAIRED FRAME PER SRM AND BOEING DRAWING.SDR SWAA075580Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075583Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075582Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075581Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA04736Frame · corrodedUPPER FUSELAGE STATION 720D FRAME, AFT EDGE IS CORRODED AT STRINGER 4 RIGHT REMOVED CORROSION AT UPPER FUSELAGE STA 720D FRAME AFT EDGE AT STR 4 RIGHT AREA REF SRM 51-10-6 ORIGINAL MATERIAL .064", MATERIAL REMAINING .048", MATERIAL LOSS .016'. FOUND TO BE OUT
Back to JASC 5311