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 2005UALA01161Frame · corrodedAFT CARGO COMPARTMENT, LOWER LOBE DRAIN HOLE IN FRAME AT BS 1562, BL 0, IS CORRODED.SDR 05FDEA03444Frame · damagedCENTER CARGO COMPT STA 1841 RT LOWER FRAME ASSY CORNER FOUND CRACK DURING REMOVAL. REPAIRED PER SRM 53-00-00 FIG.3 VOL.I. NEW ANGLE P/N FX AGA 7171-20 FABRICATED PER DRAWING AGA 7171. MAJOR REPAIR PER GMM 6-2-100.SDR SWAA053251Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053245Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 967, BETWEEN STR 6L TO STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA053242Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SRM.SDR GTIA050264Frame · crackedFRAME CANT 1463 AT APPROX LONGERON 19 AND 20 ON AC RT HAS CRACKED WEBBING. INSTALLED PERMANENT REPAIR ON CANTED FRAME FS 1463 BETWEEN R18L AND R25L, IAW EA REV ORIGINAL HAS BEEN ACCOMPLISHED. (K)SDR LR7A05161Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS4010-8) MISDRILLED LINER HOLE RIGHT HAND SIDE, FS 377 WL151. REPAIRED IAW DRAWING R05-025-07 PER LAC MEA382-53-05-071, NR 0414.SDR LR7A05160Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS4010-8) MISDRILLED LINER HOLE LEFT HAND SIDE, FS 742, WL151. REPAIRED IAW DRAWING R05-025-07 PER LAC MEA382-53-05-071, NR 0414.SDR LR7A05159Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS4010-8) MISDRILLED LINER HOLE LEFT HAND SIDE, FS732, WL151. REPAIRED IAW DRAWING R05-025-07 PER LAC MEA382-53-05-071, NR 0414.SDR LR7A05158Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS4010-8) MISDRILLED LINER HOLE LEFT HAND SIDE, FS457, WL162. REPAIRED IAW DRAWING R05-025-07 PER LAC MEA382-53-05-071, NR 0414.SDR LR7A05157Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS4010-8) MISDRILLED LINER HOLE LEFT SIDE, FS 457, WL158. REPAIRED IAW DRAWING R05-025-07 PER LAC MEA382-53-05-071, NR 0414.SDR LR7A05156Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE RIGHT HAND SIDE, FS 626, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05155Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE, FS757, WL151. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05154Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE, FS727, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05153Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE, FS707, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05152Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE, FS697, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05151Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE, FS 667, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05150Frame · misdrilledDURING C-6 CHECK PER HC5313 FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT HAND SIDE. FS657, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070. NR 0413.SDR LR7A05149Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT SIDE, FS 647, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR LR7A05148Frame · misdrilledDURING C-6 CHECK PER HC5313, FOUND FUSELAGE FRAME (LS5408-2) MISDRILLED LINER HOLE LEFT SIDE, FS626, WL158. REPAIRED IAW DRAWING R05-025-08 PER LAC MEA382-53-05-070, NR 0413.SDR SWAA053227Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L & BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053226Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053225Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA053224Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053223Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053222Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053221Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053220Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053219Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA053217Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 578, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SRM.SDR C1HA200594007Frame · dentedAFT CARGO COMPT FRAME AT STA 950F IS DENTED BETWEEN STR 25L - 026L. FOUND DENT OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. CUT OUT DAMAGE AREA IAW B727 SRM 51-10-1. FABRICATED ANGLE REPAIR IAW B727 SRM 53-10-2 FIG 3 AND 51-20-1. TREATED AND PRIMED PORT AND ASDR 0501946624Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME AT BS 2231 S26L. REPAIRED PER EA 66-205517.SDR ABXA050312Frame · tool damageFORWARD CARGO BAY DRILL START IN FRAME RADIUS, STA 120, ABOVE LONGERON 31 RIGHT, RIGHT BUTT LINE 33. ORIGINAL MATERIAL 7075-T6 0.090" PER DC8 SRM 53-4-1, PG 125. FABRICATED REPAIR ANGLE FROM 7075-0 FIG 2, HEAT TREATED IAW DC8 SRM 51-1-4, SHIM FROM 7075-T6 0.SDR 05FDEA03435Frame · corrodedFWD CARGO COMPT AT STA 6-30 RT LOWER FRAME ASSY BETWEEN LONGERON 42 TO LONGERON 43 FOUND CORRODED DURING REMOVAL. FRAME REMOVED AS PER SRM 51-35-01 VOL.II. NEW FRAME FABRICATED AS PER DWG ACA 7049 AND NEW FRAME INSTALLED AS PER SRM 51-35-01 VOL.II. MINOR SDR SWAA053192Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 455, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053191Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 24R. REPAIRED FRAME PER BFG ER.SDR SWAA053204Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 492.4, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER BFG ER.SDR SWAA053203Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, RBL 39. REPAIRED FRAME PER BFG ER.SDR SWAA053208Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT BS 616, BETWEEN LBL 65 TO RBL 65, WL 202. REPAIRED FRAME INNER CHORD PER BFG ER.SDR SWAA053182Frame · crackedDURING SCHEDULED D-HECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 7R. REPAIRED FRAME PER SRM.SDR DL76S050661Frame · crackedTHE INNER CHORD OF THE LT STA 903.5 FRAME WAS FOUND WITH A 0.60 INCH LONG CRACK. REPAIR ANGLE INSTALLED PER ACTS PP B767-53-21657, REF ER/A 450982-14AD, AD 2003-18-10.SDR USAA051209Frame · crackedSTA 380 BETWEEN S19L TO S22L CRACKED. REPAIRED IAW EA 96971, DEFECT SIZE: .25 INCH.SDR AWXA200501352Frame · crackedDURING C16 CHECK DISCOVERED FRAME 188 CHORD CRACKED, .875 INCHES, AT BS 188, WL 207 AND BL 31R. MAINTENANCE CUT OUT AND REMOVED DAMAGED SECTION OF OUTBOARD CHORD FLANGE IAW BOEING 737-300 SRM 53-00-07-2R11 FIG 201. FABRICATED FILLERS, TAPERED FILLER, AND REPSDR AWXA200501335Frame · crackedMCN - DURING C16 CHECK DISCOVERED CHORD CRACKED, 1.1 INCHES IN LENGTH, IN OUTBOARD RADIUS AT BS 188, WL 207 AND BL 31L. MAINTENANCE CUT OUT DAMAGED AREA ON CHORD FLANGE IAW BOEING 737-300 SRM 53-00-07-2R11 FIG 201. FABRICATED ANGLE, FILLERS, TAPERED FILLER ASDR SWAA053178Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA053177Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER BFG ER.SDR SWAA053176Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 992, RBL 55, WL 209. REPAIRED FRAME PER SRM.SDR ASAA0540541Frame · crackedPAE - FRAME CRACKED AT BIN RAIL SUPPORT BETWEEN STRINGER 8 LEFT AND 9 LEFT AT INBOARD FASTENER. REPAIRED DAMAGED FRAME AT BIN RAIL SUPPORT PER B737-200 SRM 53-00-07. (M)SDR ASAA0540535Frame · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL SUPPORT. REPAIRED FRAME CRACK PER B737-200 SRM 53-00-07. (M)SDR ASAA0540534Frame · crackedPAE - FOUND FRAME CRACKED AT BIN RAIL SUPPORT. REPAIRED FRAME CRACK PER B737-200 SRM 53-00-07. (M)
Back to JASC 5311