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 SWAA082629Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR KCSA081239Strap · crackedAFT BILGE FUSELAGE FRAME STABILIZER STRAP IS CRACKED AT STA 2050, RBL 66.SDR GLBA20061102Frame · crackedFRAME AT FS 177.35 CRACKED AT STRINER 9R RELIEF CUTOUT.** MAINT REPAIRED CRACK AT STRINGER RELIEFHOLE AT STRINGER 9R AND FS 177.35 IAW SRM 51-70. REPAIR APPROXIMATELY 3 INCHES BY 4 INCHES. 2024-T3 .071. RII INSPECTION COMPLIED IAW TASKCARD 8.2.1.SDR SWAA082610Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082599Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082598Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082597Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082596Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082595Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082594Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 707, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082593Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 3L. REPAIRED FRAME PER SWA EA.SDR COMA0860241Frame · crackedCRACK ON AFT SIDE FS 640 FRAME JUST BELOW STR 9. REPLACED RIGHT SIDE FRAME AT 640 AND PERFORMED REPAIR IAW SB601R-53-061 PART C.
SDR CALA0800462Frame · crackedRIGHT SIDE BS 747 INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED FRAME AT STA 747RT PER EA 5310-04498SDR CALA0800461Frame · crackedRIGHT SIDE BS 482A INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED FRAME BS 482A RIGHT AT A/C RAIL BRACKET PER EA 5310-04498.SDR CALA0800449Frame · crackedLEFT SIDE BS 400 INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME ATTACH FASTENER HOLE AT LEFT SIDE BS 400 PER EA5310-04498.SDR CALA0800452Frame · crackedLEFT SIDE BS 907 INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME ATTACH FASTENER HOLE AT LT SIDE BS 907 PER EA5310-04498.SDR CALA0800451Frame · crackedRIGHT SIDE BS 400 INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME ATTACH FASTENER HOLE AT RIGHT SIDE BS400 PER EA5310-04498.SDR SWAA082535Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082567Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082540Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082539Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082538Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082537Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082536Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082533Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1. REPAIRED FRAME PER ER.SDR SWAA082532Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 25L. REPAIRED FRAME PER ER.SDR SWAA082558Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 578, STR 13R. REPAIRED FRAME PER ER.SDR CALA0800448Frame · crackedRIGHT SIDE BS 440 I/B ATTACH FASTENER HOLES ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED FRAME BS 440 RIGHT AT A/C RAIL BRACKET PER EA 5310-04498.SDR CALA0800446Frame · crackedLEFT SIDE BS 440 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME AT BS 440 S8 - S9 PER EA5310-04498.SDR CALA0800445Frame · crackedLEFT SIDE BS 747 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME AT LEFT BS 747 I/B ATTACH FASTENER PER EA5310-04498.SDR CALA0800444Frame · crackedFRAME CRACKED AT STA 400 ABOVE S9R B737-53-3-0739. REPAIRED CRACKED FRAME BS 400 S9R PER EC/RA 5310-04763.SDR CALA0800443Frame · crackedLEFT SIDE BS 482 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME AT 482 S8 - S9 PER EA5310-04498.SDR CALA0800442Frame · crackedFRAME CRACKED AT STA 380 ABOVE S9R B737-53-3-0739. REPAIRED CRACKED FRAME BS 380 S9R PER EC/RA 5310-04763.SDR CALA0800441Frame · crackedLEFT SIDE BS 482A I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED CRACKED FRAME AT 482A S8 - S9 PER EA 5310-04498.SDR CALA0800440Frame · crackedLEFT SIDE BS 867 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED LEFT SIDE BS 867 I/B ATTACH FASTENER HOLE ON A/C BRACKET PER EA5310-04498.SDR CALA0800439Frame · crackedLEFT SIDE BS 827 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED LEFT SIDE BS 827 I/B ATTACH FASTENER HOLE ON A/C BRACKET PER EA5310-04498.SDR CALA0800438Frame · crackedLEFT SIDE BS 787 I/B ATTACH FASTENER HOLE ON AIR CONDITIONING (A/C) BRACKET CRACKED. REPAIRED LEFT SIDE BS 787 I/B ATTACH FASTENER HOLE ON A/C BRACKET PER EA5310-04498.SDR CALA0800437Frame · crackedRIGHT SIDE BS 727A I/B ATTACH FASTENER HOLE ON AIR CONDITIONING BRACKET CRACKED. REPAIRED FRAME AT BS 727A 59R PER EA5310-04498.SDR CALA0800436Frame · crackedRIGHT SIDE BS 787 INBOARD ATTACH FASTENER HOLE ON AIR CONDITIONING BRACKET CRACKED. REMOVED DAMAGE, DRILLED AND INSTALLED REPAIR IAW EA5310-04498.SDR 08FDEA01814Frame · dentedDENT FOUND ON LOWER FUSELAGE FRAME AT STA 480 BETWEEN STRINGER S-26L AND S-27L. EVALUATE AND REPAIR AS REQUIRED. REPAIR CARRIED OUT AS PER EA 757-5332-00-F0087 IN THE PTF MOD CARD NR 118250068DSSR02. REPAIR CLASSIFIED AS MAJOR AS PER FEDEX GMM 6-2-100 CRITESDR DLM90080701Frame · corrodedAFT CARGO BAY FRAME CORRODED AFT SIDE STA 1364 BETWEEN LONG 27L AND 28R. REPAIRED FRAME, IAW MD90 53-10-02.SDR USAA920081062Frame · crackedPIT - MAJOR REPAIR - C2 CHECK - R2 DOOR CUTOUT FRAME WEB CRACKED, BS 690.40 UNDER THE NR 1 STOP. REPAIRED THE R2 DOOR CUTOUT FRAME WEB CRACKED, BS 690.40 UNDER THE NR 1 STOP IAW USAIRWAYS EA 97407A.SDR F3LA200800246Frame · corrodedDURING C3 S1 C CHECK INSPECTION NOTED AFT CARGO LEFT FLOORBOARD FRAME AT STRINGER 38 LEFT BETWEEN FRAMES 58 AND 59 HAS AREAS OF CORROSION AROUND NUT CLIP HOLES. MAINTENANCE REMOVED AND INSTALLED FLOORBOARD FRAME DOOR SILL PLATE AT STRINGER 38 LEFT BETWEEN FRASDR SWAA082525Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR 08FDEA01792Frame · chafedFORWARD CABIN AT APPROXIMATELY STATION 535 LONGERON 20 LEFT FRAME FOUND CHAFED. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR 08FDEA01791Frame · chafedFORWARD CABIN LEFT SIDE 9-G NET YOKE AREA, FRAME FOUND CHAFED AT STATION 535 LONGERON 24 LEFT. REPAIRED AS PER DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR CALA0800421Frame · crackedFRAME CRACKED STATION 360 ABOVE STR 9L. REPLACED CLIP AND INSTALLED REPAIR DOUBLERS PER ECRA 5310-04759.SDR ASAA0843167Frame · crackedRIGHT FRAME AT STA 380 CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STA 380 PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 AND ASA EA 5310 02797.SDR ASAA0843166Frame · crackedLEFT FRAME AT STA 827 CRACKED AT PSU RAIL BRACKET. LEFT FRAME AT STA 827 AT PSU BRACKET REPAIRED IAW CASCADE ERO 8337 & ASA EA 5310 02797.SDR ASAA0843163Frame · crackedLEFT SIDE FRAME AT STA 747 CRACKED AT PSU RAIL BRACKET. LEFT SIDE FRAME AT STA 747 AT PSU RAIL BRACKET REPAIRED IAW ERO 8337 & ASA EA 5310 02797 REF CERT 11678.
Back to JASC 5311