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 SWAA081826Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA081783Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA081714Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 300, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA081623Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081626Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081624Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081622Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081621Lens · brokenDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA081625Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081560Battery Pack · faultyDURING SCHEDULED PM CHECK, FWD CABIN EMERGENCY EXIT LIGHTS REMAIN ON. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA081528Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 1006, STR 17R TO STR 19R. REPAIRED FRAME PER SRM.SDR SWAA081509Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE STUB FRAME CORRODED AT BS 312, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA081469Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 312, LBL 12 TO RBL 12. REPAIRED CHORD PER SRM.SDR SWAA081450Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081449Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081446Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 427, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA081447Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 405, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA081464Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA081458Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 867, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA081408Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081407Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 12 TO RBL 4. REPAIRED FLOORBEAM PER SRM.SDR SWAA081341Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081340Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081339Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081253Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081254Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA081240Lens · missingBULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 19 DEF. INSTALLED LENS PER MM.SDR SWAA080916Pressure Panel · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BEADED PRESSURE WEB CRACKED AT BS 664, LBL 40. REPAIRED WEB PER SRM.SDR SWAA080954Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 986, STR 27R. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA080790Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA080753Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080754Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080488Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 393, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA080489Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA080490Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 840, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA080491Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA080428Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080372Logic Card · faultyNLG RED LIGHT ILLUMINATED, CYCLED GEAR, LIGHT EXTINGUISHED. REMOVED AND REPLACED LOGIC CARD AND RELAY PER MM.SDR SWAA080341Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP AT ROW 8 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080339Skin · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA080340Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RIGHT WING NR 5 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA080279Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080168Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740, STR 22R. REPAIRED SKIN PER SWA EA.SDR SWAA080171Fitting · crackedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CRACKED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA080169Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 870, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA080167Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080170Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 884, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA080090Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 748D, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA080091Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA080092Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-3Q8