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 USAA920071353Battery Pack · dischargedPHX - FLT 091 - EEL - EMERGENCY LIGHT AT ROW 4 RT UPPER BULLNOSE INOP. MX REPLACED THE BATTERY CHARGER AND BATTERY. OPERATIONAL CHECK WAS GOOD.SDR SWAA076356Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076355Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 14R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076354Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076353Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076357Stiffener · corrodedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD STIFFENER CORRODED AT BS 1016, LBL 0.5. REPAIRED STIFFENER PER SRM.SDR USAA920071348Skin · crackedMCN - MAJOR REPAIR - C-16 CHECK - A CRACK ON FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT, BS 291.5, WL 233.5. INSTALLED DOUBLER AND REPAIRED CRACK ON FUSELAGE SKIN AT R1 DOOR LOWER HINGE CUTOUT, BS 291.5, WL 233.5 IAW B737-300 SRM 53-10-01-2R, FIG 201.SDR USAA920080096Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 440, S8R. REPAIRED FRAME, BS 440, S8R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080063Strap · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZER STRAP, BS 328, RBL 48. REPAIRED FLOORBEAM STABILZER STRAP, BS 328, RBL 48 IAW B737 SRM 53-10-51.SDR USAA920080056Skin · crackedCLT - MAJOR REPAIR - C18 CHECK - AFT CARGO DOOR SKIN CRACKED. REPAIRED AFT CARGO DOOR SKIN IAW B737 SRM 52-00-21.SDR USAA920080003Stringer Clip · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED STRINGER CLIP, BS 727D, S21R. REPLACED STRINGER CLIP, BS 727D, S21R IAW B737 SRM 51-40-02.SDR USAA920071352Stringer Clip · crackedMCN - MAJOR REPAIR - C-16 CHECK - STRINGER CLIP CRACKED AT BS 727D, S20R. REMOVED AND REPLACED STRINGER CLIP AT BS 727D, S20R IAW B737-300 SRM 51-40-02-0G FIG 8 AND 12.SDR USAA920071349Skin · crackedPHX - MAJOR REPAIR - A CRACK FOUND ON FUSELAGE SKIN AT BS 380, S28L - S28R. REPAIRED CRACK IAW US AIRWAYS EA 12067.SDR SWAA076312Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND LT VERTICAL STABILIZER LUG FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA076319Flap Track · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT WING NR 7 OUTBOARD FLAP INBOARD TRACK FITTING CORRODED. REPAIRED FLAP TRACK PER SWA EA.SDR SWAA076315Attach Fitting · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG W/W LT SNUBBER ATTACHMENT CRACKED AT LBL 7.75. REPAIRED ATTACHMENT PER ACO.SDR SWAA076313Fitting · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT VERTICAL STABILIZER LUG FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA076311Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076310Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM CORRODED AT BS 660, LBL 70. REMOVED AND REPLACED CREASE BEAM PER SRM.SDR SWAA076314Pressure Panel · crackedDURING SCHEDULED BRDG CHECK, FOUND NLG W/W VERTICAL WEB CRACKED AT FWD TEE CHORD. REPAIRED WEB PER SRM.SDR USAA920080108Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER CLIP, BS 706, S6R. REPLACED STRINGER CLIP, BS 706, S6R IAW B737 SRM 51-10-02.SDR USAA920080093Attach Fitting · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL ATTACH CLIP, BS 360, S10L. REPLACED INTERCOSTAL ATTACH CLIP, BS 360, S10L IAW B737 SRM 51-10-02.SDR USAA920080065Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL, BS 328 - BS 344, LBL 48. REPLACED INTERCOSTAL, BS 328 - BS 344, LBL 48 IAW B737 SRM 51-10-02.SDR USAA920080064Strap · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZER STRAP, BS 312, LBL 45. REPLACED FLOORBEAM STABILZER STRAP, BS 312, LBL 45 IAW B737 SRM 53-10-51.SDR USAA920080100Shear Tie · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR TIE, BS 360, S13L. REPLACED SHEAR TIE, BS 360, S13L IAW B737 SRM 51-10-02.SDR USAA920080091Stringer Splice · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER SPLICE, BS 360, S15L. REPLACED STRINGER SPLICE, BS 360, S15L IAW B737 SRM 51-10-02.SDR USAA920080090Stringer Splice · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER SPLICE, BS 360, S14L. REPLACED STRINGER SPLICE, BS 360, S14L IAW B737 SRM 51-10-02.SDR USAA920080089Shear Tie · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR TIE, BS 360, S14L - S15L. REPLACED SHEAR TIE, BS 360, S14L - S15L IAW B737 SRM 51-10-02.SDR USAA920080060Skin · crackedCLT - MAJOR REPAIR - C18 CHECK - LEFT WING NR 1 SLAT LOWER SURFACE IS CRACKED AT ACTUATOR ATTACH AREA. REPAIRED LEFT WING NR 1 SLAT LOWER SURFACE AT ACTUATOR ATTACH AREA IAW B737 SRM 57-43-01-2R6.SDR USAA920080102Intercostal · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL WEB, BS 295, S12L. REPLACED INTERCOSTAL WEB, BS 295, S12L IAW B737 SRM 51-40-03.SDR SWAA076180Logic Card · faultyAIR TURNBACK / DECLARED EMERGENCY. DURING CLIMB FROM HOU NLG WARNING LIGHTS ILLUMINATED. CYCLED GEAR, NO HELP. REMOVED AND REPLACED LOGIC CARD PER MM.SDR USAA920080083Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 907, S9L. REPAIRED FRAME, BS 907, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080078Door Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - FORWARD SERVICE DOOR FRAME CRACKED AT THE 2ND FROM TOP STOP FITTING CUTOUT. REPAIRED THE FORWARD SERVICE DOOR FRAME AT THE 2ND FROM TOP STOP FITTING CUTOUT IAW B737 SRM 51-70-11.SDR SWAA076163Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR USAA920080081Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 847, S9L. REPAIRED FRAME, BS 847, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920080080Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920080077Skin · crackedCLT - MAJOR REPAIR - C18 CHECK - FORWARD SERVICE DOOR SKIN CRACKED AT THE 3RD FROM TOP STOP FITTING CUT OUT. REPAIRED THE FORWARD SERVICE DOOR SKIN AT THE 3RD FROM TOP STOP FITTING CUTOUT IAW B737 SRM 51-70-11.SDR SWAA076093Door Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND AFT CARGO DOOR FWD FRAME CORRODED AT LOWER FWD CORNER. REPAIRED FRAME PER ACO.SDR USAA920071306Skin · crackedPHX - MAJOR REPAIR - WEEKLY - NR 4257110, CRACKED FUSELAGE SKIN, BS 727E, S23L. REPAIRED FUSELAGE SKIN, BS 727E, S23L IAW USAIRWAYS EA 120454.SDR USAA920071315Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED FRAME WEB BS 787, S9L. REPAIRED FRAME WEB, BS 787, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920071300Stringer Clip · crackedMCN - MAJOR REPAIR - C16 CHECK - NR 6050280, CRACKED STRINGER TIE CLIP, BS 727A, S10L. REPLACED STRINGER TIE CLIP, BS 727A, S10L IAW B737 SRM 51-40-02.SDR USAA920080106Stringer Clip · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER CLIP, BS 597, S8L. REPLACED STRINGER CLIP, BS 597, S8L IAW B737 SRM 51-20-00.SDR USAA920080062Strap · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZER STRAP, BS 328, RBL 31. REPLACED FLOORBEAM STABILZER STRAP, BS 328, RBL 31 IAW B737 SRM 51-10-02.SDR USAA920080015Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 867, S8R - S9R. REPAIRED FRAME, BS 867, S8R - S9R IAW USAIRWAYS EA 100111.SDR USAA920080014Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 727B, S8L - S9L. REPAIRED FRAME, BS 727B, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080013Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 727D, S8L - S9L. REPAIRED FRAME, BS 727D, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080012Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 747, S8L - S9L. REPAIRED FRAME, BS 747, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080011Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 787, S8L - S9L. REPAIRED FRAME, BS 787, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080010Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME, BS 827, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080009Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 867, S8L - S9L. REPAIRED FRAME, BS 867, S8L - S9L IAW USAIRWAYS EA 100111.
Back to Boeing 737-3G7