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 SWAA090217Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090216Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090215Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090214Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090213Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090207Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 927, STR 25R. REPAIRED FRAME PER SRM.SDR SWAA090169Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA090168Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 25R. REPAIRED FRAME PER SRM.SDR R5KB16005Frame · dentedSTA. 680, STR 23R TO 24R, FRAME DENTEDSDR R5KB16004Frame · dentedSTA 660, STRINGER 24R, FRAME DENTED.SDR R5KB15983Frame · corrodedSTA 340, RBL 19 TO RBL24, FRAME CORRODEDSDR R5KB15789Frame · corroded1/2 INCH CRACK IN FRAME AT STA 580 ABOVE FWD SERVICE DOOR.SDR R5KB15651Frame · dentedFRAME AT STA 26 LEFT DENTED.SDR R5KB15650Frame · dentedFRAME AT STATION 950 DENTED.SDR ASAA0944276Frame · dentedFOUND STA 807 FRAME BENT AT RADIUS JUST ABOVE STR 24L. REMOVED DAMAGED AREA OUT LIMITS FABRICATED NEW PART TREATED PRIMED TOP COATED AND INSTALLED REPAIR IAW B737 400 SRM 51 40 02.SDR UALA2009011200113Frame · dentedAFT PIT FRAME STA 1480, DENT IN FRAME LT SIDE IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE AND INSTALLED DOUBLER REPAIR BETWEEN STR 25 AND 27L.SDR UALA2009011200109Frame · dentedAFT PIT FRAME STA 1400, DENT IN LT SIDE FRAME IN SLANT PANEL AREA. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED SECTION OF FRAME AND INSTALLED DOUBLER REPAIR.SDR DLM88090389Frame · crackedMAIN CABIN RIGHT SIDE OVERWING FRAME CRACKED AT FLOOR LEVEL FS 886. REPLACED FRAME IAW EA 09-460094-12AD.SDR R5KB15652Frame · dentedFRAME AT STATION 950 DENTED.SDR FDEA200901090108Frame · crackedHOLE NR 10 SHOWS A CRACK INDICATION IN THE FRAME ON THE RIGHT SIDE OF THE COCKPIT. REAMED HOLE TO .310 IAW SRM 51-40-44. PERFORMED BHEC INSPECTION OF HOLE NR 10, IAW NTM 51-10-01 A6, INDICATION STILL PRESENT. CLEANED HOLE NR 10 IAW AMM 12-21-13-7, ACCOMPLISHESDR USAA2009013090246Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 807 BETWEEN S5L TO S9L. REPAIRED FRAME AT BS 807 BETWEEN S5L TO S9L IAW TASK CARD M1C53002.SDR USAA2009013090245Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 767 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 767 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009013090244Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 747 BETWEEN S5R TO S9L. REPAIRED FRAME AT BS 747 BETWEEN S5L TO S9L IAW TASK CARD M1C53002.SDR USAA2009013090243Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 727E BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 727E BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009013090242Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 500C BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 500C BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009013090241Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 440 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 440 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009013090240Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 400 BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 400 BETWEEN S8L TO S9L IAW TASK CARD M1C53002.SDR USAA2009013090239Frame · crackedSAL - C21 - MAJOR REPAIR - FRAME CRACKED AT BS 380 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 380 BETWEEN S8L TO S9L IAW TASK CARD M1C53002.SDR DL76L090030Frame · crackedDURING HMV AT HAECO IN HKG MAINTENANCE, FOUND A .25 INCH CRACK ON THE LT FS 903.5 FRAME AT WL 190. A REPAIR WAS INSTALLED PER ERA 471737-14AD.SDR FDEA200901080081Frame · corrodedAFT CARGO DOOR CUTOUT FRAME 59A CORROSION AT LOWER END OF DOOR FRAME. PERFORMED REPAIR PER SRM 53-17 FIG 201 AND 202A AND EA NR 6-5320-125509.SDR SWAA090149Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED BETWEEN BS 249 TO BS 250, BETWEEN STR 12R TO STR 13R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA090141Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090140Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090139Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090138Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090137Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090136Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090135Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090134Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090130Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR CALA2009010900028Frame · corrodedAFT CARGO COMP. BELTFRAME HAS CORROSION AT FWD LWR AREA STA BS 807 AND STRINGER S27L REPAIRED BELTFRAME SHEAR TIE IAW SRM 53-00-07 REPAIR 3 AT STA 807 STR 27L.SDR DLM88090575Frame · corrodedCORROSION ON FRAME FS 1098, LONGERON 30. REPAIRED BY REPLACING IAW SRM 51-30-03, 51-30-05.SDR DLM88090397Frame · corrodedFRAME CORRODED AT FS 788.SDR SWAA090117Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090116Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA090115Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO PIT FRAME CRACKED AT BS 500, BETWEEN RBL 1 TO RBL 5. REPAIRED FRAME PER SRM.SDR SWAA090113Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090112Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090111Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090110Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.
Back to JASC 5311