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 SWAA086851Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086850Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 859, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086849Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086848Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086793Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 996, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA086787Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA086738Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA086577Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA086368Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27R TO STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA086345Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27R TO STR 25R. REMOVED AND REPLACED SHEAR TIE PER AAR EA.SDR SWAA086248Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 945, STR 25R. REPAIRED SKIN PER EA.SDR SWAA086247Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 12, STR 23. REPAIRED SKIN PER EA.SDR SWAA086246Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 748, STR 23L. REPAIRED SKIN PER EA.SDR SWAA086245Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 21R. REPAIRED SKIN PER EA.SDR SWAA086244Lug · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT MLG LOWER FITTING LUG CORRODED. REPAIRED LUG PER SWA EA.SDR SWAA086225Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 967, STR 27L. REPAIRED SKIN PER AAR EA.SDR SWAA086208Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086206Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086205Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086204Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086203Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086202Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086093Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086156Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT LOWER NR 5 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA086072Skin · crackedDURING SCHEDULED SPV CHECK, FOUND NR 3 SLAT LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA086071Lens · looseFOUND L1 DOOR EMERGENCY EXIT LENS UNSECURED. INSTALLED LENS PER MM.SDR SWAA085907Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, BETWEEN STR 17R TO STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA086101Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT BS 161.9. REPAIRED SKIN PER EA.SDR SWAA085856Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED BETWEEN RIB STA 147 TO RIB STA 157. REPAIRED SKIN PER SWA EA.SDR SWAA085855Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, BETWEEN STR 18R TO STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA085802Light · missingDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT PLATE MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA085552Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA085551Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 797, BELOW STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085550Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 798, ABOVE STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085549Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 791, ABOVE STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085187Keelbeam · corrodedDURING SCHEDULED HC2 CHECK, FOUND KEEL BEAM CORRODED AT BS 500C + 10. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA084902Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR CUTOUT AFT UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA084901Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 773, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA084900Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 581, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA084711Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING OUTBOARD T/E FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA084710Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA084673Slide · low pressureDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA084640Light · crackedDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT ASSY CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA084619Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 939, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA084618Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084617Light · brokenDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA084600Fitting · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 4 SPOILER OUTBOARD LUG FITTING CRACKED. REPAIRED FITTING PER SWA EA.SDR SWAA084599Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17L. REPAIRED WEB PER SRM.SDR SWAA084598Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17R. REPAIRED WEB PER SRM.SDR SWAA084570Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 25L AND STR 27L. REPAIRED FRAME PER SRM.
Back to Boeing 737-3Q8