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 SWAA2012082907122Retaining Clip · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FORWARD RETAINING CLIP LOOSE. SECURED CLIP PER SRM.SDR SWAA2012082807102Lens · brokenR1 DOOR EXIT EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED LENS ASSY PER M/M.SDR SWAA2012100108163Skin · corrodedSKIN CORRODED BETWEEN BS 520 AND BS 540, BETWEEN STR 28L AND STR 28R. REPAIRED SKIN IAW EO AND EA.SDR SWAA2012092507972Guide · brokenLEFT WING NR 4 SLAT ANTI ICE SPRAY TUBE GUIDE BROKEN. REMOVED AND REPLACED NR 4 SLAT PER MM.SDR SWAA2012092507969Door · crackedFORWARD GALLEY DOOR FWD LOWER CORNER SKIN CRACKED. REMOVED AND REPLACED DOOR IAW AMM.SDR SWAA2012092107842Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 712, LBL 24.8. REPAIRED WEB PER ER AND EA.SDR SWAA2012091107516Fitting · crackedVERTICAL COMPRESSION BEAM CRACKED AT BS 727, RBL 45.5. REMOVED AND REPLACED FITTING IAW BOEING DWG AND SRM.SDR SWAA2012090607392Skin · corrodedSKIN CORRODED AT BS 947.5, STR 26L. REPAIRED SKIN IAW SRM.SDR SWAA2012090507381Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 727B, LBL 45.5. REMOVED AND REPLACED STIFFENER PER SRM AND DWG.SDR SWAA2012090507380Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 727B, RBL 45. REMOVED AND REPLACED STIFFENER PER DWG AND SRM.SDR SWAA2012082807103Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2012082707075Spindle · corrodedLEFT WING NR 1 SPINDLE CORRODED. REMOVED & REPLACED NR 1 SPINDLE ASSY PER MT.SDR SWAA2012082707027Sign · brokenFORWARD ENTRY EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER MM.SDR SWAA2012091807712Web · crackedWEB CRACKED BETWEEN BS 440 TO BS 460, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012082807101Light · out of adjustEEPLS OUT OF ADJUST AT ROW 8. ADJUSTED EEPLS PER MM.SDR SWAA2012082707074Skin · crackedSKIN CRACKED AT BS 500+9, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2012120310145Panel · crackedRIGHT WING UPPER SURFACE, AFT PYLON AREA, PANEL 58710R PLASTIC NUT PLATE STRIP CRACKED. REMOVED AND REPLACED RIGHT WING UPPER SURFACE PANEL 58710R NUT STRIP AS PER SRM. SEE SAM 326 FOR INDIVIDUALS STEP AND FUEL TANK ENTRY SAM 1045 AND PERFORMANCE WO# 13027 FSDR SWAA2012120310144Nut Plate · crackedRIGHT WING UPPER SURFACE, AFT PYLON AREA, PANEL 58710R PLASTIC NUT PLATE STRIP CRACKED. REPAIRED NUT PLATE STRIP PER EA 1-354-1480.SDR SWAA2012092407922Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092107871Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 837, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092107870Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727C+19, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092007805Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007804Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007803Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007802Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007801Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007800Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007799Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007798Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907775Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPARIED SKIN IAW EA.SDR SWAA2012091907774Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907773Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907772Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907771Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907770Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707690Stringer · crackedSTRINGER CRACKED BETWEEN BS 727D+10 TO BS 837, STR 5R. REPAIRED STRINGER IAW EA.SDR SWAA2012091707689Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707688Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707687Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707686Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707685Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707684Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707683Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707682Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707681Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707680Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707679Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707678Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWAARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091707663Slat · crackedRIGHT WING NR 6 SLAT LEADING EDGE SLAT CRACKED AT STA 447.75. REPAIRED NR 6 SLAT IAW SRM.SDR SWAA2012091407618Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.
Back to Boeing 737-3H4