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 2005UALA00319Frame · dentedAFT CARGO FRAME STA 1520 AT STR 25L, FRAME IS DENTED. FRAME DENT WAS CUTOUT AND A DOUBLER REPAIR WAS INSTALLED.SDR 2005UALA00318Frame · dentedAFT CARGO FRAME STA 1540, NEAR STR 26L, FRAME DENTED. FRAME DENT WAS CUTOUT AND A DOUBLER REPAIR WAS INSTALLED.SDR UPS05444395Frame · crackedBS 160 S14BL - 14CL FRAME INNER FLANGE FOUND CRACKED, CRACK LENGTH .25 INCH. BS 160 STR 14BL TO STR 14CL FRAME INNER FLANGE REPAIRED AS PER HX RS R-53-12-35288 AND UPS EO NR B747-5310-22088-A.SDR UPS05444394Frame · crackedBS 200 S13AL TO S14L FRAME FOUND CRACKED, CRACK LENGTH .750 INCH. M/DECK BS 200 BETWEEN STR 13AL TO STR 14AL FRAME REPAIRED AS PER HX RS R-53-12-35289 AND UPS EO NR B747-5310-22089-A.SDR UPS05444387Frame · crackedBS 320 S24 L - S26L, FRAME FOUND CRACKED, CRACK LENGTH 2.5 INCH. FRAME REPAIRED AS PER HX RS R53-12-35287 AND UPS EO NR B747-5310-22087-A.SDR UPS05444338Frame · crackedINSPECTION TYPE: C, M/D BS 240 STR 14L TO STR 14CL FRAME FOUND CRACKED. ( CRACK LENGTH 1.5" ) M/D BS 240 STR 14L TO STR 14CL FRAME REPAIRED AS PER SRM 53-10-04 FIG 11.SDR C1HA200595006Frame · corrodedE & E COMPT STA 320 RBL 17 FRAME LOWER END HAS CORROSION. EGG NEW FLOOR & CLEAR TIE AT FS 320 RBL 17 7075-0 PO 0420685 H/T TO T-6 ON PEMCO TRAVELER 795N000486. LOCATED, TRIMMED, DRILLED, TREATED & INSTALLED IAW 727 SRM 51-10-2 & 51-30-2 SPLICED NEW FRAME.SDR UPS05444397Frame · crackedNR 1 LT MED CUTOUT BS 488 FRAME AT STR 25L INNER CHORD TWO FASTENER HOLES FOUND CRACKED AND AS MARKED, CRACK LENGTH 1/8 INCH. NR 1 MED LT BS 488 INNER CHORD REPLACED AS PER SB 747-53-2272 AND DWG 624U0003 SHT 40A.SDR 72300154Frame · corrodedA 4 X 1 INCH AREA OF CORROSION ON FRAME WEB.SDR 72300153Frame · damagedDAMAGED FASTENER HOLES IN UPPER CHORD.SDR UPS05444427Frame · crackedNR 1 L MED CUTOUT BS 488 FRAME WEB FOUND CRACK AT DOOR STOP NR 1 AREA APPROX 0.5" LONG EXTEND BEYOND DOOR STOP SUPPORT FTG. CRACK LENGTH 1/2 INCH. M/D NR 1L MED CUTOUT BS 488 FRAME WEB REPAIRED BETWEEN STR 23 TO STR 30 AS PER SRM 53-10-04 FIG 92.SDR UPS05444403Frame · crackedNR 1R MED CUTOUT BS 488 FRAME AT DOOR STOP NR 1 AREA FOUND CRACK AT FRAME FWD DOUBLER 1/2 INCH LONG EXTEND BEYOND DOOR STOP FTG AND CRACK AT WEB 1 EA HOLE APPROX 1/16 INCH LONG. CRACK LENGTH 1/4 INCH AT DOUBLER, 1/16 INCH AT WEB. M/DECK NR 1R MED CUTOUT BS48SDR UPS05444414Frame · crackedBS 1265 STR -26R FRAME BELOW DOOR LOWER SILL FASTENER HOLE FOUND CRACKED AT FRAME WEB RUNNING I/B AND O/B (CRACK LENGTH 1/16 INCH), BS 1265 RT FRAME WEB INTERIM REPAIRED AS PER DWG 624U0060.SDR UPS05444413Frame · crackedBS 1265 STR -26L FRAME BELOW DOOR LOWER SILL FASTENER HOLE FOUND CRACKED AT FRAME WEB RUNNING I/B AND O/B AND FOUND FRAME WEB EDGE CRACKED (CRACK LENGTH 1/16 INCH) BS 1265 LT FRAME WEB INTERIM REPAIRED AS PER DWG 624U0060.SDR 2005UALA00308Frame · dentedAFT PIT STA 1580 AT STR 26L FRAME DENTED. FRAME DENT DAMAGE WAS TRIMMED AND A DOUBLER REPAIR WAS INSTALLED.SDR ASAA0510040Frame · crackedYXX - FWD CARGO BSTA 480 FRAME CRACKED NEAR STR 22L. FRAME REPAIRED IAW SRM. (K)SDR USAA050452Frame · brokenCLT - FOUND FORMER BROKEN, STATION 535 WL 165, LBL 60. REPLACED FORMER. (M)SDR 72300143Frame · crackedA .75 INCH CRACK ON LOWER FRAME ATTACH FLANGE OF WEB.SDR 72300142Frame · crackedA 1 INCH CRACK ON FRAME VERTICAL WEB BY FASTENER LOCATION.SDR ABXA050229Frame · crackedCENTER OVER WHEEL WELL MAIN FRAME RIGHT SIDE IN WHEEL WELL, HAD CRACK EXTENDING INTO TWO EACH FASTENERS. MAIN FRAME NEEDED REPLACED PER SERVICE BULLETIN DC9-53-100. MAIN FRAME REPLACED ON EA 53400324-001-2.SDR EIA2005081Frame · crackedCABIN BS 690 LT BETWEEN STR 23L TO 24L FRAME UPPER FLANGE FOUND CRACKED. CRACKED FRAME REPAIRED PER SRM 53-10-04 FIG 4.SDR EIA2005079Frame · crackedM/D BS 320 S15L FRAME CRACKED AT STRINGER CUTOUT. FRAME REPAIRED PER SRM 51-40-03 FIG 1.SDR EIA2005078Frame · crackedM/D BS 320 LEFT S14E FRAME CRACKED AT STRINGER CUTOUT. FRAME REPLACED PER SRM 51-40-03 FIG 1.SDR VTZA200500034Frame · crackedRIGHT FS 640 FRAME DOUBLER IS CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR VTZA200500039Frame · crackedLEFT FS 640 FRAME DOUBLER IS CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR 05FDEA00750Frame · corrodedAREA BEHIND AFT CARGO COMPARTMENT FRAME 77 LEFT SIDE APPROX STR 49L STR HAS 5 SQ INCHES OF CORROSION. REMOVED CORROSION AT FRAME 77 FOUND TO BE OUT OF LIMITS IAW A310-200 SRM 53-10-00 FIG 104 TABLE 102. REMOVED AND REPLACED STRINGER SECTION WITH NEW 48L FR SDR COMA0560215Frame · crackedLEFT HAND 640 FRAME CRACKED. REPAIRED IAW CRJ SRM 51-42-06, 51-42-21, 51-23-00, 51-25-06 AND 51-25-16.SDR COMA0560214Frame · crackedRIGHT HAND 640 FRAME CRACKED. REPAIRED IAW SRM 51-42-06, 51-42-21, 51-23-00, 51-25-06 AND 51-25-16.SDR ASAA0540204Frame · corrodedFWD CARGO BAY, CORROSION ON FRAME AT BSTA 500C, WL 148, LBL 5 TO RBL 5. REPAIRED FRAME IAW SRM. (K)SDR EIA2005075Frame · crackedM/D BS 340 FRAME CRACKED AT STRINGER S15R CUTOUT. FRAME REPAIRED PER SRM 51-40-03 FIG 1 AT M/D BS 340 RT FRAME STRINGER 15R.SDR EIA2005073Frame · crackedM/D BS 260 S-23R LOWER FRAME CRACKED. FRAME REPAIRED PER SRM 53-10-04 FIG 4.SDR EIA2005072Frame · crackedM/D BS 600 FRAME BETWEEN S24L & 25L FOUND CRACKED. FRAME REPAIRED PER SRM 53-10-04.SDR 20030828Frame · crackedDURING ROUTINE INSPECTION, A .55 INCH CRACK WAS FOUND ON THE INTERCOSTAL FRAME FLANGE AT FS 498.25 BELOW STRINGER 2L. CRACK WAS REPAIRED IAW WITH EO. AIRCRAFT RETURNED TO SERVICE.SDR 20030827Frame · crackedDURING ROUTINE INSPECTION, A .63 INCH CRACK WAS FOUND ON THE INTERCOSTAL FRAME FLANGE AT FS 482.75 BELOW STRINGER 2L. CRACK WAS REPAIRED IAW WITH EO. AIRCRAFT RETURNED TO SERVICE.SDR SWAA050963Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, BL 0. REPAIRED FRAME PER SRM.SDR 2005UALA00272Frame · crackedSTA 616 FRAME IS CRACKED BELOW STR 17L. MAJOR REPAIR ACCOMPLISHED. TRIMMED DAMAGE AND INSTALLED REPAIR ANGLE.SDR DHL2005740560Frame · dentedFRAME BS540 SHOW DENT BTW STR16R AND 17R PREVIOUS FRAME REPAIR. REMOVED PREVIOUS REPAIR AT FS FRAME BS 540 BTW 16R AND 17R IAW B727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT USED 7075 T6 .071 PO NR 9001737 DIMENSION 6" BY 5" IAW B727 SRM 53-10-2 FIG 3 ANDSDR DHL2005740551Frame · damagedREMOVED PREVIOUS REPAIR AT FUSELAGE FRAME BS 600 BTW 16R AND 17R IAW B727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT USED 7075T6 .071 PO 9001737 DIM 6" BY 5" IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. ALODINED AND PRIMED PART AND AREA IAW B727 SRM 51-10SDR DHL2005740545Frame · dentedFUSELAGE FRAME AT STA 520 SHOW DENT BTW STR 16R AND 17R PREVIOUS REPAIR. REMOVED PREVIOUS REPAIR AT BS 520 BTW STR16R AND 17R IAW B727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT USED 7075T6 .071 PO NR 9001737 DIMENSION 8" BY 5" IAW B727 SRM 53- SRM 10-2 FISDR DHL2005740547Frame · damagedFRAME BS 640 SHOW DENT BETWEEN STR 16R AND 17R PREVIOUS FRAME REPAIR. REMOVED PREVIOUS REPAIR AT FUSELAGE FRAME BS 640 BETWEEN STR 16R AND 17R IAW B727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT. USED 7075T6 .071 PO NR 9001737 DIM 7" BY 5" IAW B727 SRM 53-SDR DHL2005740546Frame · damagedREMOVED PREVIOUS REPAIR AT FS AT 560 BTW 16R AND 17R IAW B 727 SRM 51-30-2. FABRICATED NEW FRAME REPAIR MAT USED 7075T6 .071 PO 9001737 DIM 6" BY 5" IAW B727 SRM 53-10-2 FIG 3 AND 51-40-3 FIG 1. ALODINED AND PRIMED PART AND AREA IAW B727 SRM 51-10-3. INSTALSDR DHL2005740540Frame · damagedCABIN INTERIOR FRAME AT BS348 IS BENT AND ELONGATED HOLES BETWEEN STR 4L - 6L. PREVIOUS FRAME REPAIR. REMOVED ANGLE SUPPORT IAW B727 SRM 51-30-2, DUE TO ELONGATED HOLES, CUT OUT DAMAGED AREA DIM .50 INCH EDGE UPPER AND LOWER FRAME IAW B727 SRM 51-10-1 AND DWSDR DHL2005740519Frame · corrodedFRAME BS 720C STR 28 LT AND STR 28 RT FOUND AFTER REMOVING SEALANT (CORROSION) TO BE OUT OF LIMITS IAW B727 SRM 53-10-1 FIG 1. REMOVED LOWER SECTION OF FRAME BS 720C BETWEEN STR 28L TO 28R IAW B727 SRM 51-40-3 FIG 1. EVALUATED LOWER SKIN SECTION OK, NO DAMAGSDR DHL2005740509Frame · dentedCABIN INTERIOR FRAME AT BS 360 IS DENTED BETWEEN ST4R AND 5R PREVIOUS FRAME REPAIR. REMOVED ANGLE SUPPORT DUE TO DENT IAW B727 SRM 51-30-2. LOCATED AND DRIILED NEW ANGLE P/N AE 727-2-360-11 PO507998 AND DOUBLER AE 727-2-360-12 PO5080133. TREATED AND PRIMED SDR EIA2005046Frame · crackedM/D BS 2235 FRAME AT STR 22R I/B WEB FOUND CRACKED. FRAME WEB REPAIRED PER SRM 53-10-04 FIG 34.SDR EIA2005045Frame · crackedM/D BS 540 FRAME AT STR 25L FOUND CRACKED. FRAME REPAIRED PER SRM 53-10-04 FIG 35.SDR EIA2005044Frame · crackedAFT OF BULK CARGO COMPT RT 2200 FRAME IN BETWEEN STR 42 & STR 44 FOUND CRACKED. FRAME REPLACED PER SB 747-53-2302.SDR EIA2005043Frame · crackedM/D BS 1713 STR-13L FRAME CRACKED. CRACKED FRAME REPLACED PER SRM 51-10-01.SDR 0500469954Frame · corrodedDURING M-CHECK FOUND CORROSION ON FRAME AT BS 996. REPAIRED PER EA 99-203328.SDR SWAA050949Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FUSELAGE FRAME AT BS 794, RBL 14, WL 156. REPAIRED FRAME PER SRM.
Back to JASC 5311