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 ASAA0280484Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD INSERTS CORRODED AT FS 148. REPLACED INSERTS PER SRM 53-05. (M)SDR ASAA0280485Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, COCKPIT FLOORBOARD DELAMINATED AT AFT CORNER AND 3 INSERTS ARE CORRODED AT FS 148, BL 0. REPLACED FLOORBOARD AND INSERTS PER SRM 53-05. (M)SDR ASAA0280486Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 617-693, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280487Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DELAMINATED AT FS 579-617, LBL 22 - RBL 22. REPLACED FLOORBOARD WITH FIBERGLASS OVERLAY PER MM 25-00-00, SEC 3E. (M)SDR ASAA0280488Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD INSERTS CORRODED AT FS 1250-1307. REPLACED 5 FLOORBOARD INSERTS SRM 53-05. (M)SDR ASAA0280489Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDING AT FS 200-256, RBL 44-54. REPLACED FLOORBOARD WITH FIBERGLASS OVERLAY PER MM 25-00-00, SEC 3E. (M)SDR ASAA0280492Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 200-256, LBL 14 - RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280493Floorboard · tornOKC - DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 1079-1117, LEFT BUTTOCK LINE 22, RIGHT BUTTOCK LINE 22 TORN. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280495Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, RIGHT BUTTOCK LINE 44, RIGHT BUTTOCK LINE 54 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280496Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, LEFT BUTTOCK LINE 8, LEFT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280497Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, LEFT BUTTOCK LINE 8, RIGHT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280498Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 160-256, LEFT BUTTOCK LINE 22, LEFT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280499Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 200-256, LEFT BUTTOCK LINE 22, RIGHT BUTTOCK LINE 22 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280501Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 1307-1361, LEFT BUTTOCK LINE 18 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280502Floorboard · corrodedOKC - DURING SCHEDULED 30K-CHECK, FLOORBOARD AT BS 1117-1174, LEFT BUTTOCK LINE 6, LEFT BUTTOCK LINE 22 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280503Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD AT STATION 1156-1250 LBL 22 TO LBL 44 HAS 29 CORRODED INSERTS. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0280504Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD AT STATION 200-256 RBL 22 TO RBL 44 HAS 18 CORRODED INSERTS. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0280466Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 465-541, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280467Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 541-617, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280468Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 693-769, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280469Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 693-769, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280470Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 807-826, LBL 22 - RBL 22. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280471Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 889-927, RBL 22 - RBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280472Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 927-1003, LBL 22 - LBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280473Floorboard · puncturedOKC - FOUND DURING 30K CHECK, FLOORBOARD PUNCTURED AT FS 1250-1307, LBL 22 - LBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280476Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS CORRODED INSERTS AT FS 160-200, RBL 8 TO LBL 8. REPLACED INSERTS PER SRM 53-05. (M)SDR ASAA0280477Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, FLIGHT DECK FLOOR PANEL LOWER SURFACE IS SEPARATING FROM CORE AT FS 148.55, RBL 31-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280478Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DELAMINATING AT FS 541-579, LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR 02FDEA00783Floor Panel · crackedAVIONICS COMPARTMENT, ABOVE MAIN AVIONICS RACK STATION 401 FOUND A MACHINED FLOOR PANEL LOWER FITTING CRACKED APPROXIMATELY 3.0 INCHES. REMOVED AND REPLACED PANEL IAW SRM.SDR ASAA0280462Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 313-389, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280463Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 313-389, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280464Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 398-446, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280465Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 465-541, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR GTIA021173Floor Panel · crackedFTW - FOUND PASSENGER CABIN FLOOR PANEL STATION 1117 TO STATION 1080 IS CRACKED/DAMAGED. FABRICATED NEW CABIN FLOOR PANEL. (M)SDR LR7A02105Strap · corrodedDURING SCHEDULED C4 INSPECTION PER HST5325 FOUND CREW ENTRANCE FLOOR STRAP CORRODED. FS228, LBL59, WL146.REPLACED STRAP IAW SRM SMP 583-51-70. NR0287.SDR LR7A02102Intercostal · corrodedDURING SCHEDULED C4 INSPECTION PER HST5325 FOUND FLIGHT DECK FLOOR ANGLE CORRODED. FS188-196, BL0, WL200.REPLACED INTERCOSTAL ANGLE IAW SRM SMP 583-51-70. NR0266.SDR LR7A02101Intercostal · corrodedDURING SCHEDULED C4 INSPECTION PER HST5325 FOUND FLIGHT DECK LH FWD CIRCUIT BREAKER PANEL FLOOR ANGLE CORRODED. FS148-160, LBL50, WL200.REPLACED ANGLE IAW SRM SMP 583-51-70. NR0265.SDR GTIA021197Floor Panel · crackedFTW - PAX CABIN RIGHT WEB FLOOR PANEL STATION 200-256 IS CRACKED/DAMAGE AT HATS SECTION, BOTH SIDE. REPAIRED DAMAGED AREAS. (M)SDR GTIA021178Floorboard · crackedPASSENGER CABIN FLOOR BOARD STATION 160 TO 172 FRONT R1 DOOR, HAS CRACKED/SOFT CORRODED AT INSERTS. FABRICATED, LOCATED AND DRILLED HOLES ON PANEL. (M)SDR GTIA021177Floor Panel · damagedFTW - FOUND PASSENGER CABIN FLOOR PANEL STATION 196 TO STATION 256 HAS SOFT/MUSHY AND CORRODED AT INSERTS. FABRICATED NEW PANEL. (M)SDR GTIA021176Floorboard · crackedFTW - FOUND PASSENGER CABIN FLOORBOARD STATION 160 TO STATION 200 RIGHT SIDE FRONT R1 DOOR HAS CRACKED/DAMAGED AROUND THE EDGE. FABRICATED FLOORBOARD. (M)SDR GTIA021175Floorboard · crackedFTW - FOUND PASSENGER CABIN FLOORBOARD STATION 200 TO STATION 256 CENTER AREA SEVERAL CRACKED/DAMAGED AT INSERTS. FABRICATED NEW FLOOR PANEL. (M)SDR GTIA021174Floorboard · damagedFTW - PASSENGER CABIN FLOORBOARD STATION 160 TO 200 LEFT SIDE (12X40) FRONT L1 DOOR, HAS SOFT/MUSHY AND CORRODED AT INSERTS 22. FABRICATED PASSENGER CABIN FLOORBOARD. (M)SDR F3LA200200371Floor Panel · corrodedDURING C 2 CHECK, THE AFT CARGO COMPARTMENT FLOOR TRANSITION PANEL WAS FOUND CORRODED BETWEEN STA 787 AND STA 807. AFT CARGO COMPARTMENT FLOOR TRANSITION PANEL WAS REMOVED AND REPLACED BETWEEN STA 727 AND 947, LBL 20 IAW SRM 53-60-53 AND SRM 51-40-02.SDR SWIA200211519Floor Panel · crackedELECTRICAL BAY FLOOR FS 193.0 RIGHT AND LEFT SIDES CRACKED. FOUND DURING C CHECK INSPECTION. HFEC INSPECTION CARRIED OUT ON CUTOUT REPAIR EDGE AND AREA AS REQUIRED IAW REO 601R-53-11-245. NO CRACKS FOUND. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-245 SDR GTIA021136Floor Panel · damagedCABIN FLOOR PANEL HAS EXPOSED INTERNAL HONEYCOMB STRUCTURE. FS 1249, LBL 35. REPAIRED DAMAGED AREA IN CABIN FLOOR PANEL.SDR GTIA021139Floor Panel · corrodedFLOOR PANEL STA 256-294 LBL 44-54 HAS CORROSION UNDER RUB STRIP. FABRICATED FLOOR PANEL.SDR GTIA021070Floor Panel · cracked6 TO 8 INCH CRACK IN FLOOR WEBBING STA 807, RT SIDE. REPLACED FLOOR WEBBING.SDR GTIA021069Floor Panel · crackedTHE 04BD RT FLOOR PANEL AT ROWS 12 THROUGH 15 HAS CRACK. REPAIRED FLOOR PANEL (CLOSED 10/15/02).SDR 2002F01010Floor Panel · cracked(ORIGINAL CLOSED) AFT CARGO BAY FLOOR PANEL 140CF DENTED / CRACKED. REPAIRED DENT/CRACK IAW SRM 51-70-13-2-1
Back to JASC 5321