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 SWAA2014022525521Wedge · delaminatedRT WING INBD MID FLAP TE WEDGE DELAMINATED. R & R WEDGE IAW SRM.SDR SWAA2014022425460Light · missingG4 GALLEY EMERGENCY EXIT LIGHT ASSEMBLY MISSING. INSTALLED LIGHT ASSEMBLY IAW AMM.SDR SWAA2014021925307Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014022725631Web · damagedAFT CARGO BAY DOOR CUTOUT CLOSURE WEB DAMAGED AT BS 790, RBL 27. R & R WEB IAW DRAWING & SRM.SDR SWAA2014021825261Oil Tank · faultyDIVERSION OIL PRESS NOTED TO CHANGE WITH PRESS ALTITUDE OF CRUISE N2 SETTINGS, FL 370 + 18 PSI, FL 340 = 22 PSI FL 260 = 30 PSI, FL 100 = 40 PSI. R & R NR 1 ENG OIL TANK IAW MM.SDR SWAA2014030525783Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014030325686Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 348.2, STRINGER 16L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014022525522Lens · looseFWD ENTRY LOWER EMERGENCY EXIT LENS COVER LOOSE. R & R COVER IAW MM.SDR SWAA2014031225988Skin · crackedRT BS 380+10 UPPER FWD WINDOW CORNERS SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031225984Skin · crackedRT BS 400+10 UPPER FWD WINDOW CORNERS SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030525782Strap · crackedSTRAP CRACKED BETWEEN BS 348.2 TO BS 351.2, STRINGER 16L. R & R STRAP IAW SRM & EA.SDR SWAA2014030325691Stringer · corrodedSTRINGER CORRODED AT BS 1016, STRINGER 25L. R & R STRINGER IAW DRAWING.SDR SWAA2014030325685Angle · crackedANGLE CRACKED BETWEEN BS 348.2 TO BS 351.2, STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725218Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014021725188Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014031025906Structure · crackedNOSE WW CRACKED AT BS 258 RT SIDE UNDER DOUBLER. REPAIRED NOSE WW IAW SRM.SDR SWAA2014030725840Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030725839Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 348.2, STRINGER 16L. R & R WEB IAW SRM.SDR SWAA2014030425733Channel · corrodedCHANNEL CORRODED BETWEEN BS 727D TO BS 727E, BL 0. R & R CHANNEL IAW EA.SDR SWAA2014022625557Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014021925326Flashlight · inoperativeAFT GALLEY FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR SWAA2014021825266Filter · dirtyBURNING ELECTRICAL SMELL AT MID CABIN. TURNED OFF RECIRCULATING FAN, SMELL DISSIPATED. THIS WAS AT CRUISE 29K. FOUND PRE FILTER DIRTY, R & R PRE FILTER IAW MT.SDR SWAA2014021825277Angle · crackedLT WING FIXED TE ANGLE CRACKED AT WS 537.806. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725199Lens · looseFWD OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. REPAIRED LENS ASSEMBLY IAW SIP.SDR SWAA2014021725189Door Frame · crackedR1 DOOR LOWER FRAME CRACKED AT AFT LOWER STOP ATTACH POINT. R & R R1 DOOR ASSEMBLY IAW MM.SDR SWAA2014030325706Attach Angle · crackedHORIZONTAL STABILIZER ATTACH ANGLE ON LOWER WEB CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022425459Sign · crackedL1 DOOR EMERGENCY EXIT LIGHT SIGN BASE ASSEMBLY CRACKED. R & R SIGN IAW AMM.SDR SWAA2014022025334Stiffener · crackedLT WING NR 3 FLAP TRACK INTERNAL AREA STIFFENER CRACKED. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2014021725205Channel · crackedCHANNEL CRACKED AT BS 727, BETWEEN RBL 3 TO LBL 3. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014021425153Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STRINGER 7R. R & R CLIP IAW DRAWING & SRM.SDR SWAA2014031726138Stiffener · corrodedSTIFFENER CHANNEL CORRODED AT BS 1016, LOWER HOLE IN RT 186. REPAIRED STIFFENER IAW SRM.SDR SWAA2014030625820Floorbeam · corrodedFLOOR BEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN LBL 5 TO RBL 43. REPAIRED CHORD IAW EO & EA.SDR SWAA2014030625819Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014030625818Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014030325705Angle · crackedFWD ENTRY DOOR TIE CLIP ANGLE CRACKED AT BS 348.20, STRINGER 15L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022725609Angle · crackedL1 DOOR CUTOUT TIE CLIP ANGLE CRACKED AT BS 360, STRINGER 11L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014022625556Reveal · crackedFWD ENTRY DOOR CUT OUT REVEAL CRACKED AT BS 348. R & R REVEAL IAW SRM & DRAWING.SDR SWAA2014022625555Support Fitting · crackedSUPPORT FITTING CRACKED AT BS 333, STRINGER 8R. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014022425469Forging · crackedLT BS 747+10 WINDOW FORGING CRACKED AT HOLE NR 7. R & R FORGING IAW DRAWING.SDR SWAA2014022025333Tie Clip · crackedTIE CLIP CRACKED AT BS 1006, STRINGER 15L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021925323Crease Beam · corrodedCREASE BEAM OUTER CHORD CORRODED BETWEEN BS 772 TO BS 776, STRINGER 17L. REPAIRED CHORD IAW SRM.SDR SWAA2014021925306Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014021925296Cusp Web · corrodedCUSP WEB CORRODED AT BS 770, STRINGER 17L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021925292Stop Fitting · crackedFWD ENTRY DOOR UPPER AFT STOP POST CRACKED IN UPPER RADIUS. R & R POST IAW SRM.SDR SWAA2014021825265Bracket · crackedLT WING FIXED TE BRACKET CRACKED AT WS 531. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014021825264Fitting · crackedCLIP CRACKED AT BS 344, STRINGER 11R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014021825263Nut Clip · crackedSPACER NUT CLIP CRACKED AT BS 1006, BETWEEN STRINGER 10L TO STRINGER 11L. R & R CLIP IAW SRM.SDR SWAA2014021725204Angle · crackedRT HORIZONTAL STABILIZER ACCESS PANEL 9226R ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725203Retainer · crackedLT WING FIXED TE RETAINER CRACKED AT WBL 183.40. R & R RETAINER IAW SRM & DRAWING.SDR SWAA2014021725202Support Angle · crackedAFT SUPPORT ANGLE CRACKED AT BS 328, LBL 45.6. R & R ANGLE IAW SRM & DRAWING.
Back to Boeing 737-3H4