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 KNNA200700033Frame · crackedPASSENGER CABIN/CRACK ON FRAME BS-663 AND STRINGER-2L, ACO NR 075365 PROVIDES INSTRUCTION ON REPAIR OF CRACKED FRAME AT BS-663, STRINGER 2L SRM 53-10-4.SDR SWAA072234Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0700227Frame · corrodedINSPECTION FOUND FORWARD CARGO COMPARTMENT FRAME CORRODED AT STA 500 BETWEEN STRINGER 26L AND 27L. A SHEAR TIE AND FILLER WERE INSTALLED IAW SRM 53-00-07.SDR 07FDEA01686Frame · chafedFOUND LEFT MAIN FRAME STA 535 AT 9G NET SUPPORT YOKE AREA FOUND CHAFFED AT LONGERON 23L. [SUP 05-10-07] REPAIR CARRIED OUT AS PER FEDEX AIRCRAFT ENGINEERING STANDARD REWORK DRAWING NR: SRZ 53-503. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR VNAA0705012Frame · corrodedFS 280 FRAME, AT WL 73 IS CORRODED FROM LBL 45 TO RBL 9. MAINTENANCE REMOVED AND REPLACED FRAME AT WL 73 FS 280 AS REQUIRED IN ACCORDANCE WITH THE AIRCRAFT STRUCTURE REPAIR MANUAL 51-42-06-001-001-A01.SDR UPS07849789Frame · gougedINSPECTION TYPE:C3 A-PIT, BELT FRAME GOUGED AT STA 240 L31R. TRIMMED OUT DAMAGED AREA AT STA 240 L31R IAW E0 DC8-5310-11728-B, FABRICATED AND INSTALLED REPAIR DOUBLER IAW EO DC8-5310-11728-B.SDR QXEA200700771Frame · gougedC4 PDX - FUSELAGE FRAMES IS GOUGED AT STATION X722.102, LEFT HAND SIDE CABIN, INBOARD FLANGE TOP SURFACE AT CABIN FLOOR LEVEL. REPAIRED IAW SRM 53-40-15 AND RD8/4-53-1904.SDR TSAA0753019Frame · crackedDURING INSPECTION OF THE BS 178 WEB, CRACKS WERE DISCOVERED ON THE BS 188 FRAME AT WL 207 ON BOTH LEFT AND RIGHT SIDES. LEFT SIDE CRACK IS APPROX 1.75 INCHES LONG. RIGHT SIDE CRACK IS APPROX. 2 INCHES LONG. [SUP 05-10-07] INTERIM REPAIR PERFORMED PER ECO 3SDR SWAA072174Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072177Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 13L. REPAIRED FRAME PER SWA EA.SDR SWAA072173Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072176Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072200Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072201Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072199Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072202Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072198Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072175Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072197Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072196Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072195Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072210Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072209Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0700224Frame · crackedINSPECTION FOUND A 1/4" CRACK IN THE FORWARD BAGGAGE BIN FORWARD FRAME AT THE FOURTH STOP PAD FROM TOP, STA 440, S13R TO S28R. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR SIMA200714015Frame · damagedFRAME 668.0 FOUND DENTED. REMOVED AND RELACED FRAME IAW SAAB SRM 51-40-21, 51-40-40 AN D51-20-50. AIRCRAFT RETURNED TO SERVICE.SDR SIMA200714014Frame · damagedFOUND FRAME AT FUSELAGE FRAME 677.0 DENTED. REMOVED AND REPLACED FRAME IAW SAAB SRM 51-40-21, 51-40-40 AND 51-20-50. AIRCRAFT RETURNED TO SERVICE.SDR SWAA072132Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072155Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 320, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA072157Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072131Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072150Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B. STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072133Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072134Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA070343Frame · crackedSTUB FRAME ATTACH POINT BS 616 & LBL 64 CRACKED. INSTALLED REPAIR ANGLE PER TYP REP 53-62-05, DEFECT SIZE: .250 INCH.SDR USAA070341Frame · crackedSTA 500C BETWEEN STR 8 & 9, RT AT ATTACH BRACKET AT INBD RIVET HOLE. INSTALLED REPAIR ANGLES PER TR 53-10-20E. DEFECT SIZE: 1/4"SDR USAA070340Frame · crackedSTA 480 BETWEEN STR 8 & 9 RT AT ATTACH BRACKET ON FRAME, INBD RIVET. INSTALLED REPAIR ANGLES PER TR 53-10-20E. DEFECT SIZE: 1/4"SDR CALA0700249Frame · corrodedINSPECTION FOUND AFT FRAME CHORD AT R-2 DOOR LOWER SILL, STA 992, S17R, LBL 0 TO RBL 64 CORRODED. THE FRAME WAS REPAIRED IAW ECRA 5311-01315.SDR SWAA072121Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 14L. REPAIRED FRAME PER SRM.SDR DHL2007782510Frame · corrodedLARGE AREA OF CORROSION AT BS 320 APPROX, ON FRAME AND LOWER CHORD ANGLE, IN E-BAY FWD CRAWLWAY, RT SIDE BILGE AREA. LOWER NOSE CHORD CORRODED BEYOND LIMITS: REMOVED AND REPLACED LOWER RT NOSE CHORD ASSY PER B727 SRM 51-30-5, 51-30-2, AND 53-10-2 FIG 1. CUTSDR DHL2007782509Frame · corrodedFUSELAGE LOWER LOBE, BS 360 FRAME, BETWEEN STR 26R AND 27R, HAS EXFOLIATION CORROSION ON FWD SIDE. CUT OUT DAMAGED AREA 5" BY 1.5", FABRICATED 2 FILLERS FROM 7075-T6, .071" BY 5" BY 1.5", PO NR 9004150; DOUBLER FROM 7075-T6, .071" BY 7" BY 4.5", PO NR 9004150SDR SWIA200718372Frame · crackedFS 280 LBL9 AND RBL9 LOWER FRAMES ARE CRACKED, DISCOVERED AT C-CHECK. REPLACED FS 280 LBL9 INBOARD AND OUTBOARD CLIPS, FS 280 RBL9 INBOARD AND OUTBOARD CLIPS, AND REPAIR PARTS PER CRJ200 REO 601R 53-11-1177 REV 'A'.SDR QXEA200700766Frame · corrodedC4 PDX - STRUCTURE FRAME CASTELLATION IS CORRODED AT STATION X7.0, Y4.0L, Z94.0, BELOW MAIN CABIN DOOR LAY SHAFT. REPAIRED IAW SRM 51-21-00, 51-21-10, 51-25-05.SDR QXEA200700745Frame · crackedC4 PDX - CRACKED RIVET HOLE ON FRAME AT X69.4 ABOVE STRINGER 19P. REPAIRED IAW RD8/4-53-017 AND SRM 51-25-05.SDR SWAA072094Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SRM.SDR 2007UALA01345Frame · dentedFWD PIT, LEFT SIDE, STA 580 BETWEEN STR 24L AND 25L, MAIN FRAME IS DENTED 3 PLACES, WITH ONE INTO FRAME UPPER RADIUS BEND. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE. COLD WORK HOLES & INSTALLED DOUBLER REPAIR.SDR 2007UALA01344Frame · dentedFWD PIT, LEFT SIDE STA 660 BETWEEN STR 25 AND 26L, MAIN FRAME HAS DENT INTO RADIUS UPPER BEND. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE. COLD WORKED HOLES & INSTALLED J-ANGLE REPAIR.SDR SWAA072105Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR UPS07549866Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1320 BETWEEN S25L AND S26L (2EA). ACCOMPLISHED BOTH UPPER AND LOWER DENT REPAIRS IAW EA 757-5362-27- A1666 AND UPS EO B757-5310-26894-A WITH NO DEVIATIONS.SDR UPS07549865Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1320, BETWEEN S25L AND S26L (2EA). ACCOMPLISHED BOTH UPPER AND LOWER DENT REPAIRS IAW EA757-5362-27- A1666 AND UPS EO B757-5310-26894-A WITH NO DEVIATIONS.SDR UPS07549841Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO FUSELAGE FRAME STA 1280 BETWEEN S25L AND S26L (2EA). UPPER DENT REPAIR AT STA 1280, WAS ACCOMPLISHED PER FINAL EA 757-5362-27-A1665 AND UPS EO B757-5310-26833-A WITH NO DEVIATIONS. THE LOWER DENT AT STA 1280, WAS REPAIRED
Back to JASC 5311