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 DU4R2008246Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON BS 294 FLOORBEAM BL 0 TO BL 10R.SDR ASAA0873962Floorbeam · corrodedBS 947 RBL 53 FLOORBEAM IS CORRODED. BLENDED CORROSION ON BS 947 RBL 53 FLOORBEAM FLAP PEENED AREA AND RE-APPLIED FINISH.SDR SWAA086388Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 294, LBL 52. REPAIRED WEB PER EA.SDR 08FDEA04931Floorbeam · corrodedMAIN DECK 1130 FLOORBEAM UPPER TEE CAP HAS A DOUBLE DRILLED 1/4 INCH RBL 57.5 INCH.SDR UHLA2008111800026Floorbeam · corrodedFOUND LEVEL 2 CORROSION ON RT FLOORBEAM BETWEEN FR 86 AND 89. RT FLOORBEAM BETWEEN FR 86 AND 89 REPLACED IAW EMB 170 SRM 51-41-01 AND 51-43-04.SDR FDEA200811184909Floorbeam · corrodedCABIN FLOORBEAM, STA 1661, LBL 58 TO RBL 58 HAS CORROSION AT SEVERAL PLACES. REMOVED AND REPLACED FLOORBEAM UPPER CAP AT STA 1661, LBL 58, RBL 58 IAW SRM 51-40-02 MAJOR REPAIR. NO FOLLOW-UP INSP REQUIRED.SDR FDEA200811184916Floorbeam · corrodedAFT CARGO COMPT, FLOORBEAM 1360, AT S-26L, IS CORRODED AND GOUGED. REPAIRED FLOORBEAM IAW SRM 53-00-07, REPAIR NR 5. THIS REPAIR IS CLASSIFIED AS A CAT. "B" MAJOR REPAIR WITH THE FOLLOWING FOLLOW UP REQUIREMENTS: INITIAL AT 37,500 FC; THEREAFTER EVERY 12,0SDR SWIA200820670Floorbeam · crackedLOWER FLOORBEAM ANGLE CRACKED AT LBL 9 FS 280(C-CHECK). REPAIRED PER REO.SDR SWIA200820669Floorbeam · crackedUPPER FLOORBEAM ANGLE CRACKED AT LBL 9 AND RBL 9 (C-CHECK). REPAIRED PER REO.SDR DU4R2008244Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOORBEAM AFT CABIN BS 947 LBL 53.SDR SWAA086408Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BETWEEN BS 707 TO BS 714, BL 0. REPAIRED WEB PER PAE ER.SDR CALA2008111901088Floorbeam · corrodedCABIN FLOORBEAM AT STA 365 RBL 8 HAS SMALL AREA OF SURFACE CORROSION. PERFORMED PERMANENT REPAIR TO CABIN FLOORBEAM AT STA 365 RBL 8 REF ECRA 5320-01913 STEPS 1 THRU 6.SDR CALA2008111901087Floorbeam · corrodedCABIN FLOORBEAM AT STA 365 RBL 40 HAS SMALL AREA OF SURFACE CORROSION. PERFORMED PERMANENT REPAIR TO CABIN FLOORBEAM AT STA 365 RBL 40 REF ECRA 5320-01913 STEPS 1 THRU 6.SDR SWAA086346Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LOWER CHORD CORRODED AT BS 227, BETWEEN BL 0 TO RBL 5. REPAIRED CHORD PER SWA EA.SDR 08FDEA04909Floorbeam · corrodedCABIN FLOORBEAM STA 1661, LBL 58 TO RBL 58 HAS CORROSION AT SEVERAL PLACES. REMOVED AND REPLACED FLOORBEAM UPPER CAP AT STA 1661 LABL 58-RBL 58 IAW SRM 51-40-02, MAJOR REPAIR NO FOLLOW-UP INSPECTION REQUIRED.SDR USAA2008111992091Support Angle · crackedBFM - C4 - MAJOR REPAIR - FLOORBEAM SUPPORT ANGLE CRACKED AT BS 287, LBL 82. REPAIRED FLOORBEAM SUPPORT ANGLE AT BS 287, LBL 82 IAW B767 SRM 51-40-02.SDR SWIA200820914Floorbeam · corrodedDURING C-CHECK, LEFT SIDE FLOOR CROSS MEMBER AT FRAME 39 CORRODED. REPLACED PER SRM.SDR DHLA2008743506Floorbeam · corrodedLOWER FUSELAGE E/E COMPARTMENT BS 328 WL 208 RBL 44 FLOORBEAM WITH CORROSION. REPLACED FUSELAGE FLOORBEAM SECTION AT BS 328 BETWEEN LBL 63 AND RBL 63 IAW SRM 51-10-1 PARA 7.SDR AALA200810390Floorbeam · corrodedTOP OF FLOORBEAM CORRODED STATION 948 AND BUTT LINE 40 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-00-51.SDR DU4R2008243Floorbeam · corrodedDURING SCHEDULED INSPECTION, FL FOUND CORROSION ON FLOORBEAM AFT CABIN STA 986 RBL 39 TO LBL 44.SDR ASOA200801529Floorbeam · corrodedRT 280 FLOORBEAM CORRODED. R/R FLOORBEAM.SDR SWAA086263Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 665, BL 0. REPAIRED CHORD PER SI.SDR SWAA086262Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 667, BL 0. REPAIRED CHORD PER SI.SDR DHLA2009743DH645Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1130 RBL 62 UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 1130 BTWN RBL 57 AND RBL 62 IAW EO COO-2-53-435-08 DTD 12/04/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH644Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1130 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1130 BTWN LBL 6.5 AND LBL 62 IAW COOPESA EO COO-2-53-435-08 DTD 12/04/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA7432009649Floorbeam · corrodedUPPER FUSELAGE COCKPIT FLOORBEAM WITH CORROSION AT STA 277 AND AT 12 INCHES LBL 0. REPAIRED IAW SRM 51-40-4 FIG 1.SDR DHLA2008743DH604Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1070 LBL 62 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1070 BTWN LBL 30 AND LBL 70 IAW EO COO-2-53-493-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR USAA2008112892153Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR67 +16 INCHES, Y1195. REPLACED FLOORBEAM AT FR67 +16 INCHES, Y1195 IAW A320 SRM 51-72-11.SDR USAA2008112892152Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR67 +18 INCHES, Y1162. REPLACED FLOORBEAM AT FR67 +18 INCHES, Y1162 IAW A320 SRM 51-72-11.SDR USAA2008112892150Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR67, -Y460. REPLACED FLOORBEAM BETWEEN FR66 TO FR67, -Y460 IAW A320 SRM 51-72-11.SDR USAA2008112692134Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR68, Y765. REPLACED FLOORBEAM AT FR68, Y765 IAW A320 SRM 51-72-11.SDR USAA2008112692132Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 +5 INCHES TO FR67 +16 INCHES, -Y1195. REPAIRED FLOORBEAM BETWEEN FR66 +5 INCHES TO FR67 +16 INCHES, -Y1195 IAW A320 SRM 51-72-11.SDR USAA2008112692131Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR70, Y160. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, Y160 IAW A320 SRM 51-72-11.SDR DHLA2009743DH671Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 910 LBL 62 FLOORBEAM WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 910 BTWN LBL 53 AND LBL 70 IAW EO COO-2-53-483-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH670Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 910 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 910 BTWN RBL52.5 AND RBL 70 IAW EO COO-2-53-483-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA7432009646Floorbeam · corrodedUPPER FUSELAGE PAX CABIN AT BS 1130 FROM LBL 45 TO RBL 55 FLOORBEAM UPPER FLANGE WITH CORROSION. REPAIRED FLOORBEAM SECTION IAW COOPESA EO COO-2-53-534-08 DATED DEC 04 2008. REPLACED INTERCOSTAL AT LBL 125' AND LBL 45 IAW B727 SRM 51-10-1 PARA 7.SDR DHLA2009743DH626Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 890 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 890 BETWEEN LBL 55 AND LBL 62.5 IAW EO COO-2-53-462-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH616Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 930 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 930 BETWEEN RBL 55.5 AND RBL 70 IAW EO COO-2-53-439-08 DTD 12/02/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH615Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 930 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 930 BETWEEN LBL 55 AND LBL 70 IAW COOPESA EO COO-2-53-439-08 DTD 12/02/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH614Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1050 LBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1050 BTWN LBL 47 AND LBL 70 IAW EO COO-2-53-490-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH613Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1050 RBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1050 BTWN RBL 52 AND RBL 70 IAW EO COO-2-53-490-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH611Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1010 LBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1010 BETWEEN LBL 28 AND LBL 70 IAW EO COO-2-53-488-08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH609Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1090 LBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1090 BETWEEN LBL 21 AND LBL 70 IAW EO COO-2-53-495-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH607Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950F LBL 21 FLOORBEAM WITH CORROSION. REPAIRED FLOORBEAM SECTION AT 950F BTWN LBL6.25 AND LBL 70 IAW EO COO-2-53-494-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH605Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1070 FROM RBL 12 TO RBL 65 FLOORBEAM UPPER FLANGE WITH CORROSION. REPAIRED FLOORBEAM SECT AT BS BTWN RBL 29 AND RBL 70 IAW EO COO-2-53-493-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH603Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1070 LBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1070 BTWN LBL 30 AND LBL 70 IAW EO COO-2-53-493-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743602Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1070 RBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1070 BTWN RBL 29 AND RBL 70 IAW EO COO-2-53-493-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH598Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1110 FROM LBL 45 TO RBL 60 FLOORBEAM UPPER FLANGE WITH CORROSION. REMOVED CORROSION AND FOUND WITHIN LIMITS FROM LBL 17 TO RBL 10.5. REPAIRED FLOORBEAM AT BS 1110 BTWN LBL 17 AND LBL 70 AND BTWN RBL 10.5 AND RBL 70 IAW ESDR DHLA2009743DH597Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1110 LBL 62 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1110 BTWN LBL 17 AND LBL 70 IAW COOPESA EO COO-2-53-439-08 DTD 11/28/08 DOCUMENTED ON FORM FAA 8110-3.SDR DHLA2009743DH596Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1110 RBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1110 BTWN RBL 10.5 AND RBL 70 IAW COOPESA EO COO-2-53-434-08 DTD 11/28/08 DOCUMENTED ON FAA FORM 8110-3.
Back to JASC 5315