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 SWAA061000Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 207. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA060999Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14L. REPAIRED FRAME PER BFG ER.SDR SWAA060997Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 296, STR 16R. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA060996Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060995Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060994Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060993Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR CALA0600094Frame · corrodedINSPECTION FOUND FRAME CORRODED IN AFT BAGGAGE BIN AT FLOOR SUPPORT WEB FUSELAGE ATTACH AREA, STA 927 BETWEEN S26L AND S26R. A SHEAR TIE WAS INSTALLED IAW SRM 53-00-07.SDR USAA060484Frame · crackedSTA 294, S10R CRACKED. REMOVE AND REPLACE CHORD IAW SRM 51-10-02, DEFECT SIZE: .750 INCH.SDR USAA060483Frame · crackedSTA 294 S11R CRACKED. REMOVED DAMAGED PART, INSTALLED REPAIR PART IAW SRM 51-10-02, DEFECT SIZE: .500.SDR UPS06547113Frame · dentedFOUND DENT IN AFT CARGO COMPARTMENT FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1395 AND UPS EO NR B757-5310 -24161-A, FUSELAGE FRAME REPAIR AT BS 1320, STR 23L-24L.SDR UPS06547112Frame · dentedFOUND DENT IN AFT CARGO COMPARTMENT FUSELAGE. COMPLIED WITH EA NR 757-5362-27-A1400 AND UPS EO NR B757-5310-24185-A.SDR UPS06547110Frame · dentedFOUND DENT IN AFT CARGO FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1393 AND OPS EO NR B757-5310-241 63-A.SDR UPS06547109Frame · dentedFOUND DENT IN AFT CARGO COMPARTMENT FUSELAGE. COMPLIED WITH FINAL EA NR 757-5362-27-A1397 AND UPS EO NR B757-5310-2 4178-ASDR UPS06547077Frame · dentedINSPECTION TYPE:N/A DENT IN AFT CARGO FUSELAGE FRAME. COMPLIED WITH FINAL EA 757-5362-27-A1393& OPS EO NR B757-5310-2416 3A.SDR UPS06547072Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1480, S26L. COMPLIED WITH FINAL EA757-5562-27-A1400 & UPS EO NR B757-5310-241 85-ASDR UPS06547071Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1520, S25L. COMPLIED WITH FINAL EA757-5362-27-A13949 UPS EO NR B757-5310-2417 9-ASDR UPS06547070Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1320 S23L. COMPLIED WITH FINAL EA757-5362-27-A1395 AND UPS EO NO B757-5310- 24161-A (FUSELAGE FRAME REPAIR AT BS 1320, STR 23L-24L)SDR UPS06547069Frame · dentedINSPECTION TYPE:C DENTS IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1460, S25R TO S26R (2 EA). COMPLIED WITH FINAL EA757-6362-27-A1398 & UPS EO NO, B757-5310-24 14ASDR QXEA200600899Frame · puncturedPDX: AFT SERVICE DOOR AFT LIFT LATCH SPRING HAS PUNCTURED THE FRAME BELOW IT. MAINTENANCE REPAIRED IAW RD 8/4-52-247, NDTM PART 6, 51-00-01, AND HORIZON EA 6-52-430.SDR 2006UALA00552Frame · crackedCABIN FRAME INBOARD CHORD CRACKED BS 616 RBL 64", WL 201. INSTALLED REPAIR ANGLE DOUBLER PER MM 53-11-89.SDR 2006UALA00551Frame · crackedCABIN FRAME BS 616 INBOARD CHORD IS CRACKED LBL 64", WL 201. INSTALLED REPAIR ANGLE DOUBLER PER MM 53-11-89.SDR 061019Frame · crackedFUSELAGE FRAME AT BS 2040 CRACKED BETWEEN STRINGER S-32L AND S-33L.SDR SWAA060984Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060983Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060982Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060981Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060980Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060979Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060978Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060977Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060976Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060975Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060974Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA060973Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060972Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR SWAA060971Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR ASAA0640277Frame · corrodedFRAME CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM.SDR SWAA060939Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 21R. REPAIRED FRAME PER SWA EA.SDR SWAA060938Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA060936Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA060918Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SIMA200609402Frame · dentedDENT ON CARGO WALL FRAME AT STA 658.5. RECONTOURED THE DENT AND PERFORMED NDT INSPECTION. FABRICATED A REINFORCEMENT DOUBLER. REPAIR DONE IAW SRM. (K)SDR SIMA200609401Frame · dentedDENT ON CARGO WALL FRAME AT STATION 677.0. CONTOURED THE DENT AND PERFORMED NDT INSPECTION. FABRICATED A REINFORCEMENT DOUBLER. REPAIR DONE SRM. (K)SDR 0600746304Frame · crackedDURING M-CHECK FOUND CRACK IN FUSELAGE FRAME WEB AT BS 320 LBL 15. REPAIRED PER EA 63-206470.SDR DHL2006750518Frame · dentedFOUND FRAME DENTED AT BS 700 STR 24 R. CUT OUT DAMAGED AREA SIZE 1 BY 3/4 ON FRAME STA 700 AT STR 24R IAW B727 SRM 51-10-1. FABBED REPAIR ANGLE FROM 7075-0 .063 SIZE 8 3/4 BY 3 1/2 PO 9002827 IAW B727 SRM 51-40-3 FIG 1 AND SRM 53-10-2 FIG 3. HEAT TREATED TSDR DHL2006750517Frame · dentedFRAME DENTED AT BS 680 AT STR 24R. CUT OUT DAMAGED AREA SIZE 1 X 3/4 ON FRAME STA 680 AT STR 24R IAW B727 SRM 51-10-1. FABBED REPAIR ANGLE FROM 7075 .063 SIZE 8 3/4 X 3 1/2 PO 9002827 IAW B727 SRM 51-40-3 FIG 1 AND SRM 53-10-2 FIG 3. HEATED TO 7075 T6 .063 SDR DHL2006570519Frame · dentedFOUND FRAME DENTED AT BS 720A STR 25R. CUT OUT DAMAGED AREA SIZE 1 BY 1 ON FRAME STA 720A AT STR 25R IAW B727 SRM 51-10-1. FABBED REPAIR ANGLE FROM 7075-0 .063 SIZE 8 3/4 BY 3 1/2 PO 9002827 IAW B727 SRM 51-40-3 FIG 1 AND SRM 53-10-2 FIG 3. HEAT TREATED TO SDR C2XA06TY015Frame · crackedPAX DOOR FRAME CUTOUT AFT LOWER STOP STRUCTURE LOWER INBOARD HOLE HAS CRACK. REAMED HOLE AND INSTALLED BUSHING AND BRACKET. ALL WORK PERFORMED IAW EC 5310-01377, EA 5310-01054 AND SRM 57-21-03. AC PRESSURE CHECKED GOOD.SDR 2006UALA00518Frame · damagedAFT PIT RIGHT FRAME NEEDS TO BE REPLACED. REMOVED AND REPLACED THE FRAME REF SRM 51-40-02.
Back to JASC 5311