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 DU4R2006528Frame · corrodedCORROSION LEFT LOWER WING TO BODY FAIRING STRUCTURE BS 1037 BL 7 TO BL 30L. REMOVED CORRODED SECTION BL 7L TO BL 29L BS 1037. FABRICATED AND INSTALLED REPAIR PLATES 11-5/8" X 1-1/8" FROM 7075-T6 .063, 11-5/8" X 1-1/8" FROM 7075-T6 .050 AND EXTRUSION 21-3/4" SDR HALA0700044Frame · crackedOVERWING STUB FRAME CRACKED RT SIDE LWR END I/B RADIUS STATION 860. REMOVED DAMAGED STUB FRAME CHORD P/N 145T1001-12. REPLACED WITH NEW FABRICATED FRAME CHORD P/N 145T1001-12 IAW SRM 51-40-02.SDR HALA0700045Frame · crackedOVERWING STUB FRAME CRACKED RT SIDE LWR END I/B RADIUS STA 903. REMOVED DAMAGED STUB FRAME P/N 145T1001-8 AND REPLACED WITH NEW FABRICATED STUB FRAME, P/N 145T1001-8 IAW SRM 51-40-02.SDR MWEA060104Support · corrodedCORROSION ON R1 DOOR THRESHOLD SUPPORT LONGERON 54 AT STATION 168.750 TO 200. FABRICATED AND INSTALLED THRESHOLD SUPPORT.SDR SWAA062207Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CORRODED AT RT BS 992, WL 209. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR USAA060867Frame · crackedSTA 380L AT STR 20L TO 21L CRACKED. MAJOR REPAIR, INSTALLED DOUBLER IAW SRM 51-70-11 EA 97835, DEFECT SIZE: 3 INCHES.SDR QXEA200601880Frame · crackedSUSPECTED CRACK AT RADIUS ON FRAME NR 4 JUST AFT OF RT STRINGER NR 3. REPAIRED IAW RD 8/4-53-274 AND EA 6-55-153A.SDR UPS06547263Frame · dentedFOUND DENT ON AFT CARGO FUSELAGE FRAME. REPAIRED FRAME PER FINAL EA NR 757-5362-27A1477 AND UPS EO NR B757-5310- 24600-A.SDR SWAA062197Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062196Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062195Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062194Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062193Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062192Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062191Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062190Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA062189Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062188Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062187Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062186Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR EIA2006124Frame · crackedFOUND CRACK BS 2598 RT LWR AFT FRAME. AFT INNER FRAME REPAIRED AT RBL 37 AND WL 267, IAW B 747 SRM 53-10-04 FIG 74 REPAIR ANGLE USED 7075-T6 0.100".SDR CALA0600218Beltframe · corrodedINSPECTION FOUND FORWARD BAGGAGE BIN BELT FRAME CORRODED AT STA 500D, S27L, LBL11-13. A DOUBLER WAS INSTALLED IAW SRM 53-00-07 FIGURE 201 REPAIR 7.SDR IXXA06SMN180SFitting · crackedDURING ROUTINE C CHECK INSPECTION, FRAME FITTING CRACKED 1" APPROX , STA 960.000 L-24R.SDR CALA0600217Beltframe · corrodedINSPECTION FOUND FORWARD BAGGAGE BIN BELT FRAME CORRODED AT STA 480, S27L, LBL 13-17. REPAIRED IAW SRM 53-00-07.SDR 2006FA0000617Frame · crackedCRACK IN RT FWD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR 2006FA0000616Frame · crackedCRACK IN RT FWD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR 2006FA0000615Frame · crackedCRACK IN RT FWD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR 2006FA0000614Frame · crackedCRACK IN RT FWD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR 2006FA0000613Frame · crackedCRACK IN RT FWD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR 2006FA0000612Frame · crackedCRACK IN RT FORWARD WING BOLT ATTACH FRAME, P/N: 105-420011-6.SDR UPS06547359Frame · dentedINSPECTION TYPE:C, DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1240, S26R. FRAME REPAIR AT STA 1240, S26R HAS BEEN ACCOMPLISHED PER EA B757- 5362-27-A1484 AND UPS EO B757-5310-24700-A.SDR UPS06547357Frame · dentedINSPECTION TYPE: C, DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1280, BETWEEN S25R TO S26R. COMPLIED WITH EA 757-5362-27-A1486 AND UPS EO B757-5310-24713-A.SDR UPS06547341Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1340, BETWEEN S25R TO S26R. FRAME REPAIR AT STA 1340, S25R TO S26R WAS ACCOMPLISHED PER FINAL EA 757-5362-27-A1485 AND UPS EO B757-5310-24679-A.SDR MWEA060084Frame · misrepairedIMPROPER REPAIR ON FRAME IN THE NOSE WHEEL WELL, LEFT SIDE, FORWARD OF AFT BULKHEAD AND AFT OF LANDING GEAR STRUT, LEFT TRUNNION. FABRICATED AND INSTALLED SHIM AND ANGLE.SDR TRAX200600403Frame · crackedRANRC 299 FS 574 FRAME LOWER U CHANNEL IS CRACKED AT LBL42. MARKEDSDR C2XA06SH066Frame · corrodedSHV - DURING C-CHECKS FRAME 22 HAS AREA OF CORROSION SURROUNDING NUT PLATE. MAINTENANCE REMOVED CORROSION AND REPAIRED FRAME 22 IAW EC5310-03187. THE AIRCRAFT WAS APPROVED TO RETURN FOR SERVICE.SDR SWIA200616865Frame · crackedFRAME 10 CRACKED BELOW LEFT DV WINDOW, DISCOVERED DURING C-CHECK INSPECTION. REPAIRED LEFT FRAME 10 AT UPPER SECTION BELOW DV WINDOW IAW SRM 53-00-04, RII 53-800-1000.SDR LR7A06076Frame · damagedDURING SCHEDULED C7 CHECK FOUND FRAME FASTENER HOLES OVERSIZED AT FS 245 LT, WL 223. REPAIRED FRAME IAW LAC MEA 382-53-06-051.SDR LR7A06074Frame · crackedDURING SCHEDULED C7 CHECK PER JOB CARD HC5313 FOUND LT SIDE RING SEGMENT SPLICE CRACKED AT FS 477, WL 282, LBL 20. FABRICATED AND INSTALLED SPLICE IAW SMP583 51-60 & 51-70.SDR LR7A06064Frame · crackedDURING SCHEDULED C7 CHECK PER JOB CARD HSP53306 FOUND RING SEGMENT CRACKED AT FS 817E, WL 152, RBL 65. REPAIRED RING SEGMENT IAW SMP583 51-140-12.SDR F3LA200600059Support · corrodedDURING C-4 CHECK, INSPECTION REPORTED SURFACE CORROSION ON FRAME SUPPORT AFT OF L2 DOOR CUTOUT BETWEEN FR69 AND FR70 (BOTTOM SIDE). REPLACED FRAME SUPPORT PER SRM 51-42-11 AND 51-44-11.SDR 2006UALA01189Frame · crackedCABIN FRAME CRACKED OUT OF STRINGER PASS THROUGH CUTOUT BS 663, STR 2R.SDR DL76S060500Frame · crackedA CRACK WAS FOUND IN THE BS 903.5 FRAMES ON THE LT AND RT SIDES. REPAIR ANGLES WERE INSTALLED.SDR KCSA061176Frame · crackedFUSELAGE FRAME AND SHEAR TIES ARE CRACKED AT STA 820, BETWEEN STR 10R & 11R.SDR DU4R2006499Strap · chafedCABIN FRAME STA 1640 S-10R CHORD/STRAP CHAFED. FABRICATED AND INSTALLED REPAIR STRAP FROM 7075-T6 IAW BOEING DWG 146N8738 REV V DATED 2-12-02 IAW B757 SRM 51-40-2.SDR 2006UALA01181Frame · crackedLT FUSELAGE STA 380 AND 907 BETWEEN STRINGER 8L AND 9L AT STOW BIN RAIL SUPPORT, FASTENER HOLE HAS A CRACK ON THE FRAME.SDR 06FDEA2290Frame · puncturedAFT CARGO COMPARTMENT, FRAME STA 1841 WEB PUNCTURED AT LONGERON 42L. AFT CARGO COMPARTMENT, FRAME STA 1841 WEB AT LONGERON 42L CARRIED OUT REPAIR AS PER FEDEX EA NR 1-5350-99693, TITLE: FUSELAGE, AFT CARGO DOOR JAMB LOWER BEAM CRACK REPAIR. REPAIR IS CLASSIFSDR 06FDEA2288Frame · damagedFOUND EXISTING FRAME REPAIR (35"X 5") AT STA 449 FROM X=-22. REPLACED 4EA SPLICES WITH NEWS P/N F177133-3-5-7-9 PER SRM 53-00-01 VOL 1 FIG 8. REPLACED CLIP P/N ABA7366-21 IAW SRM 51-35-01 VOL 2 PG 1/13. FABRICATED PARTS IAW DETAIL PARTS TRAVELER N01133 AND SDR SWAA062066Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 28L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062065Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, RBL 25. REMOVED AND REPLACED FRAME SECTION PER SRM.
Back to JASC 5311