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 AWXA200701025Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987890, CRACK ON FORWARD FUSELAGE FRAME, BS 380, S-16R. REPAIRED FORWARD FUSELAGE FRAME, BS 380, S-16R IAW B737-300 SRM 53-00-07-2R, REPAIR 8, FIG 201.SDR AWXA200701017Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987891, CRACK FOUND AT FUSELAGE FRAME, BS 360, S-14R - S-15R. REPAIRED FUSELAGE FRAME, BS 360, S-14R - S-15R IAW 737-300 SRM 53-00-07-2, REPAIR 7, FIG 201.SDR AWXA200701016Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987798, CRACKS FOUND ON NR 4 SLAT BOTTOM SKIN, SLAT STA 55 - SLAT STA 87. REPAIRED NR 4 SLAT BOTTOM SKIN, SLAT STA 55 - SLAT STA 87 IAW B737-300 SRM 57-43-01-2, REPAIR 6, FIG 201.SDR AWXA200701013Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - CRACKS FOUND ON NR 5 SLAT BOTTOM SKIN, SLAT STA 213 - SLAT STA 217. REPAIRED NR 5 SLAT BOTTOM SKIN SLAT STA 213 - SLAT STA 217 IAW B737-300 SRM 57-43-01-2, REPAIR 6.SDR SWAA074037Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074038Hinge Fitting · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE FITTING PER SWA EA.SDR AWXA200701094Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5983694, L1 DOOR AFT FRAME CRACKED, BEAM 12 - BEAM 13. REPAIRED L1 DOOR AFT FRAME, BEAM 12 - BEAM 13 IAW USAIRWAYS EA 120231.SDR AWXA200701093Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5983692, L1 DOOR INNER SKIN CRACKED, BEAM 12 - BEAM 13. REPAIRED L1 DOOR INNER SKIN, BEAM 12 - BEAM 13 IAW USAIRWAYS EA 120231.SDR AWXA200701026Attach Angle · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987942, CRACK ON R1 DOOR SURROUND ATTACH ANGLE, BS 294.5, S-17R. REPLACED R1 DOOR SURROUND ATTACH ANGLE, BS 294.5, S-17R IAW B737-300 SRM 51-40-02-0G, FIG 3, 8, AND 12.SDR AWXA200701053Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5987597, FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME CRACKED, BS 445, S25R - S26R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUT OUT FORWARD FRAME, BS 445, S25R - S26R IAW B737-300 SRM 51-40-02.SDR AWXA200700954Tab · delaminatedPHX - MAJOR REPAIR - NR 4109975, RIGHT WING AILERON TRIM TAB TRAILING EDGE IS DELAMINATED, WS 431.5. REPLACED RIGHT WING AILERON TRIM TAB TRAILING EDGE, WS 417 - WS 480 IAW AWA TASK CARD R3M27014.SDR SWAA073902Channel · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR FRAME UPPER U-CHANNEL CRACKED. REMOVED AND REPLACED U-CHANNEL PER SRM.SDR SWAA073877Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 413, LBL 3. REPAIRED SKIN PER SWA EA.SDR SWAA073730Lens · missingFWD CABIN EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR AWXA200700897Flashlight · failedPHX - EEL - LOG 4157208 - MX REPORTED FLASHLIGHT IN FWD GALLEY HAS A DEAD BATTERY. MX REPLACED THE FWD GALLEY FLASHLIGHT. OPERATIONAL CHECK WAS GOOD.SDR AWXA200700959Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982104, CRACKED STRINGER CLIP, BS 663, S4L. REPLACED STRINGER CLIP, BS 663, S4L IAW B737-300 SRM 51-40-02.SDR SWAA073608Light · brokenDURING SCHEDULED SERVICE CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA073609Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 2 ABC. INSTALLED LENS PER MM.SDR AWXA200700895Stiffener · crackedMCN - MAJOR REPAIR - C-20 CHECK - CORROSION ON FORWARD LAVATORY HOUSING HAT SECTION STIFFENER, BS 271, RBL 65, WL 183.0. REPLACED FORWARD LAVATORY HOUSING HAT SECTION STIFFENER, BS 271, RBL 65, WL 183.0 IAW B737-300 SRM 51-40-02.SDR AWXA200700876Skin · delaminatedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961981, LEFT WING MID FLAP OUTBOARD END DELAMINATED, WS 184.275, INSIDE PANEL 722D. REPAIRED LEFT WING MID FLAP OUT BOARD END, WS 184.275, INSIDE PANEL 722D IAW B737-300 SRM 51-70-10-2R4.SDR AWXA200700973Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962327, CRACKED FORWARD CARGO COMPARTENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R, WL 160. REPAIRED FORWARD CARGO COMPARTENT DOOR CUT OUT FORWARD FRAME, BS 440, S24R, WL 160 I/A/W USAIRWAYS EA 120139.SDR AWXA200700971Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962328, CRACKED FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME, BS 492, S24R, WL 160. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME, BS 492, S24R, WL 160 I/A/W USAIRWAYS EA 120120.SDR AWXA200700850Wedge · debondedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962306, RIGHT WING INBOARD MID FLAP TRAILING EDGE WEDGE LOWER SURFACE HAS AREA OF DISBOND, WS 161.5 - WS 167.5. REPAIRED RIGHT WING INBOARD MID FLAP TRAILING EDGE WEDGE LOWER SURFACE, WS 161.5 - WS 167.5 IAW B737-300 SRM SDR AWXA200700826Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR# 5962280, CRACKED STRINGER CLIP, BS 578, S4R. REPLACED STRINGER CLIP, BS 578, S4R IAW B737-300 SRM 51-40-02.SDR AWXA200700968Stiffener · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962210, CORROSION ON STIFFENER, BS 271, RBL 60, WL 271. REPLACED STIFFENER, BS 271, RBL 60, WL 271 IAW B737-300 SRM 51-40-02.SDR AWXA200700909Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962202, CORROSION ON CUSP SHEAR WEB, BS 486 - BS 500, S17R. REPLACED CUSP SHEAR WEB, BS 486 - BS 500, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200700829Intercostal · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962209, CRACKED INTERCOSTAL, BS 344 - BS 360, BL 0, WL 208.1. REPLACED INTERCOSTAL, BS 344 - BS 360, BL 0, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200700970Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961307, CRACKED FRAME WEB/UPPER RING, BS 663.75, S2L. REPAIRED FRAME WEB/UPPER RING, BS 663.75, S3L - S3R IAW B737-300 SRM 53-00-07-2R9 FIGURE 201.SDR AWXA200700969Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961319, CRACKED STRINGER CLIP, BS 727A, S25L. REPLACED STRINGER, BS 727A, S25L IAW B737-300 SRM 51-40-02.SDR AWXA200700967Stringer · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961293, CRACKED STRINGER, BS 500D, S16R. REPAIRED STRINGER, BS 500D, S16R IAW AWA ER 03-5312-01094-DD1.SDR AWXA200700960Stringer · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961285, CRACKED STRINGER, BS 500C, S16L. REPAIRED STRINGER, BS 500C, S16L IAW USAIRWAYS EA 120126.SDR AWXA200700957Skin · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961254, LEFT WING NR 2 SLAT LOWER SURFACE SKIN CRACKED, SS 235, SS 245 AND SS 253.5. REPAIRED LEFT WING NR 2 SLAT LOWER SURFACE SKIN, SS 235, SS 245 AND SS 253.5 IAW B737-300 SRM 57-43-01.SDR AWXA200700947Stringer · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961286, CRACKED STRINGER, BS 500D, S16L. REPAIRED STRINGER, BS 500D, S16L IAW AWA ER 03-5312-01094-DD1.SDR AWXA200700946Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961297, CRACKED STRINGER CLIP, BS 500A, S16R. REPLACED STRINGER CLIP,BS 500A, S16R IAW B737-300 SRM 51-40-02.SDR AWXA200700945Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961296, CRACKED STRINGER CLIP, BS 500B, S16R. REPLACED STRINGER CLIP, BS 500B, S16R IAW B737-300 SRM 51-40-02.SDR AWXA200700944Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961292, CRACKED STRINGER CLIP, BS 520, S16R. REPLACED STRINGER CLIP, BS 520, S16R IAW B737-300 SRM 51-40-02.SDR AWXA200700943Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961284, CRACKED STRINGER CLIP, BS 500B, S16L. REPLACED STRINGER CLIP, BS 500B, S16L IAW B737-300 SRM 51-40-02.SDR AWXA200700942Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961282, CRACKED STRINGER CLIP, BS 500A, S16L. REPLACED STRINGER CLIP, BS 500A, S16L IAW B737-300 SRM 51-40-02.SDR AWXA200700940Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961274, CRACKED STRINGER CLIP, BS 597, S10L. REPLACED STRINGER CLIP, BS 597, S10L IAW B737-300 SRM 51-40-02.SDR AWXA200700938Stringer · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961294, CRACKED STRINGER, BS 500C + 5", S16R. REPAIRED STRINGER, BS 500C + 5", S16R IAW AWA ER 03-5312-01094-DD1.SDR AWXA200700922Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961279 AND 5961288, CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME, BS 480, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700918Frame · crackedMAJOR REPAIR - C-20 CHECK - NR 5961289, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700917Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961278, CRACKED FRAME, BS 440, S9L. REPAIRED FRAME, BS 440, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700913Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961287, CRACKED FRAME, BS 500A, S9R. REPAIRED FRAME, BS 500A, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700912Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961275, CORROSION ON CUSP SHEAR WEB, BS 616 - BS 639, S17L. REPLACED CUSP SHEAR WEB, BS 616 - BS 639, S17L I/A/W B737-300 SRM 51-40-02.SDR AWXA200700911Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962163, CORROSION ON CUSP SHEAR WEB, BS 767 - BS 787, S17R. REPLACED CUSP SHEAR WEB, BS 767 - BS 787, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200700910Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962161, CORROSION ON CUSP SHEAR WEB, BS 807 - BS 827, S17R. REPLACED CUSP SHEAR WEB, BS 807 - BS 827, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200700904Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961268, CRACKED FRAME FOOT, BS 360 S14R - S15R. REPAIRED FRAME FOOT, BS 360 S14R - S15R IAW B737-300 SRM 53-00-07-2R3.SDR AWXA200700894Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962159, CORROSION ON CUSP WEB, BS 847 - BS 867, S17L. REPLACED CUSP WEB, BS 847 - BS 867, S17L IAW B737-300 SRM 51-40-02.SDR AWXA200700893Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962154, CORROSION ON CUSP WEB, BS 867 - BS 887, S17L. REPLACED CUSP WEB, BS 767 - BS 887, S17L IAW B737-300 SRM 51-40-02.
Back to Boeing 737-3G7