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 SWAA080047Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080048Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080049Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 410 AND BS 448, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA076383Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT KEEL BEAM CORRODED AT BS 523. REPAIRED KEEL BEAM PER SRM.SDR SWAA076347Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA076320Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076321Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076322Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076323Bearing · wornDURING SCHEDULED BRDG CHECK, RT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BEARING PER MM.SDR SWAA076324Bearing · wornDURING SCHEDULED BRDG CHECK, LT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BEARING PER MM.SDR SWAA076325Flap Track · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT WING NR 2 OUTBOARD FLAP INBOARD TRACK FITTING CORRODED. REPAIRED FLAP TRACK PER SWA EA.SDR SWAA076326Flap Track · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT WING NR 7 OUTBOARD FLAP INBOARD TRACK FITTING CORRODED. REPAIRED FLAP TRACK PER SWA EA.SDR SWAA076267Lamp · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076236Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076246Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND STUB FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA076245Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076090Gasper Fan · faultyON APPROACH CREW REPORTED AN ELECTRICAL ODOR IN CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA075986Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 981, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA075985Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA075984Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA075954Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA075953Bulkhead · crackedDURING SCHEDULED MV2 CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB PER SWA EA.SDR SWAA075827Hinge · brokenDURING SCHEDULED MV1 CHECK, FOUND LT WING NR 4 GROUND SPOILER INBOARD HINGE BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075726Skin · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075512Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 5 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075511Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 980, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA075347Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075200Battery · inoperativeDURING SCHEDULED MV1 CHECK, FOUND AFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA075143Lens · activatedDIVERSION, ELECTRICAL-RUBBER BURNING ODOR IN COCKPIT. INSPECTED AND FOUND F/O GRIMES LIGHT INTERNAL LENS MELTED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075065Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA075034Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075033Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND LEFT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075032Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND RIGHT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA074981Lens · missingBULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 20 ABC. INSTALLED LENS PER MM.SDR SWAA074886Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 375, STR 8L. REPAIRED SKIN PER SWA EA.SDR SWAA074845Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA074846Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA074826Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE BETWEEN ROW 5 ABC AND ROW 8 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA074788Mixing Valve · faultyAIRTURN BACK/DECLARED EMERGENCY. ON DESCENT TO DHN EXPERIENCED SMOKE IN FLIGHTDECK, NO SMOKE DETECTED IN LAV OR CABIN. SMOKE DISSIPATED, SOURCE OF SMOKE NOT DETERMINED. INSPECTED AIRCRAFT, REMOVED AND REPLACED RT MIX VALVE PER MM.SDR SWAA074702Wire · looseDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. FOUND UN-TERMINATED WIRE, RE-TERMINATED WIRE PER MM.SDR SWAA074686Light · brokenDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074688Skin · delaminatedDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 9 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA074687Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 910, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA074701Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA074703Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074710Lamp · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074651Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074672Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 745D AND BS 730E, STR 24L AND STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA074624Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 28R CORRODED AT BS 326. REPAIRED STRINGER PER SRM.SDR SWAA074630Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 516 AND BS 500D, STR 16L AND STR 15L. REPAIRED SKIN PER SWA EA.
Back to Boeing 737-3Q8