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 06FDEA2944Floor Panel · damagedSNRM N00657: COCKPIT: FLOOR PANEL NR 215AF FOUND WITH PUNCH MARK.SDR 06FDEA2943Floor Panel · damagedSNRM N00656: COCKPIT: FLOOR PANEL NR 215DF FOUND DAMAGED.SDR 06FDEA2942Floor Panel · damagedCOCKPIT: FLOOR PANEL NR 215BF FOUND DAMAGED.SDR ASAA0680852Floor Panel · delaminatedFOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680851Floor Panel · damagedCABIN FLOOR PANEL CORE DAMAGED. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680850Floor Panel · damagedFOUND CABIN FLOOR PANEL CORE DAMAGED AT INSERT HOLES. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680849Floor Panel · delaminatedFOUND CABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680848Floor Panel · delaminatedCABIN FLOOR PANEL DELAMINATED. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680847Floor Panel · delaminatedCABIN FLOOR PANEL DELAMINATED AND HAS CORRODED INSERTS. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR ASAA0680846Floor Panel · damagedFOUND CABIN FLOOR PANEL CORE DAMAGED AT INSERTS. REPLACED PANEL PER SRM 53 05.SDR ASAA0680845Floor Panel · damagedCABIN FLOOR PANEL DAMAGED AT INSERT HOLES. REPLACED FLOOR PANEL PER SRM 53 05 AND DWG S4932106.SDR LR7A06094Floor Panel · warpedDURING SCHEDULED C 2 CHECK PER JOB CARD HC5211, FOUND CENTER RAMP FLOOR PANEL WARPED AT RS 0 TO RS 10. REPLACED PANEL IAW SMP583 CHAP 51-70 AND 51-60.SDR USAA061017Floor Panel · delaminatedFLOOR PANEL, CABIN 262EF DELAMINATION. FABRICATED NEW PANEL PER MCG IRM 9701, RGUF, DEFECT SIZE: 2 X 2 INCHES.SDR AMTA200600502Floor Panel · corrodedFWD CARGO FLOOR PANEL 120DF HAS CORROSION NUMEROUS AREAS ON UPPER SURFACE. (K)SDR AWXA200601463Floor Panel · debondedSAL - DEBONDED DOUBLER WAS FOUND ON FLOOR PANEL NR 132 DG IN FWD CARGO COMPARTMENT. FLOOR PANEL NR 132 DG IN FWD CARGO COMPARTMENT WAS REPLACED IAW IRM 9701 REV F AND DOUBLER WAS BONDED IAW AWA CARD M2M 53301 REV 8.SDR AMTA200600472Floor Panel · corrodedAFT CARGO FLOOR PANEL 140CF HAS CORROSION ON UPPER SURFACE 1 AREA. FABRICATED NEW FLOOR PANEL IAW SRM, TREATED AND PRIMED IAW SRM. (K)SDR AMTA200600471Floor Panel · corrodedAFT CARGO FLOOR PANEL 140DF HAS CORRISION SEVERAL AREAS ON UPPER SURFACE. FABRICATED FLOOR PANEL IAW TREATED PRIMED IAW SRM. (K)SDR AMTA200600470Floor Panel · corrodedFWD CARGO FLOOR PANEL 120AF HAS CORROSION NUMEROUS AREAS ON UPPER SURFACE. FABRICATED FLOOR PANEL IAW SRM, TREATED AND PRIMED PANEL IAW SRM. (K)SDR AMTA200600467Floor Panel · corrodedFWD CARGO COMPARTMENT FLOOR PANEL 120CF CORROSION, AREA APPROX 22 INCHES X 9 INCHES. FABRICATED FLOOR PANEL AND TREATED AND PRIMED IAW SRM. (K)SDR AMTA200600466Floor Panel · corrodedFWD CARGO COMPARTMENT FLOOR PANEL 120BF HAS CORROSION AREA APPROX 36 INCHES X 12 INCHES. FABRICATED NEW FLOOR PANEL. (K)SDR AWXA200601447Floor Panel · delaminatedSAL - DELAMINATION WAS FOUND ON FLOOR PANEL NR 151 ZG IN AFT CARGO COMPARTMENT. FLOOR PANEL NR 151 ZG WAS REPLACED IAW SRM 53-02-00 TABLE 105 ZONE "C" PARA 8G, 8H AND IRM 9701 REV F.SDR AWXA200601483Floor Panel · corrodedSAL - FOUND CORROSION ON FLOOR PANEL 261 FF, IN AFT CABIN AT FRAME 66 TO FS 68 R. THE FLOOR PANEL WAS REPLACED AND INSTALLED WITH AWA CARD CID25318.SDR AWXA200601482Floor Panel · corrodedSAL - FOUND CORROSION ON FLOOR PANEL NR 262 FF IN AFT CABIN AT FS 66 TO FS 68L. THE FLOOR PANEL WAS REPLACED AND INSTALLED WITH AWA CARD CID25318.SDR AWXA200601478Floor Panel · corrodedCHECK NR BC-4. NR 5953533. CORROSION ON FLOOR PANEL AT RT DOOR IN PASSENGER CABIN BETWEEN FR66 TO FR68. FLOOR PANEL NR 262 FF BETWEEN FR 66 TO FR 68, WAS REPLACED.SDR AWXA200601477Floor Panel · corrodedCHECK NR BC-4. NR 5953532. CORROSION ON FLOOR PANEL AT LT DOOR IN PASSENGER CABIN BETWEEN FR 66 TO FR 68. FLOOR PANEL NO. 261 FF BETWEEN FR 66 TO FR 68, WAS REPLACED.SDR AWXA200601462Floor Panel · delaminatedSAL - DELAMINATION WAS FOUND ON FLOOR PANEL NR 151 PE IN AFT CARGO COMPARTMENT. FLOOR PANEL NR 151 PE WAS REPLACED IAW IRM 9701 REV F AND SRM 53-02-00 TABLE 105.SDR AWXA200601461Floor Panel · delaminatedSAL - DELAMINATION WAS FOUND ON FLOOR PANEL NR 151 VG IN AFT CARGO COMPARTMENT. FLOOR PANEL NR 151 VG WAS REPLACED IAW SRM 53-02-00 TABLE 105 PAR 8G , 8H AND IRM 9701 REV F PAR 8 TO 10.SDR AWXA200601499Floor Panel · debondedSAL - THE FLOOR PANEL NR 151 PE IN THE AFT CARGO COMPARTMENT WAS FOUND WITH THE DOUBLER DISBONDED. THE FLOOR PANEL NR 151 PE, AND THE DOUBLER WAS FABRICATED AS PER IRM 9701 REV F, PAR 8. THE DOUBLER WAS FABRICATED IAW AWA CARD M2M53301, SRM 53-02-00 PARA 8GHSDR AWXA200601498Floor Panel · debondedSAL - THE FLOOR PANEL NR 131AF IN THE FWD CARGO COMPARTMENT WAS FOUND WITH THE DOUBLER DISBONDED. THE FLOOR PANEL NR 131 AF, AND THE DOUBLER WAS FABRICATED AS PER IRM 9701, REF F, PAR 8. THE DOUBLER WAS FABRICATED IAW AWA CARD M2M53301, SRM 53-02-00, PARA 8GSDR MWEA060187Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 617 TO 693. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060186Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 465 TO 541. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060189Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 674 TO 693. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060188Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 693 TO 769. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060185Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 389 TO 465. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060184Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 465 TO 541. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060183Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 693 TO 769. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060182Floor Panel · delaminatedMAIN CABIN FLOOR PANEL DELAMINATED AT FRAME STATIONS 313 TO 389. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060162Floor Panel · damagedFLOOR PANEL AT STATION 160-180 HAS DAMAGED CORNERS. FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA060164Floor Panel · damagedFLOOR PANEL AT STATION 108-200, HAS MISSING INSERTS AND GOUGED ON OUTER EDGE. FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA060165Floor Panel · damagedFLOOR PANEL AT STATION 160-200 HAS DAMAGE CORNERS. FABRICATED AND INSTALLED FLOOR PANEL.SDR MWEA060163Floor Panel · crackedFLOOR PANEL BETWEEN SEAT TRACKS 1 AND 2, CRACKED IN 3 PLACES AT STATION 1079 TO 1003. FABRICATED AND INSTALLED NEW FLOOR PANEL.SDR MWEA060161Floor Panel · crackedFLOOR CABIN PANEL CRACKED AT STATIONS 617 TO 655 BETWEEN SEAT TRACK 3 AND 4. FABRICATED AND INSTALLED NEW FLOOR PANELS.SDR MWEA060166Floor Panel · damagedFLOOR PANEL AT STATION 886 TO 864 HAS NUMEROUS DAMAGED AREAS. FABRICATED AND INSTALLED NEW PANELS.SDR AWXA200601435Floor Panel · crackedSAL - THE FLOOR PANEL NR 151 FF IN AFT CARGO COMPARTMENT WAS FOUND WITH CRACKS. THE FLOOR PANEL NR 151 FF IN AFT CARGO COMPARTMENT WAS REPAIRED IAW SRM 53-02-00 PAR 8C.SDR AWXA200601434Floorboard · delaminatedSAL - FOUND DAMAGE FLOORBOARD 231 WF AT PASSENGER CABIN. FLOORBOARD 231 WF WAS REPLACED IAW SRM 53-02-00 TABLE 103 ZONE "A" PAR 8G, 8H AND IRM 9701 REV F.SDR AWXA200601433Floorboard · delaminatedSAL - FOUND DAMAGE FLOORBOARD 252 MF AT PASSENGER CABIN. FLOORBOARD 252 MF WAS REPLACED IAW SRM 53-02-00 TABLE 103 ZONE "A" PAR 8G , 8H AND IRM 9701 REV F.SDR AWXA200601432Floorboard · delaminatedSAL - FOUND DAMAGE FLOORBOARD NR 242 DF AT PASSENGER CABIN. FLOORBOARD NR 242 DF WAS REPLACED IAW SRM 53-02-00 TABLE 103 ZONE "A" PAR 8G, 8H , AND IRM 9701 REV I.SDR AWXA200601429Floorboard · delaminatedSAL - FOUND DAMAGED FLOORBOARD NR 251 GF AT PASSENGER CABIN. FLOORBOARD NR 251 GF WAS REPLACED IAW SRM 53-02-00 TABLE 103 ZONE "A" PAR 8G, 8H AND IRM 9701 REV F.SDR AWXA200601428Floorboard · delaminatedSAL - FOUND DAMAGE FLOOR BOARD NR 231 VF AT PASSENGER CABIN. FLOORBOARD NR 231 VF WAS REPLACED IAW SRM 53-02-00 ZONE "A" PAR 8G 8H AND IRM 9701 REV. F.SDR AWXA200601427Floorboard · delaminatedSAL - FOUND DAMAGE FLOORBOARD NR 242 BF AT PASSENGER CABIN. FLOORBOARD NR 242 BF WAS REPLACED IAW SRM 53-02-00 TABLE 103 ZONE "A" PAR 8G, 8H AND IRM 9701 REV. F.
Back to JASC 5321