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 GLBA20110601JFrame · crackedDURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND FRAME CRACK AT FS 164 & STRINGER 9AR AT THE STRINGER CUTOUT, .3" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-038. MATERIALS UTILIZED ARE SDR GLBA20110601GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND A CRACK IN THE SKIN AT FS 150 & STRINGER 9AL AT THE LOWER SNUBBER MOUNT AND AS DOOR FUSELAGE FRAME CRACKED AT SNUBBER UP MOUNT NUTPLATE AREA, BOTH 1.3" IN LENGTH. MAINTENANCE REPAIRED THE ASDR GLBA20110601HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP, MX FOUND A CRACK IN THE FRAME AT FS 456 AT STRINGER 10R CUTOUT, LWR INBD EDGE, .25" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-037. MATERIALS UTILIZED ASDR SIMA201115403Frame · gougedDURING MAINTENANCE BASE VISIT FOUND THE RIGHT CARGO FRAME 64 TO BE GOUGED. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLETED REPAIR TO FRAME 64 IAW EO EM-53MR-1818. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA114062Frame · crackedDURING SCHEDULED 12Y CHECK FOUND, FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA114061Frame · crackedDURING SCHEDULED 12Y CHECK FOUND, FRAME CRACKED AT BS 727, WL 201. REPAIRED FRAME PER EA.SDR AALA20110601TUL12Frame · crackedAFT ACCESSORY 1510 CANT FRAME CRACKED ABOVE MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER EA MD80-53-017199.SDR SWAA113997Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 807, BETWEEN LBL 5 TO RBL 5. REPAIRED FRAME PER SRM.SDR FDEA201106012064Frame · damagedAFT LOWER CARGO, AFTER REMOVAL OF REVEAL PANEL AT STA 1380 FOUND 1 EA. ELONGATED FASTENER HOLE BETWEEN STRINGERS S26R & S27R. DAMAGED AREA REPAIRED IAW EA F-5310-146475, PART 1 (FUSELAGE BS 1380 FRAME INNER CHORD ELONGATED FASTENER HOLE AND EXTRA HOLES REPAIR)SDR SWAA113971Frame · corrodedDURING SCHEDULED 18Y CHECK FOUND, FRAME CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA113966Frame · crackedDURING SCHEDULED 20Y CHECK FOUND, FRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB PER SRM.SDR SWAA113955Frame · crackedDURING SCHEDULED 26Y CHECK FOUND, FRAME CRACKED AT BS 727C, STR 14R. REPAIRED FRAME PER ER.SDR EE4Y1106027Frame · crackedAFT UPPER FUSELAGE STA 1437 -X6.5 FRAME INBD CHORD VERTICAL FLANGE WITH CRACK. REPAIRED IAW EO APPROVED BY FAA DER.SDR IPXA1567647Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 660, STR 15L. REPAIRED IAW ER 11-03034, SRM 53-00-07-1A1, 51-40-09-0G, AMM 25-55-07, 25-55-00-4.SDR IPXA1567633Frame · damagedINSPECTION TYPE:C1, SECTION 41, FUSELAGE UPPER LOBE INTERIOR, FRAME ASSY INBD FLANGE HAS A SCREW STRIKE AT BS 345.0, AND 3"ABOVE S-10L. REPAIRED IAW ATS 11-03028.SDR IPXA1567631Frame · damagedINSPECTION TYPE:C1, SECTION 41, FUSELAGE UPPER LOBE INTERIOR, FRAME ASSY INBD FLANGE HAS A SCREW STRIKE AT BS 345.0, AND 3" ABOVE S-10L. REPAIRED IAW ATS 11-03028.SDR IPXA1567626Frame · damagedINSPECTION TYPE:C1, MAIN CARGO FRAME INBD FLANGE HAS 2 EA SCREW STRIKES BS 1060 BETWEEN STR 15L-16L. REPAIRED IAW ER 11-03025, DATED 06-30-11.SDR IPXA11567590Frame · damagedINSPECTION TYPE:C1, MAIN CARGO FRAME INBD FLANGE HAS SCREW STRIKE BS 1020, BETWEEN STR 15L-16L. REPAIRED IAW ER 11-03021.SDR IPXA11567568Frame · damagedINSPECTION TYPE:C1, SECTION 41, FUSELAGE UPR LOBE INTERIOR, FRAME ASSY INBD FLANGE HAS A SCREW STRIKE AT B.S 395, AT S-8L. REPAIRED IAW ATS ER 11-03030.SDR IPXA1567441Frame · damagedINSPECTION TYPE:C1, MAIN CARGO FRAME INBD FLANGE HAS SCREW STRIKE BS 1100 BETWEEN STR 15L-16L. REPAIRED IAW ATS ER 11-03026.SDR IPXA11567272Frame · damagedINSPECTION TYPE:C1, BS 1380 FRAME, BETWEEN STR-15R AND 16R HAS 2EA SCREW STRIKE. REPAIR IAW ER11-03005.SDR IPXA1567033Frame · damagedINSPECTION TYPE:C1, MCB BS 1580 FRAME, BETWEEN STR-15R AND 16R HAS 1 EA SCREW STRIKE. REPAIRED DAMAGE ON FRAME IAW SRM 53-60-07-01I, SRM 53-00-07-1A1, SRM 51-40-05-0G, SRM 51-40-02-0G, AND EO B757-5310-39560-B, DATED 12/29/2010.SDR IPXA1567024Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 700 JUST BELOW STR 15L. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST, AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR IPXA1567023Frame · damagedINSPECTION TYPE:C1, 2 SCREW STRIKES ON FRAME AT BS 740 JUST BELOW STR 15L. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST, AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR IPXA1567022Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 780 JUST BELOW STR 15L. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST, AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR AALA20110531TUL05Web · crackedAFT ACCESSORY WEB CRACKED 1485 CANT FRAME LEFT OF RUDDER PACK. DOUBLER INSTALLED PER AARD 53-10-00-32.SDR SWAA113930Failsafe · corrodedDURING SCHEDULED 14Y CHECK FOUND, FAIL-SAFE FRAME CORRODED AT BS 807, STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR CALA2011053100405Frame · cracked737-53-3-0734; CABIN - CRACK ON FRAME AT STA 380, STRINGER 9R. REPAIRED FRAME AT STA 380 BETWEEN STR 8R AND 9R PER EA 5310-04716 REV C OP 2.SDR IPXA11567448Frame · damagedINSPECTION TYPE:C1, MAIN CARGO FRAME INBD FLANGE HAS A SCREW STRIKE BS 980 BETWEEN STR 15L-16L. REPAIRED IAW ER 11-03027, AND EO B757-5310-43212A.SDR IPXA11567447Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE BS 1380, 1 EA SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). REPAIRED IAW ER 11-03039.SDR IPXA11567318Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE, BS 1300 2EA, SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). REPAIR IAW ER 11-03037; SRM 53-60-07-0I1, SRM 53-00-07-1A1, SRM 51-40-02-0G; SRM 51-20-01-0G; EO B757-5310-39560.SDR IPXA1567031Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE, BS 1220, 2 EA SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). REPAIRED DAMAGE ON FRAME IAW SRM 53-60-07-01, SRM 53-00-07-1A1, SRM 51-20-01-0G, SRM 51-40-02-0G, AND EO B757-5310-39560-B, DATED 12/29/2010.SDR IPXA1567028Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE, BS 1240, 1 EA SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). REPAIRED DAMAGE ON FRAME IAW SRM 53-60-07-01I, SRM 53-00-07-1A1, SRM 51-20-01-0G, SRM 51-40-02-0G, AND EO B757-5310-39560-B DATED 12/29/2010.SDR IPXA1567027Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE, BS 1400, 1 EA SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). FOUND DAMAGE TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. ENSURED CRACK FREE CONDITION AND FILLED HOLE WITH REPAIR FASTENSDR IPXA1567026Frame · damagedINSPECTION TYPE:C1, MCB FRAME, LT SIDE, BS 1420, 1 EA SCREW STRIKE, BETWEEN STR 15L AND 16L (MARKED). FOUND DAMAGE TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. ENSURED CRACK FREE CONDITION AND FILLED HOLE WITH REPAIR FASTENSDR IPXA1567025Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 780 JUST BELOW STR 15R. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST, AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR IPXA1567021Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 700 JUST BELOW STR 15R. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST, AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR IPXA1567020Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME AT BS 740 JUST BELOW STR 15R. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-07-1A1. REMOVED DAMAGE BY DRILLING. VERIFIED NO CRACKS EXIST AND FILLED HOLE WITH REPAIR FASTENER IAW EO B757-5310-39560B.SDR DALA1139020915Frame · crackedCRACK ON FRAME STA 937 AND X=-6 BELOW KEEL BEAM. STOPPED DRILLED CRACKS AND INSTALLED FABRICATED REPAIR PART.SDR USAA2011060800028Frame · crackedCLT - Q4 - CRACK IN FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REP 13.SDR USAA2011060800020Frame · crackedCLT - Q4 - CRACK IN FUSELAGE FRAME AT BS 500G BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500G BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA1136891353Strap · wornREFERENCE ERA 492639-14AD FAILSAFE STRAP REPAIR STA 955.SDR DALA1136881335Strap · wornREFERENCE ERA 492638-14AD RAM ACFT, 1353 FAILSAFE STRAP REPAIR.SDR ABXR2011052800037Strap · crackedRT FAILSAFE STRAP CRACKED. REPAIRED IAW REA 46868REA01.SDR ABXR2011052800034Strap · crackedLT FAILSAFE STRAP CRACKED. REPLACED FAILSAFE STRAP IAW REA 46868REA09.SDR FDEA201105271997Frame · damagedDENT AT FRAME 70 STR 26/27 LT. DAMAGE ASSESSED IAW SRM 53-10-12 AND FOUND TO BE OUT OF LIMITS DUE TO DAMAGE PROXIMITY TO FRAME. REPAIR CARRIED OUT IAW SRM 53-10-12 FIG 225/53-10-14 PARA 4B FIG 102. JPF STAGES 1 TO 9 REFER. MAJOR REPAIR CARRIED OUT, ORIGINSDR USAA2011060800019Frame · crackedCLT - Q4 - CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR HNAA2011060100157Frame · corrodedRIB AT X222, STRINGER 30-31 HAS CORROSION. REMOVED VERTICAL FLOOR SUPPORT FRAME. REMOVED RIB SECTION AT X222 BETWEEN STRINGERS 32P AND 28S. COMPLIED WITH HFEC INSPECTION, NO DEFECTS NOTED. SPLICE FRAME AT X222 IAW EO8-53-11-0289.SDR HNAA2011060100156Frame · corrodedRIB AT X240.5, STA. 31S HAS CORROSION. REMOVED RIB SECTION AT X240.5 BETWEEN STRINGER 32P AND STRINGER 28S. COMPLIED WITH HFEC IAW EO8-53-11-0289. NO DEFECTS NOTED. SPLICE FRAME AT X240.5 IAW EO8-53-11-0289.SDR IPXA11566842Frame · dentedINSPECTION TYPE:C3, FRAME IS DENTED. INBD FLANGE, STA 540, WL 213, BETWEEN STR 16-17R. REPAIRED IAW ER 11-02733, DATED 27MAY2011.
Back to JASC 5311