Boeing 737-3Y0
Service difficulty reports · 3,007
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 = '7373Y0' 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 = '7373Y0' 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 SWAA091284Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA091321Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 887, STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091177Lens · out of positionFWD EMERGENCY EXIT SIGN FELL OFF. SECURED LENS PER MM.SDR SWAA090799Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 907, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA090798Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090797Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 460, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090361Hinge Fitting · brokenDURING SCHEDULED CV CHECK, FOUND RT WING NR 5 GROUND SPOILER O/B HINGE CASTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA090360Slide · out of adjustDURING SCHEDULED CV CHECK, FOUND L1 DOOR EMERGENCY EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA090257Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 923, STR 21R. REPAIRED SKIN PER EA.SDR SWAA090256Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, BETWEEN STR 22R TO STR 23R. REPAIRED FRAME PER EA.SDR SWAA090255Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, BETWEEN STR 21L TO STR 22L. REPAIRED SKIN PER EA.SDR SWAA090244Battery Pack · dischargedDURING SCHEDULED 24Y CHECK, FOUND AFT CENTER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA090199Lens · brokenDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR OVERHEAD EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA090198Sign · brokenDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA090197Sign · brokenDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA090129Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING OTBD FORE FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA090128Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA090120Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING INBD L/E SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA090013Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE LOWER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA090012Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND E&E COMPARTMENT SKIN CRACKED BETWEEN BS 360 TO BS 380, BETWEEN STR. 28L TO STR 29R. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA090011Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA087341Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA087340Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING O/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA087319Frame · corrodedDURING SCHEDULED 24Y CHECK, FWD CARGO COMPT FRAME CORRODED AT BS 500, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA087318Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA087317Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA087145Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND E & E COMPARTMENT SKIN CRACKED BETWEEN BS 360 TO BS 380, STR 28R. REPAIRED SKIN PER SRM.SDR SWAA087141Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA087140Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND LT STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA087132Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND E & E COMPARTMENT SKIN CRACKED BETWEEN BS 360 TO BS 380, STR 28L. REPAIRED SKIN PER SRM.SDR SWAA087131Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086909Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA086739Slide · out of positionFOUND L1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA085898Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA085897Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA085896Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 15L. REPAIRED SKIN PER EA.SDR SWAA085611Light · brokenFOUND LT EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA085408Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 520, STRL 16R. REPAIRED PER SWA EA.SDR SWAA085361Sign · brokenDURING SCHEDULED 22Y CHECK, R2 EMERGENCY EXIT DOOR SIGN BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA085360Sign · missingDURING SCHEDULED 22Y CHECK, FOUND R1 EMERGENCY EXIT DOOR LIGHT SIGN MISSING. REMOVED AND REPLACED SIGN PER MM.SDR SWAA085290Glowstrip · crackedDURING SCHEDULED 22Y CHECK, FOUND PHOTOLUMINESCENT STRIP CRACKED BETWEEN BS 336 TO BS 947. REPLACED STRIP PER SWA DWG.SDR SWAA085256Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085255Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 769 19L TO BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085254Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 729E TO BS 739E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085233Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 360, STR 14L. REPAIRED STRINGER PER EA.SDR SWAA085161Skin · crackedDURING SCHEDULED C4 CHECK, FOUND R2 DOOR LOWER HINGE CUTOUT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA085143Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA085163Seal · tornEMERGENCY FLASHLIGHT SEAL TORN. REMOVED AND REPLACED SEAL PER MM.SDR SWAA085162Skin · crackedDURING SCHEDULED C4 CHECK, FOUND SKIN CRACKED AT STR 24L, STA 908 + 3. REPAIRED SKIN PER SRM.SDR SWAA085108Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 827, LBL 16 TO LBL 18. REPAIRED SHEAR TIE PER SRM.
Back to Boeing 737-3Y0