Boeing 737-3Y0
Service difficulty reports · 3,007
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7373Y0' 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 aircraft_model_key = '7373Y0' 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 SWAA105621Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER ER AND EA.SDR SWAA105620Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 663, BETWEEN STR 2R TO STR 3R. REPAIRED FRAME PER ER AND EA.SDR SWAA105619Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT EXTERNAL POWER DOOR CUTOUT BETWEEN BS 227 TO BS 235.8, BETWEEN STR 19R TO STR 24R. REPAIRED SKIN PER EA.SDR SWAA105618Floor Support · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 714, BBL 0. REPAIRED WEB PER ER AND EA.SDR SWAA105617Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, LBL 66. REPAIRED FRAME PER ER AND EA.SDR SWAA105616Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, RBL 66. REPAIRED FRAME PER ER AND EA.SDR SWAA105615Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 500 TO BS 500A, STR 26L. REPAIRED STRINGER PER ER AND EA.SDR SWAA105614Floor Support · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 705 TO BS 712, LBL 24.5. REPAIRED WEB PER ER AND EA.SDR SWAA105613Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 44. REPAIRED BEAM PER ER AND EA.SDR SWAA105612Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 26. REPAIRED BEAM PER ER AND EA.SDR SWAA105567Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105566Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105565Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA105564Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA105563Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA105562Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708 TO BS 711, LBL 24.8. REPAIRED WEB PER EO.SDR SWAA105560Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING UPPER SURFACE SPOILER NR 8 O/B EDGE DELAMINATED. REPAIRED SPOILER PER SRM.SDR SWAA105557Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND VERTICAL FRAME ANGLE CRACKED AT BS 727B, LBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA105556Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND WEB SUPPORT CORRODED BETWEEN BS 440 TO BS 500, RBL 22. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA105555Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 495, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA105554Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 500 TO BS 500A, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA105553Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787A, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA105552Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA105551Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA105534Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP PER MM.SDR SWAA105533Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND L WING O/B FORE FLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA105532Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 1L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105531Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 1L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105530Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105529Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105528Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105527Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105526Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA105523Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105522Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105516Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105515Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105514Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105513Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA105512Tab · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING AILERON TAB DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA105499Attach Bracket · looseDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR ATTACH BRACKETS LOOSE. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA105498Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 1 SLAT LOWER SURFACE CRACKED. REPAIRED SLAT PER SRM.SDR SWAA105425Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA105424Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPART WEB CORRODED BETWEEN BS 807 TO BS 827, STR 18R. REMOVED AND REPLACED WEB PER BAC DWG AND SRM.SDR SWAA105421Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 616, BETWEEN STR 7L TO STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA105418Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM WEB BETWEEN BS 660 TO BS 727, CORRODED. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA105417Web · crackedDURING SCHEDULED 24Y CHECK, FOUND WEB CRACKED AT BS 294.5, STR 15L. REPAIRED WEB PER SRM AND BAC DWG.SDR SWAA105416Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA105415Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 440, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA105414Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D, STR 28L. REPAIRED BEAM PER SRM.
Back to Boeing 737-3Y0