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 VGQY2010080400053Frame · corrodedCBN/ U/D/ STA 540 RT FRAME FOUND WITH SURFACE CORROSION. SURFACE CORROSION REMOVED AND REPROTECTED PER SRM 51-10-01 AND SRM 51-10-02 REV 117. ORIG THICKNESS: 0.180 INCH; REMOVED: 0.177 INCH; FOUND WITHIN LIMITS AS PER B747-200 SRM 53-10-01 FIGURE 1, REV 117.SDR C2XA10SH254Frame · corrodedSHV - DURING C-CHECK FRAME 68 WAS FOUND TO BE CORRODED BETWEEN STRINGERS 17-18L. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5320-01494. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IPXA10562137Frame · dentedINSPECTION TYPE:C2 DENT IN FRAME AT BS 660, STR 24L. REPAIRED IAW ATS ER 10-3847.SDR IPXA10562105Frame · dentedINSPECTION TYPE:C2, DENT IN FRAME AT BS 720 BETWEEN STR 24L AND 25L REPAIRED IAW SRM 53-00-07-2R5, FIG 201, DETAIL III.SDR AALA20100803TUL23Frame · crackedAFT ACC RIGHT SIDE CRACK IN FRAME 1497 AT INSTRUMENT SENSE LINE BRACKET 12 INCHES BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-012097 AND SRM 51-70-05.SDR C2XA10TY112Frame · corrodedBOTTOM AFT CORNER OF SERVICE DOOR FRAME HAS CORROSION. REPAIRED FRAME 22 IAW EC5310-01373.SDR SWAA104557Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED FRAME PER SRM.SDR VGQY2010080300048Frame · crackedHFEC INSP FOUND CRACK INDICATION ON BS 1000 RADIUS OF BULKHEAD CHORD BETWEEN STR 38R AND STR 39R BELOW BATHTUB FITTING. COMPLIED WITH EN 1190-10,SDR IPXA10562342Frame · gougedINSPECTION TYPE:C3, UPPER LOBE FRAME IB FLANGE HAS GOUGE DAMAGE WITHIN A DENTED AREA, BS 345 BETWEEN STR 9R-STR 10R, (MARKED). REPAIRED IAW ATS ER 10-3862, DATED 9-1-10.SDR IPXA10562337Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT: BS 660 FRAME INNER FLANGE IS DENTED, STA 666, STR 24R. REPAIRED IAW ATS ER 10-3928, DATED 9-1-10.SDR IPXA10562116Frame · dentedINSPECTION TYPE:C3, UPPER LOBE FRAME HAS GOUGE DAMAGE WITHIN A DENTED AREA, BS345, BETWEEN STR 9-10L. MARKED REPAIRED IAW ATS ER 10-3854.SDR QXEA2010080600461Frame · crackedAFT FUSELAGE ON FRAME 6 AT STR 3L, 10 INCHES LT OF CTR FRAME WAS CRACKED. REMOVED FRAME AND INSTALLED NEW FRAME AND RIVETS IAW SRM 51-42-05.SDR SIMA201021701Frame · crackedDURING THE MAINTENANCE BASE VISIT FOUND FRAME 23 BETWEEN STRINGER 15 RIGHT AND 16 RIGHT TO BE CRACKED AROUND RIVET WHERE AFT SERVICE DOOR SILL IS ATTACHED. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLIED WITH INSTALLATION OF FRAME SECTION IAW SRM 51-40-02 ANSDR SWAA104559Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 14R. REPAIRED FRAME PER AAR EA.SDR SWAA104529Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 27R TO STR 28R. REMOVED AND REPLACED FRAME PER BAC DWG.SDR SWAA104512Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 380, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA104508Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA104486Frame · corrodedDURING SCHEDULE 16Y CHECK, FOUND FRAME CORRODED AT BS 993, RBL 47. REPAIRED FRAME PER ER.SDR SWAA104482Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 671, RBL 43.5. REPAIRED FRAME PER ACO.SDR IPXA10562350Frame · dentedINSPECTION TYPE:C3, DAMAGED ISOLATOR WITH POSSIBLE DENT TO FRAME IN MCB BS 540, BETWEEN S-5R AND S-6R. REPAIRED IAW ATS ER10-3945.SDR IPXA10562291Frame · damagedINSPECTION TYPE:C3, MCB FRAME INBD FLANGE HAS A MECHANICAL DAMAGE AT BS 900 BETWEEN S-15R AND S-16R. REPAIR IAW ATS ER 10-4009.SDR 2010FA0000909Frame · corroded(SPUY) LT MLG WW - FRAME FITTING CORRODED AT STA FS 879.000 L-24.SDR USAA2010080391581Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20100730TUL02Frame · damagedDAMAGED FRAME FORWARD SIDE OF STATION 1418 AT STRINGER 2 RIGHT. INSTALLED DOUBLER PER SMR 53-03-00.SDR SWAA104440Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104408Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA104407Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA104406Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 616, STR 17R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA104405Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104404Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104403Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104401Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME PER EO.SDR SWAA104400Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 951, STR 17L. REPAIRED FRAME PER EO.SDR SWAA104399Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA104396Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA104374Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 17R TO STR 27R. REMOVED AND REPLACED FRAME PER BAC DWG.SDR AALA20100729TUL01Frame · crackedCRACK STATION 1510 FRAME LOWER RIGHT SIDE AT ALIGNMENT PIN. INSTALLED DOUBLER PER SRM 53-01.SDR K11A2010072972201Frame · dentedFRAME DAMAGE (2 INCH DENT).SDR IPXA10562155Frame · damagedINSPECTION TYPE:C2, BS 395, SCREW STRIKE ON INBD FACE OF FRAME COMMON TO STR-62. REPAIRED IAW ATS ER 10-3830, DATED 8-24-10.SDR ASAA1048166Frame · corrodedFRAME STA 847 STR CORRODED. REMOVED CORRODED FRAME AND INSTALLED NEW FRAME.SDR FDEA201007292725Frame · dentedSTA 1500 FRAME BETWEEN STR 26L AND 27L DENTED, GOUGED AND CORRODED. REMOVED CORROSION PER SRM 51-10-02; L=3", W=1", D=.004", WITHIN LIMITS PER SRM 53-00- 53, FIG.101. GOUGE AREA; L=1.2",W=.01", D=.003", WITHIN LIMITS PER SRM 53-00-53, FIG.101; DENT OUT OF SDR USAA2010080591603Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 706 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 706 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-22A.SDR FDEA201007292714Frame · corrodedCORROSION ON UPPER FLANGE OF FRAME AT BS 1148 BETWEEN STRINGER 27L AND 26L. REMOVED CORROSION. ORIGINAL MATERIAL THICKNESS .063, MATERIAL LOSS .003. FOUND WITHIN LIMITS IAW SRM 53-10-1 AND 53-10-2.SDR USAA2010080291563Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FRAME LOCATED BS 360 AND BETWEEN S14R TO S15R FWD PAX CABIN. REPAIRED FUSELAGE FRAME AT BS 360 BETWEEN S14R TO S15R IAW B737 SRM 53-00-07 REPAIR 3.SDR SWAA104332Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR AALA20100728AFW02Frame · damagedFUSELAGE FRAME LOWER LOBE WEB AT STATION 566 AND RIGHT BUTTLINE 14 DAMAGED. ACCOMPLISHED REPAIR PER EA B767-53-011825.SDR AALA20100728AFW01Frame · dentedFUSELAGE FRAME STATION 500 INNER CHORD BETWEEN STRINGERS 30 AND 31 LEFT DAMAGED. ACCOMPLISHED REPAIR PER EA B767-53-011677.SDR IPXA10562174Frame · dentedINSPECTION TYPE:C2, AFT CARGO COMPARTMENT FRAME DENTED STA 1260 BETWEEN STR 23L TO 24L. REPAIRED IAW ATS ER 10-3737.SDR IPXA10562081Frame · dentedINSPECTION TYPE:C2, AFT CARGO COMPARTMENT FRAME DENTED STA 1220 BETWEEN STR 25R AND 26R. REPAIRED IAW ATS ER 10-3739.SDR IPXA10562070Frame · gougedINSPECTION TYPE:C2, MCB FRAME STA 612.9 IS GOUGED IN (2) PLACES APPROX 6" - 8" ABOVE THE BOTTOM OF FRAME. REPAIRED GOUGED AREA IAW SRM 52-31-02-1A, DWG 65-25330, SRM 51-40-02, SRM 52-32-05-04.
Back to JASC 5311