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 SIMA2012032003Frame · corrodedDURING C CHECK FOUND FRAME FS 661.00 CORRODED BETWEEN STRINGERS 26 LEFT AND 26 RIGHT. THE AIRCRAFT WAS REMOVED FROOM SERVICE. REPAIRED FRAME FS661.00 IAW ECN CR-53MR-264 R1 01. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR REXA2012022300245Frame · crackedFRAME AT FS 333 S-24R CRACKED AT STRINGER CUTOUT. REPAIRED IAW BOMBARDIER REO 690-53-21-322.SDR IPXA12571789Frame · damagedINSPECTION TYPE:C, MAIN CARGO COMPARTMENT AT STA 1260 ISOLATOR BETWEEN STR 6L AND 7L HAS DOUBLE DRILLED HOLES. REPAIRED DAMAGE FRAME AT STA 1260, STR 6L IAW SRM 53-00-07-2 R-1 REPAIR 1 FIG 202, DETAIL 2.SDR IPXA12571739Frame · dentedINSPECTION TYPE:C, FWD CARGO BAY STA 760, FRAME FLANGE DENTED AT STRINGER 24L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-02-2R 5, REPAIR 5, DETAIL III.SDR IPXA2571719Frame · dentedINSPECTION TYPE:C, FWD CARGO BAY BS 800, FRAME FLANGE DENTED ABOVE STR 25R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R5, DETAIL III.SDR IPXA2571679Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT STA 720 FRAME FREE FLANGE DENTED AT STRINGER 23R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R, REPAIR 5.SDR IPXA2571676Frame · dentedINSPECTION TYPE:C-CK FWD CARGO COMPARTMENT STA 680 FRAME FREE FLANGE DENTED AT STRINGER 25R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R, REPAIR 5.SDR CALA2012013000060Frame · crackedSUPPORT TASK - FRAME REPAIR SIGN OF CRACK ON FRAME STA 500A R REPAIR FRAME AT STA 500A RT IAW EA 5310-04716.SDR CALA2012013000059Frame · crackedFRAME SHOWS SIGN OF A CRACK ON FRAME STA 747L. REPAIRED FRAME IN ACCORDANCE WITH EA 5310-04716 REV C.SDR CALA2012013000058Frame · crackedFRAME SHOWS SIGN OF A CRACK ON FRAME STA 787L. REPAIRED FRAME IN ACCORDANCE WITH EA 5310-04716 REV C.SDR CALA2012013000057Frame · crackedFRAME SHOWS SIGN OF A CRACK ON FRAME STA 747R. CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER IN REF EA 5310-04716 REV C.SDR CALA2012013000056Frame · crackedSUPPORT TASK - FRAME SHOWS SIGN OF A CRACK ON A FRAME AT STA 787R. REPAIRED PER ECRA 5310-04716 REV C , PARTIAL WORK ACCOMPLISHED FORM 44.0008 ATTACHED.SDR SWAA120650Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 616, LBL 66. REPAIRED WEB IAW EA.SDR SWAA120649Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME SECTION IAW EA.SDR SWAA120648Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME SECTION IAW EA.SDR SWAA120647Support Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME SUPPORT ANGLE CRACKED AT BS 500D, STR 21R. REMOVED AND REPLACED ANGLE PER SRM.SDR IPXA12571813Frame · damagedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT STA 1240, BETWEEN STR 6L AND 7L SIDEWALL ISOLATOR HAS PLUGGED FASTENERS VERY CLOSE TO ISOLATOR FASTENERS REPAIRED IAW EA 120138 IR AND EO B757-5310-45958-A.SDR DALA1207000182Strap · crackedFAIL SAFE STRAP FAILED U/T INSPECTION AT LT BS 955 REPAIR REQUIRED. BS 955 REAR SPAR BULKHEAD LT FAIL SAFE STRAP REPAIRED PER ERA 499093-14AD REV 0 09FEB2012 (ERA 499093-14AD).SDR IPXA12571500Frame · dentedINSPECTION TYPE:C-CK, BS 1500 FRAME FLANGE AT STR 26L IS DENTED. REPAIRED IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 1.SDR A6WA201240222Frame · corrodedFWD AND AFT SIDE OF FS 349 FRAME BETWEEN STRINGER 26R AND 26L IS CORRODED. R & R FRAME.SDR CALA2012013000054Frame · crackedSUPPORT TASK FRAME SHOWS SIGN OF A CRACK ON A FRAME AT STA 827L. REPAIR PER ECRA 5310-04716. PARTIAL WORK ACCOMPLISHED FOR 44.0008 ATTACHED.SDR CALA2012013000053Frame · crackedSUPPORT TASK FRAME SHOWS SIGN OF A CRACK ON A FRAME AT STA 867R. REPAIR FRAME AT STA 867R PER ECRA 5310-04716. PARTIAL WORK ACCOMPLISHED FORM 44.008 ATTACHED.SDR AALA20120126TUL02Frame · damagedRIGHT CANT FRAME 1463 MISDRILLED. ACCOMPLISHED REPAIR PER EA MD80-53-021470.SDR SWAA201201201Frame · crackedFRAME WEB CRACKED AT BS 188, RBL 32. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR DALA1204010192Strap · crackedHMV2 FAIL SAFE STRAP CRACKED STA 995 LT SIDE OPN 8701AD. REPAIR PER ERA 499083-14AD REV 0.SDR AALA20120126TUL12Frame · crackedAFT ACCS- 1485 CANT FRAME CRACKED BELOW STAIR RET ACTUATOR. INSTALLED DOUBLER REPAIR PER AARD 53-10-00-33.SDR SWAA120614Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA120610Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA120589Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA120588Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA120580Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 19L. REPAIRED FRAME PER SRM AND DWG.SDR SWAA120577Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME IAW EA.SDR SWAA120576Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR CALA2012012600050Frame · crackedSUPPORT TASK REF EA 5310-04716 BRACKET AT FRAME 400 R INBOARD RIVET HOLE CRACKED. FRAME 400 R BETWEEN STR'S 8 R AND 9 R HAS BEEN REPAIRED IAW ECRA 5310-05441.SDR CALA2012012600049Frame · crackedSUPPORT TASK REF EA 5310-04716 BRACKET AT FRAME 400 L INBOARD RIVET HOLE CRACKED. FRAME 400 L BETWEEN STR'S 8 L AND 9 L HAS BEEN REPAIRED IAW ECRA 5310-05441.SDR QXEA2012012600083Frame · corrodedFRAME 28 ANGLE HAS MISSING SURFACE PROTECTION AND POSSIBLE CORROSION STR 25P-24P. ACFT IS DOWN FOR C-CHECK. ANGLE FOUND TO BE OUT OF LIMITS DUE TO CORROSION IAW SRM 53-20-15-00-01. REMOVED ANGLE IAW SRM 51-42-05-02-01. TREATED AND PAINTED NEW ANGLE THAT WASDR QXEA2012012600082Frame · corrodedFRAME 8 ANGLE HAS MISSING SURFACE PROTECTION AND POSSIBLE CORROSION STR 25P-24P. ACFT IS DOWN FOR C-CHECK. FOUND ANGLE TO BE OUT OF LIMITS, DUE TO CORROSION IAW SRM 53-20-15-00-01. REMOVED ANGLE IAW SRM 51-42-05-02-01. FABRICATED, TREATED AND PAINTED NEW ASDR DALA1209970139Frame · crackedMAIN DECK BS 903 RBL 89 FRAME CRACKED. REPAIRED PER ERA 499047-14AD REV ORIG SECT 1.SDR DALA1209840139Frame · crackedMAIN DECK BS 903 LBL 89 FRAME CRACKED. REPAIRED PER ERA 499046-14AD REV ORIG.SDR DALA1209490139Frame · crackedMAIN DECK BS 883 LBL 89 FOUND FRAME CRACKED. REPAIRED PER ERA 499048-14AD REV ORIG SECTION 1.SDR DALA1209430139Frame · crackedMAIN DECK BS 883 RBL 89 FRAME CRACKED. REPAIR ACCOMPLISHED PER ERA 499049-14AD REV ORIG SECTION I.SDR IPXA12571561Frame · dentedINSPECTION TYPE:C-CK, AFT LOWER CARGO COMPARTMENT STA 1540, STRINGER 25L, TOP OF FRAME DENTED. REPAIRED AFT LOWER CARGO COMPARTMENT STA 1540, STR 25L IAW SRM 5 3-00-07-2R, REPAIR 5, DETAIL 3, REV 82.SDR SWAA2012020901271Frame · crackedCRACK ON STUB FRAME AT BS 294.5, STR 10R INTERNAL CUT OUT FWD GALLEY DOOR. REPLACED STUB FRAME LOCATED IAW SRM AND DWG.SDR HNAA2012012500502Frame · crackedFRAME CRACKED IN FLIGHT COMPARTMENT RT SIDE AT STA X136.8 AND STR 15. R & R FRAME IN FLIGHT COMPARTMENT RT SIDE. INSTALLED WITH NEW SOLID RIVET AND HI-LOK IAW SRM 57-42-05 AND SRM 51-40-10.SDR SWAA120729Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA120728Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA120726Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, STR 16R. REPAIRED CHORD PER EA.SDR SWAA120725Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA120603Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND STUB FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME IAW SRM.SDR KCSA121006Frame · crackedBS 2701.5 WL 315 LBL 36 FRAME IS CRACKED AT STIFFENER HOLES.
Back to JASC 5311