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 DALA13040743758Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN BS 500A BELOW S8L FRAME HAS EVIDENCE OF A CRACK AROUND FASTENER HOLE ON AFT SIDE. REPAIRED FRAME IAW PRI ERA 517647-14AD, REV ORIGINAL AND FINAL ERA 517647-14AD, REV ORIGINAL.SDR DALA13040733758Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN, FS 480, STR 8R, FRAME IS CRACKED AT PSU RAIL SUPPORT ANGLE MOUNT POINT. REPAIRED IAW PRI ERA 517647-14AD, REV ORIGINAL AND FINAL ERA 517647-14AD, REV ORIGINAL.SDR DALA13040723758Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN FS 480 BELOW S8L FRAME CRACKED AT INBD FASTENER HOLE ON AFT SIDE. REPAIRED IAW PRI ERA 517647-14AD, REV ORIGINAL AND FINAL ERA 517647-14AD, REV ORIGINAL.SDR DALA13040713758Frame · crackedDURING INSPECTION, FOUND PASSENGER CABIN, BS 500A, BELOW STR 8R, FRAME CRACKED AT PSU RAIL SUPPORT ANGLE MOUNT POINT. MX ACCOMPLISHED REPAIR TO FRAME IAW ERA 517647-14AD, REV, ORIGINAL AND FINAL 517647-14AD, REV ORIGINAL.SDR SWAA1944090119824Frame · crackedFRAME CRACKED AT BS 727A, STRINGER 8R. REPAIRED FRAME IAW ER & EA.SDR SWAA2013082219430Frame · crackedFRAME CRACKED AT BS 727B STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013082219429Frame · crackedFRAME CRACKED AT BS 867 STRINGER 8L. REPAIRED FRAME IAW EA.SDR ASOA20130819214Frame · corrodedDURING C-CHECK, FR 65 HAS CORROSION BETWEEN STR 16 - 17L. REPAIRED FR 65 IAW EC5310-01505. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013082619540Frame · crackedFRAME WEB CRACKED AT STATION 178 RBL 17.0. REPAIRED WEB IAW SRM.SDR SWAA2013082319458Frame · crackedFRAME CRACKED AT STATION 727B STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013082919691Frame · crackedFRAME CRACKED AT BS 360, STRINGER 8R. REPAIRED FRAME IAW ER & EA.SDR SWAA2013082719616Frame · crackedFRAME CRACKED AT BS 867, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082719615Frame · crackedFRAME CRACKED AT BS 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082719614Frame · crackedFRAME CRACKED AT BS 500A STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082719613Frame · crackedFRAME CRACKED AT BS 480 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082719612Frame · crackedFRAME CRACKED AT BS 440 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082719611Frame · crackedFRAME CRACKED AT BS 400 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082619489Frame · crackedFRAME CRACKED AT BS 827 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082619488Frame · crackedFRAME CRACKED AT BS 747 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013082619487Frame · crackedFRAME CRACKED AT BS 440 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013082219428Frame · crackedFRAME CRACKED AT BS 747 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013082219427Frame · crackedFRAME CRACKED AT BS 500A STRINGER 8L. REPAIRED FRAME IAW EA.SDR CALA2013081900576Frame · crackedFRAME AT BS 727B, BETWEEN STR 8 AND 9R SHOWS CRACK INDICATION AT THE INBD FASTENER HOLE OF THE AIR CONDITIONING OUTLET EXHAUST SUPPORT BRACKET FRAME 727B R HAS BEEN REPAIRED IAW ECRA 5310-05844.SDR CALA2013081900575Frame · crackedFRAME AT BS 440, BETWEEN STR 8 AND 9R SHOWS CRACK INDICATION AT THE INBD FASTENER HOLE OF THE AIR CONDITIONING OUTLET EXHAUST SUPPORT BRACKET FRAME 440 R HAS BEEN REPAIRED IAW ECRA 5310-05844.SDR CALA2013081900574Frame · crackedFRAME AT BS 380 BETWEEN STR 8 AND 9R SHOWS CRACK INDICATION AT THE INBD FASTENER HOLE OF THE AIR CONDITIONING OUTLET EXHAUST SUPPORT BRACKET FRAME 380 R HAS BEEN REPAIRED IAW ECRA 5310-05844.SDR KCSA201308160067Frame · damagedFORWARD CARGO BAY HAS A FRAME FLANGE DAMAGED AT BS 500 BETWEEN S37-38L.SDR FDEA201308161913Frame · crackedFUSELAGE FRAME 40, UPPER CORNER FOUND CRACK IN RT NR 2 HOLE COMPLIED WITH EA 6-5710-T0301577.SDR K11A2014052791703Frame · crackedFRAME STRUCTURE HAS TWO CRACKS AT STA 83 + 10 FROM CENTER VIEWED THROUGH LT WIPER MOTOR HOLE. ONE CRACK IN FLANGE RADIOUS ABOUT .5" & 1 CRACK AT FASTENERS 1 INCH LONG.SDR SWAA2013082319454Former · crackedFORMER CRACKED AT BS 1022 BETWEEN LONGERON 13L TO LONGERON 14L. R&R FORMER IAW SRM & DRAWING.SDR SWAA2013091920311Frame · damagedFRAME DAMAGED AT STATION 243.7 STRINGER 24L. REPAIRED FRAME IAW AAR EA & SWA EA.SDR SWAA2013091920310Frame · damagedFRAME DAMAGED AT STATION 235.8 STRINGER 24L.. R & R CHORD IAW AAR EA & SWA EA.SDR DALA13039399020Frame · crackedBS 1510 FRAME RT CRACKED. FRAME REPLACED IAW SRM 51-01.SDR DALA13039389020Frame · crackedBS 1510 FRAME CRACKED ON LT SIDE IN 3 LOCATIONS. FRAME REPLACED IAW SRM 51-01 AND DWG 9911843-698815.SDR FDEA201308141884Frame · corrodedAFT CARGO BAY BS 1580, S19R, FRAME INBD FLANGE CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 1. R & R FRAME IAW SRM 51-40-02, FROM SPLICE TO SPLICE AND DWG 146N1030. CAT "A" MAJOR REPAIR.SDR SWAA2013091020027Frame · crackedFRAME CRACKED AT STATION 947, STRINGER 19L. R&R FRAME IAW SRM.SDR FDEA201308131861Frame · crackedRIGHT FUSELAGE FRAME 45 FOUND CRACKED. REPAIRED IAW EA 6-5310-T0301727.SDR FDEA201308131860Frame · crackedRT FUSELAGE FRAME 44 FOUND CRACKED. REPAIRED IAW EA 6-5330-T0301676.SDR FDEA201308131859Frame · crackedRT FUSELAGE FRAME 43 FOUND CRACKED. REPAIRED IAW EA 6-5310-T0301727.SDR FDEA201308131858Frame · crackedLEFT FUSELAGE FRAME 45 FOUND CRACKED. REPAIRED IAW EA 6-5310-T0301727.SDR FDEA201308131857Frame · crackedLEFT FUSELAGE FRAME 44 FOUND CRACKED. REPAIRED IAW EA 6-5310-T0301727.SDR KCSA201308130066Frame · corrodedCORROSION FOUND AT BS 1920, RBL 55 ON AFT CHORD LWR LEG OF INNER FRAME.SDR SWAA2013090519872Frame · crackedSTUB FRAME CRACKED AT BS 947.5, BETWEEN STRINGER 15L TO STRINGER 17L. R&R FRAME IAW DRAWING SRM.SDR FDEA201308121842Frame · corrodedAFT WASTE TANK COMPARTMENT FRAME CORRODED AT BS 1997 FROM LONGERON 49L TO LONGERON 49R. REMOVED CORROSION IAW SRM 51-21-01 VOLII. REMOVED AND REPLACED EXISTING SPLICE IAW SRM 51-31-01 VOL II.SDR DALA1317316712Frame · dentedFWD CARGO FRAME DENTED AT BS 520 BETWEEN S24 & 25L. REPAIRED IAW ERA 515778-14, REV ORIG.SDR FDEA201308121840Frame · dentedAFT CARGO BAY LT SIDE AT BS 1400, STR 26L, FRAME DENTED. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 5. R & R FRAME IAW SRM 51-40-02 AND DWG 146N1011. MAJOR REPAIR.SDR IPXA3B79964Frame · crackedINSPECTION C, M/D RT BS 840, STR R11 TO R12 FRAME FOUND CRACK. REPAIRED BETWEEN STR 7R TO STR 12R AREA IAW RI-53-22-10294, REV A AND EO B747-5310-51858-A.SDR IPXA2013082300933Frame · crackedDURING C INSPECTION, MAIN DECK FRAME BS 840, S11-12L AFT FACE FOUND CRACKED. FRAME REPAIRED IAW RI-53-22-10294, REV A & EO B747-5310-51858-A. MAJOR REPAIR.SDR USAA2013083000018Frame · corrodedC4 CHECK, CORROSION WAS FOUND ON FUSELAGE FRAME AT BS 794, RBL 16. REPAIRED FRAME IAW SRM 51-40-02.SDR IPXA3B79974Frame · crackedINSPECTION C, M/D RT BS 840 TENSION TIE TO FRAME ATTACHMENT AREA THREE HOLES FOUND CRACKED AT FRAME. FRAME IS REPAIRED IAW HX RI RI-53-22-10294, REV A AND EO B747-5310-51858-A. MAJOR REPAIR.SDR FDEA201308091818Frame · corrodedAFT CARGO BAY RT SIDE FRAME HAS CORROSION AT UPPER FLANGE BETWEEN S26-27R. REPAIRED IAW EA F-5310-T0301728 PART 1. MAJOR REPAIR.
Back to JASC 5311