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 WRNA20080028Frame · damagedDURING B CHECK, FOUND MISSING FASTENER AND ELONGATED HOLE RIGHT SIDE OF FRAME AND INTERCOSTAL AT STATION 2662 W/L 305. FABRICATED REPAIR DOUBLER IAW SRM 51-40-03 FIGURE 01 AND INSTALLED DOUBLER IAW SRM 51-30-02.SDR TRAX200800349Frame · corrodedCORROSION DAMAGE IN MAIN AVIONICS BAY BETWEEN FS 295.00 AND 310.00 FRAMES (MARKED). BLENDED CORROSION ON FS 295 FRAME IN LIMITS, .047 MATERIAL REMAINING IAW CRJ 700 SRM 53-21-06. SUPPLEMENTAL SDR CLOSED 3/7/08.
SDR QXEA200800259Frame · corrodedPDX - C4 - RIGHT FRAME CASTELLATION AT STATION 449.5 AND STRINGER 24S HAS CORROSION AROUND RIVET. REMOVED RIVET AT LOCATION AND CORROSION. INSTALLED RIVET IAW DASH 8 Q400 SRM 51-21-00, 51-42-05 AND 51-25-25.SDR QXEA200800254Frame · corrodedPDX - C4 - RIGHT SIDE FRAME CASTELLATION (SKIN LEG), AT STATION X234.4 AND BETWEEN STRINGER 24S AND 25S HAS CORROSION AROUND RIVET. REPAIRED IAW DASH 8 Q400 SRM 51-42-05, 51-21-00, 51-21-10, 51-25-15, AND Q400 NDTM PART 1 51-00-04 AND PART 6 51-00-01.SDR QXEA200800262Frame · corrodedPDX - C4 - MCD THRESHOLD FLOOR SUPPORT STRUCTURE FRAME CASTELLATION IS CORRODED (STATION X27.4.0, Z95.0, Y38). REMOVED FRAME AND INSTALLED NEW FRAME IAW DASH 8 Q400 SRM 51-40-07, 51-42-05 AND 51-25-15.SDR QXEA200800261Frame · corrodedPDX - C4 - MCD THRESHOLD FLOOR SUPPORT STRUCTURE FRAME CASTELLATION IS CORRODED (STATION X6.0, Z95.0, Y38). REMOVED FRAME AND INSTALLED NEW FRAME IAW DASH 8 Q400 SRM 51-40-07, 51-42-05 AND 51-25-15.SDR QXEA200800256Frame · corrodedPDX - C4 - CORROSION ON FRAME CLIP AFT CARGO PIT STATION X819/Z111.5/STRINGER 21R UNDER CARGO TIE DOWN COVER 251VZ. REMOVED CLIP AND REPAIRED IAW DASH 8 Q400 SRM 51-21-00 QND 51-14-00, ALSO Q400 NDTM PART 6 51-00-01. REINSTALLED CLIP IAW DASH 8 Q400 SRM 51-42SDR QXEA200800255Frame · corrodedPDX - C4 - RIGHT SIDE FRAME CASTELLATION (SKIN LEG) AT STATION X136 AND STRINGER 24S HAS AREA OF CORROSION AROUND RIVET. REPAIRED IAW DASH 8 Q400 SRM 51-42-05, 51-21-00, Q400 NDTM PART 6 51-00-01 AND PART 1 51-00-04, Q400 SRM 51-21-10, 51-25-10, 51-21-00, 51-SDR TRAX200800350Frame · corrodedCORROSION DAMAGE IN FWD MAIN AVIONICS BAY JUST FWD OF FS 280 FRAME AT NOSE JACK PAD SUPPORT STRUCTURE LHS (MARKED). REMOVED DIRT PRIMER AND PAINT, AT MARKED LOCATION, NO CORROSION FOUND INSPECTED LOCAL AREA NO CORROSION FOUND AT THIS TIME AT NOSE JACK PAD ARESDR 2008UALA01083Frame · damagedAFT PIT FUSELAGE STA 1620 FRAME AT STR 26R. ACCOMPLISHED A MAJOR REPAIR AT GSO.SDR 2008UALA01081Frame · dentedAFT LOWER CARGO PIT, FUSELAGE FRAME UPPER CHORD DENTED AT BS 1480 BETWEEN STR 25L-26L. ACCOMPLISHED A MAJOR REPAIR AT GSO.SDR 2008UALA01080Frame · damagedAFT PIT FRAME AT BS 1520R, STR 24.5R - 26R HAS DAMAGE. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR 2008UALA01078Frame · gougedAFT PIT FRAME GOUGED NUMEROUS PLACES AT BS 1520 BETWEEN STR 22R AND STR 24R. ACCOMPLISHED A MAJOR REPAIR AT GSO.SDR 2008UALA01077Frame · dentedAFT LOWER CARGO COMPARTMENT FUSELAGE FRAME DENTED AT BS 1460 AT STR 26L, INBOARD FLANGE. ACCOMPLISHED A MAJOR REPAIR AT GSO.SDR 2008UALA01076Frame · dentedAFT LOWER CARGO COMPARTMENT, FUSELAGE FRAME DENTED ON INBOARD FLANGE, BS 1440, AT STR 25L-26L. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR SWAA081117Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081116Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081115Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081114Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081083Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM.SDR 08FDEA00627Frame · corrodedAFT LWR CARGO BAY AT BS 950D BETWEEN STR S-29L AND S-28L, AFT SURFACE OF FRAME AND LWR SURFACE OF LWR CHORD HAVE CORROSION REMOVED FASTENERS FROM STA 950D STR 28L - 30L, BLENDED CORROSION, ORIGINAL MATERIAL .071". REMAINING MATERIAL .058 INCH, MATERIAL REMOVESDR USAA920080515Frame · crackedCLT - MAJOR REPAIR - RON CHECK - PILOTS WINDSHIELD OUTBOARD CORNER WINDOW POST FRAME CRACKED, BS 219.8. REPAIRED PILOTS WINDSHIELD OUT BOARD CORNER WINDOW POST FRAME, BS 219.8 IAW B737 SRM 53-10-01 REPAIR 10.SDR 2008UALA01050Frame · gougedAFT PIT FRAME GOUGED NUMEROUS PLACES AT BS 1520 BETWEEN STR 22R THRU STR 24R. ACCOMPLISHED MAJOR REPAIR AT GSO.SDR 08FDEA00616Frame · damagedCOCKPIT WINDSHIELD CENTER FRAME EXTERIOR, 2ND BOLT HOLE FROM THE BOTTOM IS ELONGATED. COMPLIED WITH EA NR 6-5310-113036 PART 1.SDR 08FDEA00612Failsafe · corrodedCORROSION FOUND ON LT FWD DOOR FAIL/SAFE RING, LOWER AFT CORNER. REPAIR PERFORMED BY BLEND OUT THE CORROSION, NDT FOR CRACK FREE CONDITION IAW. RAS 70503237/006/2008 ISS A, APPROVED BY EA 6-5312-114886.SDR UPS08851753Frame · crackedINSPECTION TYPE:C2 CRACK AT FWD CARGO PIT STA 100 LONG 34L. FRAME REPAIRED AT STA 100 AND L34L IAW EO DC8-5320-6176-6 AND SRM 51-1-8.SDR GLBA20061075Frame · crackedFUSELAGE FRAME CRACKED .5 NR AT FS 163.9 AND STR 9R MAINT REPAIRED FRAME CRACK AT STRINGER RELIEF HOLE FS 163.9 STRINGER 9R IAW SRM REF. 51-70. REPAIR APPROX 5.5 X 2.5 2024-T3 .071. RII INSP COMPLIED IAW TASKCARD 8.2.1.SDR GLBA20061076Frame · crackedFUSELAGE FRAME CRACKED .5 INCH AT FS 183 AT STRINGER 9R. MAINT REPAIRED FRAME CRACK AT STR RELIEF HOLE FS 183, STRINGER 9R IAW SRM REF 51-70. REPAIR APPROXIMATELY 5.5 INCH X 2.5 2024-T3 .071. RII INSPCOMPLIED WITH IAW TASKCARD 8.2.1.SDR 2008UALA01030Frame · crackedFUSELAGE FRAME IS CRACKED IN E&E COMPT BS 380 1" INBOARD OF STR 26L ON FWD FACE OF FAIL SAFE CHORD. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. VERIFIED REMOVAL WITH HFEC. INSTALLED REPAIR ANGLE.SDR SWAA081061Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081018Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081022Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081021Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081020Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081019Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081034Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081036Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081037Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081038Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081039Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081035Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081033Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081045Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 3L AND STR 2R. REPAIRED FRAME PER SWA EA.SDR SWAA081043Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA081044Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR 08FDEA00585Frame · corrodedFWD LOWER CARGO COMPT FRAME TIE AT STA 580 LBL 20 CORRODED AT END VERIFIED MATERIAL FOR REPLACEMENT FRAME TIE REF DWG 69-14871 .050 7075 T-6. FABRICATED NEW FRAME TIE REF DWG 69-14871. TREATED PRIMED REF SRM 51-10-2. INSTALLED NEW FRAME TIE REF SRM 51-30-2,SDR 08FDEA00581Frame · corrodedFWD CARGO COMPT CORROSION ON STA 580 TO SKIN, LBL 3" TO LBL 10". REPAIRED SHEAR TIE AT STA 580, LBL 3" TO 10". REF SRM 53-10-4 FIG 15. THIS IS CLASSIFID AS A MAJOR REPAIR.SDR 08FDEA00580Frame · damagedFRAME SHEAR TIE AT FS 600 LBL 12 HAS MISDRILLED HOLES FROM PREVIOUS WORKMANSHIP REMOVED DAMAGED SHEARTIE REF SRM 53-10-4. FABRICATED NEW ANGLE REF SRM 53-10-4, TOP COAT ANGLE REF SRM 51-10-2 MM 51-20-151-7. INSTALLED ANGLE TIE REF SRM 53-10-4 FIG 15. THIS ISDR NWAA081226310Frame · crackedDURING "M" CHECK, FOUND CRACKS IN 4 FRAME WEB FASTENER HOLES COMMON TO TENSION TIE AREA AT BS 1220. REPAIRED PER EA 63-212263.SDR SWAA081000Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 28R. REPAIRED FRAME PER SRM.
Back to JASC 5311