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 GTIA030125Floorboard · damagedFTW - FOUND FORWARD CABIN STATION 160 TO STATION 148 RBL 17 INCHES TO RBL 32 (11 BY 15) FLOOR PANEL SOFT/MUSHY. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA030124Floorboard · damagedFTW - FOUND FORWARD CABIN STATION TO STATION 148 RBL 17 TO 45 (11 BY 13) FLOOR PANEL SOFT/MUSHY. FABRICATED NEW CABIN FLOORBOARD. (M)SDR GTIA030123Floor Panel · delaminatedFTW - FOUND MAIN CABIN STATION 1117 TO STATION 1174 FLOOR PANEL DELAMINATING. FABRICATED REPLACEMENT FLOOR PANEL. (M)SDR GTIA030165Floor Panel · damagedFORWARD CABIN STA160 TO 122 (CENTER) FLOOR PANEL HAS SOFT/MUSHEY, DAMAGED SEVERAL INSERTS CORRODED. FABRICATED FORWARD CABIN FLOOR PANEL.SDR SIMA200307907Doubler · corrodedTHIS IS A LEVEL TWO FINDING FOUND DURING AN IMBV INSPECTION, LEFT CARGO FLOOR DOUBLER FROM STATION 65 TO 68 CORRODED. REMOVED AND INSTALLED CARGO FLOOR DOUBLER FROM STATION 65 TO 68 IAW EMB SRM 51-40-02. (M)SDR GTIA030148Floor Panel · deterioratedFORWARD CABIN STA 200 TO 256 FLOOR PANEL SOFT/ MUSHEY DETERIORATED, CORR. INSERTS, LBR 22 TO LBR 44 (21X56). FABRICATED NEW PANEL.SDR GTIA030146Floor Panel · damagedFWD CABIN STA 180 TO 160 LBR 8 INCHES TO 44 INCHES (20X36) FLOOR PANEL SOFT/ MUCHEY DAMAGED DETERIORATED CORR. INSERTS. FABRICATED NEW PANEL.SDR GTIA030145Floorboard · corrodedFORWARD CABIN STA 200 TO 160 LBL 44 TO 53 INCHES (9 X 40) FLOOR PNL SOFT/ MUSHY CORRODED INSERTS. FABBED NEW CABIN FLOORBOARD, STA 200-160 LBL 53.SDR GTIA030129Floorboard · damagedFTW - FOUND FORWARD CABIN STATION 200-160 FLOOR PANEL SOFT/MUSHY CORRODED INSERTS, 12 BY 40. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030128Floorboard · damagedFTW - FOUND FORWARD CABIN STATION 206 TO STATION 160 LBL 44 INCHES TO LBL 56 INCHES, 12 BY 40, SOFT/MUSHEY DETERIORATED. FABRICATED CABIN FLOORBOARD. (M)SDR GTI030149Floor Panel · damagedFORWARD CABIN FLOOR PANEL HAS SOFT/MUSHEY DAMAGED DETERIORATED CORR. INSTERS LBR 8 INCH TO 44 INCH STA 200 TO 180 (20X36). FABRICATED NEW PANEL.SDR GTIA030151Floorboard · deterioratedFORWARD CABIN STA 200 TO STA 256 (CENTER) FLOOR PANEL SOFT/DAMAGED, DETERIORATED CORE INSERTS. FABRICATED NEW FLOORBOARD.SDR GTIA030131Floor Panel · corrodedFTW - FOUND MAIN CABIN FLOOR PANEL STATION 1155 TO STATION 1250 HAS SOFT/MUSHY DETERIORATED SEVERAL INSERTS. FABRICATED FLOOR PANEL. (M)SDR GTIA030130Floor Panel · damagedFTW - FOUND MAIN CABIN FLOOR PANEL STATION 1174 TO STATION 1250, CENTER, HAS SOFT/MUSHY DETERIORATED AND SEVERAL INSERTS CORRODED. FABRICATED NEW FLOOR PANEL. (M)SDR 2003UALA00192Floor Panel · corrodedAFT CABIN FLOOR PLATE CORR0DED AT STA 1680 - 1684, RBL 45 TO RBL 53. RECHECKED FOR EXCESSIVE MATERIAL LOSS AT STA 1681 RBL 49-50 AND RBL 51-53. MAJOR REPAIR ACCOMPLISHED. AFT CABIN FLOOR DECK PLATE CORROSION BLENDED AND REPAIR DOUBLER INSTALLED AT STA 1681SDR GTIA030216Floor Panel · delaminatedFTW - FOUND CABIN FLOOR PANEL STATION 886-946 DELAMINATED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020197Floor Panel · delaminatedFTW - FOUND CABIN FLOOR PANEL STATION 886-927 DELAMINATED. FABRICATED FLOOR PANEL. (M)SDR GTIA030196Floorboard · delaminatedFTW - FOUND CABIN FLOORBOARD STATION 826-864, DELAMINATED. FABRICATED FLOORBOARD. (M)SDR GTIA030195Floor Panel · delaminatedFTW - FOUND CABIN FLOORBOARD STATION 864-875 DELAMINATED. FABRICATED NEW FLOOR PANEL. (M)SDR CALA0300054Pressure Panel · crackedINSPECTION FOUND A .5 INCH CRACK IN PRESSURE DECK AT BS 664 - 675, LBL 30 - 35. REPAIRED IAW SRM 53-60-51, PAGE 213-221.SDR SIMA200307104Floorboard · corrodedABI - THIS IS A LEVEL TWO FINDING FOUND DURING AN IMBV INSPECTION, GALLEY FLOORBOARD EXTENSION HAS CORROSION. REMOVED AND INSTALLED FLOORBOARD EXTENSION IAW EMB 135 SRM 51-40-02, 51-20-03, 51-40-04, 51-40-06. (M)SDR ASAA0380138Floor Panel · corrodedOKC - FOUND DURING 30K CHECK, CABIN FLOOR PANEL TO HAVE 16 CORRODED INSERTS FROM FS 160-180. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380137Floor Panel · corrodedOKC - DURING 30K CHECK, FOUND CABIN FLOOR PANEL FOND TO HAVE 4 CORRODED INSERTS FROM FS 110-200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0380136Floor Panel · corrodedOKC - FOUND DURING 30K CHECK, CABIN FLOOR PANEL TO HAVE 16 CORRODED INSERTS FROM FS 160 TO 200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR CALA0300047Pressure Panel · crackedINSPECTION FOUND A .75 INCH CRACK IN BOTH THE LEFT HAND AND RIGHT HAND PRESSURE DECK AT STA 663.75. BOTH LOCATIONS WERE REPAIRED IAW SRM 53-60-51.SDR GTIA030100Floorboard · corrodedFTW - FOUND FORWARD CABIN STATION 200-260 RBL 24 TO 44 FLOORBOARD HAS CORROSION AT INSERTS/SOFT MUSHEY. FABRICATED PANEL. (M)SDR 03FDEA00123Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 950, LBL 50, RBL 25, WL 208.SDR GTIA030094Floor Panel · crackedFTW - FOUND PAX CABIN FLOOR WEB CRACKED AT LONGERON 18L STATION 325. CUT OUT DAMAGED WEB. FABRICATED FLOOR WEB AND DOUBLER. INSTALLED WEB AND DOUBLER. (M)SDR GTIA030092Floorboard · crackedFTW - FOUND CABIN PRESSURE FLOORBOARD RIGHT STATION 265-313 4 EACH RIVETS PULLED THROUGH SKIN AND CRACKED. REMOVED CRACKED SKIN. FABRICATED NEW FLOORBOARD SKIN. INSTALLED NEW SKIN. (M)SDR AWXA200300205Panel · tornMCN - MAJOR REPAIR - DURING C-04 CHECK CORE DAMAGE WAS FOUND ON AFT GALLEY FLOOR PANEL, 2 EACH SCREW INSERTS WERE ALSO FOUND DAMAGED, FR 68 - 70. MAINTENANCE PERFORMED COMPOSITE REPAIR ON AFT GALLEY FLOOR PANEL IAW A320 SRM 53-02-00, PG. 102-105, & 108, FIG. 1SDR GTIA030095Floor Panel · crackedFTW - FOUND MAIN CABIN FS 1174 RIGHT OUTBOARD FLOOR PANEL CRACKED. REMOVED DAMAGED FLOOR PANEL. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. REINSTALLED FLOOR PANEL. (M)SDR 2003F00146Floor Panel · chafedAPU COMPARTMENT FLOOR HAS CHAFING MARK .020 INCHES DEEP. CHAF DAMAGE CAUSED BY APU DRAIN HOSE ID TAB RUBBING AGAINST FLOOR. PROVIDED PROPER CLEARANCE. REPAIRED RUB DAMAGE IAW GULFSTREAM REPAIR LETTER DRAWING SE55053001 DATED 2/6/2003. (M)SDR GTIA030082Floorboard · deterioratedFTW - FOUND FLOORBOARD STATION 130-160 DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030065Floorboard · damagedFTW - PASSENGER CABIN STATION 1309 TO 1360 FLOORBOARD HAS SOFT/MUSHEY BLUE WATER STAINS AND SEVERAL INSERTS DAMAGE. FABRICATED NEW PASSENGER CABIN FLOORBOARD. (M)SDR GTIA030113Floor Panel · corrodedFLIGHT COMPARTMENT STA 138 CORRODED ON WEB UNDER INBOARD CAPTAINS SEAT TRACK. REMOVED DAMAGED AREA OF WEB. FABBED NEW WEB SECTION. FABRICATED SPLICE. INSTALLED SPLICE. INSTALLED NEW WEB SECTION FS 133, FS 160, RBL 4, LBL30.SDR GTIA030066Floorboard · deterioratedFTW - FOUND FLOORBOARD R1 ENTRY DETERIORATED. FABRICATED NEW R1 ENTRY FLOORBOARD. (M)SDR GTIA030059Floor Panel · deterioratedFTW - FLOOR PANEL STATION 200-260 LBL 20 LBL 44 DETERIORATED. FABRICATED NEW PANEL. (M)SDR GTIA030073Floor Panel · crackedFTW - FOUND FLOOR PANEL FORWARD CABIN STATION 200-260 HAS BLUE WATER STAINS AND CRACKED. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA030069Floor Panel · deterioratedFTW - FOUND FLOOR PANEL FORWARD ENTRY L-1 DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030068Floor Panel · deterioratedFTW - FOUND FLOOR PANEL STATION 160-200 HAS BLUE WATER AND DETERIORATION. FABRICATED NEW FLOORBOARD. (M)SDR GTIA030074Floorboard · deterioratedFTW - FOUND FORWARD CABIN FLOORBOARD STATION 160-200 DETERIORATED. FABRICATED NEW FLOORBOARD. (M)SDR CALA0300026Pressure Panel · crackedINSPECTION FOUND A CRACK IN PRESSURE DECK WEB AT STA 663, LBL 32. THE AREA WAS REPAIRED IAW SRM 53-60-51, FIGURE 203 AND ECRA 5310-04317.SDR SIMA200306405Floorboard · corrodedABI - A LEVEL TWO FINDING, FOUND DURING AN IMBV INSPECTION GALLEY FLOORBOARD EXTENSION CORRODED. REMOVED AND INSTALLED SERVICEABLE EXTENSION IAW EMB 134 SRM 51-40-02. (M)SDR CALA0300025Pressure Panel · crackedINSPECTION FOUND A CRACK IN THE PRESSURE DECK WEB AT STA 665 - 675, RBL 35 - 45. THE CRACK WAS ESTIMATED TO BE .5 - .75 INCH LONG. THE AREA WAS REPAIRED IAW SRM 53-60-51, FIGURE 203 AND ECRA 5310-04316.SDR AWXA200300168Floor Panel · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND LOWER FLANGE UPPER TEE CAP OF AFT GALLEY DECK PLATE BS 1681 - 1720, LBL 51 TO RBL 51. MAINTENANCE REMOVED AFT GALLEY SHEAR PLATE BS 1681 - 1720, LBL 51 TO RBL 51; FABRICATED A NEW REPLACEMESDR 2003UALA00104Pressure Panel · damagedAFT CABIN PRESSURE DECK WEB, STA 1681 - RBL 50 TO 52, HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPAIRED DECK WITH FILLER AND DOUBLER.SDR HEEA083968Floor Panel · corrodedCARGO DECK FLOOR PANEL CORRODED AND SEPARATED.SDR GTIA030029Floorboard · delaminatedFTW - FOUND FLOORBOARD UNDER FORWRAD LAVATORY IS DELAMINATED AROND LAVATORY CONNECTION HOLES, AND FASTENERS ARE CORRODED. REMOVED FLOORBOARD UNDER FORWARD LAVATORY STATION 218-275. REPAIRED FLOORBOARD UNDER FORWARD LAVATORY. INSTALLED FLOORBOARD. (M)SDR ASAA0380083Floorboard · puncturedOKC - FOUND DURING C-CHECK, FORWARD CARGO BAY NR 4 FLOORBOARD PUNCTURED AND CORRODED. REPLACED FLOOR PANEL PER SRM 51-10-4. (M)SDR GTIA030027Floor Panel · delaminatedFTW - FOUND FLOOR PANEL STATION 332-370 IS DELAMINATED. FABRICATED REPLACEMENT PANEL. (M)
Back to JASC 5321