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 SWAA062638Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA062637Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA062636Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA062635Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA062634Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L AND STR 8R. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA062628Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ASAA0640804Frame · crackedFOUND CRACK IN FRAME STRAP. REMOVED AND REPLACED FRAME STRAP PER SRM 51 40 02.SDR ASAA0640802Frame · crackedFOUND CRACK IN FRAME. REPAIRED PER SRM 53 00 07.SDR EIA2006161Frame · crackedFOUND FUSELAGE FRAME STA 280 LT SIDE CRACKED AT STR 27 AT CUTOUT. REPAIRED IAW B747 SRM 53-10-04 FIG 11, 2024-T42 0.063 REPAIR DOUBLER USED.SDR 06FDEA2672Frame · dentedDENTED FRAME AT BS 1148 STRINGER 25R. REMOVED DAMAGED AND REPAIR FRAME PER SRM 51-40-3.SDR 06FDEA2667Frame · dentedFRAME DENTED BETWEEN STR 23 AND 24 RT, STA 680. CUT OUT DAMAGE AND FABRICATED REPAIR IAW SRM 51-40-3 FIG 1.SDR 06FDEA2666Frame · dentedFRAME DENTED BETWEEN STR 23 AND 24 LT, STA 520. CUT OUT DAMAGE AND FABRICATED REPAIR IAW SRM 51-10-3 FIG 1.SDR SWAA062626Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED BS 349, STR 16L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062622Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062621Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062620Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062619Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062618Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062617Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062616Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA062615Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA062614Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA062613Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA062612Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA060950Frame · crackedSTA 787 S8R-S9R ACTION: REMOVED DAMAGE, INSTALLED DOUBLER REPAIR IAW TR 53-10-20D DEFECT SIZE: .125 INCH.SDR USAA060952Frame · crackedSTA 440 S8L AND S9L. REMOVED DAMAGE, INSTALLED DOUBLER REPAIR IAW TR 53-10-20D. DEFECT SIZE: .250 INCH.SDR EIA2006176Frame · crackedFUSELAGE FRAME B STA 940 RT FOUND CRACKED BETWEEN STR 37 & STR 38. REPAIRED IAW B747 SRM 53-10-04 FIG 52 REPAIR DOUBLER USED 7075-T6 0.063SDR EIA2006182Frame · crackedFUSELAGE FRAME B STA 960 RT FOUND CRACKED AT CUTOUT FOR STR 31 (TOP CORNER). CRACKED FRAME REPAIRED IAW B747 SRM 53-10-04 FIG 4 REPAIR ANGLE WEB 7075-T6 0.063 USED.SDR EIA2006181Frame · crackedFUSELAGE FRAME B STA 800 LT INNER CHORD FOUND CRACKED BETWEEN STR 35-36. REPAIRED IAW B747 SRM 53-10-04 FIG 52, DOUBLER 7075-T6 0.063 & STRAP 7075-T6 0.040 USED.SDR EIA2006180Frame · crackedFUSELAGE FRAME B STATION 820 LT FOUND CRACKED AT CUTOUT FOR STR 33 (TOP CORNER). REPAIRED IAW B747 SRM 53-6-04 FIG 4 7075-T6 0.071 REPAIR ANGLE USED.SDR EIA2006179Frame · crackedFUSELAGE FRAME B STATION 940 RT FOUND CRACKED AT CUTOUT FOR STR 34 (BOTTOM CORNER). REPAIR IAW B747 SRM 51-40-03 FIG 3 7075-T6 0.063, REPAIR ANGLE USED.SDR EIA2006178Frame · crackedFUSELAGE FRAME B STA 940 RT FOUND CRACKED AT CUTOUT FOR STR 31 (TOP CORNER). REPAIRED IAW B747 SRM 53-10-04 FIG 4, 7075-T6 0.071 REPAIR ANGLE USED.SDR EIA2006177Frame · crackedFUSELAGE FRAME B STA 940 RT FOUND CRACKED AT CUTOUT FOR STR 30 (TOP CORNERS). REPAIRED IAW B747 SRM 53-10-04 FIG 4 7075-T6 0.071, REPAIR ANGLE USED.SDR EIA2006173Frame · crackedRIGHT CANTED BULKHEAD STA 260 FRAME FOUND CRACKED AT WEB AND INNER CHORD FROM STR S-40 TO NOSE WHEEL WELL TORQUE BOX. REPAIRED IAW B747 SRM 53-10-04 FIG 70. DOUBLER USED 7075-T6 0.080, CHORD REPAIRED IAW B747 SRM 51-40-04 FIG 1.SDR EIA2006172Frame · crackedFUSELAGE FRAME B STA 540 LT FOUND CRACKED AT CUTOUT FOR STR 43 INBOARD CORNER. REPAIRED IAW B747 SRM 53-10-04 FIG 3A, 7075-T6 0.071, REPAIR ANGLE USED.SDR EIA2006171Frame · crackedFUSELAGE FRAME B STA 880 RT FOUND CRACKED AT CUTOUT FOR STR 33 (TOP CORNER). REPAIRED IAW B747 SRM 53-10-04. REPAIR ANGLE USED 7075-T6 0.063.SDR EIA2006170Frame · crackedFUSELAGE FRAME B STA 540 RT INNER FLANGE FOUND CRACKED AT STR 26 (REFER TO SRM 53-10-21 FIG 9 ITEM 10 FOR LOCATION). REPAIRED IAW B747 SRM 53-10-04 FIG 52. DOUBLER 7075-T6 0.063 AND STRAP 7075-T6 0.040 USED.SDR HALA0600574Frame · crackedAFT CARGO BAY, CRACKED VERTICAL SUPPORT ON FRAME AT BS 1439, LBL 22.20, WL 130. REMOVED AND REPLACED VERTICAL SUPPORT ON FRAME BS 1439 LBL 22.2, WL 130 PER SRM 51-40-02.SDR ASAA0640797Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE ANGLE. REPLACED PART PER SRM 51 40 02 AND DWG 65 47959.SDR ASAA0640796Frame · crackedCRACK IN FRAME FASTENER. REPAIRED FRAME PER SRM 53 00 07.SDR ASAA0640793Frame · corrodedFOUND CORROSION ON FRAME. REPAIRED PER SRM 53 00 07.SDR ASAA0640792Failsafe · corrodedFOUND CORROSION ON FAIL/SAFE. REPAIRED PER SRM 51 70 11.SDR ASAA0640800Frame · puncturedFOUND FASTENER AT STA 787 ABOVE ATR 25R HAS GOUGED TOP OF FRAME. REMOVED DAMAGED PART OF FRAME AND INSTALLED REPAIR PARTS IAW SRM 51 70 11 FIG 1.SDR ASAA0640791Frame · puncturedFOUND UPPER FRAME FLANGE PUNCTURED. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 51 70 11.SDR CALA0600258Frame · crackedAFT BILGE FRAME CRACKED AT STA 947.5, STR 19L. REPLACED FRAME PER SRM 51-40-02.SDR AWXA200601376Frame · crackedMCN - FOUND FRAME CRACKED AT WL 207 RBL 31. MAINTENANCE CUT AND REMOVED DAMAGED AREA OF 188 FRAME AT WL 207 RBL 31 AND REPAIRED 188 FRAME IAW B737-300 SRM 53-00-07 2R 11 FIG 201.SDR AWXA200601375Frame · crackedMCN - FOUND FRAME CRACKED AT WL 207 LBL 31. MAINTENANCE CUT AND REMOVED DAMAGED AREA OF 188 FRAME AT WL 207 LBL 31. REPAIRED 188 FRAME IAW B737-300 SRM 53-00-07-2R 11 FIG 201.SDR SWAA062558Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, RBL 2. REPAIRED FRAME SECTION PER SRM.SDR SWAA062557Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062556Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R. REPAIRED FRAME SECTION PER SRM.
Back to JASC 5311