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 SWAA081773Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA081763Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081764Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081765Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081766Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR 08FDEA01234Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. EVALUATED FRAME BLENDED ROUGH EDGES DRILLED HOLE REMOVING ALL DAMAGE FILLED HOLE WITH RIVET IAW SRM 530001 FIG 1A. REPSDR 08FDEA01233Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/729477, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STASDR 08FDEA01231Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/729477, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STASDR 08FDEA01230Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGE FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/29475, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STA 7SDR 08FDEA01229Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/29478, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STA SDR 08FDEA01228Frame · chafedMCD-FUSELAGE UPPER LOBE AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/729478, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STA 675 IASDR 08FDEA01227Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/729478, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE AT STASDR 08FDEA01226Frame · chafedMCD-FUSELAGE UPPER LOBE-FRAME AT FS 635, 655, 675, 695, 715, 735, 755 AND 775, LONGERON 13R HAS CHAFED AND DAMAGED FROM LINER MOUNT FASTENER. REMOVED FRAME SPLICE, FABED NEW SPLICE ON TRAVELER T8/729476, LOCATED AND DRILLED HOLES AND INSTALLED NEW SPLICE SDR UPS08M52211Frame · crackedINSPECTION TYPE:4C CRACK AT FRAME TO FLOOR BRACKET AT FS 1258 RBL 106. REMOVED, FABRICATED, AND INSTALLED FRAME PER EO MD11-5310-29275-A DAC DWG AEA7605, MD-11 SRM 53-33-01, AND SAA EA 011-5310-01-A1340.SDR USAA920080810Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - A .5" CRACK ON FRAME AT BS 907 BETWEEN STR 8R AND STR 9R. INSTALLED REPAIR IAW SRM TR 53-10-20E.SDR NWAA081456310Frame · crackedDURING "M" CHECK FOUND CRACK IN FRAME WEB AT BS 1265 S26L. REPAIRED PER EA 63-212256 SECTION I. REPETITIVE INSPECTIONS TO BE ACCOMPLISHED AT 2000 CYCLE INTERVALS PER SECTION II UNTIL SECTION III PERMANENT REPAIR IS ACCOMPLISHED.SDR SWAA081755Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081756Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081757Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081758Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081738Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081741Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081740Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081739Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR 2008UALA01825Frame · dentedAFT PIT FRAME INBOARD FLANGE AT STA 1560 AND STR 26R IS DENTED. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR.SDR 2008UALA01824Frame · dentedFWD PIT AT STA 580 BETWEEN STR 23L AND 24L , FRAME INBOARD FLANGE DENTED. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR.SDR 2008UALA01821Frame · damagedFRAME IS TORN OUT STA 1351 BETWEEN STR 28R-26R. REPAIRED FRAME IAW SRM 53-00-01 FIG 201 DETAIL II AND SRM 51-40-02. AC OK FOR SERVICE.SDR ASAA0842858Frame · crackedCRACK FOUND ON INNER FRAME CHORD AT BS 616 RT WL200 AT STUB BEAM CRACK ON INNER CHORD WAS REPAIRED IAW ASA EA NR 5310 02790.SDR SWAA081707Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081728Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081696Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081721Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081698Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081695Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081697Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081702Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081701Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081700Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081699Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081694Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR UPS08B52553Doubler · crackedINSPECTION TYPE:BCF LT BS1120 TENSION TIE FRAME DOUBLER CRACKED ABOUT 0.030 INCH. LT BS 1120 TENSION TIE FRAME DOUBLER REPLACED PER 65B25837 PL AND DWG.SDR UPS08B52380Frame · crackedINSPECTION TYPE:C LT BS 1140 TENSION TIE FRAME CRACKED. LT BS 1140 TENSION TIE FRAME REPAIRED PER SRM 53-40-07.SDR SWAA081752Frame · corrodedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 480, BL 0. REPAIRED FRAME PER SRM.SDR USAA920080808Support · crackedCLT - MAJOR REPAIR - Q6 CHECK - A 1" CRACK ON FRAME SUPPORT AT BS 947, STR 22L. INSTALLED REPAIR IAW SRM 51-10-02.SDR USAA920080807Support · crackedCLT - MAJOR REPAIR - Q6 CHECK - A 2" CRACK ON FRAME SUPPORT AT BS 927 - 947, BL 0. INSTALLED REPAIR IAW SRM 51-40-02.SDR USAA920080757Frame · crackedPIT - MAJOR REPAIR - FPBH INSPECTION, FRAME CRACKED, BS 440, S24R. REPAIRED FRAME, BS 440, S24R, IAW US AIRWAYS EA 110807.SDR USAA920080721Frame · crackedPIT - MAJOR REPAIR - FPBH INSPECTION, CRACKED FRAME, BS 440, S24R. REPAIRED FRAME, BS 440, S24R IAW USAIRWAYS EA 110807.SDR 2008UALA01767Frame · crackedFWD GALLEY DOOR AFT SIDE FRAME CRACKED AT 4TH FROM TOP STOP FITTING. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE. INSTALLED FRAME REPAIR ANGLE.SDR GLBA20061085Frame · bentFRAME SECTION AT FS 469 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 469 STRINGER 3L IAW SRM 51-40. P/N NR 129-440044-75.SDR GLBA20061087Frame · bentFRAME SECTION AT FS 495.75 STRINGER 3L BENT. MAINTENANCE REPLACED THE BENT INTERCOSTAL AT FS 495.75 STRINGER 3L IAW SRM 51-40. P/N 129-440044-71.
Back to JASC 5311