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 AWXA200700706Frame · crackedMCN - MAJOR REPAIR - CRACKED FRAME, BS 380, S16L, WL 217. REPAIRED FRAME, BS 380, S16L, WL 217 IAW B737-300 SRM 53-00-07-2R7, FIGURE 201.SDR AWXA200700637Frame · crackedMCN - MAJOR REPAIR - CRACKED FUSELAGE FRAME FOOT, BS 360, S14R, WL 228. REPLACED FUSELAGE FRAME FOOT, BS 360, S14R, WL 228 IAW B737-300 SRM 53-00-07-2R7, FIGURE 201.SDR 2007UALA01263Angle · crackedRIGHT HAND WHEEL WELL BS 695 FRAME INNER CHORD ANGLE CRACKED, LOWER INNER RADIUS. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED CRACKED CHORD ANGLE.SDR ZZDA070423155Angle · crackedAFT ACCESSORY COMPARTMENT FS 1178 CANTED FRAME ANGLE CRACKED NEAR LONGERON 15R. INSTALLED ANGLE FOR REPAIR 1 ZIDE OF ANGLE 11 1/2 X 2 1/2 IAW B717 SRM 51-70-11.SDR ZZDA070426149Angle · crackedAFT ACCESSORY COMPARTMENT FS 1178 CANTED FRAME ANGLE CRACKED NEAR LONGERON 15R. INSTALLED ANGLE FOR REPAIR 1 SIDE OF ANGLE 11 1/2 X 2 1/2 IAW B717 SRM 51-70-11.SDR SWAA071982Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071989Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071990Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071991Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071986Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071985Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071984Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071994Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071993Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071987Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071983Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071988Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071995Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071992Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071996Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071998Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR USAA070313Frame · crackedSTUB FRAME WEB AT 294.5 S12L HAS CRACK. INSTALLED NEW FAB'D PART PER SRM 51-10-02, 51-40-02, DEFECT SIZE: .5 INCH.SDR USAA070311Frame · crackedBS 492, S21R HAS CRACK. FAB'D & INSTALLED REPAIR PARTS PER SRM 53-00-53, 51-40-02, BOEING DWG 65-20723, DEFECT SIZE: 0.03 INCH.SDR USAA070310Frame · crackedBS 492 S-24R HAS CRACK. FAB'D & INSTALLED REPAIR PARTS PER SRM 53-00-53, 51-40-02 BOEING DWG 65-20723, DEFECT SIZE: .250 INCH.SDR USAA070315Frame · crackedSTA 294.5, S16L HAS CRACK. FAB'D NEW WEB PER BOEING DWG 65-17684; SRM 51-30-01, DEFECT SIZE: 2 INCHES.SDR AWXA200700756Frame · corrodedMCN - MAJOR REPAIR - CORROSION ON FRAME FOOT, BS 767, S26R - S27R, WL 147. REPAIRED FRAME FOOT, BS 767, S26R - S27R, WL 147 IAW AWA ER 03-5311-07170-SS2.SDR AWXA200700614Frame · crackedMCN - CRACKED R1 DOOR CUT OUT FWD STUB FRAME, BS 291, S16R. REPLACED R1 DOOR CUT OUT FWD STUB FRAME, BS 291, S16R IAW B737-300 SRM 51-40-02.SDR DU4R2007107Frame · corrodedFOUND CORROSION IN AFT CARGO PIT LWR FRAME FWD FACE AT BS 1661 FROM S-26L TO S-28R. REPAIRED BY FABRICATING AND INSTALLING 3 SHEAR TIES 1.5 BY 4", 4" BY 4", 7.5" BY 3" FROM 7075-T6 .050 AND ONE 4.5" BY 5" FROM 7075-T6 .071 AND REPAIR DOUBLER 20 BY 6 FROM 707SDR DU4R2007106Frame · corrodedFOUND CORROSION IN AFT CARGO PIT ON WASTE DRAIN LINE BOX FRAME AFT I/B CORNER BS 1645 S-27L. REPAIRED BY FABRICATING AND INSTALLING NEW INTERCOSTAL 21 BY 4.5 FROM, STRINGER REPAIR 39 BY 3 FROM BAC1498-204 7075-T62, STRINGER SPLICE 10 BY 3 FROM BAC1498-204 707SDR IXXA07SMN150SFrame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND MAIN CARGO COMPARTMENT FRAME FLANGE WITH A CRACK AT STATION 1580.000 LONGERON 21LEFT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED CRACKED FRAME SEGMENT. FABRICATED NEW FRAME SEGMENT. PERFORMED HEAT TREATMSDR IXXA07SMN158SFrame · crackedDURING ROUTINE C CHECK INSPECTION, FOUND AFT CARGO COMPARTMENT FRAME WITH A CRACK AT STATION 1260.000 LONGERON 34 RIGHT TO LONGERON 35 LEFT. REMOVED CRACKED FITTING. FABRICATED FRAME FITTING, SPLICES, AND DOUBLER. PERFORMED HEAT TREATMENT. PERFORMED NDT INSDR PIDA07021Frame · damagedDURING INSPECTION, NOTED FIGURE 8 HOLE IN BS 927 FRAME AT STR 6LT. REPAIRED FRAME PER SRM 51-40-02, 51-40-05 AND 51-30-00 AND REPLACED STRINGER CLIP PER SRM 51-40-02 AND 51-40-03.SDR SWAA071965Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB PER SRM.SDR CALA0700193Frame · crackedFUSELAGE FRAME AND WEB CRACKED AT STA 639 AT STRINGER 17L. REPAIRED IAW ECRA 5311-01311.SDR CALA0700192Frame · crackedLEFT FRAME CRACKED AT STA 639 ON O/B CHORD. REPAIRED IAW ECRA 5311-01312.SDR CALA0700191Frame · crackedLEFT FRAME CRACKED AT STA 639 ON OUTBOARD CHORD. REPAIRED IAW ECRA 5311-01312.SDR SWAA071964Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 296, RBL 54, WL 209. REPAIRED FRAME PER SRM.SDR CALA0700187Frame · corrodedCORROSION INSIDE LWR NOSE COMPARTMENT AFT SIDE OF CUTOUT, STA 227. REPAIRED IAW ECRA 5311-01308.SDR ASAA0741595Frame · crackedFRAME CRACKED AT 37L INTERCOSTAL ATTACHMENT HOLE. FRAME REPAIRED IAW EA 5310 02714.SDR ASAA0741582Frame · crackedFRAME CRACKED. REPAIRED CRACKED FRAME IAW SRM 53-00-07 FIG 201.SDR AWXA200700743Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - FOUND CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME, BS 480, S9L AND S9R IAW AWA ER 03-5362-07165-ES1.SDR AWXA200700742Frame · crackedMCN - FOUND CRACKED FRAME, BS 440, S9L AND S9R. REPAIRED FRAME, BS 440, S9L AND S9R IAW AWA ER 03-5362-07165-ES1.SDR AWXA200700740Frame · crackedMCN - FOUND CRACKED FRAME, BS 400, S9L. REPAIRED FRAME, BS 400, S9L IAW AWA ER 03-5362-07165-ES1.SDR SWAA071947Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA071941Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071942Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA071950Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9L. REPAIRED FRAME PER EA.SDR SWAA071940Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071954Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 2L. REPAIRED FRAME PER ER.SDR SWAA071953Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1. REPAIRED FRAME PER ER.
Back to JASC 5311