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 USAA050993Frame · crackedCLT, Q6, FRAME .125 INCH CRACK, STRINGER 9 LT STA 500A. REPAIRED IAW TR 53-10-20B. (K)SDR QOF2005F00000Frame · crackedTOP FORE AND AFT STRINGER CRACKED AT AFT MOST TAB AT JUNCTURE OF WELD. TUBE TO TAB. 2004 MODEL. (K)SDR SWAA052353Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, RBL 21. REPAIRED FRAME PER SRM.SDR ASAA0580439Frame · corrodedOKC - DURING C-CHECK, FOUND FRAME CORRODED. REPLACED DAMAGED FRAME SECTION. (M)SDR MALA050636Frame · corrodedIRREGULAR ROUTING DUE TO AIRFRAME CORROSSION NOTED DURING ROUTINE MAINTENANCE. NO FURTHER INFORMATION AT THIS TIME.SDR 2005UALA00775Frame · dentedFWD PIT FRAME STA 600, LT 2 EACH DENT STR 24L. TRIMMED OUT DAMAGE, ACP HFEC INSP, NO CRACK FOUND. FABRICATE AND INSTALL REPAIR PER TIMCO REO-G10763, REV B, AND UA EVA-50518.SDR 2005UALA00774Frame · dentedAFT PIT FRAME DENTED STA 1400, STR 26L. TRIMMED OUT DAMAGE, ACP HFEC INSP, NO CRACK FOUND. FABRICATE REPAIR ANGLE PER TIMCO REO- G10758, REV B, AND UA EVA-50516.SDR 2005UALA00773Frame · dentedDENT IN FRAME AT STA 580, STR 24L. TRIMMED OUT DAMAGE, ACP HFEC INSP, NO CRACK FOUND. FABRICATE ANGLE REPAIR PER TIMCO REO-G10764 AND UA EVA-50105.SDR 2005UALA00771Splice · dentedFRAME SPLICE AT STA 1420 BETWEEN STR 24L AND 25L IS DENTED ON TOP IN AFT CARGO PIT. TRIMMED OUT DAMAGE, ACP HEFC NDT INSP, NO CRACK FOUND. REPAIR PER TIMCO REO-G10762, REV B, AND UAL EVA 50517.SDR SWAA052345Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA052344Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 24R TO STR 26R. REPAIRED FRAME PER BFG ER.SDR 05FDEA02286Frame · crackedMAIN CABIN RT FRAME 46 CRACKED. REMOVED AND REPLACED RT FRAME 46 AT STR 27 IAW A300-600 SRM 51-40-21 FIG 9.SDR 05FDEA02285Frame · crackedRIGHT MAIN CABIN FRAME 45 FOUND CRACKED. REMOVED AND REPLACED FRAME SECTION IAW A300-600 SRM 51-40-21 FIG 9, STR 22 TO STR 27.SDR ASAA0540380Frame · crackedCRACKED FRAME. REPAIRED CRACK IAW SRM. (K)SDR SWAA052325Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 747, BS 807, BS 827, BS 847 & BS 867, STR 8L TO STR 9L. REPAIRED FRAMES PER SRM.SDR SWAA052324Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 807, BS 827, BS 847, BS 867, BS 887 & BS 907, STR 8R TO STR 9R. REPAIRED FRAMES PER SRM.SDR SWAA052322Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, RBL 55, WL 209. REPAIRED STUB FRAME PER BFG ER & SRM.SDR ASAA0540376Frame · corrodedYXX - FWD CARGO PIT BILGE, CORROSION ON FRAME LWR FLANGE @ B STA 500B, WBL 95. SHEAR TIE REPAIR ACCOMPLISHED IAW SRM. (K)SDR MALA050632Frame · chafedDURING 4Y/2Y INSPECTION IN BNA, FRAME 686.888 RT SIDE OF FUSELAGE HAS BEEN CHAFED BY CARGO DOOR CABLE. DAMAGE HAS BEEN REPAIRED IAW MESABA EO#53308. REFER EAMS WORK ORDER #212691 TASK 2505.SDR SWAA052289Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER BFG ER.SDR MALA050628Frame · dentedDURING 4K CHECK IN BNA, FOUND LOWER FUSELAGE AND FRAME AT FS 686.888 JUST TO THE LEFT OF BL 0 IS DENTED, DAMAGE IS ACCEPTABLE IAW MESABA EO S53307. REF: EAMS WORK ORDER 212637 TASK 1546.SDR SWAA052270Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, L1 DOOR LOWER FWD STOP FITTING CUTOUT. REPAIRED FRAME PER SRM.SDR AWXA200500931Frame · crackedDURING C18 CHECK, FOUND FUSELAGE FRAME CRACKED, .50 INCHES IN LENGTH, AT BS 616, BL 65R BELOW STRINGER 17, CABIN AREA. MAINTENANCE REMOVED CRACK FROM INNER CHORD FRAME AT BS 616, BL 65R BELOW STRINGER 17, CABIN AREA IAW AMERICA WEST AIRLINES ENGINEERING REPAISDR 05FDEA02146Frame · gougedCOMPLY WITH EA 6-5310-82108, FUSELAGE MAIN FRAME, FRAME 28, GOUGE REPAIR STR 18L THROUGH STR 22L. COMPLIED WITH EA 6-5310-82108 FUSELAGE, MAIN FRAME, FRAME 28, GOUGE REPAIR STR 18L THROUGH STR 22L.SDR 05FDEA02143Frame · gougedCOMPLY WITH EA 6-5310-82112, COMPLIED WITH EA 6-5310-82112 FUSELAGE-MAIN FRAME, FRAME 28 GOUGE REPAIR STR 10L THROUGH STR 11L.SDR UPS05445139Frame · crackedINSPECTION TYPE:C M/D BS 2180 FRAME WEB S24R STR CUTOUT FOUND CRACK (CRACK LENGTH 0.75" & 0.5"). M/D BS 2180 STR 23R TO STR 26R FRAME REPAIRED AS PER HX RS R53-62-35345 & UPS EO B747-5310-22631-A.SDR SWAA052267Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, L1 DOOR LOWER STOP FITTING CUTOUT. REPAIRED FRAME PER SRM.SDR DL76S050658Frame · crackedTHE INNER CHORD OF THE RIGHT STA 903.5 FRAME WAS FOUND WITH A 0.25 INCH CRACK. CHORD WAS REPAIRED WITH AN ANGLE PER ACTS PP B767-53-20585, REF ER/A 099690-14AD.SDR UPS05845153Frame · crackedMAIN CABIN FRAME CRACKED 1" LONG AT STA 1700 L20L. TRIMMED OUT DAMAGE, FABRICATED, AND INSTALLED REPAIR IAW EO DC8-5310 -11728-B AND DWG DC8-53A-011-A.SDR SWAA052233Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052224Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA052222Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKS AT BS 500B, BETWEEN STR 20R AND STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA052246Beltframe · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REPAIRED BELTFRAME PER SRM.SDR DU4R0507163Frame · dentedDENT IN AFT CARGO COMPARTMENT BS 1520 FRAME UPPER FLANGE BETWEEN S-25 TO S-26L.SDR DU4R0507162Frame · crackedCRACK IN FRAME UPPER SURFACE IN AFT CARGO COMPARTMENT BS 1540.SDR DU4R0507161Frame · crackedAFT BAG PIT LT BS 1500 AT S-26L MAIN FRAME HAS DENT/CRACK.SDR DU4R0507160Frame · dentedAFT CARGO BAY LT BS 1480 AT S-25L MAIN FRAME HAS DENTS.SDR DU4R0507159Frame · dentedAFT CARGO BAY LT BS 1340 AT S-25L MAIN FRAME HAS DENT.SDR SWAA052210Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA052209Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR 05FDEA02116Frame · dentedFWD CARGO PIT FRAME AT BS 500 HAS A DENT BETWEEN STRINGER 23R AND 25R. REPAIRED FRAME IAW SRM 51-40-3 THIS IS A MAJOR REPAIR.SDR 05FDEA02115Frame · damagedBS 360 FRAME HAS MECHANICAL DAMAGE FWD OF STR 5L. REPAIRED DAMAGED FRAME PER SRM 51-40-3. (CLOSED)SDR ABXA050224Frame · crackedSHEAR TIE CRACKED FS 1087, LONGERON 2 RIGHT. REMOVED AND REPLACED SHEAR TIE IAW DC-9 SRM 51-30-5.SDR UPS05445166Frame · crackedBS 560 STR 10AL-11L FRAME O/B FOUND CRACK FLANGE. CRACK LENGTH 2" CORROSION BLEND OUT N/A. BS 560 BETWEEN STR 10AL-11L FRAME REPAIRED AS PER HX RS R53-12-35352 AND UPS EO B747-5310-22634-A.SDR SWAA052199Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, RBL 8. REPAIRED FRAME PER SRM.SDR UPS05445020Frame · crackedBS 560, BETWEEN STR 6L - 8L FRAME AFT FACE O/B AREA 2EA CRACK FOUND, CRACK LENGTH 1.125 & 3/4". BS 560 FRAME REPAIRED AS PER SRM 53-10-04 FIG 54 AT BTN STR 6L TO 8L AREA.SDR 05FDEA02099Frame · crackedBS 1263 LWR RT TORQUE BOX FRAME ANGLE CRACKED RBL 20 WL 192. REPAIRED FRAME ANGLE PER SRM 51-30-2. (CLOSED)SDR 05FDEA02098Frame · dentedDENT IN FRAME STA 970 STR 23L. REPAIRED FRAME AT STA 970 STR. 23L PER SRM 51-40-3 FIG 1.SDR UPS05445010Frame · crackedINSPECTION TYPE: C, LT BLG WW LT STA 1416 FRAME FOUND CRACKED IN BTN STR 29 AND STR 30, CRACK LENGTH 0.25". LT BLG W/W LT BS 1416 BETWEEN STR 29 AND 30 FRAME REPAIRED AS PER SRM 53-10-04 FIG 4.SDR 2005UALA00709Frame · crackedFUSELAGE FRAME STA 663 IS CRACKED AT STR 1 CUTOUT. MAJOR REPAIR ACP'D PER SRM 53-00-07 AND BACO DRAW 65-73740.
Back to JASC 5311