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 SWAA093081Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 440, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093080Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093079Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 380, STR 8R. REPAIRED WEB PER SWA EA.SDR SWAA093046Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 794, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER ACO.SDR SWAA093044Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER WA.SDR SWAA093043Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER WA.SDR RMXA051220097098Frame · crackedDURING SCHEDULED MAINTENANCE, A 1 INCH LONG CRACK WAS DISCOVERED IN THE FUSELAGE TAILCONE LT A FRAME PT NR 117-22106-01.SDR ASOA200900540Frame · crackedRT FS 718 IS CRACKED BETWEEN STRINGERS 10 AND 11. REPAIRED FRAMES IAW SB 601R-53-055, PART C & C STRUCTURAL REPAIR. THE REPAIR MEETS WITH ALL THE REQUIREMENTS OF SB 610R53-055, REV B.SDR SWAA093039Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093016Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND BS 559 RT LWR FWD AND AFT FASTENER HOLES COMMON TO THE WING CHORD CRACKED. REPAIRED FRAME PER SWA EA.SDR ZZDA2009155Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 2. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2987.SDR ZZDA2009154Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2976.SDR FDEA200905111609Frame · corrodedFOUND CORROSION AROUND ANCHOR NUTS HOLES OF FRAME 20A, P28-39 RT REPAIR PERFORMED BY BLEND OUT THE CORROSION AND SPLICING A NEW SECTION BETWEEN P 33-36 RT IAW RAS/EFW/9000168/2009, APPROVED BY EA 6-5310-129155.SDR IPXA09556085Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 1300, STR 5R AND 15R. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR IPXA09556077Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 1460, STR 5L AND 15L. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR IPXA09556074Frame · damagedINSPECTION TYPE:C3 FRAME HAS SCREW STRIKE, BS 1220, STR 5L. REPAIRED FRAME PER SRM ADDENDUM B757-5310-19952-C APPENDIX A.SDR CALA2009051400254Frame · crackedB737-53-3-0739 CABIN STA 480 BETWEEN S8L AND S9L, PSU RAIL SUPPORT BRACKET TO FRAME CRACKED. REPAIRED CABIN FRAME AT STA 480 BETWEEN S8L AND S9L REF ECRA 5310-04946. SEE L/P 9883425 FOR GENERATION OF DIP (CONTROL 93982).SDR CALA2009051400253Frame · crackedB737-53-3-0739 CABIN STA 440, BETWEEN S8R AND S9R PSU RAIL ATTACHED SUPPORT TO FRAME CRACKED. REPAIRED CABIN FRAME AT STA 440 BETWEEN S8R AND S9R REF ECRA 5310-04946. SEE L/P 9883425 FOR GENERATION OF DIP (CONTROL 93982).SDR CALA2009051400252Frame · crackedB737-53-3-0739 CABIN STA 400 BETWEEN S8R AND S9R PSU RAIL SUPPORT BRACKET TO FRAME CRACKED. REPAIRED CABIN FRAME AT STA 400 BETWEEN S8R AND S9R REF ECRA 5310-04946. SEE L/P 9883425 FOR GENERATION OF DIP (CONTROL 93982).SDR CALA2009051400249Frame · crackedB737-53-3-0739 CABIN STA 400 BETWEEN S8L AND S9L PSU RAIL SUPPORT BRACKET TO FRAME, CRACKED. REPAIRED CABIN FRAME AT STA 400 BETWEEN S8L ANDS9L REF ECRA 5310-04946. SEE L/P 9883425 FOR GENERATION OF DIP (CONTROL 93982).SDR SWAA092991Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER EA.SDR SWAA092990Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA092989Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER EA.SDR ASAA0945563Frame · gougedGOUGE OUT OF LIMITS ON FRAME CLOSE OUT WEB. FABRICATED NEW WEB.SDR IPXA09556107Frame · damagedINSPECTION TYPE:C3 INNER FLANGE OF BS 160 FRAME, STR 15L HAS SCREW DAMAGE EXCEEDING THE SRM LIMITS. REPAIRED PER ATS ER 09-2771 DATED 21 MAY 09.SDR IPXA09556106Frame · damagedINSPECTION TYPE:C3 INNER FLANGE OF BS 1640 FRAME, STR 14L HAS SCREW DAMAGE EXCEEDING THE SRM LIMITS. REPAIRED PER ATS ER 09-2771 DATED 21MAY2009.SDR IPXA09555824Frame · dentedINSPECTION TYPE:C4 FRAME DENTED AT STA 1520 LBL 26 STR 26L ABOVE FLOOR TO SIDEWALL SUPPORT. REMOVED DAMAGE & REPAIRED DAMAGE PER SRM 53-00-07-2R, ER 09-2554 AND EO B757-5310-33409.SDR ASAA0945546Frame · misrepairedEXISTING REPAIRS ON 847 FRAME NOT PER DWG A 5330018185 FIG 5. REMOVED AND REPLACED FRAME.SDR COMA2009051150132Frame · crackedFS 605.00 FRAME UNDER CARGO DOOR SILL IS CRACKED WHERE IT ATTACHES TO SKIN IN OUTER RADIUS. REMOVED DAMAGE FRAME SECTION AT FS 605.00 JUST BELOW CARGO DOOR SILL AND INSTALLED SERVICEABLE FRAME IAW CRJ SRM 51-42-06 PG 1-20, CRJ SRM 51-42-21 PG 1-21 AND SR 99-5SDR IPXA09556166Frame · gougedINSPECTION TYPE:C3 INNER FLANGE OF THE BS 345 FRAME STR 15L IS GOUGED BEYOND SRM LIMITS. INSTALLED REPAIR DOUBLER IAW EO B757-5310-33673-A.SDR IPXA09556165Frame · gougedINSPECTION TYPE:C3 INNER FLANGE OF THE BS 365 FRAME STR 15L IS GOUGED BEYOND SRM LIMITS. REPAIRED FRAME PER ATS ER 09-2774 DATED 27MAY2009.SDR IPXA09556164Frame · gougedINSPECTION TYPE:C3 INNER FLANGE OF FRAME BS 365, STR 15R IS GOUGED BEYOND SRM LIMITS. REPAIRED GOUGED PER ATS ER 09-2770.SDR IPXA09556061Frame · damagedINSPECTION TYPE:C3 INNER FLANGE OF FRAME BS 395 HAS 10 DRILL STRIKES STR 6-16 R. INVESTIGATED AND REPAIRED ALL DAMAGED LOCATIONS (10) AT BS 395 STR 6R TO 16R. PER SRM 53-00-07-1A1 AND SRM ADDENDUM, B757-5310- 19952C.SDR ZZDA2009153Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR ZZDA2009152Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2980.SDR ASAA0945547Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTER LINE DUCT SUPPORT STA 767 2IN LT SIDE OF STR 1. REPAIRED IAW SRM.SDR ASAA0945540Frame · crackedFRAME CRACKED AT FASTENER HOLE FOR OVERHEAD CENTER LINE DUCT SUPPORT STA 767 2 INCHES LT SIDE OF STR 1. TRIMMED OUT DAMAGE AND REPAIRED PER SRM.SDR ZZDA2009150Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2986.SDR ZZDA2009149Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2979.SDR ZZDA2009139Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2989.SDR USAA2009052991343Frame · crackedCLT - Q1 - MAJOR REPAIR - NR 03-0553-8-0538/001 - CRACK ON FUSELAGE FRAME AT BS500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR IPXA09556100Frame · gougedINSPECTION TYPE:C3 INNER FLANGE OF THE BS 660 FRAME, STR 15L IS GOUGED BEYOND SRM LIMITS. BLENDED GOUGE OUT OF LIMITS PER SRM 53-00-07-1A AND REPAIRED IAW EO B757-5310-33506-A.SDR AALA20090512TUL59Frame · crackedCANT FRAME 1474 CRACKED. INSTALLED DOUBLER ON CANT FRAME AT L18L PER ZAARD 53-10-00-15.SDR ASAA0945514Frame · crackedFRAME CRACKED STA 440 BETWEEN STR 8R AND 9R OUT OF LIMITS SRM 53-00-07. REPAIRED PER SRM.SDR ASAA0945513Frame · crackedFRAME CRACKED STA 480 BETWEEN STR 8R AND 9R OUT OF LIMITS SRM 53-00-07. REPAIRED FRAME IAW SRM 53-00-07.SDR SWAA092925Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 986, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA092920Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 13L. REPAIRED FRAME PER EA.SDR SWAA092917Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CHORD CORRODED AT BS 727B, BETWEEN STR 26L TO STR 27L. REPAIRED CHORD PER SRM.SDR SWAA092912Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 19L. REPAIRED FRAME PER ER.SDR SWAA092885Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER AAR EA.
Back to JASC 5311