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 2005UALA00095Frame · dentedAFT PIT FUSELAGE FRAME INNER FLANGE IS DENTED AT BS 1400, STR 25L. *S/D* DAMAGE DUE TO TYPICAL CARGO LOADING IN AFT PIT. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE REPAIR.SDR 2005UALA00094Frame · dentedAFT PIT FUSELAGE FRAME INNER FLANGE IS DENTED AT BS 1440, STR 25L. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME FLANGE WITH A NESTED J-ANGLE REPAIR.SDR 2005UALA00093Frame · dentedAFT PIT AT STA 1540 FRAME INBOARD FLANGE IS DENTED AT STR 25R. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE REPAIR.SDR 2005UALA00092Frame · dentedAFT PIT STA 1580 FRAME IS DENTED ON INBOARD FLANGE AT STR 25. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE REPAIR.SDR SWAA050203Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 520, BETWEEN STRINGERS 27L AND 28L, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050202Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 500C, BETWEEN STRINGERS 27R AND 28L, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050201Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 500A, BETWEEN STRINGERS 28L AND 28R, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR IXXA0500182SFrame · chafedDURING ROUTINE C-CHECK FOUND FLIGHT DECK AT STATION 12.00 TO STATION 20.00 LEFT BUTT LINE 10 FRAME CHAFED THROUGH. REMOVED LOWER L-ANGLE WIRE BUNDLE ATTACH ANGLE, STIFFENERS, AND INTERCOSTAL. FABRICATED INTERCOSTAL AND DOUBLER. LOCATED INTERCOSTAL AND DOUBLSDR MALA050217Frame · dentedLEFT SIDE OF FUSELAGE BELOW LAPCAT FRAME 14 DENTED AND CREASED. REPAIRS CARRIED ON 409, NR 226085 AND EOA53247.SDR SWAA050187Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 992, RBL 55, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR IXXA0500172SFrame · crackedDURING ROUTINE C-CHECK FOUND FRAME CRACKED IN THE AFT PIT STATION 1120 AT LONGERON 30 RIGHT. REMOVED DAMAGE, FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED REPAIR PARTS IAW DC8 SRM 53-2-0, 51-1-8, AND 51-1-20D.SDR ASAA0540044Frame · corrodedOKC - AFT CARGO COMPARTMENT B-STA 727E FRAME IS CORRODED ON THE FORWARD SIDE BETWEEN STR 25R AND 25L. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER, ANGLE, AND SHEAR TIE IAW SRM. (K)SDR ASAA0540043Frame · misdrilledOKC - AFT CARGO COMPARTMENT FRAME 947 HAS A MISDRILLED HOLE STRINGER 26 R. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR DOUBLER AND SHIMS IAW SRM. (K)SDR SWAA050182Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500D, STRINGER 27L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050181Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT FWD CARGO COMPT BS 440, STRINGER 24R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR AWXA200500228Frame · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1 INCH CRACK WAS FOUND IN MAIN CABIN FRAME AT R-1 DOOR BS 294.5, STR 7 RT. MAINTENANCE CUT OUT CRACK IN FRAME AT R-1 DOOR BS 294.5, STR 7 RT; FABRICATED A FILLER AND REPAIR ANGLE; INSTALLED REPAIR PARTS IAW 51-70-11.SDR 2006UALA00101Frame · crackedCABIN FS 616 BELOW STR 17R FRAME CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED ANGLE AND FILLER REPAIR REF MM 53-11-89.SDR ASAA0570015Frame · bentPAE - DURING MAINTENANCE CHECK, FOUND FORWARD FRAME CLOSURE WEB BENT, AFT CARGO DOOR CUT OUT. REPAIR IAW SRM 51-40-02. (M)SDR 05FDEA00140Frame · dentedSTATION 322 ON LEFT SIDE OF NOSE FUSELAGE JUST BELOW COCKPIT FLOOR FRAME IS DENTED. REFERENCE NON-ROUTINE N01203. COMPLIED WITH FEDEX EA 8-5310-83962,SDR 2005UALA00083Frame · damagedBS 178 BULKHEAD ON THE UPPER LT CHORD WAS FOUND TO HAVE INSUFFECENT EDGE DISTANCE AT WL 230 FOR REQUIRED OVERSIZING OF FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND INSTALLED SPLICE REPAIR.SDR 2005UALA00081Frame · dentedFWD PIT FRAME DENTED ON INBD FLANGE AT STA 620 JUST BELOW STR 24L. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE.SDR 2005UALA00080Frame · dentedAFT PIT STA 1480 FRAME IS DENTED ON INBD FLANGE, APPROXIMATELY STR 26L. REPAIRED FRAME FLANGE WITH NESTED J-ANGLE REPAIR.SDR 05FDEA00133Frame · dentedMAIN DECK CARGO COMPARTMENT LEFT AFT FUSELAGE UPPER MAIN FRAME AT STA 1701 FOUND WITH DENT. REPAIRED AS PER SRM 53-30-00 FIG1 VOL1. REFER TRACKING EA 1-5310-81698.SDR 05FDEA00132Frame · dentedMAIN DECK CARGO COMPARTMENT LEFT AFT FUSELAGE UPPER MAIN FRAME AT STA 1681 FOUND WITH DENT. MAIN FRAME AT STA 1721 BETWEEN LONGERON 11L TO 13L REPAIRED AS PER SRM 53-30-00 FIG1 VOL1. REFER TRACKING EA 1-5310-81680.SDR 05FDEA00131Frame · dentedMAIN DECK CARGO COMPARTMENT LT AFT FUSELAGE UPPER MAIN FRAME AT STA 1661 FOUND WITH DENT. MAIN FRAME AT STA 1661 BETWEEN LONGERON 11L TO 13L REPAIRED AS PER SRM 53-30-00 FIG1 VOL1. REFER TRACKING EA 1-5310-81679.SDR DLM88050045Frame · crackedFUSELAGE FRAME AT STATION 886 CRACKED ON FLANGE BELOW FLOOR LINE ADJACENT TO LONGERON 18R. FRAME REPLACED IAW ERA 095971-14.SDR SWAA050136Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 440, RBL 6, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050134Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 787, STRINGER 9R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0540035Frame · corrodedOKC - AFT CARGO COMPARTMENT STA B 927 FRAME IS CORRODED ON THE UPPER AND LOWER FLANGES, RBL 18 TO RBL 19. REMOVED DAMAGE, FABRICATED AND INSTALLED A REPAIR FILLER AND REPAIR ANGLE IAW SRM. (K)SDR SWAA050128Frame · crackedDURING SCHEDULED C4 CHECK, FOUND L1 COCKPIT WINDOW POST UPPER CORNER, CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA050127Shear Tie · crackedDURING SPV, FOUND 4 EACH SHEAR TIES BETWEEN BS 727C AND BS 767, STRINGER 4L, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR 72300073Frame · corroded1 INCH BY 3 INCH AREA OF CORROSION ON LOWER FRAME ANGLE.SDR SWAA050115Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 400, STRINGER 9R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA050114Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CHORD AT BS 616, RBL 65, CRACKED. REPAIRED FRAME CHORD SECTION PER ER.SDR 05FDEA00113Frame · crackedCRACKED FRAME BS 320 LBL 45 WL 148.5. *S/D* REPAIRED CRACKED FRAME AT BS 320, LBL 45, WL 148.5 IAW SRM 51-40-3 FIG 1 AND SRM 51-40-2 FIG 1.SDR USAA050204Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, BETWEEN STRINGER 8L AND 9L AT STATION 827. CUT OUT DAMAGE, HI FREQ, INSTALLED DOUBLER PER TR 53-10-20A. (M)SDR USAA050203Frame · crackedPIT - FOUND FRAME CRACKED .25 INCH, BETWEEN STRINGER 8L AND 9L AT STATION 867. CUT OUT DAMAGED AREA, HI FREQ INSTALLED DOUBLER PER TR 53-10-20A. (M)SDR SWAA050083Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 360, STRINGER 9R, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA050082Frame · crackedDURING SCHEDULED D-CHECK, FOUND 3 EACH FRAMES CRACKED BETWEEN BS 787 AND BS 907, STRINGER 9L. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA050081Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 380, STRINGER 9L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR 2005UALA00055Frame · crackedSTA 616 FRAME INNER CHORD IS CRACKED FROM BOTTOM FASTENER BELOW STR 17 LT. CUT-OUT DAMAGE AND INSTALLED ANGLE DOUBLER.SDR USAA050207Frame · crackedPIT - FOUND FRAME CRACKED .125 INCH FROM RIVET, STATION 727D BETWEEN S8/59R. REPAIR ANGLE PER TYPICAL REPAIR 53-10-20A. (M)SDR 2006FA0000814Frame · damagedDURING SCHEDULE INSP REQUIRED BY AD, FOUND 8.5 WEB SEPARATION AT FUSELAGE BS 950, RT BETWEEN STRINGER S-9 AND S-10. PARTIAL FRAME REPLACEMENT BETWEEN S-9 AND S-12 WAS ACCOMPLISHED. INSTALLED KIT NR 65C35283-2. ALL WORK DONE IAW DWG, SRM, SB, AND AD. (K)SDR UPS05443819Frame · crackedBS 940, S25L FRAME I/B CHORD FOUND CRACK. M/D BS 940 FRAME AT S-25L, FRAME REPAIRED PER RS R-53-22-35244 AND EO B747-5310-21670-A.SDR 2005F00027Frame · corrodedIG CORROSION ON FRAME AT BS 285 FROM STRINGER 24L TO STR 28L.SDR UPS05443716Frame · crackedINSPECTION TYPE:C - BS 960, S8R, FRAME FOUND CRACK. FRAME REPAIRED PER SRM 53-10-04 FIG 54.SDR UPS05443714Frame · crackedINSPECTION TYPE:C - FRAME BS 760 STR CUTOUT CRACKED AT S-6L AND S-7L. M/D BS 760 BETWEEN STR 6L AND STR 7L FRAME REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 54.SDR UPS05443712Frame · crackedINSPECTION TYPE:C - BS 740, BETWEEN S7 - 8R, FRAME FOUND CRACK. M/D BS 740 BETWEEN STR 7R AND STR 8R FRAME REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 54.SDR UPS05443711Frame · crackedINSPECTION TYPE:C - BS 760, BETWEEN STR 5 - 8R, FRAME FOUND CRACK. M/D BS 760 BETWEEN STR 5R AND STR 8R FRAME REPAIR CARRIED OUT IAW SRM 53-10-04 FIG 54.SDR UPS05443658Frame · crackedINSPECTION TYPE:C, FWD CARGO COMPT - SUPPORT FRAME WEB SURFACE FOUND CRACKED AT STA 880 BETWEEN STRINGER 37L TO STRINGER 38L. SUPPORT FRAME REPAIRED PER SRM 53-10-04 FIG 52.
Back to JASC 5311