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 USAA2010091692000Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA1022399868Frame · corrodedDURING M-CHECK, FOUND CORROSION ON FRAME AT BS 1079, FROM S29L TO S29R. REPAIRED IAW SRM 53-03, FIG 2A, SRM 51-10-3 & EA 09A51-37583, PAGE 133.SDR KCSA101119Frame · crackedSTA 200 FRAME HAS 1 INCH CRACK AT STR 14B RT CUTOUT.SDR DALA1026906901Frame · corrodedAFT CARGO FRAME CORRODED STA 1520 STR 26L-26R. REPAIRED CARGO FRAME DURING HMV AT ST AEROSPACE SAT ON NON ROUTINE CARD 171039 (DL75E102748).SDR ABXA201010010129Fitting · corrodedRT FAIL-SAFE T-FITTING CENTER AND LOWER HOLES COMMON TO FAIL-SAFE CORRODED. REMOVED AND REPLACED T-FITTING IAW B767 SRM 51-40-02.SDR IPXA10562645Frame · damagedINSPECTION TYPE:C3, FRAME SCREW STRIKE BS 365, STR 14 LT. R & R FRAME SPLICE IAW SRM 51-40-02-0G.SDR ASOA201001302Frame · corrodedFRAME SECTION AT FS 333.00 FROM STRINGER 25L TO 25R IS CORRODED. REMOVED FASTENERS FROM FRAME SECTION AT FS 333, FROM STR 23L TO 23R IAW SRM 51-42-06 AND 51-42-21. FOUND CORROSION TO BE OUT OF LIMITS IAW SRM 53-21-15 AND 53-00-00. REMOVED FRAME SECTION FROSDR ASOA201001301Frame · corrodedFRAME SECTION AT FS 349.00 IS CORRODED AT STRINGER 27. REMOVED CORROSION FROM FRAME FS 349.00 STRINGER 27 IAW SRM 51-21-06. AREA OF CORROSION REMOVED WITHIN LIMITS IAW SRM 53-00-00, FIG 102 (SHEET 2). MATERIAL REMOVED .002, REMAINING MATERIAL .061. PAINTSDR USAA2010090791942Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010090791937Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 616, 8 INCHES BELOW S17R. REPAIRED FUSELAGE FRAME AT BS 616, 8 INCHES BELOW S17R IAW TYPICAL REPAIR 53-62-01.SDR SWAA105425Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA105408Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA105407Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 13L. REMOVED AND REPLACED FRAME PER EA.SDR AALA20100909TUL04Frame · crackedCRACK IN FRAME FORWARD SIDE OF STATION 1418 LONGERON 2 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-03-00.SDR AALA20100909TUL03Frame · crackedCRACK ON FRAME FORWARD SIDE OF STATION 1418 LONGERON 2 LEFT. INSTALLED REPAIR DOUBLER PER SRM 53-03-00.SDR C77A273893Frame · corrodedDURING BASIC 1 CHECK INSP, CORROSION WAS FOUND ON CROSS FRAME 14 PN 170-03151-001. REPAIR WAS ACCOMPLISHED IAW ETD2010-170-08006 AND COMPASS EO E175-53MR-043 IR.SDR USAA2010091692006Frame · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 807 BETWEEN S6L TO S6R. REPAIRED FUSELAGE FRAME AT BS 807 BETWEEN S6L TO S6R IAW B737 SRM 53-00-07.SDR COEA2010090815803Frame · corrodedWO#: 97861 NR#: COE / HEAVY CHECK / LEVEL 2 CORROSION / FRAME 24 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 19L AND 20L. WILL REPAIR IN ACCORDANCE WITH ATR 72 STRUCTURAL REPAIR MANUAL.SDR COEA2010090814803Frame · corrodedWO#: 97861 NR#: 100043 COE / HEAVY CHECK / LEVEL 2 CORROSION / FWD SIDE OF FRAME 29 IS CORRODED BETWEEN STRINGERS 19R AND 20R. WILL REQUIRE REPAIR SPLICE PER ATR SRMSDR USAA2010090791941Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 400 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 400 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR SWAA105365Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 2L. REPAIRED FRAME PER SRM.SDR SWAA105363Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA105361Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 26R. REPAIRED FRAME PER SRM AND BAC DWG.SDR C2XA10SH278Frame · crackedSHV - DURING C-CHECK FRAME 10 STR 10R-9R CRACKED. MAINTENANCE REMOVED AND REPLACED FRM 10 BETWEEN STR 9R-13R IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR GTIA1000069Frame · corrodedSTA Y254 AT FRAME 67 HAS CORROSION.SDR UALA2010090703270Frame · damagedFWD PIT LWR FRAME STA 900 RBL 43 AFT SIDE OF UPPER CHORD HAS BEEN PARTLY DRILLED THROUGH FRAME VERT. JUST FWD OF FWD DRIVE WHEEL BAY 5 RT. BEGAN REMOVING FASTENERS AND STIFFENER ANGLES IN REPAIR AREA FOR ACCESS TO TEE SPLICE AND WEB REPAIR. FINISHED REMOVING SDR SWAA105310Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA105294Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 13L. REPAIRED FRAME PER EA.SDR SWAA105291Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.SDR SWAA105290Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.SDR SWAA105288Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 957, STR 7L. REPAIRED FRAME PER AEM.SDR SWAA105286Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA105285Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA105276Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727C, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA105275Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER
EA.SDR SWAA105267Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA105266Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA105265Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105264Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105263Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105262Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105261Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR KCSA101115Strap · crackedCRACKED FRAME STRAP AT STA -800 BELOW STR-16L APPROX .250 INCH.SDR 2010FA0001011Spar · corroded(CNQR) DURING MX VISIT WITH SERVICE CTR, CORROSION WAS FOUND ON BOTH RT AND LT WHEEL WELL AREAS INCLUDING THE AFT SPAR AND SPAR CAPS. ACFT WAS RELOCATED 8/30/10 FOR MFG ENGINEERING EVALUATION AND REPAIRS ON A SPECIAL FLIGHT PERMIT. MFG STRUCTURES ENGINEERINGSDR FDEA201009063298Frame · crackedUPPER AFT FUSELAGE FRAME CLIP AT CANT STATION Y = 2069.44, CRACKED APPROX 1 INCH IN LENGTH. R & R IAW SRM 51-31-01, REV 44. THIS REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-100, REV 110.SDR SWAA105260Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA105256Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR DALA1021439868Frame · gougedDURING M-CHECK FOUND GOUGE IN FRAME, RT SIDE AT BS 1247 BETWEEN S12R & S14R. REPAIRED IAW SRM 53-10-05-801, FIGURE 1.SDR SWAA105209Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR IPXA10562934Frame · dentedINSPECTION TYPE:C3, DENT IN FREE FLANGE OF FRAME BS 800 BETWEEN STR 24-25L. REPAIR IAW ER 10-04839, DATED 10-1-10.
Back to JASC 5311