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 USAA920070996Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME BS 827, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071202Sign · weakCLT - EEL - C16 CHECK, EMERGENCY EXIT SIGNS ON FIRST CLASS CURTAIN HEADER FAILED BETA LIGHT COMPARATOR TEST. REPLACED EMERGENCY EXIT SIGNS ON FIRST CLASS CURTAIN HEADER IAW B737 AMM 33-51-14-2.SDR USAA920071049Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 480, S1R. REPAIRED FRAME, BS 480, S1R IAW USAIRWAYS EA 98915.SDR USAA920071047Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED, BS 846.5, S24R. REPAIRED AFT CARGO COMPARTMENT DOOR CUTOUT AFT FRAME, BS 846.5, S24R IAW B737 SRM 53-00-53.SDR USAA920071208Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 784, S8L - S9L. REPAIRED FRAME, BS 784, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071207Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 727D, S8L - S9L. REPAIRED FRAME, BS 727D, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071045Strap · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FLOORBEAM STABILIZER STRAP, BS 328, BL 0. REPAIRED FLOORBEAM STABILIZER STRAP, BS 328, BL 0 IAW B737 SRM 53-10-51.SDR USAA920071204Frame · crackedCLT - MAJOR REPAIR - C16 CHECK , CRACKED FRAME, BS 747, S8R - S9R. REPAIRED FRAME, BS 747, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071051Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FLOORBEAM INNER CHORD, BS 639. REPAIRED FLOORBEAM INNER CHORD, BS 639 IAW EA 98917.SDR USAA920071114Structure · crackedCLT - MAJOR REPAIR - C16 CHECK, RIGHT WING LOWER WING CHORD CRACKED, WS 135.5. REPAIRED RIGHT WING LOWER CHORD, WS 135.5 IAW USAIRWAYS EA 98943.SDR USAA920071007Stringer Splice · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED STRINGER SPLICE, BS 907, S4L. REPLACED STRINGER, BS 907, S4L IAW B737-300 SRM 51-10-02.SDR USAA920071000Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME, BS 827, S8L - S9L IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920070940Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504599, CRACKED FUSELAGE SKIN, BS 727D, S23R. REPAIRED FUSELAGE SKIN, BS 727D, S23R IAW USAIRWAYS EA 120316.SDR USAA920070939Floorbeam · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505201, CRACKED FLOORBEAM TEE CAP, BS 663.75, BL 0, WL 208. REPAIRED FLOORBEAM TEE CAP, BS 663.75, BL 0, WL 208 IAW USAIRWAYS EA 120277.SDR USAA920071206Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 867, S8R - S9R. REPAIRED FRAME, BS 867, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071205Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 867, S8L - S9L. REPAIRED FRAME, BS 867, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920070943Stringer · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED STRINGER CHANNEL, BS 360, S15L. REPLACED STRINGER CHANNEL, BS 360, S15L IAW B737 SRM 51-10-02.SDR USAA920070942Attach Angle · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED STRINGER SPLICE ATTACH ANGLE, BS 348, S14L - S15L. REPLACED STRINGER SPLICE ATTACH ANGLE, BS 348, S14L - S15L IAW B737 SRM 51-10-02.SDR USAA920070938Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505051, CRACKED FRAME, BS 907, S9R. REPAIRED FRAME, BS 907, S9R IAW USAIRWAYS EA 120272.SDR USAA920070937Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504947, CRACKED FRAME, BS 807, S9R. REPAIRED FRAME, BS 807, S9R IAW USAIRWAYS EA 120272.SDR USAA920070936Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504946, CRACKED FRAME, BS 767, S9R. REPAIRED FRAME BS 767, S9R IAW USAIRWAYS EA 120272.SDR USAA920070935Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504945, CRACKED FRAME, BS 480, S9R. REPAIRED FRAME, BS 480, S9R IAW USAIRWAYS EA 120272.SDR USAA920070934Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504944, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW USAIRWAYS EA 120272.SDR USAA920070933Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505053, CRACKED FRAME, BS 847, S9L. REPAIRED FRAME, BS 847, S9L IAW USAIRWAYS EA 120272.SDR USAA920070932Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505052, CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW USAIRWAYS EA 120272.SDR USAA920070931Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505054 AND 6505050, CRACKED FRAME, BS 887, S9L AND S9R. REPAIRED FRAME, BS 887, S9L AND S9R IAW USAIRWAYS EA 120272.SDR USAA920070929Stringer Splice · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED STRINGER SPLICE, BS 360, S14L. REPLACED STRINGER SPLICE, BS 360, S14L IAW B737-300 SRM 51-40-02.SDR USAA920070951Slat · delaminatedPHX - MAJOR REPAIR - LEFT WING NR 2 SLAT DELAMINATED. REMOVED, REPAIRED AND REINSTALLED THE LEFT WING NR 2 SLAT IAW B737 AMM 27-81-00 AND 57-41-01.SDR USAA920070927Web · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED SUPPORT WEB, BS 345, LBL 10. REPLACED SUPPORT WEB, BS 345, LBL 10 IAW B737-300 SRM 51-10-02.SDR USAA920070925Web · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5966928, L2 DOOR CUTOUT WEB BROKEN, BS 1010, S7L. REPLACED L2 DOOR CUTOUT WEB, BS 1010, S7L IAW B737-300 SRM 551-40-02.SDR USAA920070924Bulkhead · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505193, AFT PRESSURE BULKHEAD WEB CRACKED, BS 1016, LBL 58, WL 270. REPAIRED AFT PRESSURE BULKHEAD WEB, BS 1016, LBL 58, WL 270 IAW B737-300 SRM 53-80-08-2R7, FIGURE 201.SDR USAA920070923Attach Fitting · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5976581, RIGHT AILERON INBOARD ATTACH FITTING CRACKED, WS 517.75. REPLACED RIGHT AILERON INBOARD ATTACH FITTING, WS 517.75 IAW B737-300 SRM 51-40-02.SDR USAA920070920Tie Clip · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED TIE CLIP, BS 663, S10L. REPLACED TIE CLIP, BS 663, S10L IAW B737-300 SRM 51-10-02.SDR USAA920071008Web · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED SUPPORT WEB, BS 328, LBL 10. REPLACED SUPPORT WEB, BS 328, LBL 10 IAW B737-300 SRM 51-10-02.SDR USAA920070928Stringer Clip · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED STRINGER TIE CLIP, BS 663, S10R. REPLACED STRINGER TIE CLIP, BS 663, S10R IAW B737-300 SRM 51-10-02.SDR USAA920070921Support · crackedCLT - MAJOR REPAIR - C-20 CHECK, CRACKED SUPPORT WEB, BS 345, LBL 10. REPLACED SUPPORT WEB, BS 345, LBL 10 IAW B737-300 SRM 51-10-02.SDR SWAA075039Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR USAA920071118Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FLOOR SUPPORT STRAP, BS 328, LBL 30. REPLACED FLOOR SUPPORT STRAP, BS 328, LBL 30 IAW B737 SRM 51-10-02.SDR SWAA074977Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739E, STR 18R. REPAIRED SKIN PER SRM.SDR USAA920071129Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, FORWARD CARGO DOOR FORWARD LOWER FRAME CRACKED BETWEEN THE LOWER 2 CROSS BEAMS. REPLACED FORWARD CARGO DOOR IAW 737 MM 52-31-00-404-022.SDR USAA920070947Floorbeam · corrodedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505100, CORROSION ON FLOORBEAM SHEAR WEB, BS 1016, LBL 55, WL 208. REPLACED FLOORBEAM SHEAR WEB, BS 1016, LBL 55, WL 208 IAW B737-300 SRM 51-40-02.SDR USAA920070944Shear Web · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5976438, CRACKED CABIN FLOOR SHEAR WEB, BS 1025, RBL 2, WL 208.1. REPLACED CABIN FLOOR SHEAR WEB, BS 1016 - BS 1025, BL 0 - RBL 45, WL 208.1 IAW B737-300 SRM 51-40-02.SDR USAA920070922Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504625, FORWARD CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME CRACKED, BS 442, S25R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME , BS 442, S25R IAW B737-300 SRM 51-40-02.SDR USAA920071128Skin · delaminatedCLT - MAJOR REPAIR - C20 CHECK, LEFT WING AILERON OUTBOARD UPPER SURFACE HAS EXPOSED COMPOSITE. REPAIRED LEFT WING AILERON OUTBOARD UPPER SURFACE IAW USAIRWAYS EA 98940.SDR USAA920071119Skin · delaminatedCLT - MAJOR REPAIR - C20 CHECK, RIGHT WING NR 5 SLAT TRAILING EDGE OUTBOARD END DELAMINATED. REPLACED RIGHT WING NR 5 SLAT IAW B737 AMM 27-81-00.SDR USAA920070908Shear Web · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505192, CRACKED CABIN FLOOR SHEAR WEB, BS 986, LBL 45, WL 208. REPLACED CABIN FLOOR SHEAR WEB, BS 986, LBL 45, WL 208 IAW B737-300 SRM 51-40-02.SDR USAA920071130Shear Tie · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED SHEAR TIE, BS 348, S13L. REPLACED SHEAR TIE, BS 348, S13L IAW 737 SRM 51-10-02.SDR USAA920071127Skin · delaminatedCLT - MAJOR REPAIR - C20 CHECK, RIGHT WING AILERON UPPER LEADING EDGE HAS EXPOSED CARBON FIBLER. REPLACED RIGHT WING AILERON IAW TASK CARD R3M27015.SDR USAA920071126Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FLOOR SUPPORT, BS 540, LBL 2. REPLACED FLOOR SUPPORT, BS 540, LBL 2 IAW B737 SRM 51-10-02.SDR USAA920071125Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FLOOR SUPPORT, BS 540, RBL 2. REPLACED FLOOR SUPPORT, BS 540, RBL 2 IAW B737 SRM 51-10-02.
Back to Boeing 737-3G7