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 USAA920071347Stringer · crackedMCN - MAJOR REPAIR - C-16 CHECK - STRINGER CRACKED AT BS 907, S4L. REMOVED AND REPLACED STRINGER SPLICE AT BS 907, S4L IAW B737-300 SRM 51-40-02-0G FIG 8, 3, AND 12.SDR USAA920071346Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK - A CRACK FOUND ON FUSELAGE FRAME BS 188, LBL 31, WL 207. REMOVED DAMAGE AND INSTALLED FILLER IAW B737-300 SRM 53-00-07-2R11.SDR USAA920071345Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK- A CRACK FOUND AT BS 188, RBL 31 WL 207. REMOVED DAMAGE AND INSTALLED FILLERS IAW B737-300 SRM 53-00-07-2R11.SDR USAA920071272Frame · crackedCLT - MAJOR REPAIR-C-18- NR I1C53037/7, CRACK ON FRAME AT BS 400 BETWEEN S8R & S9R. REPAIRED IAW EA10048.SDR USAA920071271Stringer · crackedCLT - MAJOR REPAIR-C-18-NR CIC25009/1, CRACK ON STRINGER AT BS 940, S4L. REPAIRED IAW SRM 51-10-02.SDR USAA920080110Attach Bracket · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STUB BEAM ATTACH BRACKET, BS 639, LBL 45. REPLACED STUB BEAM ATTACH BRACKET, BS 639, LBL 45 IAW B737 SRM 51-40-03.SDR USAA920080086Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.
SDR USAA920080072Web · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED VERTICAL BEAM WEB, BS 180, LBL 17, WL 228. REPAIRED VERTICAL BEAM WEB, BS 180, LBL 17, WL 228 IAW B737 SRM 51-70-13.SDR USAA920080017Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 747, S8R - S9R. REPAIRED FRAME, BS 747, S8R - S9R IAW USAIRWAYS EA 100111.SDR USAA920080016Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 827, S8R - S9R. REPAIRED FRAME, BS 827, S8R - S9R IAW USAIRWAYS EA 100111.SDR USAA920071351Skin · crackedMCN - MAJOR REPAIR - C-16 CHECK - 3 CRACKS ON NR 1 SLAT SKIN AT NR 1 SLAT STA 166.5 - 171.75. INSTALLED DOUBLER AND REPAIRED IAW B737-300 SRM 57-43-01-2R4.SDR USAA920071344Skin · crackedMCN - MAJOR REPAIR - C-16 CHECK - THREE CRACKS FOUND ON LOW LEADING EDGE SKIN OF NR 2 SLAT AT NR 2 SLAT STATION 213.25 - 215.75, AND 161. REPAIRED CRACKS IAW B737-300 SRM 57-43-01-2R6, FIG 201.SDR USAA920071311Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED STRINGER TIE CLIP, BS 277, S10R. REPLACED STRINGER TIE CLIP, BS 277, S10R IAW B737 SRM 51-10-02.SDR USAA920071309Stringer Clip · crackedMCN - MAJOR REPAIR - C16 CHECK - NR 6049347, CRACKED STRINGER TIE CLIP, BS 727B, S25L. REPLACED STRINGER TIE CLIP, BS 727B, S25L IAW B737 SRM 51-40-02.SDR USAA920071308Slat · debondedMCN - MAJOR REPAIR - C16 CHECK - NR 6049364, RIGHT WING NR 5 SLAT HAS AREA OF DISBOND, SS 124.53 - SS 129.53. REPAIRED RIGHT WING NR 5 SLAT IAW B737 SRM 51-70-10-2R4.SDR USAA920071301Stringer Clip · crackedMCN - MAJOR REPAIR - C16 CHECK - NR 6052386, CRACKED STRINGER TIE CLIP, BS 887, S6R. REPLACED STRINGER TIE CLIP, BS 887, S6R IAW B737 SRM 51-40-02.SDR USAA920071282Fitting · corrodedCLT - MAJOR REPAIR- C-18 -NR I1D25012/10, CORROSION ON FLOOR FITTING MOUNT AT BS 303, LBL 12. REPAIRED IAW SRM 53-10-51-A, SRM 51-10-02.SDR USAA920071268Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/15, FRAME 847 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071267Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/6, FRAME 727E CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071266Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/14, FRAME 827 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071265Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/12, FRAME 787 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071264Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/11, FRAME 847 LEFT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071263Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/13, FRAME 807 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071262Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/10, FRAME 827 LEFT CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. INSTALLED REPAIR IAW EA100048, TR53-10-20E.SDR SWAA076027Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076029Light · crackedDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT ASSY CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA076028Slat · crackedDURING SCHEDULED C3 CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT INBOARD END. REPAIRED SLAT PER SWA EA.SDR USAA920080084Attach Angle · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL WEB ATTACH ANGLE , BS 944, S14L. REPLACED INTERCOSTAL WEB ATTACH ANGLE, BS 944, S14L IAW B737 SRM 51-10-02.SDR USAA920080121Aileron · delaminatedMCN - MAJOR REPAIR - C16 CHECK - RIGHT WING AILERON HAS AREA OF DELAMINATION, SPAR STATION 479. REPLACED RIGHT WING AILERON IAW USAIRWAYS EA 100134.SDR USAA920080002Door Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - L1 DOOR AFT EDGE BEAM CRACKED AT 3RD DOOR STOP HOLE FROM BOTTOM. REPAIRED THE L1 DOOR AFT EDGE BEAM AT 3RD DOOR STOP HOLE FROM BOTTOM IAW USAIRWAYS EA 100101.SDR USAA920071284Keelbeam · corrodedCLT - MAJOR REPAIR-C-18- NR I2B53003/4, CORROSION ON KEEL BEAM LOWER CHORD AT BS 500D, S28R. REPAIRED IAW 53-30-12-2R, REPAIR 2.SDR USAA920071276Attach Angle · crackedCLT - MAJOR REPAIR-C-18- NR I1C53037/3, CRACK ON STRINGER ATTACH ANGLE AT BS 500D,13R. REPAIRED IAW SRM 53-00-07-2R FIG 201.SDR USAA920071314Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED FRAME BS 480, S8R. REPAIRED FRAME, BS 480, S8R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920071310Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED STRINGER TIE CLIP, BS 663, S10R. REPLACED STRINGER TIE CLIP, BS 663, S10R IAW B737 SRM 51-00-00.SDR USAA920071283Stringer Clip · crackedCLT - MAJOR REPAIR-C-18- NR I1C53040/3, CRACK ON STRINGER TIE CLIP AT BS 663, S10R. REPLACED IAW 51-00-00.SDR USAA920071270Floorbeam · corrodedCLT - MAJOR REPAIR-C-18-NR I1D25012/15, CORROSION ON FLOORBEAM T-CAP AT BS 328, RBL 18. REPAIRED IAW SRM 53-10-51 FIG 101.SDR USAA920080124Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL WEB, BS 295, S11L. REPAIRED INTERCOSTAL WEB, BS 295, S11L IAW B737 SRM 51-40-02.
SDR USAA920080104Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER CLIP, BS 294.5, S12L. REPLACED STRINGER CLIP, BS 294.5, S12L IAW B737 SRM 51-20-00.SDR USAA920080103Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER CLIP, BS 294.5, S11L. REPLACED STRINGER CLIP, BS 294.5, S11L IAW B737 SRM 51-20-00.SDR USAA920080101Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL, BS 294 - BS 308, S16L. REPLACED INTERCOSTAL, BS 294 - BS 308, S16L IAW B737 SRM 51-40-03.SDR USAA920080082Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080067Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL OUTER CHORD ANGLE, BS 291, WL 249. REPLACED INTERCOSTAL OUTER CHORD ANGLE, BS 291, WL 249 IAW B737 SRM 51-10-02.SDR USAA920071275Stringer · corrodedCLT - MAJOR REPAIR -C-18- NR I2B53003/1, CORROSION ON STRINGER AT BS 535, S26L. REPAIRED IAW SRM 53-00-03-2 FIG 201 DETAIL VII.SDR USAA920071273Crease Beam · crackedCLT - MAJOR REPAIR -C-18-NR I1C53043/16, LT CREASE BEAM WEB CRACKED AT BS 616-639, LBL 70. REPLACED IAW BOEING DRWG 65C3473, SRM 51-40-03.SDR USAA920071269Seat Track · crackedCLT - MAJOR REPAIR - C-18-NR I1C53043/15, SEAT TRACK CRACKED AT BS 663, LBL 24. REPAIRED IAW EA1000040.SDR USAA920071307Flap · debondedMCN - MAJOR REPAIR - C16 CHECK - NR 6053647, RIGHT WING OUTBOARD AFT FLAP HAS AREA OF DISBOND, WBL 407.88 - WBL 409.38. REPAIRED RIGHT WING OUTBOARD AFT FLAP, WBL 407.88 - WBL 409.38 IAW B737 SRM 51-70-10-2R4.SDR USAA920080073Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3R. REPAIRED FRAME, BS 663, S3R IAW USAIRWAYS EA 100069.SDR USAA920080071Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3L. REPAIRED FRAME, BS 663, S3L IAW USAIRWAYS EA 100069.SDR USAA920080070Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S3R. REPAIRED FRAME, BS 663, S3R IAW USAIRWAYS EA 100069.SDR USAA920080069Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 663, S1. REPAIRED FRAME, BS 663, S1 IAW USAIRWAYS EA 100069.
Back to Boeing 737-3G7