Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2013111822543Skin · crackedLT BS 867+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1. REPAIRED SKIN IAW EA.SDR SWAA2013111822542Skin · crackedLT BS 847+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1. REPAIRED SKIN IAW EA.SDR SWAA2013111822541Skin · crackedLT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013111822540Skin · crackedLT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3,5 & 9. REPAIRED SKIN IAW EA.SDR SWAA2013111822531Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822530Skin · crackedLT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822529Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822528Skin · crackedRT BS 867+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822527Skin · crackedRT BS 847+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822526Skin · crackedRT BS 807+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822525Skin · crackedRT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3 & 9. REPAIRED SKIN IAW SB.SDR SWAA2013111822524Skin · crackedRT BS 847+10 UP AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111322328Skin · crackedRT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013111322329Stringer Clip · delaminatedSTRINGER CLIP DELAMINATED AT BS 986.5, STRINGER 6R. R &R CLIP IAW SRM & BAC DRAWING.SDR SWAA2013111122105Post · crackedCAPTAINS WINDOW "C" POST CRACKED 0.62 LONG FROM UPPER RADIUS. REPAIRED POST IAW SRM.SDR SWAA2013111122059Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2013110722027Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. R & R SLIDE IAW MT.SDR SWAA2013120322897Support Fitting · crackedLT WING SUPPORT FITTING CRACKED AT WBL 149.25. REPAIRED FITTING IAW EA.SDR SWAA2013112622764Support Angle · crackedCRACK ON SUPPORT ANGLE INTERNAL AREA OF ACCESS AREA OF ACCESS PANEL 5858R, NR 2 ENG. R & R ANGLE IAW SRM.SDR SWAA2013112622763Fitting · crackedCRACK ON FITTING AT BS 727, STRINGER 27L. R & R FITTING IAW SRM.SDR SWAA2013112222710Support Angle · crackedL1 DOOR SUPPORT ANGLE CRACKED AT UPPER AFT CORNER. R & R ANGLE IAW SRM.SDR SWAA2013112222709Fitting · crackedFITTING CRACKED AT BS 727 STRINGER 27R, INBD AFT CARGO COMPARTMENT. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013112122645Structure · crackedLT RAM AIR EXHAUST DUCT INTERNAL STRUCTURE CRACKED. REPAIRED STRUCTURE IAW EA.SDR SWAA2013111822425Support Fitting · crackedRT WING TE SUPPORT FITTING CRACKED AT WBL 84.64. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013111822424Support Fitting · crackedLT WING TE SUPPORT FITTING CRACKED ON WBL 84.64. R & R FITTING IAW SRM & DRAWING.SDR SWAA2013111822522Slat · delaminatedRT WING NR 4 SLAT TE DELAMINATED INBD END. REPAIRED NR 4 SLAT IAW SRM.SDR SWAA2013111122134Web · crackedWEB CRACKED BETWEEN BS 500B TO BS 500C, STRINGER 26R. R & R WEB IAW SRM & DRAWING.SDR SWAA2013111122133Web · crackedWEB CRACKED BETWEEN BS 500A TO BS 500B, STRINGER 26R. R & R WEB IAW SRM & DRAWING.SDR SWAA2013110722008Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2013120923074Shear Tie · corrodedFWD CARGO COMPARTMENT SHEAR TIE AFT FACE CORRODED AT BS 520, BETWEEN STRINGER 27L TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013120322929Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2013120322920Web · crackedWEB CRACKED AT BS 500D, STRINGER 19L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013112222708Angle · crackedANGLE CRACKED AT BS 927, STRINGER 20L AFT, CARGO COMPARTMENT. REPAIRED ANGLE IAW SRM.SDR SWAA2013112122633Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 25R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013111822423Angle · crackedL1 DOOR SURROUND STRUCTURE CLIP ANGLE CRACKED AT BS 348.8, STRINGER 15L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111122145Doubler · crackedRT WING INBD SIDE FORE FLAP OTBD INTERNAL DOUBLER CRACKED AT LEVEL WBL 220.00. R & R DOUBLER IAW SRM & DRAWING.SDR SWAA2013110521953Actuator · crackedDECLARED EMERGENCY HYDRAULIC A FAILURE. FOUND LT OTBD GROUND SPOILER ACTUATOR CRACKED. R & R BOTH FILTERS & SPOILER ACTUATOR IAW AMM.SDR SWAA2013110521950Wire Harness · faultyDECLARED EMERGENCY NR 1 FUEL QUANTITY INDICATOR CLIMBED TO 10.8 THEN DESCENDED TO "0". FMC FUEL QUANTITY ERRATIC. NR 2 FUEL QUANTITY APPEARED TO BE DECREASING AT AN ABNORMAL RATE. R & R NR 1 FUEL TANK TSO & HARNESS IAW MM.SDR SWAA2013110521974Gasper Fan · faultyBURNING SMELL IN THE CABIN WHILE DESCENDING. FOUND GASPER FAN EMITTING ELECTRIC SMELL & NOISE. R & R GASPER FAN IAW MM.SDR SWAA2013120322928Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013120222837Frame · corrodedFRAME CORRODED AT BS 727B, BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013112622762Angle · crackedCRACK ON ANGLE LOCATED AT BS 500C, LBL 21.8 AT FWD CARGO COMPARTMENT. R & R ANGLE IAW SRM.SDR SWAA2013112622761Frame · corrodedFUSELAGE FRAME CORRODED AT BS 727C, STRINGER 22L TO STRINGER 26L. REPAIRED FRAME IAW SRM.SDR SWAA2013111822430Plate · crackedVERTICAL STABILIZER ACCESS PANEL 9502 PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013111822422Angle · crackedANGLE CRACKED AT BS 807, STRINGER 25R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111422357Support Angle · corrodedSUPPORT ANGLE CORRODED ON INTERNAL AREA OF LT EMERGENCY EXIT HATCH. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013111422356Tie Clip · crackedTIE CLIP CRACKED AT BS 500B, STRINGER 19L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013111322298Angle · crackedANGLE CRACKED AT BS 947.5, STRINGER 22R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110722014Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REPAIRED LENS IAW MM.SDR SWAA2013110521997Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. R & R SLIDE IAW SWA MT.
Back to Boeing 737-3H4