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 KCSA081388Frame · crackedBS 460 3.00 INCH ABOVE S12L FRAME OUTBOARD FLANGE CRACKED IN RADIUS OF DOUBLER .375 INCH LONG AFT SIDE. CRACK MARKED. UPPER DECK. (S)SDR KCSA081387Frame · crackedBS 460 S12L FRAME DOUBLER AFT SIDE CRACKED .375 INCH AT STRINGER CUTOUT, INBOARD UPPER CORNER. CRACK MARKED. UPPER DECK. (S)SDR KCSA081386Frame · crackedBS 460 S12R FRAME DOUBLER AFT SIDE CRACKED .500 INCH AT STRINGER CUTOUT, INBOARD UPPER CORNER. CRACK MARKED. UPPER DECK. (S)SDR KCSA081385Frame · crackedBS 460 ABOVE S12R APPROX 1 INCH FRAME OTBD FLANGE CRACKED AT FASTENER HOLE. CRACK .250 INCH LONG. CRACK MARKED. UPPER DECK. (S)SDR KCSA081384Frame · crackedBS 440 S10R FRAME CRACKED .500 INCH AT STRINGER CUTOUT. CRACK MARKED UPPER DECK. (S)SDR KCSA081383AFrame · crackedBS 440 S10R FRAME OUTBOARD FLANGE CRACKED IN RADIUS .375 INCH CRACK MARKED UPPER DECK. (S)SDR KCSA081381AFrame · crackedBS 460 3.00 INCH ABOVE S12L FRAME OUTBOARD FLANGE CRACKED IN RADIUS OF DOUBLER .375 INCH LONG AFT SIDE. CRACK MARKED UPPER DECK. (S)SDR KCSA081380AFrame · crackedBS 460 S12L FRAME DOUBLER AFT SIDE, CRACKED .375 INCH AT STRINGER CUTOUT, INBOARD UPPER CORNER. CRACK MARKED UPPER DECK. (S)SDR KCSA081379AFrame · crackedBS 460 S12R FRAME DOUBLER AFT SIDE CRACKED .500 INCH AT STRINGER CUTOUT, INBOARD UPPER CORNER. CRACK MARKED UPPER DECK. (S)SDR KCSA081378AFrame · crackedBS 460 ABOVE S12R APPROX 1 INCH, FRAME OUTBOARD FLANGE CRACKED AT FASTENER HOLE. CRACK .250 INCH LONG. MARKED UPPER DECK. (S)SDR KCSA081377Frame · dentedFWD PIT BS640 FUSELAGE FRAME DENTED AT LBL29, WL101. (S)SDR KCSA081376Frame · dentedFWD PIT BS640 FUSELAGE FRAME DENTED AT LBL26, WL112. (S)SDR KCSA081375Frame · dentedBS 700 FUSELAGE FRAME WEB DENTED ABOVE STR 47R. (S)SDR COMA086346Frame · crackedLT SIDE 640 FRAME CRACKED. REPAIRED LT FS 640 FRAME, PER REO 601R-53-061, 601R-53-506, 601R-61-569, & 601R-53-61-366. (S)SDR COMA086344Frame · crackedRT SIDE 640 FRAME CRACKED. REPAIRED RT SIDE FS 640 FRAME IAW REO 601R-53-61-366, 601R-53-61-506, 601R-53-61-569. (S)SDR SWAA084442Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084436Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA084435Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA084428Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 26R. REPAIRED PER SRM & ER.SDR 08FDEA03358Frame · chafedFRAME DAMAGED STA 360 STR 2R. CUTOUT DAMAGED AREA DIMS 1 1/8 INCH BY 1 INCH, FABRICATED REPAIR ANGLE FROM 7075-0 .063 PO NR 9007470 DIMS 9 INCH BY 3 INCH BY 1 INCH. INSTALLED REPAIR ANGLE AT BS 360 STR 2R IAW B727 SRM 53-10-4 FIG 2 AND SRM 53-10-2 FIG 3.SDR COMA086351Doubler · crackedRT SIDE FUSELAGE FRAME DOUBLER AT FS 640.00 IS CRACKED. COMPLIED WITH MODIFICATION K601R360094 AT FS 640 IAW S/B 601R-53-061. (S)SDR COMA086350Frame · crackedLT SIDE FUSELAGE FRAME DOUBLER AT FS 640.00 IS CRACKED. COMPLIED WITH MODIFICATION K601R36009-R AT FS 640 IAW S/B 601R-53-061. (S)SDR FDEA200808083319Frame · corrodedAIR CONDITIONING COMPT PACK NR 1, FOUND EXFOLIATION CORROSION ON CAP ANGLE AND CLIP. REPAIRED AREA IAW SRM 53-00-01 FIG 8 SHT 1, 3, 4 VOL I.SDR AALA200802329Frame · crackedAFW WHILE ACCOMPLISHING MX NDT FOUND INDICATIONS OF CRACKING AT RT OUTER CHORD AT LOWER AFT FASTENER AT 12A. HOLE REAMED TO .2807 INCH TO REMOVE CRACKING. REPLACED WITH OVERSIZED FASTENER PER MRB 767 3273.SDR SWIA200820066Frame · crackedC-CHECK, CRACK IN FRAME IN FRONT OF LEFT HEAT EXCHANGER. INSTALLED DOUBLER.
SDR SWIA200820065Frame · crackedC-CHECK, CRACK IN FRAME IN FRONT OF RIGHT HEAT EXCHANGER. INSTALLED DOUBLER REPAIR ON FRAME.
SDR 2008UALA04188Frame · damagedFRAME AT BS 1360 STR 27R-28R HAS DAMAGE. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW FRAME REPAIR.SDR FDEA200808073297Frame · crackedAVIONIC COMPT FOUND CRACK ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 5 VOL I.SDR 08FDEA03303Frame · wornLT AIR COND COMPT FOUND DEEP WEAR ON FRAME. REPAIRED AREA IAW SRM 53-00-00 FIG 4A VOL I.SDR 2008UALA04174Frame · dentedFWD PIT STA 640 FRAME, INNER FLANGE BETWEEN S-25R-24R DENTED. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED PRODUCTION SPLICE AND FABRICATED A REPAIR ANGLE AND INSTALLED PER SRM 53-00-07, REPAIR 5 ON NON ROUTINE. THIS IS A CAT B REPAIR IN ZONE 1 AND REQUSDR USAA920081503Frame · crackedCLT-Q6 - MAJOR REPAIR - CRACK ON FRAME AT BS 360 BETWEEN S8L & S9L. REPAIRED FRAME AT BS 360 BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E. (S)SDR 08FDEA03297Frame · crackedAVIONIC COMPT FOUND CRACK ON FRAME.SDR SWAA084412Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA084405Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084404Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084403Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR UPS08M53466Frame · corrodedINSPECTION TYPE:N/A CTR CARGO FRAME AT STA 1841 BILGE AREA BETWEEN L50 - L52 RT FOUND CORROSION. FRAME CHANNEL CORROSION REMOVED AND REPROTECTED AS PER SRM 51-21-01 MATERIAL REMOVED 0.008" ORIGINAL THK 0.071" REMAINED THK 0.063" FOUND WITHIN LIMIT PER SRM 53-SDR UPS08M53465Frame · corrodedINSPECTION TYPE:N/A CTR CARGO FRAME AT STA 1801 BILGE ARE L52 FOUND CORROSION. FRAME CHANNEL CORROSION REMOVED AND REPROTECTED PER SRM 51-21-01. MATERIAL REMOVED 0.006" ORIGINAL THK 0.071" REMAINED THK 0.065" FOUND WITHIN LIMIT PER SRM 53-30-00.SDR UPS08M53464Frame · corrodedINSPECTION TYPE:N/A CTR CARGO FRAME AT STA 1741 BILGE AREA BETWEEN L51 - L52 LT FOUND CORROSION. FRAME SHEAR CLIP CORROSION REMOVED AND REPROTECTED AS PER SRM 51-21- 01. MATERIAL REMOVED 0.009" ORIGINAL THK 0.071" REMAINED THK 0.062" FOUND WITHIN LIMIT PER SSDR UPS08M53463Frame · corrodedINSPECTION TYPE:N/A CTR CARGO FRAME AT STA 1721 BILGE ARE L52 FOUND CORROSION. FRAME CHANNEL AND SHEAR CLIP CORROSION REMOVED AND REPROTECTED AS PER SRM 51-21-01. MATERIAL REMOVED 0.007" ORIGINAL THK 0.071" REMAINED THK 0.064" FOUND WITHIN LIMITS PER SRM 53-SDR UPS08M53462Frame · corrodedINSPECTION TYPE:N/A CTR CARGO FRAME AT STA 1661 BILGE AREA BETWEEN L51 LT & RT FOUND CORROSION. FRAME SHEAR CLIP CORROSION REMOVED AND REPROTECTED AS PER SRM 51-21- 01. MATERIAL REMOVED 0.005" ORIGINAL THK 0.071" REMAINED 0.066" FOUND WITHIN LIMIT PER SRM 53SDR USAA920081490Frame · crackedCLT-Q6 -MAJOR REPAIR- FRAME CRACKED AT BS 887 BETWEEN S8L AND S9L. REPAIRED FRAME AT BS 887 BETWEEN S8L AND S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E. (S)SDR CALA0800774Frame · crackedFRAME CRACKED STATION 747 AT S-9L. REPAIRED FRAME PER EA 5310-04498, OP 2.SDR 08FDEA03292Frame · crackedFRAME 44 FROM STRINGER 25L TO STRINGER 26L, FASTENER HOLE "B" AS CALLED OUT IN EO E6-5310-7-5006 PT1 STEP 70 STILL SHOWS A CRACK INDICATION AFTER REAMING IT TO A MAX SIZE OF 0.437. REMOVED FRAME 44 SECTION FROM S22-27L IAW SRM 51-40-21, PARA 'S 6 AND 7. RECESDR SWAA084384Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084383Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084380Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084388Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 25L. REPAIRED FRAME PER SRM.SDR 2010FA0000358Frame · cracked(KADY) A CRACK WAS FOUND ON THE FRAME AT STA 1680, S13R-S14R.SDR CALA0800852Frame · crackedCABIN STA 380 FRAME CRACKED BETWEEN S8-9L. INSTALLED REPAIR PER EC/RA 5310-04824 REV A.
Back to JASC 5311