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 AWXA200700892Cusp Web · corrodedMCN - MAJOR REPAIR - C-20 CHECK - NR 5962157, CORROSION ON CUSP WEB, BS 787 - BS 807, S17L. REPLACED CUSP WEB, BS 787 - BS 807, S17L IAW B737-300 SRM 51-40-02.SDR AWXA200700849Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961326, CRACKED STRINGER CLIP, BS 787, S24R. REPLACED STRINGER CLIP, BS 787, S24R IAW B737-300 SRM 51-40-02.SDR AWXA200700848Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961321, CRACKED STRINGER CLIP, BS 727B, S23R. REPLACED STRINGER CLIP, BS 727B, S23R IAW B737-300 SRM 51-40-02.SDR AWXA200700841Shear Web · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961270, CRACKED CREASE BEAM WEB, BS 559 - BS 578, S17L, WL 208. REPLACED CREASE BEAM WEB, BS 559 - BS 578, S17L, WL 208 IAW B737-300 SRM 51-40-02.SDR AWXA200700840Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961325, CRACKED STRINGER TIE CLIP, BS 787, S21R. REPLACED STRINGER TIE CLIP, BS 787, S21R IAW B737-300 SRM 51-40-02.SDR AWXA200700839Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961277, CRACKED STRINGER TIE CLIP, BS 706, S11L. REPLACED STRINGER TIE CLIP, BS 706, S11L IAW B737-300 SRM 51-40-02.SDR AWXA200700827Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR# 5961290, CRACKED STRINGER CLIP, BS 520, S16L. REPLACED STRINGER CLIP, BS 520, S16L IAW B737-300 SRM 51-40-02.SDR AWXA200700818Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 663, S10L. REPLACED STRINGER CLIP, BS 663, S10L IAW B737-300 SRM 51-40-02.SDR AWXA200700817Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 578, S10L. REPLACED STRINGER CLIP, BS 578, S10L IAW B737-300 SRM 51-40-02.SDR AWXA200700816Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR# 5961269, CRACKED STRINGER CLIP, BS 380, S1. REPLACED STRINGER CLIP, BS 380, S1 IAW B737-300 SRM 51-40-02.SDR AWXA200700813Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 578, S9L. REPLACED STRINGER CLIP, BS 578, S9L IAW B737-300 SRM 51-40-02.SDR AWXA200700810Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961271, CRACKED STRINGER CLIP, BS 578, S11L. REPLACED STRINGER CLIP, BS 578, S11L IAW B737-300 SRM 51-40-02.SDR AWXA200700934Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981847, CRACKED FRAME, BS 727E, S9R. REPAIRED FRAME, BS 727E, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700925Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981451, CRACKED FRAME, BS 887, S9R. REPAIRED FRAME, BS 887, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700924Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981843 AND 5981849, CRACKED FRAME, BS 827, S9L AND S9R. REPAIRED FRAME, BS 827, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700923Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981845 AND 5981452, CRACKED FRAME, BS 907, S9L AND S9R. REPAIRED FRAME, BS 907, S9L AND S9R IAW USAIRWAYS EA 120121.SDR AWXA200700921Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981844, CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700920Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981850, CRACKED FRAME, BS 867, S9R. REPAIRED FRAME, BS 867, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700919Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981841, CRACKED FRAME, BS 787, S9L. REPAIRED FRAME, BS 787, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700916Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981848, CRACKED FRAME, BS 767, S9R. REPAIRED FRAME, BS 767, S9R IAW USAIRWAYS EA 120121.SDR AWXA200700915Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981840, CRACKED FRAME, BS 767, S9L. REPAIRED FRAME, BS 767, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700914Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981842, CRACKED FRAME, BS 807, S9L. REPAIRED FRAME, BS 807, S9L IAW USAIRWAYS EA 120121.SDR AWXA200700972Skin · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981803, RUDDER LEADING EDGE SKIN CRACKED, LEFT SIDE, RUDDER STATION 4.5. REPAIRED RUDDER LEADING EDGE SKIN, LEFT SIDE, RUDDER STATION 4.5. IAW USAIRWAYS 120134.SDR AWXA200700879Skin · debondedMCN - MAJOR REPAIR - C-20 CHECK - NR 5961251, LEFT WING SPOILER NR 1 LOWER SURFACE HAS AREA OF DISBOND, WS 384 - WS 390. REPAIRED LEFT WING SPOILER NR 1 LOWER SURFACE, WS 384 - WS 390 IAW B737-300 SRM 51-70-10-2R4.SDR AWXA200700846Shear Web · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982112, CRACKED CUSP SHEAR WEB, BS 540 - BS 559, S17R. REPLACED CUSP SHEAR WEB, BS 540 - BS 559, S17R IAW B737-300 SRM 51-40-02.SDR AWXA200700830Shear Tie · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982117, CRACKED SHEAR TIE, BS 360, S14L - S15L. REPLACED SHEAR TIE, BS 360, S14L - S15L IAW B737-300 SRM 51-40-02.SDR AWXA200700828Attach Fitting · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982114, CRACKED INTERCOSTAL TO FRAME ATTACH CLIP ( CHANNEL), BS 360, S6L. REPLACED INTERCOSTAL TO FRAME ATTACH CLIP ( CHANNEL), BS 360, S6L IAW B737-300 SRM 51-40-02.SDR AWXA200700821Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982105, CRACKED STRINGER CLIP, BS 685, S2L. REPLACED STRINGER CLIP, BS 685, S2L IAW B737-300 SRM 51-40-02.SDR AWXA200700820Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982103, CRACKED STRINGER CLIP, BS 639, S2L. REPLACED STRINGER CLIP, BS 639, S2L IAW B737-300 SRM 51-40-02.SDR AWXA200700819Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 639, S4L. REPLACED STRINGER CLIP, BS 639, S4L IAW B737-300 SRM 51-40-02.SDR AWXA200700814Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 616, S5R. REPLACED STRINGER CLIP, BS 616, S5R IAW B737-300 SRM 51-40-02.SDR AWXA200700812Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - CRACKED STRINGER CLIP, BS 706, S2R. REPLACED STRINGER CLIP, BS 706, S2R IAW B737-300 SRM 51-40-02.SDR AWXA200700811Stringer Clip · crackedMCN - MAJOR REPAIR - CRACKED STRINGER CLIP, BS 578, S11R. REPLACED STRINGER CLIP, BS 578, S11R IAW B737-300 SRM 51-40-02.SDR AWXA200700808Stringer Clip · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5982109, CRACKED STRINGER CLIP, BS 639, S4R. REPLACED STRINGER CLIP, BS 639, S4R IAW B737-300 SRM 51-40-02.SDR AWXA200700941Skin · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981414, CRACKED L1 DOOR INNER SKIN, BS 348 AT THE NR 4 STOP. REPAIRED L1 DOOR INNER SKIN, BS 348 AT THE NR 4 STOP IAW USAIRWAYS EA 120113.SDR AWXA200700908Door Frame · crackedMCN - MAJOR REPAIR - C-20 CHECK - NR 5981344 AND 5981345, R1 DOOR AFT FRAME CRACKED, BS 328, WL 250 AT THE 3RD AND 4TH STOP FITTING. REPAIRED R1 DOOR AFT FRAME, BS 328, WL 250 AT THE 3RD AND 4TH STOP FITTING IAW USAIRWAYS EA120112.SDR AWXA200700956Power Supply · inoperativeMCN - EEL - C-20 CHECK - NR 5981248, FORWARD GALLEY EMERGENCY FLASHLIGHT IS INOPERATIVE. REPLACED FORWARD GALLEY FLASHLIGHT POWER SUPPLY AND FLASHLIGHT.SDR SWAA073226Tire · separatedNR 1 MAIN TIRE TREAD SEPARATED. R&R NR 1 MAIN WHEEL AND TIRE ASSY PER MM. R&R NR 4 GROUND SPOILER AND LT INBOARD FWD FLAP PER MM.SDR AWXA200700771Connector · damagedEMERGENCY EXIT LIGHTS ROWS 12 THRU 17 INOP. MX REPINED THE CONNECTOR. OPERATIONAL CHECK WAS GOOD.SDR SWAA073078Tab · wornDURING SCHEDULED C4 CHECK, FOUND RT WING AILERON TAB OUTBOARD HINGE FITTING WORN. REMOVED AND REPLACED AILERON TAB PER MM.SDR SWAA073077Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 925, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA073076Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 415, STR 16L. REPAIRED SKIN PER SWA EA.SDR AWXA200700754Battery Pack · inoperativeSEA - EEL - EMERGENCY PATHWAY LIGHTS FROM ROW 20 TO 23 INOP. MX FOUND BATTERY POWER PACK FUSES BAD. MX REPLACED THE FUSES. OPERATIONAL CHECK WAS GOOD.SDR AWXA200700739Flashlight · failedDFW - EEL - FWD FLIGHT ATT EMERG FLASH LIGHT BRACKET BROKEN. MX REPLACED FWD RT EMERGENCY FLASHLIGHT AND BRACKET. OPERATIONAL CHECK WAS GOOD.SDR SWAA072774Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR AWXA200700681Flashlight · inoperativeYYC - CREW REPORTED FORWARD EMERGENCY FLASHLIGHT NOT CHARGING (RED LED NOT BLINKING) MX PLACED ON MEL. MX REMOVED AND REPLACED FLASHLIGHT AND CLEARED MEL.SDR AWXA200700680Skin · crackedPHX - FUSELAGE SKIN CRACKED JUST ABOVE S10L, BS 460. REPAIRED FUSELAGE SKIN JUST ABOVE S10L, BS 460 IAW B737-300 SRM 53-00-01-2R-31 DETAIL XIX.SDR AWXA200700656Lamp · shortedPHX - EEL - EMERGENCY EXIT LIGHTS ARE INOPERATIVE AT SEAT ROWS 8, 12, 13, 14, 15, 16 AND 17. REPLACED AND OPERATIONAL CHECKED LAMP ASSEMBLY AT SEAT ROW 13 IAW AWA TASK CARD A1C33008.SDR SWAA072572Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072573Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.
Back to Boeing 737-3G7