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 2007UALA01120Frame · crackedFWD PIT FRAME 31 OUTER FLANGE IS CRACKED BETWEEN STR 43R AND 42R. *S/D* MAJOR REPAIR ACCOMPLISHED: INSTALLED ANGLE DOUBLER.SDR SWAA071828Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071829Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700174Frame · corrodedFWD CARGO FRAME CORRODED AT STA 500 BETWEEN STRINGER 27R AND 28R. REPAIRED IAW SRM 53-00-07, REPAIR 4.SDR CALA0700173Frame · crackedFRAME CRACKED AT STA 616 JUST BELOW FLOOR LINE ON LEFT SIDE. REPAIRED IAW ECRA 5311-01158.SDR KCSA071141Frame · damagedFRAME AT STA 500 STR 26L HAS TOOLING DAMAGE.SDR 07FDEA01447Frame · crackedFOUND CRACK IN FRAME SEGMENT C74, P'26 RT. REPAIR PERFORMED BY REPLACEMENT OF AFFECTED FRAME SEGMENT IAW SRM 51-72-10.SDR UIEA200700181Frame · crackedLT S14 AREA FRAME CRACKED. CRACKED FRAME WEB REPAIRED AS PER SRM 51-40-03 FIG 1.SDR DHL2007806568Frame · damagedMAIN CARGO COMPT FRAME HAS A MISDRILLED HOLE AT STA 742.250 L-20R TO L-21R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 04-04-07, JC EC-00283-001, REPAIR ORDER NR 2-50701-801 DATED 04-04-07 (ED-4497). PERFORMED NDT INSPECTION IAW DC8 NDT SDR DHL2007806566Frame · damagedMAIN CARGO COMPT FRAME HAS A MISDRILLED HOLE STA 920.000 L-6R TO L-7R. PERFORMED MAJOR REPAIR IAW FAA FORM8110-3 DATED 04-04-07, JC EC-00283-001, REPAIR ORDER NR 2-50701-801 DATED 04-04-07 (ED-4499). PERFORMED NDT INSPECTION IAW DC8 NDT SPM PART 06-10-01-001SDR AWXA200700563Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED FUSELAGE FRAME, BS 727E, S9L. REPAIRED FUSELAGE FRAME, BS 727E, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700562Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED FUSELAGE FRAME, BS 727C, S9R. REPAIRED FUSELAGE FRAME, BS 727C, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700545Frame · crackedMCN - FOUND CRACKED FUSELAGE FRAME, BS 767, S9R. REPAIRED FUSELAGE FRAME, BS 767, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700544Frame · crackedMCN - FOUND CRACKED FUSELAGE FRAME, BS 887, S9R. REPAIRED FUSELAGE FRAME, BS 887, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700542Frame · crackedMCN - CRACKED FUSELAGE FRAME, BS 847, S9L. REPAIRED FUSELAGE FRAME, BS 847, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700541Frame · crackedMCN - CRACKED FUSELAGE FRAME, BS 500A, S9L. REPAIRED FUSELAGE FRAME, BS 500A, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700539Frame · crackedMCN - FOUND CRACKED FUSELAGE FRAME, BS 440, S9R. REPAIRED FUSELAGE FRAME, BS 440, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700532Frame · crackedMCN - FOUND CRACKED FRAME, BS 480, S9L. REPAIRED FRAME, BS 480, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700531Frame · crackedMCN - CRACKED FRAME, BS 440, S9L. REPAIRED FRAME, BS 440, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700530Frame · crackedMCN - FOUND CRACKED FRAME, BS 907, S9R. REPAIRED FRAME, BS 907, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700529Frame · crackedMCN - FOUND CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR AWXA200700528Frame · crackedMCN - FOUND CRACKED FRAME, BS 400, S9R. REPAIRED FRAME, BS 400, S9R IAW B737-300 SRM 53-00-07-2R2, FIGURE 201.SDR DU4R2007086Frame · chafedFOUND BENT AND CHAFED FRAME IN AFT PIT BS 1600 S-25R - S-26R. REPAIRED BY BLENDING, CUTTING OUT DENTED AREA. FABRICATED AND INSTALLED DOUBLER REPAIR 14-1/2 BY 2 FROM 2024-T3 .063 B757 SRM 53-00-07 FIG 201.SDR 2007UALA01117Frame · dentedAFT PIT BS 1440 AT STR 26L, FRAME DENTED 2 PLACES ON INBOARD FLANGE. MAJOR REPAIR ACCOMPLISHED: REPAIRED FRAME WITH A NESTED J-ANGLE REPAIR.SDR SWAA071805Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071798Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071804Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071803Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071787Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13L. REPAIRED FRAME PER SRM.SDR SWAA071802Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071806Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071801Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071797Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071800Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071799Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700171Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN FRAME AT STA 616 JUST BELOW FLOORLINE, S17R. THE CRACKED AREA OF FRAME WAS CUT OUT AND A REPAIR ANGLE WAS INSTALLED IAW ECRA 5311-01158.SDR NWAA071456306Frame · crackedDURING "M" CHECK, FOUND CRACK IN FRAME WEB HOLE AT BS 1265 S26L. ACCOMPLISHED INTERIM REPAIR PER EA 63-208916 SECTION I. REPETITIVE INSPECTIONS TO BE ACCOMPLISHED PER SECT II EVERY 2000 CYCLES. SECTION III PERMANENT REPAIR TO BE ACCOMPLISHED BASED ON SECTIONSDR 2007UALA01103Frame · misrepairedSTA 223 FRAME IS DAMAGED ON UPPER RADIUS, 6 O'CLOCK POSITION, JUST FWD OF NOSE COMPARTMENT DOOR CUTOUT. [SUP 05-16-07] MAJOR REPAIR ACCOMPLISHED. STA 223 FRAME IS DRILLED WITH A .375 INCH HOLE ON UPR RADIUS, DUE TO PREVIOUS IMPROPER REPAIR, HFEC INSPECTED RSDR 2007UALA01100Frame · corrodedFR 29 HAS 5 EA FRAME CLEATS WITH CORROSION BETWEEN STR 40L AND 41R. *S/D* MAJOR REPAIR ACCOMPLISHED: REPLACED 5 EA CLEATS.SDR 2007UALA01099Frame · corrodedFRAME 28 HAS 1 EA FRAME CLEAT WITH CORROSION BETWEEN STR 43R AND STR 44. *S/D* MAJOR REPAIR ACCOMPLISHED: REPLACED CLEAT.SDR 2007UALA01098Frame · corrodedFRAME 31 HAS 6 EA FRAME CLEATS WITH CORROSION BETWEEN STR 38R AND STR 41L. *S/D* MAJOR REPAIR ACCOMPLISHED: REPLACED 6 EA CLEATS.SDR 2007UALA01097Frame · corrodedFRAME 33 HAS 5 EA FRAME CLEATS WITH CORROSION BETWEEN STR 39R AND STR 42L. *S/D* MAJOR REPAIR ACCOMPLISHED: REPLACED 5 EA CLEATS.SDR SWAA071782Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR KCSA071133Frame · crackedBS 820 FUSELAGE FRAME CRACKED AT STR 11L.SDR DHL2007806539Frame · deformedMAIN CARGO COMPT FRAME DEFORMED STA 1580.000 L-21L. PERFORMED MAJOR REPAIR IAW SRM 53-4-1 FIG 51. REMOVED DAMAGED FRAME SEGMENT IAW SRM 53-1-0 PG 1, SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT P/N 2645791 (7075"0" 0.071") IAW SRM 53-4-1 FIG 51 SHEET 21 ITEM SDR DHL2007806538Frame · deformedMAIN CARGO COMPT FRAME DEFORMED STA 1580.000 L-21R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-4-1 FIG 51. REMOVED DAMAGED FRAME SEGMENT IAW SRM 53-1-0 PG 1, SRM 51-1-20D. FABRICATED NEW FRAME SEGMENT P/N 2645791 (7075"0" 0.071") IAW SRM 53-4-1 FIG 51SDR AWXA200700621Frame · crackedMCN - FOUND CRACKED R1 DOOR CUTOUT FWD STUB FRAME, BS 312, S16R. REPLACED R1 DOOR CUTOUT FWD STUB FRAME, BS 312, S16R IAW B737-300 SRM 51-40-02.SDR AWXA200700608Frame · crackedMCN - MAJOR REPAIR - CRACKED FRAME, BS 639, S16R. REPAIRED FRAME, BS 639, S16R IAW AWA ER 03-5362-07122-SS4.SDR XXUA200704038Frame · damagedAIRCRAFT DAMAGE BEHIND NOSE RADOME LOWER PART OF AIRCRAFT FRAME (20 BY 2 1/2) LOCATION BS 209-222 AND BL 8L-25R. FABRICATED ALL REPAIRS PARTS PER BOEING REPAIR SKETCH SR 1-312155879. INSTALLED ALL REPAIR PARTS WITH SEALANT PER BOEING REPAIR SKETCH R 1-312155SDR 2007UALA01064Frame · corrodedFWD PIT FR 26 HAS 2 EA FRAME CLEATS WITH CORROSION BETWEEN STR 41R AND 44R. MAJOR REPAIR ACCOMPLISHED: REPLACED CLEATS.
Back to JASC 5311