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 SWAA096974Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA096970Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 4 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA096969Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA096973Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED PER MM.SDR SWAA096886Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA096885Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 COCKPIT WINDOW CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096946Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 765, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA096945Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 747, BETWEEN STR 8L TO STR 20L. REPAIRED SKIN PER SRM.SDR SWAA096944Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA096943Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 941.5, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA096942Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 745E, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA096941Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 739D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA096971Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND FWD OVERHEAD EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA096947Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM "T" CAP CRACKED AT BS 312 FWD LEG LOWER RADIUS CRACKED AT FASTENER HOLE. REMOVED AND REPLACED "T" CAP PER SRM.SDR SWAA096839Slat · crackedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 4 SLAT CRACKED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA096837Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 271.5, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA096376Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 937, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA096375Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 930, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA096350ASkin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 937, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA096349ASkin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 930, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA096415Torque Tube · damagedRT WING FLAP SHOWED 30 (LANDING SELECTION) LT WING FLAP SHOWED 25. FOUND TORQUE TUBE DAMAGED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA096389ATorque Tube · damagedRT WING FLAP SHOWED 30 (LANDING SELECTION) LT WING FLAP SHOWED 25. FOUND TORQUE TUBE DAMAGED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA096188Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM T-CAP CRACKED AT BS 312. REMOVED AND REPLACED T-CAP PER SRM.SDR SWAA095877Intercostal · crackedDURING SCHEDULED MV2 CHECK, FOUND LT BACKUP INTERCOSTAL CRACKED AT BS 333. REPAIRED INTERCOSTAL PER SWA EA.SDR SWAA095767Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT LOWER KEEL BEAM CORRODED AT BS 729. REPAIRED KEEL BEAM PER SRM.SDR SWAA095766Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095765Angle · corrodedDURING SCHEDULED SPV CHECK, FOUND LOWER BULKHEAD ANGLE CORRODED AT BS 727, BETWEEN STR 27L TO STR 27R. REPAIRED ANGLE PER SRM.SDR SWAA095691Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND LT WING NR 1 SLAT SKIN LOWER T/E CRACKED. REMOVED AND REPLACED SKIN PER MM.SDR SWAA095690Flap · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA095688Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095693Container · crackedDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE CONTAINER CRACKED. REPAIRED CONTAINER PER SRM.SDR SWAA095692Charger · inoperativeDURING SCHEDULED 2HC2 CHECK, FOUND AFT EMERGENCY EXIT LIGHT CHARGER INOP. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA095575Slide · low pressureL2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MT.SDR PIDA09037Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CAP OF FLOORBEAM 277 AT LBL 47. REPAIRED PER SRM 53-10-51 REPAIR 6.SDR PIDA09036Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 294.5 AT RBL 48. REPLACED FLOORBEAM T-CAP FROM RBL 59 TO LBL 59 PER SRM 53-10-51 REPAIR 5 AND SRM 51-40-02.SDR PIDA09035Shear Tie · corrodedDURING C-CHECK, FOUND RIVETS SHEARED ON SHEAR TIE AT STR 15LT AT BS 309. FOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER BAC DWG 50-07946 AND SRM 51-40-02.SDR PIDA09034Stringer Splice · crackedDURING C-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 359.2 FOR STR 14LT. REPLACED STRINGER SPLICE PER SRM 51-40-02.SDR SWAA095435Light · looseOVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT PER MM.SDR PIDA09033Fitting · crackedDURING C-CHECK, FOUND CLIP CRACKED AT BS 294.5 AT STR 13LT. REPLACED CLIP PER BAC DWG 65-17684 AND SRM 51-40-02.SDR PIDA09032Fitting · crackedDURING C-CHECK, FOUND CLIP CRACKED AT BS 294.5 AND STR 13LT. REPLACED CLIP PER BAC DWG 65-17684 AND SRM 51-40-02.SDR PIDA09031Strap · corrodedTIE STRAP AT BS 1016 IS CORRODED FROM RBL 2 TO LBL 2. REPLACED STRAP PER BAC DWG 65-46812 AND SRM 51-40-02.SDR SWAA095379Sign · missingRIGHT FWD OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR PIDA09030Stringer Splice · corrodedCORROSION ON STRINGER SPLICE BETWEEN BS 360 AND BS 380, STR 28RT. REPLACED STRINGER SPLICE PER SRM 51-40-02.SDR PIDA09029Support Angle · crackedDURING C CHECK, FOUND SUPPORT ANGLE FOR INTERCOSTAL WEB AT BS 290 JUST FORWARD OF THE R-1 DOOR CUTOUT BETWEEN STR 12RT AND 13RT CRACKED. REPLACED SUPPORT ANGLE PER BOEING DWG 65-45807 AND SRM 51-40-02.SDR PIDA09028Support Angle · crackedDURING C CHECK, FOUND SUPPORT ANGLE FOR INTERCOSTAL WEB AT BS 290 BETWEEN STR 11RT AND 12RT CRACKED. REPLACED SUPPORT ANGLE PER BOEING DWG 65-45807 AND SRM 51-40-02.SDR PIDA09027Support Angle · crackedDURING C CHECK, FOUND SUPPORT ANGLE FOR INTERCOSTAL WEB AT BS 290 BETWEEN STR 10RT AND 11RT, JUST FORWARD OF THE R-1 DOOR CUTOUT CRACKED. REPLACED ANGLE PER BAC DRAWING 65-45807 AND SRM 51-40-02.SDR PIDA09026Skin · damagedBELT LOADER DAMAGED FORWARD LOWER CARGO DOOR CUT-OUT FUSELAGE SKIN. REMAIRED DAMAGED AREA PER SRM 53-00-01, REPAIR 32.SDR PIDA09025Floorbeam · corrodedDURING C CHECK, FOUND CORROSION ON BS 727D FLOORBEAM AT LBL 3. REPAIRED FLOORBEAM IAW SRM 53-00-53.SDR PIDA09014Tie Clip · crackedDURING C CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 663.75 AND STR 11RT. REPLACED TIE CLIP IAW SRM 51-40-02.SDR PIDA09013Doubler · corrodedDURING C CHECK, FOUND CORROSION ON INNER SKIN DOUBLER AT BS 370 AT BL 0. REPLACED DOUBLER PER BAC DRAWING 65-45769 AND SRM 51-40-02.
Back to Boeing 737-3Y0