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 USAA920070917Intercostal · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5976405, CRACKED AFT PRESSURE BULKHEAD INTERCOSTAL WEB, BS 1016, LBL 26.38 - LBL 45, WL 208.1. REPLACED AFT PRESSURE BULKHEAD INTERCOSTAL WEB, BS 1016, LBL 26.38 - LBL 45, WL 208.1 IAW B737-300 SRM 51-40-02.SDR USAA920070892Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505163, CRACKED STRINGER CLIP, BS 947, S26R. REPLACED STRINGER CLIP, BS 947, S26R IAW B737-300 SRM 51-40-02.SDR USAA920070895Attach Angle · corrodedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504936, CORROSION ON CUSP WEB TO CREASE BEAM ATTACH ANGLE, BS 807 - BS 827, S17L. REPLACED CUSP WEB TO CREASE BEAM ATTACH ANGLE, BS 807 - BS 827, S17L IAW B737-300 SRM 51-40-02.SDR USAA920070893Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505095, CRACKED STRINGER CLIP, BS 344, S11R. REPLACED STRINGER CLIP, BS 344, S11R IAW B737-300 SRM 51-40-02.SDR USAA920070869Floor Support · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505166, CRACKED FLOOR SUPPORT CHANNEL, BS 537, BL 0 - RBL 25, WL 208.1. REPLACED FLOOR SUPPORT CHANNEL, BS 537, BL 0 - RBL 25, WL 208.1 IAW B737-300 AMM 20-50-11.SDR USAA920070868Stringer Splice · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504930, CRACKED STRINGER SPLICE, BS 360, S4L. REPLACED STRINGER SPLICE CHANNEL, BS 360, S4L IAW B737-300 SRM 51-40-02.SDR USAA920070867Stringer Splice · crackedMCN - MAJOR REPAIR - C-18 CHECK - NON-ROUTINE 6504931, CRACKED STRINGER SPLICE, BS 907, S4L. REPLACED STRINGER SPLICE CHANNEL, BS 907, S4L IAW BOEING 737-300 SRM 51-40-02.SDR USAA920070860Intercostal · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505178, CRACKED INTERCOSTAL BS 303.9, S10L. REPLACED INTERCOSTAL, BS 303.9, S10L IAW B737-300 SRM 51-40-02.SDR USAA920070853Gusset · crackedPHX - MAJOR REPAIR - NR 4163756, PILOTS NR 1 WINDOW FRAME GUSSET CRACKED, BS 196.5 - BS 203.8, S9L - S10L. REPAIRED PILOTS NR 1 WINDOW FRAME GUSSET, BS 196.5 - BS 203.8, S9L - S10L IAW B737-300 SRM 53-10-01-2R REPAIR 10, FIGURE 201.SDR USAA920070859Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505198, CRACKED STRINGER CLIP, BS 663.75, S10R. REPLACED STRINGER CLIP, BS 663.75, S10R IAW B737-300 SRM 51-40-02.SDR USAA920070894Stringer Clip · corrodedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505244, CORROSION ON FLOORBEAM VERTICAL CLIP, BS 1016, LBL 41.0, WL 208.1. REPLACED FLOORBEAM VERTICAL CLIP, BS 1016, LBL 41.0, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200701131Windshield · crackedPHX - EL - LOG 7816283 - DURING CLIMB-OUT, THE FO'S WINDSHIELD OUTER PANE CRACKED. THE CREW RETURNED TO PHX. THE LANDING WAS UNEVENTFUL. MX REPLACED THE FO'S WINDSHIELD. OPERATIONAL/LEAK CHECK WAS GOOD.SDR USAA920070874Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505181, CRACKED STRINGER CLIP, BS 294.5, S9L. REPLACED STRINGER CLIP, BS 294.5, S9L IAW B737-300 SRM 51-40-02.SDR SWAA074711Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074659Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR AWXA200701112Flashlight · failedPHX - EEL - 8813229 - MX REPORTED FWD F/A VERTICALLY MOUNTED EMERGENCY FLASHLIGHT NOT CHARGING. MX REPLACED THE FORWARD F/A FLASHLIGHT. OPERATIONAL CHECK WAS GOOD.SDR USAA920070916Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504500, CRACKED FUSELAGE SKIN, BS 727D, S27L. REPAIRED FUSELAGE SKIN, BS 727D, S27L IAW B737 SRM 53-00-01-2R31, FIGURE 201.SDR SWAA074596Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 938, STR 23R. REPAIRED SKIN PER SRM.SDR AWXA200701074Skin · crackedPHX - MAJOR REPAIR - NR 4155161, FUSELAGE SKIN CRACKED BS 727, S22L. REPAIRED FUSELAGE SKIN, BS 727, S22L IAW B737-300 SRM 53-00-01-2R1 FIGURE 201.SDR SWAA074331Lens · missingFWD CABIN EMERGENCY EXIT SIGN MISSING LENS. INSTALLED LENS PER MM.SDR AWXA200701050Skin · delaminatedPIT - MAJOR REPAIR, TEAR AND DELAMINATION ON RIGHT WING LEADING EDGE SKIN, WS 538. REPAIRED RIGHT WING LEADING EDGE SKIN, WS 538 PER US AIRWAYS EA (ENGINEERING AUTHORIZATION).SDR AWXA200701029Flashlight · failedLAS - EEL - LOG NR 7824838 - FWD EMERGENCY FLASHLIGHT INOP. MX REPLACED FLASHLIGHT. OPERATIONAL CHECK WAS GOOD.SDR SWAA074176Hinge · crackedDURING SCHEDULED C2 CHECK, FOUND RIGHT WING NR 5 GROUND SPOILER OUTBOARD HINGE CRACKED. REMOVED AND REPLACED NR 5 SPOILER PER MM.SDR AWXA200701006Skin · crackedPHX - MAJOR REPAIR - LOG PAGE 7818967, CRACKED FUSELAGE SKIN, BS 727E, S23L, AFT OF EMERGENCY EXIT LIGHT. REPAIRED FUSELAGE SKIN, BS 727E, S23L, AFT OF EMERGENCY EXIT LIGHT IAW B737-300 SRM 53-00-01, FIGURE 201.SDR SWAA074108Logic Card · faultyRAISED LANDING GEAR LEVER ON CLIMBOUT AND HAD RED NLG INDICATION WITH NO OTHER LIGHTS ILLUMINATED. CYCLED GEAR, LIGHTS NORMAL. ADJUSTED NLG DOWNLOCK SENSOR, REMOVED AND REPLACED M983 LOGIC CARD PER MM.SDR AWXA200701079Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5988034, CRACKED FRAME, BS 807, S9R. REPAIRED FRAME, BS 807, S9R IAW USAIRWAYS EA 120228.SDR AWXA200701078Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5988035, CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW USAIRWAYS EA 120228.SDR AWXA200701057Strap · corrodedMCN - MAJOR REPAIR - C-18 CHECK - NR 5988011, CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL WEB INNER CHORD STRAP, BS 793 - BS 847, S25R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL WEB INNER CHORD STRAP, BS 793 - BS 847, S25R IAW B737SDR AWXA200701055Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5988022 & 5988023, FRAME CHORD CRACKED, BS 663.75, S3L AND S3R. REPAIRED FRAME CHORD, BS 663.75, S3L AND S3R IAW B737-300 SRM 53-00-07-2R9, FIGURE 201.SDR AWXA200701031Stringer · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5988018, CRACK FOUND ON FUSELAGE STRING S-10R, BS 277. REPAIRED FUSELAGE STRINGER S-10R, BS 277 IAW B737-300 SRM 53-00-03-2 R3 FIG 201.SDR AWXA200701018Floorbeam · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACK FOUND ON CABIN FLOOR SUPPORT CHANNEL ASSEMBLY, BS 540, LBL 25. REPLACED CABIN FLOOR SUPPORT CHANNEL ASSEMBLY, BS 540, LBL 25 IAW B737-300 SRM 51-40-04-0G, FIG 1.SDR SWAA074071Battery · faultyDURING SCHEDULED MV4 CHECK, FWD CABIN EMERGENCY EXIT LIGHTS STAY ILLUMINATED WITH SWITCH IN OFF POSITION. REMOVED AND REPLACED BATTERY PACK PER MM.SDR AWXA200701098Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987974, CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW USAIRWAYS EA 120228.SDR AWXA200701097Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987977, CRACKED FRAME, BS 907, S9L. REPAIRED FRAME, BS 907, S9L IAW USAIRWAYS EA 120228.SDR AWXA200701096Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987976, CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EA 120228.SDR AWXA200701083Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987975, CRACKED FRAME, BS 847, S9L. REPAIRED FRAME, BS 847, S9L IAW USAIRWAYS EA 120228.SDR AWXA200701082Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987972, CRACKED FRAME, BS 480, S9L. REPAIRED FRAME, BS 480, S9L IAW USAIRWAYS EA 120228.SDR AWXA200701081Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987969, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW USAIRWAYS EA 120228.SDR AWXA200701080Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987971, CRACKED FRAME, BS 887, S9R. REPAIRED FRAME, BS 887, S9R IAW USAIRWAYS EA 120228.SDR AWXA200701052Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987960, CRACKED STRINGER TIE CLIP, BS 277, S10R. REPLACED STRINGER TIE CLIP, S10R IAW B737-300 SRM 51-40-02.SDR AWXA200701027Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR#5987941, CRACK ON R1 DOOR SURROUND FORWARD UPPER STUB FRAME, BS 296, WL 265, RBL 50. REPLACED R1 DOOR SURROUND FORWARD UPPER STUB FRAME, BS 296, WL 265, RBL 50 IAW B737-300 SRM 51-40-02-0G PAR 4B, 7B, AND FIG 3, 8, 12.SDR AWXA200701020Shear Tie · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987943, CRACK FOUND ON R1 DOOR SURROUND SKIN ANGLE, BS 280 - BS290, S-13R. REPLACED R1 DOOR SURROUND SKIN ANGLE, BS 280 - BS290, S-13R IAW B737-300 SRM 51-40-02-0G, FIG 3, 8, AND FIG 12.SDR AWXA200701015Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987940, CRACK FOUND AT L1 DOOR SURROUND STRINGER CLIP, BS 360, S-11L. REPLACED L1 DOOR SURROUND STRINGER CLIP, BS 360, S-11L IAW B737-300 SRM 51-40-02-0G, FIG 8 AND FIG 12.SDR AWXA200701014Stringer Clip · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987939, CRACK FOUND AT L1 DOOR SURROUND STRINGER CLIP, BS 277, S-10L. REPLACED L1 DOOR SURROUND STRINGER CLIP, BS 277, S-10L IAW B737-300 SRM 51-40-02-0G, FIG 8 AND FIG 12.SDR AWXA200701111Channel · corrodedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987854, CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL CHANNEL, BS 847 - BS 867, S26R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT LOWER SILL CHANNEL, BS 847 - BS 867, S26R IAW B737-300 SRM 51-40-02.SDR AWXA200701092Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987852, FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME CRACKED, BS 492.3, S24R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT AFT FRAME, BS 492.3, S24R IAW USAIRWAYS EA 120222.SDR AWXA200701091Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987853, FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 440, S24R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R IAW USAIRWAYS EA 120223.SDR AWXA200701090Stringer · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987892, CRACKED STRINGER, BS 500D, S16L. REPAIRED STRINGER, BS 500D, S16L IAW AWA ER 03-5312-01094-DD1.SDR AWXA200701056Stringer · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987893, STRINGER CRACKED AT EXISTING REPAIR, BS 500C, S16L. REPAIRED STRINGER, BS 500C, S16L IAW AWA ER 03-5312-01094-DD1.SDR AWXA200701054Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987801, RIGHT WING NR 6 SLAT LOWER SURFACE HAS 3 CRACKS, SS 292 - SS 327. REPAIRED RIGHT WING NR 6 SLAT LOWER SURFACE, SS 292 - SS 327 IAW B737-300 SRM 57-43-01-2R6, FIGURE 201.
Back to Boeing 737-3G7