JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, 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 = '5315' 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 = '5315' 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 SWAA982325Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM RBL 11, BS 312. REPAIRED PER BOEING SRM.SDR SWAA982324Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM RBL 8, BS 312. REPAIRED PER BOEING SRM.SDR SWAA982323Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM BL0, BS 312. REPAIRED PER BOEING SRM.SDR 98ZZZX4308Floor Beam · corrodedDURING MAINTENANCE CHECK, CORROSION NOTED ON UPPER T-CHORD OF FLOOR BEAM 967, LBL 5.SDR 98ZZZX4306Floor Beam · corrodedDURING MAINTENANCE CHECK, CORROSION NOTED FLOOR BEAM AT INTERSECTION OF FRAME 1016 LBL 38.SDR 98ZZZX4148Floorbeam · corrodedDURING MAINTENANCE CHECK, CORROSION NOTED ON UPPER T-CHORD OF FLOORBEAM 294.5, RBL 25 TO LBL 30.SDR SWAA982313Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM AT LBL 9 CLIP NUT HOLE. REPAIRED PER TE-A53-014.SDR SWAA982312Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 1016, LBL 7. REPAIRED PER TI-A53-014.SDR SWAA982308Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM NUT PLATES AND BEAM SURFACE AT BS 754. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982307Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED NUT PLATES ACROSS FLOORBEAM AT BS 813. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982306Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM RBL 35 BS 328. REPAIRED PER BOEING SRM.SDR SWAA982305Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM RBL 28 BS 328. REPAIRED PER BOEING SRM.SDR SWAA982304Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 986.5, RBL 8 FWD FLANGE. REPAIRED PER TI-A53-014.SDR SWAA982303Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED BULKHEAD AT LBL 5, WL 199, FWD SIDE. REPAIRED PER BOEING SRM.SDR SWAA982295Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 986.5, RBL 43 FWD FLANGE. REPAIRED PER TI-A53-014.SDR SWAA982294Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 986.5, LBL 7 FWD FLANGE. REPAIRED PER TI-A53-014.SDR SWAA982293Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 986.5, RBL 15 FWD FLANGE. REPAIRED PER TI-A53-014.SDR SWAA982292Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE AT BS 986.5, RBL 28 FWD FLANGE. REPAIRED PER TI-A53-014.SDR SWAA982282Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM RBL39, BS 294.5. RREPAIRED PER TI-A53-014.SDR SWAA982278Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 987, RBL 1-40, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982277Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 967, RBL 5-41.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982274Floorbeam · misdrilledDURING SCHEDULED TRAN CHECK, FOUND MISDRILLED HOLE ON FLOORBEAM AT BS 7270+5, LBL 17, WL 160. REPAIRED PER BOEING SRM.SDR SWAA982271Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CARGO FLOORBEAM AT FASTENER HOLES BS 727 TO 773, LBL 12, WL 10. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982270Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED CARGO FLOORBEAM AT FASTENER HOLES BS 727 TO 773, RBL 8, WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982269Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FASTENERS ON FLOORBEAM SUPPORT STRAP AT BS 860, WL 160, RBL 20 TO LBL 20. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982248Floorbeam · damagedDURING SCHEDULED D CHECK, FOUND FLOORBEAM DAMAGED AT NUTPLATE BS 360, WL 208, RBL 52. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982247Floorbeam · damagedDURING SCHEDULED D CHECK, FOUND FLOORBEAM DAMAGED AT NUTPLATE BS 344, WL 208, LBL 28-48. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982244Floorbeam · damagedDURING SCHEDULED D CHECK, FOUND DAMAGED AT NUTPLATE LOCATIONS BS 312, RBL 1-12, WL 208 ON FLOORBEAM UPPER CHORD. REPAIRED PER BOEING SRM.SDR SWAA982243Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AROUND FASTENER LOCATIONS AT BS 328, WL 208, RBL 11. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982240Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 986, LBL 14, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR AALA984196Floorbeam · corrodedAFW - FLOORBEAM STATION 347 HAS CORROSION REMOVAL ON UPPER SURFACE. FABRICATE REPAIR STRAPS, ALODINE ALL BARE ALUMINUM FILL BLENDS WITH BMS. INSTALL REPAIR STRAP WET WITH SEALANT PER MRB 767-1701. (M)SDR AALA984195Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 AND APPROX RBL 50 HAD CORROSION BLENDED. FABRICATE REPAIR STRAPS, ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLENDS PER MRB 767-1695. (M)SDR AALA984194Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1480 HAS CORROSION. BLEND OUT ALL CORROSION, ALODINE ALL BARE SURFACES FINISH WITH 2 COATS OF PRIMED FILL BLENDED AREA WITH BMS PER MRB 767-1693. (M)SDR AALA984191Floorbeam · corrodedAFW - FLOORBEAM AT STATION 904 LBL 33 HAD CORROSION BLENDED ON TOP SURFACE. BLEND OUT GOUGES, ENSURED THAT ALL DAMAGE HAS BEEN REMOVED. ROTO/FLAP PEEN BLENDED AREA PER SRM 51-20-06 ALODINE AND APPLY 2 COATS OF PRIMER FILL WITH BMS-5-95 REF MRB 767-1703. (M)SDR AALA981779Floorbeam · corrodedTUL - FOUND FLOORBEAM CHORD CORRODED STATION 388 BL 0 - RBL 66. REPAIRED FLOORBEAM PER SRM 53-10-8 AND ESO 11697 DATED 8-31-98. (M)SDR 98FDEA00612Floorbeam · corrodedBS 680 CORROSION ON BOTTOM SIDE OF FLOORBEAM LWR FLANGE AT SEV AREAS. BLENDED OUT CORROSION PER EA 7-5310-29662 DATED 9-14-98. INSTALLED .071 7075-T6 ANGLES ON FWD AND AFT FLANGES PER AARD 53-10-7-2 AND EA 7-5310-29662.SDR 98FDEA00609Floorbeam · damagedUPPER LOBE FLOORBEAM HAS DOUBLER DRILL HOLE BS 990. CUT OUT DAMAGE, INSTALLED DOUBLER PER AARD 53-10-07-02 AND EA 7-5310-29648.SDR 98FDEA00608Floorbeam · damagedCABIN FLOORBEAM HAS ONE DOUBLE DRILL HOLE BS 1010, RBL 63. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-07-02 FIG 3 AND EA 7-5310-29648.SDR 98FDEA00607Floorbeam · damageFLOORBEAM CUT ACROSS TOP FLANGE BS 1130, RBL 63. BLENDED OUT DAMAGE AND INSTALLED .080 STRAP OF 7075-T6 ALUM PER AARD 53-10-07-01 AND 7-5310-29698.SDR 98FDEA00606Floorbeam · damagedCABIN FLOORBEAM CUT ACROSS TOP FLANGE BS 1050, RBL 63. CUT OUT DAMAGE, INSTALLED DOUBLER PER AARD 53-10-07-02 AND EA 7-5310-29648.SDR 98FDEA00605Floorbeam · damagedCABIN FLOORBEAM CUT ACROSS TOP FLANGE AT STR 970, RBL 63. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-07-02 AND EA 7-5310-29648.SDR 98FDEA00603Floorbeam · corrodedUPPER LOBE, BS 1050 HEAVY CORROSION ON LWR FWD LEG OF FLOORBEAM AT LBL 29. BLENDED OUT CORROSION IN AREA NOTED PER SRM 51-10-6. BLENDED AREA OUT OF LIMITS. CUT OUT DAMAGE AND INSTALLED DOUBLER ON FLOORBEAM PER AARD 53-10-07-2.SDR SWAA982226Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED AT BS 986.5 FLOORBEAM FASTENER HOLES LBL 5, 35.5 RBL 4.5, 31, 39, WL 208 AND 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982223Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CRACKED AT FLOORBOARD FASTENER HOLE AT BS 947 LBL 53, WL 208. REPAIRED PER BOEING SRM.SDR SWAA982230Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT FASTENER HOLES BS 727 TO 773, RBL 3, WL 160. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982227Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED AT BS 986.5 FLOORBEAM FASTENER HOLES LBL 5, 35.5 RBL 4.5, 31, 39, WL 208 AND 207. REMOVED AND REPLACED PER BOEING SRM.SDR C2XA98IA367Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FRAME 38 FLOORBEAM CORRODED AROUND SEVERAL FASTENER HOLES. MAINTENANCE REMOVED THE CORROSION AND INSTALLED ONE REPAIR DOUBLER IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION (ECRA) EC5310-01037. THE AIRCSDR C2XA98IA366Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FRAME 36 FLOORBEAM CORRODED AROUND SEVERAL FASTENER HOLES. MAINTENANCE INSTALLED REPAIR DOUBLERS IN 5 LOCATIONS IAW CONTINENTAL EXPERSS ENGINEEERING CHANGE/REPAIR AUTHORIZATION (ECRA) EC5310-01037. THE AIRCRAFT WAS APPRSDR UPS98827924Floorbeam · crackedINSPECTION TYPE:C2 FLOORBEAM, STA 902 CRACKED AT RT O/B FLANGE. ROUTED OUT DAMAGE, FABBED FILLER AND SHIM IAW REO-05489 REV A FABBED. REPAIR STRAP ON UPS N/R 809637, DRILLED AND INSTALLED IT, FILLER AND SHIM IAW DC8 SRM 51-1-20D, 51-1-24 AND REO 05489 REV A.SDR DL72L982003Floorbeam · corrodedFLOORBEAM CAP CORRODED STA 344 LBL 40 TO 48. REPAIRED PER 272 SRM 53-10-8.
Back to JASC 5315