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 SWAA072571Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072569Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND RIGHT MLG W/W VERTICAL STIFFENER CRACKED AT BS 663, RBL 6.15. REMOVED AND REPLACED STIFFENER PER ACO.SDR SWAA072505Wire · brokenL1 DOOR EMERGENCY EXIT LIGHT INOP. FOUND GROUND WIRE BROKEN. REPAIRED GROUND WIRE PER MM.SDR AWXA200700624Computer · malfunctionedLAS - ATO - 85-95 KT REJECTED TAKEOFF AT 28C ON RUNWAY 25R DUE TO A FLIGHT CONTROL MASTER CAUTION WARNING INDICATION. MAINTENANCE PERFORMED STEPS 15 THRU E-2 AS OUTLINED IN THE B737-300 AMM 27-31-00-5 AND TESTED THE DIFFERENTIAL PRESSURE SWITCH WITH NO FAULTSDR SWAA072397Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA072396Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR AWXA200700587Light · inoperativePHX - EEL - R1 DOOR EXTERIOR ESCAPE SLIDE EMERGENCY LIGHT INOPERATIVE. REPLACED AND OPERATIONAL CHECKED R1 DOOR EXTERIOR ESCAPE SLIDE EMERGENCY LIGHT ASSEMBLY IAW B737-300 AMM 33-51-02.SDR SWAA072372Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504D, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA072373Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 374, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA072357Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072324Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER 26R CORRODED AT BS 540. REPAIRED STRINGER PER SRM.SDR SWAA072298Bearing · wornDURING SCHEDULED 20Y CHECK, RIGHT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING AND BUSHING PER MM.SDR SWAA072297Bearing · wornDURING SCHEDULED 20Y CHECK, LEFT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING AND BUSHING PER MM.SDR SWAA072285Control Rod · crackedDURING SCHEDULED 20Y CHECK, FOUND RIGHT ELEVATOR TAB CONTROL ROD CRACKED AT DRAIN HOLE. REMOVED AND REPLACED CONTROL ROD PER MM.SDR AWXA200700560Stiffener · crackedPHX - MAJOR REPAIR - RIGHT HAND MAIN LANDING GEAR WHEEL WELL FORWARD BULKHEAD VERTICAL STIFFENER CRACKED, BS 663.75, RBL 6.15, WL 170. REPAIRED RIGHT HAND MAIN LANDING GEAR WHEEL WELL FORWARD BULKHEAD VERTICAL STIFFENER, BS 663.75, RBL 6.15, WL 170 IAW AWA ESDR AWXA200700568Wire · brokenSNA - EEL - EMERGENCY ESCAPE PATH LIGHTS INOPERATIVE FROM SEAT ROW 12 ABC THRU 18 ABC. REPAIRED BROKEN EMERGENCY ESCAPE PATH LIGHT WIRE AT SEAT ROW 18 ABC AND PERFORMED OPERATIONAL CHECK IAW B737-300 AMM 33-51-02.SDR AWXA200700561Attach Fitting · crackedPHX - MAJOR REPAIR - LEFT HAND ELEVATOR TAB PUSH ROD ATTACH FITTING LUG CRACKED, ELEVATOR STATION 32 TO ELEVATOR STATION 39.22. REPLACED LEFT HAND ELEVATOR TAB IAW AWA TASK CARD R6C27007.SDR SWAA072244Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072210Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072209Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072155Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 320, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA072121Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 14L. REPAIRED FRAME PER SRM.SDR SWAA072108Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072109Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072107Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA072055Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072056Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072057Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072029Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071976Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA071998Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA071968Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071942Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA071944Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071943Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071888Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR AWXA200700483Web · crackedMIA - R1 DOOR AFT LOWER CORNER WEB, CRACKED, BS 344, S13R, WL 209.80. REPAIRED R1 DOOR AFT LOWER CORNER WEB, CRACKED, BS 344, S13R, WL 209.80 IAW B737-300 SRM 51-70-13.SDR SWAA071772Window · arcedFLIGHT DECK R2 WINDOW ARCHED AND CRACKED. REMOVED AND REPLACED WINDOW AND HEAT CONTROLLER PER MM.SDR AWXA200700466Frame · crackedMCN - FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME CRACKED, BS 492.50, S24R AT LOWER STOP FITTING. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT, AFT FRAME, BS 492.50, S24R AT LOWER STOP FITTING IAW AWA ER 03-5300-07093-SS2.SDR AWXA200700490Skin · crackedMCN - FOUND CRACKED FUSELAGE SKIN, BS 344, S13R, R1 DOOR CUT OUT LOWER AFT CORNER. REPAIRED FUSELAGE SKIN, BS 344, S13R, R1 DOOR CUT OUT LOWER AFT CORNER IAW B737-300 SRM 53-00-01-01, FIGURE 201.SDR SWAA071672Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071670Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071671Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 717C, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR AWXA200700482Bear Strap · crackedMCN - CRACKED BEAR STRAP, BS 303, S13L, AT LOWER HINGE FITTING ATTACH POINT. REPAIRED BEAR STRAP, BS 303, S13L, AT LOWER HINGE FITTING ATTACH POINT IAW AWA ER 03-5300-07100-SS3.SDR AWXA200700431Spar · crackedMCN - LEFT WING REAR SPAR UPPER CHORD CRACKED, RSS 221. REPAIRED LEFT WING REAR SPAR UPPER CHORD, RSS 221 IAW AWA ER 03-5722-07086-SS4.SDR SWAA071566Skin · crackedDURING SCHEDULED SV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR AWXA200700467Skin · crackedMCN - FUSELAGE SKIN CRACKED, BS 764, S25L. REPAIRED FUSELAGE SKIN, BS 764, S25L IAW B737-300 SRM 53-00-01-2R31.SDR SWAA071500Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RIGHT FWD FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR AWXA200700399Reveal · crackedPHX - AFT CARGO DOOR FORWARD FRAME INTERNAL DOUBLER CRACKED AND DAMAGED. REPLACED AFT CARGO COMPARTMENT DOOR FORWARD FRAME DOUBLER IAW B737-300 SRM 51-40-02. DISCREPANT PART INFORMATION AND LOCATION WILL BE ADDED AFTER MAJOR REPAIR FORM IS RECEIVED AND REVIESDR AWXA200700434Support Channel · crackedMCN - CRACKED VERTICAL STABILIZER SUPPORT STIFFENER CHANNEL, BS 1095, RBL 8.5. REPLACED VERTICAL STABILIZER SUPPORT STIFFENER CHANNEL, BS 1095, RBL 8.5 IAW B737-300 SRM 51-40-02.
Back to Boeing 737-3G7