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 GLBA20061086Frame · bentFRAME SECTION AT FS 482.75 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 482.75 STRINGER 3L IAW SRM 51-40. P/N 129-440044-73SDR 20061087Frame · bentFRAME SECTION AT FS. 495.75 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 495.75 STRINGER 3L IAW SRM 51-40. PN 129-440044-71.SDR 20061086Frame · bentFRAME SECTION AT FS 482.75 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 482.75 STRINGER 3L IAW SRM 51-40. P/N 129-440044-73.SDR 20061085Frame · bentFRAME SECTION AT FS 469 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 469 STRINGER 3L IAW SRM 51-40. P/N 129-40044-75.SDR KCSA081215Frame · bentFRAME BENT BETWEEN STA-2180 AND STA-2200 LBL-28.SDR KCSA081214Frame · bentFRAME BENT BETWEEN STA-2200 AND STA-2220 LBL-28.SDR KCSA081213Frame · bentFRAME BENT AFT OF BULKHEAD 2160 RBL-32.SDR UPS08B52552Frame · crackedINSPECTION TYPE:BCF RT BS 1120 TENSION TIE FRAME WEB CRACKED ABOUT 0.250 INCH. RT BS 1120 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07 REPAIR 1.SDR UPS08B52551Frame · crackedINSPECTION TYPE:BCF RT BS 1160 TENSION TIE FRAME WEB CRACKED ABOUT 0.250 INCH. RT BS 1160 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07 REPAIR 3.SDR UPS08B52378Frame · crackedINSPECTION TYPE:C RT BS 1120 TENSION TIE FRAME WEB CRACKED ABOUT 0.250 INCH. RT BS 1120 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07, REPAIR 1.SDR UPS08B52377Frame · crackedINSPECTION TYPE:C RT BS 1160 TENSION TIE FRAME WEB CRACKED ABOUT .250 INCH. RT BS1160 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07. REPAIR 3.SDR UPS08B52376Frame · crackedINSPECTION TYPE:C LT BS 1160 TENSION TIE FRAME WEB CRACKED ABOUT 0.400 INCH. LT BS 1160 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07 REPAIR 3.SDR UPS08B52375Frame · crackedINSPECTION TYPE:C LT BS 1120 TENSION TIE FRAME WEB CRACKED ABOUT 0.500 INCH LT BS 1120 TENSION TIE FRAME WEB REPLACED PER SRM 53-40-07 REPAIR 1.SDR USAA920080800Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - A .125" CRACK ON FRAME AT BS 727B, STR 8R AND STR 9R. INSTALLED REPAIR IAW SRM TR 53-10-20.SDR NWAA081446310Frame · mismanufacturedDURING "M" CHECK, THE BS 320 CROWN FRAME WEB WAS FOUND TO BE 0.080 INCH THICK INSTEAD OF BLUEPRINT THICKNESS OF 0.140. REPAIRED PER EA 63-212555 SECTION I SECTION II REQUIRES DAMAGE TOLERANCE ANALYSIS TO BE ACCOMPLISHED BY MARCH 2009.SDR DL757080442Frame · dentedTHE STA 345 FUSELAGE FRAME WAS DAMAGED BETWEEN S-18L AND S-20L. THE DAMAGE SECTION OF FRAME WAS REMOVED AND A NEW FRAME SECTION WAS SPLICED IN.SDR 2008UALA01741Frame · dentedFOUND FWD PIT FRAME DENTED 2 PLACES AT STA 540 STR 25L. REPAIRED PER REO G 12281 R EV B AND EVA 71348.
SDR 2008UALA01740Frame · dentedFOUND FWD PIT FRAME DENTED AT STA 560 STR 25L. REPAIRED PER REO G 12282 R EV D AND EVA 71349.SDR SWAA081677Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081678Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081679Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081680Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081681Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081672Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081676Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR 2008UALA01706Frame · crackedMID CABIN AREA BS 616L BODY FRAME INNER CHORD IS CRACKED BELOW STRINGER S-17L. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED AREA ON FRAME. ACCMP NDT FOR CRACKS. FABRICATED & INSTALLED STAINLESS STEEL NESTED ANGLE REPAIR.SDR 2008UALA01705Frame · crackedBS 616L FRAME WEB IS CRACKED IN 2 HOLES COMMON TO INBD CHORD ANGLE. UPPER HOLE IS 0.5 INCH BELOW STRINGER S-17L AND LOWER HOLE IN WEB IS 7 INCH BELOW STRINGER S-17L. MAJOR REPAIR ACCOMPLISHED: REAMED HOLES & ACCMP NDT FOR CRACK CONTAINMENT. FABRICATED & INSTSDR 2008UALA01714Frame · dentedFWD PIT AT STA 600 AT STR 24L, FRAME INBOARD FLANGE DENTED. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR IAW SRM. THIS IS A CAT B ZONE 2 RPR WHICH REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS TO BEGIN WHEN ACFT REACHES 45,636C AND 11,000C THEREAFTER. SDR 2008UALA01713Frame · dentedAFT PIT FRAME INBOARD FLANGE IS DENTED AT STA 1500 AND STR 26L. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 RPR 5. THIS IS A CAT B ZONE 1 RPR WHICH REQU IRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS TO BEGIN WHEN ACFT REACHES 50,000C AND 12SDR USAA920080702Frame · crackedCLT - MAJOR REPAIR - CRACKED FRAME WEB, BS 560, S22R - S23R. REPAIRED FRAME WEB, BS 560, S22R - S23R IAW B737 SRM 53-00-07 REPAIR 2.SDR SWAA081668Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081667Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081666Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA081669Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081659Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081657Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800258Frame · crackedCABIN, LEFT SIDE STA 480, FRAME CRACKED BETWEEN S-8L AND S-9L AT PSU RAIL SUPPORT BRACKET. REMOVED DAMAGED SECTION OF FRAME, FAB'D REPAIR PARTS, TREATED, PRIMED AND INSTALLED IN REF TO ECRA5310-04736.SDR KCSA081207Frame · dentedFWD PIT FUSELAGE FRAME UPPER CHORD DENTED AT BS 800.SDR 2008UALA01692Frame · dentedFOUND FWD PIT FRAME DENTED STA 640 STR 25L. REMOVED DAMAGE FABRICATED REPAIR AND INSTALLED IAW SRM 53-00-07 RPR 5 THIS IS A CAT B REPAIR IN ZONE 1 AND REQUIRES SUPPLEMENTAL VISUAL AND NDT INSPECTIONS TO BEGIN 29,294C AFTER RPR INSTALLED, AND REPET ATIVE INSPSSDR 2008UALA01691Frame · dentedFOUND FWD PIT FRAME DENTED STA 600 STR 25L. REMOVED DAMAGE FABRICATED REPAIR AND INSTALLED IAW SRM 53-00-07 RPR 5 ON NR 22857 BY MECH 111857 AND INSP BY QC 071. PER SRM 53-00-07 RPR 5 TABLE II THIS IS A CAT B REPAIR IN ZONE 2 AND
REQUIRES SUPPLEMENTAL VSDR SWAA081619Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081618Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA081635Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081634Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, STR 27L TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081599Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081633Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA081636Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081595Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 14R. REPAIRED FRAME PER SRM.SDR WRNA20080036Frame · chafedDURING C CHECK, FRAME AT STATION 2664.19 LBL 38, WL 295 WAS FOUND CHAFED. REMOVED DAMAGE AND FABRICATED REPAIR PARTS IAW SRM 51-40-03 FIGURE 1. INSTALLED REPAIR PARTS IAW SRM 51-40-03-FIG 1.SDR USAA920080805Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - A .7" CRACK ON FRAME AT BS 727F BETWEEN STR 8R AND STR 9R. INSTALLED REPAIR IAW SRM TR 53-10-20.
Back to JASC 5311