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 USAA2009043091044Frame · crackedSAL - C19 - MAJOR REPAIR - FRAME CRACKED AT BS 480 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS480 BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA2009043091043Frame · crackedSAL - C19 - MAJOR REPAIR - FRAME CRACKED AT BS 480 BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 480 BETWEEN S8L TO S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA2009043091042Frame · crackedSAL - C19 - MAJOR REPAIR - FRAME CRACKED AT BS 380 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 380 BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002.SDR ASAA0945316Frame · corrodedFWD PIT STA 500E STR 28L 28R FRAME CORRODED ON SKIN SIDE. CUT OUT DAMAGED AREA, FABRICATED INSTALLED FRAME REPAIR IAW B737 400 SRM 53 00 07.SDR ASAA0945315Frame · corrodedFWD PIT STA 500B STR 28L 28R FRAME CORRODED FWD SIDE. CUT OUT DAMAGED AREA, FABRICATED, INSTALLED FRAME REPAIR IAW B737 400 SRM 53 00 07.SDR USAA2009042891018Frame · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON FRAME AT BS 794 BETWEEN S16R TO S27R. REPLACED FRAME AT BS 794 BETWEEN S16R TO S27R IAW B737 SRM 51-10-02 & BOEING DRAWING 65-47959.SDR DLM88090599Frame · corrodedFRAME AT STATION 1309 CORRRODED AT UPPER CORD. REPAIRED BY SPLICE PER 53-03D FIG 2A ON NR 202893.SDR ASOA200900371Frame · noneRT FS 718 FRAME WEB HAS A CREASE WITH POSSIBLE CRACK JUST BELOW ACM SUPPORT. PERFORMED EDDY CURRENT INSP OF SUSPECTED AREA IAW NDTM PT 1 51-20-06. NO INDICATIONS NOTED AT THIS TIME. EVALUATED DENT PER SRM 53-00-00 FIG. 102, SHEETS 1 AND 2. WITHIN LIMITS SPSDR SWAA092145Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED WEB PER ACO.SDR SWAA092132Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 291, STR 16R. REPAIRED WEB PER ACO.SDR FDEA200904021157Frame · damagedFOUND SEVERAL DAMAGED AREAS ON RT FRAME C 47 IN SEVERAL HOLES. REPAIR PERFORMED BY REAM UP THE HOLES IAW 041976/041/2005 ISS A, APPROVED BY EA 6-5310-129126.SDR FDEA200904021146Frame · corrodedFOUND STA 1661 FRAME CORRODED BETWEEN STRINGERS 28R AND 27L. CORROSION FOUND EXCEEDED SRM REPAIRABLE LIMITS. FRAME AT STA 1661 REMOVED AND REPLACED IAW SRM 51-40-02 REV. 96. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200904021140Frame · damagedMISDRILLED HOLE IN FRAME 50, BETWEEN P 15-16 LT REPAIR PERFORMED BY REWORK THE RIB OF FRAME AND PLUG THE HOLE IAW RAS /EFW/9000160/2009 ISS A, APPROVED BY EA 6-5310-129114.SDR ZZDA2009105Frame · corrodedSURFACE CORROSION AT CIRCUMFERENTIAL FRAME LONG 29L-29R AFT CARGO BILGE STA 889. INSTALLED CIRCUMFERENTIAL FRAME REPAIR AS REQ LONG 19L-29R REFERENCE B717 SRM 51-10-04 AND 53-20-07.SDR USAA2009050791111Frame · crackedMCN - C5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 188, WL 207. REPAIRED FUSELAGE FRAME AT BS 188, WL 207 IAW B737 SRM 53-00-07.SDR MALA090051Frame · chafedCHAFE NOTED ON LT CABIN FRAME STA363 INNER FLANGE REINFORCEMENT ANGLE AT SL 1505. REPAIRED IAW S53675.SDR USAA2009040290782Frame · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FRAME LOWER T-CHORD AT BS 1540, BL 0. REPAIRED FRAME LOWER T-CHORD AT BS 1540, BL 0 IAW B767 SRM 51-40-02, 53-00-03 & 51-40-05.SDR SWAA092121Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA092116Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 887, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER AAR EA.SDR SWAA092115Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER AAR EA.SDR SWAA092113Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME ANGLE CRACKED AT BS 291, STR 11R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA092112Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SRM.SDR SWAA092111Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA092110Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500D, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA092109Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA092108Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092104Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 303, STR 16L. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA092099Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA092098Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 706, BETWEEN STR 2L TO STR 3L. REPAIRED FRAME PER SRM.SDR SWAA092094Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 639, BETWEEN STR 16R TO STR 17R. REPAIRED FRAME PER SRM.SDR SWAA092073Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA092065Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 2R TO STR 3R. REPAIRED FRAME PER SRM.SDR SWAA092058Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 616, LBL 64. REPAIRED FRAME PER SRM.SDR FDEA200903311129Frame · corrodedSTA 1661 FRAME CORRODED BETWEEN STRINGER 28R AND 27L.SDR DLM88090564Frame · crackedCANTED FRAME 1485 RT SIDE FOUND TO BE CRACKED. REPAIRED PANEL AT CANTED FRAME 1485 IAW SRM 53-01 FIG 4.SDR USAA2009040190743Frame · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FRAME WEB AT BS 1540, BL 0. REPAIRED FRAME WEB AT BS 1540, BL 0 IAW B767 SRM 51-40-02, 53-00-03, 51-40-05, & 51-21-01.SDR SWAA092037Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND LT LOWER STUB FRAME CRACKED AT BS 951 L2 DOOR LOWER FWD CUTOUT. REPAIRED STUB FRAME PER SRM.SDR CALA2009033000173Frame · crackedCABIN FRAME CRACKED AT PSU SUPPORT BRACKET STA 727D STR 8L. INSTALLED INTERIM REPAIR PART B, STEPS 1 THRU 13 AND ISSUED DIP REF PART C, STEP 4 OF ECRA 5310-04919. ISSUED DIP ON LOG PAGE 9879503.SDR CALA2009033000172Frame · crackedCABIN FRAME CRACKED AT PSU SUPPORT BRACKET STA 400 STR 8L. INSTALLED INTERIM REPAIR PART B, STEPS 1 THRU 13 AND ISSUED DIP REF PART C, STEP 4, OF ECRA 5310-04919. ISSUED DIP ON LOG PAGE 9879503.SDR CALA2009033000171Frame · crackedCABIN FRAME CRACKED AT PSU SUPPORT BRACKET STA 440 STR 8L. INSTALLED INTERIM REPAIR PART B, STEPS 1 THRU 13, AND ISSUED DIP REF PART C, STEP 4, OF ECRA 5310-04919.SDR USAA2009051291161Frame · crackedMCN - C5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440, 24R. REPLACED FUSELAGE FRAME AT BS 440, 24R IAW B737 SRM 51-40-02.SDR DL75E090776Frame · dentedFRAME DENTED IN FWD CARGO STA 520 BETWEEN STR 25 AND 24L. REPAIRED PER ERA474163-14 REV ORIG DURING HMV AT SAT ON NRC133877.SDR DL75E090768Frame · dentedAFT CARGO FRAME STA 1480 S26-27L FLANGE DENTED. REPAIRED PER SRM 53-00-07, 51-40-02 CAT B REPAIR NR 5 REINSPECT EVERY 12,000 CYCLES.SDR USAA2009043091046Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 867 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 867 BETWEEN S8R TO S9R IAW US AIRWAYS EA 132382.SDR USAA2009043091040Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 727F BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 727F BETWEEN S8R TO S9R IAW US AIRWAYS EA 132382.SDR USAA2009043091039Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 727F BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 727F BETWEEN S8L TO S9L IAW US AIRWAYS EA 132382.SDR USAA2009043091038Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 727D BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 727D BETWEEN S8L TO S9L IAW US AIRWAYS EA 132382.SDR USAA2009043091037Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 727B BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 727B BETWEEN S8R TO S9R IAW US AIRWAYS EA 132382.SDR USAA2009043091036Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 500A BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 500A BETWEEN S8L TO S9L IAW US AIRWAYS EA 132382.SDR USAA2009043091035Frame · crackedSAL - Q6 - MAJOR REPAIR - FRAME CRACKED AT BS 480 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 480 BETWEEN S8R TO S9R IAW US AIRWAYS EA 132382.
Back to JASC 5311