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 07FDEA00199Floorbeam · damagedFLOORBEAM HAS OPEN HOLE AT BS 380 ACCOMPLISHED EA NR 7-5330-106980 PART 1, TO COMPLETE WO NR 35039/N01472. INSTALLED RIVETS IN ALL OPEN HOLES.SDR KCSA071056Floorbeam · crackedAFT PIT BS 1800 FLOORBEAM WEB CRACKED AT RBL-15, WL-115.SDR SWIA200717930Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM CRACKS FOUND AT RBL12 AND LBL12, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PARTS PER CRJ200 REO 601R-53-11-171 REV C AND COMPLIED WITH SKYWEST RII 53-900-1001.SDR SIMA200705904Floorbeam · corrodedFOUND FLOORBEAM AT STATION 280 CORRODED ALONG BUTT LINE 24L TO 42R. SPLICED IN FRAME 280 AND EXTENSION MOUNTS IAW AMERICAN EAGLE ENGINEERING ORDER CR-53-MR-105. RETURNED AIRCRAFT TO SERVICE.SDR CALA0700048Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 25 - LBL 40. THE CORROSION WAS REMOVED AND THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR SIMA200703203Floorbeam · corrodedFOUND OMEGA BEAM CORRODED AT FRAME 32. PERFORMED CUTOUT OF DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW EMB SRM 53-00-10. RESTORED PROTECTIVE FINISH AND RETURNED AIRCRAFT TO SERVICE.SDR KCSA071053Floorbeam · corrodedMAIN DECK BS 480 FLOORBEAM UPPER CHORD CORRODED AT LBL 59.SDR SIMA200703006Floorbeam · corrodedFOUND LEFT OMEGA BEAM CORRODED AT FRAME 25. PERFORMED CUTOUT OF DAMAGE, FABRICATED REPAIR PIECES. INSTALLED REPAIR PIECES IAW EMB SRM 53-00-10. RESTORED PROTECTIVE FINISH. RETURNED AIRCRAFT TO SERVICE.SDR SIMA200703007Floorbeam · corrodedFOUND CENTER FLOORBEAM CORRODED AT FRAME 24. PERFORMED CUTOUT OF DAMAGE, FABRICATED REPAIR PIECES. INSTALLED REPAIR PIECES IAW EMB SRM 53-00-10. RESTORED PROTECTIVE FINISH AND RETURNED AIRCRAFT TO SERVICE.SDR 07FDEA00193Floorbeam · crackedCRACK IN FLOORBEAM UNDER CLS ADAPTER AT FRAME 34 BETWEEN TRACK 3L AND 4L (SEEN FROM FWD PIT). REMOVED AND REINSTALLED FLOORPANEL FOR FOM IAW A310-200 AMM SUPP 53-10-25-4. REMOVED AND REINSTALLED CLS ADAPTER IAW A310-200 SRM 51-40-21. REMOVED CRACK IAW A310 SDR 07FDEA00192Floorbeam · crackedCRACK IN FLOORBEAM UNDER CLS ADAPTER AT FRAME 36 BETWEEN TRACK 3L AND 4L (SEEN FROM FWD CARGO PIT). REMOVED AND REINSTALLED FLOOR PANEL TO FOM IAW A310-200 AMM SUPP 53-10-25-4. REMOVED AND REINSTALLED CLS ADAPTER IAW A310-200 SRM 51-40-21. REMOVED CRACK IAWSDR KCSA071052Floorbeam · corrodedUPPER DECK FLOORBEAM UPPER CHORD HAS CORROSION AT STA 520, BL 0.SDR CALA0700039Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 BETWEEN LBL 26.5 AND LBL 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01876.SDR SWAA070427Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 47 TO LBL 5. REPAIRED FLOORBEAM PER SRM.SDR CALA0700036Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 986.5 BETWEEN RBL 22.5 AND 43. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01877.SDR SIMA200703011Floorbeam · corrodedFOUND PREVIOUS REPAIR AT FRAME 20 CORRODED. REMOVED EXISTING REPAIR. CLEANED AND TREATED AREA, FABRICATED AND INSTALLED NEW REPAIR PIECES IAW EMB SRM 53-00-10. RESTORED PROTECTIVE FINISH, RETURNED AIRCRAFT TO SERVICE.SDR A6WA200740043Floorbeam · crackedFOUND RIGHT SIDE CARGO FLOOR ANGLE AT FS 621 BULKHEAD CRACKED APPROX .5 INCH LONG. (M) MAINTENANCE REPAIR CRACK IAW REO 601R-53-61-117 REV C BY INSTALLING REPAOR ANGLE AND STRAPS. (K)SDR 07FDEA00168Floorbeam · maint errorMAIN DECK FLOORBEAM UPPER CHORD AND INTERCOSTAL ATTACHMENT HAS DOUBLE DRILLED/MISREPAIRED FASTENER HOLES AT BS 400, RBL 12, WL 208. REMOVED DAMAGE ON UPPER CHORD, REPAIRED AREA REF SRM 53-10-08 FIG 3, TABLE I. REMOVED AND REPLACED INTERCOSTAL AT 400-420, RSDR 07FDEA00167Floorbeam · maint errorMAIN DECK FLOORBEAM UPPER CHORD AND INTERCOSTAL ATTACHMENT HAS DOUBLE DRILLED/MISREPAIRED FASTENER HOLES AT BS 420, RBL 12, WL 208 REMOVED AND REPLACED INTERCOSTAL AND REPAIR UPPER CHORD REF SRM 53-10-08 STA 420-440, REF GMM 7-0-1001 PG 1 AND 2, SRM 51-30-02SDR 07FDEA00165Floorbeam · maint errorMAIN DECK FLOORBEAM UPPER CHORD AND INTERCOSTAL ATTACHMENT HAS DOUBLE DRILLED/MISREPAIRED FASTENER HOLES AT BS 380, RBL 12, WL 208 REMOVED DAMAGE AND REPAIRED ON UPPER CHORD STA 380. REMOVED AND REPLACED INTERCOSTAL AT 380-400 REF SRM 53-10-08 FIG 3 STEP 3 SDR SIMA200703005Floorbeam · corrodedFOUND LEFT OMEGA BEAM CORRODED AT FRAME 44. PERFORMED CUTOUT OF DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES IAW EMB SRM 53-00-10. RESTORED PROTECTIVE COATING, RETURNED AIRCRAFT TO SERVICE.SDR SIMA200703004Floorbeam · corrodedFOUND OMEGA BEAM CORRODED AT FRAME 38. PERFORMED CUTOUT OF DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PIECES IAW EMB SRM 53-00-10. RESTORED PROTECTIVE COATING, RETURNED AIRCRAFT TO SERVICE.SDR SWAA070353Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 1003, RBL 50. REMOVED AND REPLACED FLOORBEAM WEB PER SRM.SDR KCSA071044Floorbeam · dentedSTA 560 FLOORBEAM UPPER CHORD DENTED RBL 50.SDR KCSA071043Floorbeam · damagedSTA 780 RBL 22 FLOORBEAM UPPER CAP DAMAGED.SDR CALA0700027Floorbeam · corrodedINSPECTION FOUND FLOORBEAM FORWARD FLANGE CORRODED AT NUTPLATE HOLE, STA 986.5, LBL 43. REPAIRED IAW ECRA 5321-01439.SDR UPS07849112Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON FLOORBEAM LOWER T-CAP EXFOLIATED STA -80 RBL 54. REMOVED OUT OF LIMITS CORROSION AT STA -80 RBL 57 IAW SRM 51-2-1. FABRICATED AND INSTALLED REPAIR PARTS AT STA -80 RBL 57 IAW SRM 51-2-1 FIG 1, AND TR 51-130.SDR SWAA070324Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 19 TO RBL 57. REPAIRED FLOORBEAM PER SRM.SDR SWAA070323Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 38 TO LBL 48. REPAIRED FLOORBEAM PER SRM.SDR KCSA071040Floorbeam · dentedSTA 720 FORWARD PIT FLOORBEAM UPPER CHORD DENTED WL 119 RBL 10.SDR USAA070050Floorbeam · corrodedSEVERAL AREAS ON FLOORBEAM, STA 986.5, RBL 24, RBL 28, BL 0, RBL 7, LBL 7 HAVE CORROSION. REMOVED CORROSION & INSTALLED ANGLE DOUBLERS & SHIMS PER EA 98409, DEFECT SIZE: .250 INCH EACH, SEVERAL AREAS.SDR USAA070047Floorbeam · corrodedSTA 785 - 847 RBL 14 HAS CORROSION. REMOVED DAMAGE & INSTALLED FAB'D PARTS PER SRM 53-00-53, FIG 201; CORR LEVEL 2; TASK C53-100-01, DEFECT SIZE: 65 INCHES.SDR C2XA07SH005Floorbeam · corrodedSHV - DURING C-CHECK, FS 23 LT OMEGA BEAM I/B L-FLANGE HAS AREA WITH CORROSION. MAINTENANCE REPAIRED LT OMEGA BEAM I/B L-FLANGE FR 23 IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR KCSA071038Seat Track · corrodedFOUND CORROSION ON MAIN DECK SEAT TRACK UPPER CHORD AT BS 440, LBL-33.SDR CALA0700023Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER TEE CORRODED AT FASTENER HOLE, STA 986.5, LBL 27. REPAIRED IAW ECRA 5321-01437.SDR CALA0700022Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT FASTENER HOLE, STA 986.5, LBL 4. REPAIRED IAW ECRA 5321-01437.SDR ASAA0741409Floorbeam · corrodedFLOORBEAM CAP HAS CORROSION AROUND A NUT HOLES. FLOORBEAM REPAIRED IAW SRM 53-60-51 FIG 201 REPAIR 3.SDR SWIA200717689Floorbeam · crackedRIGHT FLOORBEAM AT FRAME 13 ANGLE, INBOARD SIDE, CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED SUPPORT ANGLE AT FRAME 13A FLOOR PROP, INBOARD SIDE OF RIGHT FLOOR PROP PER EMB 120 SRM 51-40-02.SDR SWIA200717688Floorbeam · crackedLEFT FLOORBEAM AT FRAME 13 CRACKED BOTH SIDES, DISCOVERED DURING C-CHECK INSPECTION. SPLICED IN REPLACEMENT SECTION PER EMB 120 SRM 53-10-10. SEE RII 53-800-1000.SDR 07FDEA00132Floorbeam · damagedMAIN DECK FLOORBEAM UPPER TEE AND INTERCOSTAL ATTACHMENT HAS DOUBLE DRILLED/MISREPAIRED FASTENER HOLES AT BS 440, RBL 12, WL 208. FABRICATED T CAP REPAIR BS 440 RBL 12, WL208 REF SRM 53-10-8 FIG 3 AND INTERCOSTAL ATTACHMENT REF SRM 53-10-8 FIG 3. REMOVED DSDR QXEA200700084Floorbeam · damagedC2 PDX - DUE TO NUMEROUS DISCREPANCIES, FS 280 FLOORBEAM REQUIRES REPLACEMENT, REF NON ROUTINE 00162, NONROUTINE 00163 AND NON ROUTINE 00171. REPLACED IAW SRM 51-42-00, 51-40-11, AND REO670-53-11-047.SDR UIEA200700007Floorbeam · damagedAFT CARGO COMPARTMENT AFT FLANGE OF FLOORBEAM UPPER CHORD DAMAGED AT STA 1780 RBL 25.75. AFT CARGO COMPARTMENT AFT FLANGE OF FLOORBEAM REPAIRED AS PER SRM 51-70-12 REPAIR 1 AND EO 4453A100.SDR 0700316740Floorbeam · crackedDURING "M" CHECK, FOUND FASTENER HOLES WITH CRACK AND SHORT EDGE MARGIN ON UPPER DECK FLOORBEAM AT BS 380. REPAIRED PER EA 67-208611.SDR SWAA070233Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 54, WL 207. REPAIRED FLOORBEAM PER ER.SDR USAA070042Floorbeam · corrodedBS 328 RBL 28.5 FLOORBEAM UPPER TEE HAS CORROSION. CORROSION REMOVED, BLENDED; FAB'D STRAP & INSTALLED PER SRM 53-00-51; CORROSION LEVEL 2; TASK C53-107-02, DEFECT SIZE: 1 X 1 X .020 INCH.SDR ASAA0741402Floorbeam · corrodedFLOORBEAM CAP CORRODED AROUND NUT HOLES. FLOORBEAM REPAIRED PER SRM 53-60-51 FIG 201 REPAIR 3.SDR QXEA200700064Floorbeam · corrodedC2 PDX - VERTICAL WEB IS CORRODED AT STATION 280 FLOORBEAM, LBL12-LBL16 AND LBL30. REPAIRED IAW REO670-53-11-052, AND SRM 51-40-11, 51-40-02.SDR ASAA0741394Floorbeam · corrodedPASSENGER CABIN FLOORBEAM CORRODED OUT OF LIMITS. REMOVED THE DAMAGED AREA OF THE BEAM UPPER HORIZONTAL FLANGE, FABRICATED AND INSTALLED A REPAIR T-CHORD SECTION 2 SPLICE ANGLES 2 SPLICE STRAPS AND FILLERS IAW ASA EA 5310 02690 AND AAR EA 11805.SDR ASAA0741391Floorbeam · corrodedPASSENGER CABIN FLOORBEAM IS CORRODED OUT OF LIMITS. REMOVED EXISTING REPAIR IN THE DAMAGE AREA REMOVED THE DAMAGED AREA OF UPPER CHORD HORIZONTAL FLANGE, FABRICATED AND INSTALLED A REPLACEMENT UPPER T-CHORD SEGMENT 2 SPLICE ANGLES AND TWO SPLICE STRAPS PER ASDR SWAA070224Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, LBL 43 TO RBL 40. REPAIRED FLOORBEAM PER SWA EA.
Back to JASC 5315