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 SWAA105413Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 6 SPOILER SKIN CRACKED. REPAIRED SPOILER PER SRM.SDR SWAA105391Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105390Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105389Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105388Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 27L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105387Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 26L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105386Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105385Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B EDGE OF I/B FORE FLAP SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105384Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING I/B EDGE OF O/B FORE FLAP SKIN DELAMINATED. REPAIRED SKIN PER SRM.SDR USAA2010091491989Floorbeam · corrodedMIA - C20 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT BS 328 BETWEEN RBL 26 TO RBL 36. REPAIRED FLOORBEAM AT BS 328 BETWEEN RBL 26 TO RBL 36 IAW B737 SRM 53-10-51, 53-30-51 & 53-00-51.SDR SWAA105364Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105363Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA105362Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105361Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 26R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA105360Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 727B, 20R. REMOVED AND REPLACED CLIP PER SRM BAC DWG.SDR SWAA105359Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 907, RBL 13.80. REMOVED AND REPLACED CLIP PER SRM BAC DWG.SDR SWAA105358Support Angle · corrodedDURING SCHEDULED 24Y CHECK, FOUND LOWER SUPPORT ANGLE CORRODED AT BS 719, BETWEEN LT AND RT KEEL BEAM. REMOVED AND REPLACED SRM AND BAC DWG.SDR SWAA105357Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 727D, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105356Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 727A, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105355Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 460 TO BS 490, STR 27L. REMOVED AND REPLACED STRINGER PER SRM AND BAC DWG.SDR SWAA105381Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 15L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA105380Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 14L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA105347Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105346Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA105328Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787 STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105327Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747 STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105326Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706 STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105325Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597 STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105324Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578 STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105323Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597 STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105322Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597 STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105321Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578 STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105320Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105319Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105318Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105317Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105316Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 SLAT SKIN I/B EDGE DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA105315Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 559 TO BS 578, STR 17R. REPAIRED WEB PER SRM.SDR SWAA105314Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4R. REPAIRED CLIP PER SRM.SDR SWAA105313Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4L. REPAIRED CLIP PER SRM.SDR SWAA105312Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 10L. REPAIRED CLIP PER SRM.SDR SWAA105311Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 15L. REPAIRED CLIP PER SRM.SDR SWAA105310Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA105309Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 20L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105307Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105306Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 14L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105305Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105304Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105291Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.SDR SWAA105290Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER ER AND EA.
Back to Boeing 737-3Y0