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 SWAA063659Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063658Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063657Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R AND STR 8L. REPAIRED FRAME SECTION PER ACO.SDR SWAA063655Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME SECTION PER SWA EA.SDR C1HA200697002Frame · crackedBS 1303 FRAME FIN WL (O) HAS WEB CRACK LT SIDE BOTTOM. STOP DRILLED CRACK AT FIN WL (0) IAW EO CA0909-06 REV N/C. VERIFIED CRACK STOPPED IAW NDTM PT 6 51-00-00 FIG 23.SDR CIHA200697003Frame · crackedBS 1303 FRAME FIN WL (6) HAS WEB CRACKED LT SIDE +6 INCHES FROM BOTTOM. STOP DRILLED CRACK AT WL 6 IAW EO CA 0909-06 REV N/C. VERIFIED CRACK STOPPED IAW NDTM PT 6 51-00-00 FIG 23.SDR 2007FA0000133Frame · crackedCABIN, BS 787, FRAME AT STR 8R, CRACKED AT STOW BIN ATTACH BRACKET. (K)SDR AWXA200601737Fitting · crackedMCN - MAJOR REPAIR - C-17 CHECK - FRAME CLIP CRACKED, BS 348.20, STR 16L. REMOVED AND REPLACED FRAME CLIP, BS 348.20, STR 16L IAW AWA ER 03-5311-06282-SS1.SDR 2006UALA01846Frame · damagedSTATION 879 J-SECTION FRAME IS DAMAGED NEAR S21R. MAJOR REPAIR ACCOMPLISHED AT STA 879 FRAME S-21R. NEW FRAME INSTALLED. THIS IS A 12 MONTH CF ITEM PENDING DTA FROM BOEING.SDR SWAA063620Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME SECTION PER SRM.SDR IXXA06SMN315SFrame · corrodedDURING ROUTINE C-CHECK INSPECTION, FOUND EXISTING FRAME REPAIR CORRODED AT STA 600 BETWEEN LONGERON 36 AND LONGERON 35 RT. REMOVED EXISTING REPAIR. FABRICATED NEW REPAIR DOUBLER. INTERNAL FINGER DOUBLER AND FILLER. CLEANED, TREATED AND PRIMED AREA AND REPASDR 0602176730Frame · crackedDURING M-CHECK FOUND CRACK IN FRAME AT BS 480 S7R. REPAIRED PER EA 67-207309.SDR TRAX200600770Frame · corrodedBOTTOM OF FRAME 45 IN AFT AVIONIC COMPARTMENT CORRODED AT MANY PLACES. CORROSION REMOVED ON FR 45 IN AFT AVIONICS COMPARTMENT AS PER SRM 51-21-41. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IAW SP663 AND FAR 43 APPENDIX A REPAIR ACCOMPLISHED IAW SRM 53-81-00SDR SWAA063611Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063610Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063609Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063608Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063607Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063606Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063605Beltframe · crackedDURING SCHEDULED 18Y CHECK, FOUND BELT FRAME CRACKED AT BS 420, STR 13L. REPAIRED BELT FRAME PER SWA EA.SDR SWAA063590Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 26L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR USAA061187Frame · crackedBS 727D LBL 1 FRAME CRACKED. CUT OUT DAMAGE, FABRICATED FRAME DOUBLER IAW SRM 51-70-11, DEFECT SIZE: 1 INCH.SDR USAA061188Frame · crackedSTA 727, S13L, S14L S15L IN CUTOUT FRAME CRACKED. REMOVED CRACKED AREAS OF FRAME IAW EA 98040, DEFECT SIZE: .125 INCH, .500 INCH, .750 INCH.SDR 0602166730Frame · crackedDURING M-CHECK FOUND 7 FASTENER HOLES CRACKED IN FRAME AT BS 360 BETWEEN S0 AND S3L. REPAIRED PER EA 67-207299.SDR 0602146730Frame · crackedDURING M-CHECK FOUND CRACK IN FRAME AT BS 360 S23R. REPAIRED PER EA 67-207304.SDR UPS06448181Frame · crackedAPU COMPT BS 2675 LT WL325 FRAME FOUND CRACK AS MARKED, CRACK LENGTH .500 INCH. APU COMPT BS 2675 LT WL 325 FRAME REPAIRED AS PER SRM 51-40-03 FIG 1.SDR UPS06448180Frame · crackedEMP APU COMPT LT BS 2701 WL 315 FRAME FOUND CRACK AS MARKED, CRACK LENGTH .7500. APU COMPT LT BS 2701 WL 315 FRAME REPAIRED AS PER SRM 51-40-03 FIG 1.SDR 2006UALA01810Frame · damagedFRAME AT STA 880 STR 21R HAS HEAT DAMAGE. MAJOR REPAIR ACCOMPLISHED. CONDUCTIVITY CHECK FOUND HEAT DAMAGE APPROX 3 INCH FROM EITHER SIDE OF BURNT THRU AND THE FRAME SUPPORT BRACKET ALSO HAS HEAT DAMAGE AT THAT LOCATION. UPON FURTHER INSPECTION FOUND STRINGESDR SWAA063575Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063574Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063585Beltframe · crackedDURING SCHEDULED 20Y CHECK, FOUND BELT FRAME CRACKED AT BS 1006, STR 27L AND 27R. REPAIRED BELT FRAME PER SRM.SDR SWAA063584Beltframe · corrodedDURING SCHEDULED 20Y CHECK, FOUND BELT FRAME CORRODED AT BS 360, STR 28L AND 28R. REPAIRED BELT FRAME PER SRM.SDR SWAA063565Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME SECTION PER SRM.SDR KCSA061346Frame · corrodedFUSELAGE FRAME UPPER CHORD IS CORRDED AT STA 820 RBL 44.SDR KCSA061343Frame · corrodedFUSELAGE FRAME UPPER CHORD IS CORRODED AT STA 800 AT RBL 34.SDR KCSA061342Frame · crackedFRAME CRACKED 1 INCH AT STA 2180 STR 25L.SDR 0602156730Frame · crackedDURING M-CHECK FOUND CRACKS IN FRAME AT BS 520 S10R TO S13R. REPAIRED PER EA 67-207921.SDR 2006UALA01807Frame · crackedFOUND STA 1265 LT FRAME WEB FASTENER HOLE AND EDGE SURFACE "C" CRACK (COA 8-4788 SKETCH NR 32 CIRCLE NOTE 1 AND 10). ACCOMPLISHED FRAME CUT AND REPAIRED PER COA JIC C9788-71-01. CUT FRAME PER ITEM 4, INSTALL REPAIR PER ITEM 5. A/C READY FOR RETURN TO SERVICE.SDR SWAA063551Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME SECTION IAW SRM.SDR SWAA063550Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME SECTION IAW SRM.SDR SWAA063549Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME SECTION IAW SRM.SDR SWAA063548Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME SECTION IAW SRM.SDR SWAA063547Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063546Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME SECTION IAW SRM.SDR SWAA063545Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063543Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 2L. REPAIRED FRAME SECTION PER SRM.SDR 2007FA0000139Frame · crackedMID CABIN, STATION 500A FRAME, BETWEEN STRINGER 8 AND 9L, CRACKED AT PSU MOUNT RAIL ATTACH POINT. (K)SDR 2007FA0000138Frame · crackedMID CABIN, STATION 480 FRAME, AT STRINGER 8L, CRACKED AT PSU MOUNT RAIL ATTACH POINT. (K)SDR 2007FA0000130Frame · crackedMID CABIN, STATION 400 FRAME AT STRINGER 8R, CRACKED AT PSU RAIL OUNT ATTACH POINT. (K)SDR 2007FA0000127Frame · crackedMID CABIN, STA 500A FRAME, BETWEEN STRINGER 8 AND 9L, CRACKED AT PSU MOUNT RAIL ATTACH POINT. (K)
Back to JASC 5311