Boeing 737-3G7
Service difficulty reports · 5,850
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 = '7373G7' 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 = '7373G7' 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 USAA920080522Bulkhead · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED WEB, BS 178, RBL 5.7, WL 186. REPAIRED WEB, BS 178, RBL 5.7, WL 186 IAW B737 SRM 53-10-08-2R12.SDR USAA920080413Skin · crackedPHX - MAJOR REPAIR - CRACKED FUSELAGE SKIN CRACKED, BS 930, S25R. REPAIRED FUSELAGE SKIN, BS 930, S25R IAW B737 SRM 53-00-01-2R.SDR SWAA080797Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA080796Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR USAA920080557Stiffener · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON BULKHEAD STIFFENER CHANNEL, BS 1016, BL 0. REPAIRED BULKHEAD STIFFENER CHANNEL, BS 1016, BL 0 IAW B737 SRM 51-70-11.SDR USAA920080472Stringer Clip · crackedMCN - CRACKED STRINGER TIE CLIP, BS 344, S10R. REPLACED STRINGER TIE CLIP, BS 344, S10R IAW B737 SRM 51-40-02.SDR USAA920080471Skin · debondedMCN - MAJOR REPAIR - C18 CHECK - RIGHT WING NR 5 SPOILER UPPER SURFACE HAS AREA OF DISBOND, WS 123 - WS 128. REPAIRED RIGHT WING NR 5 SPOILER UPPER SURFACE, WS 123 - WS 128 IAW B737 SRM 51-70-02.SDR SWAA080764Skin · damagedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR OUTER SKIN CREASED. REMOVED AND REPLACED SKIN PER SRM.SDR USAA920080617Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 616, S8R. REPLACED STRINGER TIE CLIP, BS 616, S8R IAW B737 SRM 51-40-02.SDR USAA920080616Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 727C, S4R. REPLACED STRINGER TIE CLIP, BS 727C, S4R IAW B737 SRM 51-40-02.SDR USAA920080475Cusp Web · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON MAIN CABIN FLOOR CUSP WEB, BS 460 - BS 480, S17R, WL 208. REPLACED MAIN CABIN FLOOR CUSP WEB, BS 460 - BS 480, S17R, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080474Cusp Web · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON MAIN CABIN FLOOR CUSP WEB, BS 800 - BS 827, S17L, WL 208. REPLACED MAIN CABIN FLOOR CUSP WEB, BS 800 - BS 827, S17L, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080530Skin · debondedMCN - MAJOR REPAIR - C18 CHECK - LEFT WING NR 4 SPOILER HAS AREA DEBONDED, WBL 169.05 - WBL 180.75. REPAIRED LEFT WING NR 4 SPOILER, WBL 169.05 - WBL 180.75 IAW B737 SRM 51-70-10-2R4.SDR USAA920080476Skin · debondedMCN - MAJOR REPAIR - C18 CHECK - LEFT WING INBOARD FORE FLAP LOWER SURFACE HAS AREA DEBONDED, WBL 175 - WBL 178. REPAIRED AREA OF DISBOND LEFT WING INBOARD FORE FLAP LOWER SURFACE, WBL 175 - WBL 178 IAW B737 SRM 51-70-10.SDR USAA920080473Intercostal · crackedMCN - MAJOR REPAIR - CRACKED INTERCOSTAL ANGLE, BS 927 - BS 947, BL 0, WL 208. REPLACED INTERCOSTAL ANGLE, BS 927 - BS 947, BL 0, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080618Intercostal · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL, BS 294.5, S7L. REPLACED INTERCOSTAL, BS 294.5, S7L IAW B737 SRM 51-40-02.SDR USAA920080549Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 907, S9L AND S9R. REPAIRED FRAME BS 907, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080546Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S9L AND S9R. REPAIRED FRAME BS 827, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080545Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 440, S9L AND S9R. REPAIRED FRAME BS 440, S9L AND S9R IAW USAIRWAYS EA 100286.
SDR USAA920080543Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 380, S9R. REPAIRED FRAME BS, 380, S9R IAW USAIRWAYS EA 100286.SDR USAA920080542Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 360, S9L. REPAIRED FRAME BS, 360, S9L IAW USAIRWAYS EA 100286.SDR USAA920080528Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663.75, S3L - S3R. REPAIRED FRAME, BS 663.75, S3L - S3R IAW B737 SRM 53-00-07-2R9.SDR USAA920080495Channel · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED CHANNEL, BS 540, RBL 2.2, WL 208. REPLACED CHANNEL, BS 540, RBL 2.2, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080477Web · crackedMCN - MAJOR REPAIR - C18 CHECK - AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL VERTICAL WEB CRACKED, BS 818, S26R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL VERTICAL WEB, BS 818, S26R IAW B737 SRM 51-40-02.SDR USAA920080443Attach Fitting · crackedMCN - MAJOR REPAIR - CRACKED R1 DOOR CUTOUT INTERCOSTAL ATTACH CLIP, BS 332.1, S8R. REPLACED R1 DOOR CUTOUT INTERCOSTAL ATTACH CLIP, BS 332.1, S8R IAW B737 SRM 51-40-02.SDR USAA920080442Floorbeam · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED CABIN FLOOR SUPPORT CRACKED, BS 540, LBL 2.5. REPLACED CABIN FLOOR SUPPORT, BS 540, LBL 2.5 IAW B737 SRM 51-40-04.SDR USAA920080444Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 360 AND S5L. REPLACED STRINGER TIE CLIP, BS 360 AND S5L IAW B737 SRM 51-40-02.SDR USAA920080607Skin · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FUSELAGE SKIN, BS 727E, S24R. REPAIRED FUSELAGE SKIN, BS 727E, S24R IAW B737 SRM 53-00-01-2R31.SDR USAA920080558Web · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED L1 DOOR INNER WEB, BS 347, S14L - S15L. REPAIRED L1 DOOR INNER WEB, BS 347, S14L - S15L IAW USAIRWAYS EA 100247.SDR USAA920080386Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - NR I2D52004/2, AFT CARGO DOOR FORWARD FRAME CRACKED. REPLACED AFT CARGO DOOR IAW B737 SRM 52-31-00.SDR SWAA080672Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA080673Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RIGHT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR USAA920080342Skin · crackedPHX - MAJOR REPAIR - DAILY CHECK - NR 7884884, CRACKED FUSELAGE SKIN, BS 967, S21L. REPAIRED FUSELAGE SKIN, BS 967, S21L IAW USAIRWAYS EA 120566.SDR SWAA080605Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RIGHT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080582Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080583Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080541Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR USAA920080299Uplock Sensor · out of adjustPHX - DEN - ATB - FLT 490 - DURING CLIMB CREW SELECTED GEAR UP. RED RIGHT MAIN LANDING GEAR LIGHT REMAINED ILLUMINATED. PER QRH CREW SELECTED GEAR DOWN. THREE GREEN GEAR DOWN LIGHTS ILLUMINATED. CREW DECLARED AN EMERGENCY AND CABIN WAS PREPPED. THE CREW RSDR USAA920080273Skin · crackedPHX - MAJOR REPAIR - OVERNIGHT - CRACKED FUSLAGE SKIN, BS 676, S19R. REPAIRED FUSELAGE SKIN, BS 676, S19R IAW B737 SRM 53-00-01-2R.SDR SWAA080463Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA080467Charger · inoperativeDURING SCHEDULED BRDG CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER AND DIODES PER MM.SDR SWAA080466Bolt · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT MLG BOTTLE BOLT CORRODED. REMOVED AND REPLACED BOTTLE BOLT PER MM.SDR SWAA080465Bolt · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT MLG BOTTLE BOLT CORRODED. REMOVED AND REPLACED BOTTLE BOLT PER MM.SDR SWAA080464Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM.SDR USAA920080344Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - NR 03-0553-8-0315/4, AFT CARGO COMPARTMENT DOOR CUT OUT AFT FRAME CRACKED, BS 847. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT AFT FRAME, BS 847 IAW B737 SRM 51-40-00.SDR USAA920080242Tie Clip · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED TIE CLIP, BS 727D, S26L. REPLACED TIE CLIP, BS 727D, S26L IAW B737 SRM 51-40-02.SDR SWAA080432Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080429Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 18L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR USAA920080243Bulkhead · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED WEB, BS 178, LBL 5.7, WL 207.5. REPAIRED WEB, BS 178, LBL 5.7, WL 207.5 IAW B737 SRM 51-70-13.SDR SWAA080400Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to Boeing 737-3G7