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 AWXA200601924Skin · crackedMCN - RIGHT WING NR 6 SLAT LOWER SURFACE SKIN HAS 10 CRACKS, SLAT STA 373-385. REPAIRED RIGHT WING NR 6 SLAT LOWER SURFACE SKIN HAS 10 CRACKS, SLAT STA 373-385 IAW B737-300 SRM 57-43-01.SDR AWXA200601923Skin · crackedMCN - LEFT WING NR 1 SLAT LOWER SURFACE SKIN HAS 4 CRACKS, SLAT STA 385-388. REPAIRED LEFT WING NR 1 SLAT LOWER SURFACE SKIN, SLAT STA 385-388 IAW B737-300 SRM 57-43-01.SDR AWXA200601922Skin · crackedMCN - RIGHT WING NR 6 SLAT LOWER SURFACE SKIN HAS 6 CRACKS, SLAT STA 296-310. REPAIRED RIGHT WING NR 6 SLAT LOWER SURFACE SKIN, SLAT STA 296-310 IAW B737-300 SRM 57-43-01.SDR AWXA200601914Strap · crackedMCN - MAJOR REPAIR - C-17 CHECK - E/E BAY FLOORBEAM STAB STRAP IS CRACKED, BS 315, LBL 12, WL 200. REPAIRED E/E BAY FLOORBEAM STAB STRAP, BS 315, LBL 12, WL 200 IAW B737-300 SRM 53-10-51 FIGURE 201.SDR AWXA200601913Strap · crackedMCN - MAJOR REPAIR - C-17 CHECK - E/E BAY FLOORBEAM STAB STRAP IS CRACKED, BS 315, LBL 3, WL 200. REPAIRED E/E BAY FLOORBEAM STAB STRAP, BS 315, LBL 3, WL 200 IAW B737-300 SRM 53-10-51 FIGURE 201.SDR AWXA200601859Skin · crackedMIA - SCRIBE MARK INSPECTION (AD 2006-07-12), FUSELAGE SKIN CUTOUT FOR GROUND AIR CONDITION ACCESS DOOR IS CRACKED AT FORWARD RIGHT CORNER, BS 522, S28R. REPAIRED FUSELAGE SKIN CUTOUT FOR GROUND AIR CONDITION ACCESS DOOR AT FORWARD RIGHT CORNER, BS 522, S28R SDR AWXA200601947Structure · debondedMCN - DEBOND AREA AT TRAILING EDGE OF RT INBOARD FOREFLAP, 4.5" FROM OUTBOARD END. REPLACED DEBOND AREA AT TRAILING EDGE OF RT INBOARD FOREFLAP 4.5" FROM OUTBOARD END IAW B737 SRM 51-70-10-2R, REPAIR 4, FIG 203.SDR AWXA200601912Strap · crackedMCN - MAJOR REPAIR - C-17 CHECK - E/E BAY FLOORBEAM STAB STRAP IS CRACKED, BS 331, LBL 12, WL 200. REPAIRED E/E BAY FLOORBEAM STAB STRAP, BS 331, LBL 12, WL 200 IAW B737-300 SRM 53-10-51 FIGURE 201.SDR AWXA200601882Floorbeam · corrodedMCN - MAJOR REPAIR - C-16 CHECK - CORROSION ON MAIN CABIN FLOORBEAM, BS 312, LBL 6 - RBL 12. REPAIRED MAIN CABIN FLOORBEAM, BS 312, LBL 6 - RBL 12 IAW B737-300 SRM 53-10-51 FIGURE 201.SDR AWXA200601877Intercostal · crackedMCN - MAJOR REPAIR - C-16 CHECK - INTERCOSTAL CRACKED, BS 324, LBL 40, WL 208. REPAIRED INTERCOSTAL, BS 324, LBL 40, WL 208 IAW B737-300 51-70-11 FIGURE 1.SDR SWAA064194Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 21L CRACKED AT BS 500B. REPAIRED STRINGER SECTION PER SRM.SDR SWAA064193Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 827, STR 17R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR AWXA200601917Connector · bentMCN - EEL - C-17 CHECK - AFT GALLEY EMERGENCY FLASH LIGHTS HAVE 1 WEAK BATTERY AND 1 BATTERY CONNECTOR BENT. REPLACED AFT GALLEY EMERGENCY FLASH LIGHT BATTERIES AS REQUIRED.SDR SWAA064170Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA064169Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR AWXA200601960Frame · crackedMCN - MAJOR REPAIR - FORWARD CARGO COMPARTMENT DOOR FORWARD FRAME CRACKED, BS 442, S20R. REPLACED FORWARD CARGO COMPARTMENT DOOR FORWARD FRAME, BS 442, S20R IAW B737-300 SRM 51-40-02.SDR AWXA200601870Attach Fitting · crackedMCN- MAJOR REPAIR - C-16 CHECK - AFT CARGO COMPARTMENT ATTACH CLIP CRACKED ON VERTICLE WEB, BS 772.6, RBL 24. REPLACED AFT CARGO COMPARTMENT ATTACH CLIP, BS 772.6, RBL 24 IAW B737-300 SRM 51-40-02-0G, FIGURES 3, 8 AND 13.SDR AWXA200601871Attach Fitting · crackedMCN - MAJOR REPAIR - C-16 CHECK - AFT CARGO COMPARTMENT ATTACH CLIP CRACKED, BS 787, RBL 24. REPLACED AFT CARGO COMPARTMENT ATTACH CLIP CRACKED, BS 787, RBL 24 IAW B737-300, SRM 51-40-02-0G, FIGURES 3 AND 8 AND BAC DRAWING 69-43934.SDR AWXA200601869Channel · crackedMCN - MAJOR REPAIR - C -16 CHECK - AFT CARGO COMPARTMENT SUPPORT CHANNEL CRACKED, BS 787-767, RBL 24. REPLACED AFT CARGO COMPARTMENT SUPPORT CHANNEL, BS 787-767, RBL 24 IAW B737-300 SRM 51-40-02-0G ,FIGURES 8 AND 12.SDR AWXA200601932Angle · crackedMCN - L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE CRACKED, BS 348 - BS 351, S16L. REPLACED L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE , BS 348 - BS 351, S16L IAW AWA ER 03-5312-06318-SS1.SDR AWXA200601931Angle · crackedMCN - L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE CRACKED, BS 348 - BS 350, S16L. REPLACED L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE , BS 348 - BS 350, S16L IAW AWA ER 03-5312-06318-SS1.SDR AWXA200601930Angle · crackedMCN - L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE CRACKED, BS 348 - BS 351, S16L. REPLACED L1 ENTRY DOOR SURROUND STRUCTURE CLIP ANGLE , BS 348 - BS 351, S16L IAW AWA ER 03-5312-06318-SS1.SDR SWAA064131Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR AWXA200601853Attach Angle · corrodedMAJOR REPAIR- C-16 CHECK - NR 5935066, CORROSION ON THE L2 DOOR CUT OUT SCUFF PLATE ATTACH ANGLE, BS 980, S17L. REPLACED THE L2 DOOR CUT OUT SCUFF PLATE ATTACH ANGLE, BS 980, S17L IAW SRM 51-40-02.SDR AWXA200601851Intercostal · crackedMAJOR REPAIR - C-16 CHECK - NR 5935073, CRACKED INTERCOSTAL, BS 344 - BS 360, BL 0, WL 208. REPAIRED CRACKED INTERCOSTAL, BS 344 - BS 360, BL 0, WL 208 IAW SRM 51-70-11.SDR SWAA064114Skin · crackedDURING SCHEDULED C3 CHECK, FOUND LT WING NR 1 L/E SLAT LOWER T/E SKIN CRACKED. REPAIRED SLAT PER SWA EA.SDR SWAA064113Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 25R. REPAIRED SKIN PER SWA EA.SDR AWXA200601860Floorbeam · crackedMCN - MAJOR REPAIR - C-16 CHECK - FLOORBEAM UPPER CHORD CRACKED, BS 294.5, LBL 55, WL 208. REPAIRED FLOORBEAM UPPER CHORD CRACKED, BS 294.5, LBL 55, WL 208 IAW B737-300 SRM 53-10-51, FIGURE 201.SDR SWAA064084Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 9L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064083Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064075Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR AWXA200601901Reveal · crackedMCN - MAJOR REPAIR - C-16 CHECK - R1 DOOR CUT OUT FORWARD UPPER CORNER REVEAL CRACKED, BS 300, RBL 56, WL 290. REPLACED R1 DOOR CUT OUT FORWARD UPPER CORNER REVEL, BS 300, RBL 56, WL 290 IAW B737-300 SRM 51-40-02.SDR AWXA200601868Floorbeam · crackedMCN - MAJOR REPAIR - C-16 CHECK - MAIN CABIN LONGITUDINAL FLOORBEAM TEE CAP CRACKED, BS 665, BL 0. REPAIRED MAIN CABIN LONGITUDINAL FLOORBEAM TEE CAP, BS 665, BL 0 IAW AWA ER 03-5300-06308-HF1.SDR AWXA200601855Sill · corrodedMAJOR REPAIR-C-16 CHECK - NR 5935591, CORROSION ON AFT CARGO COMPARTMENT DOOR CUTOUT VERTICAL SILL WEB, BS 804 - BS 840, S26R. REPLACED AFT CARGO COMPARTMENT DOOR CUTOUT VERTICAL SILL WEB, BS 804 - BS 840, S26R IAW SRM 51-40-02.SDR AWXA200601822Vertical Beam · crackedMCN - MAJOR REPAIR - C-16 CHECK - FOUND VERTICAL BEAM WEB CRACKED, BS 178, RBL 17.1, WL 185. REPAIRED VERTICAL BEAM WEB, BS 178, RBL 17.1, WL 185 IAW B737-300 SRM 53-10-08-2R12, FIGURE 201.SDR SWAA064048Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064047Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA064046Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR AWXA200601893Door Frame · crackedMCN - MAJOR REPAIR - R1 DOOR CUT OUT FORWARD FRAME CRACKED IN THE RADIUS, BS 298, RBL 57, WL 248. REPLACED R1 DOOR CUT OUT FORWARD FRAME, BS 298, RBL 57, WL 248 IAW B737-300 SRM 51-40-02.SDR AWXA200601858Floorbeam · corrodedMAJOR REPAIR-C-16 CHECK - NR 5935515, CORROSION ON MAIN CABIN FLOORBEAM, BS 986, LBL 55. REPAIRED MAIN CABIN FLOORBEAM, BS 986, LBL 55 IAW AWA ER 03-5311-06296-TH1.SDR AWXA200601852Door Frame · corrodedMAJOR REPAIR - C-16 CHECK - NR 5935507, CORROSION ON THE L1 DOOR CUT OUT INNER CHORD, BS 310 - BS 345, LBL 70, WL 208. REPLACED THE L1 DOOR CUT OUT INNER CHORD, BS 310 - BS 345, LBL 70, WL 208 IAW SRM 51-40-02.SDR AWXA200601824Crease Beam · corrodedMCN - MAJOR REPAIR - C-16 CHECK - FOUND CORROSION ON THE R1 DOOR CUT OUT LOWER SILL CREASE BEAM UPPER ANGLE, BS 300 - BS 330, S17R. REPLACED THE R1 DOOR CUT OUT LOWER SILL CREASE BEAM UPPER ANGLE, BS 300 - BS 330, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200601823Bulkhead · crackedMCN - MAJOR REPAIR - C-16 CHECK - FOUND VERTICAL BEAM WEB CRACKED, BS 178, LBL 17.1, WL 230. REPAIRED VERTICAL BEAM WEB, BS 178, LBL 17.1, WL 230 IAW B737-300 SRM 53-10-08-2R12, FIGURE 201.SDR AWXA200601806Angle · crackedMCN - ANGLE CRACKED, BS 291.5 - BS 294.5, S17R, RBL 55. REPLACED ANGLE, BS 291.5 - BS 294.5, S17R, RBL 55 IAW B737-300 SRM 51-40-02 FIGURE 12.SDR AWXA200601934Stringer · crackedMCN - L1 ENTRY DOOR SURROUND STRUCTURE STRINGER CRACKED, BS 294 - BS 303, S10L. REPLACED L1 ENTRY DOOR SURROUND STRUCTURE STRINGER CRACKED, BS 294 - BS 303, S10L IAW AWA ER 03-5312-06318-SS1.SDR AWXA200601933Intercostal · crackedMCN - L1 ENTRY DOOR SURROUND STRUCTURE INTERCOSTAL CRACKED, BS 294.5 - BS 303.9, S12L. REPLACED L1 ENTRY DOOR SURROUND STRUCTURE INTERCOSTAL , BS 294.5 - BS 303.9, S12L IAW AWA ER 03-5312-06318-SS1.SDR AWXA200601916Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK - CRACKED FRAME, BS 440, S24R. REPAIRED FRAME, BS 440, S24R IAW AWA ER 03-5332-06310-SS4.SDR AWXA200601915Frame · crackedMC - MAJOR REPAIR - C-16 CHECK - CRACKED FRAME, BS 663.75, S2L - S3L. REPAIRED FRAME, BS 663.75, S2L - S3L IAW B737-300 SRM 53-00-07 FIGURE 201.SDR AWXA200601881Threshold · corrodedMCN - MAJOR REPAIR - C-16 CHECK - CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT THRESHOLD WEB, BS 807 - BS 840, S25R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT THRESHOLD WEB, BS 807 - BS 840, S25R IAW B737-300 SRM 51-41-02.SDR AWXA200601857Shear Web · corrodedMAJOR REPAIR-C-16 CHECK - NR 5935406, CORROSION ON RT AFT LAV AND GALLEY AREA FLOOR SHEAR WEB, BS 1014 - BS 1016, RBL 40, WL 208. REPLACED RT AFT LAV AND GALLEY AREA FLOOR SHEAR WEB, BS 1014- BS 1016, RBL 40, WL 208 IAW SRM 51-40-02.
Back to Boeing 737-3G7