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 ASAA0944405Frame · damagedFRAME AT BS 727A HAS OVERSIZED HOLES COMMON TO FLOOR TO SIDEWALL SUPPORT AT RBL 19 AND 21. REPAIRED OVERSIZED HOLE.SDR ASAA0944404Frame · damagedAFT CARGO BAY FRAME AT BS 727G HAS OVERSIZED HOLES COMMON TO FLOOR TO SIDEWALL SUPPORT AT LBL 19 AND 21. REPAIRED FRAME AT BS 727G LBL 21 IAW SRM 51 70 11.SDR ASAA0944403Frame · damagedAFT CARGO BAY FRAME AT BS 727G HAS OVERSIZED HOLES COMMON TO FLOOR TO SIDEWALL SUPPORT. DISCREPANCY REPAIRED ON MIG 5.SDR ASAA0944402Frame · damagedAFT CARGO BAY SUBFRAME AT .5 INCHES FORWARD OFBS 727G HAS OVERSIZED HOLES COMMON TO FLOOR TO SIDEWALL SUPPORT. REPAIRED SUB FRAME AT BS 727G.SDR UALA2009021100463Frame · dentedAFT PIT FRAME STA 1580 AT STR 25R IS DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED J-ANGLE DOUBLER REPAIR.SDR UALA2009021100462Frame · dentedAFT PIT STA 1600 AT STR 25R IS DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2009021100461Frame · dentedAFT PIT STA 1580 AT STR 25L FRAME IS DENTED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2009021100459Frame · dentedAFT PIT FRAME DENTED STA 1540, BETWEEN STR 25L - 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR UALA2009021100458Frame · dentedAFT PIT FRAME DENTED STA 1400, BETWEEN STR 25L AND 24L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR RMXA02102009Frame · crackedDURING SCHEDULED MAINTENANCE, A 2 INCH LONG CRACK WAS DISCOVERED IN THE FUSELAGE LT BOX BEAM FRAME ASSY. ADDITIONALLY, 7 ATTACHING RIVETS WERE FOUND TO BE SHEARED.SDR AALA2009021300099Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER IN ACCORDANCE WITH ENGINEERING AUTHORIZATION 53-005415 AND SRM 53-01.SDR AALA2009021300098Frame · crackedFRAME CRACKED AT STATION 1418 AT LONGERON 2 RIGHT. INSTALLED DOUBLER ON FRAME 1418 LONGERON 2 RIGHT PER ENGINEERING AUTHORIZATION MD80 53-005415 AND SRM 53-01-00.SDR ASAA0944420Frame · damagedFRAME 727A HAS OVERSIZED HOLES COMMON TO FLOOR TO SIDEWALL SUPPORT RBL 19 AND RBL 21.7. FABRICATED AND INSTALLED REPAIR PARTS.SDR SWAA091027Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR SWAA091019Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 26L. REPAIRED FRAME SRM.SDR SWAA091018Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 26L. REPAIRED FRAME SRM.SDR SWAA091017Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 727C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME SRM.SDR SWAA091006Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091005Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091004Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091003Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090986Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090985Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090984Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR FDEA200902090483Frame · corrodedFORWARD ACCESSORY COMPARTMENT FRAME AT BS 231.25 BETWEEN S29L TO 29R HAS SEVERAL GOUGES. REPAIR CARRIED OUT AS PER EA F-5310-111009 A, REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 CRITERIA.SDR DU4R2009312Frame · crackedS/O NR 312003 N/R 25855, DURING SCHEDULED INSP, FOUND L-1 DOOR FWD TOP CORNER INNER STRUCTURE FRAME CRACKED AT BS 311 S-5L-S-6L.SDR SWAA090974Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090973Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090972Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090971Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090970Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090969Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090968Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090967Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090966Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090965Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090964Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090963Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090962Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090961Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090960Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090959Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090958Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090957Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090954Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090952Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090950Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090947Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090946Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090945Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311