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 SWAA2014041127031Lens · looseFWD EEPLS LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014041127028Slide · looseL2 DOOR ESCAPE SLIDE LOOSE. ADJUSTED SLIDE IAW MM.SDR SWAA2014050727754Skin · crackedFORWARD ENTRY DOOR AFT LOWER CUT OUT CORNER CRACKED AT BS 344, STRINGER 17L. REPAIRED CUT OUT IAW SRM.SDR SWAA2014050727753Structure · crackedLEFT WING LOWER CHORD CRACKED AT RRS 537, 806 TE AREA OF AILERON & CONTROL TAB. R & R CHORD IAW SRM & DWG.SDR SWAA2014050227608Seat Track · crackedCENTER WING BOX SEAT TRACK CRACKED AT BS 727B, LBL 45.57+1. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2014050227607Web · crackedUPPER FLOORBEAM ANGLE OF WEB CRACKED BETWEEN BS 500D TO BS 520, BL 0. R & R WEB IAW SRM & DWG.SDR SWAA2014050227606Support Angle · crackedSUPPORT ANGLE CRACKED AT BETWEEN BS 927 TO BS 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042227273Floorbeam · crackedUPPER FLOORBEAM ANGLE CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042227268Frame · crackedFRAME CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014042127233Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 375 TO BS 376, STRINGER 8L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014042127232Skin · crackedFUSELAGE SKIN CRACKED AT BS 500+14, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014041627152Skin · crackedFUSELAGE SKIN CRACKED AT BS 500+14, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014041427078Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 480, STRINGER 16R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041127038Light · faultyACRID SMELL WITH SMOKE & FUMES IN COCKPIT BY FIRST OFFICER`S OVERHEAD. R & R FIRST OFFICER`S MAP & KIT LIGHT ASSEMBLY.SDR SWAA2014041027025Window · faultyCLIMBING THRU FL290 FIRST OFFICER & THE CAPTAIN DETECTED AN ACRID SMELL. THE FIRST OFFICER SAW A VERY THIN LAYER OF LIGHT GRAY SMOKE IN THE VICINITY OF HIS OVERHEAD UTILITY LIGHT. SMOKE & FUMES IMMEDIATELY BEGAN TO DISSIPATE. NO ELEC ARCING OR OTHER EVIDENCSDR SWAA2014041027005Attach Bracket · crackedRIGHT WING HYD & FIRE EXIT LINES STAND ATTACH BRACKET CRACKED AT GND SPOILER INBD ACTUATOR LOWER ATTACH POINT. R & R BRACKET IAW SRM.SDR SWAA2014041026981Lens · looseRIGHT EMERGENCY EXIT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014050527682Skin · crackedRIGHT BS 887+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050527669Frame · crackedFRAME CRACKED AT BS 520, STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014050527668Angle · crackedRIGHT WING TE ANGLE CRACKED AT LEVEL RSS 533+13 INCHES. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050527667Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014050527666Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STRINGER 24R TO STRINGER 25R. R & R FRAME IAW SRM & DWG.SDR SWAA2014050227605Web · corrodedWEB CORRODED BETWEEN BS 460 TO BS 480, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014050227604Angle · crackedANGLE CRACKED BETWEEN BS 927 TO BS 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014050227603Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 24R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014050227602Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014050227601Rib · crackedRIGHT HORIZONTAL STABILIZER ACCESS PANEL 9249R RIB CRACKED. R & R RIB IAW SRM & DWG.SDR SWAA2014043027540Angle · crackedVERTICAL STABILIZER ANGLE CRACKED AT ACCESS PANEL 9503. R & R ANGLE IAW SRM & DWG.SDR SWAA2014043027571Skin · crackedRIGHT BS 520+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042927518Forging · crackedRIGHT BS 887+10, CRACKED AT HOLE NR 8 IN LOWER FWD CORNER. R & R FORGING IAW DWG.SDR SWAA2014042927517Forging · crackedRIGHT BS 887+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED FORGING IAW SRM.SDR SWAA2014042927512Flap · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014042827438Frame · crackedFRAME CRACKED AT BS 500B, STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014042827432Frame · crackedFRAME INNER CHORD CRACKED AT BS 500B, STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014042327330Skin · crackedRIGHT BS 360+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042227259Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014042127250Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042127249Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042127248Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042127247Skin · crackedRIGHT BS 500B+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042127246Skin · crackedRIGHT BS 520+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014042127245Skin · crackedRIGHT BS 500C+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014042127241Skin · crackedRIGHT BS 500B+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014041427071Plate · crackedRIGHT HORIZONTAL STABILIZER ACCESS PANEL 9226R PLATE CRACKED. R & R PLATE IAW SRM.SDR SWAA2014041026995Cover · looseFORWARD EMERGENCY EXIT COVER LOOSE. SECURED COVER IAW MM.SDR SWAA2014050727752Crossbeam · crackedAFT CARGO DOOR CROSSBEAM E & D T CHORDS CRACKED. REPAIRED T CHORD IAW EA.SDR SWAA2014050727744Crossbeam · crackedAFT CARGO DOOR CROSSBEAM WEB CRACKED. REPAIRED WEB IAW EA.SDR SWAA2014050527665Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+7.5, RBL 25.8. REPAIRED BEAM IAW EA.SDR SWAA2014042827456Support Angle · corrodedSUPPORT ANGLE CORRODED AT BS 440 + 14, STRINGER 18R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042227258Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 344, BETWEEN STRINGER 26R TO STRINGER 27R. R & R SHEAR TIE IAW SRM & DWG.
Back to Boeing 737-3H4