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 ZZDA2009224Frame · 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.SDR ZZDA2009223Frame · 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 SWAA095889Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER ER.SDR SWAA095888Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 25L TO STR 26L. REPAIRED FRAME PER ER.SDR SWAA095887Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA095886Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 460, STR 26L. REPAIRED FRAME PER ER.SDR SWAA095885Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA095884Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 21L. REPAIRED FRAME PER ER.SDR SWAA095883Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA095882Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, LBL 19, WL 155. REPAIRED FRAME PER ER.SDR SWAA095881Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA095880Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 13R. REPAIRED FRAME PER ER.SDR SWIA200922731Frame · crackedCOCKPIT OVERHEAD FRAME CRACKED. (C-CHECK) REPAIRED PER SRM.SDR ASOA200900994Frame · crackedFWD SIDE OF FS 640.00 FRAME AT STR 9 CUTOUT RT SIDE CRACKED APPROX .3750 INCH. PERFORMED ET INSPECTION OF STR9 CUTOUT ON RT FS 640 FRAME FWD SIDE IAW CRJ 200 NDTM 51-20-06. RECEIVED RELEVANT INDICATION APPROX 3/8" LONG. REMOVED AND REPLACED RIGHT SIDE 640 FSDR ZZDA2009238Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2984.SDR ZZDA2009237Frame · 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 ZZDA2009231Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2989.SDR ZZDA2009230Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2979.SDR SWAA095840Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095816Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, LBL 65. REPAIRED FRAME PER ER.SDR SWAA095814Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR FDEA200909093273Frame · gougedMAIN CABIN BS 1280 STR 10R FRAME DOUBLER GOUGED. REPAIR DOUBLERS FABRICATED IAW SRM 53-00-07 REPAIR 1 REV 98. REPAIR DOBLER REMOVED AND REPLACED AS PER SRM 53-00-07, REPAIR 1 REV 98. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909093272Frame · gougedMAIN CABIN BS 1280, STR 11L TO 12L FRAME DOUBLER GOUGED. REPAIR DOUBLERS FABRICATED IAW SRM 53-00-07 REPAIR 1 REV. 98. REPAIR DOUBLERS REMOVED AND REPLACED IAW SRM 53-00-07 REPAIR 1 REV. 98. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR C772009F00000Frame · corrodedCORRODION AT BUTT SPLICES AT FRAMES 86,19, 14-18, 16-19, UNDER FLOOR. THESE ARE GALLEY/ENTRANCE WAY AREAS. THIS REPORT IS SUBMITTED DUE TO RECURRING PROBLEM. (K)SDR USAA2009090992438Frame · corrodedSAL - BC-7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON INTERNAL STRUCTURE OF BULKHEAD FRAME AT FR70 BETWEEN S22R TO S23R. REPAIRED INTERNAL STRUCTURE OF BULKHEAD FRAME AT FR70 BETWEEN S22R TO S23R IAW US AIRWAYS EA 132598.SDR SWAA095737Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA095732Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 259.5, STR 11L. REPAIRED WEB PER SRM.SDR SWAA095727Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REMOVED AND REPLACED FRAME SPLICE PER SWA EA.SDR FDEA200909083266Frame · crackedLT MLG WW FOUND CRACK ON FRAME. REPAIRED AREA IAW SRM 53-00-01 FIG 8 SHT 2 VOL I.SDR LR7A2009090900123Frame · crackedDURING SCHEDULED C-9 CHECK PER JOB CARD HC5315, FOUND AFT FUSELAGE INTERIOR UPPER BULKHEAD FORMER CRACKED AT FS 968, WL 280, RBL 60. REPAIRED IAW SRM SMP583 FIG 51-140-21.SDR LR7A2009090900104Frame · crackedDURING SCHEDULED C-9 CHECK PER JOB CARD HC5314, FOUND UNDERFLOOR FRAME STRUCTURE CRACKED AT FS 588, WL 130, RBL 20. REPAIRED IAW SRM SMP583 FIG 51-140-21.SDR EIAA200900103AFrame · crackedFRAMES AT LEFT BS 440, STR 10-10A AND BS 460, STR 0-16 CRACKED. ASSOCIATED FRAMES BS 420 AND BS 480 SHOWED NO DAMAGE. FRAMES AT BS 440 AND BS 460 WERE REPLACED PER ECRA 485-53-191-1.SDR EIAA20090906001Frame · crackedSUPPLEMENTAL INFORMATION: FRAMES AT LEFT BS 440, STRINGER 10-10A AND BS 460, STRINGER 0-16 CRACKED. ASSOCIATED FRAMES BS 420 AND BS 480 SHOWED NO DAMAGE. FRAMES AT BS 440 AND BS 460 WERE REPLACED PER ECRA 485-53-191-1.SDR ASAA0996537Frame · corrodedCORROSION ON FRAME IN AFT CARGO BAY BS 787 RBL 25.SDR ASAA0996539Frame · corrodedCORROSION ON FRAME IN AFT CARGO BAY BS 767 RBL 25. REMOVED AND REPLACED FRAME SPLICE.SDR QXEA2009090900659Frame · corrodedDURING INSPECTION FOUND CORROSION AT FS 517.00 S18L. CORROSION IS ON BOTH SIDE OF THE FRAME. BLENDED SURFACE CORROSION FROM AFFECTED AREAS. REMOVED ALL CORROSION. ALL WORK DONE IAW SRM 51-11-00, 51-12-00, AND 51-21-06.SDR ASAA0946574Frame · crackedFRAME CRACKED AT STA 360 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946569Frame · crackedCABIN FRAME CRACKED AT STA 867 BETWEEN STR 8L AND 9L IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946568Frame · crackedCABIN FRAME CRACKED AT STA 867 BETWEEN STR 8R AND 9R IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946567Frame · crackedCABIN FRAME CRACKED AT STA 827 BETWEEN STR 8R AND 9R IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946566Frame · crackedCABIN FRAME CRACKED AT STA 380 BETWEEN STR 8R AND 9R IS CRACKED. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946563Frame · crackedCABIN FRAME CRACKED AT STA 907 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946562Frame · crackedCABIN FRAME CRACKED AT STA 907 BETWEEN STR 8R AND 9R. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946561Frame · crackedCABIN FRAME CRACKED AT STA 787 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946560Frame · crackedCABIN FRAME CRACKED AT STA 787 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR ASAA0946558Frame · crackedCABIN FRAME CRACKED AT STA 827 BETWEEN STR 8L AND 9L. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER EA.SDR IPXA09557297Failsafe · damagedINSPECTION TYPE: N/A STA 1640 FRAME FAILSAFE CHORD SPLICE BETWEEN STR 25 AND 26R DAMAGED. REPAIRED PER EO B757-5310-27595-C.SDR GLBA20090904JFrame · bentUPON INSP OF ACFT THE LWR CTR FRAME SECTION WAS FOUND BENT AT FS 13630.0 FRAME 40 BETWEEN STR 20L AND 21L. MX REPLACED THE LWR FRAME SECTION ON FRAME 40 IAW EO 09-120-53-009. RII INSP COMPLIED IAW EO 09-120-53-009. MATERIALS UTILIZED ARE INCLUDED IN THE EO.SDR SWAA095703Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SWA EA.SDR GLBA2009090409HFrame · bentMAJOR REPAIR - UPON INSP OF ACFT, LWR SECTION FRAME WAS FOUND BENT AT FS 12860.0, FRAME 38 BETWEEN STR 20L AND 21L. MX REMOVED AND REPLACED THE CTR FRAME SECTION 38 IAW EO 09-120-53-015 RII INSP COMPLIED WITH IAW EO 09-120-53-015 . MATERIALS UTILIZED ARE IN
Back to JASC 5311