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 SWAA117238Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA117237Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 348.2, STR 17L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA117233Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA117232Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR ASOA201102002Frame · corrodedFRAME CORRODED AT FS 319.70 BETWEEN S25R & S25L. REMOVED CORRODED FRAME SECTION AND INSTALLED NEW FRAME SECTION IAW SRM 51-42-06 AND 51-42-21.SDR AALA20111018TUL01Frame · crackedCRACK IN AFT RADIUS OF FRAME AT STATION 1418, EVEN WITH LONGERON LONGERON 2. INSTALLED REPAIR DOUBLER TO AFT SIDE OF FRAME STATION 1418 LONGERON 2 PER SRM 53-03-00.SDR SWAA117207Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 967, LBL 2. REPAIRED FRAME IAW EA.SDR SWAA117202Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA117168Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, WL 202. REPAIRED FRAME IAW SRM.SDR NSVA2011257Frame · buckledCONTROL # 198-47: CARGO FRAME AT STA 702.0 BUCKLED. COMPLETED REPAIR IAW SAAB STATEMENT 340SDS-023358 AND TD 340-53-11-64. COMPLETED JC 51-00-00S.SDR SWIA201130833Frame · corrodedLOWER FRAME FORWARD OF MAIN AVIONICS BAY DOOR AT FS 333.00 HAS CORROSION ON AND AROUND GROUND TERMINAL. (C-CHECK) REPAIRED PER REO.SDR SWAA117240Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER EA.SDR ASOA201101987Frame · corrodedBS 310 FRAME CORRODED S26L TO 26R.SDR ASOA201101986Frame · corrodedFS 310 FRAME CORRODED, S26L TO 26R. REMOVED FRAME IAW SRM 51-42-06. DRILLED FRAME IAW SRM 51-40-11 & ALODINE IAW SRM 51-21-11. INSTALLED FRAME IAW SRM 51-42-06.SDR ASOA201101985Frame · corrodedFS 349 FRAME CORRODED, S25-26R. DRILLED NEW FRAME IAW SRM 51-40-11. INSTALLED NEW FRAME IAW SRM 51-42-06.SDR SWAA117186Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY LT FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR QXEA2011101701075Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X49.500 FLANGE HAS CORROSION BETWEEN STRINGERS 32S & 33S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .052". CONFIRMED CRACK FREE WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR SWAA117135Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME IAW EO AND EA.SDR SWAA117134Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM AND EA.SDR SWAA117127Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM AND MM.SDR SWAA117125Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME IAW SRM.SDR 7AHR201192030Frame · crackedAFT PIT CRACKED, FRAME LOWER CHORD AT BS 907 AND STRINGER 26R.SDR SWAA117107Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 908, STR 5L. REPAIRED FRAME IAW SRM.SDR SWAA117106Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 23L TO STR 24L. REPAIRED FRAME IAW ER AND EA.SDR SWAA117105Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 328, STR 20R. REPAIRED FRAME IAW ER AND EA.SDR SWAA117104Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 947, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW ER AND EA.SDR SWAA117100Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR USAA2011101700039Frame · crackedC4 CHECK - CRACK ON FRAME AT BS 500E, BETWEEN S20L TO S21L. REPAIRED FRAME AT BS 500E, BETWEEN S20L TO S21L IAW B737-400 SRM 53-00-07.SDR QXEA2011101801080Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X604.500 FLANGE HAS CORROSION BETWEEN STRINGERS 31P & 32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .034". CONFIRMED CRACK FREE, WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101701042Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X1.00 FLANGES HAVE CORROSION BETWEEN STRINGERS 29P AND 32P. BLENDED CORROSION IAW RD 8/4-53-2344. MATERIAL REMAINING .049". CONFIRMED CRACK FREE. ALODINED, PRIMED AND PAINTED.SDR FOTR2011101406609Frame · corrodedTOP OF FRAME BS 727E, S25L CORRODED. REPAIRED ON FASI WO 21142, NR 06609.SDR QXEA2011101801060Frame · corrodedLT STUB FRAME FLANGE BELOW THE FORWARD PASSENGER DOOR THRESHOLD AT STATION X6.0 BETWEEN STRINGERS 24P AND 25P HAS CORROSION. OUTSIDE OF LIMITS. FABRICATED AND INSTALLED NEW FLANGE IAW 51-42-05-02-01.SDR QXEA2011101801061Frame · corrodedLEFT STUB FRAME FLANGE BELOW THE PASSENGER DOOR THRESHOLD AT STA 28.0 BETWEEN STRINGERS 24P AND 25P HAS CORROSION. OUTSIDE OF LIMITS. FABRICATED NEW FLANGE AND INSTALLED IAW SRM 51-42-05-02-01.SDR USAA2011101700038Frame · crackedC4 CHECK - CRACK ON FRAME AT BS 500B, BETWEEN S20L TO S21L. REPAIRED FRAME AT BS 500B, BETWEEN S20L TO S21L IAW EA 103427.SDR USAA2011101700037Frame · crackedC4 CHECK - CRACK ON FRAME AT BS 500B, BETWEEN S20R TO S21R. REPAIRED FRAME AT BS 500B, BETWEEN S20R TO S21R IAW EA 103430.SDR QXEA2011101801059Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X71.200 FLANGES HAVE CORROSION BETWEEN STRINGERS 31S & 33. BLENDED CORROSION IAW Q400 RD 8/4-53-2344. REMAINING THICKNESS .038". CONFIRMED CRACK FREE. WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101801058Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X71.200 FLANGES HAVE CORROSION BETWEEN STRINGERS 30P & 32P. BLENDED CORROSION IAW Q400 RD 8/4-53-2344. REMAINING THICKNESS .044". CONFIRMED CRACK FREE. WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101801057Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X49.500 FLANGES HAVE CORROSION BETWEEN STRINGERS 30S & 32S. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .052". CONFIRMED CRACK FREE. WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101801056Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X49.500 FLANGE HAS CORROSION BETWEEN STRINGERS 31P & 32P. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .054". CONFIRMED CRACK FREE. WITHIN LIMITS. ALODINED, PRIMED AND PAINTED AREA.SDR QXEA2011101801051Frame · corrodedINTERIOR FUSELAGE BELLY FRAME X19.400 FLANGES HAVE CORROSION BETWEEN STRINGERS 30S AND 33. BLENDED CORROSION IAW RD 8/4-53-2344. REMAINING THICKNESS .039". CONFIRMED CRACK FREE. ALODINED PRIMED AND PAINTED.SDR FDEA201110144496Frame · gougedBS 660, FRAME SPLICE- BETWEEN S25 & 26L GOUGED & DENTED DOT NR100- 060. BLENDED AREA IAW SRM 51-70-01 AND 51-10-00. DAMAGED AREA MEASURE IS L=1 X W=1 X D=.055. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, REMOVED DAMAGED PART, INSTALLED NEW PART IAW SRMSDR JR2R2011101400464Frame · corrodedFRAME 301 HAS CORROSION BETWEEN STGR 26R AND 25R IN FWD E&E BAY. REPAIRED FRAME 310 26R TO 25R IAW CRJ 900 RO# CRJ9-53-0810.SDR FDEA201110134462Frame · corrodedAFT LWR CARGO FRAME UPPER SURFACE HAS CORROSION BS 1340 BETWEEN S26-27R. CORROSION REMOVED AS PER EA F-5310-153433. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201110134461Frame · dentedAFT LWR CARGO COMP FRAME UPPER SURFACE HAS DENT AT BS 1440, BETWEEN S25-26L. REPAIRED AS PER EA F-5310-153431 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201110134460Frame · dentedAFT LWR CARGO COMP FRAME HAS DENT ON UPPER SURFACE AT BS 1420 BETWEEN STRINGERS S-23L- S-24L. REPAIR CARRIED OUT AS PER EA F-5310-153430 PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201110134467Frame · dentedMAIN DECK - LT STA 1681, LONGERON 12, FRAME FOUND DENTED. FRAME TRIMMED OUT AS PER SRM 53-00-07 FIG.201 REV 47. REPAIR ANGLE FABRICATED AND INSTALLED AS PER SRM 53-00-07 FIG.201 REV 47. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 113.SDR AALA20111013TUL06Frame · gougedFUSELAGE FRAME STATION 148 GOUGED. ACCOMPLISHED REPAIR PER SRM 51-70-5.SDR USAA2011101800052Frame · crackedDROP IN - CRACK ON FUSELAGE FRAME 500D, BETWEEN STR 20L AND 21L. REPAIRED FRAME 500D, BETWEEN STR 20L AND 21L IAW 737-400 SRM 53-00-07 REPAIR 13.SDR ASAA11410541Frame · crackedTHE 907 FRAME IS CRACKED BELOW STR 8R. REPAIRED IAW EA AD20062609 400 53 124 REV A.SDR ASAA11410540Frame · crackedTHE 907 FRAME IS CRACKED BELOW STR 8C. REPAIRED IAW EA AD20062609 400 53 124 REV A.
Back to JASC 5311