JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 USAA2013090500012Frame · crackedQ3 CHECK, CRACK ON FRAME WEB AT BS 947.5, S15R. REPAIRED FRAME IAW DWG 65-46561.SDR USAA2013090300005Frame · corrodedC4 CHECK - CORROSION ON FUSELAGE FRAME BS 795 S24-25R. REPLACED FRAME IAW SRM 51-40-02 & DWG 65-47959.SDR USAA2013090300004Frame · corrodedC4 CHECK - CORROSION ON FUSELAGE FRAME BS 795 BETWEEN S26-27R. REPLACED FRAME IAW SRM 51-40-02 & DWG 65-47959.SDR FDEA201308292071Frame Splice · gougedAFT CARGO BAY, BS 1480 S24R, FRAME SPLICE GOUGED. REMOVED & REPLACED FRAME SPLICE IAW 51-40-02. CATEGORY A MAJOR REPAIRSDR FDEA201308292070Frame Splice · corrodedAFT CARGO BAY BS 1600 S25R, FRAME SPLICE CORRODED. REMOVED AND REPLACED FRAME SPLICE IAW SRM 51-40-02. CATAGORY A MAJOR REPAIR.SDR IPXA3580322Frame · damagedINSPECTION C-8, SCREW STRIKE ON MAIN CABIN FRAME BS 1200. ACCOMPLISHED NEO B757-5310-52182-A.SDR IPXA3580321Frame · damagedINSPECTION C-8, SCREW STRIKE ON MAIN CABIN FRAME BS 1240. ACCOMPLISHED EO B757-5310-52176-A.SDR SWAA2013091020036Frame · crackedSTUB FRAME CRACKED AT BS 947.5+9, STRINGER 8R. R&R FRAME IAW SRM.SDR CHQA20130829334Frame · gougedDURING INSPECTION, FRAME 63 WAS FOUND TO HAVE 2 GOUGES BETWEEN STRINGERS 1L AND 1R. THE FRAME WAS REPAIRED IAW ETD 2013-145-034393.SDR SWAA2013090619906Frame · crackedFS FRAME CRACKED AT STATION 500C, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013090619905Frame · crackedFS FRAME CRACKED AT STATION 727A, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419832Frame · crackedFRAME WEB CRACKED AT BS 867, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419831Frame · crackedFRAME WEB CRACKED AT BS 787, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419830Frame · crackedFRAME WEB CRACKED AT BS 747, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419829Frame · crackedFRAME WEB CRACKED AT BS 480, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419828Frame · crackedFRAME WEB CRACKED AT BS 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090419827Frame · crackedFRAME WEB CRACKED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090319781Frame · crackedFRAME WEB CRACKED AT BS 787, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013090319780Frame · crackedFRAME WEB CRACKED AT BS 480, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013110722044Frame · crackedFRAME CRACKED AT FS 715 RT, BETWEEN LONGERON 18R & LONGERON 17R. R & R FRAME IAW SRM & DRAWING.SDR USAA2013092600013Frame · corroded2S CHECK - CORROSION ON FUSELAGE FRAME AT FRAME 68 BETWEEN S22-23R. REPAIRED FUSELAGE FRAME IAW SRM 53-41-12 & EA 504324.SDR SWAA2013092320420Frame · crackedFRAME CRACKED AT BS 715, BETWEEN LONGERON 18L TO LONG 17L. R &R FRAME SECTION IAW SRM.SDR SWAA2013091220101Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20L TO STRINGER 2L. REPAIRED FRAME IAW SRM.SDR CALA2013090591050Frame · crackedBS 1180 TENSION TIE RT FRAME CRACKED AT FASTENER HOLE. INSTALLED NEW FRAME SEGMENT IAW SRM 53-40-07 REPAIR 4.SDR CALA2013090591049Frame · crackedBS 1160 RT TENSION TIE FRAME CRACKED AT FASTENER HOLE. INSTALLED NEW FRAME SEGMENT IAW SRM 53-40-07 REPAIR 3.SDR CALA2013090591048Frame · crackedBS 1120 RT TENSION TIE FRAME CRACKED AT FASTENER HOLE. INSTALLED NEW FRAME SEGMENT IAW SRM 53-40-07 REPAIR 1.
SDR AALA20130828004Frame · crackedFS FRAME FWD SIDE IS CRACKED AT STATION 1322 & LONGERON 17 LT. INSTALLED FRAME CRACK CUTOUT REPAIR IAW SRM 53-03-00, FIGURE 51.SDR MJYA201309120009Frame · corrodedCANTED FRAME AT BS 796 LT IS CORRODED OUT OF LIMITS.SDR DALA13042060977Frame · crackedBELT FRAME WEB CRACKED AT CANTED BS 1485, NEAR 8 O`CLOCK POSITION, AT TAIL INTERIOR, TAIL CONE RELEASE HANDLE STRUCTURE ATTACHMENT. REPAIRED IAW ERA 518140-14, REV ORIG.SDR AALA20130827017Frame · crackedFRAME CRACKED ON AFT SIDE OF STATION 1418 & LONGERON 2 RT. INSTALLED FRAME DOUBLER ON AFT SIDE OF FRAME IAW SRM 53-03-00, DRAWING PL591359, SRM 53-10-00-15, SRM 53-01-00, & AARD 53-10-00-15.SDR AALA20130827015Frame · crackedFRAME CRACKED ON AFT SIDE OF STATION 1418 & LONGERON 2 LT. INSTALLED FRAME DOUBLER ON AFT SIDE OF FRAME 1418 & LONGERON 2 LT IAW 53-03-00, DRAWING PL591358, & SRM 53-01-00, AARD 53-10-00-15, SRM 53-03-00, SRM 53-01-00, & AARD 53-10-00-15.SDR C77A20130827002Frame · damagedDURING CHECK, DISCOVERED FASTENER HOLE DAMAGED ON THE FWD CARGO FRAME 24 FWD LOWER CORNER. REPAIRED IAW ETD2013-170-031690.SDR SWAA2013091320128Frame · crackedFRAME CRACKED AT STATION 907 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013091020042Frame · crackedFRAME CRACKED AT STATION 907, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013090919989Frame · crackedFRAME CRACKED AT STATION 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR FDEA201308262059Frame · corrodedAFT CARGO, BS 1300, LBL 21-RBL 21, FRAME CORRODED. REMOVED CORROSION IAW SRM 51-10-02, FOUND OUT OF LIMITS IAW SRM 53-00-07, DETAIL 2, FIG. 101. REMOVED AND REPLACED FRAME IAW DWG 146N1006, SH.3, REV. E, AND SRM 51-40-02. MAJOR REPAIR (CAT. "A")SDR AALA20130905025Frame · crackedFRAME CRACKED AT STATION 727B BETWEEN STRINGERS 8 & 9 RT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905024Frame · crackedFRAME CRACKED AT STATION 500C BETWEEN STRINGERS 8 & 9 RT. REPLACED WITH DOUBLER IAW ECO J1159AE.SDR SWAA2013090619901Frame · crackedFRAME CRACKED AT STATION 500C, STRINGER 8L. REPAIRED FRAME IAW EA.SDR AALA20130905023Frame · crackedFRAME CRACKED AT STATION 500A BETWEEN STRINGERS 8 & 9 RT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905022Frame · crackedFRAME CRACKED AT STATION 440 BETWEEN STRINGERS 8 & 9 RT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905020Frame · crackedFRAME CRACKED AT STATION 887 BETWEEN STRINGERS 8 & 9 LT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905018Frame · crackedFRAME CRACKED AT STATION 727B BETWEEN STRINGERS 8 & 9 LT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905017Frame · crackedFRAME CRACKED AT STATION 500A BETWEEN STRINGERS 8 & 9 LT. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905016Frame · crackedFRAME CRACKED AT OVERHEAD BIN RAIL ATTACH POINT AT STATION 480. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR AALA20130905015Frame · crackedFRAME CRACKED AT AC RAIL ATTACH BRACKET AT LT STATION 400. REPAIRED WITH DOUBLER IAW ECO J1159AE.SDR SWAA2013083019725Frame · crackedFRAME CRACKED AT STATION 440, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013083019724Frame · crackedFRAME CRACKED AT STATION 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013083019723Frame · crackedFRAME CRACKED AT STATION 727B, STRINGER 8R. REPAIRED FRAME IAW EA.SDR MJYA20130827008Frame · corrodedUPPER AND MID LT CANTED FRAME CORRODED AND FOUND TO BE OUT OF LIMITS AT BS 989.
Back to JASC 5311