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 SWAA060666Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500D, LBL 5. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA060645Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA060644Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA060643Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA060642Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, BL 0. REPAIRED FRAME PER SRM.SDR SWAA060641Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 727E, STR 14R. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060640Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 354, STR 16L. REPAIRED STRINGER PER SRM.SDR SWAA060639Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 365, STR 28L. REPAIRED STRINGER PER SRM.SDR SWAA060638Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 312, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA060637Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500D, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060636Girt Bar · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT FLOOR FITTING CORRODED. REMOVED AND REPLACED FLOOR FITTING PER SRM.SDR SWAA060622Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 915, STR 25R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060621Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 597, STR 13L. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060620Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 579, STR 13L. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060619Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500D, STR 19R. REPAIRED BELTFRAME PER SWA EA.SDR SWAA060613Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060612Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 365, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA060611Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 927, BL 0. REPAIRED FLOORBEAM PER SRM.SDR SWAA060610Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 753 TO BS 764, STR 19L TO STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA060609Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA060608Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA060607Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA060606Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA060605Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732E TO BS 741E, STR 22L TO STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060576Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941.5, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA060571Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR BRACKET CORRODED. REMOVED AND REPLACED FWD BRACKET PER SRM.SDR SWAA060570Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 764 TO BS 765, STR 19L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060580Fan · faultyDIVERSION/DECLARED EMERGENCY. STRONG BURNING ODOR IN CABIN. FOUND GASPER FAN WITH STRONG BURNED ODOR. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA060537Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND LEFT WING NR 2 L/E SLAT LOWER T/E SKIN CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA060456Wire · chafedAIR TURNBACK, SMOKE SMELL IN COCKPIT. FOUND WIRE 268-010-08 CHAFED AT CONNECTOR D13730, AFT OF P5 PANEL. SPLICED WIRE PER WDM.SDR SWAA060433Hinge · brokenNR 5 GROUND SPOILER ATTACHMENT HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA060403Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060402Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 372, STR 8L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060350Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RH HORIZONTAL STAB LOWER SKIN CRACKED AT AFT SPAR ATTACH POINT. REPAIRED HORIZONTAL STAB PER SRM.SDR SWAA060261Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA060247Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 914 TO BS 919, STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060246Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 860, STR 25L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060245Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 833, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060244Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA060173Fastener · missingDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE COVER ATTACH BRACKET MISSING FASTENER. INSTALLED FASTENER PER MM.SDR SWAA060172Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA060171Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA060170Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060169Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT NR 2 RADIO ALTIMETER ANTENNA CUTOUT, BS 410, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA060119Outflow Valve · faultyAIR TURNBACK, CABIN ALTITUDE HORN SOUNDED. REMOVED AND REPLACED CABIN PRESSURE CONTROLLER AND MAIN OUTFLOW VALVE PER MM. RESECURED AFT CARGO DOOR SEAL PER MM.SDR SWAA060104Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500B, STR 19L & STR 19R. REPAIRED BELTFRAME PER SWA EA'S.SDR SWAA060106Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EEPLS FWD & AFT ENDS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA060093Battery Pack · inoperativeDURING SCHEDULED RON CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK IAW MM.SDR SWAA060068Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA060041Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED PRESSURE WEB CRACKED BETWEEN BS 663 TO BS 665, LBL 43. REPAIRED WEB PER SWA EA.
Back to Boeing 737-3Q8