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 IPXA11565531Frame · damagedINSPECTION TYPE:C4, DAMAGE TO FRAME 820, STRINGER 15L MAIN CARGO DECK, DRILLED OUT DAMAGE TO .199 AND INSTALLED BACR15BB6AD RIVET IAW EO B757 -5310-39560.SDR IPXA11565463Frame · damagedINSPECTION TYPE:C3, MAIN DECK FRAME INNER FLANGE, HAS 2 EA SCREW STRIKE IN A 1" AREA, BETWEEN STR 15R-16R, BS 500, MARKED REPAIRED IAW ATS ER 11-01688.SDR IPXA1565435Frame · damagedINSPECTION TYPE:C-3, MAIN DECK FRAME INNER CHORD, HAS 6 EA SCREW STRIKES BETWEEN STR 7R -STR 12R BS 365, MARKED. REPAIRED ATS ER 11-01693.SDR IPXA1565428Frame · damagedINSPECTION TYPE:C3, MAIN DECK FRAME INNER FLANGE, HAS 1 EA SCREW STRIKE AT STR 5L BS 395, MARKED. REPAIRED IAW ATS ER 11-01691.SDR IPXA1565427Frame · damagedINSPECTION TYPE:C3, MAIN DECK FRAME INNER FLANGE HAS 1 EA, SCREW STRIKE AT STR 9L BS 395 MARKED. REPAIRED IAW ATS ER 11-01692.SDR SWAA111003Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA111000Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT FAIL SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110999Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT FAIL-SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110996Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 482A, STR 22R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA110965Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 482, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM AND SI.SDR ASAA1149215Frame · crackedBS 827 FRAME CRACKED BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149213Frame · crackedBS 747 FRAME CRACKED BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149211Frame · crackedBS 787 FRAME CRACKED BETWEEN STR 8R AND 9R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR USAA2011022190841Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 559, S10L - S14L. REPAIRED FRAME AT BS 559, S10L - S14L IAW EA 102700 AND B737 SRM 53-00-07.SDR ASOA201100289Frame · corrodedCORROSION ON LT AND RT RADIUS ON STR 27, 3-3.5 INCHES FWD OF FRAME 349. REMOVED CORROSION IAW SRM 51-21-06. BLENDED AREAS EXCEED LIMITS IAW SRM 53-00-00, FIG 101, SHEET 3 AND SRM 51-31-59, FIG 3, CUT AND REMOVED STRINGER SECTION IAW SRM 53-00-03, FIG 202. SDR ASOA201100287Frame · corrodedFOUND CORROSION AT FS333 BETWEEN STR 25L AND 25R. REMOVED CORROSION IAW SRM 51-21-06 AND 51-42-06.SDR ASOA201100286Frame · corrodedFOUND CORROSION AT FS349 BETWEEN STR 25L AND 25R. BLENDED IAW SRM 51-12-00.SDR DALA1110859873Frame · crackedMAIN CABIN STA 180, FRAME IS CRACKED AT L4L, ABOVE L-1 DOOR. STOP DRILLED CRACK IAW SRM 53-01, FIG 2 FABRICATED ANGLE, FILLER, GUSSET AND SHIM. LOCATED AND DRILLED ALL REPAIR PARTS IAW SRM 53-03, FIG 36, SHEET 1 &51-10-2 INSTALLED IAW SRM 53-03, FIG 36. REQSDR DALA1110560921Frame · crackedFUSELAGE FRAME AT STA 1418 L8L/R CRACKED. REPAIRED IAW ER/A 489670-14.SDR EE4Y20110106Frame · corrodedLOWER FUSELAGE MID CARGO COMPARMENT YSTA 598 BETWEEN LONGERON 27LT AND 27RT FRAME CORRODED.SDR ASAA1149218Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 LT SIDE AT BS 787. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149217Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 LT SIDE AT BS 360. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149216Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 RT SIDE AT BS 400. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149214Frame · crackedFUSELAGE FRAME IS CRACKED BS 400 BETWEEN STR 8R AND STR 9R. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149212Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 LT SIDE AT BS 867. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149210Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 LT SIDE AT BS 747. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR ASAA1149209Frame · crackedFUSELAGE FRAME IS CRACKED AT OVERHEAD BIN RAIL ATTACHMENT BETWEEN STRINGERS 8 AND 9 RT SIDE AT BS 867. REPAIRED FRAME IAW ASA EA AD20062609 400 53 116 DATED 25 FEB 11.SDR USAA2011021890801Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 727D, S8L - S9L. REPAIRED FRAME AT BS 727D, S8L - S9L IAW EA 102619.SDR IPXA1164731Frame · gougedGOUGE TO FUSELAGE FRAME 42.5, STR 40 R. REPAIRED IAW EO A300-5330-32996-D.SDR JR2R2011021300011Frame · corrodedFS 364 STR 25 R/L FRAME CORRODED O/B OF O/B DIAPHRAM. REPAIRED FRAME IAW RO CRJ7-53-5402.SDR FDEA201102120549Frame · gougedMDC FRAME AT STA 1280 HAS GOUGES ON AREAS BETWEEN STR S11L & S17L. REPAIRED IAW EA F-5310-146523, MAJOR REPAIR.SDR SWAA110875Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA110874Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA110867Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA110865Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 296.4, STR 17R. REPAIRED FRAME PER EA.SDR SWAA110862Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA110859Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 420, BETWEEN STR 18R TO STR 19R. REPAIRED FRAME PER EA.SDR SWAA110834Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA110833Doubler · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME DOUBLER CORRODED AT BS 793, STR 25R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA110796Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO FRAME CRACKED AT BS 807, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA110746Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA110745Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR CALA2011032400176Frame · crackedFRAME CRACKED STA 867 AT S-9R. INSTALLED REPAIR ANGLES A&B REF EA 5310-04498 REV A OP2.SDR CALA2011032400175Frame · crackedFRAME CRACKED STA 907 AT S-9L. CTN53-304-108 INSTALLED REPAIR ANGLES A&B REF EA 5310-04498 REV A.SDR CALA2011032400177Frame · crackedFRAME CRACKED STA 907 AT S-9R CTN53-304-108 INSTALLED REPAIR ANGLES A&B PER EA.5310-04498, REV-A.SDR ASOA201100265Frame · corrodedFOUND CORROSION AT FS 364.00 AND BETWEEN S26L AND 25L. BLENDED CORROSION IAW SRM 51-21-06. FOUND TO BE WITHIN LIMITS IAW SRM 53-21-15, FIG 6, ITEM 5.SDR IPXA1564699Frame · dentedINSPECTION TYPE:C3, AFT PIT STA 1300, RBL 26", FRAME DENTED REPAIRED IAW EA 110056 AND EO B757-5310-41366.SDR USAA2011032291167Frame · crackedCLT - Q2 - CRACK ON FUSELAGE FRAME AT BS 380 BETWEEN S8L & S9L. REPAIRED FUSELAGE FRAME AT BS 380 BETWEEN S8L & S9L IAW EA 102619.SDR FDEA201102100531Frame · crackedDURING HFEC OPEN HOLE INSP, CRACK INDICATION FOUND AT LT FRAME 44, HOLE 'B' ON FRAME. REPAIRED PER E.A. 6-5310-143509, REPAIR CLASSIFIED MINOR PER GMM 6-2-100 REVISION 111.SDR FDEA201102100533Frame · crackedDURING HFEC OPEN HOLE INSPECTION, CRACK INDICATION FOUND AT RT FRAME 44, HOLE 'B' ON FRAME. REPAIR CARRIED OUT PER E.O. 6-5310-7-5006A1 PART 2, . REPAIR CLASSIFIED MAJOR PER GMM 6-2-100 REVISION 111.
Back to JASC 5311