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 SWAA071335Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071324Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071332Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071329Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071327Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071328Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071326Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071323Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071334Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071336Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA00770Frame · dentedFOUND UPPER CARGO COMPARTMENT, RT SIDEWALL FRAME AT STA 1761 INNER CHORD DENTED AT L-12R. UPPER CARGO COMPARTMENT, RH SIDEWALL FRAME AT STA 1761 INNER CHORD DENTED AT L-12R REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED. ISDR 07FDEA00769Frame · dentedFOUND UPPER CARGO COMPARTMENT, LT SIDEWALL FRAME AT STA 1641 INNER CHORD DENTED AT L-12L. UPPER CARGO COMPARTMENT, LH SIDEWALL FRAME AT STA 1641 AT L-12L. REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTSDR 07FDEA00768Frame · dentedFOUND UPPER CARGO COMPARTMENT, LT SIDEWALL FRAME AT STA 1681 DENTED AT L- 12L. UPPER CARGO COMPARTMENT, LT SIDEWALL FRAME AT STA 1681 AT L-12L REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT SDR 07FDEA00767Frame · dentedFOUND UPPER CARGO COMPARTMENT, LT SIDEWALL FRAME AT STA 1701 INNER CHORD DENTED AT L- 12L. UPPER CARGO COMPARTMENT, LT SIDEWALL FRAME AT STA 1701 AT L-12L REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION SDR 07FDEA00765Frame · dentedFOUND UPPER CARGO COMPARTMENT, RT SIDEWALL FRAME AT STA 1661 INNER CHORD DENTED AT L- 12R. UPPER CARGO COMPARTMENT, RH SIDEWALL FRAME AT STA 1661 INNER CHORD AT L-12R REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED - INITIALSDR 07FDEA00764Frame · dentedFOUND UPPER CARGO COMPARTMENT, RT SIDEWALL FRAME AT STA 1701 INNER CHORD DENTED AT L-12R. UPPER CARGO COMPARTMENT, RT SIDEWALL FRAME AT STA 1701 AT L-12R REPAIR CARRIED OUT AS PER SRM 53-30-00 FIG.1 VOL.I. REPETITIVE INSPECTION REQUIRED. INITIAL INSPECTIOSDR KNNA200700026Frame · damagedAFT CARGO PIT, INTERIOR BILGE B-STA 867 BETWEEN STR 27 R AND STR 28 L FRAME BOTTOM SIDE, CORRODED. PROVIDE INSTRUCTIONS ON REPAIR OF CORROSION AFT CARGO PIT, INTERIOR BILGE BS 867 BETWEEN STR 27R-27L BOEING SRM 53-10-4 FIGURE 7.SDR SWAA071313Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071311Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071312Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR AWXA200700451Frame · crackedMCN - CRACKED R1 DOOR CUT OUT UPPER STUB FRAME, BS 296.40, RBL 49.34,WL 265. REPLACED R1 DOOR CUT OUT UPPER STUB FRAME, BS 296.40, RBL 49.34,WL 265 IAW B737-300 SRM 51-40-02.SDR AWXA200700450Frame · crackedMCN - R1 DOOR CUT OUT FORWARD FRAME CRACKED, BS 294, WL 207. REPLACED R1 DOOR CUT OUT FORWARD FRAME, BS 294, WL 207 IAW B737-300 SRM 51-40-02.SDR AWXA200700439Frame · crackedMCN - CRACKED FRAME UPPER RING, BS 663.75, S1 - S3R. REPAIRED FRAME UPPER RING, BS 663.75, S1 - S3R IAW B737-300 SRM 53-00-07-2R9, FIGURE 201.SDR UPS07549567Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 700, 24L. REPAIR COMPLETED PER EA 757-5332-27-A1624, & UPS EO B757-26409-A, WITH NO DEVIATIONS.SDR UPS07549566Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 660, BETWEEN S24R TO S25R. COMPLIED WITH EA 757-5332-27-A1623 AND UPS EO B757-5310-26415-A.SDR UPS07549565Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO FUSELAGE FRAME STA 640, S24R. REPAIR COMPLETED PER EA 757-5332-27-A1625.SDR UPS07549564Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1340, BETWEEN S25R TO S26R, 2EA ACCOMPLISHED REPAIR PER FINAL EA 757-5362-27-A1620 AND UPS EO B757-5310-26429-A.SDR UPS07549563Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1280, S26L. REPAIRED FRAME PER FINAL EA 757-5362-27-A1619 AND UPS EO B757-26423 7-A.SDR UPS07549562Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, S26L. ACCOMPLISHED REPAIR PER FINAL EA 757-5362-27-A1621 AND UPS EO B757-5310-26418-A.SDR UPS07549561Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1460, BETWEEN S25L TO S26L. REPAIR AT FRAME STA 1460, S25L TO S26L ACCOMPLISHED PER FINAL EA 757-5362-27-A1622 & UPS EO B757-5310-26417-A.SDR DHL2007751516Frame · corrodedAFT CARGO COMPT FRAME AT STA 950C IS CORRODED AT BOTTOM BETWEEN STR 29L AND 30L. CORROSION DMG EXCEEDS LIMITS PER B727 SRM 53-10-2 FIG 5. CUT OUT DAMAGE, FABRICATED SHEAR TIE REPAIR FROM 7075-T0, .080" BY 4.5" BY 1.5" BY 1", PO NR 9002619 PER B727 SRM 53-10-SDR DHL2007751515Frame · corrodedAFT CARGO COMPT FRAME AT STA 1148 IS CORRODED AT BOTTOM BETWEEN STR 29R AND 30R. CUT OUT DAMAGED AREA 4" BY 1" BY 1". FABRICATED REPAIR SHEAR TIE (.063" BY 4.875" BY 3.5" BY 1") AND SHIM (.063" BY 3.5" BY 1.2") FROM 7075-T6 PO NR 9004690; TREATED AND PRIMEDSDR 2007UALA00709Frame · crackedFUSELAGE BS 616 LT SIDE OVERWING FRAME INNER CHORD CRACKED LBL 65. MAJOR REPAIR ACCOMPLISHED: ACCOMPLISHED ANGLE, FILLER & SHIM REPAIR.SDR SWAA071307Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071306Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071282Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071284Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071286Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071287Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071283Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071281Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071285Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR COEA0703908Frame · damagedGOUGE LOCATED ON THE VERTICAL WEB OF FRAME 7 AT BL 0 IN THE NLG WELL. DAMAGE CUTOUT AND FABRICATED DOUBLER INSTALLED PER DO/TS-3265/06-7477 AND DO/TS-3926/06-7477. REF SRAS DO/TS03265/06...3787. (M)SDR COEA07002908Frame · damagedTOOLING DAMAGE TO UPPER FUSELAGE FRAME 25 AFT FLANGE BETWEEN STRINGER 4-5 LT. DAMAGE BLENDED OUT PER SRAS DO/TS-3859/06-7653 REPAIR INSTRUCTIONS. REF SRAS DO/TS-3859/06...3772 ISSUE B FOR REPETITIVE INSPECTION. (M)SDR SWAA071304Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65, WL 201. REPAIRED FRAME PER SRM.SDR SWAA071265Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071261Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071270Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SWA EA.SDR 07FDEA00678Frame · crackedFRAME 277 IS CRACKED IN THE RADIUS OF CUT OUT FOR STRINGER 16R DISPLACED WIRING FOR ACCESS. VERIFIED CRACK, REMOVED FASTENERS AND DAMAGE, VERIFIED DAMAGE REMOVED AND MATERIAL LOSS. FABRICATED, TREATED AND INSTALLED DOUBLER, FILLER AND CLIP REF SRM 51-40-2 SDR AWXA200700444Frame · crackedMCN - FOUND FORWARD CARGO COMPARTMENT FRAME CRACKED, BS 492, S24R. REPAIRED FORWARD CARGO COMPARTMENT FRAME, BS 492, S24R IAW AWA ER 03-5300-07086-SS3.
Back to JASC 5311