Boeing 737-7H4
Service difficulty reports · 96,125
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 = '7377H4' 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 = '7377H4' 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 SWAA2023101710942Beam · crackedINNER SKIN CRACKED AFT SIDE 20.5 INCHES FROM BOTTOM. REMOVED FRAME PER SRM 51-40-02 2.P/N 141A6120-6 AND IT SHOULD BE P/N 141A6121-7. LOCATED NEW BEAM PER SRM 51-40-05. 3. INSTALLED NEW BEAM P/N 141A6121-7 PER SRM 51-40-02. 4. INSPECTED WORK ABOVE 5.C/WSDR SWAA2023101610990Slide · looseL1 SLIDE PACK NEEDS TO BE RESECURED.<[01] RE-POSITIONED L1 DOOR SLIDE; CK?S GOOD; REF MT 725-61-06.SDR SWAA2023113010495Retainer · crackedL/W REAR SPAR FIXED T/ E DEFLECTION CONTROL RIB PANEL VERTICAL BULB SEAL RETAINER CRACKED MKD DOT<[01] REMOVED AND REPLACED SEAL RETAINER AT LT WING REAR SPAR FIXED T/E DEFLECTION CONTROL RIB VERTICAL PANEL PER REF B737 SRM 51-40-02-0G-0;[02] VERIFIED STEP 1SDR SWAA2023111010450Strip · corrodedSEVERAL CORROSION SPOTS AT FWD CARGO COMP. RT CAP STRIP FROM STA 500 TO 500D<[01] REPLACED RT CAP STRIP PN 453A1611-5 AT FWD CARGO COMP FROM STA 500 TO 500D AS PER B737-700 AMM 25-52-10-400-801. CAP STRIP INSTALLATION WILL BE ACCOMPLISHED ON FOULT #TTG8Q00NZUPSDR SWAA2023110710601Frame · crackedCRACK FRAME ON BS 312 LOWER CORNER ABOVE CUT-OUT FWD ENTRY DOOR BTW STRG 5L AND STRG 6L APROX AT FWD GALLEY AREA 2023-635531<[01] REPAIRED FRAME ON BS 312 LOWER CORNER ABOVE CUT-OUT FWD ENTRY DOOR BTW STRG 5L AND STRG 6L APROX AT FWD GALLEY AREA IAW EA M-22-15SDR SWAA2023110310486Fitting · corrodedCORROSION ON FWD ENTRY DOOR UPPER HINGE BOX FITTING<[01] REMOVED AND REPLACED FWD ENTRY DOOR UPPER HINGE BOX FITTING IAW SRM 51-40-02 AND DWG #141A8180;[02] VERIFIED CORRECTIVE ACTION 1;[03] VERIFIED MEASUREMENT TABLESDR SWAA2023101910226Light · inoperativeFOUND SEAT ROW 9 AND 11 ABC LEFT HAND EMERGENCY BIN LIGHTS INOP<[01] COMPLETED WORK STEP 1.;[02] CERTIFIED ACTION 2 STEP 2;[03] REPLACED LAMPS ON SEAT ROW 9 AND 11 ABC LEFT HAND EMERGENCY BIN LIGHTS AND CHECKED VOLTAGE ON BOTHS LIGHTS; STILL FAIL PER AMM 33-51SDR SWAA2023101610274Handle · loosePASSENGER CABIN - R1 DOOR INNER HANDLE LOOSE<[01] REMOVED DOOR HANDLE AND COVER ASSY; TIGHTENED DOOR HANDLE ATTACHMENT HARDWARE; INSTALLED DOOR HANDLE AND COVER ASSY. REF: AMM 52-41-00SDR SWAA2023101610340Battery Pack · failedEMX BATT PACK M01668 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01668 PER AMM 33-51-06SDR SWAA2023101610341Battery Pack · failedEMX BATT PACK M01669 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01669 PER AMM 33-51-06SDR SWAA2023101610334Battery Pack · failedEMX BATT PACK M01670 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01670 PER AMM 33-51-06SDR SWAA2023101610342Battery Pack · failedEMX BATT PACK M01673 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01673 PER AMM 33-51-06SDR SWAA2023101610343Battery Pack · failedEMX BATT PACK M01672 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01672 PER AMM 33-51-06SDR SWAA2023101610335Battery Pack · failedEMX BATT PACK M01675 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01675 PER AMM 33-51-06SDR SWAA2023101610344Battery Pack · failedEMX BATT PACK M01674 FAILS CAPACITANCE CHECK<[01] REMOVED AND REPLACED EMX BATT PACK M01674 PER AMM 33-51-06SDR SWAA2023101610669Battery Pack · inoperativeOVERWING EMERGENCY EXIT SIGN DAMAGED.<[01] R&R AFT EXIT SIGN LIGHT ASSY PER AMM 33-51-01. R&R AFT EMERGENCY BATTERY PACK PER AMM 33-51-06. OPS CHECK GOODSDR SWAA2023101610509Battery · inoperativeFORWARD GALLEY EMERGENCY FLASHLIGHT-BLINKING POWER LIGHT INOP<[01] REMOVED AND REPLACED FWD GALLEY UPPER EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00; OPS CHECK GOOD.SDR SWAA2023101610419Girt Bar · looseR1 DOOR SLIDE GIRT BAR BRACKETS LOOSE.<[01] TIGHTENED GIRT BAR BRACKETS PER S.I.P.SDR SWAA2023101610415Girt Bar · looseR1 DOOR AFT GIRT BAR CLIP HAS ONE FASTENER BROKEN R-1 GIRT BAR CLIPS LOOSE<[01] LP 2117729 AP 3846899 C/W INTERIM REPAIR PER EA M-23-125-01839SDR SWAA2023101610284Bulb · inoperativeRH EMERGENCY EXIT LIGHT BULB OVER HANDLE INOP<[01] C/W;[02] RE LAMPED RH EMERGENCY EXIT BULB IAW AMM 33-21-00-201-NGSDR SWAA2023111009910Crease Beam · crackedCRACK ON RT CREASE BEAM STRUCTURE INNER CHORD AT STA 639<[01] REMOVED AND REPLACED CREASE BEAM INNER CHORD AT RT FROM STA 616 TO STA 685 PER B737-700 SRM 51-40-02-0G-0 & DWG# 144A5901.;[02] CERTIFIED WORK STEPS ACCOMPLISHED TO REMOVE AND REPLACE CREASE BEAM INSDR SWAA2023110810151Plate · crackedCRACK PLATE LOCATED BS907 TO BS927 BETWEEN STR25R TO STR27R AT AFT CARGO COMPARTMENT (2 EA) 2023-637784<[01] REPLACED STIFFENER 2(E/A) AND FASTENERS LOC. BS907 TO BS927 BETWEEN STR25R TO STR27R AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 ITEM 9 AND INSTSDR SWAA2023110810150Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BS847 TO BS867 AT LEVEL LBL24 AT AFT CARGO COMPARTMENT 2023-637783<[01] REPLACED WEB-INTERCOSTAL AND FASTENERS LOCATED BS847 TO BS867 AT LEVEL LBL24 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 ; SRM 51-10-02 ITEM 9 AND DWSDR SWAA2023110710262Floorbeam · corrodedCORROSION FLOOR BEAM BS 312 AND LBL 15 APROX AT FWD GALLEY AREA 2023-635502<[01] TOOL USED: ULTRASONIC THICKNESS GAUGE; PN: 45MG; SN: 221861811; DUE DATE: 08-NOV-23;[02] PERFORMED PERMANENT REPAIR ON FLOOR BEAM LOC. BS 312 BTW LBL LBL30 TO BL0 AT FWD GALLEY ARSDR SWAA2023110709959Fitting · deterioratedDETERIORATED SERVICE DOOR HARDWARE AND PLATE GIRT BAR FITTING AT FWD GALLEY AREA 2023-635489<[01] REPLACED SERVICE DOOR HARDWARE AND PLATE GIRT BAR FITTING AT FWD GALLEY AREA I.A.W. B737-700 AMM 25-66-02-400-801.;[02] TASK CARD COMPLETEDSDR SWAA2023110709960Fitting · deterioratedDETERIORATED ENTRY DOOR HARDWARE AND PLATE GIRT BAR FITTING AT FWD GALLEY AREA 2023-635490<[01] REPLACED ENTRY DOOR HARDWARE AND PLATE GIRT BAR FITTING AT FWD GALLEY AREA I.A.W. B737-700 AMM 25-66-02-400-801.;[02] TASK CARD COMPLETEDSDR SWAA2023110709961Fitting · deterioratedDETERIORATED SERVICE DOOR HARDWARE AND PLATE GIRT BAR FITTING AT AFT GALLEY AREA 2023-635491<[01] REPLACED SERVICE DOOR HARDWARE AND PLATE GIRT BAR FITTING AT AFT GALLEY AREA IAW B737-700 AMM 25-66-02-400-801;[02] REPLACED SERVICE DOOR HARDWARE AND PLATE GIRT SDR SWAA2023110709958Fitting · deterioratedDETERIORATED ENTRY DOOR HARDWARE AND PLATE GIRT BAR FITTING AT AFT GALLEY AREA 2023-635492<[01] REPLACED ENTRY DOOR HARDWARE AND PLATE GIRT BAR FITTING AT AFT GALLEY AREA AMM 25-66-02-400-801;[02] REPLACED ENTRY DOOR HARDWARE AND PLATE GIRT BAR FITTING AT AFT SDR SWAA2023110709956Light · deterioratedDETERIORATED STRIP PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING ON SEVERAL POSITIONS AT PASSENGER CABIN (10 EA) 2023-635488<[01] REPLACED STRIP PHOTOLUMINESCENT FLOOR PROXIMITY LIGHTING ON SEVERAL POSITIONS AT PASSENGER CABIN (10 EA) IAW B737-700 AMM 33-51-15-000SDR SWAA2023110710263Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 TO BS 328 AND LBL 46 APROX AT FWD GALLEY AREA 2023-635504<[01] REPLACED WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BETWEEN BS 312 TO BS 328 AND LBL 46 APROX AT FWD GALLEY AREA IAW B737-700 SRM 51-40SDR SWAA2023110710265Floor Support · corrodedCORROSION FLOOR STRUCTURE LOCATED ON INTERCOSTAL BETWEEN BS 986 TO BS 1006 AND LBL 22 APROX AT AFT GALLEY AREA 2023-635495<[01] REPLACED INTERCOSTAL LOCATED FLOOR STRUCTURE BETWEEN BS 986 TO BS 1006 AND LBL 20.70 AT AFT GALLEY AREA IAW B737-700 SRM 51-40-02-0GSDR SWAA2023103010385Battery Pack · failedALL EMERGENCY LIGHTS FAILS TEST; DUE TO STORAGE OF THE AIRCRAFT ALL EMERGENCY LIGHTS FAILS TEST DUE TO STORAGE OF THE AIRCRAFT<[01] REMOVED AND REPLACED SERVICEABLE BATTERY PACKS M1668; M1669; M1670; M1672; M1673; M1674 AND M1675.;[02] VERIFIED CORRECTIVE ACTISDR SWAA2023103010214Stiffener · crackedCRACK INSPAR RIB 120.30 STIFFENER 2 AT RT HORIZONTAL STABILIZER 2023-594703<[01] EDDY CURRENT EQUIPMENT P/N: NORTEC500D; S/N: N500X12101V022237; DUE DATE: 26-JAN-24.;[02] TOOL USED : EDDY CURRENT EQUIPMENT P/N NORTEC500D S/N 00X12101V022237 DUE DATE: 26-JAN-24SDR SWAA2023103010215Stiffener · crackedCRACK INSPAR RIB 120.30 STIFFENER 4 AT RT HORIZONTAL STABILIZER 2023-594704<[01] EDDY CURRENT EQUIPMENT P/N: NORTEC500D; S/N: N500X12101V022237; DUE DATE: 26-JAN-24.;[02] TOOL USED : EDDY CURRENT EQUIPMENT P/N NORTEC500D S/N 00X12101V022237 DUE DATE: 26-JAN-24SDR SWAA2023101310015Seat Back · out of adjustCABIN PASSENGER SEAT RECLINE NOT LOCKED OUT OF EMERGENCY EXIT ROW SEAT 11D.<[01] ADJUSTED SEAT RECLINE AT 11D IAW AMM 25-22-00SDR SWAA2023101309992Seat Back · out of adjustPASSENGER SEAT 10A EMERGENCY EXIT ROW RECLINES AND SHOULD NOT<[01] ADJUSTED HYDRO-LOCK TO THE STOP POSITION PER AMM 25-22-00SDR SWAA2023101209970Battery Pack · failedM1669 FAILED CAPACITY CHECK<[01] R/R M1669 BATTERY PACK PER AMM 33-51-06SDR SWAA2023101209969Battery Pack · failedM1675 FAILED CAPACITY CHECK<[01] R/R M1675 BATTERY PACK PER AMM 33-51-06;[02] R/R M1675 BATTERY PACK PER AMM 33-51-06SDR SWAA2023101209968Battery Pack · failedM1672 FAILED CAPACITY CHECK<[01] R/R M1672 BATTERY PACK PER AMM 33-51-06SDR SWAA2023101209967Battery Pack · failedM1673 FAILED CAPACITY CHECK<[01] R/R M1673 BATTERY PACK PER AMM 33-51-06SDR SWAA2023101209966Battery Pack · failedM1674 FAILED CAPACITY CHECK<[01] R/R M1674 BATTERY PACK PER AMM 33-51-06SDR SWAA2023101210006Slide · out of adjustR2 DOOR SLIDE LOWER FLAP REQUIRES REPOSITION.<[01] REPOSITIONED R2 DOOR SLIDE LOWER FLAP PER MT 725-66-01SDR SWAA2023101209971Seal · cracked-LH HORIZONTAL STABILIZER FWD UPPER SLIDING SEAL CRACKED<[01] REMOVED AND REPLACED LH HORIZONTAL STAB FWD UPPER SLIDING SEAL PER AMM 53-31-31SDR SWAA2023101209972Seal · cracked-LH HORIZONTAL STABILIZER LOWER SLIDING SEAL CRACKED<[01] REMOVED AND REPLACED LH HORIZONTAL STAB LOWER SLIDING SEAL PER AMM 53-31-31SDR SWAA2023101209986Seal · cracked-RH HORIZONTAL STABILIZER LOWER FWD SLIDING SEAL CRACKED<[01] REMOVED AND REPLACED RH HORIZONTAL STAB LOWER FWD SLIDING SEAL PER AMM 53-31-31SDR SWAA2023110809826Intercostal · crackedCRACK ON UPPER ANGLE OF WEB INTERCOSTAL LOCATED ON FLOOR STRUCTURE BTW BS 380 TO BS 400 AND APROX BL0 ON PAX CABIN 2023-637759<[01] REPLACED UPPER ANGLE OF WEB INTERCOSTAL LOCATED ON FLOOR STRUCTURE BTW BS 380 TO BS 400 AND APROX BL0 ON PAX CABIN I.A.W B737-70SDR SWAA2023110809962Stringer · crackedCRACK STRINGER 25R LOCATED BS540 AT FWD CARGO COMPARTMENT 2023-637779<[01] TOOL USED: ULTRASONIC THICKNESS GAUGE; PN: 45MG; SN: 221861811; DUE DATE: 08-NOV-23;[02] EDDY CURRENT EQUIPMENT USED P/N: NORTEC 600D; S/N: 220273012 AND DUE DATE: 17-DEC-23.;[03] TOOL SDR SWAA2023110709828Gusset · crackedFWD CARGO BAY GUSSET CRACKED AT BS 500D STR 19L<[01] REMOVED AND REPLACED GUSSET ON FCB;AT BS500D;STR19L.IAW SRM 51-40-02 AND DWG# 143A7902.;[02] UPDATED PARTS USAGE;[03] VERIFIED JOB COMPLETE<BR><BR>VERIFIED MEASUREMENT TABLESDR SWAA2023110709827Gusset · crackedFWD CARGO BAY GUSSET CRACKED AT BS 500D STR 19R<[01] REMOVED AND REPLACED GUSSET ON FCB;AT BS500D;STR19R;IAW SRM 51-40-02 AND DWG#143A7902.;[02] VERIFIED JOB COMPLETE<BR><BR>VERIFIED MEASUREMENT TABLESDR SWAA2023110709824Scuff Plate · crackedCRACK FWD CORNER SCUFF PLATE AT FWD CARGO COMPARTMENT 2023-635459<[01] TOOL USED DIGITAL CALIPER P/N:500-197-30;S/N:B20189510;DUE DATE:26-DEC-23.;[02] TOOL USED: RADIOMETER PHOTOMETER P/N: XRP-3000; S/N: 1859843; CAL DUE DATE: 05-DEC-23;[03] REPAIRED THE FWD C
Back to Boeing 737-7H4