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 SWAA075963Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075950Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075951Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075952Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075962Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075961Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075949Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075948Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075946Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075943Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075944Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075945Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075956Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER ER.SDR DHL2007793026Frame · dentedAFT CARGO COMPARTMENT FRAME AT STATION 1090 UPPER FLANGE IS DENTED BETWEEN STRINGER 27L TO 26L. CUT OUT DAMAGE AREA AT AFT CARGO COMPARTMENT FRAME STATION 1090 BETWEEN STRINGER 27L TO 26L IAW B-727 SRM 51-40-3 FIGURE 1 DIMENSION CUT OUT .75" BY .75". FABRICASDR DHL2007793025Frame · dentedAFT CARGO COMPARTMENT FRAME AT FS 1110 UPPER FLANGE IS DENTED BETWEEN STRINGER 27L AND 26L. CUT OUT DAMAGED IAW SRM 51-40-3 FIGURE 1. FABRICATED REPAIR FRAME IAW SRM 51-40-3 FIGURE 1 AND 53-10-2 FIGURE 5. HEAT TREATED PART IAW NR FAS0115 REV 11. TREATED ANSDR DHL2007793024Frame · dentedAFT CARGO COMPARTMENT FRAME AT STATION 1110 UPPER FLANGE IS DENTED BETWEEN STRINGER 27R AND 26R. CUT OUT DAMAGE AREA AT AFT CARGO COMPARTMENT FS 1110 UPPER FLANGE IAW SRM 51-40-3 FIGURE 1. FABRICATED REPAIR IAW SRM 51-40-3 FIGURE 1 AND 53-10-2 FIGURE 5. HEASDR 2007UALA04915Frame · damagedFUSELAGE FRAME OUT OF LIMITS AT BS 740 STR 27L. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR ASAA0782295Frame · crackedAFT A C BAY FRAME 1418 CRACKED AT LONGERON 2 RIGHT REPAIRED AFT A C BAY FRAME 1418 IAW MD80 SRM 53 03 FIG 31A. STOP DRILLED CRACK, INSTALLED REPAIR ANGLES. LOCATED AND DRILLED 2 EACH 37 AND 1 EA 35. REPAIR ANGLES AND STRAP INSTALLED PER FIG 31A.SDR CALA0700724Frame · crackedSTA 320 BETWEEN S-20L AND 2-21L CRACK IN FRAME. CUTOUT DAMAGED AREA, INSTALLED REPAIR DOUBLER AND FILLER REF SRM 51-70-11.SDR USAA920080073Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3R. REPAIRED FRAME, BS 663, S3R IAW USAIRWAYS EA 100069.SDR USAA920080071Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3L. REPAIRED FRAME, BS 663, S3L IAW USAIRWAYS EA 100069.SDR USAA920080070Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3R. REPAIRED FRAME, BS 663, S3R IAW USAIRWAYS EA 100069.SDR USAA920080069Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S1. REPAIRED FRAME, BS 663, S1 IAW USAIRWAYS EA 100069.SDR SIMA200733901Frame · corrodedDURING MBV, THE FRAME AT FS 258.0 WAS FOUND TO BE CORRODED. REPAIRED FRAME AT FS 258.0 PER SAAB SRM (72LKS 3079 REV 49) CHAPTER 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR USAA920071274Frame · crackedCLT - MAJOR REPAIR -C-18- NR I1D25012, CRACK ON FRAME AT BS 291.5 - 294.5, S17L. REPAIRED IAW BOEING DWG 69-37402, SRM 51-10-02.SDR TRAX200701835Frame · corrodedFR 23B FOUND CORRODED OUT OF LIMIT ON W/C 100-15 NEEDS SPLICE PART TO BE FABRICATED, RESOLVED ON W/O: 75891 TASKCARD: N/R-00651. FABRICATION SPLICE PARTS ON FRAME 23B IAW SRM 53-00-00 FIG 430 (SHEET 1). INSTALLATION COVER ON W/C 100-15.SDR 2007UALA04883Frame · corrodedFRAME CORRODED ON FWD AND AFT SIDE OF BS 380 AND ON SKIN ADJACENT TO FWD SIDE OF FRAME, IN FWD PIT BILGE RBL 2"- LBL 2". MAJOR REPAIR: REMOVED CORROSION AND ACCOMPLISHED REPAIR.SDR ASAA0782290Frame · crackedFUSELAGE FRAME STA 1418 FROM LONGERON 5L TO 5R FAILSAFE CHORD IS CRACKED. REMOVED CRACKED CHORD RECEIVED DRILLED AND INSTALLED NEW CHORD IAW MD80 SRM 51-10-4, 51-30-5.SDR SWAA075923Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075918Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075917Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075916Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075924Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075915Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0700718Frame · crackedCABIN STA 907 BETWEEN LT S8 AND S9 FRAME CRACKED WHERE IT ATTACHED TO PSU RAIL SUPPORT. INSTALLED DOUBLERS PER ECRA 5310-04677.SDR CALA0700717Frame · crackedCABIN STA 867 BETWEEN S8 AND S9 FRAME CRACKED AT BRACKET ATTACH TO PSU, OUT RAIL LT SIDE. INSTALLED DOUBLER PER ECRA 5310-04677.SDR CALA0700716Frame · crackedCABIN STA 787 BETWEEN LT S8 AND S9 FRAME CRACKED AT BRACKET ATTACHED TO PSU MOUNT RAIL MARKED. INSTALLED DOUBLERS PER ECRA 5310-04677.SDR HNAA0800080Frame · crackedFRAME CRACKED. REPAIRED IAW EO8-53-07-3450.SDR HNAA0800079Frame · crackedFRAME CRACKED. REPAIRED IAW SRM 53-20-21.SDR 08FDEA00001Frame · crackedLT MLG, L/G MAIN DOOR LEANING WITH WEB FWD CRACKED WEB OF FRAME 48. REPAIRED IAW FEDEX EA NR 6-5320-115304.SDR SWAA075901Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075902Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR TRAX200701787Frame · corrodedFOUND FR 23B CORRODED ON LWR FLANGE BTW STR 21L-21R. FR 23B ON LWR FLANGE BTW STR 21L - 21R CORROSION IS REMOVED IAW SRM 51-21-42 AND FOUND OUT OF LIMITS SRM 53-51-00 U/T PERFORMED BY HEATHAIR AMO46-90 W/O 37934 IAW NTM MIN = 0.035" FRAME 23B ON LWR FLANGE BTSDR CALA0700704Frame · crackedMAIN FRAME CRACKED STA 616 LT JUST BELOW MAIN DECK FLOOR INSTALLED STIFFENING ANGLE AND FILLER PER ECRA 5311-01158.SDR CALA0700703Frame · crackedRIGHT MAIN FRAME CRACKED STA 616 JUST BELOW MAIN DECK FLOOR INSTALLED STIFFENING ANGLE AND FILLER PER ECRA 5311-01158.SDR SWAA075883Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075885Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075884Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075880Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075881Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311