JASC 5321
Service difficulty reports · 49,402
Reports filed under 5321 · Fuselage Floor Panel, 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 = '5321' 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 = '5321' 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 ASOA05727Pressure Panel · corrodedDURING A C-CHECK IN MCN, THE LEFT SIDE PRESSURE FLOOR SKIN PLANK AT FS 461 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS SUBMITTING A DAMAGE REPORT TO BOMBARDIER FOR ISSUANCE OF AN REO TO DETERMINE THE APPROPRIATE CORRECTIVE ACTION. (M)SDR ASOA05728Pressure Panel · corrodedDURING A C-CHECK IN MCN, THE RIGHT SIDE PRESSURE FLOOR SILL STRUCTURE AT FS 461 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS SUBMITTING A DAMAGESDR ASOA05734Pressure Panel · corrodedDURING A C-CHECK IN MCN, THE RIGHT SIDE PRESSURE FLOOR SKIN AT FS 499 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS SUBMITTING A DAMAGE REPORT TO BOMBARDIER FOR ISSUANCE OF AN REO TO DETERMINE THE APPROPRIATE CORRECTIVE ACTION. AFTER MAINTENANCE BLENSDR UIEA200500122Pressure Panel · crackedD-CHECK, FUSELAGE STA 1241 SLOPING PRESSURE DECK WEB WAS FOUND WITH CRACK AT DUCT CUTOUT. THE CRACKED AREA REPAIRED BY CUTTING EXISTING WEB SECTIONS BETWEEN UPPER EDGE OF THE SLOPING DECK AND REAR SPAR AND FROM BL 0 TO TRIM LINE. HFEC INSPECTED THE EDGE OF TSDR SWAA052565Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, LBL 29, WL 208. REPAIRED WEB PER SRM.SDR GTIA050249Floor Panel · corrodedFOUND FLOOR WEB AT APPROX STATION 180 BETWEEN L1 AND R1 DOOR HAS SEVERAL AREAS OF CORROSION. REMOVED CORRODED MEMBRANE AND SUPPORT. FABRICATED NEW MEMBRANE. TREATED, PRIMED AND INSTALLED REPAIR MEMBRANE. (M)SDR SWAA052506Floor Panel · crackedDURING SCHEDULED SPECIAL VISIT, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 188 TO BS 196, RBL 29, WL 208. REPAIRED WEB PER SRM.SDR USAA051019Floor Panel · delaminatedPIT - S1 - FLOOR PANEL, 3 INCH X 3 INCH AREA, DELAMINATION. FLOORBOARD TORN AND DELAMINATED, FR 16 TO 20, Z222 (222EF). DEFECTIVE PART REPLACED WITH IDENTICAL PART. (K)SDR ASAA0570054Floor Panel · dentedPAE - DURING C-CHECK, FOUND AFT CARGO BAY NR 2 FLOOR PANEL DENTED. REPAIRED IAW SRM 53-60-53. (M)SDR 05FDEA02331Floor Panel · damagedMDC FLOOR PNL 242CF IS DAMAGED.SDR 05FDEA02330Floor Panel · crackedMDC FLOOR PNL 231EF IS CRACKED.SDR 05FDEA02329Floor Panel · crackedMDC FLOOR PNL 252UF CRACKED.SDR 05FDEA02328Floor Panel · brokenMDC FLOOR PNL 241LK BROKEN.SDR 05FDEA02308Floor Panel · corrodedCENTER CARGO - UPPER DECK FLOOR PANEL SUPPORT AT STA 1561 X = 58 FOUND CORRODED.SDR 2005UALA00953Floor Panel · corrodedAFT CABIN FLOOR BS 1680 TO 1720, RBL 51 METAL FLOOR CORRODED. REMOVE GALLEY MOUNT FOR ACCESS, REMOVE CORROSION AND INSTALL DOUBLER, ALODINE, PRIME, AND PAINT PER SRM 51-20-01.SDR ASAA0580415Stiffener · dentedOKC - FOUND C-CHECK, CABIN FLOOR PANEL STIFFENER, HAT CHANNEL, DENTED. REPLACED HAT CHANNEL. (M)SDR ASAA0580414Floor Panel · damagedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL IS CREASED ACROSS TOP. REPLACED FLOOR PANEL. (M)SDR ASAA0580413Floor Panel · puncturedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL IS PUNCTURED. REPLACED FLOOR PANEL. (M)SDR ASAA0580412Floor Panel · chafedOKC - DURING C-CHECK, FOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR 05FDEA02253Floor Panel · delaminatedMDC FLOOR PNL 231BH DELAMINATED.SDR 05FDEA02252Floor Panel · crackedMDC FLOOR PNL 252WG CRACKED.SDR 05FDEA02251Floor Panel · crackedMDC FLOOR PNL 252AH CRACKED.SDR 05FDEA02250Floor Panel · crackedMDC FLOOR PNL 252BH IS CRACKED.SDR 05FDEA02246Floor Panel · damagedMDC FLOOR PNL 232FF IS DAMAGED.SDR 05FDEA02245Floor Panel · damagedMDC FLOOR PNL 231FG DAMAGE.SDR 05FDEA02244Floor Panel · damagedMDC FLOOR PNL 232TG DAMAGED.SDR 05FDEA02242Floor Panel · puncturedMDC FLOOR PNL 251YG HAS SEVERAL PUNCTURES ON LWR SURFACE AND 1 ON UPPER SURFACE.SDR 05FDEA02241Floor Panel · damagedMDC FLOOR PNL 231FF DAMAGED.SDR 05FDEA02240Floor Panel · crackedMAIN CARGO COMPT FLOOR PNL 262ZF IS CRACKED AT ATTACH POINT.SDR 05FDEA02239Floor Panel · crackedMAIN CARGO COMPT FLOOR PANEL 242EK IS CRACKED AT SEAT TRACK ATTACH POINT.SDR ASAA0570050Floor Panel · cutPAE - CUT IN FLOOR REPORT BY GROUND IN CARGO PIT 3, NR 2 FLOORBOARD. REMOVED AND FABRICATED NEW NR 2 FLOOR PANEL THEN INSTALLED IAW SRM 53-30-53. (M)SDR ASAA0570049Floor Panel · corrodedPAE - FOUND CORROSION DISCOVERED WHILE WORKING CARD NR 494861. FOUND CORROSION ON NR 3 FLOOR PANEL IN FORWARD CARGO BAY. BLENDED, AND FOUND CORROSION OUT OF LIMITS, FABRICATED NEW NR 3 FLOOR PANEL IAW SRM 53-00-53. (M)SDR 05FDEA02122Floor Panel · crackedMAIN DECK FLOOR PANEL 232CF CRACKED.SDR 05FDEA02121Floor Panel · crackedMAIN DECK FLOOR PANEL 232CF CRACKED.SDR 05FDEA02105Floor Panel · crackedMCD FLR PNL NR 262AH CRACKED. FABRICATED FLOOR PANEL ON TRAVELER NR T5/531328 IAW SRZ-25-005.SDR 05FDEA02104Floor Panel · delaminatedW/O 29493, NR# N00484, BULK CARGO PIT FLOOR PNL 161GF DENTED AND DELAMINATED NEW FLOOR PANEL FABRICATED ON T5/530783 IAW SRZ-25-005SDR 05FDEA02103Floor Panel · delaminatedFWD CGO PIT FLOOR PNL 131MG DELAMINATED AND HAS EDGE DAMAGE. FLOOR PANEL FABRICATED ON TRAVELER T5/530781 IAW SRZ -25-005SDR 05FDEA02102Floor Panel · crackedMCD FLOOR PANEL 232NG PUNCTURED AND CRACKED. FABRICATED NEW FLOOR PANEL ON TRAVELER T5/531061 IAW SRZ -25-005.SDR 05FDEA02097Floor Panel · crackedFLOOR PANEL 231VG PUNCTURED AND CRACKED. FABRICATED FLOOR PANEL ON TRAVELER NR T5/531063 IAW SRZ-25-005.SDR ASAA0570046Floor Panel · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON NR 2 FLOORBOARD AROUND EDGES IN AFT CARGO BAY. REPAIRED IAW SRM 53-60-53. (M)SDR ASOA05630SFloor Panel · corrodedDURING C-CHECK, CORROSION WAS FOUND BEYOND LIMITS ON THE PRESSURE FLOOR SKIN LT SIDE BETWEEN 409 AND 128 TO 559, RBL 36 AND 45. MAINTENANCE IS REPAIRING THE PRESSURE FLOOR SKIN LT SIDE BETWEEN 409 AND 128 TO 559, RBL 36 AND 45 IAW EO. (K)SDR ASOA05629SFloor Panel · corrodedDURING A C-CHECK, CORROSION WAS FOUND BEYOND LIMITS ON THE PRESSURE FLOOR SKIN RT SIDE BETWEEN 409 AND 128 TOO 559 RBL AND 36 AND 45. MAINTENANCE IS REPAIRING THE PRESSURE FLOOR SKIN RT SIDE BETWEEN 409 AND 128 TO 559, RBL 36 AND 45 IAW EO. (K)SDR 05FDEA02040Floor Panel · crackedMAIN CARGO DECK FLOOR PANEL 241PF IS CRACKED IN MIDDLE SECTION OF BOARD. REPLACED FLR PNL ON TRAVELER NR T5/530577 REF SRZ-25-005.SDR 05FDEA02039Floor Panel · delaminatedDURING OK TO INSTALLED FOUND PANEL 162EF DELAMINATED. REPLACED FLR PNL ON TRAVELER NR T5/534022 REF SRZ-25-005.SDR 05FDEA02038Floor Panel · crackedMAIN CARGO FLOOR PANEL 251AH IS CRACKED AT TRACK MAIN ATTACH POINT. REPLACED FLR PNL ON TRAVELER NR T5/530786 REF SRZ-25-005.SDR 05FDEA02037Floor Panel · brokenMCD FLOOR PANEL 242DF IS BROKE AFT END OF BOARD. REPLACED FLR PNL ON TRAVELER NR T5/530576 REF SRZ-25-005.SDR 05FDEA02036Floor Panel · crackedMAIN CARGO FLOOR PANEL 241KJ IS CRACKED AT SEAT TRACK ATTACH POINT. REPLACED FLR PNL ON TRAVELER NR T5/530789 REF SRZ-25-005.SDR 05FDEA02035Floor Panel · puncturedMDC FLOOR PANEL 231EF PUNCTURED AND CRACKED. REPLACED FLR PNL ON TRAVELER NR T5/531062.SDR 05FDEA02034Floor Panel · crackedMCD FLOOR PANEL 231CF PUNCTURED AND CRACKED. REPLACED FLR PNL ON TRAVELER NR T5/3001556 REF SRZ-25-005.SDR 05FDEA02033Floor Panel · brokenMAIN CARGO COMPT FLOOR PANEL 251WG IS BROKEN AT FWD INBD CUTOUT. REPLACED FLR PNL ON TRAVELER NR T5/530573 REF SRZ-25-005.
Back to JASC 5321