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 SWAA095457Lens · missingDURING SCHEDULED MV2 CHECK, FOUND OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 9. REMOVED AND REPLACED LENS PER MM.SDR SWAA095321Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA095266Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA095239Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA095365Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA095209Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE DOME BULKHEAD Y-CHORD CORRODED AT BS 1016, 6 O'CLOCK POSITION. REMOVED AND REPLACED BULKHEAD SECTION PER SRM.SDR SWAA095208Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD FWD SIDE CRACKED AT BS 1016, LBL 3. REPAIRED BULKHEAD PER BAC DWG.SDR SWAA095207Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095206Bulkhead · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD FWD SIDE CORRODED AT BS 1016, LBL 6. REPAIRED BULKHEAD PER BAC DWG.SDR SWAA095185Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 639, BETWEEN LBL 65 TO LBL 68. REPAIRED FRAME PER SWA EA.SDR SWAA095178Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR SIGN LIGHT INOP. RELAMPED PER MM.SDR SWAA095177Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA095176Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN FS 360 TO FS 380. REPAIRED WEB PER SRM.SDR SWAA095175Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME OUTER CHORD CRACKED AT BS 639, BETWEEN RBL 65 TO RBL 68. REPAIRED CHORD PER AAR EA.SDR SWAA095174Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND LT STUB BEAM CRACKED AT BS 639, LBL 63. REPAIRED BEAM PER AAR EA.SDR SWAA095173Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT HORIZONTAL STABILIZER UPPER SURFACE T/E BEAM CORRODED. REPAIRED STABILIZER PER SRM.SDR SWAA095172Slide · out of adjustDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA095171Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 827 TO BS 847. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095170Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, BETWEEN RBL 65 TO RBL 68. REPAIRED WEB PER EA.SDR SWAA095169Fitting · out of adjustDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING OUT OF ADJUST. REMOVED AND REPLACED FITTING PER MM.SDR SWAA095110Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA095107Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME STUB BEAM CRACKED AT BS 639, LBL 63. REPAIRED BEAM PER AAR EA.SDR SWAA095106Attach Angle · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPT WEB LOWER ATTACH ANGLE CORRODED AT BS 514, STR 26R. REPAIRED ANGLE PER BAC DWG.SDR SWAA095105Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 27L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095104Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 476, STR 28R. REPAIRED STRINGER PER SRM.SDR SWAA095103Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING MID FLAP L/E DELAMINATED. REPAIRED MID FLAP PER SRM.SDR SWAA095091Cover · crackedDURING SCHEDULED 24Y CHECK, FOUND LT OVERWING EMERGENCY EXIT SIGN COVER CRACKED. REMOVED AND REPLACED COVER PER MM.SDR SWAA095072Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA095071Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EXIT SIGN BULBS INOP. RELAMPED PER MM.SDR SWAA095025Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095018Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 616 TO BS 639. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095017Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 1016, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA095016Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095015Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095014Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 616, BETWEEN STR 7L TO STR 8L. REPAIRED FRAME PER SRM.SDR SWAA095013Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 639, STR 16L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA095070Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 446, STR 16L. REPAIRED SKIN PER EA.SDR SWAA095069Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 516B, STR 16L. REPAIRED SKIN PER EA.SDR SWAA095068Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 500 TO BS 513A, STR 16L. REPAIRED SKIN PER EA.SDR SWAA095012Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CORRODED AT BS 639, STR 16L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA095011Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095010Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CRACKED AT BS 620, RBL 63. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA095009Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 947.5, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA094931Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM CRACKED AT BS 639, STR 17L. REMOVED AND REPLACED BEAM SECTION PER SRM.SDR SWAA094930Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 827, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA094918Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094917Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094876Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094818Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094817Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 27L. REMOVED AND REPLACED CLIP PER SRM.
Back to Boeing 737-3Q8