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 FDEA201211043827Frame · damagedFRAME BS 1620, S5L TO S5R HAS DOUBLE DRILLED AND ELONGATED FASTENER HOLES. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, SHEET 2, DETAIL 1, REPAIR 3. MAJOR REPAIR.SDR FDEA201211043826Frame · damagedBS 418, FRAME BETWEEN STR 5L AND STR 4R DAMAGED. FRAME REPAIRED IAW EA 757-5312-16-F3926, REV, MAJOR REPAIR.SDR FDEA201211043825Frame · damagedFRAME STA 1560, BETWEEN S5L AND S5R HAS DOUBLE DRILLED AND ELONGATED FASTENER HOLES. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3. MAJOR REPAIR.SDR FDEA201211043824Frame · damagedFRAME BS 1540, S3R -S6L, HAS DOUBLE DRILLED AND ELONGATED FASTENER HOLES. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3. MAJOR REPAIR.SDR FDEA201211043823Frame · damagedFRAME BS 1520 BETWEEN S4L-S4R HAS DOUBLE DRILLED AND ELONGATED FASTENER HOLES AT BS 1520, FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3.SDR FDEA201211043822Frame · damagedFRAME BS 1260 S4L- 4R HAS DOUBLE DRILLED AND ELONGATED HOLES. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3.SDR YENA20121104633Frame · corrodedFLT 6403 JFK-BNA, ON HEAVY MAINTENANCE CHECK FOUND CORROSION ON FRAME 17 AS MARKED P/N 170-21769-403. PERMANENT REPAIR ACCOMPLISHED ON CROSS BEAM FRAME 17 RBL 16 TO RBL 45. REMOVED CORROSION BY BLEND OUT / CUT OUT. PERFORMED HFEC INSPECTION, INSTALLED REINFSDR SWAA2012111509492Frame · corrodedCORROSION ON FRAME LOCATED AT BS 330.62 BETWEEN STR 27L TO STR 28L E/E COMPARTMENT. PERFORMED REPAIR ON FRAME LOCATED ON BS 330.62 BETWEEN STR 27L TO STR 28L E/E COMP AS PER SRM B737- 300 53-00-07-2R-5 FOR INSPECTION REQUIREMENT SEE TLD S/N T0303.SDR SWAA2012111409320Frame · corrodedFRAME CORRODED AT BS 328, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA2012113010076Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 907 STR 8-9R. REPAIRED FRAME CRACKED A/C BRACKET ATTACHMENT BS 907 STR 8-9R IAW ER 12-03470 & EA 1-753-21111 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012113010075Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 907 STR 8-9R. REPAIRED FRAME CRACKED A/C BRACKET ATTACHMENT BS 907 STR 8-9R IAW ER 12-03470 & EA 1-753-21111.SDR SWAA2012113010074Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 360 STR 8-9R. REPAIRED FUSELAGE FRAME CRACKED AT AIR CONDTIONING BRACKET ATTACHMENT BS 360 STR 8-9R IAW ER 12-03469 & EA 1-753-21001.SDR SWAA2012112009661Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS500C STR8-9L. WORK ACCOMPLISHED PER EA# 1-A53-12114 REV 2.SDR SWAA2012111509519Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 867 STR 8-9R. REPAIRED FRAME AT BS 867 STR 8-9R IAW EA 1-A53-12114.SDR SWAA2012111209252Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209251Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209250Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR DALA1253650680Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE BS 1400 BETWEEN STR 25 AND 26L. REPAIRED IAW SRM53-00-07.SDR CALA2012110200741Frame · damagedAFT CARGO HAS DAMAGE TO TOP SIDE OF THE FRAME AT BS 947.5 AND RBL 20. FRAME REPAIRED IAW ECRA 5311-01568.SDR SIMA20121101013Frame · crackedFRAME 23 CRACKED BETWEEN S15 AND 16R. REPAIRED FRAME IAW EO EM-53MR-1808.SDR SWAA2012113010073Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE AT PSU RAIL SUPPORT BS 827 STR 8R - 9R. REPAIRED FRAME CRACKED AT I/B FASTENER HOLE OF PSU RAIL SUPPORT BS 827 STR 8R - 9R IAW ER 12-03535 & EA 1-753-21112.SDR SWAA2012113010072Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE AT PSU RAIL SUPPORT BS 827 STR 8R - 9R. REPAIRED FRAME CRACKED AT I/B FASTENER HOLE OF PSU RAIL SUPPORT BS 827 STR 8R - 9R IAW ER 12-03535 & EA 1-753-21112 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012112009663Frame · buckledBS 188 LOWER FRAME WEB BUCKLED AT RBL 11, AT INBD CHORD. REMOVED AND REPLACED BS 188 LOWER FRAME WEB PER SRM 51-10-02 AND SRM 51-40-02.SDR SWAA2012111909580Frame · crackedCRACK ON FRAME OF BS 344 AND AT LEVEL STR 22L IN E/E COMPARTMENT. REPLACED FRAME OF BS 344 AND AT LEVEL STR 22L IN E/E COMPARTMENT IAW B737-300 SRM 51-10-02 AND DRAWING #65-45815, SRM 51-40-02.SDR SWAA2012111509517Frame · crackedFRAME CRACKED AT I/B FASTENER HOLE AT PSU RAIL SUPPORT BS 787 STR 8R - 9R. REPAIRED CRACKED FRAME BS 787 STR 8-9 RT IAW EA 1-A53-12114.SDR SWAA2012111209248Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012111209247Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209246Frame · crackedFRAME CRACKED AT BS 500A, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012111209245Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012111209244Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012111209243Frame · crackedFRAME CRACKED AT BS 500A, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209242Frame · crackedFRAME CRACKED AT BS 440, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209241Frame · crackedFRAME CRACKED AT BS 747, STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209240Frame · crackedFRAME CRACKED AT BS 727D, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2012111209214Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2012110809179Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR CALA2012110200737Frame · damagedFRAME DAMAGED AT BS 1340 S26L. REPAIRED IAW EC/RA 5310-04505.SDR CALA2012110200736Frame · damagedBS 1320, FRAME DAMAGED. REPAIRED IAW ECRA 5310-04508.SDR CALA2012110200726Frame · damagedFUSELAGE FRAME BS 205.59 DAMAGED. REWORKED FRAME, INSPECTED AND FOUND NO CRACKS, AND INSTALLED A REPAIR ANGLE DOUBLER REF. ECRA 5310-04640 REV A, PART 1.SDR CALA2012110100708Frame · crackedFRAME CRACKED BS 1380. REPAIRED IAW EC/RA 5310-04506.SDR AALA20121108004Frame · corrodedTHE BELLFRAME CORRODED AT STATION 1660 BETWEEN STRINGERS 29 AND 28 RIGHT. INSTALLED BELLFRAME REPAIR PER EA B757-53-026955.SDR AALA20121103003Frame · corrodedSTATION 1219 CARGO FLOOR INNER J FRAME CORRODED. INSTALLED REPAIR STRAP PER SRM 53-00-07-2R.SDR FDEA201210313790Frame · misrepairedFUSELAGE FRAME AT BS 760, STR 24-26R, MISREPAIRED. REPLACED FRAME PER DRAWING 143N1018. THIS REPAIR IS A CATEGORY A, MAJOR.SDR DALA12011985651Frame · damagedFUSELAGE FRAME DAMAGED AT BS 520, S-24L TO S-25L.SDR CALA2012103100700Frame · crackedFRAME CRACKED STA 827 AT S-9L. REPAIRED FRAME IAW ECRA 5310-04817.SDR CALA2012103100699Frame · crackedFRAME CRACKED STA 827 AT S-9R. INSTALLED AN INTERIM REPAIR IAW ECRA 5310-04817.SDR CALA2012103100697Frame · dentedAFT CARGO BELT FRAME DENTED AT BS 1300 AND S26R PERFORMED INTERIM REPAIR REF EC/RA 5360-01127.SDR CALA2012103100691Frame · crackedBS 360 FRAME CRACKED AT AFT BRACKET BETWEEN S8 AND S9L. TRIMMED DAMAGED AREA & REPAIRED FRAME IAW EA5310-04498.SDR UALA2012103106265Frame · corrodedAFT PIT BS 1460 LBL 15 TO RBL 5 WL 138 FRAME HAVE CORROSION ON BOTH FWD AND AFT SIDE. REMOVED CORROSION, MATERIAL LOSS FOUND TO BE EXCEEDING SRM 53-00-07 LIMITS. FABRICATED & INSTALLED NEW FRAME PER SRM AND BOEING DWG 146N1014.SDR CALA2012110600749Frame · damagedFRAME HAS HOLES ELONGATED AT BS 188, RBL 17.1. REPAIRED IAW ECRA 5311-01478. INITIATED DIP TO READ "FOR STA 18 8 LWR FRAME WEB REPAIR ACCOMPLINS INSP OF REP BEFORE ACCUM OF 7 3.139 FLT CYCLES IAW PT 2 OF ECRA 5311-01478. PLANNING TO CONT ENG AFTER ACCUM OF 66
Back to JASC 5311