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 ASAA0791758Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL AT STA 727 CORRODED. REPAIRED IAW 51-40-05.SDR ASAA0791757Floor Panel · corrodedCORROSION ON AFT CARGO PIT FLOOR PANEL. REPAIRED IAW SRM 51-40-05.SDR ASAA0791756Floor Panel · corrodedCORROSION ON AFT CARGO PIT FLOOR PANEL. REPAIRED IAW SRM 51-40-050.SDR ASAA0791755Floor Panel · corrodedCORROSION AT AFT CARGO PIT FLOOR PANEL AT STA 727. REPAIRED IAW SRM 51-40-05.SDR ASAA0791754Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL AT STA 727 CORRODED. REPAIRED IAW SRM 51-40-05.SDR F3LA200700125Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOOR PANEL 261FF CORRODED ON LOWER SIDE. REPLACED FLOOR PANEL IAW AMM 53-12-12-000-001.SDR F3LA200700124Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOOR PANEL 262FF CORRODED ON LOWER SIDE. REPLACED FLOOR PANEL IAW AMM 53-12-12-000-001.SDR ASAA0781731Channel · damagedCABIN FLOOR PANEL HAS A DAMAGED HAT CHANNEL. LOCATED AND DRILLED A REPLACEMENT HAT CHANNEL IAW SRM 51-10-4, 51-30-2 AND DAC DWG 9957918.SDR ASAA0781730Floor Panel · damagedCABIN FLOOR PANEL HAS EDGE DAMAGE. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-03 PG 122B AND DCA DWG S4932106.SDR ASAA0781729Floor Panel · damagedCABIN FLOOR PANEL IS DELAMINATED. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781728Floor Panel · damagedCABIN FLOOR PANEL HAS TEN DAMAGED INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781727Floor Panel · deterioratedCABIN FLOOR PANEL HAS NUMEROUS DAMAGED INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781726Floor Panel · delaminatedCABIN FLOOR PANEL IS DELAMINATED. FABRICATED A REPLACEMENT PANEL IAW SRM 53-05 PARA 44 AND DCA DWG S4932106.SDR ASAA0781725Floor Panel · deterioratedCABIN FLOOR PANEL IS BROKEN AT AN INSERT. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781724Floor Panel · delaminatedCABIN FLOOR PANEL DELAMINATED. FABRICATED REPLACEMENT FLOOR PANEL IAW SRM 53-05 PG 122B FIGURES 50 AND 50A AND DCA DWG 9936640.SDR ASAA0781743Insert · corrodedCABIN FLOOR PANEL HAS NUMERIOUS INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781742Insert · corrodedCABIN FLOOR PANEL HAS NUMEROUS CORRODED INSERTS. FABRICATED A REPLACEMENT PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781741Floor Panel · delaminatedCABIN FLOOR PANEL IS DELAMINATED. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781740Floor Panel · delaminatedCABIN FLOOR PANEL IS DELAMINATED. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781739Insert · corrodedCABIN FLOOR PANEL HAS NUMEROUS CORRODED INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781738Insert · corrodedCABIN FLOOR PANEL HAS NUMEROUS CORRODED INSERTS. FABRICATED A REPLACEMENT PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781737Floor Panel · deterioratedCABIN FLOOR PANEL HAS FIBER DAMAGE TO THE UPPER SURFACE. FABRICATED A REPLACEMENT PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781736Floor Panel · damagedCABIN FLOOR PANEL HAS DAMAGED INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781735Floor Panel · delaminatedCABIN FLOOR PANEL IS DELAMINATED. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53-05 PARA 44 AND DAC DWG S4932106.SDR ASAA0781734Floor Panel · corrodedCABIN FLOOR PANEL HAS CORRODED INSERTS. FABRICATED A REPLACEMENT FLOOR PANEL IAW SRM 53 05 PARA 11 AND DAC DWG S4932106.SDR 07FDEA02002Panel · damagedMARKS, DENT, CRACKS AND NICKS AT C47-53, BETWEEN TRACK 5 LT AND 5 RT. REPAIR PERFORMED BY DOUBLER REPAIR AT INTERNAL WEB C47, DRESS OUT SKIN ON DIAPHRAGM , BLEND OUT DAMAGED AREAS IAW EA 6-5315-106463 AND RAS/051804/007/2007 8ISS. ASDR AWXA200700657Floor Panel · corrodedSAL - CORROSION ON CABIN FLOORBOARD 261FF, FR 66 - FR 68, +Y1292 TO +Y1732. REPLACED CABIN FLOORBOARD 261FF, FR 66 - FR 68, +Y1292 TO +Y1732 IAW AWA TASK CARD C1D25318.SDR TRAX200700707Pressure Panel · corrodedRT PRESSURE FLOOR HAS CORROSION AT FS 526 FLOOR TO SIDEWALL ATTACH. MARKED BLENDED OUT LIGHT SURFACE CORROSION IAW CRJ 200 SRM 51-21-06. DB 20877. COMPLIED WITH EC/TC REO 601R-53-41-523.SDR TRAX200700703Pressure Panel · corrodedPRESSURE FLOOR SKIN CORRODED AT FS 460 BETWEEN LBL 27.00 AND LBL 36.00 (MARKED).SDR F3LA200700117Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOOR PANEL 221FF CORRODED. REPLACED FLOOR PANEL 221FF IAW AMM 53-12-12-400-001.SDR 2007UALA01592Pressure Panel · crackedPRESSURE DECK CRACKED AT STA 664, LBL 30 WL 204 JUST OUTBOARD OF AILERON TOWER SHAFT INPUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER REPAIR.SDR ASAA0791648Floor Panel · corrodedFWD CARGO FLOOR PANEL NR 2 CORRODED.SDR EIA2007107Floor Panel · corrodedMAIN DECK BS 800 FWD OUTBOARD END OF PANEL 83 HAS CORROSION BETWEEN FLOOR BEAM AND SEAT TRACK. REMOVED CORROSION, NDTD AREA, FABRICATED AND INSTALLED REPAIR PER B747 SRM 53-10-07 FIG 10.SDR ASAA0791676Floor Panel · corrodedAFT CARGO FLOOR PANEL CORRODED. REPAIRED IAW SRM 51-40-02.SDR ASAA0791675Floor Panel · corrodedAFT CARGO FLOOR PANEL CORRODED. REPAIRED IAW SRM 51-40-02.SDR ASAA0791674Floor Panel · corrodedAFT CARGO FLOOR PANEL CORRODED. REPAIRED IAW SRM 51-40-02.SDR ASAA0791673Floor Panel · corrodedAFT CARGO FLOOR PANEL CORRODED. REPAIRED IAW SRM 51-40-02.SDR ASAA0791672Floor Panel · corrodedAFT CARGO FLOOR PANEL CORRODED. REPAIRED IAW SRM 51-40-02.SDR ASAA0791651Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL NR 5 CORRODED. REPAIRED IAW SRM 51-40-05.SDR ASAA0791650Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL NR 4 CORRODED. REPAIRED IAW SRM 51-40-05.SDR ASAA0791649Floor Panel · corrodedFWD CARGO PIT FLOOR PANEL NR 3 IS CORRODED. REPAIRED IAW SRM 51-40-05.SDR ASAA0791647Floor Panel · corrodedFWD CARGO FLOOR PANEL NR 1 CORRODED. REPAIRED IAW SRM 51-40.SDR F3LA200700115Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOOR PANEL 262FF CORRODED. REPLACED PANEL 262FF IAW 53-42-12, PB 401.SDR F3LA200700114Floor Panel · corrodedDURING C-3 CHECK, INSPECTION REPORTED FLOOR PANEL 261FF CORRODED. REPLACED PANEL 261FF IAW AMM 53-42-12, PB 401.SDR UPS07M49792Floor Panel · crackedINSPECTION TYPE:N/A AFT CARGO FLOOR PANEL DAMAGED. REPAIRED IAW SRM 53-60-00.SDR EIA2007116Floor Panel · gougedMAIN CABIN FLOOR PANEL GOUGED 2 PLACES BS 358 RBL 6. DAMAGED FLOOR PANEL IS WEB OF NOSE WHEEL WELL BOX TOP PANEL. REMOVED GOUGES, AREA OUT OF LIMITS PER B747 SRM 53-10-01 PAGES 2-6. REPAIRED AREA STATION 340 RBL 6 B747 SRM 53-10-04 FIGURE 119.SDR AWXA200700596Floor Panel · corrodedSAL - MAJOR REPAIR - FOUND CORROSION ON CABIN FLOOR PANEL 222 FF. REPLACED CABIN FLOOR PANEL 222 FF IAW AWA TASK CARD C1D25306.SDR AWXA200700595Floor Panel · corrodedSAL - MAJOR REPAIR - FOUND CORROSION ON CABIN FLOOR PANEL 262 FF. REPLACED CABIN FLOOR PANEL 262 FF IAW AWA TASK CARD C1D25318.SDR AWXA200700590Floor Panel · corrodedSAL - CORROSION ON CABIN FLOOR PANEL 261FF. REPLACED CABIN FLOOR PANEL 261FF IAW AWA TASK CARD C1D25318.SDR AWXA200700579Floorboard · delaminatedPHX - MAJOR REPAIR - CABIN FLOORBOARD 241EF IN CENTER AISLE IS DELAMINATED AT SEAT ROW 12. REPLACED CABIN FLOORBOARD 241EF IN CENTER AISLE AT SEAT ROW 12 IAW AWA TASK CARD R1C25306.
Back to JASC 5321