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 SWAA105738Floor Support · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 44. REPAIRED BEAM IAW ER AND EA.SDR SWAA105737Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 13R TO STR 14R. REMOVED AND REPLACED FRAME PER ER AND EA.SDR SWAA105728Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CHORD CRACKED AT BS 639, RBL 65. REPAIRED CHORD PER SRM.SDR SWAA105727Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 500B TO BS 500C, STR 27L. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA105726Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105719Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105718Wedge · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 2 SLAT WEDGE CRACKED ON LOWER SURFACE. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA105717Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105716Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 460 TO BS 480, STR 26L. REMOVED AND REPLACED STRINGER PER SRM.SDR USAA2010092292072Drag Angle · crackedMIA - C20 - MAJOR REPAIR - CRACK ON LEFT AFT VERTICAL STABILIZER ATTACH FITTING DRAG ANGLE AT BS 1016, VERT FIN STA 0. REPAIRED LEFT AFT VERTICAL STABILIZER ATTACH FITTING DRAG ANGLE AT BS 1016, VERT FIN STA 0 IAW TYPICAL REPAIR 53-80-30.SDR USAA2010092292071Skin · crackedMAJOR REPAIR - CRACK ON LT WING OTBD MID FLAP L/E SKIN BETWEEN WBL204.4 TO WBL219.4. REPAIRED LT WING OTBD MID FLAP L/E SKIN BETWEEN WBL204.4 TO WBL219.4 IAW SRM 57-53-01 REPAIR NR 8.SDR SWAA105681Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105680Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN BBL 0 TO RBL 4. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105668Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 860, LBL 12.5. REPAIRED CHANNEL PER EA.SDR SWAA105667Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 773, LBL 12.5. REPAIRED CHANNEL PER EA.SDR SWAA105666Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 732D, LBL 12.5. REPAIRED CHANNEL PER EA.SDR SWAA105665Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 772, RBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA105664Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 732D, RBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA105663Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER EO.SDR SWAA105662Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 732C, RBL 3.10. REPAIRED CHANNEL PER EA.SDR SWAA105661Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED BETWEEN BS 727 TO BS 727A, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA105660Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 24L TO STR 23L. REPAIRED FRAME PER EO.SDR SWAA105659Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPART CHANNEL CORRODED BETWEEN BS 767 TO BS 787, RBL 8.10. REPAIRED FRAME PER EO.SDR SWAA105658Keelbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM WEB CRACKED AT BS 711, BBL 0. REMOVED AND REPLACED WEB PER BAC DWG AND SRM.SDR SWAA105657Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 816.5, STR 22L. REPAIRED STRINGER PER SRM.SDR SWAA105656Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 26L. REPAIRED FRAME PER EO.SDR SWAA105655Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 639, STR 10R. REPAIRED FRAME PER EO.SDR SWAA105654Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED BETWEEN BS 543 TO BS 616, STR 15R. REMOVED AND REPLACED STRINGER PER SRM AND BAC DWG.SDR SWAA105653Support Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND SUPPORT ANGLE CRACKED AT BS 306.9, STR 10L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA105652Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 639, BETWEEN STR 7L TO STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA105651Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM CORRODED AT BS 500D, STR 28R. REPAIRED BEAM PER SRM.SDR SWAA105650Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 500D, STR 27R. REPAIRED STRINGER PER SRM.SDR SWAA105649Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 500D, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA105648Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 867 TO BS 887, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA105647Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA105646Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA105645Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA105644Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA105643Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA105642Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA105641Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105701Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105630Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 13R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105629Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 12R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105628Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE ANGLE CRACKED AT BS 303, STR 15L. REMOVED AND REPLACED ANGLE PER BAC DWG.SDR SWAA105627Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105626Channel · crackedDURING SCHEDULED 24Y CHECK, FOUND SPLICE CHANNEL CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CHANNEL PER SRM AND BAC DWG.SDR SWAA105625Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER BAC DWG.SDR SWAA105623Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 663, BETWEEN STR 2R TO STR 3R. REPAIRED SKIN PER ER AND EA.SDR SWAA105622Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 639, RBL 63. REMOVED AND REPLACED CHORD SECTION PER SRM.
Back to Boeing 737-3Y0