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 UPS06446968Frame · crackedINSPECTION TYPE:C M/D LEFT BS 434 FRAME ABOVE S26L AREA FOUND 1EA HOLE CRACK AT FRAME INNER CHORD. CRACK LENGTH .0625 INCH. FRAME CHORD REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS06446953Attach Bracket · crackedINSPECTION TYPE:C M/D BS 434 FRAME ATT BRACKET AT 26L FWD FOUND CRACK. CRACK LENGTH 3/8". M/D BS 434 FRAME ATT BRACKET AT STR 26L AREA REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS06446921Frame · crackedLT BS 2231 FRAME INNER FLANGE BETWEEN S24L AND S25L FOUND 1 HOLE CRACK AT FRAME STRAP CRACK LENGTH 1/16". BS 2231 LT FRAME ATTACH STRAP REPAIRED BETWEEN STR 24L TO 26L AS PER SRM 53-10-04 FIG 15. CONTINUED INSPECTION IS REQUIRED AS PER SRM 53-10-04 FIG 115 TSDR AWXA200600970Frame · crackedNR 5868264 - DURING C19 CHECK DISCOVERED LOWER OB CHORD OF THE BS 188 FRAME CRACKED, .5 INCHES, AT BL 35R AND WL 207. MAINTENANCE REPAIRED THE LOWER OB CHORD OF THE BS 188 FRAME AT BL 35R AND WL 207 IAW ENGINEERING REPAIR NR 03-5300-06152-ES2.SDR AWXA200600957Frame · crackedNR 5868263 - DURING C-19 CHECK, DISCOVERED 188 FRAME CRACKED AT LBL 35 WL 207. MAINTENANCE REPAIRED BS 188 FRAME AT LBL 35 WL 207 IAW AWA ER 03-5300-06153-GS1.SDR 06FDEA1702Frame · gougedLWR FWD CARGO DOOR CUTOUT AFT SIDE FRAME IS GOUGED FWD OF LATCH FITTING STR 23 RT. REPAIRED LOWER FWD CARGO DOOR CUTOUT AFT SIDE FRAME IAW FED EX EA 7-5310-99516.SDR TRAX200600181Frame · crackedLT FRAME STA 718 CRACKED AT STR 11, RESOLVED ON W/O: 24018 TASKCARD: N/R-00140. REPAIRED LT FRAME STA 718 CRACK IAW SRM 51-42-16 AND REO 601R-53-61-193-1.SDR SWAA061511Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT SIDE FRAME CRACKED AT BS 178, WL 207. REMOVED AND REPLACED RT FRAME PER ACO.SDR SWAA061510Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT SIDE FRAME CRACKED AT BS 178, WL 207. REMOVED AND REPLACED LT FRAME PER ACO.SDR ASAA0640543Frame · corrodedCORROSION FOUND ON FRAME. REPLACED FRAME PER SRM 51 40 2 AND 53 00 07.SDR USAA060652Frame · dentedFOUND FRAME DENTED, BS 747 ABOVE S-25R. INSTALLED FABRICATED PART, IAW TR 553-60-07, DEFECT SIZE: .500 BY .500 BY .04.SDR USAA060653Frame · crackedFOUND FRAME CRACKED STA 867 BETWEEN S10L AND S9L. REPAIRED TR 53-10-20C, DEFECT SIZE: .25.SDR 2006UALA00862Frame · crackedCABIN BODY FRAME WEB OTBD CHORD IS CRACKED AT STRINGER CUTOUT BS 663, STR 2L.SDR 2006UALA00861Frame · damagedAFT PIT, STA 747 JUST IB OF STR 25L, FUSELAGE FRAME UPPER CHORD HAS 1 EACH DAMAGED FASTENER HOLE (COMMON TO Z ANGLE).SDR 2006UALA00858Frame · crackedFOUND BS 1140 STR 10R FRAME AND FWD AND AFT TENSION TIES CRACKED.SDR SWAA061479Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME CRACKED AT FWD SERVICE DOOR CUTOUT, AFT FRAME, NR 3 STOP FITTING. REPAIRED FRAME SECTION PER SRM.SDR SWAA061478Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME WEB CRACKED AT FWD ENTRY DOOR CUTOUT, FWD LOWER STOP, BS 303. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA061477Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REMOVED AND REPLACED FRAME SECTION PER SWA EA.SDR AWXA200600756Frame · crackedDURING C19 CHECK DISCOVERED FWD CARGO DOOR, AFT FRAME CRACKED, 1.5 INCHES, AT LOWER DOOR STOP STR 24R AND BS 492.40. MAINTENANCE TRIMMED OUT DAMAGED AREA IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5332-06118-ES1. FABRICATED REPAIR DOUBLERS (ANGLES) ASDR AWXA200600755Frame · crackedDURING C19 CHECK DISCOVERED FWD CARGO DOOR, FWD CUT-OUT FRAME CRACKED, 1.9 INCHES, AT DOOR STOP WL 160, STR 24R AND BS 440. MAINTENANCE TRIMMED OUT DAMAGED AREA IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5332-06118-ES2. FABRICATED REPAIR DOUBLERS (ANSDR 2006UALA00853Frame · gougedFUSELAGE TAIL COMPARTMENT BODY FRAME WEB IS GOUGED NEAR APU BLEED DUCT CUT OUT BS 1040 AFT, LBL 5.SDR ASAA0640522Frame · corrodedAFT CARGO DOOR CUTOUT FWD FRAME HAS CORROSION ON FRAME AND WEB. REPLACED FRAME PER SRM 51 40 02.SDR USAA060643Frame · crackedFOUND FRAME CRACKED RBS 867R BETWEEN S8L AND S9L. REPAIRED FRAME IAW SRM 53-00-07, DEFECT SIZE: .025".SDR USAA060646Frame · crackedFOUND FUSELAGE FRAME CRACKED STA 847 B5 STOP FOOTPRINT. REMOVED AND REPLACED FRAME SECTION IAW BOEING DWG 65-47960, 69-42945, 65C35243-6, SRM 53-60-15, DEFECT SIZE: .125".SDR USAA060641Frame · crackedFOUND CRACK BS 867L BETWEEN S8L AND S9L. REPAIRED FRAME IAW SRM 53-00-07 DEFECT SIZE: .025".SDR SWAA061473Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT FWD CARGO DOOR CUTOUT BS 492, NR 5 STOP PAD. REMOVED AND REPLACED FRAME SECTION PER ER AND SB.SDR SWAA061472Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT AFT CARGO DOOR CUTOUT BS 847, NR 1 LOWER DOOR STOP. REMOVED AND REPLACED WEB PER ER.SDR 200600092Structure · ground damageDURING GROUND HANDLING, AIRCRAFT WAS STRUCK ON THE RT SIDE OF THE FUSELAGE, FWD OF THE AOA SENSOR AND BEHIND THE LOWER PITOT PROBE. CAUSED A DENT 12 INCHES LONG, BY 5 INCHES WIDE. A FURTHER DENT WAS CAUSED IN THE RVSM AREA, JUST AFT OF THE LWR PITOT PROBE.SDR ASAA0640524Frame · corrodedFOUND CORROSION ON LWR EDGE FRAME UNDER PRESSURE SEAL ON RT FWD OVER WING EXIT. REPAIRED PER EA 5220 01012.SDR SWAA061444Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 847, AFT CARGO DOOR CUTOUT NR 1 DOOR STOP FITTING. REPAIRED FRAME WEB PER ER.SDR QXEA200601578Frame · corrodedYYC - C3 FUSELAGE INTERIOR FRAME AT X19.400, BLO HAS AREA OF CORROSION AROUND SPLICE. REPAIRED IAW DHC-8-400 SRM TASK 51-20-00-350-801, 51-21-10-380-801 AND SRM TASK 51-42-05-330-801.SDR QXEA200601579Frame · corrodedYYC - C3 FUSELAGE INTERIOR FRAME AT X1.000. BLO HAS AREA OF CORROSION AROUND SPLICE. REPAIRED IAW DHC-8-400 SRM 51-42-05-330-801, 51-21-00-350-801, 51-21-10-380-801 AND SRM TASK 51-42-05-330-801.SDR UPS06547037Frame · dentedINSPECTION TYPE:N/A DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1460 BETWEEN STR 25L AND 26L. COMPLIED WITH FINAL EA 757-5362-27-A1432-A AND UPS EO B757-5310-24239- A.SDR UPS06547036Frame · dentedINSPECTION TYPE:N/A DENTS IN AFT CARGO COMPARTMENT FUSELAGE 1220 BTWEEN STR 25R & 27R. COMPLIED WITH EA 757-5362-27-A1434 & UPS EO B757-5310-24234.SDR 2006UALA00846Frame · crackedCABIN BS 274 BTWN STRINGER 10R AND 11R FRAME CRACKED ON FWD SIDE NEAR STRINGER CUTOUT.SDR 2006UALA00845Frame · crackedFOUND CABIN FRAME CRACKED STATION 867 BETWEEN STRINGERS 8L-9L AT PSU ATTACH BRACKET.SDR 2006UALA00844Frame · crackedCABIN FRAME CRACKED AT STATION 747 BETWEEN STR 8-9L AT PSU ATTACH BRACKET.SDR 2006UALA00843Frame · crackedCABIN FRAME CRACKED STA 827 BETWEEN STRINGERS 8-9L AT PSU ATTACH BRACKET.SDR 2006UALA00842Frame · crackedCABIN FRAME CRACKED AT STATION 907 BTWN STRINGERS 8L-9L AT PSU ATTACH BRACKET.SDR 2006UALA00841Frame · crackedCABIN FRAME CRACKED BS 787 BTWN STRINGERS 8L-9L AT PSU ATTACH BRACKET.SDR 2006UALA00840Frame · crackedFOUND CABIN BS 440 BETWEEN STRINGER 8R AND 9R FRAME CRACKED AT PSU SUPPORT RAIL CLIP.SDR UPS06547035Frame · dentedINSPECTION TYPE:N/A DENT IN AFT CARGO FUSELAGE FRAME STA 1480 BETWEEN S25R TO S26R. COMPLIED WITH EA 757-5363-27-A1430 & UPS EO B757-5310-24232A.SDR DUR42006416Frame · dentedFOUND FRAME DENTED AT S-25L IN AFT PIT BS 1480. CUT OUT DENTED AREA IAW B757 SRM 51-70-11. FABRICATED AND INSTALLED FORMED SECTION REPAIR 210.50" BY 4.75" FROM 7075-0 .050" HEAT TREATED TO TPS-1002 IAW B757 SRM 51-20-01 AND 51-70-11.SDR 2006UALA00832Frame · crackedDURING HMV FOUND A CRACK COMMON TO THE FORWARD FRAME 65-20722-84.SDR F3LA200600022Frame · damagedDURING C-3 CHECK, INSPECTION REPORTED FRAME 55 AT STR 2L DAMAGED INBD SIDE AFT EDGE. BURNISHED DAMAGED AREA PER ASRM 51-73-00. PERFORMED HFEC ON WORKED AREA AND FOUND NO DEFECTS PER NDTM PART 6, 51-10-08, PAGE 601. TREATED AND PRIMED AREA PER AMM 51-23-00 ASDR F3LA200600020Frame · damagedDURING C-3 CHECK, INSPECTION REPORTED FRAME 55 AT STR 2R DAMAGED INBD SIDE AFT EDGE. BURNISHED DAMAGED AREA PER SRM 51-73-00. PERFORMED HFEC ON WORKED AREA AND FOUND NO DEFECTS PER NDTM PART 6, 51-10-08, PAGE 601. TREATED AND PRIMED AREA PER AMM 51-23-00 ANSDR MALA060277Frame · corrodedDURING 2 YEAR CHECK IN BNA, FOUND UPPER FLANGE OF FRAME AT FS 272 AND RBL 28 IS CORRODED OUT OF LIMITS AND HAS BEEN REPAIRED IAW MESABA EO#S53108. REF: EAMS WORK ORDER 213767 TASK 1516.SDR ASAA0640518Frame · crackedNR 2 ENGINE PYLON CRACK IN FRAME. REPAIRED PER EA 5440 01050 AND ER 06 1834.SDR ASAA0640507Frame · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED.SDR 06FDEA1618Frame · crackedDURING AIRPLANE'S CONVERSION FROM P TO F/ACF FOUND: STA 421 LT SIDE Z = -60, FRAME WITH CRACK 1 INCH LONG. REPAIR IAW SRM 53-00-01 FIG 8 VOL I.
Back to JASC 5311