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 SWAA071849Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071696Sign · inoperativeL1 DOOR EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED EMERGENCY EXIT SIGN PER MM.SDR SWAA071647Slide · dislodgedR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA071643Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, LBL 23, WL 193. REPAIRED WEB PER BOEING SB AND SRM.SDR SWAA071599Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SRM & EA.SDR SWAA071585Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA071569Hook · brokenR2 DOOR EVACUATION SLIDE GIRT BAR FWD ATTACH HOOK BROKEN. REMOVED AND REPLACED R2 DOOR SLIDE COVER ASSY PER MM.SDR SWAA071551Skin · crackedFUSELAGE SKIN CRACKED AT BS 450, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA071517Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA071519Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071518Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 15R. REPAIRED FRAME PER ER AND BOEING SB.SDR SWAA071521Skin · delaminatedDURING SCHEDULED HC1 CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP UPPER OUTBOARD SURFACE DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA071520Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA071478Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA . CUT OUT BS 450, BL 0. REPAIRED SKIN PER ER.SDR SWAA071477Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA. CUTOUT BS 430, BL 0. REPAIRED SKIN PER ER.SDR SWAA071476Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA. CUT OUT BS 410, BL 0. REPAIRED SKIN PER ER.SDR SWAA071416Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071415Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071417Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA071434Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA071388Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 303.9, WL 259.88 NEXT TO L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA071391Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR LOWER FRAME CRACKED AT PULLEY BRACKET LOCATION. REMOVED AND REPLACED DOOR FRAME PER SRM & BAC DRAWING.SDR SWAA071390Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR UPPER FRAME CRACKED AT PULLEY BRACKET LOCATION. REMOVED AND REPLACED DOOR FRAME PER SRM & BAC DRAWING.SDR SWAA071392Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 65 TO RBL 65. REPAIRED FLOORBEAM PER ER.SDR SWAA071389Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 291, NEXT TO R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA071363Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LEFT KEEL BEAM CORRODED BETWEEN BS 500C & BS 510. REPAIRED KEEL BEAM PER SRM.SDR SWAA071365Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RIGHT CREASE BEAM CORRODED AT BS 948. REPAIRED CREASE BEAM PER SRM.SDR SWAA071364Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 996, LBL 65 TO RBL 65. REPAIRED FLOORBEAM PER ER.SDR SWAA071343Floor Support · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 707, LBL 25. REPAIRED FLOORBEAM PER BFG ER & SRM.SDR SWAA071342Floor Support · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 706 TO BS 712, BL 0. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA071316Bulb · inoperativeDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BULBS INOP. RELAMPED PER MM.SDR SWAA071317Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 251.5, STR 24L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA071232Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071231Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071233Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071230Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA071185Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 538, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA071182Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 277, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA071183Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA071184Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA071105Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA071102Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 762, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA071082Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA071068Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071067Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071066Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071065Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, LBL 28 TO RBL 57. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA071043Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 1006, LBL 41. REMOVED AND REPLACED FLOORBEAM WEB PER SRM.SDR SWAA071044Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 663, STR 2L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA071045Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1. REPAIRED FRAME PER SRM.
Back to Boeing 737-3Q8