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 08FDEA00872Frame · crackedDURING MODIFICATION DC10 CARGO TO MD10 ACF, AT REMOVAL BRACKET IS NOTED CRACK 1.5 INCH LONG ON FRAME STA 1851 RT SIDE LONGERON 10 TO 11. PERFORMED REPAIR FOR EA FEDEX 8-5310-111515.SDR 08FDEA00845Frame · corrodedAFT PIT FUSELAGE FRAME HAS CORROSION ON THE WEB AT FRAME 65 BETWEEN STR 49L AND 50L. REMOVED CORROSION IAW SRM 51-74-10. CHECKED LIMITS IAW SRM 53-17-12. FOUND TO BE WITHIN LIMITS. ALODINED IAW SRM 51-21-10. PRIMED AND PAINTED BOTH IAW SRM 51-23-10. MINORSDR 08FDEA00841Frame · corrodedAFT PIT FUSELAGE FRAME HAS CORROSION ON THE WEB AT FRAME 67 ABOVE S49L. REMOVED CORROSION IAW SRM 51-74-10. CHECKED LIMITS IAW SRM 53-17-13. FOUND TO BE WITHIN LIMITS; ALODINED IAW SRM 51-21-10. PRIMED AND PAINTED BOTH IAW SRM 51-23-10. MINOR REPAIRSDR SWAA081321Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727E, STR 26L AND STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081320Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 26L AND STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081322Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 727D, STR 27L AND STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081330Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807 BETWEEN STR 26L AND STR 27R. REPAIRED FRAME PER SRM.SDR SWAA081319Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 26L AND STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081338Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081336Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081337Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA00846Frame · corrodedAFT PIT FUSELAGE FRAME WEB HAD CORROSION AT FRAME 66 BETWEEN STR 49L AND STR 50L. REPAIRED FUSELAGE FRAME 66 BETWEEN STRINGER 49L & STRINGER 50L IAW SRM 53-10-10; PARA 4.SDR 08FDEA00844Frame · corrodedAFT PIT FUSELAGE FRAME HAS CORROSION ON THE WEB AT FRAME 64 BETWEEN STR 49L AND 50L. REMOVED CORROSION IAW SRM 51-74-10. ORIGINAL MATERIAL 0.045; MATERIAL REMOVED 0.017, MATERIAL REMAINING 0.028. FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. FORMED ANGLE, HESDR 08FDEA00843Frame · corrodedAFT PIT FUSELAGE FRAME HAS CORROSION ON THE WEB AT FRAME 64 BETWEEN STR 49L AND 50L. REMOVED CORROSION IAW SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. FORMED ANGLE, HEAT TREATED ANGLE IAW TPS 1003; REV A. DRILLED UP PARTS; ALODINED, PRIMED SDR 08FDEA00842Frame · corrodedAFT PIT FUSELAGE FRAME HAS CORROSION ON THE WEB BETWEEN STR 49L AND STR 50L, FRAME 65. REMOVED CORROSION IAW SRM 51-74-10. CHECKED LIMITS IAW SRM 53-17-13 & FOUND TO BE OUT OF LIMITS IAW SRM 53-10-00. FORMED IAW SRM 51-26-00. REPAIR PARTS HEAT TREATED. REPASDR 08FDEA00809Frame · corrodedCENTER CARGO COMPARTMENT DOOR LOWER TORQ BOX AFT LIGHTENING HOLE FWD INBOARD FRAME IS CORRODED REMOVED AND REPLACED FRAME IAW SRM 53-30-00 FIG 2. CUT AND REMOVED FLOORBEAM AND FRAME FOR ACCESS AND REINSTALLED AND REPAIRED IAW SRM 51-33-01 AND 53-30-00.SDR KCSA081163Frame · corrodedBS 2200 FUSELAGE FRAME LOWER CHORD CORRODED ABOVE STR 42L, LBL 33.SDR UPS08B53480Frame · crackedINSPECTION TYPE:BCF RT STA 1140 TENSION TIE FRAME 1EA FASTENER HOLE CRACKED MORE THAN 0.0 30". REPAIRED CRACKED TENSION TIE FRAME AS PER SRM 53-40-07.SDR 08FDEA00795Frame · corrodedMAIN BODY FRAME ASSY CORRODED, BS 1166, STR 17L, WL 208. REMOVED CORROSION FROM BS 1166, S17L FRAME AND FOUND TO BE OUT OF LIMITS, REMOVED FRAME AND INSTALLED. REFERENCE SRM 51-30-2. CLASSIFIED AS MAJOR REAIRSDR KCSA081154Frame · corrodedUPPER CHORD AT STA 2200 FRAME CORRODED LBL 4 TO LBL 50.SDR DLM90080454Frame · gougedBS 1364 FROM LONG. 28R TO 24L THERE IS EDGE DAMAGE FROM FLOORBOARD FASTENERS (AFT CARGO BAY UNDERNEATH AFT BULKHEAD). BLENDED GOUGES, CHECKED LIMITS. OUT OF LIMITS IN SEVERAL PLACES. REMOVED SECT. OF FRAME, SPLICED NEW SECT. IN IAW MD90 SRM 51-10-10, 53-00-01SDR CALA0800212Frame · crackedFRAME CRACKED STA 400 AT S-9R. INTERIM REPAIR PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR CALA0800211Frame · crackedFUSELAGE FRAME CRACKED AT BRACKET MOUNT BETWEEN STR 8 AND 9 LT AT STA 747. INTERIM REPAIRED PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR CALA0800210Frame · crackedFUSELAGE FRAME CRACKED BETWEEN STR 8 AND 9 LT AT STA 787. INTERIM REPAIRED PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR 2008UALA01258Frame · crackedFWD PIT FRAME WEB CRACKED AT BS 456 LBL 28. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED NEW WEB.SDR CALA0800208Frame · crackedFRAME CRACKED STA 867 ABOVE S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800207Frame · crackedFRAME CRACKED STA 787 ABOVE S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800206Frame · crackedFRAME CRACKED STA 747 ABOVE S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800205Frame · crackedFRAME CRACKED STA 727B ABOVE S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800204Frame · crackedFRAME CRACKED STA 482 BETWEEN S9L AND S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800203Frame · crackedFRAME CRACKED STA 400 BETWEEN S8R AND S9R. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800201Frame · crackedFRAME CRACKED STA 787 ABOVE S9R. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800200Frame · crackedFRAME CRACKED STA 747 ABOVE S9R. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800199Frame · crackedFRAME CRACKED STA 440 BETWEEN S8R AND S9R. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR CALA0800198Frame · crackedFRAME CRACKED STA 400 BETWEEN S8L AND S9L. FABRICATED AND INSTALLED REPAIR ANGLES PER ECRA 5310-04727 REV A.SDR SWAA081265Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT RT BS 616. REPAIRED FRAME CHORD PER SRM.SDR KCSA081141Frame · corrodedSTA-2200 HAS CORROSION ON FRAME WEB LBL-40 FWD OF LEFT OUT FLOW VALVE.SDR SWAA081259Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 28L. REPAIRED FRAME PER SRM.SDR SWAA081247Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081257Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081258Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081245Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081246Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482B, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0800195Frame · crackedFRAME CRACKED AT STA 360 BETWEEN STRINGER 8L AND 9L. TRIMMED OUT CRACKED AREA ON FRAME AND INSTALLED REPAIR DOUBLERS PER ECRA 5310-04728. REPLACED INTERCOSTAL CLIP AT STA 360 STRINGER 8L PER ECRA 5310-04728.SDR USAA920080613Frame · corrodedCLT - MAJOR REPAIR - C17 CHECK - LEVEL 2 CORROSION ON FRAME, BS 794.5, RBL 13.80. REPAIRED FRAME, BS 794.5, RBL 13.80 IAW B737 SRM 51-70-11.SDR SWAA081236Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 12L. REPAIRED FRAME PER SRM.SDR SWAA081224Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0800194Frame · crackedFOUND CRACK AROUND HI-LOK HOLE AT STA 188 LBL 10. FABRICATED AND INSTALLED REPAIR PER ECRA 5311-01397.SDR 08FDEA00686Frame · corrodedFWD CARGO COMPT AT FR 36 AT RBL 29 FRAME CROSSBEAM IS CORRODED UNDER AND AROUND NUTPLATE. REMOVED CORROSION IAW SRM 51-74-10. BLENDED AREA FOUND TO BE OUT OF LIMITS. REMOVED CENTER GUIDE; ROLLER TRAY AND LATERIAL WEB TO FOM IAW SRM 51-40-21. WEIGH DAMAGSDR KCSA081134Frame · crackedFUSELAGE FRAME CRACKED IN AFT PIT AT BS 1620, LBL-82.
Back to JASC 5311