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 SWAA072793Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072791Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072794Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072797Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072796Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072795Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072792Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700278Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 887 BETWEEN STRINGERS 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR UPS07450034Frame · crackedINSPECTION TYPE:C BS 800 RT SIDE AT STR16 INNER CHORD 1 HOLE FOUND CRACKED AT 9 O/C POSITION WITH LENGTH 0.125" LENGTH. M/D BS 800 RT SIDE FRAME FWD INNER CHORD AND STRAP REPAIRED AT BETWEEN STR 15R TO STR 18R AREA AS PER RS R53-21-35812. POST REPAIR INSPECTSDR SWAA072788Frame · crackedDURING SCHEDULED PAE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072789Frame · crackedDURING SCHEDULED PAE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072790Frame · crackedDURING SCHEDULED PAE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700287Frame · crackedINSPECTION FOUND A 5 INCH CRACK IN AFT CARGO DOOR CUTOUT FORWARD FRAME AT LOWER DOOR STOP AREA, STA 947.5, S16R-26R. THE FRAME WAS REPLACED IAW SRM 51-40-02 AND BOEING DRAWING 65-20723, AND ECRA 5311-01323.SDR CALA0700286Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 480 BETWEEN STRINGER 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700285Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 847 BETWEEN STRINGER 8R AND 9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700284Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 867 BETWEEN STRINGER 8R AND 9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700283Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 827 BETWEEN STRINGER 8R AND 9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700282Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 887 BETWEEN STRINGER 8R AND 9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700281Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 807 BETWEEN STRINGER 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700280Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 747 BETWEEN STRINGER 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700279Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 827 BETWEEN STRINGER 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR CALA0700277Frame · crackedINSPECTION FOUND A .25 INCH CRACK IN FUSELAGE FRAME AT STA 867, S8L-9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04636.SDR QXEA200700893Frame · chafedC4 PDX - FUSE CIRCUMFERENTIAL FRAME HAS CHAFE DAMAGE AT STATION X1.000 AT Z100.032 UNDER MAIN CABIN DOOR APERTURE LOWER FORWARD CORNER CASTING. REPAIRED IAW SRM 53-20-15 AND RD8/4-53-1928.SDR 2007UALA01762Frame · crackedFUSELAGE FRAME CRACKED AT STR CUTOUT, BS 727 STR 13L. [06-26-07] MAJOR REPAIR: INSTALLED NESTED FRAME DOUBLER REPAIR PER AAR EA-I070344 ON AAR NR12000-2000-0021.SDR AWXA200700690Frame · crackedMCN - FOUND CRACKED FRAME, BS 767, S9L. REPAIRED FRAME, BS 767, S9L IAW AWA ER 03-5311-07143-ES1.SDR DU4R2007128Frame · dentedFOUND DENT IN UPPER CAP OF AFT PIT MAIN FRAME BS 1400 BETWEEN S-27 AND S-26 LT. REPAIRED BY FABRICATING AND INSTALLING FRAME REPAIR 9 BY 14 FROM 7075-T6 .071 IAW DELTA ERA 380490-14MA REV ORIG, DELTA PROCESS STANDARD 900-5-1 NR 4, B757 SRM 51-40-02, PG 2, 7, SDR SWAA072762Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072758Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR KCSA071174Frame · crackedSTA 434 FRAME CRACKED LBL 49 WL 121 APROX .75 INCH.SDR TRAX200700758Frame · corrodedFRAME CORRODED AT FS 605 BETWEEN STR 26L AND 27.SDR TRAX200700757Frame · corrodedCORROSION ON FRAME AT FS 349 BETWEEN STR 26L TO 26R.SDR TRAX200700756Frame · corrodedCORROSION ON FRAME AT FS 319 BETWEEN STR 26L TO 25R.SDR TRAX200700755Frame · corrodedCORROSION ON FRAME AT FS 319 BETWEEN STR 25L TO 25R.SDR TRAX200700754Frame · corrodedCORROSION ON FRAME AT FS 310 BETWEEN STR 26L TO 26R.SDR TRAX200700752Frame · corrodedFRAME CORRODED AT FS 364.00 BETWEEN STR 26L TO 26R.SDR SWAA072750Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA072742Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072749Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072751Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA072752Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 12L. REPAIRED FRAME PER SWA EA.SDR SWAA072753Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 294, STR 11L. REPAIRED FRAME PER SWA EA.SDR 07FDEA02023Frame · corrodedAFT PIT, AFT BULKHEAD SUPPORT FRAME IS CORRODED AT FASTENER RECEPTACLE BS 1166, LBL 19-RBL 36, WL 179 REMOVED CORROSION, FOUND 3 AREAS TO BE OUT OF LIMITS, IAW SRM 53-10-1. REMOVED DAMAGED AREA, FABRICATED REPAIR PART OUT OF 7075-T6 .063. FABRICATED FILLERS SDR KCSA071171Frame · crackedAFT BILGE FUSELAGE FRAME UPPER CHORD IS CRACKED AT STA 1820 AT RBL 48 1 INCH.SDR 2007FA0000570Frame · damagedFUSELAGE FRAME WEB DAMAGED BY DRILL BIT FROM THE BEND RADIUS OF THE OUTER (SKIN) FLANGE. REPLACEMENT REQUIRED SRM, CHAPTER 53-12-27. PROBABLE CAUSE: INCORRECTLY DRILLED AT AIRCRAFT MFG. (K)SDR ASAA0781746Frame · corrodedAFT CARGO FRAME AT STA 1307.091 CORRODED. LOCATED AND DRILLED A REPLACEMENT FRAME SECTION AND REPAIR PARTS AND INSTALLED IAW SRM 53-03 FIG 2A AND SRM 51-30-2.SDR SWAA072714Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072721Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072719Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072713Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072718Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311