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 USAA920080167Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 787, S9R. REPAIRED FRAME, BS 787, S9R IAW USAIRWAYS EO 5311-01019.SDR USAA920080166Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 767, S9R. REPAIRED FRAME, BS 767, S9R IAW USAIRWAYS EO 5311-01019.SDR USAA920080165Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 480, S9R. REPAIRED FRAME, BS 480, S9R IAW USAIRWAYS EO 5311-01019.SDR USAA920080164Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 907, S9L. REPAIRED FRAME, BS 907, S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080163Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 887, S9L. REPAIRED FRAME, BS 887, S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080162Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080161Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080160Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 480, S9L. REPAIRED FRAME, BS 480, S9L IAW USAIRWAYS EO 5311-01019.SDR USAA920080159Frame · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED FRAME, BS 440, S9L. REPAIRED FRAME, BS 440, S9L IAW USAIRWAYS EO 5311-01019.SDR SWAA080094Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 336, STR 18L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA080093Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 320, STR 18L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA080095Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1042, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA080110Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 887, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080109Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 747, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA080035Hinge Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT HORIZONTAL STABILIZER CENTER SECTION HINGE FITTING CORRODED AT BEARING FACE. REPAIRED FITTING PER SWA EA.SDR SWAA080038Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA080037Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA.SDR USAA920080057Skin · delaminatedCLT - MAJOR REPAIR - C18 CHECK - RIGHT WING AILERON UPPER SURFACE HAS DELAMINATION. REPAIRED RIGHT WING AILERON UPPER SURFACE IAW USAIRWAYS EA 100087.SDR USAA920080109Floorbeam · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM, BS 665 - BS 669, LBL 24. REPAIRED FLOORBEAM, BS 665 - BS 669, LBL 24 IAW USAIRWAYS EA 100085.SDR USAA920080107Shear Tie · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR TIE, BS 616, S8L - S9L. REPLACED SHEAR TIE, BS 616, S8L - S9L IAW BOEING DRAWING 66-24124.SDR USAA920080058Slat · delaminatedCLT - MAJOR REPAIR - C18 CHECK - RIGHT WING NR 5 SLAT LOWER TRAILING EDGE HAS DELAMINATION. REPLACED RIGHT WING NR 5 SLAT IAW B737 AMM 27-81-21-004-001.SDR USAA920080008Fitting · crackedMCN - MAJOR REPAIR - C16 CHECK - RIGHT WING AFT GEAR SUPPORT FITTING CRACKED, RSS 224.14. REPAIRED RIGHT WING AFT GEAR SUPPORT FITTING, RSS 224.14 IAW USAIRWAYS EA 100091.SDR USAA920080007Skin · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FUSELAGE SKIN, BS 943 S24L. REPAIRED FUSELAGE SKIN, BS 943, S24L IAW USAIRWAYS EA 100084.SDR USAA920080006Pan · corrodedMCN - MAJOR REPAIR - C16 CHECK - CORROSION ON POTABLE WATER SERVICE PAN, BS 947 - BS 967, S24L - S24R. REPLACED POTABLE WATER SERVICE PAN, BS 947 - BS 967, S24L - S24R IAW B737 SRM 51-40-02.SDR SWAA076481Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA076482Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19R. REPAIRED SKIN PER SRM.SDR USAA920080123Stringer Splice · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER SPLICE BS 361, S4R. REPAIRED STRINGER SPLICE, BS 361, S4R IAW B737 SRM 51-10-02.
SDR USAA920080068Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL OUTER CHORD ANGLE, BS 291, S10R, WL 253. REPLACED INTERCOSTAL OUTER CHORD ANGLE, BS 291, S10R, WL 253 IAW B737 SRM 51-10-02.SDR USAA920080095Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 380, S8R. REPAIRED FRAME, BS 380, S8R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080094Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 480, S8L. REPAIRED FRAME, BS 480, S8L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080088Stringer Splice · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER SPLICE, BS 907, S4L. REPLACED STRINGER SPLICE, BS 907, S4L IAW B737 SRM 51-10-02.SDR USAA920080087Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 887, S9R. REPAIRED FRAME, BS 887, S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080085Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 787, S9R. REPAIRED FRAME, BS 787, S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080079Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 807, S9L. REPAIRED FRAME, BS 807, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080074Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 492, S21R. REPAIRED FRAME, BS 492, S21R IAW USAIRWAYS EA 100079.SDR SWAA076484Shear Tie · corrodedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500D, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR USAA920080099Attach Angle · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED ANGLE, BS 360, S16L. REPAIRED ANGLE, BS 360, S16L IAW B737 SRM 53-10-04-2R.SDR USAA920080055Skin · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FUSELAGE SKIN, BS 948, S14L - S15L. REPAIRED FUSELAGE SKIN, BS 948, S14L - S15L IAW B737 SRM 53-00-01-10.SDR USAA920080105Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME INNER CHORD, BS 312, S7R. REPLACED FRAME INNER CHORD, BS 312, S7R IAW B737 SRM 51-10-02.SDR USAA920080097Shear Tie · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR TIE, BS 360, S14R - S15R. REPLACED CRACKED SHEAR TIE, BS 360, S14R - S15R IAW B737 SRM 53-00-07 REPAIR 7.SDR USAA920080076Angle · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED WEB ANGLE, BS 303, S10L. REPLACED WEB ANGLE, BS 303, S10L IAW B737 SRM 51-10-01.SDR USAA920080066Floorbeam · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM, BS 328, LBL 12. REPLACED FLOORBEAM, BS 328, LBL 12 IAW B737 SRM 53-10-51-2R5.SDR USAA920080061Web · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED HORIZONTAL WEB, BS 727 - BS 727A, S18AL. REPLACED HORIZONTAL WEB, BS 727 - BS 727A, S18AL IAW USAIRWAYS EA 100057.SDR USAA920080005Bulkhead · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED VERTICAL BEAM WEB, BS 178, LBL 17, WL 224. REPAIRED VERTICAL BEAM WEB, BS 178, LBL 17, WL 224 IAW B737 SRM 53-10-08-2R12.SDR USAA920080004Bulkhead · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED VERTICAL BEAM WEB, BS 178, RBL 17, WL 224 - WL 234. REPAIRED VERTICAL BEAM WEB, BS 178, RBL 17, WL 224 - WL 234 IAW B737 SRM 53-10-08-2R12.SDR USAA920071360Door Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED AFT CARGO COMPARTMENT DOOR FRAME. REPLACED AFT CARGO DOOR IAW B737 AMM 52-31-00-4.SDR SWAA076382Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT VERTICAL STABILIZER AFT INBOARD FAIL SAFE FITTING CORRODED. REMOVED AND REPLACED FITTING PER SWA EA.SDR SWAA076381Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT VERTICAL STABILIZER AFT INBOARD FAIL SAFE FITTING CORRODED. REMOVED AND REPLACED FITTING PER SWA EA.SDR USAA920080098Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER CLIP, BS 500A, S16R. REPLACED STRINGER CLIP, BS 500A, S16R IAW B737 SRM 51-10-00.SDR USAA920080059Skin · delaminatedCLT - MAJOR REPAIR - C18 CHECK - LEFT WING INBOARD FORE FLAP LOWER SURFACE HAS DELAMINATION. REPAIRED LEFT WING INBOARD FORE FLAP LOWER SURFACE IAW B737 SRM 51-70-10.
Back to Boeing 737-3G7