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 SWIA200211429Floor Panel · crackedELECTRICAL BAY FLOOR FS 193.00 RT CRACKED. FOUND DURING C CHECK INSPECTION. REPAIRED DAMAGE IAW CRJ REO 601R-53-11-245 REV. ''NC''. HFEC INSPECTION C/O ON CUTOUT AS REQUIRED IAW REO 601R-53-11-245. NO CRACKS FOUND.SDR QXEA0201653Floor Panel · corrodedPDX - CORROSION AT NUTPLATE, X546 BELOW CARGO FLOOR DECK. REPAIRED IAW DHC-8 SRM 51-40-11.SDR GTIA021121Floor Panel · crackedFLIGHT COMPT, STA 120 TO STA 140.8 FLOOR PANEL HAS CRACK/ CORROSION. FABRICATED NEW FLOOR PANELS. INSTALLED NEW FLOOR PANELS.SDR GTIA021093Floor Panel · corrodedFTW - FLIGHT COMPARTMENT, FLOOR PANEL STATION 120 TO STATION 160 CENTER SOFT/MUSHY CORROSION. FABRICATED NEW FLOORBOARD. INSTALLED NEW FLOORBOARD. (M)SDR GTIA021091Floorboard · corrodedFTW - FOUND FLOORBOARD RIGHT OUTBOARD STATION 196 TO 256 SOFT/MUSHY CORROSION. FABRICATED FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021090Floorboard · damagedFTW - FOUND FLOORBOARD LEFT INBOARD STATION 160 TO 196 CRACKED/DAMAGED AND CORRODED. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021089Floorboard · damagedFTW - FOUND FLOORBOARD LEFT INBOARD STATION 160 TO STATION 196 SOFT/MUSHY CORRODED. FABRICATED FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021088Floorboard · damagedFTW - FOUND FLOORBOARD RIGHT INBOARD STATION 160 TO STATION 180 SOFT/DAMAGED. FABRICATED FLOORBOARD PANEL. INSTALLED FLOORBOARD PANEL. (M)SDR GTIA021087Floorboard · crackedFTW - FOUND FLOORBOARD RT INBOARD STATION 180-200 CRACKED/DAMAGED/CORRODED. FABRICATED FLOOR BOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021086Floor Panel · crackedFTW - FLIGHT COMPARTMENT, COPILOT SIDE STATION 148, FLOOR PANEL IS CRACKED/DAMAGED AT CORNERS, 2 EACH PLATE ATTACH PANEL IS CORRODED. FABRICATED NEW PANEL. INSTALLED NEW PANEL. (M)SDR GTIA021120Floorboard · delaminatedLT AFT LAV ASSY, SEVERAL AREA OF DELAMINATED AND DAMAGED FLOORBOARD SUPPORT LAV ASSY. FABBED NEW LAV FLOOR BOARD, INSTALLED NEW LAV FLOORBOARD.SDR GTIA021046Floorboard · crackedFLOORBOARDS, STA 160 TO STA 190 RIGHT CENTER PANEL IS CRACKED AND DELAMINATED, CORRODED. FABRICATED NEW FLOORBOARD, INSTALLED NEW FLOORBOARD.SDR GTIA021227Floorboard · damagedFTW - FORWARD LAVATORY EQUIPMENT DAMAGED AT FLOORBOARD SUPPORT. REMOVED DAMAGED FLOORBOARD FORWARD LAVATORY. FABRICATED NEW FLOORBOARD FORWARD LAVATORY. INSTALLED NEW FLOORBOARD FORWARD LAVATORY. (M)SDR GTIA021085Floorboard · damagedFTW - FOUND PASSENGER CABIN, FLOOR PANEL STATION 200-256, SOFT/MUSHY DAMAGED. FABRICATED PASSENGER CABIN FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021084Floorboard · damagedFTW - PASSENGER CABIN FLOOR PANEL STATION 160 TO STATION 190 GOUGES, SOFT DAMAGE. FABRICATED FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021097Floor Panel · damagedFTW - FOUND PASSENGER CABIN CENTER FLOOR PANEL FS 200 IS CAVED IN AND DELAMINATED. REMOVED FLOORBOARD. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021300Floor Panel · crackedFLOOR PANEL, RT SIDE, UNDER RUDDER PEDAL, CRACKED IN RIBS. REMOVED RT AND LT INBOARD RIBS, FROM FLOOR PANEL STA 84-107. FABRICATED RIBS FOR FLOOR PANEL. UPON FURTHER INVESTIGATION FOUND FLOOR PANEL WEB MATERIAL CRACKED. FABRICATED DOUBLER. FABRICATED FILLSDR GTIA021179Floor Panel · crackedFTW - FOUND FLOOR PANEL RIGHT SIDE UNDER RUDDER PEDAL CRACKED IN RIBS. REMOVED RIGHT AND LEFT INBOARD RIBS FROM FLOOR PANEL. FABRICATED RIBS. FOND FLOOR PANEL WEB MATERIAL CRACKED. FABRICATED DOUBLER. FABRICATED FILLER. INSTALLED DOUBLER AND FILLER. INSSDR GTIA021010Floorboard · damagedFTW - FOUND FLOORBOARD, STATION 541 TO STATION 579 LBL 22 TO RBL 22 INCHES HAS SOFT/MUSHY AND GOUGED ALONG PANEL. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021009Floorboard · corrodedFTW - FOUND FLOORBOARD STATION 160, 9 INCH BY 12 INCHES, HAS MUSHEY/CORROSION. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021008Floorboard · crackedFTW - FOUND FLOORBOARD RIGHT STATION 905, 21 INCH BY 41 INCH, HAS CRACKED/DAMAGED AT FORWARD BOTTOM PANEL. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021007Floorboard · corrodedFTW - FOUND FLOORBOARD STATION 256 TO STATION 313 RBL 22 TO RBL 44 INCHES HAS CRACKED/CORRODED A BOTTOM FLOOR BOARD. FABRICATED NEW FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021006Floorboard · crackedFLOORBOARD STATION 313 TO STATION 339 RBL 22 TO RBL 44 INCHES HAS CRACKED/DAMAGED AND GOUGED ALONG THE PANEL. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021013Floorboard · corrodedFTW - FOUND STATION 862-912 FLOOR BOARD HAS DAMAGED/SOFT AND CORROSION AT INSERTS. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021012Floorboard · corrodedFTW - FOUND FORWARD FLOOR BOARD STATION 200-237 HAS DAMAGED AND CORRODED AT INSERTS, PANEL GOUGED ENTIRE LENGTH OF SURFACE. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR AT0200080Floorboard · damagedTEMPORARY REPAIR OF FORWARD CARGO PIT FLOORBOARD STA 218 TO 331, REQUIRES FAB OF NEW FLOORBOARD. INSTALLED NEW FLOOR BOARD IAW 17-2558-A1529 REV IR AND RES NR 02-0824.SDR AT0200079Floorboard · damagedTEMPORARY REPAIR OF FORWARD CARGO PIT FLOORBOARD STA 369 TO 426, FLOORBOARD REQUIRES FAB OF NEW BOARD. INSTALLED NEW FLOOR BOARD IAW EO 17-2558-A1530, REV IR AND RES 02-0824.SDR AT0200078Floorboard · puncturedFORWARD CARGO PIT, FLOORBOARD STA 465 TO 541 HAS SEVERAL PUNCTURES. INSTALLED NEW FLOOR BOARD AT FORWARD CARGO PIT IAW B-717 SRM 25-58-01, AND AS PER EA NR 17-2558-A1521 REV IR AND RES NR 02-0824.SDR GTIA021021Floorboard · damagedFTW - FOUND CABIN FLOOR BOARD, STATION 256 TO 313, RBL 22 TORN, ELONGATED HOLE AND MISSING INSERTS. FABRICATED NEW PANEL. INSTALLED PANEL. (M)SDR GTIA021015Floor Panel · brokenFTW - FLIGHT COMPARTMENT FLOOR PANEL BROKEN AROUND EDGES. FABRICATED FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021014Floor Panel · brokenFTW - FOUND CENTER FLIGHT COMPARTMENT FLOOR PANEL BROKEN AROUND EDGES. FABRICATED CENTER FLIGHT COMPARTMENT FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021001Floor Panel · crackedFTW - FOUND FLO'S FLOOR PANEL IS CRACKED UPPER AND LOWER SIDES. STOPPED DRILLED CRACK. FABRICATED REPAIR DOUBLER. INSTALLED REPAIR DOUBLER. (M)SDR GTIA021020Floor Panel · damagedFTW - FOUND FLOOR PANEL CENTER BETWEEN AFT LAVATORY HAS SOFT/DAMAGED. FABRICATED A NEW FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021019Floor Panel · damagedFTW - FOUND PASSENGER CABIN, STATION 769 CENTER, 38 INCH BY 42 INCHES HAS SOFT/MUSHY. FABRICATED FLOOR PANEL. INSTALLED FLOOR PANEL. (M)SDR GTIA021018Floorboard · crackedFTW - FOUND PASSENGER CABIN STATION 160 TO 180 FLOOR BOARD HAS CRACK/DAMAGED. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021017Floorboard · crackedFTW - FOUND PASSENGER CABIN STATION 826 TO 988 HAS CRACKED/DAMAGED. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021016Floorboard · damagedFTW - FOUND FLOOR BOARD, RIGHT OVER FUEL TANK ACCESS PANEL, 21 INCH BY 22 INCH, IS CRACKED/DAMAGED AT CORNERS. FABRICATED NEW FLOOR BOARD. INSTALLED FLOOR BOARD. (M)SDR GTIA021000Floorboard · crackedFTW - FOUND FORWARD LAVATORY ASSEMBLY, FLOORBOARD ASSEMBLY LAV HAS CRACKED/DAMAGED. REMOVED FLOORBOARD. FABRICATED NEW FLOORBOARD. INSTALLED FLOORBOARD. (M)SDR GTIA021053Floor Panel · delaminatedPAX CABIN STA 200 TO STA 256 FLOOR PANEL HAS DELAMINATED AT THE HAT SECTION. REPAIRED PAX CABIN FLOOR PANEL.SDR GTIA020976Floorboard · deterioratedFLOOR BOARDS VERY SPONGY AT FORWARD ENTRY AREA STA 160-200, BL 0-LBL 46. FLOORBOARDS TO BE REMOVED AND REINSTALLED ON, FABBED FLOOR BOARDS.SDR C2XA02TY130Gusset · corrodedTYS DURING A SCHEDULED 2-C INSPECTION MAINTENANCE FOUND THE GALLEY GUSSET CORRODED. MAINTENANCE R/R NEW GUSSET IAW EMB 135/145 SRM 51-40-02. COUNTERSUNK HOLES IAW EMB 135/145 SRM 51-40-06,PAINTED TOP GUSSET IAW CPM 51-21-06. ALL WORK WAS ACCOMPLISHED AND WIL SDR MWEA020538Floorboard · corrodedFLOORBOARD ATTACH FASTENERS HOLES ARE LIGHTLY CORRODED ON J-CHANNEL BETWEEN STATIONS 160 AND 200 FORWARD OF SEAT TRACK 4. REMOVED CORROSION AND INSTALLED FLOOR SUPPORT.SDR MALA020545Floorboard · corrodedDURING 4K-INSPECTION IN CWA, RT O/B FLOORBOARD FLANGE HAS CORROSION AFT OF STA 288. MAINTENANCE REMOVED CORROSION IAW SRM 51-70-40.SDR AT0200073Floor Panel · corrodedHEAVY CORRODED FLOOR PANEL STA 230 TO 305, RBL 44 TO RBL 56. REMOVED AND REPLACED SKIN ON FLOOR PANEL IAW DC-9 SRM 51-30-2.SDR MALA020484Floorboard · corrodedDURING 4K/2Y/4Y INSPECTION IN CWA, FLOOR BOARD WEB STA 288 HAS SEVERAL RIVETS, CORRODED AND CORROSION FWD OF SEAT 1A, C/D. MAINTENANCE REMOVED AND REPLACED STA 288 WEB IAW SRM 51-00-00.SDR AAL2002F00013Floorboard · scratchedMETAL FLOOR MEMBRANE, 2 INCH SCRATCH IN FLOOR, STA 212 INBOARD OF NR 5 SCAT TRACK UNDER CENTER FLOORBOARD, FC 10. INSTALLED CUTOUT DAMAGED DOUBLER. (2002-1245 , AMC4)SDR AAL2002F00012Floorboard · damagedMETAL FLOOR MEMBRANE, HOLE IN METAL FLOOR, STA 05, INBOARD OF NR 3 SEAT TRACK UNDER CENTER FLOORBOARD FC 10. C/A: CUTOUT DAMAGE- INSTALLED DOUBLER IAW AARD. (2002-1244, AMC4)SDR LR7A02074Floor Panel · crackedDURING SCHEDULED C4 INSPECTION PER JOB CARD HSP53161 FOUND FS 796 TO 809 RAMP LH AND RH FLOOR PANELS WITH CRACKED HAT SECTIONS, LBL 60 AND RBL 60, WL 146.REPLACED FLOOR PANELS IAW SRM SMP 583 51-10 PG 4, 51-60 AND 51-70. NR 2183.SDR LR7A02069Floor Panel · warpedDURING SCHEDULED C4 INSPECTION PER JOB CARD HC05297 FOUND FS 588 TO 657 & 737E TO 817E 3 EA. CENTER FLOOR PANELS WARPED, RBL 20 TO LBL 20, WL 146.REPLACED FLOOR PANELS IAW SRM SMP 583 53-40-05 AND 51-60. NR 2037.SDR LR7A02068Floor Panel · warpedDURING SCHEDULED C4 INSPECTION PER JOB CARD HC05297 FOUND FS 245 TO 588 CENTER FLOOR PANELS WARPED, RBL 20 TO LBL 20, WL 146.REPLACED FLOOR PANELS IAW SRM SMP 583 53-40-05 AND 51-60. NR 2036.
Back to JASC 5321