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 08FDEA01773Frame · gougedMAIN CABIN FRAME 40 L BETWEEN STRINGER 15L AND STRINGER 16 L THE FRAME IS GOUGED. PERFORMED SMOOTH BLENDOUT FOR THE DAMAGED AREA IAW EA 6-5312-118485 "FUSELAGE FRAME 40 AT STRINGER 15L AND STRINGER 16L GOUGE REPAIR". RESTORED THE SURFACE PROTECTION IAW EA 6SDR SWAA082312Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, BL 0 AND LBL 10. REPAIRED FRAME PER SRM.SDR CALA0800391Frame · crackedCABIN STATION 400 BETWEEN S8L AND S9L HAS PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. REPAIRED FRAME REF EA 5310-04498.SDR CALA0800390Frame · crackedCABIN STATION 500 AT S9R PASSENGER SERVICE UNIT RAIL BRACKET TO FRAME CRACKED. REPAIRED FRAME REF EA 5310-04498.SDR CALA0800389Frame · crackedCABIN STATION 747 AT S9L PASSENGER SERVICE UNIT RAIL BRACKET TO FRAME CRACKED. REPAIRED FRAME REF EA 5310-04498.SDR CALA0800387Frame · crackedCABIN STATION 787 BETWEEN S8R AND S9R PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. INSTALLED REPAIR DOUBLERS PER EA 5310-04498.SDR CALA0800386Frame · crackedCABIN STATION 867 BETWEEN S8R AND S9R PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. INSTALLED REPAIR ANGLES REF EA 5310-04498.SDR CALA0800385Frame · crackedCABIN STATION 787 BETWEEN S8L AND S9L PASSENGER SERVICE UNIT RAIL ATTACH BRACKET FRAME CRACKED. REPAIRED FRAME AT STATION 787 BETWEEN S8L AND S9L PER EA 5310-04498.SDR CALA0800383Frame · crackedCABIN STATION 400 BETWEEN S8R AND S9R PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. REPAIRED FRAME AT STATION 400 BETWEEN S8R AND S9R PER EA 5310-04498.SDR CALA0800382Frame · crackedCABIN STATION 747 BETWEEN S8R AND S9R PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. REPAIRED FRAME AT STATION 747 BETWEEN S8R AND S9R PER EA 5310-04498.SDR CAKA0800384Frame · crackedCABIN STATION 440 AT S9L PASSENGER SERVICE UNIT RAIL BRACKET TO FRAME CRACKED. INSTALLED REPAIR DOUBLERS PER EA 5310-04498.SDR 08FDEA01614Frame · damagedUPPER FUSELAGE INTERIOR FRAME AT RIGHT STA 1681 LONGERON 11 FOUND DAMAGED. UPPER FUSELAGE INTERIOR, DENT FRAME AT RT BS 1681 LONGERON 11 REPAIRED AS PER SRM 53-30-00. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRISDR SWAA082284Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082290Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, RBL 16. REPAIRED FRAME PER SRM.SDR SWAA082288Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082287Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082286Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082285Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082283Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082289Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082260Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 520, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA082261Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082277Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082250Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 22L. REPAIRED FRAME PER SRM.SDR SWAA082297Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082298Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR F3LA200800264Frame · damagedDURING C2 C CHECK INSPECTION NOTED FRAME 75 DAMAGED STRINGER 26 LEFT AND STRINGER 26 RIGHT. MAINTENANCE REPLACED FRAME 75 AND ALL ATTACHING SHEAR TIES IN ACCORDANCE WITH THE REQUIREMENTS OF EA A9-53R-30262. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND SDR F3LA200800252Frame · damagedDURING C3 S1 C CHECK INSPECTION NOTED FRAME 72 DAMAGED AT STRINGER 26 LEFT. MAINTENANCE REMOVED AND REPLACED FRAME 72 IN ACCORDANCE WITH THE REQUIREMENTS OF SRM 51-42-11 FIGURE 8. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE.SDR CA080425006Frame · cracked(CAN) VISUAL INSPECTION FOUND THAT INNER FRAME CHORD AT BS 616, RT, WL 200 AT STUB BEAM TO BE CRACKED. (TC NR 20080425006)SDR CALA0800369Frame · crackedCABIN STATION 727B LT BETWEEN S8LT AND S9LT PASSENGER SERVICE UNIT (PSU) RAIL ATTACH BRACKET TO FRAME CRACKED. INSTALLED REPAIR DOUBLERS PER EA 5310-04498 OPS 2.SDR CALA0800365Frame · crackedCABIN STATION 867 LT BETWEEN S9L AND S8L PASSENGER SERVICE UNIT (PSU) RAIL ATTACH BRACKET TO FRAME CRACKED. REPAIRED FRAME AT STA 867 LT BETWEEN S8L AND S9L PER EA5310-04498.SDR 08FDEA01586Frame · corrodedFWD PIT, FRAME AT STA 720D HAS CORROSION ON THE FWD FACE AROUND CABLE CUT OUT AT LBL 1. FOUND WITHIN LIMITS IAW SRM 53-10-2.SDR 08FDEA01548Frame · damagedFOUND DEFORMED FLANGE AT C 75, P26 RT REPAIR PERFORMED BY REWORK OUTER FLANGE TO ELIMINATE THE DEFORMATION, NDT FOR CRACK FREE IAW AS/EFW/9000019/2008 ISS A, APPROVED BY EA 6-5318-117150.SDR 08FDEA01547Frame · damagedFOUND DEFORMED FLANGE AT C 74, P26-27 LT/RT REPAIR PERFORMED BY REWORK OUTER FLANGE TO ELIMINATE THE DEFORMATION, NDT FOR CRACK FREE IAW RAS/EFW/9000019/2008 ISS A, APPROVED BY EA 6-5318-117150.SDR CALA0800363Frame · corrodedFRAME AT BILGE AREA AT STATION 767 LBL 9 IN AFT CARGO COMPARTMENT FOUND CORRODED. CORROSION FOUND TO BE OUT OF LIMITS PER B 737-500 SRM 53-00-07 AND 53-60-07. REMOVED CORROSION AND ACCOMPLISHED REPAIR PER B 737-500 SRM 53-00-07 REPAIR 8.SDR USAA920081163Frame · crackedMCN - MAJOR REPAIR - LEASE RETURN - CRACKED FRAME, BS 492, S24R. REPLACED FRAME, BS 492, S24R IAW B737 SRM 51-40-02.SDR 2008UALA02423Frame · gougedAFT PIT LEFT SIDE FRAME HAS GOUGE AT BS 1580 BTWN STRS 27L AND 26L. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 RPR 5. PER SRM 53-00-07 RP R 5 TABLE II THIS RPR REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES AND 1SDR 2008UALA02422Frame · dentedAFT PIT FUSELAGE FRAME AT STA 1340 BETWEEN STRINGERS 25R AND 26R DENTED. CUT OUT DAMAGE FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 RPR 5. PER SRM 53-00-07 RP R 5 TABLE II THIS RPR REQUIRES SUPPLEMENTAL INSPECTIONS STARTING AT 50,000 TOTAL FLIGHT CYCLES SDR SWAA082233Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082232Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082231Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082218Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082216Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082219Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082217Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082214Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082213Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082212Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082220Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082215Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311