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 SWAA2014100332600Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440 STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014100332599Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400 STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014100232551Angle · crackedLEFT WING UPPER WING SUPPORT UNDER PANEL 5735 26 INCHES AFT RS & 8 UP FROM NR 3 FLAP TRACK ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014100232550Angle · crackedLEFT WW CUT OUT FWD CURVED ANGLE CRACKED ON TOP CORNER. R & R ANGLE IAW SRM.SDR SWAA2014100232549Strap · crackedE & E COMPARTMENT FLOOR SUPPORT STRAP CRACKED AT BS 328 RT SIDE. REPAIRED STRAP IAW SRM.SDR SWAA2014100232548Door Frame · crackedR1 DOOR CRACKED LOWER EDGE FRAME CRACKED AT AFT LOWER CORNER STOP FITTING. R & R DOOR IAW AMM.SDR SWAA2014102233305Stringer · crackedSTRINGER CRACKED AT BS 375 STRINGER 14L. REPAIRED STRINGER IAW SRM.SDR SWAA2014100332575Stop Fitting · crackedL1 DOOR FRAME STOP FITTING CRACKED AT BS 348.2 STRINGER 16L. R & R FITTING IAW SRM & DWG.SDR SWAA2014100232527Control Valve · failedAIR TURN BACK ON CLIMB OUT LE TRANSIT LIGHT STAYED ON. LE SLATS FAILED TO RETRACT. R & R AUTO SLAT CONTROL VLV IAW MM.SDR SWAA2014093032469Sign · brokenFORWARD ENTRY EMER EXIT SIGN BROKEN. R & R SIGN IAW AMM.SDR SWAA2014093032448Battery · dischargedLEFT AFT FLASHLIGHT IN AFT GALLEY INOPERATIVE. R & R BATTERY IAW SIP.SDR SWAA2014102233226Skin · corrodedFUSELAGE SKIN CORRODED BETWEEN BS 747 TO 767 BETWEEN STRINGER 27R TO 27L. REPAIRED SKIN IAW EA.SDR SWAA2014093032449Skin · delaminatedLEFT WING OTBD AFT FLAP LOWER SURFACE DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014102233227Skin · crackedSKIN CRACKED AT BS 381 STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2014101032860Shear Tie · crackedFUSELAGE FRAME SHEAR TIE CRACKED AT STATION 360 STRINGER 13R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014100732723Tip Cap · crackedLEFT HORIZONTAL STABILIZER OTBD TIP CRACKED. REPAIRED TIP IAW SRM.SDR SWAA2014100232564Shear Tie · crackedSHEAR TIE CRACKED AT BS 360 BETWEEN STRINGER 14L TO 15L. R & R SHEAR TIE IAW DWG.SDR SWAA2014093032488Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 597 STRINGER 7L. R & R CLIP IAW SRM & DWG.SDR SWAA2014092932394Blower · faultyDIVERSION SULFUR SMELL IN CABIN UPON DEPARTURE. R & R MAIN EQUIPMENT COOLING FAN BLOWER IAW MM.SDR SWAA2015032637880Threshold · crackedAFT CARGO DOOR CUT OUT CTR THRESHOLD CRACKED AT FWD END. REPAIRED THRESHOLD IAW EA.SDR SWAA2014110533772Stringer · crackedSTRINGER CRACKED AT BS 727 STRINGER 1L. REPAIRED STRINGER IAW EA.SDR SWAA2014110533756Skin · crackedSKIN CRACKED AT BS 727 STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014093032447Charger · inoperativeLEFT OVERWING EMER EXIT LOWER LIGHT INOPERATIVE. R & R CHARGER IAW AMM.SDR SWAA2014092932358Stiffener · crackedRIGHT WING AILERON 2ND HINGE STIFFENER CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2014092932357Angle · crackedRIGHT WING TE INBD UPPER PANEL ANGLE BRACKET CRACKED. REPAIRED ANGLE IAW DWG & SRM.SDR SWAA2014092932356Cover · out of adjustLEFT EMER EXIT CUT OUT LIGHT LENS COVER OUT OF ADJUSTMENT. ADJUSTED COVER IAW AMM.SDR SWAA2014092932352Light · inoperativeFORWARD LAVATORY WALL EMER LIGHT BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2014092632337Control Valve · faultyAIR TURN BACK, DURING FLAP RETRACTION OTBD SLAT REMAINED EXTENDED. R & R LE DEVICE CONTROL VLV IAW MM.SDR SWAA2014103033519Shear Tie · damagedSHEAR TIE DAMAGED AT BS 887, BETWEEN STRINGER 1 TO 2L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014102233290Stringer · crackedSTRINGER CRACKED AT BS 841 STRINGER 1. REPAIRED STRINGER IAW SRM.SDR SWAA2014102033135Stringer · crackedSTRINGER CRACKED AT BS 900 STRINGER 3L. REPAIRED STRINGER IAW SRM.SDR SWAA2014093032487Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 767 STRINGER 11L. R & R CLIP IAW DWG.SDR SWAA2014093032470Lug · brokenLEFT WING GND SPOILER NR 4 OTBD MAIN ATTACH LUG BROKEN. R & R NR 4 GND SPOILER IAW AMM.SDR SWAA2014092632328Bracket · crackedRIGHT WING BRACKET CRACKED AT INBD OF INBD FLAP OTBD TRACK FAIRING. R & R BRACKET IAW SRM.SDR SWAA2014100732718Angle · crackedRIGHT WING LOWER L ANGLE FOR AILERON WHIPPER PANEL CRACKED AT INBD END AT RSS 529. R & R L ANGLE IAW SRM & DWG.SDR SWAA2014100332598Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360 STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014092632339Filter · dirtyFLIGHT ATTENDANT REPORTED SMELLING BURNED RUBBER SMELL DURING CRUISE. R & R RECIRCULATION FAN FILTER IAW MM.SDR SWAA2014092632326Fairing · delaminatedRIGHT WING INBD FLAP OTBD TRACK FAIRING INBD SIDE DELAMINATED. REPAIRED FAIRING IAW SRM.SDR SWAA2014092532308Fastener · missingR1 DOOR EMER EVAC SLIDE AFT GIRT BAR HOLDER ON SLIDE COVER MISSING FASTENER. INSTALLED FASTENER IAW SRM.SDR SWAA2014092532305Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE IAW MT.SDR SWAA2014102233222Seat Track · corrodedSEAT TRACK CORRODED AT BS 996 RBL 18. R & R SEAT TRACK IAW SRM.SDR SWAA2014092932348Light · inoperativeLEFT FLUORESCENT LIGHTS BETWEEN ROWS 4 TO ROWS 7 WENT OUT & PRODUCED A STRONG ACRID SMELL & LIGHT SMOKE. R & R LIGHT IAW MM.SDR SWAA2014102233225Skin · crackedAFT CGO DOOR SKIN CUT OUT FWD LOWER CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014101032859Shear Tie · corrodedFUSELAGE FRAME SHEAR TIE CORRODED AT STATION 500 STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014100732710Skin · crackedLEFT WING FIXED LE SKIN CRACKED LOCATED AT STATION 208.00. REPAIRED SKIN IAW EA.SDR SWAA2014100332597Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500A BETWEEN LBL 2 TO RBL 2. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014093032468Attach Fitting · crackedLOWER RT WING TO BODY FAIRING ATTACH TEE CHORD CRACKED AT BS 727. R & R CHORD IAW DWG.SDR SWAA2014092932353Skin · corrodedFUSELAGE SKIN CORRODED AT BS 227 RBL 8. REPAIRED SKIN IAW EA.SDR SWAA2014092232133Attach Fitting · missingR2 DOOR EMER EVAC SLIDE GIRT BAR FLOOR ATTACH POINTS MISSING. INSTALLED ATTACH POINTS IAW AMM.SDR SWAA2014092232162Attach Fitting · missingL2 DOOR EMER EVAC SLIDE GIRT BAR FLOOR ATTACHMENT POINTS MISSING. INSTALLED ATTACHMENT POINTS IAW AMM.
Back to Boeing 737-3H4