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 ASAA0580049Floor Panel · damagedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS BROKEN INSERTS. REPLACED FLOOR PANEL. (M)SDR ASAA0580059Floor Panel · crackedOKC - FOUND DURING C-CHECK, PAX CABIN FLOOR PANEL IS CRACKED, PUNCTURED, AND DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580050Floor Panel · puncturedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL IS PUNCTURED AT TWO LOCATIONS. REPLACED FLOOR PANEL. (M)SDR ASAA0580061Floor Panel · delaminatedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580062Floor Panel · puncturedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL IS PUNCTURED. CORE PLUG REPAIRED. (M)SDR ASAA0580056Floor Panel · dentedOKC - C-CHECK, PAX CABIN FLOOR PANEL DENTED, GOUGED, AND DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580060Floor Panel · crackedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL IS CRACKED, PUNCTURED, CRUSHED, AND DELAMINATED. REPLACED FLOOR PANEL. (M)SDR ASAA0580047Floor Panel · debondedOKC - DURING C-CHECK, PAX CABIN FLOOR PANEL HAS SOFT, DISBONDING SPOT. REPLACED FLOOR PANEL. (M)SDR SWAA050252Web · crackedDURING SCHEDULED D-CHECK, FOUND FLOORWEB AT BS 178, LBL 24, CRACKED. REMOVED AND REPLACED FLOOR WEB SECTION PER SRM.SDR CALA0500031Floor Panel · delaminatedINSPECTION FOUND LT CENTER FLOOR PANEL DELAMINATED AND HOLES PUNCHED IN PANEL AT STA 465-541, LBL 20 TO LBL 40. A NEW PANEL WAS INSTALLED IAW SRM 53-05, PAGE 122B.SDR IXXA0500203SFloorboard · delaminatedDURING ROUTINE C-CHECK FOUND CABIN FLOORBOARD DELAMINATED AT STATION 1120 TO STATION 1260 RIGHT BUTT LINE 54. REMOVED DAMAGED FLOORBOARD, MANUFACTURED NEW FLOORBOARD, LOCATED, DRILLED AND INSTALLED NEW FLOORBOARD IAW DC8 SRM 51-3-0, 51-1-11 AND DOUGLAS SPEC 3SDR ASAA0540056Floorboard · gougedPAE - AFT CARGO BAY FLOORBOARD NR 4 GOUGED AT RT FORWARD TIE DOWN CUTOUT. REMOVED GOUGED BY .25 INCH BY 1 INCH, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-53 FIG 101 DETAIL V. FABRICATED, ALODINED AND PRIMED ACB NR 4 FLOORBOARD IAW 51-40-2 STEP 8B AND AMM 51-21SDR IXXA0500177SFloor Panel · corrodedDURING ROUTINE C-CHECK FOUND FLOORING IN COURIER AREA CORRODED. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. REMOVED FASTENERS, FABRICATED NEW FLOOR PANEL, ALODINED, PRIMED, INSTALLED NEW FLOOR PANEL AND FASTENERS IAW DC8 DRAWING 564827, DC8 SRM 51-1-8, 53-SDR LCQ68Floor Panel · corrodedL-1 FLOOR PANEL COVER HAS CORROSION UPPER AND LOWER SURFACE. S/O 152051, OPS 29737, ZONE 6C-201.SDR LCQ63Floor Panel · corrodedMAIN CABIN FLOOR PANEL NR 83 HAS CORROSION. S/O 152051, OPS 29582, ZONE 6C-157.SDR LCQ62Floor Panel · crackedMAIN CABIN FLOOR PANEL NR 81 HAS CRACKS AROUND RIVETS, 2 EACH PUNCTURES AND SURFACE CORROSION. S/O 152051, OPS NR 29583, ZONE 6C-156SDR LCQ61Floor Panel · brokenMAIN CABIN FLOOR PANEL NR 76 RT CENTER FS 680 - 760 IB HAS HOLES BROKEN OUT ON THE END. S/O 152051, OPS NR 29576, ZONE 6C-153SDR LCQ53Floor Panel · crackedMAIN CABIN FLOOR PANEL NR 95 HAS SKIN TORN ON END AND SURFACE CORROSION ON BOTTOM CHANNELS. S/O 152051, OPS 29564, ZONE 6C-141.SDR LCQ52Floor Panel · crackedMAIN CABIN FLOOR PANEL NR 92 HAS CORNERS BROKEN OUT OF TOP SKIN, HALF SECTION IS CRACKED AND HAS SURFACE CORROSION. S/O 152051, OPS 29535, ZONE 6C-130.SDR LCQ20050120Floor Panel · crackedMAIN CABIN FLOOR PANEL NR 85 HAS HALF SECTION CRACKED OUT. S/O 152051, OPS 29532, ZONE 6C-127.SDR LCQ50Floor Panel · crackedMAIN CABIN FLOOR PANEL NR 80 HAS SECTION CRACKED OUT IN THE CENTER AND TOP SKIN CRACKED OUT ON EDGES. S/O 152051, OPS 29531, ZONE 6C-126.SDR LCQ49Floor Panel · corrodedMAIN CABIN FLOOR PANEL NR 83 HAS SURFACE CORROSION AND A PUNCTURE. S/O 152051, OPS 29530, ZONE 6C-125SDR LCQ48Floor Panel · crackedMAIN CABIN FLOOR PANEL FS 120 - 160 HAS CRACKS ON TOP SKIN AND CORROSION. TOP AND BOTTOM SIDE HAS HOLES DRILLED IN HALF SECTION. S/O 152051, OPS 29528, ZONE 6C-123.SDR LCQ47Floor Panel · damagedCABIN FLOOR PANEL 73 LT CENTER HAS HOLES ON THE EDGE TORN OUT. S/O 152051, OPS 29524, ZONE 6C-119.SDR LCQ46Floor Panel · crackedCABIN FLOOR PANEL HAS 3 EACH AREAS WORN AND CRACKED AT FS 237 LBL 7 FROM CENTER. S/O 152051, OPS 29422, ZONE 6C-88.SDR LCQ45Floor Panel · crackedCABIN FLOOR PANEL HAS GOUGE AND CRACK FWD OF FS 237 I/B OF LEFT O/B SEAT TRACK. S/O 152051, OPS 29423, ZONE 6C-87.SDR LCQ43Floor Panel · corrodedMAIN CABIN FLOOR PANEL 2A IS CORRODED. S/O 152051, OPS 29207, ZONE 6C-27.SDR LCQ42Floor Panel · corrodedMAIN CABIN FLOOR PANEL NR 4 HAS SURFACE CORROSION THROUGH OUT TOP AND BOTTOM. S/O 152051, OPS 29208, ZONE 6C-26.SDR LCQ41Floor Panel · corrodedMAIN CABIN FLOOR PANEL NR 7 HAS SURFACE CORROSION THRU OUT TOP AND BOTTOM. S/O 152051, OPS 29210, ZONE 6C-24.SDR USAA050185Floor Panel · corrodedBFM - S1 CHECK - FLOOR PANEL HEATED, (12 INCHES X 36 INCHES X 0.50) CORROSION AND DELAM. FR 74-75, Y1456, X240 PANEL NR 271JF. REPLACED ALUNIMUM SKIN IAW TYP REP, SRM. (K)SDR USAA050183Floor Panel · corrodedBFM - S1 CK - HEATED FLOOR PANEL, (12 INCHES X 1.5 INCH X 0.60 INCH AREA), CORROSION; LEVEL 2; TASK J7-270-53100, FR74-75, Y-1456, Z-240, PANEL NR 272JF. REPLACED ALUMINUM SKIN IAW TYP REP, SRM. (K)SDR USAA050182Floor Panel · corrodedBFM - S1 CK - HEATED FLOOR PANEL, (12 INCHES X 12 INCHES) CORROSION AND DELAM. CORROSION AND DELAMINATION; LEVEL 2; TASK J7-270-53100-001, FR 33-36, Y2820, Z240, PANEL NR 242 EF. REPLACED ALUMINUM SKIN IAW TYP REP, SRM. (K)SDR USAA050181Floor Panel · corrodedBFM - S1 - HEATED FLOOR PANEL, (12 INCHES X 10 INCH) AREA AND DELAMINATED; CORROSION; LEVEL 2; TASK NR J7-270-53100-008, FR 33 TO FR 36, Z240, Y1959 PANEL NR 242 DF FLOORBOARD. REPLACED ALUMINUM SKIN IAW TYP REP, SRM. (K)SDR USAA050135Floorboard · crackedFOUND FLOORBOARD CRACKED 2.5 INCHES LONG, MAIN CABIN FLOOR PANEL 272K. REMOVED DAMAGE, FABRICATED REPAIR PATCH PER SRM 53-0002-00. (M)SDR ASAA0570010Splice Plate · corrodedDURING MAINTENACE CHECK FOUND CORROSION ON FLOOR PANEL SPLICE PLATE, REPAIR IAW SRM.. (K)SDR ASAA0570008Splice · corrodedDURING MAINTENANCE CHECK FOUND CORROSION ON FLOOR SPLICE AT BS 732, REPAIR IAW SRM. (K)SDR ASAA0570007Splice · corrodedDURING MAINTENANCE CHECK FOUND CORROSION ON FLOOR SPLICE AT BS 871, REPAIR IAW SRM. (K)SDR AWXA200500096Floor Panel · delaminatedSAL - MAJOR REPAIR - DURING C-04 CHECK FOUND PASSENGER CABIN FLOOR PANEL 262FF DELAMINATED. MAINTENANCE REMOVED DAMAGED AREA OF FLOOR PANEL 262FF, PERFORMED BOND REPAIR IAW A320 SRM 53-02-00, FIG 201.SDR USAA050120Floorboard · damagedBFM - FOUND FLOORBOARD WITH HOLE 3.5 INCH BY 3.5 INCH, MAIN CABIN FLOOR PANEL 251JG. FABRICATED NEW FLOORBOARD PER SRM 53-02-00. (M)SDR USAA050122Floorboard · debondedBFM - FOUND FLOORBOARD DISBOND .75 INCH BY 3 INCH AREA, MAIN CABIN FLOORBOARD 262 SG. FABRICATED NEW FLOORBOARD PER SRM 53-02-00. (M)SDR USAA050121Floorboard · puncturedBFM - FOUND FLOORBOARD PUNCTURED 1 INCH BY 2 INCH PUNCTURE, MAIN CABIN FLOORBOARD 231SF. PUNCTURE IN AREA, NOT REPAIRABLE. FABRICATED NEW FLOORBOARD PER SRM 53-02-00. (M)SDR USAA050126Floor Panel · corrodedFOUND FLOOR PANEL CORRODED 17.5 INCHES LONG BY .50 INCHES WIDE BY .093 INCH DEEP, BETWEEN FRAME 73-76 PLUS 2820 -Z240. REPLACED WITH NEW PART PER SRM 51-74-00. CORROSION LEVEL 2, TASK NR J7-270-53100-005. (M)SDR AWXA200500097Floor Panel · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK, CORROSION WAS FOUND ON FACESHEET OF AFT CARGO COMPARTMENT FLOOR PANEL 161AF. MAINTENANCE REMOVED DAMAGED FLOOR PANEL 161AF; FABRICATED A NEW REPLACEMENT FLOOR PANEL; INSTALLED REPLACEMENT PART IAW A320 SRM 53-02-00, FIGSDR UPS05443833Floor Panel · corrodedSTA 1020 TO 1110, BTN L11" AND R11" FLR METAL PNL SKIN FOUND CORROSION. FLOOR PANEL REPAIRED AS PER RS R53-20-35251 AND EO B747-5320-21675-A AND THIS METAL PANEL NEED REPLACEMENT WITHIN 18 MONTHS OR 1000 CYCLES WHICHEVER OCCURS FIRST. CORROSION BLEND OUT DESDR UPS05443832Floor Panel · corrodedSTA 1170 TO 1250, BTN L11 AND R11 FLR METAL PNL SKIN FOUND CORR. METAL FLOOR PANEL REPAIRED AS PER RS R53-20-35251 AND EO B747-5320- 21675-A AND THIS METAL PANEL NEED REPLACEMENT WITHIN 18 MONTHS OR 1000 CYCLES WHICHEVER OCCURS FIRST. CORROSION BLEND OUT DEPSDR AWXA200500065Floor Panel · delaminatedDURING C-04 CHECK AFT CARGO COMPARTMENT FLOOR PANEL 151DF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DELAMINATED FLOOR PANEL 151DF FROM FR 47 TO FR 59; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPLACEMENT PARTS IAW EO 5326-01007.SDR AWXA200500064Floor Panel · delaminatedSAL - MAJOR REPAIR - DURING C-04 CHECK FORWARD CARGO COMPARTMENT FLOOR PANEL 131AF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DELAMINATED FLOOR PANEL 131AF FROM FR 24 TO FR 34; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPLACEMENT PARTS SDR USAA050026Floorboard · delaminatedBFM - S1- FLOORBOARD, 4.0 INCH X 2.5 INCH AREA, DELAMINATION, FR 20-24 +Y 500, -Z240. REPAIRED DAMAGED AREA IAW SRM. (K)SDR AWXA200500066Floor Panel · delaminatedSAL - MAJOR REPAIR - DURING C-04 CHECK AFT CARGO COMPARTMENT FLOOR PANEL 151GF WAS FOUND DELAMINATED. MAINTENANCE REMOVED DELAMINATED FLOOR PANEL 151GF FROM FR 47 TO FR 49; FABRICATED A NEW REPLACEMENT FLOOR PANEL AND DOUBLER; INSTALLED REPLACEMENT PARTS IAW SDR SWIA200414395Pressure Panel · corrodedFUSELAGE PRESSURE FLOOR HAS SURFACE CORROSION FS 409+128 TO FS 559.0 RBL 36-43. ITEM FOUND AT C-CHECK INSPECTION. REMOVED CORROSION IAW CRJ SRM 51-21-06 REO 601R-53-41-272. MAP DAMAGE IAW CRJ SRM 51-13-01.
Back to JASC 5321