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 SWAA043473Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 344, STRINGER 22L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043472Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, STRINGER 9L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR ASAA0410619Frame · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FRAME. REPAIRED PER SRM. (M)SDR BJNA041103Frame · corrodedDURING A SCHEDULED C CHECK INSPECTION, LEVEL TWO CORROSION WAS DISCOVERED ON A FRAME RIB AT STATION 285 FROM STRINGER 24L TO STRINGER 28L. CUTOUT CORRODED AREA OF FRAME AT STATION 285 FROM STRINGER 24L TO STRINGER 28L. FABRICATED FILLER AND DOUBLER USING 707SDR DHL2004873560Angle · crackedAFT ACCY COMPT FRAME SPLICE ANGLE CRACKED 4.000 STA 1640.000 BETWEEN L-25 AND L-26R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1, SRM 53-4-1 FIG 51. REMOVED CRACKED FRAME SPLICE ANGLE IAW SRM 51-1-21 PG 1, SRM 51-1-20D PG 21. FABRICATED NEW FRSDR 04FDEA03216Frame · corrodedDURING AIRPLANE'S CONVERSION FROM P-F/ACF, FOUND FWD AVIONIC COMPT AT STA 401 FRAME P/N ABA7104-67 AND ANGLE P/N 7104-69 WITH CORROSION. REPLACE FRAME AND ANGLE PER SRM 51-35-01 PAGE 1-12 AND SRM 51- 33-01 PAGE 33-47.SDR 04FDEA03215Frame · corrodedDURING AIRPLANE'S CONVERSION FROM P-F/ACF, FOUND AFT FUS VAST COMP STA 1986 FOUND EXISTING REPAIRED AND CORROSION ON FRAME P/N AGA3787-3. REPLACE FRAME PER SRM 51-35-01 PAGE 1-12 AND SRM 51-33-01 PAGE 34-47.SDR 04FDEA03213Frame · corrodedDURING AIRPLANE'S CONVERSION FROM P-F/ACF, FOUND AFT FUSELAGE COMPT STA 1975 FOUND FRAME P/N AGA 3183-3 WITH CORROSION. REPLACE FRAME PER SRM 51-35-01 PAGE 1-12 AND SRM 51-33-01 PAGE 34-47.SDR 04FDEA03208Frame · crackedDURING AIRPLANE'S CONVERSION FROM P-F/ACF, FOUND FWD ACC COMP AT STA 469 RT SIDE. FOUND 1 CRACK OF 5 INCHES ON FRAME AND 1 CRACK ON LWR FLANGE OF 0.90 INCHES. REPLACED FRAME PER SRM 51-33-01 PAGE 34-47 AND SRM 51-35-01 PAGE 1- 12.SDR ASAA0410613Frame · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FRAME DOUBLER AT BS 787, STRINGER 23R, WL 156. REMOVED, FABRICATED AND INSTALLED FRAME DOUBLER PER SRM. (M)SDR 2004UALA01157Frame · dentedAFT PIT FRAME DENTED UPPER FLANGE AT STA 1500 AND STR 26L. INSTALLED J ANGLE REPAIR DOUBLER.SDR 2004UALA01156Frame · dentedAFT PIT FRAME DENTED UPPER FLANGE AT STA 1420, STR 26L.SDR 2004UALA01155Frame · dentedAFT PIT FRAME DENTED AT UPPER FLANGE AT STA 1440, STR 26L. REPAIRED FRAME WITH J ANGLE REPAIR SECTION.SDR 2004UALA01154Frame · dentedAFT PIT FRAME DENTED ON UPPER FLANGE AT STA 1520 AND STR 26L. INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01158Frame · dentedAFT PIT FRAME DENTED ON UPPER FLANGE STA 1400 AND STR 26L. INSTALLED NESTED J ANGLE REPAIR.SDR MALA040932Frame · gougedDURING INSPECTION, LT SIDE FUSELAGE GOUGED BETWEEN FRAMES 18 & 19 ON LAP -C-, STRINGER 24. MAINTENANCE REPAIRED REFER TO 409 CARD 226160, AND EO A53234 FOR ADDITONAL INFORMATION.SDR SWAA043428Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FRAMES CRACKED AT BS 807 & BS 867, STR 9L. REPAIRED BOTH FRAMES PER SRM.SDR ASAA0410572Frame · damagedPAE - FRAME DAMAGED. REPAIRED FRAME BY INSTALLING DOUBLER.SDR C2XA04TY176Frame · damagedDURING C CHECK, THE FASTENER HOLES AT FRAME 61, STRINGER 11R WHERE FOUND DAMAGED. INSTALLED A REPAIR DOUBLER IAW 51-40-02 AND CMP 51-21-04/05. AIRCRAFT RETURNED TO SERVICESDR UPS04843582Frame · corrodedSTA 70 FRAME CORRODED BEYOND LIMITS ABOVE LONG 21R. REMOVED CORROSION, TREATED AND PRIMED SITE PER SRM51-1-8. FABRICATED REPAIR DOUBLER FROM SHT7075O-.080 PER EO DC8- 5310-11728/DWGDC8-53A-011. HEAT TREAT TO T6 PER DPS7.00 INSTALLED REF SRM 51-1-20D, 51-1-8SDR SWIA200414349Frame · crackedAFT OF FRAME 280 RIGHT SIDE 2 ANGLE CLIPS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED IAW CRJ 200 SRM 51-42-06 FIG 8 AND 51-42-21.SDR SWAA043413Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L TO STR 20 R. REPAIRED FRAME PER SRM.SDR SWAA043407Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS STR 4R CRACKED AT BS 908. REPAIRED STRINGER ASSY PER SRM.SDR SWAA043406Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 482A FRAME CRACKED BETWEEN STR 20L & STR 21L. REPAIRED FRAME PER SRM.SDR SWAA043403Frame · crackedDURING SCHEDULED D-CHECK, FOUND BS 188 STUB FRAMES CRACKED AT STR 17L & STR 17R. REMOVED AND REPLACED FRAMES PER SRM.SDR USAA040939Frame · crackedPIT - Q1 -FRAME, 1 INCH CRACK, RT STA 601 BELOW S17R, FRAME TO FLOORBEAM ATTACH POINT. INSTALLLED REPAIR ANGLE IAW EA 79352.SDR ASAA0480563Frame · crackedC-CHECK - NLG LT TUNNEL FORWARD CUTOUT FRAME, CRACKED. STOP-DRILLED CRACK. INSTALLED REPAIR ANGLE.(K)SDR MALA040870Frame · chafedDURING 4Y/2Y INSPECTION IN BNA, FRAME CHAFED ON RT SIDE AT FS 686.888 WAS REPAIRED IAW EO S53261. AIRCRAFT RETURNED TO 11/23/04.SDR SWIA200414191Frame · crackedAFT EQUIPMENT COMPARTMENT FRAME IS CRACKED; FS 640.00 STR 9R, ITEM FOUND AT C-CHECK INSPECTION. FRAME REPAIRED IAW REO 601R-53-61-557 REV NC.SDR SWIA200414190Frame · crackedAFT EQUIPMENT COMPARTMENT FRAME IS CRACKED; FS 640.00 STR 9L, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-557 REV "NC"SDR SWIA200414182Frame · corrodedCORROSION ON FRAME 349.0 STR 26L AND ON FRAME 364.0 STR 26L IN AVIONICS CRAWL WAY. (ITEM FOUND AT C-CHECK INSPECTION.) AFFECTED AREAS REPAIRED IAW CRJ SRM 53-21-15.SDR 2004UALA01146Frame · dentedAFT PIT STA 1340 FRAME DENTED AT STR 25R. TYPICAL AFT PIT FRAME DENT DAMAGE DUE TO CARGO LOADING. FRAME CAP REPAIRED USING "J" ANGLE REPAIR.SDR 2004UALA01144Frame · dentedAFT PIT STA 1420 FRAME DENTED AT STR 25L. DENT CUTOUT AND J ANGLE REPAIR INSTALLED.SDR 2004UALA01143Frame · dentedAFT PIT STA 1580 FRAME DENTED AT STR 25R. DAMAGED WAS CUTOUT AND FRAME J ANGLE REPAIR WAS ACCOMPLISHED.SDR ASAA0410541Frame · corrodedOKC - FRAME STATION 767 CORRODED BETWEEN STRINGER 26L AND 26R. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR SHEAR TIE, DOUBLERS, RADIUS FILLERS AND SHIMS, IAW SRM. (M)SDR ASAA0410539Frame · corrodedOKC - FOUND CORROSION STATION 500 UNDER NUTPLATE AT STRINGER 27R INSIDE LONGERON CHANNEL. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED A REPLACEMENT SECTION, ANGLE, AND CHANNEL IAW SRM. (M)SDR MALA040822Frame · chafedDURING 6Y/4Y INSPECTION IN LAN, RT FRAME AT STA 686.388 HAS CHAFING. MAINTENANCE REPAIRED IAW MESABA EO NR S53260. REFER TO NRC NR 127285 FOR ADDITIONAL INFORMATION. AIRCRAFT RETURNED TO SERVICE 11/18/04.SDR USAA040974Failsafe · crackedPIT - Q5 - FAIL SAFE CHORD, .75 INCH CRACK, STA 380 AT STR 15R. REMOVED DAMAGE AND INSTALLED DOUBLER IAW SRM 51-70-11, FIG 1.SDR 2004UALA01124Frame · damagedSTA 986 FRAME I/B FLANGE HAS AN ELONGATED FASTENER HOLE AT WL 206. INSTALLED ANGLE DOUBLER REPAIR.SDR SWAA043349Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT FRAME WEB CRACKED AT BS 303, FWD LOWER STOP FITTING. REMOVED AND REPLACED FRAME WEB PER SRM.SDR 04FDEA03112Frame · chafedMAIN DECK CARGO COMPARTMENT, RT STA 535 FRAME FOUND CHAFED AT UPPER AND LOWER YOKE MOUNTING AREA. TRIMMED OUT AND REPAIRED PER FEDEX DRAWING SRZ-53-503 AND SRM 51-31-01 VOLUME I.SDR 04FDEA03108Frame · dentedFRAME BS 1010 LT BETWEEN STR 24 AND 25 DENTED.SDR 04FDEA03106Frame · dentedAFT CARGO FRAME DENTED AT BS 970, STR 26R.SDR 2004UALA01114Frame · damagedFRAME AT BS 1400 STR 26L IS DAMAGED. CARGO PIT FRAME DAMAGE DUE TO CARGO HANDLING. FRAME SECTION REPLACED.SDR 2004UALA01059Frame · dentedAFT PIT STA 1440 FRAME DENTED AT STR 25L. INSTALLED J ANGLE REPAIR.SDR 2004UALA01108Frame · dentedAFT PIT FRAME DENTED AT RT SIDE BETWEEN STRINGERS S25R & S26R. REMOVED DAMAGED FRAME CAP AND INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01107Frame · dentedAFT PIT FRAME DENTED AT STA 1480 BETWEEN STRINGERS S25L & S26L. REMOVED DAMAGED PORTION OF THE FRAME CAP. INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01056Frame · dentedAFT PIT FRAME INNER FLANGE DENTED AT BS 1320 ABOVE STR 26R. INSTALLED J ANGLE REPAIR.SDR 2004UALA01055Frame · dentedAFT PIT FRAME INNER FLANGE DENTED AT BS 1400 ABOVE STR 26L. INSTALLED J ANGLE REPAIR.SDR 2004UALA01054Frame · dentedAFT PIT FRAME DENTED AT STA 1580 ABOVE STRINGER S26L. INSTALLED NESTED ANGLE REPAIR.
Back to JASC 5311