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 USAA2008121592227Wire · unknownSAL - C17 - EEL - EMERGENCY EXIT LIGHT IN THE FOLLOWING POSITION IN SEAT ROW 17 LT SIDE UPPER POSITION AND EXIT UPPER POSITION AND LITTLE EXIT L2 DOOR. PERFORMED RE-CONFIGURATION OF WIRES ON CONNECTOR D2966 IAW B737 TROUBLESHOOTING MANUAL 33-51-02-1, WDM 33-5SDR USAA2008121992282Support Fitting · corrodedSAL - C17 - MAJOR REPAIR - CORROSION ON STABILIZER BEAM AFT SUPPORT FITTING AT LT MAIN LANDING GEAR. REPLACED STABILIZER BEAM AFT SUPPORT FITTING IAW AMM 57-15-00-4.SDR USAA2008122292299Bulkhead · crackedSAL - C19 - MAJOR REPAIR - NR 6130736 - CRACK ON VERTICAL CHORD WEB AT BS 178, WL 184, RBL 5.7. REPAIRED VERTICAL CHORD WEB AT BS 178, WL 184, RBL 5.7 IAW US AIRWAYS EA 132171.SDR USAA2008122392311Structure · debondedSAL - C19 - MAJOR REPAIR - NR 6135795 - DEBOND OF TRAILING EDGE OF RUDDER STA 233.09 +12 INCHES. REPAIRED RUDDER TRAILING EDGE IAW B737 SRM 51-20-05-06.SDR USAASB08118Megaphone · inoperativePHX - MAINTENANCE REPORTED THE FORWARD MEGAPHONE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FORWARD MEGAPHONE. OPERATIONAL CHECK GOOD.SDR USAA2008122992331Sill · corrodedSAL - MAJOR REPAIR - C19 CHECK - NR 6130864, CORROSION ON AFT CARGO DOOR CUTOUT LOWER SILL WEB AT BS 767 - BS 787, S25R. REPLACED AFT CARGO DOOR CUTOUT LOWER SILL WEB AT BS 767 - BS 787, S25R IAW B737 SRM 51-10-02.SDR USAA2008122992330Frame · crackedSAL - MAJOR REPAIR - C19 CHECK - NR 6136281, CRACKED FRAME AT BS 907, S8R - S9R. REPAIRED FRAME AT BS 907, S8R - S9R IAW TASK CARD M1C53002.SDR USAA2008112892143Repair · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED ON LEFT WING NR 2 SLAT UPPER SURFACE WS 251. REPAIRED NR 2 SLAT UPPER SURFACE IAW B737 SRM 51-70-10-2R.SDR USAA2008122292296Frame · corrodedSAL - C19 - MAJOR REPAIR - NR 6130873 - CORROSION ON FRAME AT BS 847, BETWEEN S24R TO S26R. REPLACED FRAME AT BS 847, BETWEEN S24R TO S26R IAW B737 SRM 51-40-02-0G.SDR USAA2008112892138Spoiler · delaminatedCLT - RON - MAJOR REPAIR - RIGHT WING NR 7 SPOILER DELAMINATED AT UPPER TRAILING EDGE APPROX 5 INCHES CIRCULAR DIAMETER. REPLACED NR 7 SPOILER IAW B737 AMM 27-61-11.SDR USAA2008121792261Stringer Clip · crackedSAL - C19 - MAJOR REPAIR - STRINGER TIE CLIP CRACKED AT BS 986.5, S25L. REPLACED STRINGER TIE CLIP AT BS 986.5, S25L IAW SRM 51-40-02.SDR USAA2008122992332Support Angle · corrodedSAL - MAJOR REPAIR - C19 CHECK - NR 6130865, CORROSION ON AFT CARGO DOOR CUTOUT LOWER SILL SUPPORT ANGLE AT BS 767 + 5, S25R. REPLACED AFT CARGO DOOR CUTOUT LOWER SILL SUPPORT ANGLE AT BS 767 + 5, S25R IAW B737 SRM 51-10-02.SDR USAA2008122292298Frame · corrodedSAL - C19 - MAJOR REPAIR - NR 6130869 - CORROSION ON FRAME AT AFT CARGO DOOR CUTOUT AT BS 794, BETWEEN S23R TO S27R. REPLACED FRAME AT AFT CARGO DOOR CUTOUT AT BS 794, BETWEEN S23R TO S27R IAW B737 SRM 51-40-02-0G.SDR USAA2008122292297Sill · corrodedCLT - C19 - MAJOR REPAIR - NR 6130870 - CORROSION ON SILL WEB AT AFT CARGO COMPARTMENT ENTRY RIGHT SIDE. CORROSION ON SILL WEB AT AFT CARGO REPLACED SILL WEB AT AFT CARGO COMPARTMENT ENTRY IAW B737 SRM 51-40-02-0G.SDR USAA2008122292295Bulkhead · corrodedSAL - C19 - MAJOR REPAIR - NR 6135611 - CORROSION ON BULKHEAD LOWER CHORD AT BS 227.8, BETWEEN S28R TO S28L. REPAIRED BULKHEAD LOWER CHORD AT BS 227.8, BETWEEN S28R TO S28L IAW US AIRWAYS EA 32138.SDR USAA2008122292294Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - NR 6130902 - CORROSION ON FLOORBEAM UPPER FLANGE AT BS 986.5, S17R, BETWEEN BL 0 TO RBL 19. REPAIRED FLOORBEAM AT BS 986.5, S17R, BETWEEN BL 0 TO RBL 19 IAW US AIRWAYS EA 132131 & B737 SRM 53-00-51-2R 2.SDR USAA2008121892266Channel · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON SUPPORT CHANNEL BETWEEN BS 767 TO BS 787, S25R. REPLACED SUPPORT CHANNEL BETWEEN BS 767 TO BS 787, S25R IAW SRM 51-40-02-0G.SDR USAA2008121792259Strap · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON STRAP BETWEEN BS 847 TO BS 867, S25R. REPAIRED STRAP BETWEEN BS 847 TO BS 867, S25R IAW DRAWING 6547957 & SRM 51-90-02.SDR USAA2008122292293Seat Track · corrodedSAL - C19 - MAJOR REPAIR - NR 6135762 - CORROSION ON SEAT TRACK BETWEEN BS 907 TO BS 927, RBL 26. REPAIRED SEAT TRACK BETWEEN BS 907 TO BS 927, RBL 26 IAW B737 SRM 53-00-52-2R 3.SDR USAA2008121892267Seat Track · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON SEAT TRACK BETWEEN BS 907 TO BS 927, LBL 26. REPAIRED SEAT TRACK BETWEEN BS 907 TO BS 927, LBL 26 IAW SRM 53-00-52-2R.SDR USAA2008121792260Angle · crackedSAL - C19 - MAJOR REPAIR - CRACK ON SUPPORT ANGLE OF FLOOR STRUCTURE BETWEEN BS 967 TO BS 986.5, LBL 68.6 AT L2 DOOR AREA. REPLACED SUPPORT ANGLE OF FLOOR STRUCTURE IAW SRM 51-40-02-0G.SDR USAA2008121792258Seat Track · corrodedSAL - C19 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK BETWEEN BS 907 TO BS 927, LBL 47. REPAIRED SEAT TRACK BETWEEN BS 907 TO BS 927, LBL 47 IAW SRM 53-00-52-2R.SDR USAA2008121792257Seat Track · corrodedSAL - C19 - MAJOR REPAIR - GALVANIC CORROSION ON SEAT TRACK BETWEEN BS 907 TO BS 927, RBL 45.5. REPAIRED SEAT TRACK BETWEEN BS 907 TO BS 927, RBL 45.5 IAW SRM 53-00-52-2R.SDR USAA2008121892265Intercostal · corrodedSAL - C19 - MAJOR REPAIR - CORROSION ON UPPER FLANGE OF INTERCOSTAL BETWEEN BS 986.5 TO BS 1006, LBL 29. REPLACED INTERCOSTAL BETWEEN BS 986.5 TO BS 1006, LBL 29 IAW B737 SRM 51-40-02-0G.SDR USAASB08114Wire · brokenPHX - SEAT TWO, LEFT FORWARD ESCAPE PATH LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE. OPERATIONALLY CHECKS OK.SDR USAA920082072Skin · crackedPHX RON MAJOR REPAIR NR 4451797 FUSELAGE SKIN CRACKED BETWEEN BS727E TO BS747, S23R. REPAIRED FUSELAGE SKIN BETWEEN BS727E TO BS747, S23R IAW SRM 53-00-01-2R31.SDR USAA920082071Skin · crackedPHX - RON MAJOR REPAIR NR 4451796 FUSELAGE SKIN CRACKED BETWEEN BS927 TO BS947.5, S23L. REPAIRED FUSELAGE SKIN BETWEEN BS927 TO BS947.5, S23L IAW B737 SRM 53-00-01-2R 31.SDR USAA2008112892144Repair · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED ON LEFT WING NR 4 INBOARD SPOILER, WBL 87.75 TO WBL 180.7. REPAIRED NR 4 INBOARD SPOILER IAW B737 SRM 51-70-10-2R.SDR USAA2008112892142Repair · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED ON LEFT ELEVATOR UPPER SURFACE AT ELEVATOR STA 53. REPAIRED LEFT ELEVATOR UPPER SURFACE IAW B737 SRM 51-70-03-0G.SDR USAA2008112892141Repair · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED ON RIGHT ELEVATOR UPPER SURFACE AT ELEVATOR STA 108.5. REPAIRED RIGHT ELEVATOR UPPER SURFACE IAW B737 SRM 51-70-03-0G.SDR USAA2008112892140Repair · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED ON LEFT WING NR 1 SLAT UPPER SURFACE WS 254.53 TO WS 389. REPAIRED NR 1 SLAT UPPER SURFACE IAW B737 SRM 51-70-10-2R.SDR USAA2008112492110Skin · delaminatedSAL - C17 - MAJOR REPAIR - EXISTING REPAIR DELAMINATED AT SPOILER NR 0 UPPER SURFACE WS 447.47 TO WS 499.93. REPAIRED SPOILER NR 0 UPPER SURFACE WS 447.47 TO WS 499.93 IAW B737 SRM 51-70-10-2R.SDR USAA920082081Shear Web · crackedMCN LAV SPILL MAJOR REPAIR NR 6135587 FLOOR SHEAR WEB CRACKED AT BS986.5, WL207.8, BETWEEN LBL38 TO LBL40. REPAIRED FLOOR SHEAR WEB AT BS986.5, WL207.8, BETWEEN LBL38 TO LBL40 IAW BOEING DRAWING NR 65C32677.SDR USAA920082077Angle · corrodedMCN LAV SPILL MAJOR REPAIR NR 6136798 CORROSION ON SPLICE ANGLE AT BS936.5, WL204, BETWEEN RBL34 TO LBL40. REPLACED SPLICE ANGLE IAW B737 SRM 51-40-02-0G.SDR USAA920082078Crease Beam · corrodedMCN LAV SPILL MAJOR REPAIR NR 6135573 CORROSION ON CREASE BEAM INNER CHORD BETWEEN BS984 TO BS1006, WL207.8, LBL60. REPLACED CREASE BEAM IAW B737 SRM 51-40-02-0G.SDR USAA920082075Shear Web · corrodedMCN LAV SPILL MAJOR REPAIR NR 6135576 CORROSION ON SHEAR WEB AT BS986.5, WL207.8, BETWEEN RBL38 TO RBL40. REPAIRED SHEAR WEB AT BS986.5, WL207.8, BETWEEN RBL38 TO RBL40 IAW BOEING DRAWING NR 65C32677.SDR USAA920082074Shear Web · corrodedMCN LAV SPILL MAJOR REPAIR NR 6135577 CORROSION ON SHEAR WEB AT BS1016, WL207.8, LBL19. REPLACED SHEAR WEB AT BS1016, WL207.8, LBL19 IAW B737 SRM 51-40-02-0G.SDR USAA920082073Floorbeam · corrodedMCN LAV SPILL MAJOR REPAIR NR 6135575 CORROSION ON FLOOR BEAM AT BS986.5, WL207.8, BETWEEN RBL40 TO RBL4. REPAIRED FLOOR BEAM AT BS986.5, WL207.8, BETWEEN RBL40 TO RBL4 IAW US AIRWAYS EA NR 130147.SDR USAA2008111792076Crease Beam · corrodedMCN - MAJOR REPAIR - DROP IN MAINTENANCE, CORROSION ON RIGHT CREASE BEAM INNER CHORD AT BS 967, RBL 60, WL 207.8. REPLACED CREASE BEAM INNER CHORD AT BS 967, RBL 60, WL 207.8 IAW B737-300 SRM 51-40-02.SDR USAA2008121992281Angle · crackedSAL - C17 - MAJOR REPAIR - ANGLE ON FLOOR SUPPORT CRACKED AT BS 540, BL 0. REPLACED ANGLE ON FLOOR SUPPORT AT BS 540, BL 0 IAW SRM 51-40-02.SDR USAA2008112492112Floorbeam · corrodedSAL - C17 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT BS 986.5 BETWEEN RBL 43 TO LBL 8. REPLACED FLOORBEAM AT BS 986.5 BETWEEN RBL 43 TO LBL 8 IAW B737 SRM 53-00-51 2R2.SDR SWAA086020Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SRM.SDR USAA2008121892270Vertical Beam · crackedSAL - C17 - MAJOR REPAIR - VERTICAL BEAM WEB CRACKED AT BS 178, WL 183, RBL 5 TO RBL 7. REPAIRED VERTICAL BEAM WEB AT BS 178, WL 183, RBL 5 TO RBL 7 IAW US AIRWAYS EA 132168.SDR USAA920081974Beam · crackedMCN C18 MAJOR REPAIR NR 6132076 VERTICAL BEAM CRACKED AT BS184, WL232, RBL17. REPAIRED VERTICAL BEAM AT BS184, WL232, RBL17 IAW BOEING 737 SRM 53-10-08.SDR SWAA085787Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA085786Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 784, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA085785Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA085784Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR USAA920082070Intercostal · corrodedSAL C21 MAJOR REPAIR NR 6136496 CORROSION ON INTERCOSTAL BETWEEN BS967 TO BS986.5, WL208.1, RBL17.5 IN PASSENGER CABIN. REPAIRED INTERCOSTAL BETWEEN BS967 TO BS986.5, WL208.1, RBL17.5 IAW B737 SRM 51-40-02-0G.SDR USAA2008120292175Web · corrodedSAL - C21 - MAJOR REPAIR - CORROSION ON WEB BETWEEN BS 847 TO BS 867, RBL 21. REPAIRED WEB BETWEEN BS 847 TO BS 867, RBL 21 IAW SRM 51-10-02.
Back to Boeing 737-3G7