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 SWAA052066Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER BFG ER.SDR 2005UALA00662Frame · dentedFRAME 600 IS DENTED AT STRINGER 23L. TRIM OUT DAMAGE, ACP HEFC INSP, NO CRACK NOTED. REPAIRED PER GSO EA G10674 REV B.SDR 05FDEA01965Frame · chafedFUSELAGE UPPER LOBE, FRAME REPAIR IS CHAFED, BS 970, STR 9R. REPAIRED FRAME PER SRM 51-40-3.SDR 05FDEA01964Frame · chafedFUSELAGE UPPER LOBE, FRAME IS CHAFED, BS 990, STR 9R. REPAIRED FRAME PER SRM 51-40-3.SDR AWXA200500959Frame · crackedDURING C18 CHECK DISCOVERED FRAME CRACKED, .17 INCHES IN LENGTH, UNDER DOOR ASSIST HANDLE AT THE R2 DOOR, BS 954, STR14R. MAINTENANCE TRIMMED OUT CRACK AT DOOR ASSIST HANDLE AT THE R2 DOOR, BS 954, STR 14R IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ESDR 05FDEA01947Frame · damaged3 FIGURE 8 HOLES AT BS 460 FRAME VERTICAL FLANGE STR 5R. REPLACED FRAME PER SRM 51-30-2.SDR EIA2005140Frame · crackedSTA 803 WL 215 1.5" BELOW STR 24R DOOR FRAME WEB HAS A CRACK. REMOVED DAMAGE AND REPAIRED DOOR FRAME STA 803 WL 215 STR 24R AREA PER ECRA 487-53-025-2.SDR EIA2005138Frame · crackedFRAME STA 2231 STR 24L CRACK IN WEB INNER STRAP. REPAIRED CRACK AT STA 2231 WEB CUT OUT BETWEEN STR 24L AND 25L PER B747 SRM 53-10-01 FIG 1 DETAIL 1 AND ECRA 487-53-018-2.SDR DHL2005746527Gusset · crackedBS 825 FRAME GUSSET ON RT SIDE I/B AT EDGE IS CRACKED. REMOVED GUSSET ON BS 825 FRAME ON RT SIDE I/B IAW B727 SRM 51-30-2. FABBED GUSSET FROM 7075 T6 .090 SIZE 4.3"X5.6" PO 9001777 IAW B727 S/B 53-0197 SRM 51-10-2. INSTALLED GUSSET IAW B727 S/B 53-0197 REV SDR SWAA052018Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REMOVED AND REPLACED STUB FRAMES PER SRM.SDR SWAA052016Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT BS 348, LBL 50, WL 208. REPAIRED FRAME INNER CHORD PER SRM.SDR VTZA200500138Frame · crackedRT FS 640 FRAME DOUBLER CRACKED IN RADIUS AT 3.0 IN LENGTH.SDR USAA200507003Frame · cracked1.5 IN CRACK FOUND AT FRAME 767, STR 24L. INSTALLED REPAIR DOUBLER PER SRM 53-00-01 FIG 229.SDR UPS05845181Frame · crackedCRACK IN FRAME 55 A/C COMPT BETWEEN L24L AND L25L. REMOVED CRACKED FRAME AT STA 55 L24L-L25L IAW SRM 51-3-0. FABRICATED REPAIR FRAME SECTION, REPAIR ANGLES, AND FILLER IAW SRM 53-03-03 FIG3 AND 53-2-0. INSTALLED FRAME SECTION AND REPAIR ANGLES AND FILLER ATSDR SWAA052000Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA051995Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA051994Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA051985Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 28R TO STR 28L, WL 149. REPAIRED FRAME PER SRM.SDR SWAA052008Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, RBL 55, WL 209. REPAIRED FRAME PER BFG ER.SDR SWAA052001Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA051993Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 24R TO STR 25R. REPAIRED FRAME PER SRM.SDR USAA050851Frame · crackedCLT - FOUND FRAME CRACKED .5 INCH, CENTER AISLE FRAME BETWEEN STATION 380 AND 400. FABRICATED AND INSTALLED NEW PART IAW SRM 51-10-02. (M)SDR AWXA200500871Frame · crackedDURING C16 CHECK DISCOVERED BULKHEAD 178 CHORD CRACKED, 2.2 INCHES IN LENGTH, AT WL 207, BL 27L. MAINTENANCE REMOVED CRACKED CHORD LOCATED AT BULKHEAD 178, WL 207 IAW BOEING 737-300 SRM 51-40-02-0 FIG 8. RECEIVED NEW CHORD AND PREPARED FOR INSTALLATION IAW BSDR SWAA051973Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 907, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR IXXA05SMN154SFrame · crackedDURING ROUTINE C-CHECK INSPECTION, FWD ACCES COMPT. FRAME CRACKED 2” STA 55.000 L-24R. PERFORMED MAJOR REPAIR IAW DC-8 SRM 53-2-0 FIG. 2 SHEET 5, TR 53-125 DATE 08-31-01, DC-8 SRM 53-2-0 FIG. 2 (SHEET 6) EO SEMAN NR 20051015 DATE 06-29-05. REPAIRED PER SSDR DU4R0507144Frame · crackedBS 178 BULKHEAD RT SIDE AFT SIDE FRAME HAS EVIDENCE OF CRACK ABOVE AND BELOW WL 207.SDR SWAA051945Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BETWEEN BS 727B TO BS 727E, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051956Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 616, BETWEEN LBL 63 + RBL 63, WL 201. REPAIRED FRAME CHORD PER BFG ER.SDR DHL2005746520Frame · dentedFRAME DENTED AT BS 700 STR 24R. REMOVED NESSARY FASTENERS IAW B727 SRM 51-30-2. REMOVED DAMAGED SEC FROM FRAME AT BS 700 STR 24R IAW B727 SRM 51-40-3 FIG 1, 51-30-2 FABBED DOUBLER FROM 7075 T6 .063 PO 900226 10" X 3.5" X .75" DRILLED, DEBURRED, TREATED & PRISDR C2XA05SH061Frame · crackedSHV-DURING C-CHECK MAINTENANCE FOUND APU FIREWALL ATTACHMENT FRAME CRACKED AT THE SIX O'CLOCK POSITION AT FRAME 81 (INTERNAL). MAINTENANCE REPAIRED THE APU FIREWALL IAW EC 5310-01342. AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR SWIA200515798Frame · crackedFWD AVIONICS BAY FS 280 LT FRAME CRACKED BL-+8 AND +11 INBOARD OUTBOARD. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED TWO NEW BRACKETS IAW REO 601R-53-11-136.SDR SWIA200515797Frame · crackedFWD AVIONICS BAY FS 280 RT FRAME CRACKED BL- +8 AND +11 INBOARD OUTBOARD. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED TWO NEW BRACKETS IAW REO 601R 53-11-136.SDR 0501086740Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME WEB AT BS 460 S12L. REPAIRED PER EA 67-165219.SDR ASAA0540333Frame · corrodedOKC - FRAME 807 FORWARD FACE CORRODED BETWEEN STRINGERS 27L AND 27R. REMOVED DAMAGED SHEAR TIES. FABRICATED AND INSTALLED REPAIR PIECES IAW 737-400 SRM 53-00-07 FIGURE 210. (M)SDR 2005UALA00611Frame · chafedSTA 211 FRAME WEB WAS CHAFED BEYOND LIMITS BETWEEN STR 15R AND 16R, FRAME WAS ALSO GOUGED BEYOND LIMITS. SPLICED IN NEW SECTION OF WEB REF SRM 51-70-13 FIG 1 AND SPLICED IN NEW FRAME FROM STR 15R TO 17R REF SRM 51-70-12.SDR 05FDEA01786Frame · dentedCENTER CARGO BAY AT STA 1841 RT LOWER FRAME PATCH REPAIR FOUND DENTED AS MARKED. CENTER CARGO COMPARTMENT,LOWER FRAME AT STA 1841 RH WEB REMOVED AS PER SRM 51-53-01 VOL II. NEW WEB FABRICATED AS PER DRAWING AGA 7170, NEW WEB INSTALLED AS PER SRM 51-53-SDR SWAA051913Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 440, STR 9R. REPAIRED FRAME PER SRM.SDR 0501076740Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME AT BS 460 S14L. REPAIRED PER EA 67-165222.SDR SWAA051912Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 CRACKS IN FRAME AT BS 380, STR 15R & STR 16R. REPAIRED FRAME PER SRM.SDR SWAA051911Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND LT CREASE BEAM WEB CRACKED AT BS 500C + 14. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA051919Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, LBL 18. REPAIRED FRAME PER SRM.SDR AWXA200500799Frame · crackedMCN - MAJOR REPAIR - DURING C16 CHECK FOUND FRAME WEB CRACKED AT FASTENER HOLE AT BS 178, WL 230, AND LBL 17.1. MAINTENANCE REMOVED DAMAGED AREA OF FRAME WEB AT BS 178, WL 230, LBL 17.1 IAW BOEING 7370399 SRM 53-10-08-2 FIG 212. OBTAINED AND PREPARED NEW WEBSDR 05FDEA01720Frame · crackedCOCKPIT LT FRAME STA 277 BTWN STR S-14 TO S-16 FRAME WEB ANGLES CRACKED AT FWD & AFT SIDE OF FRAME AT 6 EA PLACES AS MARKED. REPAIRED FRAME WEB ANGLE IAW SRM 53-10-4 MAJOR REPAIRSDR 05FDEA01718Frame · chafed344 FRAME CHAFED AT STR'S 4R,6R & 8R. FABRICATED AND INSTALLED REPAIR CHANNEL IAW SRM 51-40-3SDR IXXA05SMN97SFrame · crackedDURING ROUTINE C CHECK INSPECTION, NOSE SECTION, DOUPLER ANTENNA FRAME WITH 02 CRACKS 2" EACH ONE. REMOVED DOUPLER ANTENNA FRAME (CRACKED) IAW DC-8 SRM 51-1-21 PAGE 1. FABRICATED NEW DOUPLER ANTENNA CAP IAW DWG DOUGLAS NR 561601 (ALCLAD 7075 T6 0.125). PERFOSDR 0500969918Frame · crackedDURING M-CHECK FOUND CRACKED FRAME AT VENTRAL STAIR CUTOUT BS 1087. REPAIRED PER EA 99-203533.SDR SWAA051877Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME UPPER STRUCTURE IS CRACKED AT BS 663, STR 1L TO STR 3L. REPAIRED FRAME PER SRM.SDR SWAA051875Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 639, STR 17L, WL 210. REPAIRED FRAME CHORD PER SRM.SDR ASAA0540317Frame · corrodedOKC - FOUND FRAME AT BS 500F STRINGER 27-28 LEFT ARE CORRODED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW 737-400 SRM 53-00-07 FIGURE 203. (M)SDR ASAA0540313Frame · cutOKC - FOUND FRAME DAMAGED ON UPPER LIP AT BS 787 BETWEEN STRINGER 25 AND 26 RT. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW 737-400 SRM 53-00-07 FIGURE 201. (M)
Back to JASC 5311