Boeing 737-3Q8
Service difficulty reports · 4,188
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 = '7373Q8' 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 = '7373Q8' 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 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 SWAA111770Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT WEB CORRODED BETWEEN BS 194.3 TO BS 849. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111769Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 19R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111768Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 25L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111767Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 24R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111766Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 24L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111765Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 23L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111764Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 18L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111763Stringer Clip · brokenDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP BROKEN AT BS 400, STR 28L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111762Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 23R TO STR 24R. REPAIRED FRAME PER SRM.SDR SWAA111761Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 727A TO BS 727B, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA111760Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 28R TO STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA111759Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 5 SLAT SKIN CRACKED. REPAIRED SKIN PER MM.SDR SWAA111758Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND WEB CORRODED BETWEEN BS 639 TO BS 663.75, STR 17L. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111757Slat · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 4 SLAT I/B END DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA111756Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 19L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111755Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 23L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111754Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 23L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111753Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111752Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 909, STR 18L. REMOVED AND REPLACED STRINGER PER SRM AND BAC DWG.SDR SWAA111751Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.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 SWAA111743Skin · delaminatedDURING SCHEDULED 26Y CHECK, FOUND RT WING AFT FLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED AFT FLAP PER SRM.SDR SWAA111742Lens · looseDURING SCHEDULED 26Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 11. REMOVED AND REPLACED LENS PER MM.SDR SWAA111741Light · brokenDURING SCHEDULED 24Y CHECK, FOUND EMERGENCY EXIT SIDEWALL LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA111740Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500B, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111739Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 807, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111738Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA111737Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 18L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111736Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 22R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111735Stiffener · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX STIFFENER CRACKED AT BS 540, LBL 24.5. REMOVED AND REPLACED STIFFENER PER SRM AND BAC DWG.SDR SWAA111734Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111733Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111732Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB DOME CRACKED AT BS 1016, STR 15L. REPAIRED DOME PER SRM.SDR SWAA111731Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 6R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111730Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 3R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111729Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111728Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111727Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 760, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111726Web · corrodedDURING SCHEDULED 24Y CHECK, FOUND WEB CORRODED BETWEEB BS 727B TO BS 727C, STR 17R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111725Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 9L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.
Back to Boeing 737-3Q8