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 SWAA2013072218417Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED BETWEEN BS 708-BS 712, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013062017449Pump · malfunctionedUPON INITIATING DESCENT NR 2 ENGINE COMPRESSOR STALLED. R & R MAIN ENGINE FUEL CONTROL & FUEL PUMP IAW M/M.SDR SWAA2013061817241Cover · unsecureL1 DOOR EMERGENCY EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSY PER M/M.SDR SWAA2013072418537Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18R. REPAIRED FRAME IAW EA.SDR SWAA2013071718307Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+1, STRINGER 28R. REPAIRED SKIN IAW SRM.SDR SWAA2013062517534Angle · crackedMAIN WHEEL WELL ANGLE CRACKED AT BS 727, LBL 14. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013061917390Stringer Clip · crackedSTRINGER CLIP CRACKED AT STA 727B, STR 8R. R & R CLIP IAW BAC DWG & SRM.SDR SWAA2013061817336Actuator · faultyDURING CLIMB LT MAIN GEAR RED LIGHT ILLUMINATED, CYCLED GEAR. R & R LT UPLOCK ACTUATOR IAW MM.SDR SWAA2013061817239Skin · delaminatedRT WING INBD FORE FLAP INBD LOWER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA2013062617642Angle · corrodedFRAME FAIL SAFE ANGLE CORRODED AT BS 767, BETWEEN STRINGER 25L - 25R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013061917367Battery · inoperativeLEFT AFT INTERIOR EMERGENCY EXIT BATTERY INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2013061817278Battery Pack · dischargedLEFT EMERGENCY EXIT LIGHTS INOP. R & R BATTERY PACK IAW MM.SDR SWAA2013061817240Lens · brokenL1 DOOR LOWER EGRESS LIGHT LENS BROKEN. R&R LENS PER MM.SDR SWAA2013061717170Cap · crackedRT WING NR 6 SLAT OTBD END CAP CRACKED. R & R END CAP IAW AMM.SDR SWAA2013061717169Cap · crackedLEFT WING NR 4 SLAT OTBD TAI DUCT END CAP CRACKED. R & R END CAP IAW AMM.SDR SWAA2013061717168Light · brokenFOUND FWD ENTRY EMERGENCY EXIT LIGHT BROKEN. R & R LIGHT ASSY IAW MM.SDR SWAA2013070517951Crease Beam · crackedCREASE BEAM CRACKED AT BS 178, STRINGER 17L. REPAIRED BEAM IAW EO.SDR SWAA2013070317895Web · crackedWEB CRACKED BETWEEN BS 332.1 - BS 344, STRINGER 17R. R&R WEB IAW SRM & DRAWINGSDR SWAA2013061917366Web · chafedBEADED WEB CHAFED BETWEEN BS 663 TO BS 675, BETWEEN RBL 12 TO RBL21. REPAIRED WEB IAW EA.SDR SWAA2013061717161Light · inoperativeLT CABIN EMERGENCY EXIT BULLNOSE LIGHTS INOPERATIVE BETWEEN ROW 12 TO ROW 17. RELAMPED IAW AMM.SDR SWAA2013061717160Battery Pack · dischargedLAV BULKHEAD EMERGENCY EXIT LIGHT INOP. R & R EMERGENCY LIGHT BATTERY PACK IAW AMM.SDR SWAA2013061717159Cover · out of positionR1 DOOR EMERGENCY EVAC SLIDE DEPLOY HANDLE COVER OUT OF POSITION. REPOSITIONED SLIDE COVER IAW MM.SDR SWAA2013061717148Web · crackedNOSE WHEEL WELL CRACKED BETWEEN PANELS 3103R AND 3105R, BS259.5, WL 192R. REPAIRED WEB IAW SRM.SDR SWAA2013062817733Skin · corrodedSKIN CORRODED BETWEEN BS 500A - BS 500B, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2013062517531Web · crackedWEB CRACKED BETWEEN BS 188 TO BS 196.5, STRINGER 17R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013061817287Channel · crackedSTRINGER SPLICE CHANNEL CRACKED STA 907, STR 4R. R & R CHANNEL IAW DWG.SDR SWAA2013061717188Light · inoperativeEXTERNAL EMERGENCY EXIT LIGHT AFT OF LAV INOP. R & R LIGHT IAW AMM.SDR SWAA2013061717184Sign · missingFORWARD ENTRY EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR SWAA2013061217123Charger · malfunctionedBUSSES WOULD NOT STAY POWERED BY APU OR GROUND POWER. BURNING SMELL FILLED COCKPIT. COULD SMELL 4 ROWS INTO CABIN. ALL T/R CB'S POPPED AND BATTERY CHARGER & NORMAL EQUIP COOLING FAN POPPED. R & R APU GENERATOR AND BATTERY CHARGER, APU TRANSFORMER, APU FIRE SDR SWAA2013062817732Stiffener · crackedFWD BULKHEAD STIFFENER CRACKED AT BS 727, BETWEEN LBL 38 - LBL 48. R&R STIFFENER IAW SRM & DRAWING.SDR SWAA2013062417500Slat · delaminatedRT WING NR 6 SLAT I/B EDGE DELAMINATED ON UPPER SURFACE. REPAIRED SLAT IAW SRM.SDR SWAA2013061817244Bracket · crackedFIRE BOTTLE MOUNTING BRACKET CRACKED BETWEEN BS 709 TO BS 727, LBL 48. R&R BRACKET IAW SRM AND DWG.SDR SWAA2013061217111Skin · crackedSKIN CRACKED AT BS 887 + 13, STR 10L. REPAIRED SKIN IAW EA.SDR SWAA2013061217091Lens · brokenR2 DOOR LOWER EMERGENCY EXIT SIGN LENS BROKEN. R & R LENS IAW MM.SDR SWAA2013061016930Actuator · shearedRIGHT WING NR 5 GROUND SPOILER INBD ACTUATOR ROD END SHEARED. R & R ACTUATOR IAW MM.SDR SWAA2013070417931Support Angle · crackedLT WING SUPPORT ANGLE CRACKED AT LEVEL WBL 191.00 AFT FAIRING. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013070217845Skin · crackedLT BS 807+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,9. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070217844Skin · crackedLT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,5,7. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070217843Skin · crackedLT BS 727A+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070217833Skin · crackedLT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,5,10. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070117777Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW EA.SDR SWAA2013062717670Skin · crackedLT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW SWA EA.SDR SWAA2013062717663Skin · crackedLT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4. REPAIRED SKIN IAW SWA EA.SDR SWAA2013062417487Skin · crackedLT BS 887+10 LOWER FORWARD SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013062417485Skin · crackedLT BS 787+10 LOWER FORWARD SKIN CUTOUT CRACKED AT HOLES 1,3,9. REPAIRED SKIN IAW SB.SDR SWAA2013062417470Skin · crackedLT BS 867+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013062417469Skin · crackedLT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,6. REPAIRED SKIN IAW SB.SDR SWAA2013062417468Skin · crackedLT BS 827+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013062417461Skin · crackedLT BS 767+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW SB.SDR SWAA2013061917417Skin · crackedSKIN CRACKED AT BS 727A+7, STR 10R. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4