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 SWAA100595Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR DALA102509876Frame · crackedDURING "H" CHECK FOUND CRACK IN FRAME AT BS 465 L26R. REPAIRED IAW SRM 53-03,51-10-4,51-10-3,51-30-5,51-10-2.SDR SWAA100566Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100565Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100560Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA100559Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 360, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA100547Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100546Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100545Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100544Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100543Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR C2XA10SH039Frame · crackedSHV - DURING C-CHECK LEFT FR 10 CRACKED BETWEEN STR 11L AND 14L. REMOVED AND REPLACED FR 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UIEA201000005Frame · brokenFOUND FUSELAGE STRUCTURE FRAME BROKEN AT STA 1800 S-10R. REPAIRED THE FRAME BROKEN AREA IAW EI NR T2010A53B-166. FOLLOWED UP INSPECTION PRIOR TO 25,000 TOTAL FLIGHT CYCLES PER EO NR 4453A327.SDR FDEA201001300292Frame · chafedMAIN DECK CARGO, LT STA 535 FRAME ADJACENT TO 9-G NET LOWER SUPPORT YOKE FITTING FOUND CHAFED. REPAIR CARRIED OUT AS EA NR 1-5310-132334, THIS REPAIR IS CLASSIFIED AS MAJOR, IAW GMM 6-2-100 REVISION 109.SDR AALA20100129TUL01Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 RIGHT. REPAIRED PER AARD 53-10-00-15.SDR FOTR20006NR5059Frame · crackedMAIN CARGO AREA, BS 480, BETWEEN STR 16L-17L, CRACKED FRAME. REPAIRED ON FASI WO 20006, N/R 05059. REPAIRED FRAME AT STA 480 BETWEEN STR 16L AND 17L IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 3, REV 102. MATERIAL USED: 7075-T6, 0.050, DIM: 9.0 BY 3. CUT OUSDR CA100208002Frame · cracked(CAN) RT LOWER FUSELAGE FRAME AT STATION 207 FOUND CRACKED. FRAME REPLACED. (TC 20100208002)SDR AALA20100128TUL15Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 LEFT. STOP DRILLED CRACK AND INSTALLED DOUBLER REPAIR PER AARD 53-10-00-15.SDR UIEA201000064Frame · crackedDURING C-CHECK, MAINTENANCE FOUND CRACKS IN THE 65B07415-5 FRAME WEB AT BS 720 BETWEEN S-42L AND S-44L. EFFECTED AREA WAS REMOVED AND REPAIRED AS PER EO 4753B243.SDR CALA2010020200021Frame · corrodedCORROSION ON BOTTOM SIDE OF INNER (UPPER) CHORD, AFT CARGO DOOR OPENING, FWD FRAME, LOWER CORNER, AT STA 1380, JUST O/B OF CARGO TIE DOWN PLATE. REF DWG 146N8511 FRAME 3 OF 7, BL 26, WL 148. REPAIRED CARGO FRAME ASSY STA 1380 INNER CORD S26R-S27R REF ECR A 5SDR UALA2010012800351Frame · damagedUPPER DECK RT BS 1180, FRAME CRACKED AT 1 FASTENER HOLE AT TENSION TIE ATTACH POINT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, INSTALLED REPAIR.SDR UALA2010012800350Frame · crackedUPPER DECK RT BS 1140, FRAME CRACKED AT 3 FASTENER HOLES AT TENSION TIE ATTACH POINT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, INSTALLED REPAIR.SDR UALA2010012800349Frame · crackedUPPER DECK LT BS 1180, FRAME CRACKED AT 2 FASTENER HOLES AT TENSION TIE ATTACH POINT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, INSTALLED REPAIR.SDR UALA2010012800348Frame · crackedUPPER DECK RT BS 1160, FRAME CRACKED AT 1 FASTENER HOLE AT TENSION TIE ATTACH POINT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, INSTALLED REPAIR.SDR UALA2010012800347Frame · crackedUPPER DECK LT BS 1160, FRAME CRACKED AT 1 FASTENER HOLE AT TENSION TIE ATTACH POINT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE, INSTALLED REPAIR.SDR SWAA100535Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA100512Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR FDEA201001280280Frame · corrodedAFT CARGO COMPT BILGE FOUND CORROSION ON CAP FRAME AND FRAME LONGERON. TRMIMED AND REPLACED FRAME SECTION, SPLICE IAW SRM 53-30-00 FIG.5 VOL.1 & 53-00-01 FIG.10 VOL.1 & DWG AGA7125.SDR AALA20100127TUL04Frame · corrodedCORROSION FOUND OUT OF LIMITS AT J FRAME AT STATION 1271 BETWEEN LONGERON 29 LEFT AND 29 RIGHT. INSTALLED FRAME SPLICE REPAIR PER AARD 53-10-00-17.SDR ASAA1047306Frame · crackedFRAME IS CRACKED AROUND FASTENER HOLE AT BS 380 JUST 2 INCHES ABOVE STRINGER HOLE. REPAIRED FRAME AT BS 380.SDR SWAA100467Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100461Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100460Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100459Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER EA.SDR USAA2010012990229Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B, S20L. REPAIRED FUSELAGE FRAME AT BS 500B, S20L IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA101659876Frame · crackedDURING "H" CHECK FOUND FRAME CRACKED AT BS 332 L26L-L27L. REPAIRED IAW SRM 53-03-02.SDR SWAA100440Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER AAR EA.SDR FDEA201001250256Frame · damagedCABIN, FUSELAGE FRAME EXISTING REPAIR DOUBLER AT STA 1701 LONGERON 12 LT FOUND DEFORMED. REPAIR IAW SRM 53-00-07 FIG 201 REPAIR 2 REV 42 (MAJOR REPAIR).SDR DALA101413234Frame · corrodedDURING H-CHECK FOUND CORROSION ON FRAME 29 SHEAR TIE BETWEEN S24R AND S43R. REPAIRED PER SRM 51-42-11 AND SRM 51-75-12.SDR FDEA201001250245Frame · damagedDEEP GOUGES IN FRAME 1280 BETWEEN S-10R AND S-14R MAIN CARGO DECK. REMOVED GOUGES IAW SRM 51-10-02. OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DET II. REPAIRED FRAME AT BS 1280, S10-14R, IAW SRM 53-00-07, FIG 201, R1. THIS IS A CLASS "B" REPAIR WITH SUPPLEMESDR FDEA201001250240Frame · crackedRT MLG WHEEL WELL, FOUND CRACK ON FRAME. TRIMMED OUT DAMAGED SECTION OF FRAME IAW SRM 53-30-00 FIG.5 VOL.1. INSTALLED NEW SECTION OF FRAME & SPLICE IAW SRM 53-00-01 FIG.10 SH.5 VOL.1SDR SWAA100408Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER EA.SDR SWAA100491Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 887, STR 13R. REPAIRED FRAME PER EA.SDR ASOA201000097Frame · corrodedCORROSION FOUND ON FRAME FS 349 LBL 6 APROX. REMOVED CORROSION ON BACK SIDE OF FRAME IAW SRM 51-21-06.SDR 2010FA0000067Skin · bulgedFUSELAGE SKIN, EXTERNAL, HAS A BULGE AND PULLING FASTENERS AT STA 1148, BETWEEN STRINGER 24R AND 27R.SDR USAA2010030290479Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500B, S20R. REPAIRED FUSELAGE FRAME AT BS 500B, S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA101349866Frame · crackedDURING "L" CHECK FOUND CRACK IN FRAME AT BS 1303 BETWEEN L14R AND L15R. REPAIRED IAW SRM 51-30-2 AND 53-01.SDR IPXA10558472Frame · dentedINSPECTION TYPE:C1 FRAME DENTED AT STR 23 AND 24 LT, BS 820. REMOVED, FABRICATED AND INSTALLED REPAIR PER SRM 53-00-07-2R-5.SDR IPXA10558471Frame · dentedINSPECTION TYPE:C1 FRAME DENTED AT STR 23 AND 24 LT, BS 820. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR PER SRM 53-00-07-2R-5SDR IPXA10558466Frame · dentedINSPECTION TYPE:C1, FCB STR 24R FRAME HAS DENT STA 760. REPLACED FRAME SECTION IAW SRM 53-00-07-2R, AMM 25-50-04-4, SRM 51-40-02.
Back to JASC 5311