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 SWAA060032Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED BETWEEN BS 927 TO BS 947.5, RBL 13.8. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060023Lens · looseFWD CABIN BULLNOSE LENS LOOSE. SECURED LENS PER MM.SDR SWAA060021Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 4 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA060020Keelbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT KEEL BEAM LOWER CHORD CRACKED AT BS 542. REPAIRED KEEL BEAM PER SRM.SDR SWAA060019Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD FRAME NR 3 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA054172Strap · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BS 178 BULKHEAD VERTICAL STRAP CRACKED AT BL 0, WL 188. REPAIRED STRAP PER SWA EA.SDR SWAA054154Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 747, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054132Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 747, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA054131Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727B, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054130Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA054129Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT E/E COOLING EXHAUST OUTLET INTERNAL DOUBLER, BS 373 AND BS 378, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR SWAA054128Tee Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD UPPER T-CHORD CORRODED AT RBL 24.75. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA054127Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT BL 0, WL 189. REPAIRED WEB PER SRM.SDR SWAA054126Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 734, STR 27L. REPAIRED STRINGER PER SWA EA.SDR SWAA054125Bulb · inoperativeDURING SCHEDULED C4 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA054124Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING INBD T/E FOREFLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA054123Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA054073Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054072Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054071Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA054070Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND BEADED PRESSURE WEB CRACKED BETWEEN BS 663 TO BS 665, LBL 32. REPAIRED WEB PER SWA EA.SDR SWAA054069Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA054068Girt Bar · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FWD BRACKET CORRODED AT BS 312, LBL 56. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA054052Fan · faultySMOKE ODOR IN CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA054057Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W RIGHT FWD SIDE PRESSURE PANEL CRACKED AT BS 243.7, WL 168.5. REPAIRED WEB PER SWA EA.SDR SWAA054056Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W LEFT FWD SIDE PRESSURE PANEL CRACKED AT BS 240, WL 168.6. REPAIRED WEB PER SWA EA.SDR SWAA054055Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA054054Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, BETWEEN STR 20L TO STR 23L. REPAIRED SKIN PER SRM.SDR SWAA054053Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 12L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA054031Keelbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT KEEL BEAM CORRODED AT BS 727. REPAIRED KEEL BEAM PER SRM.SDR SWAA054030Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, BETWEEN STR 23L TO STR 24L. REPAIRED SKIN PER SRM.SDR SWAA054032Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 261, STR 9L. REPAIRED SKIN PER SWA EA.SDR SWAA054017Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA054016Floor Support · crackedDURING SCHEDULED D-CHECK, FOUND NR 3 LONGITUDINAL FLOORBEAM UPPER T-CHORD CRACKED AT BS 662, RBL 24.82. REPAIRED FLOORBEAM IAW EA.SDR SWAA054015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FLOOR BEAM CORRODED AT BS 986.5, RBL 45. REMOVED AND REPLACED FLOORBEAM UPPER T-CHORD IAW SRM.SDR SWAA053966Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 811 TO BS 814, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA053965Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732B TO BS 736B, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA053964Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 730B TO BS 733B, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA053924Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 905, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053897Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA053896Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 357, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA053895Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA053864Line · looseFUMES SMELL IN FWD GALLEY. FOUND HYDRAULIC FLUID LEAK AT LINE FWD OF RT AIR CYCLE MACHINE. TIGHTENED HYDRAULIC LINE PER MM.SDR SWAA053815Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA053776Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 883, STR 23R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053781Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA053780Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053779Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 735D, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA053778Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 472, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA053777Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, BS 455 AND BS 465, STR 4R. REPAIRED SKIN PER SRM.
Back to Boeing 737-3Q8