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 AWXA200700476Attach Angle · crackedMCN - CRACKED FRAME ATTACH ANGLE (CLIP), BS 348, S15L. REPLACED FRAME ATTACH ANGLE (CLIP), BS 348, S15L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700461Frame · crackedMCN - CRACKED FRAME, BS 380, S27L. REPAIRED FRAME, BS 380, S27L IAW B737-300 SRM 53-00-07-2R4, FIGURE 201.SDR AWXA200700435Intercostal · corrodedMCN - CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL, BS 797, S25R. REPLACED AFT CARGO COMPARTMENT INTERCOSTAL, BS 797, S25R IAW B737-300 SRM 51-40-02.SDR AWXA200700405Angle · crackedMCN - FOUND CRACKED ANGLE, BS 336, BETWEEN S22L AND S23L. REPLACED ANGLE, BS 336, BETWEEN S22L AND S23L IAW B737-300 SRM 51-40-02.SDR AWXA200700391Strap · crackedMCN - FOUND CRACKED LOWER FLOORBEAM STRAP, BS 312, RBL 46. REPAIRED LOWER FLOORBEAM STRAP, BS 312, RBL 46 IAW B737-300 SRM 51-70-11.SDR AWXA200700486Frame · crackedMCN - CRACKED FRAME, BS 294.5, S10L - S11L. REPAIRED FRAME, BS 294.5, S10L - S11L IAW AWA ER 03-5312-07093-SS5.SDR AWXA200700453Tab · debondedMCN - RIGHT ELEVATOR TRIM TAB DISBONDED, ELEVATOR STATION 59 - 64. REPAIRED RIGHT ELEVATOR TRIM TAB, ELEVATOR STATION 59 - 64 IAW B737-300 SRM 51-70-04 FIGURE 10.SDR AWXA200700491Strap · corrodedMCN - CORROSION ON AFT CARGO DOOR CUT OUT LOWER SILL STRAP, BS 787 - BS 857, S25R. REPLACED AFT CARGO DOOR CUT OUT LOWER SILL STRAP, BS 787 - BS 857, S25R IAW B737-300 SRM 53-60-15-1A1 FIGURE 101.SDR AWXA200700488Intercostal · crackedMCN - CRACKED AUXILARY INTERCOSTAL, BS 294.5 - BS 299, S10L. REPLACED AUXILARY INTERCOSTAL, BS 294.5 - BS 299, S10L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700487Shear Tie · crackedMCN - CRACKED INTERCOSTAL SHEAR TIE CLIP, BS 294.5, S11L. REPLACED INTERCOSTAL SHEAR TIE CLIP, BS 294.5, S11L IAW AWA ER 03-5312-0793-SS4.SDR AWXA200700485Intercostal · crackedMCN - CRACKED INTERCOSTAL WEB, BS 294.5, S7L. REPLACED INTERCOSTAL WEB, BS 294.5, S7L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700475Intercostal · crackedMCN - CRACKED INTERCOSTAL WEB, BS 294.5, S8L. REPLACED INTERCOSTAL WEB, BS 294.5, S8L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700474Intercostal · crackedMCN - CRACKED INTERCOSTAL LOWER CLIP, BS 348.2, S16L. REPLACED INTERCOSTAL LOWER CLIP, BS 348.2, S16L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700473Intercostal · crackedMCN - CRACKED INTERCOSTAL UPPER CLIP, BS 348.2, S16L. REPLACED INTERCOSTAL UPPER CLIP, BS 348.2, S16L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700472Attach Fitting · crackedMCN - CRACKED FRAME VERTICAL CLIP, BS 360, S14L - S15L. REPLACED FRAME VERTICAL CLIP, BS 360, S14L - S15L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700471Intercostal · crackedMCN - CRACKED INTERCOSTAL STRAP (TIE), BS 348.2, S16L. REPLACED INTERCOSTAL STRAP (TIE), BS 348.2, S16L IAW AWA ER 03-5312-07093-SS4.SDR AWXA200700468Attach Fitting · brokenMCN - AFT CARGO COMPARTMENT FRAME TO WEB ATTACH CLIP IS BROKEN, BS 807, S25R. REPLACED AFT CARGO COMPARTMENT FRAME TO WEB ATTACH CLIP, BS 807, S25R IAW B737-300 SRM 51-40-02SDR AWXA200700454Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 727A, S20R. REPLACED STRINGER CLIP, BS 727A, S20R IAW B737-300 SRM 51-40-02.SDR AWXA200700406Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 727E, S24L. REPLACED STRINGER CLIP, BS 727E, S24L IAW B737-300 SRM 51-40-02.SDR AWXA200700393Web · crackedMCN - FOUND AFT CARGO COMPARTMENT DOOR CUT OUT WEB CRACKED, BS 847, RBL 36, WL 150. REPAIRED AFT CARGO COMPARTMENT DOOR CUT OUT WEB, BS 847, RBL 36, WL 150 IAW B737-300 SRM 51-70-02.SDR AWXA200700392Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 947, S26R. REPLACED STRINGER CLIP, BS 947, S26R IAW B737-300 SRM 51-40-02.SDR AWXA200700381Stringer Clip · crackedMCN - FOUND CRACKED AFT CARGO COMPARTMENT STRINGER CLIP, BS 747, S25L. REPLACED AFT CARGO COMPARTMENT STRINGER CLIP, BS 747, S25L IAW B737-300 SRM 51-40-02.SDR AWXA200700350Skin · crackedPHX - FOUND CRACKED FUSELAGE SKIN, BS 887, S25R AT LAP SEAM. REPAIRED FUSELAGE SKIN, BS 887, S25R AT LAP SEAM IAW B737-300 SRM 53-00-01-2RSDR AWXA200700452Skin · delaminatedMCN - RIGHT WING OUTBOARD FLAP UPPER SURFACE DELAMINATED, WS 316.45 - WS 326.45. REPAIRED RIGHT WING OUTBOARD FLAP UPPER SURFACE, WS 316.45 - WS 326.45 IAW B737-300 SRM 51-70-10-2R4 FIGURE 203.SDR AWXA200700408Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 616, S8R. REPLACED STRINGER CLIP, BS 616, S8R IAW B737-300 SRM 51-40-02.SDR AWXA200700407Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 706, S1. REPLACED STRINGER CLIP, BS 706, S1 IAW B737-300 SRM 51-40-02.SDR AWXA200700398Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 616, S6R. REPLACED STRINGER CLIP, BS 616, S6R IAW B737-300 SRM 51-40-02.SDR AWXA200700396Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 706, S2R. REPLACED STRINGER CLIP, BS 706, S2R IAW B737-300 SRM 51-40-02.SDR AWXA200700395Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 663.75, S10L. REPLACED STRINGER CLIP, BS 663.75, S10L IAW B737-300 SRM 51-40-02.SDR AWXA200700394Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 706, S2L. REPLACED STRINGER CLIP, BS BS 706, S2L IAW B737-300 SRM 51-40-02.SDR AWXA200700489Door Frame · crackedMCN - R1 DOOR AFT FRAME CRACKED, BS 328, S15R AT THE 5TH STOP PIN CUT OUT. REPAIRED R1 DOOR AFT FRAME, BS 328, S15R AT THE 5TH STOP PIN CUT OUT IAW AWA ER 03-5200-07098-SS1.SDR AWXA200700481Door Frame · crackedMCN - CRACKED L1 DOOR AFT FRAME, BS 348, S13L - S14L, NEAR STOP PIN CUTOUTS NR 6 AND NR 7. REPAIRED L1 DOOR AFT FRAME, BS 348, S13L - S14L, NEAR STOP PIN CUTOUTS NR 6 AND NR 7 IAW ER 03-5200-07097-ES1.SDR AWXA200700480Skin · crackedMCN - CRACKED L1 DOOR INNER SKIN, BS 347.30, S12L - S14L, NEAR STOP PIN CUTOUTS NR 5, NR 6 AND NR 7. REPAIRED L1 DOOR INNER SKIN, BS 347.30, S12L - S14L, NEAR STOP PIN CUTOUTS NR 5, NR 6 AND NR 7 IAW ER 03-5200-07097-ES1.SDR AWXA200700460Skin · crackedMCN - LEFT WING NR 1 SLAT LOWER SURFACE CRACKED, SS 255 - SS 258.87. REPAIRED LEFT WING NR 1 SLAT LOWER SURFACE, SS 255 - SS 258.87 IAW B737-300 SRM 57-43-01-2R6 FIGURE 201.SDR AWXA200700459Seat Track · crackedMCN - CRACKED CABIN SEAT TRACK, BS 841, LBL 24.75. REPLACED CABIN SEAT TRACK, BS 727B - BS 947, LBL 24.75 IAW B737-300 SRM 51-40-02.SDR AWXA200700458Intercostal · crackedMCN - CRACKED INTERCOSTAL, BS 400, S26L. REPLACED INTERCOSTAL, BS 400, S26L IAW B737-300 SRM 51-40-02.SDR AWXA200700397Stringer Clip · crackedMCN - FOUND CRACKED STRINGER CLIP, BS 500C, S27L. REPLACED STRINGER CLIP, BS 500C, S27L IAW B737-300 SRM 51-40-02.SDR AWXA200700380Stringer Clip · crackedMCN - FOUND CRACKED FORWARD CARGO COMPARTMENT STRINGER CLIP, BS 500D, S25R. REPLACED FORWARD CARGO COMPARTMENT STRINGER CLIP, BS 500D, S25R IAW B737-300 SRM 51-40-02.SDR AWXA200700377Stringer Clip · crackedMCN - FOUND FORWARD CARGO COMPARTMENT STRINGER CLIP CRACKED, BS 500, S20R. REPLACED FORWARD CARGO COMPARTMENT STRINGER CLIP, BS 500, S20R IAW B737-300 SRM 51-40-02.SDR AWXA200700484Skin · crackedMCN - CRACKED FUSELAGE SKIN, BS 303.9, S13L, L1 DOOR CUT OUT FWD LOWER CORNER. REPAIRED FUSELAGE SKIN, BS 303.9, S13L, L1 DOOR CUT OUT FWD LOWER CORNER IAW AWA ER 03-5300-7100-SS3 .SDR AWXA200700479Skin · crackedMCN - CRACKED FUSELAGE SKIN, BS 727D + 3", S23R - S24R. REPAIRED FUSELAGE SKIN, BS 727D + 3", S23R - S24R IAW AWA ER 03-5300-07100-SS2.SDR AWXA200700470Skin · crackedMCN - FUSELAGE SKIN CRACKED, BS 989, S17L, WL 280, AT L2 DOOR SURROUND UPPER AFT CORNER FASTENER HOLE. REPAIRED FUSELAGE SKIN CRACKED, BS 989, S17L, WL 280, AT L2 DOOR SURROUND UPPER AFT CORNER FASTENER HOLE IAW B737-300 SRM 53-00-01 FIGURE 201.SDR AWXA200700469Skin · crackedMCN - FUSELAGE SKIN CRACKED, BS 884, S23R - S24R. REPAIRED FUSELAGE SKIN, BS 884, S23R - S24R IAW AWA ER 03-5300-07094-ES2.SDR AWXA200700451Frame · crackedMCN - CRACKED R1 DOOR CUT OUT UPPER STUB FRAME, BS 296.40, RBL 49.34,WL 265. REPLACED R1 DOOR CUT OUT UPPER STUB FRAME, BS 296.40, RBL 49.34,WL 265 IAW B737-300 SRM 51-40-02.SDR AWXA200700450Frame · crackedMCN - R1 DOOR CUT OUT FORWARD FRAME CRACKED, BS 294, WL 207. REPLACED R1 DOOR CUT OUT FORWARD FRAME, BS 294, WL 207 IAW B737-300 SRM 51-40-02.SDR AWXA200700440Channel · corrodedMCN - CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT CHANNEL, BS 787, S25R. REPLACED AFT CARGO COMPARTMENT DOOR CUT OUT CHANNEL, BS 787, S25R IAW B737-300 SRM 51-40-02.SDR AWXA200700439Frame · crackedMCN - CRACKED FRAME UPPER RING, BS 663.75, S1 - S3R. REPAIRED FRAME UPPER RING, BS 663.75, S1 - S3R IAW B737-300 SRM 53-00-07-2R9, FIGURE 201.SDR AWXA200700438Gusset · crackedMCN - BS 540 BULKHEAD VERTICAL STIFFENER ATTACH ANGLE CRACKED, LBL 45, WL 208. REPLACED BS 540 BULKHEAD VERTICAL STIFFENER ATTACH ANGLE, LBL 45, WL 208 IAW B737-300 SRM 51-40-02.SDR AWXA200700437Shear Web · corrodedMCN - CORROSION ON CABIN FLOOR SHEAR WEB, BS 616, LBL 65, WL 208.1. REPLACED CABIN FLOOR SHEAR WEB, BS 616, LBL 65, WL 208.1 IAW B737-300 SRM 51-40-02.SDR AWXA200700436Shear Web · corrodedMCN - CORROSION ON CABIN FLOOR SHEAR WEB, BS 639, RBL 65, WL 208.1. REPLACED CABIN FLOOR SHEAR WEB, BS 639, RBL 65, WL 208.1 IAW B737-300 SRM 51-40-02.
Back to Boeing 737-3G7