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 SWAA112457Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112456Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED ADN REPLACED CLIP PER SRM.SDR SWAA112455Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112454Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112453Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112452Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112451Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112450Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112449Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112502Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 517, STR 8L. REPAIRED SKIN PER EA.SDR SWAA112382Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112381Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112380Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112383Sign · looseLT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA112303Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 827, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA112302Stringer · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA112301Stringer Clip · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112229Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 908, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA112228Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, RBL 8. REPAIRED SHEAR TIE PER SRM.SDR SWAA112227Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 516D, STR 20R. REPAIRED SKIN PER ER AND EA.SDR SWAA112226Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, RBL 5. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA112225Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 667, LBL 24.5. REPAIRED BEAM PER ER AND EA.SDR SWAA112090Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 767+13, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA112089Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727D, BETWEEN BL 0 TO RBL 5. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA112088Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 460, BL 0. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA112055Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 764, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112054Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 754, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA112053Stringer · corrodedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CORRODED AT BS 398, STR 25L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA112052Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA112039Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA112016Keelbeam · corrodedDURING SCHEDULED 26Y CHECK, FOUND RT KEEL BEAM CORRODED AT BS 787. REPAIRED BEAM PER EA AND SRM.SDR SWAA112015Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 662, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA112014Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 485, STR 16R. REPAIRED SKIN PER ER AND EA.SDR SWAA111874Light · out of positionDURING SCHEDULED MV1 CHECK, FOUND L1 EMERGENCY LIGHT INOP. REPOSITIONED LIGHT IN CHARGER PER MM.SDR SWAA111806Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA111805Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 500A, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA111804Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 2 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA111803Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 24R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWGSDR SWAA111788Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA111786Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 767 TO BS 787, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA111785Charger · inoperativeDURING SCHEDULED 24Y CHECK, FOUND EMERGENCY EXIT LIGHT BATTERY CHARGER INOP. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA111784Spoiler · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR4 SPOILER DELAMINATED. REPAIRED SPOILER PER SRM.SDR SWAA111783Spoiler · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 SPOILER DELAMINATED. REPAIRED SPOILER PER SRM.SDR SWAA111782Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA111780Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 13R TO STR 14R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111779Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 17R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA111778Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRDED BETWEEN BS 787 TO BS 807, STR 26L. REMOVED AND REPLACED STRINGER PER SRM AND BAC DWG.SDR SWAA111777Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRDED AT BS 793.5, STR 26R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111776Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, RBL 5. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA111775Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.
Back to Boeing 737-3Q8