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 GTIA030456Floor Panel · brokenFOUND CABIN FS 815 LEFT MID FLOOR PANEL HAS BROKEN INSERT AND MISSING SCREW. FABRICATED NEW PANEL. (M)SDR GTIA030432Floor Panel · crackedFOUND CABIN FS 1112 RIGHT FLOOR PANEL CRACKED. REMOVED OUTBOARD RIGHT FLOOR PANEL. FABRICATED DOUBLER REPAIR. INSTALLED DOUBLER REPAIR. INSTALLED FLOOR PANEL. (M)SDR GTIA030470Floorboard · brokenMAIN CABIN FS 754 RIGHT CENTER FLOOR PANEL HAS BROKEN INSERT. REMOVED PANEL. FABRICATED PANEL. INSTALLED FLOORBOARD. (M)SDR GTIA030468Floor Panel · brokenFOUND MAIN CABIN FS 730 CENTER FLOOR PANEL HAS BROKEN INSERT. REMOVED FLOORBOARD. FABRICATED FLOOR PANEL. INSTALLED NEW PANEL. (M)SDR DHL2003747500Web · crackedDURING C-CHECK DISCREPANCY AS FOLLOWS, CABIN FLOOR SUPPORT WEB AT BS 870 LT SIDE OUTBOARD BY THE EMERGENCY EXIT LBL 60 IS CRACK (MKD). REMOVED FLOOR SUPPORT FOR REPAIR IAW B-727 SRM 51-30-2. CUT-OUT AREA DIM 1.5 INCH X 1 INCH AND FABRICATED ONE FILLER 1.5 INSDR GTIA030314Floor Panel · delaminatedFORWARD LAV ENTRY STA 256 FLOOR PANEL DELAMINATED. REMOVED FLOOR PANEL. FABBED FLOOR PANEL. INSTALLED NEW FLOOR PANEL.SDR GTIA030315Floorboard · delaminatedFORWARD ENTRY STA 200 FLOOR PANEL DELAMINATED. REMOVED FLOOR PANEL. FABRICATED NEW FLOORBOARD. INSTALLED NEW FLOORBOARD.SDR GTIA030327Floorboard · crackedFLOORBOARD MAIN CABIN STA 826-927 LT, CRACKED. STOP DRILLED CRACK. FABBED REPAIR DOUBLER. INSTALLED REPAIR PARTS.SDR 250TR0017Floor Panel · damagedHOLE IN NR 2 FLOOR PANEL IN FORWARD CARGO BIN. REPAIRED PER SRM 51-40-2 FIG 1.SDR AWXA200300490Floor Panel · crackedMCN - MAJOR REPAIR - DURING C-04 CHECK A 1.5 INCH CRACK WAS FOUND IN CENTER OF FLOOR PANEL 261NF. MAINTENANCE PERFORMED COMPOSITE REPAIR OF CRACK IN CENTER OF FLOOR PANEL 261NF IAW A320 SRM 53-02-00 PG 203-207 FIG 202.SDR ASAA0380411Floor Panel · corrodedOAK - DURING C-CHECK, FOUND AFT CARGO BAY FLOOR PANEL 3C3 IS CORRODED. REPLACED FLOOR PANEL PER EA 2550-01066. (M)SDR ASAA0380407Floorboard · puncturedOKC - DURING 30K CHECK, FOUND FLOORBOARD HAS TWO PUNCTURES. REPLACED FLOORBOARD PER SRM. (M)SDR ASAA0380393Retainer · crackedOKC - DURING 30K CHECK, FOUND FLOORBOARD CENTER STATION 886-946 RETAINER CRACKED AROUND FASTENER. REPAIRED PER SRM. (M)SDR ASAA0380392Floorboard · crackedOKC - DURING 30K CHECK, FOUND CABIN FLOORBOARD CRACKED. REPAIRED FLOORBOARD PER SRM. (M)SDR ASAA0380394Floorboard · gougedOKC - DURNG 30K CHECK, FOUND FLOORBOARD STATION 811 RBL 22-43 LOWER SKIN CORNER GOUGED. REPAIRED PER SRM. (M)SDR SWIA200312059Floor Panel · crackedFS 193 ELECTRICAL BAY RT FLOOR CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGE IAW CRJ REO 601R-53-11-245 REV NC.SDR GTIA030307Floorboard · crackedPAX CABIN FLOORBOARD CRACKED/BROKEN AT FS 218-294 LEFT BETWEEN SEAT TRACKS 1 AND 2. REMOVED FLOORBOARD, DRILL AND LOCATE AND INSTALLED FLOORBOARD.SDR GTIA030287Floorboard · brokenFLOORBOARD (CABIN) AT STA 826-886 (CENTER) FWD LT CORNER BROKEN. REMOVED DAMAGED CORRECTED ON FLOORBOARD. FABRICATED NEW COVER. INSTALLED NEW COVER.SDR 03FDEA00510Floor Panel · tornMAIN CARGO DECK FLOOR PANEL AT BS 950 RBL 45 INBOARD EDGE TORN. *S/D* REPAIRED IAW FED EX BOEING 727 SR 27-51-002.SDR GTIA030312Floor Panel · brokenCABIN FLOOR PANEL AT FS 200-237 CENTER IS BROKEN IN CENTER. FABRICATED NEW FLOOR PANEL.SDR 03FDEA00508Floor Panel · missingFORWARD AUXILARY FUEL TANK FLOOR ACCESS PANEL AT STA 720E RIGHT SIDE HAS AREAS OF FILLING COMPOUND MISSING ON 3 OF 4 EDGES. *S/D* REPAIRED FLOORBOARD ACCESS PANEL IAW FED EX SRZ 25-005C.SDR 03FDEA00507Floor Panel · damagedAFT CARGO PIT FLOOR PANEL STA 960E TO 990 HAS GILLINER PATCH WITH HOLE PUNCTURED THROUGH. *S/D* REPAIRED FLOOR PANEL IAW BOEING SRM 727-200 53-10-07.SDR 03FDEA00472Floor Panel · damagedAFT CARGO PIT STA 1030 TO 1070 FORWARD CENTER FLOOR PANEL HAS SEVERAL GOUGES AND A PREVIOUS REPAIR.SDR 03FDEA00471Floor Panel · damagedAFT CARGO PIT AT STA 960E TO 990 FORWARD FLOOR PANEL HAS A HOLE.SDR 03FDEA00469Floor Panel · damagedA .75 X 3.5 INCH HOLE IN FLOOR OF AFT LOWER CARGO COMPARTMENT STATION 1020.SDR UPS03840454Pressure Panel · corrodedINSPECTION TYPE: C1, LT NOSE WHEEL WELL TUNNEL, PRESSURE WEB IS CORRODED BEYOND LIMITS OUTBOARD OF HEAT EXCHANGER SUPPORT BRACKET AT STA -68 AT APPROX LBL 64. CUT OUT DAMAGED AREA, NDT VERIFIED NO CRACKS AT CUTOUT. FABRICATED AND INSTALLED FILLER, SPLICE, DSDR GTIA030288Floorboard · delaminatedCABIN FLOORBOARD STA 1003-1079 DELAMINATED. FABRICATED REPLACEMENT FLOORBOARD.SDR UPS03440544Web · corrodedINSPECTION TYPE: C, FLOOR WEB AT BS 520 RBL 83 FOUND CORROSION. WEB REPAIRED AS PER RS NR : R52-25-35007 AND ENGINEERING FILE NUMBER 747-53-20130.SDR ASAA0380309Floor Panel · corrodedOAK - FOUND DURING 15K CHECK, E/E FLOOR PANEL IS CORRODED AT FS 160-218. REPLACED SUPPORT PER SRM 53-01 AND 51-30-2. (M)SDR 2003F00539Floor Panel · brokenFOUND CABIN FLOOR PANEL LBL 22-44 FS 802-889 IS BROKEN. FABRICATED AND INSTALLED REPAIR FLOOR PANEL IAW MD80 SRM 53-05 PAGE 122A THROUGH 127. (M)SDR GTIA030267Floorboard · corrodedFTW - FOUND FORWARD CABIN RIGHT SIDE STATION 200 TO STATION 256, FLOOR PANEL SOFT/MUSHEY DETERIORATED INSERTS CORRODED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030273Floor Panel · deterioratedFTW - FOUND MAIN CABIN STATION 1041 TO STATION 1060 FLOOR PANEL DETERIORATED. FABRICATED A NEW FLOOR PANEL. (M)SDR GTIA030266Floorboard · corrodedFTW - FOUND FORWARD CABIN STATION 200 TO STATION 180 FLOOR PANEL SOFT/MUSHEY CORRODED AT INSERTS. FABRICATED NEW FLOORBOARD. (M)SDR ASAA0380296Floor Panel · crackedOAK - DURING 15K CHECK, FOUND FLOOR WEB CRACK AT FS 1250 UNDER SEAT 32 F/D. STOP DRILLED CRACK AND INSTALLED DOUBLER AT RIGHT CUSP MEMBRANE WEB. (M)SDR ASAA0380292Floorboard · damagedOKC - DURING 30K CHECK, FOUND FLOORBOARD INSERTS MISSING AT FS 150-200. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380291Floorboard · crackedOKC - DURING 30K CHECK, FOUND FLOORBOARD LOWER SURFACE CORNER IS CRACKED. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0380290Floorboard · delaminatedOKC - DURING 30K CHECK, FOUND FLOORBOARD MISSING RIVETS AND IS DELAMINATED AT FS 200-237. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR SWIA200311942Floor Panel · crackedRIGHT AND LEFT ELECTRICAL BAY FLOOR PANELS AT FS 193 CRACKED. FOUND DURING C-CHECK INSPECTION. NDT HFEC CARRIED OUT IAW REO 601R-53-11-081. NO CRACKS NOTED. REPAIRED DAMAGED FLOOR IAW CRJ REO 601R-53-11-245 REV NC.SDR AWXA200300338Floor Panel · crackedMCN - MAJOR REPAIR - DURING C-04 CHECK A DAMAGED SCREW INSERT, AND 1 1/2 INCH CRACK WERE FOUND ON AFT LAVATORY FLOOR PANEL (261 PF). MAINTENANCE PERFORMED COMPOSITE REPAIR OF CRACK, AND REPLACED DAMAGED SCREW INSERT ON AFT LAVATORY FLOOR PANEL (261 PF) IAW A32SDR MWEA030148Floor Panel · corrodedFLOOR PANEL AT STATION 1290 BETWEEN LEFT SEAT TRACKS IS CORRODED. REMOVED AND REPLACED FLOORBOARD.SDR GTIA030174Floor Panel · damagedPAX CABIN CENTER FLOOR PANEL STA 826 TO STA 886 SOFT/MUSHEY AND SEVERAL INSERTS BROKEN OUT. FABRICATED NEW FLOOR PANEL.SDR GTIA030173Floorboard · damagedFLOORBOARD AT STA 1309-1260 CENTER DAMAGED. FAB PANEL.SDR MWEA030139Doubler · corrodedSUBFLOOR HAS A SPOT OF LIGHT CORROSION AT STATION 207 APPROBIMATELY 6" RIGHT OF CENTER. -- FABRICATED AND INSTALLED NEW REPAIR DOUBLER.SDR MWEA030138Intercostal · crackedSUBFLOOR INTERCOSTAL CRACKED IN SEVERAL PLACES BETWEEN FRAME STATION 788 AND 769 CENTERLINE. --FABRICATED AND INSTALLED REPAIR.SDR CALA0300133Pressure Panel · crackedINSPECTION FOUND A 1 INCH CRACK IN RT PRESSURE DECK AT STA 664. REPAIRED IAW SRM 53-60-51.SDR AWXA200300307Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 3158, FR 66, TO BS 3257, FR 68. MAINTENANCE REMOVED DAMAGED FLOOR PANEL BS 3158, FR 66, TO BS 3257, FR 68; FABRICATED A NEW REPLACEMENT FLOOR PANEL; INSTALLED REPAIR PART IAW SDR AWXA200300306Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 2136, FR 47, TO BS 2350, FR 51. MAINTENANCE REMOVED DAMAGED FLOOR PANEL BS 2136, FR 47, TO BS 2350, FR 51; FABRICATED A NEW REPLACEMENT FLOOR PANEL; INSTALLED REPAIR PART IAW SDR AWXA200300305Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 950, FR 24, TO BS 1163, FR 28. MAINTENANCE PERFORMED BOND REPAIR ON UPPER SURFACE OF CABIN FLOOR PANEL BS 950, FR 24, TO BS 1163, FR 28 IAW A320 SRM 53-02-00, PG. 203-207, FIGSDR AWXA200300304Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 3093, FR 64, TO BS 3158, FR 66. MAINTENANCE PERFORMED BOND REPAIR ON UPPER SURFACE OF CABIN FLOOR PANEL BS 3093, FR 64, TO BS 3158, FR 66 IAW A320 SRM 53-02-00, PG. 203-207, FSDR AWXA200300303Floor Panel · debondedDURING C-03 CHECK THE UPPER SURFACE OF CABIN FLOOR PANEL WAS FOUND DISBONDED FROM BS 3158, FR 66, TO BS 3257, FR 68. MAINTENANCE REMOVED DAMAGED FLOOR PANEL BS 3158, FR 66, TO BS 3257, FR 68; FABRICATED A NEW REPLACEMENT FLOOR PANEL; INSTALLED REPAIR PART IAW
Back to JASC 5321