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 SWAA082145Lens · crackedLT OVERWING EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA082030Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 501C, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA082031Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA081937Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081879Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 766, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA081877Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 737E, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA081555Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081536Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081468Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA081396Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA081303Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA081149Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 410 AND BS 430, BL 0. REPAIRED SKIN PER EA.SDR SWAA080903Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA080751Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA080752Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 27L CORRODED AT BS 503 TO BS 512B. REPAIRED STRINGER PER SRM.SDR SWAA080763Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA080731Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080705Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080704Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.SDR USAA920080339Door Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - NR 6076267, CRACKED L2 DOOR AFT FRAME, BS 342 AT BEAM 12. REPAIRED THE L2 DOOR AFT FRAME, BS 342, AT BEAM 12 IAW USAIRWAYS EA 100225.SDR USAA920080338Web · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED L2 DOOR INNER WEB, BS 342 AT THE NR 6 AFT STOP. REPAIRED THE L2 DOOR INNER WEB, BS 342, AT THE NR 6 AFT STOP IAW USAIRWAYS EA 100225.SDR SWAA080612Fire Loop · faultyAIR TURNBACK - MLG WHEEL WELL FIRE LIGHT ILLUMINATED DURING CLIMBOUT OF BWI. REMOVED AND REPLACED FIRE LOOP PER MM.SDR SWAA080604Lens · missingL1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR USAA920080301Channel · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED MAIN CABIN FLOOR CHANNEL, BS 540, BL 0, WL 208. REPAIRED CRACKED MAIN CABIN FLOOR CHANNEL, BS 540, BL 0, IAW B737 SRM 51-40-04-0G FIGURE 2.SDR USAA920080300Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - STRINGER TIE CLIP, BS 787, S9R. REPAIRED STRINGER TIE CLIP, BS 787, S9R, IAW BOEING 737 SRM 51-40-02-0G FIGURE 8, 12, 13 & 14.SDR USAA920080298Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME UPPER CHORD, BS 663.75, S3L, S1, S2R, S3R. REPAIRED FRAME UPPER CHORD, BS 663.75, S3L, S1, S2R, S3R, IAW B737 SRM 53-00-07-2R9 FIGURE 201.SDR USAA920080305Skin · debondedMCN - MAJOR REPAIR - C18 CHECK, LEFT WING OUTBOARD FORE FLAP, UPPER SURFACE HAS AREA OF DISBOND, WS 289 - WS 295. REPAIRED LEFT WING OUTBOARD FORE FLAP, UPPER SURFACE, WS 289 - WS 295 IAW B737 SRM 51-70-10-2R3.SDR USAA920080251Skin · delaminatedMCN - MAJOR REPAIR - C18 CHECK - LEFT WING INBOARD FORE FLAP LOWER SURFACE HAS DELAMINATION, WBL 125 - WBL 127. REPAIRED LEFT WING INBOARD FORE FLAP LOWER SURFACE, WBL 125 - WBL 127 IAW B737 SRM 51-70-10-2R4.SDR USAA920080303Angle · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON FORWARD CARGO COMPARTMENT DOOR CUT OUT ANGLE, BS 492.4, S25R - S26R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT ANGLE, BS 492.4, S25R - S26R IAW BOEING DRAWING 65-20726.SDR USAA920080227Reveal · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED R1 DOOR CUTOUT REVEAL, BS 305, S7R. REPLACED R1 DOOR CUTOUT REVEAL, BS 305, S7R IAW B737 SRM 51-40-02.SDR USAA920080336Gate · crackedMCN - MAJOR REPAIR - C18 CHECK - NR 6071109, L1 DOOR BOTTOM GATE PUSH ROD CENTER LUG CRACKED. REPLACED L1 DOOR LOWER GATE IAW B737 SRM 52-11-51.SDR USAA920080302Support Angle · corrodedC18 CHECK, CORROSION ON THE R1 DOOR CREASEBEAM SUPPORT ANGLE, BS 312 - BS 328, S17R. REPLACED THE R1 DOOR CREASE BEAM SUPPORT ANGLE, BS 312 - BS 328, S17R IAW BOEING DRAWING 65-45875.SDR USAA920080250Skin · delaminatedMCN - MAJOR REPAIR - C18 CHECK - RIGHT WING INBOARD MID FLAP LOWER SURFACE HAS AREA OF DELAMINATION, WBL 73 - WBL 75. REPAIRED RIGHT WING INBOARD MID FLAP LOWER SURFACE, WBL 73 - WBL 75 IAW B737 SRM 57-70-10-2R4.
SDR USAA920080222Angle · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON R1 DOOR CUTOUT LOWER SILL ANGLE, BS 294.5 - BS 312, S17R, WL 208. REPLACED R1 DOOR CUTOUT LOWER SILL ANGLE, BS 294.5 - BS 312, S17R, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080223Sill · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON R1 DOOR CUTOUT LOWER SILL WEB, BS 291 - BS 332, RBL 54, WL 208. REPLACED R1 DOOR CUTOUT LOWER SILL WEB, BS 291 - BS 332, RBL 54, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080304Crease Beam · corrodedC18 CHECK, CORROSION/CRACK ON THE R1 DOOR CREASEBEAM ANGLE, BS 289 - BS 298, S17R. REPLACED THE R1 DOOR CREASE BEAM ANGLE, BS 289 - BS 298, S17R IAW BOEING DRAWING 65-45875.SDR USAA920080224Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 294.5, S10R. REPLACED FRAME, BS 294.5, S10R IAW B737 SRM 51-40-02.SDR USAA920080221Strap · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON R1 DOOR CUTOUT LOWER SILL STRAP, BS 277 - BS 294.5, S17R, WL 208. REPLACED R1 DOOR CUTOUT LOWER SILL STRAP, BS 277 - BS 294.5, S17R, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080212Web · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT INTERCOSTAL WEB, BS 294.5, S11L. REPLACED L1 DOOR CUTOUT INTERCOSTAL WEB, BS 294.5, S11L IAW B737 SRM 51-40-02.SDR USAA920080211Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER CLIP, BS 663, S10L. REPLACED STRINGER CLIP, BS 663, S10L IAW B737 SRM 51-40-02.SDR USAA920080210Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER CLIP, BS 663, S10R. REPLACED STRINGER CLIP, BS 663, S10R IAW B737 SRM 51-40-02.SDR USAA920080209Angle · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED MAIN CABIN FLOOR STRUCTURE SHEAR WEB ANGLE, BS 380- BS 400, BL 0, WL 208. REPLACED MAIN CABIN FLOOR STRUCTURE SHEAR WEB ANGLE, BS 380- BS 400, BL 0, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080381Stringer · crackedMCN - MAJOR REPAIR - C18 CHECK - NR 6060939, CRACKED STRINGER, BS 500C S16R. REPAIRED STRINGER, BS 500C, S16R IAW USAIRWAYS ER 03-5312-01094-DD1.SDR USAA920080226Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 639, S2R. REPLACED STRINGER TIE CLIP, BS 639, S2R IAW B737 SRM 51-40-02.SDR USAA920080225Fitting · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED CLIP, BS 360, S13L. REPLACED CLIP, BS 360, S13L IAW B737 SRM 51-40-02.SDR USAA920080220Shear Web · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR WEB, BS 578 - BS 597, LBL 70, WL 208. REPLACED SHEAR WEB, BS 578 - BS 597, LBL 70, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080219Fitting · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S11L. REPLACED L1 DOOR CUTOUT INTERCOSTAL CLIP, BS 360, S11L IAW B737 SRM 51-40-02.SDR USAA920080218Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER CLIP, BS 639, S1. REPLACED STRINGER CLIP, BS 639, S1 IAW B737 SRM 51-40-02.SDR USAA920080208Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED STRINGER CLIP, BS 639, S2L. REPLACED STRINGER CLIP, BS 639, S2L IAW B737 SRM 51-40-02.SDR USAA920080207Strap · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKED L1 DOOR CUTOUT LOWER SILL WEB STRAP, BS 312 - BS 328, LBL 45.6, WL 208. REPLACED L1 DOOR CUTOUT LOWER SILL WEB STRAP, BS 312 - BS 328, LBL 45.6, WL 208 IAW B737 SRM 51-40-02.
Back to Boeing 737-3Y0