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 UPS09554451Frame · damagedINSPECTION TYPE:C3 DAMAGE ON I/B SIDE OF FRAME BS 980 RBL WL 223. REMOVED AND REPAIRED DAMAGED AREA PER SRM B757-5310-19952C.SDR UPS09554450Frame · damagedINSPECTION TYPE:C3 STA 1460 MECHANICAL DAMAGE FRAME AT STRINGER 15R. REMOVED AND REPAIRED DAMAGED AREA PER SRM ADDENDUM B757-5310-19952C.SDR UPS09554449Frame · damagedINSPECTION TYPE:C3 STA 1540 MECHANICAL DAMAGE FRAME (10 PLACES) FROM STRINGER 16R. REMOVED AND REPAIRED DAMAGED AREA PER SRM ADDENDUM B757-5310-19952C.SDR AALA20090513TUL16Frame · crackedCANT FRAME CRACKED AT TAILCONE ALIGNMENT PIN, 9:00 POSITION. INSTALLED REPAIR DOUBLER PER SRM 53-01-00.SDR UPS09554534Frame · gougedINSPECTION TYPE:C2 MAIN CARGO DOOR LWR FRAME ANGLE BS 488 STR 14-15L IS GOUGED IN 3 PLACES. REPAIRED PER SRM 51-40-02, SRM 51-40-05 AND DRAWING 65-25327.SDR UPS09554448Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 860 STRINGER 15L IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554446Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 820 STRINGER 15L IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554445Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 780 STRINGER 15L IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554444Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 740 STRINGER 15L IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554443Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 700 STRINGER 15L IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554442Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 860 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 15-40-02.SDR UPS09554441Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 820 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554440Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 780 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554439Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 740 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554438Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 700 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554437Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 660 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554436Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 620 STRINGER 15R IS GOUGED. REPAIRED PER B757-5310-19952 AND SRM 51-40-02.SDR UPS09554435Frame · gougedINSPECTION TYPE:C3 FRAME AT BS 440 STR 15R IS GOUGED. REPAIRED PER B757-5310-19952, AND SRM 51-40-09.SDR DLM88090085Frame · crackedTHE FS 1437 UPPER FRAME BETWEEN LONGERON 1 AND 3R WAS FOUND CRACKED IN THE INNER AND OUTER CAPS AND THE WEB, APPROXIMATELY 3.75 INCH. THE WEB WAS REPLACED. THE TWO CAPS HAD THE DAMAGE CUTOUT, AND REPAIR ANGLES WERE INSTALLED.SDR SWAA090484Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090482Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090477Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 927, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA090476Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 320, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA090475Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 336, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR USAA2009012390145Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME CRACKED AT BS 787, BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 787, BETWEEN S8L & S9L IAW US AIRWAY TYPICAL REPAIR 53-10-02E.SDR FDEA200901210293Frame Splice · corrodedFWD CARGO COMPT, LT FRAME SPLICE CORROSION, STA 740, STR 26L. REMOVED AND REPLACED SPLICE PLATE STA 740, STR 26L IAW SRM 51- 40- 02. SPLICE FABRICATED ON MAE TRAV NR T9/ 777465 IAW SRM 51-40-05. CATEGORY A MAJOR REPAIR.SDR SWAA090470Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME STUB BEAM CRACKED AT BS 616, RBL 65, WL 207. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA090467Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA090455Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR FDEA200901210291Frame · crackedFRAME 44, LEFT LOWER SECTION NEEDS TO BE REPLACED DUE TO FASTENERS HOLES BEING OUT OF LIMITS REMOVED FRAME IAW SRM 51-40-21; PGS 6 AND 7. LOCATED AND DRILLED FRAME IAW SRM 51-72-10. INSTALLED IAW SRM 51-40-21 PGS 6 AND 7. APPLIED CIC IAW SRM 51-23-20.SDR FDEA200901210290Frame · crackedFRAME 44, RIGHT LOWER SECTION NEEDS TO BE REPLACED DUE TO THE FASTENER HOLES BEING OUT OF LIMITS. REMOVED FRAME IAW SRM 51-40-21; PGS 6 AND 7. LOCATED AND DRILLED FRAME IAW SRM 51-72-10. INSTALLED IAW SRM 51-40-21 PGS 6 AND 7. APPLIED CIC IAW SRM 51-23-20.SDR USAA2009020990306Frame · crackedCLT - Q5 MAJOR REPAIR - CRACK ON FRAME AT BS 500B BETWEEN S20L & S21L. REPAIRED FRAME AT BS 500B BETWEEN S20L & S21L IAW B737 SRM 53-00-07 & EA 100853.SDR ASOA200900117Frame · crackedF.S. 718 FRAMES CRACKED AND PREVIOUS REPAIRS. REPAIRED IAW SB 601R-53-055 REV B PART A, B, AND C. INSPECTED AND REPAIRED IAW EC/TC SB 601R-53-055 AND SB 601R-53-05501.SDR USAA2009012290128Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME IS CRACKED AT BS 500A, BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 500A, BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009012290127Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME IS CRACKED AT BS 827, BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 827, BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2009012290126Frame · crackedCLT - Q5 - MAJOR REPAIR - FUSELAGE FRAME HAS A .250 INCH CRACK AT BS 747, BETWEEN S8L & S9L, ALSO A .062 INCH CRACK AT BS 747, BETWEEN S8R & S9R. REPAIRED FUSELAGE FRAME AT BS 727 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-2SDR SWAA090432Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090431Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090430Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090429Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090428Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090417Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA090411Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER BOEING DWG.SDR SWAA090405Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR. 8L. REPAIRED FRAME PER SWA EA.SDR ZZDA2009015Frame · corrodedAFT CARGO COMPARTMENT CENTER BILGE FRAME 974 HAS CORROSION L 29L AND L 29R - OUT OF LIMITS. INSTALLED ROLLED Z-FRAME REPAIR SPLICE IAW B717 SRM 58-20-07 FIG 201 REP 3.SDR C2XA09SH014Frame Splice · corrodedDURING C-CHECK. CIRCUMFERENTIAL SPLICE AFT OF FR 66 HAS AREAS OF CORROSION STR. 19L - 21R. R&R CIRCUMFERENTIAL SPLICE AT STR 19L-21R IAW EMB 145 SRM 53-00-02. THIS ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DHLA2009743DH618Frame · corrodedLOWER FUSELAGE E/E COMPARTMENT AT BS 460 BETWEEN S-23L AND S-24L FRAME WITH CORROSION. REPAIRED FRAME SECTION SHEAR TIE AT BS 460 BETWEEN S-23L AND S-24L IAW B727 SRM 53-10-4 FIG 13 AND REPLACED SHEAR TIE P/N 69-13293-3 IAW B727 SRM 51-10-1 PARA 7A.SDR FDEA200901190252Frame · gougedAFT CARGO PIT STA 1320 STR 26-27L FRAME IS GOUGED. REPAIRED FRAME AT STA 1320 STR 26-27L IAW SRM 53-00-07 FIG 201 SHEET 4. THIS REPAIR IS A CATEGORY "B" MAJOR REPAIR.SDR FDEA200901190266Frame · crackedCABIN, RIGHT STATION 1781 LONGERON 13 RIGHT FRAME SPLICE FOUND CRACKED. FABRICATED AS PER DRAWING AFA0030. SPLICE REMOVED AND REPLACED AS PER SRM 51-31-01 VOL. II. THIS REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR FDEA200901190253Frame · dentedFRAME STA 940 UPPER FLANGE HAS DENT AT STR 6L. REPAIRED FRAME AT STA 940 STR 6L IAW SRM 53-00-07 REPAIR NR 1 DETAIL II. THIS REPAIR IS A CATEGORY "A" MAJOR REPAIR AND NO FOLLOW UP ACTION REQUIRED.
Back to JASC 5311