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 CALA0600514Floorboard · corrodedINSPECTION FOUND FLOORBOARD CORRODED AT STA 986.5, LBL 26. REPAIRED IAW SRM 53-00-51.SDR CALA0600510Floorboard · corrodedINSPECTION FOUND FLOORBOARD CORRODED AT STA 986.5, RBL 4. REPAIRED IAW SRM 53-00-51, FIGURE 203, PAGE 208.SDR AMTA200600712Floor Panel · corrodedFOUND FS 727I+5 TO 772 LBL 22 RBL 22 AFT CARGO PANEL 140BF HAS CORROSION ON BOTH LEFT AND RIGHT EDGES OF PANEL WITH PITTING IN CENTER OF PANEL OUT OF LIMITS. FABRICATED FLOOR PANEL 140BF IAW SRM 53-60-53 REF SS 7520625 TRAVELER NR 0001. (M)SDR SWIA200617698Floorboard · crackedCOCKPIT FLOORBOARD AT SUPPORT ATTACHED 280 BEAM IS CRACKED AT THE LT AND RT SIDES, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW FLOOR SUPPORT AFT COCKPIT PART NR CC670-33282-13 P/O 74023 PER SRM 51-42-21.SDR AWXA200700058Floor Panel · delaminatedSAL - MAJOR REPAIR - MAIN CABIN FLOOR PANEL NR 232XF DELAMINATED. REPLACED MAIN CABIN FLOOR PANEL NR 232XF IAW A320 SRM 53-02-00.SDR AWXA200700065Floor Panel · delaminatedSAL - MAIN CABIN FLOOR PANEL NR 251 HF DELAMINATED. REPLACED MAIN CABIN FLOOR PANEL NR 251 IAW A320 SRM 53-02-00.SDR AWXA200700064Floor Panel · delaminatedSAL - MAJOR REPAIR - MAIN CABIN FLOOR PANEL NR 231NF DELAMINATED. REPLACED MAIN CABIN FLOOR PANEL NR 231NF IAW A320 SRM 53-02-00.SDR DALA1134750682Floor Panel · gougedAFT GALLEY FLOOR AT BS 1682, BL-54L GOUGES REPAIRED IAW SRM 53-00-51, 51-20-01, 53-60-51 FIG 201.SDR DU4R2006702Floorboard · corrodedCORROSION ON AFT GALLEY FLOOR AT BS 1680 - BL 48R CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 5-1/2" BY 7-1/2" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006701Floorboard · corrodedCORROSION ON GALLEY FLOOR AT BS 1720 - BL 36R CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 5-1/2" BY 7-1/2" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006700Floorboard · corrodedCORROSION ON GALLEY FLOOR AT BS 1720 - BL 20R CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 18-3/4" BY 7-1/2" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006699Floorboard · corrodedCORROSION ON GALLEY FLOOR AT BS 1720 - BL 0 TO BL 8R CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 18-1/2" BY 7-1/2" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006698Floorboard · corrodedCORROSION ON GALLEY FLOOR AT BS 1720 - BL 12L CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 17-1/2" BY 6-5/8" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006697Floorboard · corrodedCORROSION ON GALLEY FLOOR AT BS 1720 - BL 4L CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 17-1/2" BY 6-5/8" FROM 2024-T3 .063" BAC1517-2226 IAW B757 SRM 51-10-02, 53-00-51, 51-20-01, AND 53-60-51 FIG 201.SDR DU4R2006693Floor Panel · gougedGOUGES ON AFT GALLEY FLOOR AT BS 1682 BL-54L IN CABIN COMPARTMENT. FABRICATED AND INSTALLED REPAIR DOUBLER 9-1/2" BY 5-3/4" FROM 2024-T3 .063" IAW B757 SRM 53-00-51, 51-20-01, 53-60-51 FIG 201.SDR ASAA0691232Floor Panel · corrodedAFT CARGO FLOOR PANEL NR 2 AT BS 727D+5 REPAIRED IAW SRM 51-10-02 PAR 9G.SDR ASAA0691234Floor Panel · corrodedAFT CARGO FLOOR PANEL NR 3 AT BS 7237I+5 CORRODED REPAIRED IAW SRM 51 10 02SDR ASAA0691230Floor Panel · corrodedAFT CARGO FLOOR PANEL AT BS 792 CORRODED REPAIRED IAW SRM 51 10 02 PAR 9G.SDR ASAA0671276Floor Panel · corrodedAFT CARGO FLOOR PANEL 140AF CORRODED REPAIRED IAW SRM 51 10 02 PAR G9.SDR ASAA0671274Floor Panel · corrodedFWD CARGO FLOOR PANEL 120AF CORRODED REPAIRED IAW SRM 51 10 02 PAR G9.SDR ASAA0671273Floor Panel · corrodedAFT CARGO FLOOR PANEL 140 DF CORRODED. REPAIRED IAW SRM 51-10-02 PAR 9G.SDR ASAA0671272Floor Panel · corrodedFWD CARGO FLOOR PANEL 120 CF CORRODED. REPAIRED IAW SRM 51-10-02 PAR 9G.SDR ASAA0671271Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL 120BF CORRODED. REPAIRED IAW SRM 51-10-02.SDR ASAA0671270Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL 140 CF CORRODED. REPAIRED IAW 51-10-02 PAR 9G.SDR ASAA0671269Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL 140BF CORRODED. REPAIRED IAW SRM 51-10-02 PAR 9G.SDR ASAA0691231Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL NR 1 AT BS 727 CORRODED REPAIRED IAW SRM 51 10 02 PAR 9G.SDR ASAA0691229Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL AT BS 887 CORRODED REPAIRED IAW SRM 51 10 02 PAR 9.SDR ASAA0691226Floorboard · corrodedFWD PIT NR 3 FLOORBOARD CORRODED. REPAIRED IAW SRM.SDR ASAA0691223Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL BS 887-940 CORRODED REPAIRED IAW SRM 51 40 20.SDR ASAA0691222Floorboard · corrodedFWD CARGO PIT FLOORBOARD NR 2 AT BS 430-500 CORRODED REPAIRED IAW SRM 51 10 02.SDR ASAA0691221Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL AT BS 500D NR 4 CORRODED REPAIRED IAW SRM 51 10 02.SDR ASAA0691220Floorboard · corrodedFWD CARGO PIT FLOORBOARD CORRODED AT BS400-440 REPARIED IAW SRM 51 10 02 PARA 9G.SDR ASAA0691248Floor Panel · corrodedFWD CARGO PIT NR 5 FLOOR PANEL CORRODED. REPLACED WITH FABRICATED REPAIR PART IAW SRM 53 30 53 FIG 2.SDR AWXA200602007Floor Panel · corrodedSAL - CORROSION ON CABIN FLOOR PANEL 221FF, FS 16 - FS 20, +Y1292 - +Y1349. REPLACED CABIN FLOOR PANEL 221FF, FS 16 - FS 20, +Y1292 - +Y1349 IAW A319 SRM 51-72-11.SDR AWXA200602006Floor Panel · corrodedSAL - CORROSION ON CABIN FLOOR PANEL 222FF, FS 16 - FS 20, -Y1292 TO -Y1349. REPLACED CABIN FLOOR PANEL 222FF, FS 16 - FS 20, -Y1292 TO -Y1349 IAW A319 SRM 51-72-11.SDR ASAA0681208Floor Panel · delaminatedCABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL PER SRM 53-05 DWG 9939195 AND MM 53-20-01.SDR 06FDEA04056Floor Panel · dentedCOCKPIT, DENT MARKS ON FLOOR PANEL 216BF. COCKPIT FLOOR PANEL #216BF REMOVED AS PER AMM 53-21-02. FLOOR PANEL FABRICATED AS PER DRAWING ABA 8675, NEW FLOOR PANEL PAINTED AS PER SRM 51-21-01 AND INSTALLED AS PER AMM 53-21-02. REPAIR CLASSIFIED MAJOR ASSDR QXEA200603066Floor Panel · corrodedC2 PDX - CUTOUT FOR AFT CARGO BAY DECK PANEL 144GZ HAS CORROSION UNDER NUTPLATE. REPAIRED IAW SRM 51-14-00 AND 51-25-10.SDR AWXA200601945Floor Panel · delaminatedPHX - DELAMINATION ON CENTER AISLE FLOOR PANEL FROM FS 42 TO 47. REPLACED CENTER AISLE FLOOR PANEL FROM FS 42 TO 47 IAW TASK CARD R1C25306.SDR DU4R2006690Floor Panel · corrodedCORROSION IN AFT CABIN BS 1720 S-20R FLOOR PANEL. FABRICATED AND INSTALLED REPAIR FILLER 21 BY 7.5 FROM 2024-T3 .063 IAW B757 SRM 51-10-2, AND 53-60-51 FIG 201.SDR USAA061346Floor Panel · delaminatedFRAME 14-16 DELAMINATED. FABRICATED NEW FLOOR PANEL PER MCGILL IRM 9701 REV F. DEFECT SIZE: 2 X 4 INCHES AT 2 AREAS.SDR AMTA200600655Floor Panel · corrodedAFT CARGO FLOOR PANEL 1538X HAS CORROSION ALONG EDGE OF PART AS MARKED F/S 946 TO 948, LBL 22 TO RBL 22, UPPER SURFACE. BLENDED AREA, MATERIAL THICKNESS 080, MAX MATERIAL LOSS IS 003 WITHIN LIMITS IAW SRM, FIG 101. TREATED AND PRIMED ARA IAW SRM. (K)SDR AMTA200600653Floor Panel · corrodedFWD CARGO BAY, THE FWD PORTION OF THE LT TRAP FOR THE FLOOR PANEL IS CORRODED. F/S 472-500, LBL 22. REMOVED CORROSION IAW 53-30-53, ORIGINAL THICKNESS IS 063, REMAINING MATERIAL THICKNESS IS .060 AND FOUND TO BE WITHIN LIMITS IAW SRM 53-30-53, FIG 101. (K)SDR AMTA200600648Floor Panel · corrodedAFT CARGO FLOOR PANEL 1534X HAS CORROSION AROUND FASTENER HOLES ON FORWARD F/S 727 TO 732, LBL 20 TO RBL 20 ON ITS UPPER SURFACE. BLENDED AREA AT AFT CARGO FLOOR PANEL 1534X AROUND FASTENER HOLES ON FORWARD END UPPER SURFACE. ORIGINAL THICKNESS IS 080, BLENDSDR AMTA200600647Floor Panel · corrodedAFT CARGO FLOOR PANEL 1535X HAS CORROSION ON EDGES OF THE UPPER SURFACE AS MARKED. REMOVED CORROSION ON FLOOR PANEL 1535X IAW SRM 53-30-53 FIG 101. ORIGINAL THICKNESS IS 080 ENDING THICKNESS IS 076 MATERIAL LOSS IS 004 AND FOUND TO BE WITHIN LIMITS. (K)SDR AMTA200600646Floor Panel · corrodedAFT CARGO FLOOR PANEL 1536X IS CORRODED ESPECIALLY AT DOOR THRESHOLD AREA F/S 767 TO 789 RBL 17 TO 22.0 UPPER SURFACE. BLENDED OUT CORROSION ON UPPER SURFACE OF FLOOR PANEL IAW 53-30-53 WITHIN LIMITS. ORIGINAL MATERIAL .071 MATERIAL LOSS .005. (K)SDR ASAA0671173Floor Panel · corrodedAFT PIT FLOOR PANEL NR 140 CF CORRODED REPAIRED IAW SRM 51 40 05.SDR ASAA0671171Floorboard · corrodedAFT CARGO PIT PH SIDE WALL TO FLOOR BOARD SHEILD CORRODED AT BS 867 REPAIRED IAW SRM 53 60 15.SDR ASAA0671165Floor Panel · corrodedFOUND CORROSION ON AFT FIT FLOOR PANEL NR 140, CF REPAIRED IAW 53 00 53.SDR ASAA0671164Floor Panel · corrodedFOUND CORROSION ON AFT PIT FLOOR PANEL NR 14OAF. REPAIRED IAW SRM 53 00 53.
Back to JASC 5321