Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2012060404591Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA2012053104482Tab · delaminatedRT ELEVATOR TAB DELAMINATED. REMOVED AND REPLACED TAB PER AMM.SDR SWAA2012053104496Skin · crackedFUSELAGE SKIN CRACKED AT BS 727C+3, STR 7R. REPAIRED SKIN PER SRM.SDR SWAA2012053004455Light · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED & REPLACED LIGHT ASSEMBLY IAW M/M.SDR SWAA2012061104791Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+18 BETWEEN STR 28L & STR 28R. REPAIRED SKIN IAW ER & EA.SDR SWAA2012061104833Skin · crackedSKIN CRACKED AT BS 767 +15.5, STR 23L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012052904430Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED & REPLACED BATTERY PACK PER AMM.SDR SWAA2012052904408Hinge Fitting · brokenLEFT I/B GROUND SPOILER O/B HINGE FITTING BROKEN. REMOVED AND REPLACED NR 4 GROUND SPOILER PER MM.SDR SWAA2012052304273Skin · crackedSKIN CRACKED AT BS 947, 3 FEET FOWARD OF OUTFLOW VALVE. REPAIRED SKIN PER SRM.SDR SWAA2012052304282Skin · crackedR2 DOOR FWD SKIN CRACKED AT UPPER HINGE CUTOUT LWR CORNER. REPAIRED SKIN PER SRM.SDR SWAA2012052304266Seal · out of positionAIR TURNBACK - CABIN ALT WARNING HORN DURING CLIMBOUT. REMOVED AND REPLACED SEAL PER MM.SDR SWAA2012051604059Battery Pack · dischargedEMERGENCY EXITS INOP. REPLACED BATTERY PACKS PER MT.SDR SWAA2012051504003Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2012051504002Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012051504001Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT AT CASE, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MT.SDR SWAA2012051403947Aileron · delaminatedRT AILERON AFT TIP DELAMINATED. REMOVED AND REPLACED AILERON ASSY PER AMM.SDR SWAA2012051403946Sign · missingLEFT EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER M/M.SDR SWAA2012051003869Gasper Fan · faultyDURING CRUISE FLT ATTENDANT CALLED AND REPORTED A STRONG ACRID SMELL STRONGEST NEAR ROW 3. NO ABNORMAL INDICATIONS NOTED. TURNED OFF GASPER FAN SMELL DISSIPATED (DISAPPEAR) ON APPROACH SMELL CAME BACK. NO VISABLE SMOKE. REMOVED AND REPLACED GASPER FAN PER MSDR SWAA2012051504010Skin · crackedSKIN CRACKED AT BS 927+7, STR 24L. REPAIRED SKIN PER EA.SDR SWAA2012051504009Skin · crackedSKIN CRACKED AT BS 927+5, STR 24L. REPAIRED SKIN PER EA.SDR SWAA2012051003866Spoiler · delaminatedLEFT WING NR 4 GROUND SPOILER DELAMINATED. REMOVED AND REPLACED NR 4 GROUND SPOILER PER MM.SDR SWAA2012051003865Wedge · delaminatedRIGHT WING NR 5 SLAT WEDGE O/B END DELAMINATED. REMOVED AND REPLACED NR 5 SLAT ASSEMBLY PER MM.SDR SWAA2012050403687Light · disconnectedL2 DOOR LOWER EMERGENCY LIGHT INOP. RECONNECTED LIGHT ASSY IAW MM.SDR SWAA2012050903824Web · crackedNOSE LANDING GEAR LEFT SIDE INTERNAL SKIN WEB CRACKED AT BS 259, WL 174. REPAIRED WEB IAW EA.SDR SWAA2012050403691Skin · crackedSKIN CRACKED AT BS 767, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA2012050303666Wire · brokenAFT CARGO EMERGENCY LIGHT WIRE BROKEN BETWEEN BS 747 TO BS 767, BETWEEN STR 23L TO STR 24L. REPAIRED WIRE IAW BSWPM & AMM.SDR SWAA2012120310147Panel · crackedCRACK ON BOTH SIDES OF FASTENER HOLE ON PYLON/WING PANEL AFT OF 58710R. REPLACED PANEL 5871 OR ON PYLON/WING RIGHT IAW SRM B737-500 51-40-05 AND DWG 65C27356.SDR SWAA2012050403688Light · inoperativeR2 DOOR LOWER EMERGENCY EXIT SIGN BULBS INOP. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012050703731Skin · crackedSKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050703730Skin · crackedSKIN CRACKED AT BS 772, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050303652Skin · crackedFUSELAGE SKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050303651Skin · crackedFUSELAGE SKIN CRACKED AT BS 772, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050103607Lens · missingRT EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 9. INSTALLED NEW LENS IAW M/M.SDR SWAA2012050103620Slat · delaminatedLT WING NR 2 SLAT UPPER OUTBOARD TRAILING EDGE DELAMINATED. REMOVED AND REPLACED NR 2 SLAT IAW MM.SDR SWAA2012043003584Skin · crackedSKIN CRACKED AT BS 426, STR 17R. REPAIRED SKIN PER EA.SDR SWAA2012042703490Cover · crackedR1 DOOR LOWER EMERGENCY EXIT LIGHT COVER CRACKED. REMOVED AND REPLACED COVER PER AMM.SDR SWAA2012043003583Flap · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA2012042703491Skin · crackedSKIN CRACKED AT BS 520, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA2012042403347Window · arcedDIVERSION -- L2 COCKPIT WINDOW ARCED. REMOVED AND REPLACED L2 COCKPIT WINDOW ASSY PER MM.SDR SWAA2012042303323Slide · low pressureR1 DOOR ESCAPE SLIDE PRESS INDICATION IN RED. REMOVED AND REPLACED R1 DOOR SLIDE ASSY PER MM.SDR SWAA2012041803221Frame · brokenFUSELAGE FRAME BROKEN AT BS 847, BETWEEN STRINGERS 17R AND 18R LOWER END IS BROKEN. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA2012042703523Skin · canningLOWER FUSELAGE SKIN OIL CANNING CONDITION BETWEEN BS 767 TO BS 807 +6, BETWEEN STR 19L TO STR 20L. REPAIRED SKIN IAW EA.SDR SWAA2012041203066Light · brokenL1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012041103014Strap · brokenFWD EMERGENCY FLASHLIGHT STRAP BROKEN. REMOVED AND REPLACED STRAP PER M/M.SDR SWAA2012042703517Skin · crackedSKIN CRACKED BETWEEN BS 747+16.5 TO BS 747+17.6, STR 20L. REPAIRED SKIN IAW EA.SDR SWAA2012041603166Structure · corrodedLT AFT INNER CHORD CORRODED AT BS 967, LBL 52 IAW SRM. REPAIRED CHORD IAW AMM.SDR SWAA2012050103619Skin · crackedSKIN CRACKED AT BS 380+5, STR 15L. REPAIR SKIN IAW SRM.SDR SWAA2012042503411Skin · crackedSKIN CRACKED AT BS 482B+16, STR 16R. REPAIRED SKIN IAW SRM.SDR SWAA2012042503383Skin · puncturedLT WING INBD FORE FLAP LOWER SURFACE PUNCTURED. REPAIRED FLAP PER SRM.SDR SWAA2012041903242Skin · delaminatedLEFT WING I/B FOREFLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.
Back to Boeing 737-5H4