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 DALA13016060946Frame · corrodedCORROSION ON FRAME 1380 STA X=13 AND X=-13. REF. (T0 276519). FRAME TEE WAS REPLACE IAW DWG 9912246, REV DE (FRAME TEE WAS REMOVED AND NEW FRAME TEE WAS INSTALLED ) IAW SRM 51-30-2 , 51-30-5. CORROSION LEVEL 2.SDR DALA1308561609Frame · crackedMAIN DECK STA 903 WL200 RT FRAME INNER CHORD TRANSITION RADIUS CRACKED AT RADIUS APPROX .2500"LONG. REPAIRED IAW ERA 511795-14AD REV O.SDR SIMA20130409001Frame · crackedDURING MAINTENANCE INSPECTION FOUND FRAME 23 CRACKED AT RIGHT FLOOR SILL. THE AIRCRAFT WAS REMOVED FROM SERVICE. PERFORMED REPAIR IAW AEA EO-EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA2013051716177Frame · crackedFRAME WEB CRACKED AT BS 420, BETWEEN STR 11L TO STR 13L. REPAIRED WEB IAW SRM.SDR GLBA2013040800227Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK ON THE FRAME FLANGE AT FS 177.35 AND STRINGER 13L, 1.5" IN LENGTH. REPAIRED IAW EO 13-1900-53-031. MAJOR REPAIR.SDR GLBA2013040800225Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE COCKPIT RT SIDE WALL FRAME AT FS 107 AT THE UPPER 2 FASTENER HOLES, RADIATES FROM EACH HOLE UPWARD, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-030. MAJOR REPAIR.SDR SWAA2013050715739Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013050215459Frame · crackedFRAME CRACKED AT BS 196.5, STR 17L. REMOVED AND REPLACED FRAME IAW SRM AND DRAWING.SDR SWAA2013051516078Frame · crackedSTUB FRAME CRACKED AT BS 296.4, STR 7R. REPAIRED STUB FRAME IAW EA.SDR ASOA2013051403541Frame · corrodedMINOR CORROSION ON TOP OF FS 533, FRAME AND STR 24L. LOCATED AND DRILLED THE REPLACEMENT STRAP IAW SRM 51-40-11-001-001-A01. INSTALLED THE REPLACEMENT STRAP IAW SRM 51-44-16-001-001-A01 AND DWG SH670-33793. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW ASSDR DALA1312536708Frame · damagedAFT CARGO BS 1520 S23-26R FOUND MULTIPLE TOOLING MARKS IN THE FRAME AND SPLICE. REPAIRED IAW ERA 513688-14, REV ORIG.SDR SWAA2013050215484Frame · corrodedFRAME CORRODED AT BS 908, LONGERON 28LTO LONGERON 29R. REPAIRED FRAME IAW SRM.SDR SWAA2013050115431Frame · crackedFRAME CRACKED AT BS 986.5, STR 20R. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013042615241Former · crackedAFT FUSELAGE FORMER CRACKED AT FWD SIDE OF FS 1022 BULKHEAD, BETWEEN L-15L AND L-14L. REMOVED AND REPLACED FORMERS IAW SRM.SDR SWAA2013041814990Frame · corrodedFRAME CORRODED BETWEEN BS 927 TO BS 954, LONGERON 29L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR WX0A071550Frame · corrodedAFT CARGO PIT FRAME STATION 1309 CORRODED BETWEEN LONGERON 29L AND 29R. REMOVED DAMAGED AREA. FABRICATED REPAIR PARTS. LOCATED DRILLED AND INSTALLED.SDR DALA13015390945Frame · crackedAFT ACCESSORY COMPT FRAME BS 1485 RT AFT UPPER CORNER PREVIOUS REPAIR CRACK AND WEB CRACK. REMOVED PREVIOUS REPAIR. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 51-30-2, 53-01 FIG 2 51-10-3 & 51-30-1.SDR DALA13015330907Frame · corrodedCORROSION AFT CARGO BAY BS 1309 BETWEEN LONGERON 28L TO 28R (53-139-05-1). NO ALLOWABLE LIMITS OF CORROSION -9 REPAIR ANGLE AT FS 1309 FRAME BETWEEN LONGERON 28L-28R. REPLACED PART-9 ANGLE IAW SRM 53-03, FIG 2A. FP 578644U 06APR13, ATS LEAD 33 06APR13.SDR CALA2013040800204Frame · crackedLT FUSELAGE FRAME BS 867 SHOWS FRAME CRACKED INBD FASTENER HFEC CRACK RAN INTO RADIUS. FRAME REPAIRED IAW EA5310-04716, REV D, OP 1.SDR DALA1313180681Frame · corrodedCORROSION ON MAIN CABIN FRAME INBD FLANGE AT STA 729 LT 2 INCHES ABOVE FLOOR LEVEL. ACCOMPLISHED ERA 513915-14, REV ORIG.SDR DALA1313170681Frame · gougedMAIN CABIN FUSELAGE FRAME GOUGED BS 1640 BETWEEN STR 5 - 6L. ACCOMPLISHED REPAIR IAW ERA 513907-14, REV ORIG.SDR DALA1313150681Frame · gougedMAIN CABIN FUSELAGE FRAME GOUGED AT BS 1640 S5 - 6R ACCOMPLISHED ERA 513908-14, REV ORIG.SDR ASOA2013051403535Frame · corrodedFRAME BS 333 CORRODED BETWEEN S26 - 27L. REPAIRED FRAME IAW REO 670-53-21-799.SDR ASOA2013051403533Frame · corrodedFRAME BS 310, CORRODED BETWEEN 26LT - 26RT. REPAIRED IAW REO 670-53-21-799.SDR SWAA2013050715798Frame · corrodedFRAME CORRODED AT BS 947.5, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA2013050715715Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L AND STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013050715712Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013050615593Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013050615592Frame · corrodedFRAME CORRODED AT BS 500A, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013050215479Frame · corrodedFRAME CORRODED AT BS 908, LONGERON 28LTO LONGERON 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013043015345Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME IAW SRM.SDR CHQA20130405121Frame · crackedDURING INSPECTION, A CRACK WAS FOUND ON FRAME 72 BETWEEN STRINGERS 11R AND 12R. THE FRAME WAS REPAIRED IN ACCORDANCE WITH SRM 51-40-02.SDR CALA2013040500203Frame · crackedFUSELAGE FRAME BS 747 CRACKED INBD FASTENER. REPAIRED IAW EA 5310-04716 REV D, OP 1.SDR HNAA2013040500211Frame · corrodedFRAME CORRODED IN FORWARD CABIN UNDERFLOOR RT SIDE AT BS 201, S31S. CUT FRAME AT STR 33 AND REMOVED FRAME SPLICE AT STR 28. FABRICATED NEW SPLICE IAW EA12-2013-122. INSTALLED FRAME IAW EO8-53-13-0138.SDR SWAA2013050215457Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED FRAME IAW SRM AND DRAWING.SDR DALA1309993748Frame · damagedSTUB FRAME AT BS 947.5 BELOW S17R HAS DAMAGE ON THE WEB. COMPLIED WITH ERA 511677-14 REV ORIG 1791792.SDR SWAA2013041114741Frame · crackedFRAME WEB CRACKED AT BS 500C, STR 8L. REPAIRED FRAME WEB IAW EA.SDR SWAA2013041114740Frame · crackedFRAME WEB CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR CALA2013040500198Frame · crackedLEFT FUSELAGE FRAME BS 727D CRACKED AT INBD FASTENER IAW HFEC. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR DALA13015410944Frame · corrodedCORROSION ON FRAME ANGLE BS 1136 BETWEEN LONGERONS 27-28RT AT AFT CARGO COMPARTMENT. THE FRAME CLIP WAS REMOVED, NEW FRAME ANGLE FABRICATED, AND INSTALLED IAW SRM 51-30-5.SDR QXEA2013040400752Frame · corrodedFRAME BS 547, FLANGE DOUBLER IS CORRODED STR 24P. REMOVED FLANGE DOUBLER IAW SRM 51-42-05-02-01, REV 12. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15-00-01, REV 12. INSTALLED NEW CLEAT AND REINFORCING ANGLE IAW SRM 51-42-05-02-01 REV 12.SDR QXEA2013040400751Frame · corrodedFRAME BS 547, FLANGE DOUBLER IS CORRODED STR 25S. FOUND TO BE CORRODED OUT OF LIMITS IAW SRM 53-30-15-00-01, REV 12. REMOVED DOUBLER OUT FR547 STR25S IAW SRM 51-40-07-02-01 REV12. MATCH DRILLED NEW DOUBLER IAW SRM 51-40-07-02-01, REV 12. INSTALLED DOUBLSDR QXEA2013040400732Frame · corrodedFRAME 529.5 FLANGE DOUBLER IS CORRODED, STR 24S. REMOVED FRAME FLANGE DOUBLER AT STA 529.5, STR 24S IAW SRM 51-42-05-02-01, REV 12. PRIOR TO REMOVAL FRAME FLANGE DOUBLER WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15-00-01, REV 12. MATCH DRILLED NEW DOUBLERSDR CALA2013040500200Frame · crackedFRAME BS 787 CRACKED. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2013040500199Frame · crackedFRAME BS 867 CRACKED. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR DALA13014860944Frame · corrodedCORROSION ON FRAME STA Y=1322 BETWEEN LONG 28 LT TO 28 RT AT AFT CARGO COMPARTMENT. FRAME WAS REPAIRED IAW SRM 53-03D, FIG 2A.SDR DALA1313120681Frame · corrodedAFT CARGO FRAME BS 1400 S28L-28R HAS CORROSION FWD AND AFT SIDE. REPLACED FRAME IAW SRM 51-40-02, PG 6 AND 7.SDR DALA1313110681Frame · corrodedAFT CARGO FRAME STA 1460, S27L-27R HAS CORROSION FWD, TOP AND AFT SIDE. REPLACED FRAME IAW SRM 51-40-02, PARA 4, PG 2-3 AT SAA ON NR CARD 100-258.SDR SWAA2013050715757Frame · crackedFRAME CRACKED AT BS 616, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME IAW EA.SDR SWAA2013050115427Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.
Back to JASC 5311