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 AALA20091215TUL04Frame · crackedAFT FUSELAGE CANT FRAME WEB AT STATION 1463 CRACKED AT LONGERON 18 RIGHT. STOP DRILLED CRACK AND INSTALLED DOUBLER.SDR AALA20091215TUL03Frame · corrodedCORROSION AT FRAME STATION 1309. INSTALLED FRAME SPLICE PER SRM 53-03-0.SDR SWAA097781Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 867, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097780Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097766Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND LOWER FWD CORNER STUB FRAME CRACKED AT R1 DOOR. REPAIRED FRAME PER SRM.SDR SWAA097763Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 294 BETWEEN STR 5L TO STR 6L. REPAIRED FRAME PER SRM.SDR QXEA2009121601064Frame · corrodedC5 CHECK - CORROSION FOUND AT FS 333.00 BETWEEN STR 26R - STR 25R. BLENDED OUT CORROSION IAW SRM 51-21-06-001-001-A01, FOUND TO BE OUT OF LIMITS IAW SRM 53-21-06-101-002-A01. PERFORMED ECI IAW NDTM 51-20-06. SENT FOR REO. ETCHED , ALODINED AND PRIMED IAW SSDR FDEA200912154473Frame · damagedFWD ACCY COMT-AREA FWD OF NLG W/W - FRAME 231.25 AT BL0 (FRAME, FRAME REPAIR, INTERCOSTAL UPPER PLATE AND DOORLOCK FITTING) DAMAGED "CHAFED AND GOUGED". BLENDED GOUGE IN REPAIR DOUBLER IAW SEM 51-10-02. L=.100",W=.250",D=.023", FOUND OUT OF LIMITS IAW SRM 53-SDR FDEA200912154471Frame · gougedFRAME AT STA 1280 RT, STR 14-10 HAS GOUGES. REPLACED FRAME SEGMENT FROM STR 7R TO 14R IAW SRM 51-40-05. FRAME SEGMENT FABRICATED ON MAE TR T/9/812786, CHANNEL 1 FABRICATED ON MAE TR T9/812787, CHANNEL 2 FABRICATED ON MAE TR T9/812788. ORIG MAT'L .071 AFTER SDR SWAA097760Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 13R. REPAIRED FRAME PER EA.SDR SWAA097759Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 847, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097758Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097757Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097752Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097751Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097750Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097749Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097748Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097742Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097741Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097732Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 639, LBL 46. REPAIRED FRAME PER SRM.SDR SWAA097731Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 616, RBL 65. REPAIRED FRAME PER SRM.SDR ASOA200901406Frame · corrodedFS 349.0 FRAME CORRODED STR 26L TO STR 27 FWD SIDE OF FRAME.SDR ASOA200901405Frame · corrodedFS 333.0 FRAME CORRODED STR 26R TO STR 27 FWD AND AFT SIDES.SDR ASOA200901404Frame · corrodedFS 319.70 FRAME CORRODED STR 26R AFT SIDE.SDR ASOA200901403Frame · corrodedFS 310.0 FRAME CORRODED STR 26R TO STR 27 AFT SIDE.SDR AALA20091212TUL01Tripler · crackedAFT FUSELAGE FRAME 1463 TRIPLER CRACKED AT LONGERON 18 LEFT. REMOVED CRACKED TRIPLER AND INSTALLED NEW REPAIR DOUBLER AND TRIPLER.SDR FDEA200912124433Frame · misrepairedEXISTING REPAIR AT MAIN DECK CARGO RT STA 535 FRAME, 9G NET LWR YOKE SUPPORT. EXISTING REPAIR AT MAIN CARGO RT STA 535 9G NET LWR SUPPORT YOKE EVALUATED AND FOUND NOT IAW ANY SRM REPAIR SASCO 304. EXISTING REPAIR AT MAIN DECK CARGO RT STA 535 9G NET LWR SUPPSDR FDEA200912124432Frame · misrepairedEXISTING REPAIR AT MAIN DECK CARGO LT STA 535 FRAME 9G NET UPPER SUPPORT YOKE. EXISTING REPAIR AT MAIN DECK CARGO LT STA 535 9G NET LWR SUPPORT YOKE EVALUATED & FOUND NOT IAW ANY SRM REPAIR . EXISTING REPAIR AT MAIN DECK CARGO LT STA 535 9G NET LWR SUPPORT YOSDR FDEA200912124431Frame · misrepairedEXISTING REPAIR AT MAIN DECK CARGO LT STA 535 FRAME, 9G NET UPPER SUPPORT YOKE EVALUATED AND FOUND NOT IAW ANY SRM REPAIR. REPAIR CARRIED OUT IAW EA NR 1-5310-137502, THIS REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 109.SDR ASAA0947141Frame · crackedTHE 727 FRAME IS CRACKED 2 EA PLACES AT STR 14L & 15L. REPAIRED CRACKED FRAME.SDR AALA20100108TUL19Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET STATION 867 LEFT SIDE AT INBOARD FASTENER. REPAIRED FRAME 867 LEFT PER ECO J1159AC.SDR AALA20100108TUL16Frame · crackedRIGHT FRAME 727B CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER. REPAIRED FRAME 727B PER ECO J1159AC.SDR 2010FA0000137Profile · corrodedFRAME TOP PROFILE AT FRAME 62LY .478-844 HAS CORROSION. REMOVED AND REPLACED PROFILE IAW SRM.SDR 2010FA0000136Profile · corrodedFRAME TOP PROFILE AT FRAME 62 RY .479-644 HAS CORROSION. REMOVED AND REPLACED PROFILE IAW SRM 51-00-000.SDR 2010FA0000104Frame · corrodedTOP PROFILE OF FRAME AT STA X6415-X6538 HAS CORROSION. R & R PROFILE IAW SRM 51-20-01, 51-10-02, 51-40-02, CRM 51-21-04, 51-21-08.SDR V0XR201001110014Doubler · corrodedDOUBLER AT RT .479 FRAME 20R HAS CORROSION. R & R DOUBLER.SDR V0XR201001110012Frame · corrodedFRAME TOP PROFILE AT FRAME 62 RY .479 - .644 HAS CORROSION. REMOVED AND REPLACED PROFILE. W/C 1088SDR V0XR201001110011Frame · corrodedFRAME TOP PROFILE AT FRAME 62 LY .479 HAS CORROSION. R & R PROFILE.SDR C2XA09SH490Frame · crackedSHV - DURING C-CHECK, FR 10 CRACKED AT STR 10L. REMOVED AND REPLACED FRAME IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR A6WA201040023Frame · chafedFRAME AT FS 718.00 BTW STR 16R-17R CHAFED BY ACMP NR 2 SUCTION LINE. FRAME AT FS 718 BTW STR 16R-17R. REPAIRED IAW REO 601R-53-61-3449, REV A.SDR AALA20091215AFW01Frame · corrodedLIGHT CORROSION WAS FOUND ON THE AFT CARGO STATION 1263 FRAME INNER CHORD VERTICAL AFT SURFACE AT APPROXIMATELY RIGHT BUTTLINE 16. REMOVED CORROSION, ACCOMPLISHED SURFACE AND OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION FOR CRACKS. FABRICATED REPAIR ANGLSDR AALA20091210TUL04Frame · crackedCANT FRAME 1497 CRACKED AT LINE SUPPORT BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-008359.SDR SWAA097693Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 380, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097692Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 380, STR 22L. REPAIRED FRAME PER SRM.SDR SWAA097691Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097690Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097685Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR ZZDA2009403Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR ZZDA2009402Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.
Back to JASC 5311