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 SWAA081241Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 500, RBL 4. REPAIRED SHEAR TIE PER SRM.SDR SWAA081242Beam · crackedDURING SCHEDULED BRDG CHECK, FOUND VERTICAL BEAM CRACKED AT BS 178, RBL 17, WL 182. REPAIRED BEAM PER SRM.SDR USAA920080608Skin · crackedCLT - MAJOR REPAIR - C17 CHECK - AFT CARGO DOOR SKIN CRACKED AT THE DOOR HANDLE CUTOUT. REPAIRED THE AFT CARGO DOOR SKIN IAW B737 SRM 52-00-01-2R2.SDR USAA920080559Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 727E, S9R. REPAIRED FRAME BS, 727E, S9R IAW USAIRWAYS EA 100286.SDR USAA920080556Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 400, S9L. REPAIRED FRAME BS, 400, S9L IAW USAIRWAYS EA 100286.SDR SWAA081218Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081216Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 440, RBL 70. REMOVED AND REPLACED WEB PER SWA EA.SDR SWAA081217Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 360, RBL 1. REPAIRED FLOORBEAM PER SRM.SDR USAA920080550Fuse · inoperativeFLT NR 298 - LAS-SEA - EEL - AFT CENTER EMERGENCY EXIT SIGN AND PATHWAY LIGHTS FROM LT ROWS 19-23 INOP. MAINTENANCE REPLACED THE POWER SUPPLY FUSES AND PINS 11/12 AND 13/14. EMERGENCY EXIT LIGHTING SYSTEM OPERATIONAL CHECK NORMAL.SDR USAA920080621Shear Tie · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED SHEAR TIE, BS 1088, S2R. REPLACED SHEAR TIE, BS 1088, S2R IAW B737 SRM 51-10-02.SDR USAA920080535Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 767, S9L. REPAIRED FRAME BS, 767, S9L IAW USAIRWAYS EA 100286.SDR SWAA081214Web · corrodedDURING SCHEDULED 20Y CHECK, FOUND NLG W/W CHORD CORRODED AT BS 247, RBL 16. REMOVED AND REPLACED CHORD PER SRM.SDR USAA920080540Frame · crackedMCN - MAJOR REPAIR - CRACKED FRAME, BS 887, S9L AND S9R. REPAIRED FRAME BS 887, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080539Frame · crackedMCN - CRACKED FRAME, BS 500C, S9L. REPAIRED FRAME BS, 500C, S9L IAW USAIRWAYS EA 100286.SDR USAA920080537Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME BS 480, S9L AND S9R IAW USAIRWAYS EA 100286.SDR USAA920080536Frame · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 747, S9L. REPAIRED FRAME BS, 747, S9L IAW USAIRWAYS EA 100286.SDR USAA920080520Skin · crackedPHX - MAJOR REPAIR - OVERNIGHT CHECK - CRACKED FUSELAGE SKIN, BS 727D - BS 727E, S23L. REPAIRED FUSELAGE SKIN, BS 727D - BS 727E, S23L IAW USAIRWAYS TYPICAL REPAIR 53-33.SDR USAA920080526Ground Stud · brokenPHX - EEL - FLT NR 640 - MX REPORTED LEFT EXTERIOR EMERGENCY LIGHT INOP. MX REPLACED THE BROKEN GROUNDING LUG IN AFT BAG PIT. OPERATIONAL CHECK WAS GOOD.SDR SWAA081133Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR USAA920080612Bulkhead · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED BULKHEAD WEB, BS 178, RBL 17, WL 230. REPLACED BULKHEAD WEB, BS 178, RBL 17, WL 230 IAW B737 SRM 53-10-08.SDR SWAA081118Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA081119Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 3 DOOR STOP. REMOVED AND REPLACED FRAME PER BOEING DRAWING.SDR USAA920080610Bulkhead · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED BULKHEAD VERTICAL BEAM WEB, BS 178, RBL 17, WL 228. REPLACED BULKHEAD VERTICAL BEAM WEB, BS 178, RBL 17, WL 228 IAW B737 SRM 51-20-01.SDR USAA920080609Bulkhead · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED BULKHEAD VERTICAL BEAM WEB, BS 178, RBL 17, WL 232. REPLACED BULKHEAD VERTICAL BEAM WEB, BS 178, RBL 17, WL 232 IAW B737 SRM 51-20-01.SDR USAA920080611Bulkhead · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED BULKHEAD WEB, BS 178, RBL 5.7, WL 180. REPAIRED BULKHEAD WEB, BS 178, RBL 5.7, WL 180 IAW B737 SRM 51-70-13 FIGURE 1.SDR USAA920080499Web · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON AFT PRESSURE BULKHEAD EXPANSION SEAL WEB, BS 1030 - BS 1034, LBL 24 - LBL 36, WL 210. REPLACED AFT PRESSURE BULKHEAD EXPANSION SEAL WEB, BS 1030 - BS 1034, LBL 24 - LBL 36, WL 210 IAW B737 SRM 51-40-02.SDR USAA920080493Web · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED WEB, BS 500D, BL0. REPLACED WEB, BS 500D, BL0 IAW B737 SRM 51-10-02.SDR USAA920080492Stringer Clip · crackedCLT - MAJOR REPAIR - C17 CHECK - CRACKED STRINGER TIE CLIP, BS 937, S25R. REPLACED STRINGER TIE CLIP, BS 937, S25R IAW B737 SRM 51-10-02.SDR USAA920080447Skin · crackedPHX - MAJOR REPAIR - OVERNIGHT CHECK - CRACKED FUSELAGE SKIN, BS 847, S23L - S24L. REPAIRED FUSELAGE SKIN, BS 847, S23L - S24L IAW B737 SRM 53-00-01 REPAIR 31.SDR SWAA080878Support Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG WALKING BEAM SUPPORT FITTING LUG CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA080877Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080876Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 AND BS 380, RBL 65. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080875Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME UPPER CRACKED. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA080905Charger · faultyEMERGENCY EXIT LIGHTS C/B OPENED INFLIGHT, C/B WOULD RESET. REMOVED AND REPLACED FWD CABIN BATTERY CHARGER PER MM.SDR SWAA080904Glowstrip · looseEEPLS PHOTOLUMINESCENT STRIP LOOSE AT ROW 1 DEF. SECURED STRIP PER MM.SDR USAA920080470Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 440, S9R. REPLACED STRINGER TIE CLIP, BS 440, S9R IAW B737 SRM 51-40-02.SDR USAA920080525Web · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR WEB, BS 1023 - BS 1040, BL 0 - RBL 38, WL 208. REPLACED SHEAR WEB, BS 1023 - BS 1040, BL 0 - RBL 38, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080496Stringer Clip · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER TIE CLIP, BS 927, S24R. REPLACED STRINGER TIE CLIP, BS 927, S24R IAW B737 SRM 51-40-02.SDR USAA920080498Web · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON AFT PRESSURE BULKHEAD EXPANSION SEAL WEB, BS 1038 - BS 1040, BL 0 - LBL 10, WL 210. REPLACED AFT PRESSURE BULKHEAD EXPANSION SEAL WEB, BS 1038 - BS 1040, BL 0 - LBL 10, WL 210 IAW B737 SRM 51-40-02.SDR USAA920080527Web · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR WEB, BS 1023 - BS 1040, BL 0 - LBL 38, WL 208. REPLACED SHEAR WEB, BS 1023 - BS 1040, BL 0 - LBL 38, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080497Intercostal · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL, BS 1034 - BS 1038, LBL 10 - LBL 24, WL 210. REPLACED INTERCOSTAL, BS 1034 - BS 1038, LBL 10 - LBL 24, WL 210 IAW B737 SRM 51-40-02.SDR USAA920080524Bulkhead · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED WEB, BS 178, RBL 17.1, WL 220. REPAIRED WEB, BS 178, RBL 17.1, WL 220 IAW B737 SRM 53-10-08-2R12.SDR USAA920080494Angle · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON ANGLE, BS 993, RBL 43. REPLACED ANGLE, BS 993, RBL 43 IAW B737 SRM 51-40-02.SDR USAA920080445Intercostal · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON INTERCOSTAL, BS 312 BS 328, S12R. REPLACED INTERCOSTAL, BS 312 BS 328, S12R IAW B737 SRM 51-40-02.SDR SWAA080820Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT AND LT HORIZONTAL STABILIZER FITTING CLEVIS LUG FACES CORRODED. REPAIRED FITTING PER SRM.SDR SWAA080819Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 19R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080818Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 505D AND BS 525. REPAIRED BEAM PER ER.SDR SWAA080814Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 AND BS 440, LBL 65. REMOVED AND REPLACED WEB PER SRM.SDR USAA920080529Bulkhead · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED BULKHEAD CHORD, BS 178, LBL 5.7, WL 184. REPAIRED BULKHEAD CHORD, BS 178, LBL 5.7, WL 184 IAW B737 SRM 53-10-03-2R5.SDR USAA920080523Bulkhead · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED WEB, BS 178, BL 0, WL 190. REPAIRED WEB, BS 178, BL 0, WL 190 IAW B737 SRM 53-10-08-2R12.
Back to Boeing 737-3G7