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 SWAA081806Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 3L. REPAIRED BELTFRAME PER SRM.SDR SWAA081805Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 2L. REPAIRED BELTFRAME PER SRM.SDR SWAA081804Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 663, STR 1. REPAIRED BELTFRAME PER SRM.SDR USAA920080733Seal · tornFLT 70 - PHX-SEA - CREW REPORTED AFTER LEVELING OFF AT FL340, RECEIVED A "CABIN ALTITUDE WARNING HORN" FOLLOWED BY A RISE IN CABIN PRESSURE ALTITUDE. CREW DESCENDED TO FL 200 AND DECLARED AN EMERGENCY. CREW DIVERTED TO LAS. CABIN WAS NOT PREPPED. THE LANDISDR SWAA081772Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA081773Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA081755Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081756Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 344, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081757Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA081758Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081759Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 663, STR 3L. REPAIRED STRINGER SPLICE PER SRM.SDR USAA920080714Skin · crackedCLT - MAJOR REPAIR -B-CHECK - .5 INCH CRACK ON RT HORIZ STAB LWR SKIN AT STA 125 - 128 AT REAR SPAR. REPAIRED IAW EA 100338, US AIRWAYS TYPICAL REPAIR 55-10-07, REV C.SDR USAA920080726Light · inoperativeFLT 592 - SEA - CREW REPORTED FWD F/A FLASHLIGHT WORKS BUT NEGATIVE FLASHING TEST LIGHT INOP. MX REPLACED THE FWD F/A FLASHLIGHT. OPERATIONAL CHECK WAS GOOD.SDR SWAA081677Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081678Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081679Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081680Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081681Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081668Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081665Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081664Stringer Splice · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081667Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081666Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA081669Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081619Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081618Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA081617Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 433 AND BS 448, LBL 3 AND RBL 2. REPAIRED SKIN PER SWA EA.SDR USAA920080749Shear Web · corrodedMCN - MAJOR REPAIR - C18 CHECK - CORROSION ON CABIN SHEAR WEB, BS 616 - BS 639, S17L, WL 208. REPLACED CABIN SHEAR WEB, BS 616 - BS 639, S17L, WL 208 IAW B737 SRM 53-60-13.SDR USAA920080744Attach Angle · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED ATTACH ANGLE, BS 500D, BL 0, WL 208. REPLACED ATTACH ANGLE, BS 500D, BL 0, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080673Skin · crackedPHX - MAJOR REPAIR - FOUND CRACKED FUSELAGE SKIN, BS 840, S18R. REPAIRED FUSELAGE SKIN, BS 840, S18R IAW B737 SRM 53-00-01 REPAIR 31.SDR SWAA081559Battery Pack · dischargedDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA081558Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN R1 DOOR CUTOUT UPPER FWD CORNER CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA081557Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING INBOARD FORE FLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081556Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR USAA920080672Door Frame · crackedCLT - MAJOR REPAIR - B4 CHECK - AFT CARGO COMPARTMENT DOOR CUT OUT AFT FRAME CRACKED, BS 847, S21R. REPAIRED AFT CARGO COMPARTMENT DOOR CUT OUT AFT FRAME, BS 847, S21R - S24R IAW USAIRWAYS EA 100315SDR USAA920080645Skin · crackedPHX - MAJOR REPAIR - OVERNIGHT CHECK - CRACKED FUSELAGE SKIN, BS 727E, S23L. REPAIRED FUSELAGE SKIN, BS 727E, S23L IAW B737 SRM 53-00-01 REPAIR 31.SDR USAA920080741Cover · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED INTERCOSTAL WEB / COVER, BS 540, RBL 24 - RBL 44, WL 208. REPLACED INTERCOSTAL WEB / COVER, BS 540, RBL 24 - RBL 44, WL 208 IAW B737 SRM 51-40-02.SDR USAA920080644Skin · crackedPHX - MAJOR REPAIR - WEEKLY - CRACKED FUSELAGE SKIN, BS 907, S4L. REPAIRED FUSELAGE SKIN, BS 907, S4L IA155AWW B737 SRM 53-00-01 REPAIR 31.SDR USAA920080752Sill · corrodedMCN - MAJOR REPAIR - C18 CHECK - LEVEL 2 CORROSION ON THE R2 DOOR CUTOUT LOWER SILL WEB, BS 986.5, RBL 60, WL 207. REPLACED THE R2 DOOR CUTOUT LOWER SILL WEB, BS 986.5, RBL 60, WL 207 IAW B737 SRM 51-40-02.SDR USAA920080751Crease Beam · corrodedMCN - MAJOR REPAIR - C18 CHECK - LEVEL 2 CORROSION ON THE R2 DOOR CUTOUT LOWER SILL CREASE BEAM INNER CHORD, BS 990 - BS 996, RBL 48 - RBL 51, WL 208. REPLACED THE R2 DOOR CUTOUT LOWER SILL CREASE BEAM INNER CHORD, BS 990 - BS 996, RBL 48 - RBL 51, WL 208 IASDR SWAA081451Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512D, STR 26R. REPAIRED SKIN PER SWA EA.SDR SWAA081471Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 335, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA081420Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081421Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR USAA920080629Wire · shortedFLT 391 - LAS - MX REPORTED EMERGENCY LIGHTS ROW 5-10 INOP. MX DISCOVERED LAMP PINS AT ROW 10 GROUNDED OUT. MX REPAIRED WIRES AND RE-LAMPED. OPERATIONAL TEST WAS GOOD.SDR USAA920080772Shear Tie · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED SHEAR TIE, BS 360, S14L - S15L. REPLACED SHEAR TIE, BS 360, S14L - S15L IAW B737 SRM 51-40-02.SDR USAA920080682Reveal · crackedMCM - MAJOR REPAIR-C18- R-1 DOOR CUTOUT FWD UPPER REVEAL CRACKED. REPLACED REVEAL IAW SRM 51-40-02-0G, FIG 3.SDR USAA920080748Skin · debondedMCN - MAJOR REPAIR - C18 CHECK - RIGHT WING NR 8 SPOILER UPPER SURFACE HAS AREA OF DISBOND, WS 425 - WS 434. REPAIRED RIGHT WING NR 8 SPOILER UPPER SURFACE HAS AREA OF DISBOND, WS 425 - WS 434 IAW B737 SRM 51-70-10-2R REPAIR 4.SDR USAA920080747Stringer · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER, BS 500C, S8R. REPAIRED STRINGER, BS 500C, S8R IAW B737 SRM 53-00-03-2R3.SDR USAA920080746Stringer · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED STRINGER, BS 500C, S16R. REPAIRED STRINGER, BS 500C, S16R IAW AWA ER 03-5312-01094-DD1.
Back to Boeing 737-3G7