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 GTIA020549Floor Panel · damagedFTW - FOUND FLOOR BROKEN AND DELAMINATED, PLUS X8 UP TO PLUS X45 BETWEEN STATION 160 AND STATION 200. FORMED NEW PANEL. (M)SDR GTIA020532Floorboard · damagedFTW - FOUND FLOORBOARD AT STATION 160-200 PLUS X6 TO -X6. FABRICATED NEW PASSENGER CABIN FLOOR PANEL STATION 160-200. (M)SDR DLM88020553Floor Panel · cracked99525-71, -76 FLOOR PANELS WERE FOUND DISBONDED AND CRACKED. REPAIR PER ER/A 417223-14.SDR F3LA200200149Panel · corrodedDURING C-2 CHECK, INSPECTION REPORTED SURFACE CORROSION ON RT TRANSITION PANEL, STA 767 TO 794.5. FABRICATED AND INSTALLED REPLACEMENT PANEL PER SRM 53-60-15 AND 51-40-02.SDR AALA20020692Floorboard · corrodedFLOORBOARD ATTACH FASTENERS AND INSERTS CORRODED, FLOORBOARD OUTBOARD FO RIGHT SEAT TRACK STA 148 (FORWARD OF FORWARD GALLEY). COMPLETED INSTALLATION OF STRAP AND FILLER.SDR AALA20020676Floorboard · corrodedFLOORBOARD BETWEEN FOS SEAT TRACKS CORRODED STA 148, RBL 20 INCHES, TO RBL 29 INCHES. NEW FLOORBOARD INSTALLED ES84186122.SDR HEEA078873Floor Panel · corrodedCARGO FLOOR PANEL SEPARATED/CORRODED.SDR DLM88020554Floor Panel · crackedFLOOR PANELS WERE FOUND DELAMINATED AND CRACKED. REPAIR PER ER/A 411194-14.SDR AALA20020680Floorboard · corrodedCORROSION ON FLOORBOARD UNDER FLO SEAT AND SEAT TRACK. INSTALLED DOUBLER REPAIRS AT STA 120 STA 148.SDR MWEA020274Floorboard · dentedFLOORBOARD D4 IS DENTED ABOUT 8 INCHES FORWARD OF THE AFT END. FABRICATED AND INSTALLED FLOORBOARD.SDR MWEA020273Floorboard · gougedFLOORBOARD BETWEEN SEAT TRACKS NR 3 AND 4 HAS SEVERAL GOUGES BETWEEN STATION 1145 TO 1260. FABRICATED AND INSTALLED FLOORBOARD.SDR GTIA020494Floor Panel · brokenFTW - FOUND RIGHT COCKPIT FLOOR PANEL CRACKED AND BROKEN FORWARD CLOSEOUT. REPAIRED COCKPIT FLOOR PANEL USING 181 CLOTH. (M)SDR GTIA020445Stiffener · crackedFTW - FOUND CABIN FLOORBOARD STATION 1155-1250 X46 TO X56 STIFFENER CHANNEL CRACKING, REPAIR DEBONDING, PHENOLIC BACKSTRIPS BROKEN AND FASTENER HOLE ENLARGED. REPAIRED CABIN FLOOR PANEL STATION 1155-1250. (M)SDR CALA0200213Floor Panel · splitINSPECTION FOUND CHANNEL ON BACK OF MAIN CABIN DECK FLOOR PANEL AT FS 218-256, RBL 44-58, COMING LOOSE AND PANEL WAS SPLITTING AT THE END. THE PANEL AND CHANNEL WERE REPAIRED IAW SRM 51-70-2 AND 51-20-1.SDR GTIA020421Floorboard · brokenFTW - AT CARGO FLOORBOARD STATION 1212-1231 BROKEN 2 PLACES AND HAS CORROSION. FORMED NEW PANEL. (M)SDR GTIA020420Floorboard · corrodedFTW - FOUND AFT CARGO FLOORBOARD STATION 1155-1212 HAS CORROSION AND BAD INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020436Floorboard · corrodedFTW - FOUND LEFT FLOORBOARD BETWEEN INBOARD SEAT TRACK X22 AND OUTBOARD SEAT TRACK X44 AT STATION Y257 CORRODED. REMOVED FLOORBOARD. FABRICATED A NEW PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA020526Floorboard · crackedFTW - PASSENGER CABIN, AFT FUSELAGE AREA FLOORBOARD X 45L FROM STATION Y 1115 TO STA Y 1256 CORNER CRACKED, INSERTS MISSING AND BROKEN. FORM NEW PANEL. (M)SDR GTIA020327Floorboard · crackedFTW - PASSENGER CABIN, AFT FUSELAGE AREA FLOORBOARD FROM STATION 1115-1236 CORNER CRACKED, INSERTS MISSING AND BROKEN. FORM NEW PANEL. (M)SDR MWEA020210Panel · damagedREMOVED CABIN FLOOR PANEL B-5 TO FACILITATE OTHER MAINTENANCE. -- FORWARD END OF PANEL IS DAMAGED. FABRICATED NEW SKIN AND REINSTALLED CABIN FLOOR PANEL.SDR CALA0200173Floor Panel · corrodedINSPECTION FOUND FLOOR PANEL CORRODED AT STA 180, LBL 10 - RBL 55. THE CORRODED DOUBLER WAS REMOVED FROM THE WEB AND A REPAIR DOUBLER WAS INSTALLED.SDR CALA0200171Floor Panel · crackedINSPECTION FOUND 1 INCH CRACKS AT FLOOR PANEL INSERTS, FS 1003. THE FLOOR PANEL WAS REPAIRED.SDR GTIA020309Floor Panel · crackedFTW - FLIGHT AND FORWARD PASSENGER COMPARTMENT FLOOR PANEL RIGHT STATION 148.5 TO STATION 167.5 HAS CRACKED/DAMAGE MUSHY. FABRICATED NEW PANEL. (M)SDR UPS02838058Floorboard · damagedINSPECTION TYPE:C1 FLOORBOARD STA 340-460 POS 7 SOFT SPOT. FABRICATED FLOOR PANEL IAW UPS EO DC8-5320-9691C.SDR UPS02838057Floor Panel · damagedINSPECTION TYPE:C1 CABIN FLOORBOARD STA 1480-1580 POS NR 7 HAS SOFT SPOT. FABRICATED FLOOR PANEL IAW UPS EO DC8-5320-9691C.SDR GTIA020525Floor Panel · crackedFTW - FLIGHT AND FORWARD PASSENGER COMPARTMENT FLOOR PANEL RIGHT OUTBOARD STATION 148.5 TO STATION 167.5 HAS CRACKED MUSHY RACK 8. FORM NEW PANEL FOR STATION 148.5 TO 167.5. (M)SDR GTIA020349Floorboard · damagedFTW - FOUND INTERNAL ACCESS PANEL CENTER COCKPIT (FLT COMPT) STATION 120 HAS MUSHY SOFT DAMAGE. FABRICATED NEW FLOORBOARD. (M)SDR GTIA020348Floor Panel · damagedFTW - PASSENGER COMPARTMENT FLOOR PANEL (CENTER) STATION 1271 TO STATION 1309, HAS MUSHEY SOFT. FABRICATED NEW FLOORBOARD CENTER STATION 1271-1309. (M)SDR GTIA020347Floor Panel · damagedFTW - FOUND FORWARD FLIGHT COMPARTMENT FLOOR PANEL STATION 120.050 TO STATION 160 HAS MUSHY SOFT, RIGHT SIDE. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020315Floor Panel · crackedFTW - FOUND FLIGHT AND FORWARD PASSENGER COMPARTMENT FLOOR PANEL LEFT STATION 148.5 TO STATION 167.5 HAS CRACKED/MISSING INSERT. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020491Floor Panel · delaminatedFTW - FOUND PASSENGER COMPARTMENT FLOOR PANEL (MEMBRANE PHENOLIC) RIGHT OUTBOARD STATION 1271 TO STATION 1309 HAD DELAMINATED. REPAIRED COMPARTMENT FLOOR PANEL. (M)SDR GTIA020307Floor Panel · crackedFTW - FOUND FLOOR PANEL STATION 598-636 IS CRACKED/DAMAGE MID PIT. FORM NEW PANEL. (M)SDR GTIA020308Floor Panel · crackedFTW - FLIGHT COMPT FLOOR PANEL UNDER CAPTS SEAT HAS CRACKED/DAMAGE. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020311Floor Panel · crackedFTW - FLIGHT AND FORWARD PASSENGER COMPARTMENT FLOOR PANEL RIGHT OUTBOARD STATION 148.5 TO STATION 167.5 HAS CRACKED MUSHY (SOFT). FORM NEW PANEL FOR STATION 148.5-167.5. (M)SDR GTIA020312Floor Panel · crackedFTW - PASSENGER COMPARTMENT FLOOR PANEL LEFT INBOARD STATION 1271-1309 HAS CRACKED MUSHY SOFT. FABRICATED REPAIR FLOORBOARD. (M)SDR GTIA020313Floor Panel · crackedFTW - PASSENGER COMPARTMENT FLOOR PANEL AT STATION 1271-1309 HAS CRACKED/DAMAGE. FABRICATED NEW PANEL. (M)SDR GTIA020314Floor Panel · crackedFTW - FLIGHT AND FORWARD PASSENGER COMPARTMENT FLOOR PANEL STATION 148.5-167.5 HAS CRACKED/DAMAGE. (M)SDR GTIA020350Floor Panel · damagedFTW - FOUND FLOOR PANEL STATION 946-1003 CENTER MUSHY SOFT AND HAS BLUE WATER STAINS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA020328Floorboard · brokenFTW - FOUND COCKPIT FLOORBOARD NR 4415C CRACKED AND BROKEN OUT ALONG EDGE AND LIGHT SURFACE CORROSION ON BACK. FABRICATED A REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA020323Floor Panel · crackedFTW - FOUND FLOOR PANEL STATION 886-946 CENTER HAS CRACK AT FLANGE SUPPORT PANEL DELAMINATED. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA020322Floor Panel · crackedFTW - FOUND FLOOR PANEL INBOARD RIGHT STATION 886-927 HAS PUNCTURE/CRACKED. FABRICATED REPAIR FLOOR BOARD. (M)SDR GTIA020321Floor Panel · crackedFTW - FOUND FLOOR PANEL INBOARD STATION 826-869 CRACKED/DAMAGED. FABRICATED NEW PANEL. (M)SDR GTIA020320Floor Panel · crackedFTW - FOUND FLOOR PANEL LEFT STATION 769-826 CRACKED/DAMAGE. FORM NEW PANEL. (M)SDR GTIA020319Floor Panel · crackedFTW - FOUND FLOOR PANEL INBOARD RIGHT STATION 796-826 CRACKED/DAMAGE. FORM NEW PANEL. (M)SDR GTIA020318Floor Panel · delaminatedFTW - FOUND FLOOR PANEL RIGHT INBOARD STATION 927-1002 DELAMINATED/DAMAGE. FABRICATED REPAIR FLOORBOARD. (M)SDR GTIA020317Floor Panel · crackedFTW - FOUND FLOOR PANEL INBOARD LEFT STATION 886-927 CRACKED/DAMAGED. FABRICATED REPAIR FLOORBOARD. (M)SDR GTIA020316Floor Panel · crackedFTW - FOUND FLOOR PANEL AFT CABIN FRONT AFT ENTRY DOOR SEVERAL CRACKED, BLUE WATER STAINS, ELONGATED HOLES. FABRICATED NEW PANEL. (M)SDR GTIA020492Floor Panel · delaminatedFTW - FOUND FLOOR PANEL STATION 864 TO STATION 886 LEFT SIDE HAS DAMAGE/DELAMINATED. FABRICATED REPAIR FLOORBOARD. (M)SDR GTIA020374Floor Panel · crackedFTW - FOUND FLOOR PANEL LEFT INBOARD STATION 927-1003 HAS CORROSION UNDER PANEL AND CRACKED. FABRICATED NEW FLOORBOARD. (M)SDR GTIA020373Floor Panel · crackedFTW - FOUND FLOOR PANEL LEFT STATION 826-864 CORRODED, BLUE WATER STAINS, CRACKED. FABRICATED FLOORBOARD REPAIR. (M)
Back to JASC 5321