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 SWAA2012101108450Spindle · crackedLEFT WING NR 1 O/B FLAP O/B SPINDLE CARRIAGE CRACKED. REMOVED AND REPLACED SPINDLE IAW AMM AND MT.SDR SWAA2012100308234Lens · missingLEFT OVERHEAD BULLNOSE LIGHT LENS MISSING AT ROW 17. INSTALLED LENS PER M/M.SDR SWAA2012100108134Lens · crackedR2 DOOR EMERGENCY LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012100108133Spindle · corrodedLEFT WING NR 1 FLAP CARRIAGE SPINDLE CORRODED, FAILED INSPECTION. REMOVED AND REPLACED NR 1 O/B FLAP SPINDLE CARRIAGE ASSY PER M/M.SDR SWAA2012100108128Slat · delaminatedRIGHT WING NR 5 SLAT DELAMINATED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2012100108100Cover · detachedFORWARD EMERGENCY EXIT LIGHT COVER FELL OFF DURING LANDING. REMOVED AND REPLACED BASE ASSY PER AMM.SDR SWAA2012100308226Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STR 6R. REMOVED AND REPLACED CLIP PER SRM & DWG.SDR SWAA2012100108168Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+14, STR 1L. REPAIRED SKIN PER EA.SDR SWAA2012100108167Channel · crackedLEFT WING CHANNEL CRACKED AT WBL 191.0. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA2012100108108Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2012100108099Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA2012100108092Lens · brokenL1 DOOR EMERGENCY EXIT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER AMM.SDR SWAA2012100108088Outflow Valve · failedAIR TURNBACK -- DURING CRUISE CABIN PRESSURE WAS LOST. NO INDICATION OTHER THAN TAKEOFF WARNING HORN. REMOVED AND REPLACED OUTFLOW VALVE PER MM.SDR SWAA2012101008391Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008390Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008389Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008372Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008368Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008367Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008366Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100508301Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100508300Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100508299Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100108154Lug · brokenLEFT WING NR 4 GROUND SPOILER LUG BROKEN. REMOVED AND REPLACED NR 4 GROUND SPOILER PER AMM.SDR SWAA2012100108098Pressure Panel · crackedMAIN WHEEL WELL CEILING BEADED WEB CRACKED AT BS 664, LBL 32. REPAIRED WEB PER SRM.SDR SWAA2012102308755Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101808615Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101708589Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101608560Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101508536Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101208478Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101208477Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101208466Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012101208465Connector · brokenLEFT EMERGENCY EXIT DOOR SIDEWALL LIGHT CONNECTOR BROKEN. REPAIRED CONNECTOR PER SWPM AND MM.SDR SWAA2012101108422Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008371Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008370Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008369Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008365Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008364Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008363Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008362Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008361Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008360Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012101008359Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & TC.SDR SWAA2012100508297Web · crackedWEB CRACKED BETWEEN BS 927 TO BS 947.5, LBL 17.2. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012100108107Skin · crackedFUSELAGE SKIN CRACKED AT BS 767+8, STR 4R. REPAIRED SKIN PER EA.SDR SWAA2012092708070Window · arcedL2 WINDOW ARCED AT CRUISE. REMOVED AND REPLACED L2 WINDOW PER MM.SDR SWAA2012092708069Fuse · blownEMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED FUSE IAW MM.SDR SWAA2012092708062Lens · looseRIGHT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT PER MM.
Back to Boeing 737-3H4