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 USAA920081684Frame · corrodedSAL C14 MAJOR REPAIR NR 6097545 GALVANIC CORROSION ON FRAME AT BS787. BETWEEN S24L TO S25L. REPAIRED FRAME AT BS787 BETWEEN S24L TO S25L IAW B737 SRM 51-70-11-OG. UPON FURTHER EVALUATION FOUND THIS DISCREPANCY TO BE LEVEL 2 CORROSION.SDR USAA920081754Skin · delaminatedSAL - MAJOR REPAIR - C17 CHECK, DELAMINATING ON RT WING INBOARD FOREFLAP UPPER SURFACE, WBL 73- WBL 184.275. REPAIRED RT WING INBOARD FOREFLAP UPPER SURFACE, WBL 73- WBL 184.275 IAW B737-300 SRM 51-10-2RSDR USAA920081758Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 727D, S9L. REPAIRED FRAME, BS 727D, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081759Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 380, S9R. REPAIRED FRAME, BS 380, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081760Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081761Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 520, S9R. REPAIRED FRAME, BS 520, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081765Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 480, S9L AND S9R. REPAIRED FRAME, BS 480, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081766Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 500A, S9L AND S9R. REPAIRED FRAME, BS 500A, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081767Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 867, S9L AND S9R. REPAIRED FRAME, BS 867, S9L AND S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081764Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 907, S9R. REPLACED FRAME, BS 907, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081762Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 787, S9R. REPLACED FRAME, BS 787, S9R IAW B737 US AIRWAYS TASK CARD M1C53002.SDR USAA920081763Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081779Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS 400, S9L. REPAIRED FRAME BS400, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081780Frame · crackedMCN - MAJOR REPAIR - C18 CHECK, CRACKED FRAME, BS440, S9L. REPAIRED FRAME BS440, S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA920081672Stiffener · crackedANGLE STIFFENER CRACKED AT BS 289, S11R, WL253 BELOW R1 DOOR CUT OUT. REPLACED ANGLE STIFFENER AT BS 289, S11R, WL253 BELOW R1 DOOR CUTOUT IAW EA 13011. (K)SDR USAA9200816AAStiffener · crackedANGLE STIFFENER CRACKED AT BS 289, S12R, WL 241 ABOVE WEB ATR1 DOOR CUTOUT. REPLACED ANGLE STIFFENER AT BS 289, S12R, WL 241 ABOVE WEB AT R1 DOOR CUTOUT IAW EA 130111. (K)SDR USAA920081670Stiffener · crackedATTACH ANGLE CRACKED ABOVE WEB AT R-1 DOOR CUTOUT AT BS 289, S13R, WL 235. REPLACED ATTACH ANGLE ABOVE WEB AT R-1 DOOR CUTOUT AT BS 289, S13R, WL 235 IAW EA NR 130111. (K)SDR USAA920081647Stringer Clip · crackedMCN C18 MAJOR REPAIR NR 6124317 STRINGER TIE CRACKED AT BS380, S15L. REPLACED STRINGER TIE AT BS380, S15L IAW B737 SRM 51-40-05-OG.SDR USAA920081612Stringer Clip · crackedMCN C18 MAJOR REPAIR NR 6124318 CRACKED STRINGER CLIP AT BS 480, S16L. REPLACED STRINGER CLIP AT BS 460, S16R IAW SRM 51-40-02-OG.SDR USAA920081611Stringer Clip · crackedMCN C18 MAJOR REPAIR NR 6124320 CRACKED STRINGER CLIP AT BS 460 S16R. REPLACED STRINGER CLIP AT BS 460, S16R IAW B737 SRM 51-40-02-OG.SDR USAA920081843Floorbeam · corrodedSAL - C19 - MAJOR REPAIR, CORROSION ON FLOORBEAM UPPER CHORD AT BS 986.5, BETWEEN LBL 44 TO RBL 42. REPAIRED FLOORBEAM UPPER CHORD AT BS 986.5, BETWEEN LBL 44 TO RBL 42 IAW B737 SRM 53-00-51.SDR USAA920081734Strap · corrodedSAL - C19 - MAJOR REPAIR, CORROSION ON STRAP BETWEEN BS 947 TO 986.5, RBL48. REPAIRED STRAP BETWEEN BS 947 TO 986.5, RBL48 IAW B737 SRM 51-70-11-0G.SDR USAA920081733Skin · crackedMCN - C18- MAJOR REPAIR, 2 CRACKS IN FUSELAGE SKIN ABOVE L1 DOOR CUTOUT UPPER FWD CORNER BS 312, AT S7L & S8L. REPAIRED FUSELAGE SKIN ABOVE L1 DOOR CUTOUT UPPER FWD CORNER BS 312, AT S7L & S8L IAW US AIRWAYS EA NR 130115.SDR USAA920081756Skin · delaminatedSAL - MAJOR REPAIR - C19 CHECK, RT WING OUTBOARD FOREFLAP UPPER SURFACE DELAMINATED, WBL 202.6 -WBL 414.4. REPAIRED RT WING OUTBOARD FOREFLAP UPPER SURFACE, WBL 202.6 - WBL 414.4 IAW B737-300 SRM 57-70-2R.SDR USAA920081757Web · corrodedSAL - MAJOR REPAIR - C19 CHECK, CORROSION ON WEB, BS 947 -BS 986.5, LBL48. REPAIRED WEB, BS 947 - BS 986.5, LBL48 IAW B737-300 SRM 51-70-11.SDR USAA920081677Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN BS 986.5 TO 1006, RBL 15. REPAIRED FLOORBEAM IAW SRM 53-00-51. (K)SDR USAA920081673Web · crackedPRESSURE WEB CRACKED AT BS 665.75 WL 200, LBL 32. REPAIRED PRESSURE WEB AT BS 665.75, WL 200. (K)SDR USAA920081650Shear Web · crackedSAL C19 MAJOR REPAIR NR 6097658 CRACK ON SHEAR WEB BETWEEN BS927 & BS847 BLO. REPAIRED SHEAR WEB BETWEEN BS927 & BS847 BLO IAW B737 SRM 51-10-02.SDR USAA920081657Floorbeam · corrodedSAL C19 MAJOR REPAIR NR 6097659 GALVANIC CORROSION ON FLOOR BEAM UPPER CORD AT BS967, RBL 28. REPAIRED FLOOR BEAM UPPER CORD AT BS967, RBL28 IAW B737 SRM 53-00-51.SDR USAA920081627Web · corrodedSAL - C19 MAJOR REPAIR - GALVANIC CORROSION ON WEB AT BS 1016, RBL 3, WL 208. REPAIRED WEB AT BS 1016, RBL 3, WL 208 IAW B737 SRM TYPICAL REPAIR 51-70-03.SDR USAA920081626Floor Support · corrodedSAL - C19 MAJOR REPAIR GALVANIC CORROSION ON CABIN FLOORBEAM BETWEEN BS 986.5 AND BS 1006, LBL 15. REPAIRED CABIN FLOORBEAM BETWEEN BS 986.5 AND BS 1006, LBL 15 IAW SRM 51-70-12.SDR USAA920081581Web · crackedMCN A1 MAJOR REPAIR NR 6123918 CRACK ON SHEAR WEB AT BS986 TO 1016, S17R. WL208. REPLACED SHEAR WEB AT BS986 TO 1016, S17R. WL208 IAW B737 SRM 51-40-02-OG.SDR USAA920081703Plate · crackedSAL - C19 - MAJOR REPAIR, CRACK ON SUPPORT PLATE AROUND POTABLE WATER SERVICE PANEL BS 947.5, S25L. REPAIRED SUPPORT PLATE AROUND POTABLE WATER SERVICE PANEL BS 947.5, S25L IAW B737 SRM 51-40-02 & BOEING DRAWING NR 65-51626.SDR USAA920081676Channel · corrodedCORROSION ON CHANNEL BETWEEN BS 727B AND BS 747, LBL 3. REPAIRED CHANNEL BETWEEN BS 727B AND BS 747, LBL 3 IAW SRM 53-00-53. (K)SDR USAA920081680Frame · crackedEXFOLIATION CORROSION ON FRAME AT BS 867, BL 0. REPAIRED FRAME AT BS 867, BL 0 IAW SRM 53-00-07-2R.SDR USAA920081652Doubler · crackedMCN C19 MAJOR REPAIR NR 6124653. FRAME DOUBLER CRACKED AT BS303.9, S16L, WL216. REPLACED FRAME DOUBLER AT BS303.9, S16L, WL216 IAW B737 SRM 51-40-02-OG.SDR USAA920081580Structure · corrodedMCN A1 MAJOR REPAIR NR 6123918 CORROSION ON INNER CHORD AT BS960 TO BS990. S17R, WL208. REPLACED INNER CHORD AT BS960 TO BS990, WL208 IAW B737 SRM 51-40-02-OG.SDR USAA920081620Link · crackedSAL C17 MAJOR REPAIR NR 6090106 MOUNTED BRACKET OF SNUBBER CRACKED ON AFT ENTRY DOOR. REPLACED LINK ASSEMBLY FOR LOWER HINGE MOUNTED SNUBBER AT AFT ENTRY DOOR IAW B737 AMM 52-13-41.SDR USAA920081589Floorbeam · corrodedMCN - CORROSION MAJOR REPAIR - CORROSION ON FLOORBEAM AT FASTENER HOLES AT BS 986, RBL 15, BL 0, LBL 16. REPLACED FLOORBEAM AT BS 986, LBL 60 TO RBL 60 IAW US AIRWAYS EA NR 130099.SDR USAA920081588Floor Support · corrodedMCN CORROSION MAJOR REPAIR NR 4420136 & 6124059 CORROSION ON FLOOR SUPPORT AT BS967, RBL8. REPLACED FLOOR SUPPORT AT BS967, RBL8 IAW B737 SRM 51-40-02-0G.SDR SWAA084595Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR USAA920081744Skin · crackedSAL - MAJOR REPAIR - C19 CHECK, LT HORIZONTAL STAB LOWER SURFACE SKIN CRACKED AT PREVIOUS REPAIR, STABILIZER STATIONS 132.1 - 175.5. REPAIRED LT HORIZONTAL STAB LOWER SURFACE SKIN AT PREVIOUS REPAIR, STABILIZER STATIONS 132.1 - 175.5. IAW ER 03-5516-02339-ESSDR USAA920081755Skin · crackedSAL - MAJOR REPAIR - C19 CHECK, CRACKED FUSELAGE SKIN, BS 375, S10L. REPAIRED FUSELAGE SKIN, BS 375, S10L IAW US AIRWAYS EA 100110A.SDR USAASB08063Splice · brokenPHX - MAINTENANCE REPORTED THE EMERGENCY EXIT LIGHTS FROM SEAT ROWS 18 TO 23, LT, INOPERATIVE. MAINTENANCE REPAIRED A SPLICE. OPERATIONAL CHECK OF EMERGENCY LIGHTS GOOD. (S)SDR USAA920081587Frame · crackedMCN C19 MAJOR REPAIR NR 6124540 L2 DOORWAY LOWER FORWARD STUB FRAME CRACKED AT BS 957. WL216. LBL60. REPLACED L2 DOORWAY LOWER FORWARD STUB FRAME AT BS 957, WL216, LBL60 IAW B737 SRM 51-40-02-0G.SDR USAA920081618Skin · crackedMCN C19 MAJOR REPAIR NR 6124118 - CRACK IN FUSELAGE SKIN AT BS961, S17L. REPAIRED FUSELAGE SKIN AT BS961, S17L IAW B737 SRM 53-00-01-2R-32.SDR USAA920081617Bulkhead · crackedMCN C19 MAJOR REPAIR NR 6124120 - CRACK IN DOME WEB AT BS 1016, S6L. REPAIRED DOME WEB AT BS 1016, S6L IAW EA NR 130098.SDR USAA920081632Floorbeam · corrodedMCN C19 MAJOR REPAIR NR 6124249 - EXFOLIATION CORROSION ON TRANSVERSE BEAM AT BS986.5, WL208, RBL16. REPAIRED TRANSVERSE BEAM AT BS986.5, WL208, RBL16 IAW US AIRWAYS EA NR 130100.SDR USAA920081552Floor Support · corrodedMCN-C19 -MAJOR REPAIR- GALVANIC CORROSION ON FLOOR SUPPORT AT BS 967 TO BS 986.5 RBL 18. REPLACED FLOOR SUPPORT AT BS 967 TO BS 986.5 RBL 18 IAW B737 SRM 53-60-51-1A1. (S)SDR USAA920081541Plate · corrodedMCN-C19 -MAJOR REPAIR- EXFOLIATION CORROSION ON SEAL PLATE AT BS 947, S26L TO S26R. REPAIRED SEAL PLATE AT BS 947, S26L TO S26R IAW B737 SRM 51-40-02-0G. (S)
Back to Boeing 737-3G7