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 DHLA2009743DH593Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1090 RBL 65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1090 BTWN RBL 32 AND RBL 70 IAW EO COO-2-53-495-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH591Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 1030 RBL65 FLOORBEAM UPPER FLANGE WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1030 BETWEEN RBL 29.5 AND RBL70 IAW COOPESA EO COO-2-53-437-08 DTD NOV 29, 2008 DOCUMENTED ON FORM 8110-3.SDR DHLA2009743DH590Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 783 LBL62 OVERWING STUB BEAM AND SUPPORT ANGLE WITH DOUBLE HOLES. REPLACED STUB BEAM CHORD AND NESTED ANGLES AT BS 783 BETWEEN LBL 70.5 AND LBL 45 IAW B727 SRM 51-10-1 PARA 7A.SDR DHLA2009743DH583Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 1030 LBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1030 BETWEEN LBL28 AND LBL70 IAW EO COO-2-53-437-08 DTD 11/29/08 DOCUMENTED ON FORM 8110-3.SDR USAA2008112892148Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR20, -Y200. REPLACED FLOORBEAM AT FR20, -Y200 IAW A320 SRM 51-72-11.SDR ASOA20081501Floorbeam · damagedREMOVED OTBD CLIP AT FS 280 LBL9 IAW SRM 51-42-21. INSTALLED NEW SERVICEABLE CLIP AT FS 280 O/B LBL 9 IAW SRM 51-42-21.SDR DHLA2008745688Floorbeam · corrodedCABIN FLOORBEAM AT BS 1070 LOWER CHORD CORRODED FROM LBL 10 TO RBL 55. ACCOMPLISHED REPAIR TO LOWER CHORD FROM LBL 19 TO RBL 10 PER B727 SRM 53-10-8 FIG 8. ALL OTHER CORROSION CLEANED UP WITHIN SERVICE LIMITS. DOCUMENTED ON N/R 2-164.SDR DHLA2009743DH680Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 700 RBL 62.5 FLOORBEAM CHORD AND SUPPORT ANGLE WITH DOUBLE HOLES. REPAIRED FLOORBEAM AT BE 700 BTWN RBL 54 AND RBL 70 IAW EO COO-2-53-475-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH679Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950E RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 950E BTWN RBL 29.5 AND RBL 70 IAW EO COO-2-53-486-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH678Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950D RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 950D BTWN RBL 52 AND RBL 70 IAW EO COO-2-53-489-08 DTD 12/18/08.SDR DHLA2009743DH677Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720A LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720A BTWN LBL 29 AND LBL 70 IAW EO COO-2-53-497-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH676Floorbeam · damagedUPPER FUSELAGE MAIN A=CARGO CABIN AT BS 700 LBL62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 700 BTWN LBL 53 AND LBL 70 IAW EO COO-2-53-475-08 DTD 12/18/08.SDR DHLA2009743DH675Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950E LBL 62 FLOORBEAM WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION IAW EO COO-2-53-486-08 DTD 12/18/08.SDR DHLA2009743DH674Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950D LBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 950D BTWN LBL 51.5 AND LBL70 IAW EO COO-2-53-489-08 DTD 12/18/08.SDR DHLA2009743DH673Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 990 LBL62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 990 BTWN LBL 28 AND LBL 70 IAW EO COO-2-53-487-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH672Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 990 RBL 62 FLOORBEAM WITH HOLE. REPAIRED FLOORBEAM AT BS 990 BTWN RBL 29.5 AND RBL 70 IAW EO COO-2-53-481-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH637Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 640 RBL 62.5 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 640 BTWN RBL 54 AND RBL 70 IAW EO COO-2-53-469-08 DTD 12/17/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH629Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT BS 620 BETWEEN LBL 5 AND LBL50 FLOORBEAM UPPER CHORD CORRODED. REMOVED CORROSION AT BS 620 BETWEEN LBL 33.812TO LBL5 FOUND TO BE WITHIN ALLOWABLE LIMITS IAW B727 SRM 53-10-1 FIG 4 .003 REMOVED. REPAIRED FLOORBEAM AT BS 620 SDR DHLA2009743DH625Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720E LBL 62 FLOORBEAM WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 720E BTWN LBL53 AND LBL 70 IAW EO COO-2-53-481-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH624Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 720E RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720E BETWEEN RBL 52.5 AND RBL 70 IAW EO COO-2-53-481-08 DTD 12/18/08.SDR DHLA2009743DH623Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 720D LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720D BTWN LBL 27.5 AND LBL 70 IAW EO COO-2-53-480-08 DTD 12/18/08.SDR DHLA2009743DH622Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720D RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION IAW EO COO-2-53-480-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH621Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720B LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 720B BETWEEN LBL 53.5 AND LBL 70 IAW EO COO-2-53-478-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH620Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720B RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720B BETWEEN RBL 53.5 AND RBL 70 IAW COOPESA EO COO-2-53-478-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH617Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720C LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720C BETWEEN LBL 54 AND LBL 70 IAW COOPESA EO COO-2-53-479-08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH612Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BE 1010 RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 1010 BTWN RBL 29 AND RBL 70 OAW EO COO-2-53-488-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH610Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720C RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720C BETWEEN RBL 52.5 AND RBL 70 IAW EO COO-2-53-479-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH608Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950F RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 950F BETWEEN RBL 28.5 AND RBL 70 IAW EO COO-2-53-494-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH606Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 950F LBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 950F BTWN LBL 6.25 AND LBL 70 IAW EO COO-2-53-494-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH601Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 680 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 680 BTWN LBL 27 AND LBL 70 IAW EO COO-2-53-473-08 DTD 12/17/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH600Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 680 RBL 62.5 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 680 BTWN RBL 29.5 AND RBL 70 IAW EO COO-2-53-473-08 DTD 12/17/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH599Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT BS 680 BTWN LBL 27 AND LBL 47 FLOORBEAM CHORD CORRODED. REPAIRED FLOORBEAM SECTION AT BS 680 BTWN LBL 27 AND LBL 70 IAW EO COO-2-53-473-08 DTD 12/17/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH595Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 970 RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 970 BTWN RBL 29.5 AND RBL 70 IAW EO COO-2-53-491-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH594Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 970 LBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 970 BTWN LBL 52.5 AND LBL 70 IAW EO COO-2-53-491-08 DTD 12/19/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH589Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 783 RBL62 OVERWING FLOOR STUB BEAM WITH DOUBLE HOLES. REPLACED STUB BEAM CHORD AND NESTED DOUBLER ANGLE AT BS 783.95 BTWN RBL70.5 AND LBL45 IAW SRM 51-10-1 PARA 7A.SDR DHLA2009743DH587Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 720F LBL62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM AT BS 720F BETWEEN LBL53 AND LBL70 IAW EOCOO-2-53-482-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH586Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 720F RBL 62 FLOORBEAM WITH DOUBLE HOLES. REPAIRED FLOORBEAM AT BS 720F BTWN RBL 52.5 AND RBL 70 IAW EO COO-2-53-432-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH585Strap · corrodedLOWER FUSELAGE AFT CARGO COMPARTMENT FROM BS 1070 TO BS 1130 RBL 45 FLOORBEAM STABILIZER STRAP WITH CORROSION. REPLACED STABILIZER STRAP FROM BS 1070 TO BS 1130 RBL 45 IAW B727 SRM 51-10-1 PARA 7A.SDR DHLA2008743DH582Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN BS 720 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM AT BS 720 BETWEEN LBL 53 AND LBL 70 IAW EO COO-2-53-476-08 DTD 12/18/08 DOCUMENTED ON FORM 8110-3.SDR DHLA2008743581Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN STA 720 RBL62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720 BETWEEN RBL 52.5 AND RBL 70 IAW EO COO-2-53-476-08 DTD 12/18/08 DOCUMENTED ON FAA 8110-3.SDR DHLA2009743DH579Floorbeam · damagedUPPER FUSELAGE CARGO CABIN AT BS 950C RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 950C BETWEEN RBL 29.5 AND RBL 70 IAW EO NR COO-2-52-485 -08 DTD 12/18/08 DOC FAA 8110-3.SDR DHLA2009743DH573Floorbeam · damagedUPPER FUSELAGE CARGO CABIN STA 848 RBL 62 OVERWING FLOORBEAM WITH DOUBLE HOLES. REPLACED UPPER CHORD AT BS 848 FROM RBL 46 TO RBL 70 IAW B727 SRM 51-10-1 PARA 7A.SDR DHLA2008743501Floorbeam · corrodedLOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 950D RBL13 AND RBL 30 FLOORBEAM LOWER FLANGE WITH CORROSION. REPAIRED FLOORBEAM LOWER CHORD FWD FLANGE AT BS 950D BETWEEN RBL 2 TO RBL 20 WL 200 IAW B727 SRM 53-10-8 FIG 8.SDR SWAA086184Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM TEE CAP CRACKED AT BS 294, LBL 52. REPAIRED BEAM PER SRM.SDR SWAA086159Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 38 TO RBL 5. REPAIRED BEAM PER SRM.SDR DHLA2009743DH681Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 620 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 620 BTWN RBL 54 AND RBL 70 IAW EO COO-2-53-443-08 DTD 12/04 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH662Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 460 LBL 63 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION IAW EO COO-2-53-465-08 DTD 12/16/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH661Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 600 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 600 BTWN RBL 53 AND RBL 70 IAW EO COO-2-53-442-08 DTD 12/03/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH659Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 440 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLES. REPAIRED FLOORBEAM SECTION AT BS 440 BTW RBL 50 AND RBL 70 IAW EO COO-2-53-464-08 DTD 12/16/08 DOCUMENTED ON FAA FORM 8110-3.SDR DHLA2009743DH656Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 460 RBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 460 BTWN RBL 29 AND RBL 70 IAW EO COO-2-53-465-08 DTD 12/16/08 DOCUMENTED ON FAA FORM 8110-3.
Back to JASC 5315