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 USAA920081875Frame · crackedMCN C18 MAJOR REPAIR NR 6131828 FRAME CRACKED AT BS380, BETWEEN S8R & S9R. REPAIRED FRAME AT BS380, BETWEEN S8R & S9R IAW TASK CARD NR M1C53002.SDR USAA920081737Wedge · delaminatedMAJOR REPAIR, RT WING INBOARD MIDFLAP TRAILING EDGE WEDGE DELAMINATED AT WBL 108.5 THRU WBL 111.5. REPAIRED RT WING INBOARD MIDFLAP TRAILING EDGE WEDGE AT WBL 108.5 THRU 111.5 IAW 51-70-10-2R4.SDR USAA922081772Intercostal · corrodedMCN - MAJOR REPAIR - C18 CHECK, LEVEL 2 CORROSION ON INTERCOSTAL, BS 986.5, RBL 38, WL 208. REPLACED INTERCOSTAL, BS 986.5, RBL 38, WL 208 IAW B737 SRM 51-40-02.SDR USAA920081777Threshold · corrodedMCN - MAJOR REPAIR - C18 C-CHECK, LEVEL 2 CORROSION ON THE R1 DOOR THRESHOLD INNER CHORD, BS 277 - BS360, S17R, WL 208 IAW B737-300 SRM 51-40-02.SDR USAA920081799Angle · crackedC-18 CHECK - CRACKED ANGLE, BS 290, S11R. REPLACED ANGLE, BS 290, S11R IAW SRM 51-40-02. (K)SDR USAA920081804Angle · crackedC-18 CHECK - NR 6131710, CRACKED ANGLE, BS 290, S10R. REPLACED ANGLE, BS 290, S10R IAW SRM 51-40-02. (K)SDR USAA920081805Angle · crackedC-18 CHECK - NR 6131761, CRACKED ANGLE, BS 290, S11R. REPLACED ANGLE, BS290, S11R IAW SRM 51-40-02. (K)SDR USAA920081806Angle · crackedC-18 CHECK - NR 6131764, CRACKED ANGLE, BS 290, S13R. REPLACED ANGLE, BS 290, S13R IAW SRM 51-40-02. (K)SDR USAA920081811Angle · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED ANGLE, BS 290, S12R. REPLACED ANGLE, BS 290, S12R IAW B737 SRM 51-40-02 AND BOIENG DWG 65-45807.SDR USAA920081931Tee Fitting · crackedMCN C18 MAJOR REPAIR NR 6131670 R1 DOOR CUTOUT AFT FRAME INTERCOSTAL IS CRACKED AT STOP FITTING AT BS 332.1, S8R, WL270. REPAIRED R1 DOOR CUTOUT AFT FRAME INTERCOSTAL STOP FITTING AT BS 332.1, S8R, WL270 IAW US AIRWAYS EA NR 130127.SDR USAA920081932Intercostal · crackedMCN C18 MAJOR REPAIR NR 6131670 R1 DOOR CUTOUT AFT FRAME INTERCOSTAL IS CRACKED AT STOP FITTING AT BS 332.1, S8R, WL270. REPAIRED R1 DOOR CUTOUT AFT FRAME INTERCOSTAL STOP FITTING AT BS 332.1, S8R, WL270 IAW US AIRWAYS EA NR 130127.SDR USAA920081719Skin · debondedMCN - C18 - MAJOR REPAIR, NR 6 SLAT DISBONDED ON UPPER SURFACE AT SLAT STA 326.80 TO 329.5. REPAIRED NR 6 SLAT AT SLAT STA 326.8 TO 329.5 IAW B737 SRM 51-70-10-2R4.SDR USAA920081711Stringer Clip · crackedMCN - C18 - MAJOR REPAIR, STRINGER TIE CLIP CRACKED BS 663.75, S10R. REPLACED STRINGER TIE CLIP BS 663.75, S10R IAW B737 SRM 51-40-02-0G.SDR USAA920081710Intercostal · crackedMCN - C18 - MAJOR REPAIR, INTERCOSTAL CRACKED BS 540, LBL 2. REPLACED INTERCOSTAL BS 540, LBL 2 IAW B737 SRM 51-40-05-0G & 51-40-04-0G.SDR USAA920081709Intercostal · crackedMCN - C18 - MAJOR REPAIR, INTERCOSTAL CRACKED BS 520, WL 208, RBL 2. REPLACED INTERCOSTAL BS 520, WL 208, RBL 2 IAW B737 SRM 51-40-05-0G & 51-40-04-0G.SDR USAA920081769Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED UPPER STUB FRAME, BS 294.5, S7R, WL 276. REPLACED UPPER STUB FRAME, BS 294.5, S7R, WL 276 IAW B737-300 SRM 51-40-02.SDR USAA920081771Spoiler · debondedMCN - MAJOR REPAIR - C18 CHECK, LT WING NR 2 SPOILER DEBONDED, WS 304.53 - WS 353.53. REPAIRED LT WING NR 2 SPOILER DEBONDED, WS 304.53 - WS 353.53 IAW B737-300 SRM 51-70-10-2R4 FIGURE 201.SDR USAA920081739Hinge Pin · corrodedMCN - MAJOR REPAIR, LT HORIZONTAL STAB INNER HINGE PIN CORRODED AT BS 1154. REPLACED LT HORIZONTAL STAB INNER HINGE PIN AT BS 1154 IAW AMERICA WEST TASK CARD I6C55039.SDR USAA920081738Hinge Pin · corrodedMCN - MAJOR REPAIR, RT HORIZONTAL STAB OUTER HINGE PIN CORRODED AT BS 1154. REPLACED HORIZONTAL STAB OUTER HINGE PINS AT BS 1154 IAW AMERICA WEST TASK CARD I6C55039.SDR USAA920081743Hinge Pin · corrodedMCN - MAJOR REPAIR, RT HORIZONTAL STAB OUTER HINGE PIN CORRODED AT BS 1154. REPLACED HORIZONTAL STAB OUTER HINGE PINS AT BS 1154 IAW AMERICA WEST TASK CARD I6C55039.SDR USAA920081736Strap · crackedMCN - C18 - MAJOR REPAIR, 2 CRACKS ON FLOORBEAM STABILIZER STRAP AT BS 328, BL 0. REPAIRED FLOORBEAM STABILIZER STRAP AT BS 328, BL 0 IAW B737 SRM 53-10-51-2R4SDR USAA920081729Strap · crackedMCN - C18 - MAJOR REPAIR, FLOORBEAM STABILIZER STRAP CRACKED AT BS 312, LBL11.10. REPAIRED FLOORBEAM STABILIZER STRAP AT BS 312, LBL 11.10 IAW B737 SRM 53-10-51-2R4SDR USAA920081778Skin · crackedMCN - MAJOR REPAIR - C18 CHECK, L1 DOOR INNER SKIN CRACKED AT BS 340, S11L. REPAIRED L1 DOOR INNER SKIN CRACKED AT BS 340, S11L IAW B737-300 SRM 51-70-13-0G FIGURE 1.SDR USA2008F00031Wire · brokenMAINT REPORTED THE EMERGENCY ESCAPE PATH LIGHT ON SEAT ROW 22, LT SIDE, INOPERATIVE. MAINT TROUBLESHOT AND FOUND A BROKEN WIRE. OPERATIONAL CHECK GOOD. (K)SDR USA2008F00030Charger · inoperativeMAINT REPORTED THE EXTERIOR EMERGENCY ESCAPE SLIDE LIGHT, AFT OF R2 DOOR, FAILS TO ILLUMINATE. MAINT INSTALLED A NEW CHARGER ASSY INCLUDING BATTERY PACK (M1137). OPS CHECK GOOD. (K)SDR USAA920081741Tee Fitting · crackedSAL - C19 - NR 5 SLAT TEE CHORD CRACKED AT SLAT A STATION 124 TO 254.4. REPLACED TEE CHORD ON NR 5 SLAT STATION 124 TO 254.4 IAW B737 SRM 51-10-02.SDR USAA920081922Pressure Panel · crackedMCN C18 MAJOR REPAIR NR 6131676 MLG WW PRESSURE WEB CRACKED AT BS 663.75. WL204, LBL40. REPAIRED MLG WW PRESSURE WEB AT BS 663.75, WL204, LBL40 IAW US AIRWAYS EA NR 130128.SDR USA2008F00033Megaphone · inoperativeMAINT REPORTED THE AFT CABIN MEGAPHONE INOPERATIVE. MAINT REMOVED AND REPLACED THE AFT CABIN MEGAPHONE. OPS CHECK GOOD. (K)SDR USAA920081895Stringer Clip · crackedMCN C18 MAJOR REPAIR NR 6131871. STRINGER CLIP CRACKED AT BS 867, S9L. REPLACED STRINGER CLIP AT BS 867, S9L IAW B737 SRM 51-40-02-OG.SDR USAA920081675Flashlight · inoperativeFORWARD FLIGHT ATTENDANT FLASH LIGHT IN-OP. REPLACED FORWARD FLIGHT ATTENDANT FLASH LIGHT. (K)SDR USAA920081665Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, 9R. REPAIRED STRINGER CLIP AT BS 380, 9R IAW SRM 51-40-01-0G. (K)SDR USAA920081817Web · crackedSAL - C17 - MAJOR REPAIR, CRACKS ON WEB AT AFT CARGO COMPARTMENT FLOOR STRUCTURE BETWEEN BS 787 TO BS 847 S25R TO 26R. REPLACED WEB AT AFT CARGO COMPARTMENT FLOOR STRUCTURE BETWEEN BS 787 TO BS 847 S25R TO 26R IAW B737 SRM 51-10-0G AND BOEING DRAWING 6547-957SDR SWAA084909Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SWA EA.SDR USAA920081728Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 500A HAS A .451 INCH CRACK BETWEEN S8L & S9L. REPAIRED FRAME AT BS 500A BETWEEN S8L & S9L IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081727Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 747 HAS A .471 INCH CRACK BETWEEN S8L & S9L. REPAIRED FRAME AT BS 747 BETWEEN S8L & S9L IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081726Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 867 HAS A .395 INCH CRACK BETWEEN S8L & S9L AND A .489 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 867 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081725Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 827 HAS A .435 INCH CRACK BETWEEN S8L & S9L AND A .426 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 827 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081724Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 727D HAS A .389 INCH CRACK BETWEEN S8L & S9L AND A .496 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 727D BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081723Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 500C HAS A .409 INCH CRACK BETWEEN S8L & S9L AND A .383 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 500C BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081722Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 480 HAS A .410 INCH CRACK BETWEEN S8L & S9L AND A .371 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 480 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR MIC53002.SDR USAA920081721Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 440 HAS A .431 INCH CRACK BETWEEN S8L & S9L AND A .471 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 440 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR M1C53002.SDR USAA920081720Frame · crackedSAL - C17 -MAJOR REPAIR, FRAME AT BS 400 HAS A .475 INCH CRACK BETWEEN S8L & S9L AND A .481 INCH CRACK BETWEEN S8R & S9R. REPAIRED FRAME AT BS 400 BETWEEN S8L & S9L, ALSO BETWEEN S8R & S9R IAW AMERICA WEST AIRLINES TASK CARD NR MIC53002.SDR USAASB08073Light · defectivePHX THE EMERGENCY ESCAPE PATH LIGHTING WAS DIM AT ROWS 5-9 AND INOPERATIVE AT ROW 10. MX REPLACED THE LIGHT ASSEMBLY AT ROW 10. OPS CHECK NORMAL.SDR USAA920081614Stringer · crackedMCN C18 MAJOR REPAIR NR 6124275 STRINGER CRACKED AT BS380, S15L. REPAIRED STRINGER AT BS380, S15L OAW B737 SR, 53-30-03-2R1.SDR USAA920081602Floorbeam · corrodedSAL C19 MAJOR REPAIR NR 6097669 CORROSION ON FLOORBEAM BETWEEN BS 986.5 & BS 1006, RBL 15. REPAIRED FLOOR BEAM BETWEEN BS 986.5 & BS 1006, RBL15 IAW B737 SRM 53-00-51-2R.SDR USAA920081689Shear Web · crackedSAL C17 MAJOR REPAIR NR 6093420 CORROSION ON SHEAR WEB BETWEEN BS827 TO BS847, S17L. REPLACED SHEAR WEB BETWEEN BS827 TO BS847, S17L IAW B737 SRM 51-10-02-OG.SDR USAA920081682Support · corrodedSAL C17 MAJOR REPAIR NR 6091621 CORROSION ON SUPPORT BS947 5 INCHES, RBL8. REPLACED SUPPORT BS947 5 INCHES, RBL8 IAW B737 SRM 51-10-02-OG.SDR USAA920081593Wire · brokenMCN - CORROSION EEL - EMERGENCY LIGHT AT SEAT 10 LT IS INOP. REPAIRED BROKEN WIRE AT SEAT 10 LT EMERGENCY LIGHT IAW B737 BSWPM 20-15-02-5 & B737 AMM 33-51-02-5.SDR SWAA084789Battery · inoperativeAFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR USAA920081649Bulkhead · crackedSAL C19 MAJOR REPAIR NR 6093461. CRACK FOUND ON BULKHEAD AT CENTER CIRCUMFERENTIAL TEAR STRAP AT BS1016, S7R. REPAIRED BULKHEAD AT CENTER CIRCUMFERENTIAL TEAR STRAP AT BS1016, S7R IAW B737 SRM 53-8-08 FIGURE 1201, DETAIL III.
Back to Boeing 737-3G7