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 FDEA201103150978Frame · dentedFWD CARGO STA. 660 STR. 23R FRAME DENTED. CUTOUT DAMAGE FROM BS 660 FRAME ABOVE STR 23R, 1" X 1" IAW SRM 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER IAW SRM REV 103 51-40-3 FIG 1. INSTALLED DOUBLER IAW SRM 51-30-2 AND 51-40-3 FIG 1.SDR FDEA201103150975Frame · crackedFWD CARGO COMPARTMENT OVERHEAD FLOORBEAM; FWD SIDE OF FRAME 30 & LBL 27 IS CRACKED.SDR SWAA111907Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACK ON FRAME STA 847, BELOW STR 1L. REPAIRED FRAME PER ER AND EA.SDR SWAA111906Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACK ON FRAME WEB STA 639, STR 7R. REPAIRED FRAME ER AND EA.SDR SWAA111905Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACK ON FRAME WEB STA 420, STR 1. REPAIRED FRAME PER ER AND EA.SDR DALA1118913114Frame · corrodedAFT CABIN STR 23L BETWEEN FR70 AND FR69 HAS CORROSION IN AND UNDERSIDE OF OVAL HOLES. BLENDED AREA IAW A319 SRM 51-74-00 FOUND TO BE OUT OF LIMITS IAW A319 SRM 53-41-14. REMOVED SUPPORT FRAME IAW SRM 51-42-11. LOCATED AND DRILLED NEW SUPPORT IAW SRM 51-44-1SDR C2XA11SH068Frame · crackedSHV - DURING C-CHECK FR 10 IS CRACKED JUST BELOW LT DV WINDOW. REMOVED AND REPLACED FR 10 IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1135459220Frame · corrodedHMV STA 1443 LOWER FRAME CORRODED. REMOVED AND REPLACED FRAME IAW SRM 51-10-05 AND SRM 51-30-00.SDR V0XR20110314002Frame · corrodedRT BEAM FRM 58-63 IS CORRODED OUT OF LIMITS. R & R RT BEAM FRAME 58-63 IAW SRM 51-10-02, 51-40-02, AND CPM 51-21-05, 51-21-04.SDR FDEA201103140957Frame · dentedCABIN RIGHT BS 1701 L-11 FRAME FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 45. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 112. INITIAL INSPECTION TO BE CARRIED OUT AT 14500 CYCLE AND REPETITIVE INSPECTION AT 9500 USING HFEC METHSDR MU1Z2011020200003Frame · dentedFUSELAGE DENT BETWEEN FR 6 AND FR 7 APROX 6.5" DOWN RT SIDE STRINGER. DEPTH 1.57MM A= 21.97MM.SDR SWAA111919Frame · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK RT SIDE FRAME FWD PIT STA 482. REPAIRED FRAME PER SRM.SDR SWAA111918Frame · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK LT SIDE FRAME REINFORCEMENT FWD PIT STA 482A. REPAIRED FRAME PER SRM.SDR USAA2011031591060Frame · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 747, S27R. REPLACED FUSELAGE FRAME SECTION AT BS 747, S27R IAW B737 SRM 53-00-07.SDR SWIA201125965Frame · corrodedCORROSION AT CENTER OF FRAME 38 IN FUSELAGE. (C-CHECK) REPAIRED CENTER OF FRAME 38 AT FUSELAGE PER SRM.SDR ASOA201100578Frame · damagedREPAIR FROM RBL 27 TO LBL27 HAS SEVERAL UNSERVICEABLE FASTENERS. REMOVED UNSERVICABLE ANGLE AND INSTALLED SERVICABLE ANGLE PN 600 34017-3515 IAW SRM 51-42-06. LOCATION: FS280 FWD FLOOR SUPPORT ANGLE. THIS IS A MAJOR REPAIR. RII FOUND TO BE SATISFACTORY.SDR SWAA111801Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111800Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111799Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111798Frame · crackedDURING SCHEDULED12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA111797Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111796Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111795Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA111780Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 13R TO STR 14R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111779Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 17R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111775Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA111774Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111773Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111772Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111771Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR FDEA201103120947Frame · dentedMAIN DECK FRAME DENTED AT BS 1741 LONGERON 12LT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-00SDR FDEA201103120946Frame · dentedMAIN DECK FRAME DENTED AT BS 1681 LONGERON 12LT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPETION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-00-SDR FDEA201103120945Frame · dentedMAIN DECK FRAME DENTED AT BS 1661 LONGERON 12RT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-00SDR FDEA201103120944Frame · dentedMAIN DECK FRAME DENTED AT STATION 1701 LONGERON 12RT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPETION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 5SDR FDEA201103120943Frame · dentedMAIN DECK FRAME DENTED AT STATION 1721 LONGERON 12RT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED - INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM SDR FDEA201103120942Frame · dentedMAIN DECK FRAME DENTED AT BS 1741 LONGERON 12RT. REPAIRED AS PER SRM 53-00- 07 FIGURE 201 REPAIR 2 REVISION 45. REPETITIVE INSPECTION REQUIRED. INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPETION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SRM 53-00-SDR SWAA111762Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 23R TO STR 24R. REPAIRED FRAME PER SRM.SDR SWAA111750Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 460, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111749Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111748Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA111747Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA111746Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727D, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA111745Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA111744Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111738Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA111673Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 24R. REPAIRED FRAME PER EA.SDR SWAA111654Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN BL 0 TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA111626Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA111618Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 639, STR 14R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR TAMF201103110066Frame · crackedDURING C4 CHECK FUSELAGE FRAME WEB STA 1395, RBL 14.5, STR 34L - 37L, THERE ARE 2 CRACKS IN THE FRAME WEB. REPAIR WAS PERFORMED WITH EWO 767-53-120.
Back to JASC 5311